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

UDT01 Columns 
ColumnName  Domain  Datatype  NULL  Definition 
UDT01_ID(PK)    VARCHAR2(50)  NO 
Name: UDT01 ID. Description: Unique user-provided identifier ID for this 01 user-defined table record.
 
UDT01_NAME    VARCHAR2(120)  NO 
Name: UDT01 Name. Description: Description of user-defined ID.
 
UDT01_TYPE_CD(FK)    VARCHAR2(10)  NO 
Name: UDT01 Type. Description: The type code for this UDT01.
 
CODE1_CD    VARCHAR2(20)  YES 
Name: User Defined Code 1. Description: First user-defined alpha field.
 
CODE2_CD    VARCHAR2(20)  YES 
Name: User Defined Code 2. Description: Second user-defined alpha field.
 
CODE3_CD    VARCHAR2(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    VARCHAR2(1)  NO 
Name: Link12 Flag. Description: Logical as to whether UDT02 codes are to be linked with this UDT01 item.
 
UDT07_LINK_FL    VARCHAR2(1)  NO 
Name: Link17 Flag. Description: Logical as to whether UDT07 codes are to be linked with this UDT01 item.
 
UDT09_LINK_FL    VARCHAR2(1)  NO 
Name: Link19 Flag. Description: Logical as to whether UDT09 codes are to be linked with this UDT01 item.
 
UDT07_REQUIRED_FL    VARCHAR2(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    VARCHAR2(1)  NO 
Name: Active Flag. Description: Logical as to whether this UDT01 ID is active.
 
ALLOW_CHARGE_FL    VARCHAR2(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    VARCHAR2(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    VARCHAR2(20)  NO 
Name: Modified Byt. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMBER(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    VARCHAR2(1)  NO 
Name: Charge Approve Flag. Description: Logical as to whether this UDT01 is line approved.
 
UDT01_ABBRV_ID    VARCHAR2(20)  YES 
Name: UDT01 Abbreviation ID. Description: Abbreviation for UDT01.
 
INTERIM_FL    VARCHAR2(1)  NO 
Name: Interim Flag. Description: Logical as to whether this UDT is interim or not.
 
INTERIM_EMPL_ID(FK)    VARCHAR2(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 Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0003  PrimaryKey  UDT01_ID 

UDT01 Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
UDT01_TYPE  Non-Identifying  One To Zero or More  F00002      UDT01_TYPE_CD  NO  NO 
EMPL  Non-Identifying  Zero or One to Zero or More  F00402      INTERIM_EMPL_ID  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
LINK12  Identifying  One To Zero or More  F00050        NO  NO 
LINK19  Identifying  One To Zero or More  F00052        NO  NO 
LINK17  Identifying  One To Zero or More  F00054        NO  NO 
TS_LINE  Non-Identifying  One To Zero or More  F00065        NO  NO 
UDT01_SPVSR  Identifying  One To Zero or More  F00106        NO  NO 
EXP_RPT_EXPENSE_CHARGE  Non-Identifying  One To Zero or More  F00235        NO  NO 
LINK110  Identifying  One To Zero or More  F00260        NO  NO