Table slot9.WORLD.TSTA.USER_SCREEN_HEADER_FIELDS
This table defines the fields from the associated module (e.g. Incident, Field Arrest) to include when printing a custom form

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
FIELD_ID varchar2 50
FIELD_DATA_ELEMENTS.FIELD_ID USHF_FDE_FK R
ROW_ID number 0
USER_SCREEN_HEADER_ROWS.ROW_ID USHF_USHR_FK R
DISPLAY_INDEX number 0
WIDTH number 0
LABEL varchar2 100
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DISPLAY_INDEX" IS NOT NULL USHF_DISP_IND_NN
"FIELD_ID" IS NOT NULL USHF_FIELD_ID_NN
"LABEL" IS NOT NULL USHF_LABEL_NN
"ROW_ID" IS NOT NULL USHF_ROW_ID_NN
"WIDTH" IS NOT NULL USHF_WIDTH_NN

Indexes:
Column(s) Type Sort Constraint Name
ROW_ID + FIELD_ID Primary key Asc/Asc USHF_PK
FIELD_ID Performance Asc USHF_FDE_FK_I
ROW_ID Performance Asc USHF_USHR_FK_I

Close relationships  within of separation: