Table slot9.WORLD.TSTA.DS_IBR_FIELD_SYSTEMS
This table defines the Record Layouts. Defines the format, layout of the Attachment File. This should mirror each EXTERNAL_SYSTEM_CODES.CODE(s) Record Layout Work Sheet
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
IBR_FIELD_ID number 0
DS_IBR_FIELDS.IBR_FIELD_ID DSIBRFLDSY_DSIBRFLD_FK R
FK to DS_IBR_FIELDS PK
EXTSYS_CODE varchar2 10
EXTERNAL_SYSTEM_CODES.CODE DSIBRFLDSY_EXSYS_FK R
External System Code
CREATOR_ID varchar2 100  √  null Creator ID of this row
CREATOR_DATE date 7  √  null Creator Date of this row
UPDATOR_ID varchar2 100  √  null Updator ID of this row
UPDATOR_DATE date 7  √  null Updator Date of this row
DATA_TYPE varchar2 106  √  null Data Type of the data field (NUMBER, VARCHAR2, DATE)
DATA_ELEMENT_NUM varchar2 30  √  null Data Element Number
DATA_ELEMENT_PROMPT varchar2 50  √  null Data Element Prompt utilized by the UI when labeling fields for Edit
NAV_ORDER number 0  √  null Navigation Order of the fields to match the order of the fields in the layout
LENGTH number 0  √  null Length of the field
FORMAT_MASK varchar2 40  √  null Format Mask of the Field when in DATE data_type. COuld be used in the future for other data types but currently just for DATE
EDITABLE varchar2 1  √  null Is the Field Editable on the Edit Screen
UCR_COMMENT varchar2 200  √  null UCR Comments field
IBR_SEGMENT varchar2 100
DS_IBR_SEGMENTS.IBR_SEGMENT DSIBRFLDSY_DSIBRSEG_FK R
FK to DS_IBR SEGMENTS - Segment the Field exists
COLUMN_NAME varchar2 2000  √  null Column Name, Function Name, etc. of the Select Statement of where the data field exists. Usually from the DS_NIBR Staging Area but can be from anywhere in the system
FROM_CLAUSE varchar2 2000  √  null From Clause Statement of the Select Statement of where the data field exists
WHERE_CLAUSE varchar2 2000  √  null Where Clause Statement of the Select Statement of where the data field exists
IBR_FIELD_SYSTEM_ID number 0
DS_IBR_EXTSYS_FIELDS_VW.IBR_FIELD_SYSTEM_ID Implied Constraint R
DS_IBR_FIELD_VALUES.IBR_FIELD_SYSTEM_ID DSIBRFLDV_DSIBRFLDSY_FK R
DS_IBR_FIELD_VALUES_FAST_VW.IBR_FIELD_SYSTEM_ID Implied Constraint R
DS_IBR_FIELD_VALUES_VW.IBR_FIELD_SYSTEM_ID Implied Constraint R
DS_IBR_MODIFY_VALUES_VW.IBR_FIELD_SYSTEM_ID Implied Constraint R
Sequence generated Primary Key of this table
FIELD_ID number 0  √  null
USER_FIELDS.FIELD_ID DSIBRFLDSY_USRSCRN_F_FK R
FK to USER_FIELDS - Custom Field for an agency used throughout the application
FIELD_NUMBER varchar2 100  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
EDITABLE IN ('Y', 'N') CK_DSIBRFLDSY_EDITABLE
"EXTSYS_CODE" IS NOT NULL DSIBRFLDSY_EXTSYSCODE_NN
"IBR_FIELD_ID" IS NOT NULL DSIBRFLDSY_FIELD_ID_NN
"IBR_SEGMENT" IS NOT NULL DSIBRFLDSY_IBR_SEGMENT_NN

Indexes:
Column(s) Type Sort Constraint Name
IBR_FIELD_SYSTEM_ID Primary key Asc DSIBRFLDSY_PK
DATA_ELEMENT_NUM Performance Asc DSIBRFLDSY_DE_NUM_I
IBR_FIELD_ID Performance Asc DSIBRFLDSY_DSIBRFLD_FK_I
IBR_SEGMENT Performance Asc DSIBRFLDSY_DSIBRSEG_FK_I
EXTSYS_CODE Performance Asc DSIBRFLDSY_EXSYS_FK_I
IBR_FIELD_ID + IBR_SEGMENT + EXTSYS_CODE Performance Asc/Asc/Asc DSIBRFLDSY_FLDIDSEGESC_I
FIELD_ID Performance Asc DSIBRFLDSY_USRSCRN_F_FK_I
FIELD_NUMBER Performance Asc DSIBRFLDSY_USRSCRN_FN_FK_I

Close relationships  within of separation: