BATCH_ID 
ColumnName  BATCH_ID 
Definition 
Name: Batch ID. Description: The ID of the batch of which this record is a member. The Batch ID defaults from user screen entry during the export process.
 

TIMESHEET_DT 
ColumnName  TIMESHEET_DT 
Definition 
Name: Timesheet Date. Description: The column date for this cell. The batch ID defaults from user screen entry during the export process.
 

EMPL_ID 
ColumnName  EMPL_ID 
Definition 
Name: Employee ID. Description: Employee ID identifier from the TS table.
 

TS_SCHEDULE_CD 
ColumnName  TS_SCHEDULE_CD 
Definition 
Name: Timesheet Schedule. Description: Employee ID identifier from the TS table.
 

YEAR_NO_CD 
ColumnName  YEAR_NO_CD 
Definition 
Name: Year. Description: Employee ID identifier from the TS table.
 

PERIOD_NO_CD 
ColumnName  PERIOD_NO_CD 
Definition 
Name: Period Number. Description: Employee ID identifier from the TS table.
 

LINE_NO 
ColumnName  LINE_NO 
Definition 
Name: Line Number. Description: Employee ID identifier from the TS_LINE table. 
 

HRS_DT 
ColumnName  HRS_DT 
Definition 
Name: Hours Date. Description: Employee ID identifier from the TS table.
 

REVISION_NO 
ColumnName  REVISION_NO 
Definition 
Name: Revision Number. Description: The current revision of the timesheet from the TS table. 
 

CLASS_CD 
ColumnName  CLASS_CD 
Definition 
Name: Timesheet Class. Description: The employee class for the employee at the time of this timesheet. From the TS table.
 

WORK_SCHEDULE_CD 
ColumnName  WORK_SCHEDULE_CD 
Definition 
Name: Work Schedule. Description: The work schedule for the employee at the time of this timesheet. From the TS table.
 

LINE_DESC 
ColumnName  LINE_DESC 
Definition 
Name: Line Description. Description: Description of the charge on the line from the TS_LINE table. 
 

CHARGE_TREE_CD 
ColumnName  CHARGE_TREE_CD 
Definition 
Name: Charge Tree. Description: If charge was selected from a charge tree, this column contains the charge tree code from the TS_LINE table
 

CHARGE_BRANCH_CD 
ColumnName  CHARGE_BRANCH_CD 
Definition 
Name: Charge Branch. Description: If charge was selected from a charge tree, this column contains the charge branch code from the TS_LINE table.
 

CHARGE_CD 
ColumnName  CHARGE_CD 
Definition 
Name: Charge. Description: If charge was selected from a charge tree, this column contains the charge code for the tree/branch from the TS_LINE table.
 

UDT01_ID 
ColumnName  UDT01_ID 
Definition 
Name: UDT01 ID. Description: The UDT01 identifier for the line from the TS_LINE table.
 

UDT02_ID 
ColumnName  UDT02_ID 
Definition 
Name: UDT02 ID. Description: The UDT02 identifier for the line from the TS_LINE table.
 

UDT03_ID 
ColumnName  UDT03_ID 
Definition 
Name: UDT03 ID. Description: The UDT03 identifier for the line from the TS_LINE table.
 

UDT04_ID 
ColumnName  UDT04_ID 
Definition 
Name: UDT04 ID. Description: The UDT04 identifier for the line from the TS_LINE table.
 

UDT05_ID 
ColumnName  UDT05_ID 
Definition 
Name: UDT05 ID. Description: The UDT05 identifier for the line from the TS_LINE table.
 

UDT06_ID 
ColumnName  UDT06_ID 
Definition 
Name: UDT06 ID. Description: The UDT06 identifier for the line from the TS_LINE table.
 

UDT07_ID 
ColumnName  UDT07_ID 
Definition 
Name: UDT07 ID. Description: The UDT07 identifier for the line from the TS_LINE table.
 

UDT08_ID 
ColumnName  UDT08_ID 
Definition 
Name: UDT08 ID. Description: The UDT08 identifier for the line from the TS_LINE table.
 

UDT09_ID 
ColumnName  UDT09_ID 
Definition 
Name: UDT09 ID. Description: The UDT09 identifier for the line from the TS_LINE table.
 

UDT10_ID 
ColumnName  UDT10_ID 
Definition 
Name: UDT10 ID. Description: The UDT10 identifier for the line from the TS_LINE table.
 

ETC_HRS 
ColumnName  ETC_HRS 
Definition 
Name: ETC Hours. Description: The estimate-to-complete hours for this employee from the TS_LINE table.
 

BILLABLE_FL 
ColumnName  BILLABLE_FL 
Definition 
Name: Billable Flag. Description: Logical as to whether the hours are billable. From the TS_LINE table.
 

EXPORTED_HRS 
ColumnName  EXPORTED_HRS 
Definition 
Name: Exported Hours. Description: The exported labor hours for this cell from the TS_CELL table.
 

ENTERED_HRS 
ColumnName  ENTERED_HRS 
Definition 
Name: Entered Hours. Description: The entered labor hours for this cell from the TS_CELL table.
 

ENTERED_DTT 
ColumnName  ENTERED_DTT 
Definition 
Name: Date/Time Entered. Description: The date and time the hours were entered from the TS_CELL table.
 

CORRECT_FL 
ColumnName  CORRECT_FL 
Definition 
Name: Correct Flag. Description: From the TS_CELL table.
 

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

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

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 from the UDT10 table.
 

PAYROLL_ID 
ColumnName  PAYROLL_ID 
Definition 
Name: Payroll ID. Description: The payroll ID for the employee from the EMPL table.
 

PAYROLL_EMPL_ID 
ColumnName  PAYROLL_EMPL_ID 
Definition 
Name: Payroll Employee ID. Description: The employees Employee ID for payroll from the EMPL table.
 

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 from the UDT10 table.
 

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

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. From the UDT10 table.
 

LAST_NAME 
ColumnName  LAST_NAME 
Definition 
Name: Employee Last Name. Description: From the EMPL table.
 

FIRST_NAME 
ColumnName  FIRST_NAME 
Definition 
Name: Employee First Name. Description: From the EMPL table.
 

INITIAL_NAME 
ColumnName  INITIAL_NAME 
Definition 
Name: Employee Middle Initial. Description: From the EMPL table.
 

PAYROLL_EXPORT_FL 
ColumnName  PAYROLL_EXPORT_FL 
Definition 
Name: Payroll Export Flag. Description: From the CLASS table.
 

LABOR_EXPORT_FL 
ColumnName  LABOR_EXPORT_FL 
Definition 
Name: Labor Export Flag. Description: From the CLASS table.
 

SHORT_HEADER_TEXT 
ColumnName  SHORT_HEADER_TEXT 
Definition 
Name: Timesheet Notes. Description: Notes about the entire timesheet from the TS table.
 

SHORT_LINE_TEXT 
ColumnName  SHORT_LINE_TEXT 
Definition 
Name: Line Comment. Description: User-provided notes about the line from the TS_LINE table.
 

SHORT_CELL_TEXT 
ColumnName  SHORT_CELL_TEXT 
Definition 
Name: Cell Comment. Description: User-provided notes about the CELL from the TS_CELL table.
 

EMPL_CP_COMPANY_CD 
ColumnName  EMPL_CP_COMPANY_CD 
Definition 
Name: Employee Costpoint Company. Description: Costpoint Company Code for Employee.
 

UDT06_CP_COMPANY_CD 
ColumnName  UDT06_CP_COMPANY_CD 
Definition 
Name: UDT06 Costpoint Company. Description: Costpoint Company Code for UDT06 field.
 

UDT07_CP_COMPANY_CD 
ColumnName  UDT07_CP_COMPANY_CD 
Definition 
Name: UDT07 Costpoint Company. Description: Costpoint Company Code for UDT07 field.
 

REVERSAL_FL 
ColumnName  REVERSAL_FL 
Definition 
Name: Reversal Flag. Description: Logical as to whether entry is a reversing entry.
 

S_CP_TS_TYPE_CD 
ColumnName  S_CP_TS_TYPE_CD 
Definition 
Name: Costpoint Timesheet Type. Description: The Costpoint Timesheet Type. The valid values are: R – Regular. C – Correcting. N – Reversal. D - Replacement
 

RATE1_AMT 
ColumnName  RATE1_AMT 
Definition 
Name: User Defined Rate 1 Amount. Description: The prorated amount for rate1 minus the exported amount for rate 1.
 

RATE2_AMT 
ColumnName  RATE2_AMT 
Definition 
Name: User Defined Rate 2 Amount. Description: The prorated amount for rate2 minus the exported amount for rate 2.
 

PRORATED_HRS 
ColumnName  PRORATED_HRS 
Definition 
Name: Prorated Hours. Description: The number of hours after proration.
 

CODE1_CD 
ColumnName  CODE1_CD 
Definition 
Name: Employee User Defined Code 1. Description: The first user-defined code for the employee.
 

CODE2_CD 
ColumnName  CODE2_CD 
Definition 
Name: Employee User Defined Code 2. Description: The second user-defined code for the employee.
 

CODE3_CD 
ColumnName  CODE3_CD 
Definition 
Name: Employee User Defined Code 3. Description: The third user-defined code for the employee.
 

UDT11_ID 
ColumnName  UDT11_ID 
Definition 
Name: UDT11 ID. Description: The UDT11 identifier for the line from the TS_LINE table.
 

UDT12_ID 
ColumnName  UDT12_ID 
Definition 
Name: UDT12 ID. Description: The UDT12 identifier for the line from the TS_LINE table.
 

UDT13_ID 
ColumnName  UDT13_ID 
Definition 
Name: UDT13 ID. Description: The UDT13 identifier for the line from the TS_LINE table.
 

UDT14_ID 
ColumnName  UDT14_ID 
Definition 
Name: UDT14 ID. Description: The UDT14 identifier for the line from the TS_LINE table.
 

UDT15_ID 
ColumnName  UDT15_ID 
Definition 
Name: UDT15 ID. Description: The UDT15 identifier for the line from the TS_LINE table.
 

RATE1_RATE 
ColumnName  RATE1_RATE 
Definition 
 

CP_TS_COMPLETE_FL 
ColumnName  CP_TS_COMPLETE_FL 
Definition 
Name: Costpoint TS Complete Flag. Description: Logical as to whether this timesheet had an approved status when exported.
 

CP_TS_INPROCESS_FL 
ColumnName  CP_TS_INPROCESS_FL 
Definition 
Name: Costpoint TS In-process Flag. Description: Logical as to whether this timesheet hour record was an in process export.