Table slot9.WORLD.TSTA.ORG_DESCRIPTOR_CODES
This table defines the valid descriptors for organizations (referred to as agencies) in the application (e.g. State, District)
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ORG_DESCRIPTOR_CODE varchar2 30
ORG_DESCRIPTOR_DESC varchar2 20
ORG_DESCRIPTOR_DISPLAY_CODE varchar2 100
ORG_DESCRIPTOR_NOTES varchar2 1000  √  null
CREATOR_ID varchar2 100  √  null USER ID for the initial record creation.
CREATOR_DATE date 7  √  null Date record was created.
UPDATOR_ID varchar2 100  √  null USER ID for the last record update.
UPDATOR_DATE date 7  √  null Date record was last updated.
CAN_BE_PARENT varchar2 1 'Y'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
CAN_BE_PARENT IN ('Y', 'N') CK_ORGSTRODC_CAN_BE_PARENT
"CAN_BE_PARENT" IS NOT NULL ORGSTRODC_CAN_BE_PARENT_NN
"ORG_DESCRIPTOR_CODE" IS NOT NULL ORGSTRODC_DESCRIP_CD_NN
"ORG_DESCRIPTOR_DESC" IS NOT NULL ORGSTRODC_DESCRIP_DESC_NN
"ORG_DESCRIPTOR_DISPLAY_CODE" IS NOT NULL ORGSTRODC_DESCRIP_DSPCD_NN

Indexes:
Column(s) Type Sort Constraint Name
ORG_DESCRIPTOR_CODE Primary key Asc ORGSTRODC_PK