ColumnName |
Domain |
Datatype |
NULL |
Definition |
UDT10_ID |
|
VARCHAR2(20) |
NO |
Name: UDT10 ID. Description: Unique user-provided identifier ID for this 10 user-defined table record. |
UDT10_NAME |
|
VARCHAR2(30) |
NO |
Name: UDT10 Name. Description: Description of user-defined ID. |
OT_FL |
|
VARCHAR2(1) |
NO |
Name: Overtime Flag. Description: Logical as to whether this UDT10 ID is for overtime. |
OT_UDT10_ID |
|
VARCHAR2(20) |
YES |
Name: Overtime UDT01 ID. Description: The UDT10 ID to which overtime premiums are charged. |
COST_FL |
|
VARCHAR2(1) |
NO |
Name: Cost Only Flag. Description: Logical as to whether this UDT10 ID is for "cost only" hours. |
TEXT_FL |
|
VARCHAR2(1) |
NO |
Name: Comment Required Flag. Description: Logical as to whether comments are required when this UDT10 ID is used. |
MISC_LABOR_CD |
|
VARCHAR2(30) |
YES |
Name: Miscellaneous Labor Code. Description: Miscellaneous field contains codes used to feed the labor distribution file during export. |
MISC_PAYROLL_CD |
|
VARCHAR2(30) |
YES |
Name: Miscellaneous Payroll Code. Description: Miscellaneous field contains codes used to feed the payroll file during export. |
PAYROLL_EARNINGS_CD |
|
VARCHAR2(30) |
YES |
Name: Payroll Earnings Code. Description: Earnings code for this UDT10 ID. |
S_PAYROLL_MAP_CD |
|
VARCHAR2(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 |
|
VARCHAR2(1) |
NO |
Name: Active Flag. Description: Logical as to whether this UDT10 ID is active. |
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. |
RATE1_FACTOR_AMT |
|
NUMBER(15, 5) |
NO |
Name: User Defined Rate 1 Calculation Method. Description: Multiply factor for user-defined 1 amount. |
RATE1_FIXED_AMT |
|
NUMBER(15, 5) |
NO |
Name: User Defined Rate 1 Fixed Amount. Description: Fixed lump sum amount for user-defined 1 amount. |
S_RATE1_CALC_CD |
|
VARCHAR2(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 |
|
NUMBER(15, 5) |
NO |
Name: User Defined Rate 2 Factor. Description: Multiply factor for user-defined 2 amount. |
RATE2_FIXED_AMT |
|
NUMBER(15, 5) |
NO |
Name: User Defined Rate 2 Fixed Amount. Description: Fixed lump sum amount for user-defined 2 amount. |
S_RATE2_CALC_CD |
|
VARCHAR2(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 |
|
VARCHAR2(20) |
YES |
Name: Labor Recast UDT10 ID. Description: The UDT10 code used for recasting labor exports. |
RECAST_PAYROLL_UDT10_ID |
|
VARCHAR2(20) |
YES |
Name: Payroll Recast UDT10 ID. Description: The UDT10 code used for recasting payroll exports. |
PRORATE_FL |
|
VARCHAR2(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 |
|
VARCHAR2(1) |
NO |
Name: Future Flag. Description: Logical as to whether UDT10s assigned to this type can be charged into the future. |