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

UDT02 Columns 
ColumnName  Domain  Datatype  NULL  Definition 
UDT02_ID(PK)    VARCHAR2(50)  NO 
Name: UDT02 ID. Description: Unique user-provided identifier ID for this 02 user-defined table record.
 
UDT02_NAME    VARCHAR2(120)  NO 
Name: UDT02 Name. Description: Description of user-defined ID.
 
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.
 
UDT01_LINK_FL    VARCHAR2(1)  NO 
Name: Link12 Flag. Description: Logical as to whether UDT01 codes are to be linked with this UDT02 item.
 
UDT07_LINK_FL    VARCHAR2(1)  NO 
Name: Link27 Flag. Description: Logical as to whether UDT07 codes are to be linked with this UDT02 item.
 
UDT09_LINK_FL    VARCHAR2(1)  NO 
Name: Link29 Flag. Description: Logical as to whether UDT09 codes are to be linked with this UDT02 item.
 
UDT07_REQUIRED_FL    VARCHAR2(1)  NO 
Name: UDT07 Required Flag. Description: Logical as to whether a UDT07 code is required for this UDT02 item.
 
START_DT    DATE  YES 
Name: Start Date. Description: Start date for this UDT02 ID.
 
END_DT    DATE  YES 
Name: End Date. Description: End date for this UDT02 ID.
 
ACTIVE_FL    VARCHAR2(1)  NO 
Name: Active Flag. Description: Logical as to whether this UDT02 ID is active.
 
ALLOW_CHARGE_FL    VARCHAR2(1)  NO 
Name: Allow Charge Flag. Description: Logical as to whether this UDT02 ID allows charges.
 
INACTIVE_DT    DATE  YES 
Name: Inactive Date. Description: The date the UDT02 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 By. 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: UDT02 Abbreviation ID. Description: Third user-defined date field.
 
LINE_APPROVE_FL    VARCHAR2(1)  NO 
Name: Charge Approve Flag. Description: Logical as to whether this UDT02 is line approved.
 
CP_COMPANY_CD(FK)    VARCHAR2(10)  NO 
Name: Costpoint Company . Description: Costpoint Company Code
 
UDT02_ABBRV_ID    VARCHAR2(20)  YES 
Name: UDT02 Abbreviation ID. Description: Abbreviation for UDT02.
 
S_TYPE_CD    VARCHAR2(1)  NO 
Name: Use Option. Description: Indicates which system can have this UDT02. Valid options are: T – Time. E – Expense. B – Both
 
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.
 

UDT02 Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0004  PrimaryKey  UDT02_ID 

UDT02 Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
CP_COMPANY  Non-Identifying  One To Zero or More  F00134      CP_COMPANY_CD  NO  NO 
EMPL  Non-Identifying  Zero or One to Zero or More  F00403      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  F00051        NO  NO 
LINK27  Identifying  One To Zero or More  F00056        NO  NO 
LINK29  Identifying  One To Zero or More  F00058        NO  NO 
UDT02_SPVSR  Identifying  One To Zero or More  F00109        NO  NO