EMPL_ID 
ColumnName  EMPL_ID 
Definition 
Name: Employee ID. Description: Employee ID identifier.
 

TS_SCHEDULE_CD 
ColumnName  TS_SCHEDULE_CD 
Definition 
Name: Timesheet Schedule. Description: Timesheet frequency identifier.
 

YEAR_NO_CD 
ColumnName  YEAR_NO_CD 
Definition 
 

PERIOD_NO_CD 
ColumnName  PERIOD_NO_CD 
Definition 
Name: Period Number. Description: Period number for timesheet frequency.
 

LINE_NO 
ColumnName  LINE_NO 
Definition 
Name: Line Number. Description: The timesheet line number to which this timesheet cell belongs.
 

HRS_DT 
ColumnName  HRS_DT 
Definition 
Name: Hours Date. Description: The column date for this cell.
 

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

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

REVISION_NO 
ColumnName  REVISION_NO 
Definition 
Name: Revision Number. Description: The current revision number of this cell.
 

CORRECT_FL 
ColumnName  CORRECT_FL 
Definition 
Name: Correct Flag. Description: Logical as to whether this cell is a correcting entry.
 

S_CELL_STATUS_CD 
ColumnName  S_CELL_STATUS_CD 
Definition 
 

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

SHORT_CELL_TEXT 
ColumnName  SHORT_CELL_TEXT 
Definition 
Name: Comments. Description: User-provided notes about the timesheet cell.
 

MODIFIED_BY 
ColumnName  MODIFIED_BY 
Definition 
Name: Modified By. Description: The User ID of the person who last modified this record.
 

ROWVERSION 
ColumnName  ROWVERSION 
Definition 
Name: Row Version. Description: The number of times this record has been updated.
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: Date and time the record was last modified. 
 

BATCH_ID 
ColumnName  BATCH_ID 
Definition 
Name: Batch ID. Description: The ID that was assigned to the row during export
 

APPROVED_HRS 
ColumnName  APPROVED_HRS 
Definition 
Name: Approved Hours. Description: The approved labor hours for this cell.
 

RATE1_RATE 
ColumnName  RATE1_RATE 
Definition 
Name: User Defined Rate 1. Description: User-defined rate 1.
 

RATE2_RATE 
ColumnName  RATE2_RATE 
Definition 
Name: User Defined Rate 2. Description: User-defined rate 2. 
 

S_RATE1_CD 
ColumnName  S_RATE1_CD 
Definition 
Name: User Defined Rate 1 Source. Description: The source of the rate 1 used on this cell. The valid values are: N- None. C – Charge Tree. W – Wage Determination. E – Employee History. M – Manual Entry. 1 – Link 17/Wildcard. 2 – Link 27/Wildcard. 7 – UDT07
 

S_RATE2_CD 
ColumnName  S_RATE2_CD 
Definition 
Name: User Defined Rate 2 Source. Description: The source of the rate 2 used on this cell. The valid values are: N- None. C – Charge Tree. E – Employee History. M – Manual Entry. 1 – Link 17/Wildcard. 2 – Link 27/Wildcard. 7 – UDT07. Logical as to whether entry is a reversing entry.
 

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

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

ENTERED_RATE1_AMT 
ColumnName  ENTERED_RATE1_AMT 
Definition 
Name: Entered User Rate 1 Amount. Description: User-defined amount 1 based on Entered Hours.
 

ENTERED_RATE2_AMT 
ColumnName  ENTERED_RATE2_AMT 
Definition 
Name: Entered User Rate 2 Amount. Description: User-defined amount 2 based on Entered Hours
 

APPROVED_RATE1_AMT 
ColumnName  APPROVED_RATE1_AMT 
Definition 
Name: Approved User Rate 1 Amount. Description: User-defined amount 1 based on Approved Hours.
 

APPROVED_RATE2_AMT 
ColumnName  APPROVED_RATE2_AMT 
Definition 
Name: Approved User Rate 2 Amount. Description: User-defined amount 2 based on Approved Hours
 

PRORATED_RATE1_AMT 
ColumnName  PRORATED_RATE1_AMT 
Definition 
Name: Prorated User Rate 1 Amount. Description: User-defined amount 1 based on Prorated Hours.
 

PRORATED_RATE2_AMT 
ColumnName  PRORATED_RATE2_AMT 
Definition 
Name: Prorated User Rate 2 Amount. Description: User-defined amount 2 based on Prorated Hours
 

EXPORTED_RATE1_AMT 
ColumnName  EXPORTED_RATE1_AMT 
Definition 
Name: Exported User Rate 1 Amount. Description: User-defined amount 1 based on Exported Hours.
 

EXPORTED_RATE2_AMT 
ColumnName  EXPORTED_RATE2_AMT 
Definition 
Name: Exported User Rate 2 Amount. Description: User-defined amount 2 based on Exported Hours
 

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