USER_COMPANY_ID 
ColumnName  USER_COMPANY_ID 
Definition 
Name: Domain. Description: Alias for database schema that will be updated.
 

S_IMPORT_CD 
ColumnName  S_IMPORT_CD 
Definition 
Name: Import Type. Description: Indicates the type of transaction. The valid values are: A - Add. C - Change. D - Delete. B - Batch 
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: A time/date stamp that indicates when the record was originally inserted into table.
 

EXTERNAL_USER 
ColumnName  EXTERNAL_USER 
Definition 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 

UDT10_ID 
ColumnName  UDT10_ID 
Definition 
Name: UDT10 ID. Description: Unique user-provided identifier ID for this user-defined table record.
 

UDT10_NAME 
ColumnName  UDT10_NAME 
Definition 
Name: UDT10 Name. Description: Description of user-defined ID.
 

OT_FL 
ColumnName  OT_FL 
Definition 
Name: Overtime Flag. Description: Logical as to whether this UDT10 ID is for overtime.
 

OT_UDT10_ID 
ColumnName  OT_UDT10_ID 
Definition 
Name: Overtime UDT01 ID. Description: The UDT10 ID to which overtime premiums are charged.
 

COST_FL 
ColumnName  COST_FL 
Definition 
Name: Cost Only Flag. Description: Logical as to whether this UDT10 ID is for "cost only" hours.
 

TEXT_FL 
ColumnName  TEXT_FL 
Definition 
Name: Comment Required Flag. Description: Logical as to whether comments are required when this UDT10 ID is used.
 

MISC_LABOR_CD 
ColumnName  MISC_LABOR_CD 
Definition 
Name: Miscellaneous Labor Code. Description: Miscellaneous field contains codes used to feed the labor distribution file during export.
 

MISC_PAYROLL_CD 
ColumnName  MISC_PAYROLL_CD 
Definition 
Name: Miscellaneous Payroll Code. Description: Miscellaneous field contains codes used to feed the payroll file during export.
 

PAYROLL_EARNINGS_CD 
ColumnName  PAYROLL_EARNINGS_CD 
Definition 
Name: Payroll Earnings Code. Description: Earnings code for this UDT10 ID.
 

S_PAYROLL_MAP_CD 
ColumnName  S_PAYROLL_MAP_CD 
Definition 
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 
ColumnName  ACTIVE_FL 
Definition 
Name: Active Flag. Description: Logical as to whether this UDT10 ID is active.
 

RATE1_FACTOR_AMT 
ColumnName  RATE1_FACTOR_AMT 
Definition 
Name: User Defined Rate 1 Factor. Description: Multiply factor for user-defined 1 amount.
 

RATE1_FIXED_AMT 
ColumnName  RATE1_FIXED_AMT 
Definition 
Name: User Defined Rate 1 Fixed Amount. Description: Fixed lump sum amount for user-defined 1 amount.
 

S_RATE1_CALC_CD 
ColumnName  S_RATE1_CALC_CD 
Definition 
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 
ColumnName  RATE2_FACTOR_AMT 
Definition 
Name: User Defined Rate 2 Factor. Description: Multiply factor for user-defined 2 amount.
 

RATE2_FIXED_AMT 
ColumnName  RATE2_FIXED_AMT 
Definition 
Name: User Defined Rate 2 Fixed Amount. Description: Fixed lump sum amount for user-defined 2 amount.
 

S_RATE2_CALC_CD 
ColumnName  S_RATE2_CALC_CD 
Definition 
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 
ColumnName  RECAST_LABOR_UDT10_ID 
Definition 
Name: Labor Recast UDT10 ID. Description: The UDT10 code used for recasting labor exports.
 

RECAST_PAYROLL_UDT10_ID 
ColumnName  RECAST_PAYROLL_UDT10_ID 
Definition 
Name: Payroll Recast UDT10 ID. Description: The UDT10 code used for recasting payroll exports.
 

PRORATE_FL 
ColumnName  PRORATE_FL 
Definition 
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 
ColumnName  FUTURE_FL 
Definition 
Name: Future Flag. Description: Logical as to whether UDT10s assigned to this type can be charged into the future.