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 sequential line number of the line.
 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SHORT_LINE_TEXT 
ColumnName  SHORT_LINE_TEXT 
Definition 
Name: Line Comments. Description: User-provided notes about the line.
 

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

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

HRS 
ColumnName  HRS 
Definition 
Name: Hours. Description: The labor hours for this cell.
 

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

SHORT_CELL_TEXT 
ColumnName  SHORT_CELL_TEXT 
Definition 
Name: Cell Comments. Description: User-provided notes about the timesheet 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. 
 

REVERSAL_FL 
ColumnName  REVERSAL_FL 
Definition 
Name: . 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 Rate 1 Amount. Description: User-defined amount 1.
 

RATE2_AMT 
ColumnName  RATE2_AMT 
Definition 
Name: User Rate 2 Amount. Description: User-defined amount 2.
 

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

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. 
 

ORIGINAL_LINE_NO 
ColumnName  ORIGINAL_LINE_NO 
Definition 
Name: Original Line Number. Description: The sequential line number of the line.
 

CODE1_CD 
ColumnName  CODE1_CD 
Definition 
Name: Employee User Defined Code 1. Description: First user-defined alphanumeric field from the EMPL table.
 

CODE2_CD 
ColumnName  CODE2_CD 
Definition 
Name: Employee User Defined Code 2. Description: Second user-defined alphanumeric field from the EMPL table.
 

CODE3_CD 
ColumnName  CODE3_CD 
Definition 
Name: Employee User Defined Code 3. Description: Third user-defined alphanumeric field from the EMPL table.
 

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

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

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

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

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