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

UDT10 Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
UDT10_ID(PK)    VARCHAR(20)  NO 
Name: UDT10 ID. Description: Unique user-provided identifier ID for this 10 user-defined table record.
 
UDT10_NAME    VARCHAR(30)  NO 
Name: UDT10 Name. Description: Description of user-defined ID.
 
OT_FL    VARCHAR(1)  NO 
Name: Overtime Flag. Description: Logical as to whether this UDT10 ID is for overtime.
 
OT_UDT10_ID(FK)    VARCHAR(20)  YES 
Name: Overtime UDT01 ID. Description: The UDT10 ID to which overtime premiums are charged.
 
COST_FL    VARCHAR(1)  NO 
Name: Cost Only Flag. Description: Logical as to whether this UDT10 ID is for "cost only" hours.
 
TEXT_FL    VARCHAR(1)  NO 
Name: Comment Required Flag. Description: Logical as to whether comments are required when this UDT10 ID is used.
 
MISC_LABOR_CD    VARCHAR(30)  YES 
Name: Miscellaneous Labor Code. Description: Miscellaneous field contains codes used to feed the labor distribution file during export.
 
MISC_PAYROLL_CD    VARCHAR(30)  YES 
Name: Miscellaneous Payroll Code. Description: Miscellaneous field contains codes used to feed the payroll file during export.
 
PAYROLL_EARNINGS_CD    VARCHAR(30)  YES 
Name: Payroll Earnings Code. Description: Earnings code for this UDT10 ID.
 
S_PAYROLL_MAP_CD    VARCHAR(10)  YES 
Name: Earnings Mapping Option. Description: How the Earnings code will be mapped during export. The valid options are as follows: N - None. R - Regular. O - Overtime. 3 - Earnings 3. 4 - Earnings 4. 5 - Earnings 5. H3 - Hours 3. H4 - Hours 4
 
ACTIVE_FL    VARCHAR(1)  NO 
Name: Active Flag. Description: Logical as to whether this UDT10 ID is active.
 
MODIFIED_BY    VARCHAR(20)  NO 
Name: Modified By. 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.
 
RATE1_FACTOR_AMT    NUMERIC(15, 5)  NO 
Name: User Defined Rate 1 Calculation Method. Description: Multiply factor for user-defined 1 amount.
 
RATE1_FIXED_AMT    NUMERIC(15, 5)  NO 
Name: User Defined Rate 1 Fixed Amount. Description: Fixed lump sum amount for user-defined 1 amount.
 
S_RATE1_CALC_CD    VARCHAR(5)  NO 
Name: User Defined Rate 1 Calculation Method. Description: The method by which user-defined rate 1 amount is calculated. The valid values are as follows: CALC1 - (Hours x Rate x Factor). + Amount. CALC2 - (Hours x Rate x Factor). + (Hours x Amount). CALC3 - (Hours x Rate x Factor). + (Hours x Amount x Factor) 
 
RATE2_FACTOR_AMT    NUMERIC(15, 5)  NO 
Name: User Defined Rate 2 Factor. Description: Multiply factor for user-defined 2 amount.
 
RATE2_FIXED_AMT    NUMERIC(15, 5)  NO 
Name: User Defined Rate 2 Fixed Amount. Description: Fixed lump sum amount for user-defined 2 amount.
 
S_RATE2_CALC_CD    VARCHAR(5)  NO 
Name: User Defined Rate 2 Calculation Method. Description: The method by which user-defined rate 2 amount is calculated. The valid values are as follows: CALC1 - (Hours x Rate x Factor). + Amount. CALC2 - (Hours x Rate x Factor). + (Hours x Amount). CALC3 - (Hours x Rate x Factor). + (Hours x Amount x Factor) 
 
RECAST_LABOR_UDT10_ID(FK)    VARCHAR(20)  YES 
Name: Labor Recast UDT10 ID. Description: The UDT10 code used for recasting labor exports.
 
RECAST_PAYROLL_UDT10_ID(FK)    VARCHAR(20)  YES 
Name: Payroll Recast UDT10 ID. Description: The UDT10 code used for recasting payroll exports.
 
PRORATE_FL    VARCHAR(1)  NO 
Name: Prorate Flag. Description: Logical as to whether timesheet hours assigned to this UDT10 should be included in the hour’s pro-ration logic.
 
FUTURE_FL    VARCHAR(1)  NO 
Name: Future Flag. Description: Logical as to whether UDT10s assigned to this type can be charged into the future.
 

UDT10 Keys 
Key Name  Key Type  Keys 
RI_F00003  Inversion Entry  OT_UDT10_ID 
RI_F00148  Inversion Entry  RECAST_PAYROLL_UDT10_ID 
RI_F00147  Inversion Entry  RECAST_LABOR_UDT10_ID 
PI_0012  PrimaryKey  UDT10_ID 

UDT10 Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
UDT10  Non-Identifying  Zero or One to Zero or More        OT_UDT10_ID  NO 
UDT10  Non-Identifying  Zero or One to Zero or More        RECAST_LABOR_UDT10_ID  NO 
UDT10  Non-Identifying  Zero or One to Zero or More        RECAST_PAYROLL_UDT10_ID  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
UDT10  Non-Identifying  One To Zero or More          NO 
CLASS_UDT10  Identifying  One To Zero or More          NO 
TS_LINE  Non-Identifying  One To Zero or More          NO 
UDT10  Non-Identifying  One To Zero or More          NO 
UDT10  Non-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