Table slot9.WORLD.TSTA.AFFILIATE_CODES
This table allows for agency affiliates to be defined. This table is not currently used in the application
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
AFFILIATE_CODE varchar2 30
IJIS_USER_PROFILE_AFFILIATES.AFFILIATE_CODE ORGSTRIUPA_ORGSTRAC_FK R
POD_AFFILIATES.AFFILIATE_CODE ORGSTRPA_ORGSTRAC_FK R
RESTRICTION_LISTS.AFFILIATE_CODE ORGSTRRL_ORGSTRAC_FK R
Up to 30 alphanumeric characters used to uniquely identify the AFFILIATE.
AFFILIATE_DESCRIPTOR varchar2 20 The UI label that is used to idenfy the field in varous pages throughout the Application UI (e.g. WorkGroup, Division, etc.)
AFFILIATE_DESC varchar2 255  √  null Up to 255 alphanumeric characters to provide a long description of the AFFILIATE table entry.
POD_ID number 38  √  null
PSEUDO_ORG_DESCRIPTORS.POD_ID ORGSTRAC_ORGSTRPOD_FK R
Foreign key to the PSEUDO_ORG_DESCRIPTOR table to join the AFFILIATE to the POD and establish the AFFILIATE entity position and ownership in the hierarchy.
IS_RESTRICTED varchar2 1  √  null Y or N value indicating whether or not the AFFILIATE is restricted for access and viewing. Signals a check agains the RESTRICTIONS_LIST table
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.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
IS_RESTRICTED IN ( 'Y' , 'N' ) CK_ORGSTRAC_IS_RESTRICTED
"AFFILIATE_CODE" IS NOT NULL ORGSTRAC_AFFILIATE_CODE_NN
"AFFILIATE_DESCRIPTOR" IS NOT NULL ORGSTRAC_AFFILIATE_DESCRIP_NN

Indexes:
Column(s) Type Sort Constraint Name
AFFILIATE_CODE Primary key Asc ORGSTRAC_PK
POD_ID Performance Asc ORGSTRAC_ORGSTRPOD_FK_I

Close relationships  within of separation: