BATCH_ID |
ColumnName | BATCH_ID |
Definition | Name: Batch ID. Description: The ID of the batch of which this record is a member. From screen input. |
TIMESHEET_DT |
ColumnName | TIMESHEET_DT |
Definition | Name: Timesheet Date. Description: The column date for this cell. From screen input. |
EMPL_ID |
ColumnName | EMPL_ID |
Definition | Name: Employee ID. Description: Employee ID identifier. It defaults from the TS table. |
TS_SCHEDULE_CD |
ColumnName | TS_SCHEDULE_CD |
Definition | Name: Timesheet Schedule. Description: Timesheet frequency identifier. It defaults from the TS table. |
YEAR_NO_CD |
ColumnName | YEAR_NO_CD |
Definition |
PERIOD_NO_CD |
ColumnName | PERIOD_NO_CD |
Definition | Name: Timesheet Period. Description: Period number for timesheet frequency. It defaults from the TS table. |
LINE_NO |
ColumnName | LINE_NO |
Definition | Name: Timesheet Line. Description: The timesheet line number to which this timesheet cell belongs. It defaults from the TS_LINE table. |
HRS_DT |
ColumnName | HRS_DT |
Definition | Name: Hours Date. Description: The column date for this cell. It defaults from the TS_CELL table. |
REVISION_NO |
ColumnName | REVISION_NO |
Definition | Name: Revision Number. Description: The current revision of the timesheet. It defaults 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. It defaults from the TS_LINE 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. It defaults from the TS_LINE table. |
LINE_DESC |
ColumnName | LINE_DESC |
Definition | Name: Charge 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 you selected a charge from a charge tree, the charge code will display in this column. It defaults from the TS_LINE table. |
CHARGE_BRANCH_CD |
ColumnName | CHARGE_BRANCH_CD |
Definition | Name: Charge Branch. Description: If you selected a charge from a charge tree, this column displays the charge branch code from the TS_LINE table. |
CHARGE_CD |
ColumnName | CHARGE_CD |
Definition | Name: Charge No. Description: If you selected a charge from a charge tree, this column displays 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. It defaults from the TS_LINE table. |
UDT02_ID |
ColumnName | UDT02_ID |
Definition | Name: UDT02 ID. Description: The UDT02 identifier for the line. It defaults from the TS_LINE table. |
UDT03_ID |
ColumnName | UDT03_ID |
Definition | Name: UDT03 ID. Description: The UDT03 identifier for the line. It defaults from the TS_LINE table. |
UDT04_ID |
ColumnName | UDT04_ID |
Definition | Name: UDT04 ID. Description: The UDT04 identifier for the line. It defaults from the TS_LINE table. |
UDT05_ID |
ColumnName | UDT05_ID |
Definition | Name: UDT05 ID. Description: The UDT05 identifier for the line. It defaults from the TS_LINE table. |
UDT06_ID |
ColumnName | UDT06_ID |
Definition | Name: UDT06 ID. Description: The UDT06 identifier for the line. It defaults from the TS_LINE table. |
UDT07_ID |
ColumnName | UDT07_ID |
Definition | Name: UDT07 ID. Description: The UDT07 identifier for the line. It defaults from the TS_LINE table. |
UDT08_ID |
ColumnName | UDT08_ID |
Definition | Name: UDT08 ID. Description: The UDT08 identifier for the line. It defaults from the TS_LINE table. |
UDT09_ID |
ColumnName | UDT09_ID |
Definition | Name: UDT09 ID. Description: The UDT09 identifier for the line. It defaults from the TS_LINE table. |
UDT10_ID |
ColumnName | UDT10_ID |
Definition | Name: UDT10 ID. Description: The UDT10 identifier for the line. It defaults from the TS_LINE table. |
ETC_HRS |
ColumnName | ETC_HRS |
Definition | Name: Estimate to Complete Hours. Description: The estimate-to-complete hours for this employee. It defaults from the TS_LINE table. |
BILLABLE_FL |
ColumnName | BILLABLE_FL |
Definition | Name: Billable Flag. Description: Logical as to whether the hours are billable. It defaults from the TS_LINE table. |
HRS |
ColumnName | HRS |
Definition | Name: Hours. Description: The exported labor hours for this cell. This value defaults from the TS_CELL table and is calculated as ENTERED_HRS minus EXPORTED_HRS |
CORRECT_FL |
ColumnName | CORRECT_FL |
Definition | Name: Correction Flag. Description: Logical as to whether this cell is a correcting entry. This value defaults from the TS_CELL table. |
ENTERED_DTT |
ColumnName | ENTERED_DTT |
Definition | Name: Entered Date/Time. Description: The date and time when the hours were entered. This value defaults 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. This value defaults 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. This value defaults 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. This value defaults from the UDT10 table. |
SHORT_HEADER_TEXT |
ColumnName | SHORT_HEADER_TEXT |
Definition | Name: Timesheet Comments. Description: Notes about the entire timesheet. It defaults from the TS table - first 254 characters. |
SHORT_LINE_TEXT |
ColumnName | SHORT_LINE_TEXT |
Definition | Name: Timesheet Line Comments. Description: User-provided notes about the line. It defaults from the TS_LINE table - first 254 characters. |
SHORT_CELL_TEXT |
ColumnName | SHORT_CELL_TEXT |
Definition | Name: Timesheet Cell Comments. Description: User-provided notes about the timesheet cell. It defaults from the TS_CELL table - first 254 characters. |
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: Rate 1 Amount. Description: The prorated amount for rate1 minus the exported amount for rate 1. |
RATE2_AMT |
ColumnName | RATE2_AMT |
Definition | Name: Rate 2 Amount. Description: The prorated amount for rate2 minus the exported amount for rate 2. |
UDT11_ID |
ColumnName | UDT11_ID |
Definition | Name: UDT11 ID. Description: The UDT11 identifier for the line. It defaults from the TS_LINE table. |
UDT12_ID |
ColumnName | UDT12_ID |
Definition | Name: UDT12 ID. Description: The UDT12 identifier for the line. It defaults from the TS_LINE table. |
UDT13_ID |
ColumnName | UDT13_ID |
Definition | Name: UDT13 ID. Description: The UDT13 identifier for the line. It defaults from the TS_LINE table. |
UDT14_ID |
ColumnName | UDT14_ID |
Definition | Name: UDT14 ID. Description: The UDT14 identifier for the line. It defaults from the TS_LINE table. |
UDT15_ID |
ColumnName | UDT15_ID |
Definition | Name: UDT15 ID. Description: The UDT15 identifier for the line. It defaults from the TS_LINE table. |
SEQ_NO |
ColumnName | SEQ_NO |
Definition | Name: Sequence Number. Description: Synthetic key to support recasts |
RATE1_RATE |
ColumnName | RATE1_RATE |
Definition | Name: User Defined Rate 1. Description: User-defined rate 1. |
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. |
TS_UDT10_ID |
ColumnName | TS_UDT10_ID |
Definition | Name: UDT10 used for recast Description: UDT10 ID that started the recasting process. |
S_STATUS_CD |
ColumnName | S_STATUS_CD |
Definition | Name: Status code for export Description: Status code used in export of Labor records. |
MODIFIED_BY |
ColumnName | MODIFIED_BY |
Definition |
TIME_STAMP |
ColumnName | TIME_STAMP |
Definition |