Table slot9.WORLD.TSTA.PSEUDO_ORG_DESCRIPTORS
TABLE CONTAINING ORGANIZATIONAL MAPPING INFORMATION AND ESTABLISHING THE HIERARCHICAL RELATIONSHIP OF ENTRIES IN THE AGENCY_CODES TABLE AND THE AFFILIATES TABLE - AKA: POD
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
POD_ID number 38
AFFILIATE_CODES.POD_ID ORGSTRAC_ORGSTRPOD_FK R
ASSIGNMENT_ORGS.POD_ID ORGSTRAO_ORGSTRPOD_FK R
JS_USER_ASSIGNMENT_VW.POD_ID Implied Constraint R
POD_AFFILIATES.POD_ID ORGSTRPA_ORGSTRPOD_FK R
RESTRICTION_LISTS.POD_ID ORGSTRRL_ORGSTRPOD_FK R
TOKEN VALUE AUTO-INCREMENT - REPLACES REC_ID
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE ORGSTRPOD_AGNCY_CD_FK R
REFERENCE TO THE AGENCY_CODE IN THE AGENCY_CODES TABLE
AGENCY_DESCRIPTOR varchar2 255 WHAT THIS ORGANIZATIONAL UNIT IS CALLED (E.G. DISTRICT, AGENCY, ETC.)
AGENCY_PARENT number 38 APOINTS TO THE POD_ID VALUE IN THIS TABLE
IS_REFERENCE_AGENCY varchar2 1 Y OR N VALUE INDICATES IF THIS IS THE MASTER ORG UNIT IN THE STRUCTURE
IS_ROOT varchar2 1 Y OR N VALUE INDICATES THAT THIS IS THE STRUCTURES ROOT ELEMENT, MUST BE ONE AND ONLY ONE Y VALUE FOR EACH STRUCTURE
STRUCTURE_LEVEL number 38  √  null INDICATES WHERE THE ELEMENT IS SITUATED IN THE STRUCTURE
STRUCTURE_ID varchar2 30 IDENTIFIES THE STRUCTURE
AFFILIATE varchar2 1 INDICATES THAT THE ORG-UNIT IS AN AFFILIATED ORG UNIT AND NOT STRUCTURAL
IS_RESTRICTED varchar2 1 INDICATES THAT ORG-UNIT ACCESS IS RESTRICTED TO THE RESTRICTION LIST
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.
DISPLAY_FIELD varchar2 255  √  null
IS_GEOGRAPHIC varchar2 1 'Y' Determines if the row will appear in an Agency of Occurrence LOV.
RESTRICT_SELF_ASSIGN_FLAG varchar2 1  √  null
RESTRICT_CASE_SHARE_FLAG varchar2 1  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
AFFILIATE IN ( 'Y' , 'N' ) CK_ORGSTRPOD_AFFILIATE
IS_GEOGRAPHIC IN ( 'Y' , 'N' ) CK_ORGSTRPOD_IS_GEOGRAPHIC
IS_REFERENCE_AGENCY IN ( 'Y' , 'N' ) CK_ORGSTRPOD_IS_REF_AGENCY
IS_RESTRICTED IN ( 'Y' , 'N' ) CK_ORGSTRPOD_IS_RESTRICTED
IS_ROOT IN ( 'Y' , 'N' ) CK_ORGSTRPOD_IS_ROOT
RESTRICT_CASE_SHARE_FLAG IN ( 'Y' , 'N' ) CK_ORGSTRPOD_REST_CS_FLG
RESTRICT_SELF_ASSIGN_FLAG IN ( 'Y' , 'N' ) CK_ORGSTRPOD_REST_SLF_FLG
"AFFILIATE" IS NOT NULL ORGSTRPOD_AFFILIATE_NN
"AGENCY_CODE" IS NOT NULL ORGSTRPOD_AGENCY_CODE_NN
"AGENCY_DESCRIPTOR" IS NOT NULL ORGSTRPOD_AGENCY_DESC_NN
"AGENCY_PARENT" IS NOT NULL ORGSTRPOD_AGENCY_PARENT_NN
"IS_GEOGRAPHIC" IS NOT NULL ORGSTRPOD_IS_GEOGRAPHIC_NN
"IS_REFERENCE_AGENCY" IS NOT NULL ORGSTRPOD_IS_REF_AGNCY_NN
"IS_RESTRICTED" IS NOT NULL ORGSTRPOD_IS_RESTRICTED_NN
"IS_ROOT" IS NOT NULL ORGSTRPOD_IS_ROOT_NN
"POD_ID" IS NOT NULL ORGSTRPOD_POD_ID_NN
"STRUCTURE_ID" IS NOT NULL ORGSTRPOD_STRUCTURE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
POD_ID Primary key Asc ORGSTRPOD_PK
AGENCY_CODE Performance Asc ORGSTRPOD_AGNCY_CD_FK_I
IS_ROOT Performance Asc ORGSTRPOD_IS_ROOT_I
STRUCTURE_ID Performance Asc ORGSTRPOD_STRUCTID_I

Close relationships  within of separation: