UDT01 
Default Table Name  UDT01 
Definition 
 Name: UDT01 Master.     Description: This table is the master table of UDT01 IDs.
 

UDT01 Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
UDT01_ID(PK)    VARCHAR(50)  NO 
Name: UDT01 ID. Description: Unique user-provided identifier ID for this 01 user-defined table record.
 
UDT01_NAME    VARCHAR(120)  NO 
Name: UDT01 Name. Description: Description of user-defined ID.
 
UDT01_TYPE_CD(FK)    VARCHAR(10)  NO 
Name: UDT01 Type. Description: The type code for this UDT01.
 
CODE1_CD    VARCHAR(20)  YES 
Name: User Defined Code 1. Description: First user-defined alpha field.
 
CODE2_CD    VARCHAR(20)  YES 
Name: User Defined Code 2. Description: Second user-defined alpha field.
 
CODE3_CD    VARCHAR(20)  YES 
Name: User Defined Code 3. Description: Third user-defined alpha field.
 
DATE1_DT    DATE  YES 
Name: User Defined Date 1 . Description: First user-defined date field.
 
DATE2_DT    DATE  YES 
Name: User Defined  Date 2. Description: Second user-defined date field
 
UDT02_LINK_FL    VARCHAR(1)  NO 
Name: Link12 Flag. Description: Logical as to whether UDT02 codes are to be linked with this UDT01 item.
 
UDT07_LINK_FL    VARCHAR(1)  NO 
Name: Link17 Flag. Description: Logical as to whether UDT07 codes are to be linked with this UDT01 item.
 
UDT09_LINK_FL    VARCHAR(1)  NO 
Name: Link19 Flag. Description: Logical as to whether UDT09 codes are to be linked with this UDT01 item.
 
UDT07_REQUIRED_FL    VARCHAR(1)  NO 
Name: UDT07 Required Flag. Description: Logical as to whether a UDT07 code is required for this UDT01 item.
 
START_DT    DATE  YES 
Name: Start Date. Description: Start date for this UDT01 ID.
 
END_DT    DATE  YES 
Name: End Date. Description: End date for this UDT01 ID.
 
ACTIVE_FL    VARCHAR(1)  NO 
Name: Active Flag. Description: Logical as to whether this UDT01 ID is active.
 
ALLOW_CHARGE_FL    VARCHAR(1)  NO 
Name: Allow Charges Flag. Description: Logical as to whether this UDT01 ID allows charges.
 
INACTIVE_DT    DATE  YES 
Name: Inactive Date. Description: The date the UDT01 ID became inactive.
 
S_DATE_EDIT_CD    VARCHAR(1)  NO 
Name: Date Edit. Description: The type of edit that will be performed on start and end dates. The valid options are: H - Hard edit  . S - Soft edit . N- No Edit
 
MODIFIED_BY    VARCHAR(20)  NO 
Name: Modified Byt. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMERIC(10, 0)  NO 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
DATE3_DT    DATE  YES 
Name: User Defined Date 3. Description: Third user-defined date field
 
LINE_APPROVE_FL    VARCHAR(1)  NO 
Name: Charge Approve Flag. Description: Logical as to whether this UDT01 is line approved.
 
UDT01_ABBRV_ID    VARCHAR(20)  YES 
Name: UDT01 Abbreviation ID. Description: Abbreviation for UDT01.
 
INTERIM_FL    VARCHAR(1)  NO 
Name: Interim Flag. Description: Logical as to whether this UDT is interim or not.
 
INTERIM_EMPL_ID(FK)    VARCHAR(20)  YES 
Name: Interim Employee ID. Description: The employee who created the interim charge.
 
INTERIM_DTT    DATE  YES 
Name: Interim Date/Time. Description: The date and time the interim charge was created.
 

UDT01 Keys 
Key Name  Key Type  Keys 
RI_F00402  Inversion Entry  INTERIM_EMPL_ID 
SI_0069  Inversion Entry  UDT01_ID, UDT01_NAME, ACTIVE_FL, ALLOW_CHARGE_FL, UDT01_ABBRV_ID 
PI_0003  PrimaryKey  UDT01_ID 
RI_F00002  Inversion Entry  UDT01_TYPE_CD 

UDT01 Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
UDT01_TYPE  Non-Identifying  One To Zero or More        UDT01_TYPE_CD  NO 
EMPL  Non-Identifying  Zero or One to Zero or More        INTERIM_EMPL_ID  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
LINK12  Identifying  One To Zero or More          NO 
LINK19  Identifying  One To Zero or More          NO 
LINK17  Identifying  One To Zero or More          NO 
TS_LINE  Non-Identifying  One To Zero or More          NO 
UDT01_SPVSR  Identifying  One To Zero or More          NO 
EXP_RPT_EXPENSE_CHARGE  Non-Identifying  One To Zero or More          NO 
LINK110  Identifying  One To Zero or More          NO