...
Main WBS → Customer
WBS Level1 → Project
WBS Level2 → Labor Category
WBS assignment → Project Assignment at the employee level.
Timesheet Extract Definition
Specification
Attribute | Description |
Format | CostPoint extract to timesheet module |
What to include | All fully approved, not already extracted timesheets. Extracted by reporting timesheet period for each user. |
Level of detail | Summarized Extract. Extract by expense report and unique account string |
Process | Timesheet extracted from DATABASICS to CostPoint; it will be executed by Administrators once they are ready to close the reporting period in DATABASICS. |
File Name | DBTIME<datetimestamp>.txt |
Time Specification
For Adjustments: apply the original logic for the adjusted line(s), and reverse the original posting (post as a negative value).
Seq | Column Name | Type | Lgth | DB DESC |
10 | Timesheet Date | Char | 10 | Last Day of the reporting period YYYY-MM-DD |
20 | Employee ID | Char | 12 | EMPLY_ID from profile (also the Vendor_ID) |
30 | Timesheet Type Code | Char | 2 | Initial posting hard Code: "R"; if adjustment: C (correction). From a process point net should be zero but there is no way to validate adjustments made to ensure this is the case. |
40 | Working State | Char | 2 | Blank |
50 | Fiscal Year | Char | 6 | Blank |
60 | Period | Numeric | 2 | Blank |
70 | Subperiod | Numeric | 2 | Blank |
80 | Correcting Ref Date | Char | 10 | Last Day of the reporting period, only supplied on Adjustments: YYYY-MM-DD |
90 | Pay Type | Char | 3 | R - OT - OS1, mapped to time code DESC (note: Leave codes are all mapped to R) |
100 | General Labor Category | Char | 6 | Blank |
110 | Timesheet Line Type Code | Char | 1 | Hard Code: "A" |
120 | Labor Cost Amount | Numeric | 15 | Hard Code: “000000000000000” |
130 | Hours | Numeric | 10 | hrs reported, will be negative for the originally posted hours in an adjustment |
140 | Workers' Comp Code | Char | 6 | Blank |
150 | Labor Location Code | Char | 6 | Blank (cannot be removed) |
160 | Organization ID | Char | 20 | DEPT_CODE - from employee profile |
170 | Account ID | Char | 15 | Blank |
180 | Project ID | Char | 30 | WBS Level 1 code as selected by the user (only lowest level will form part of the load), for Indirect Time codes: as associated with Time Code selected by user |
190 | Project Labor Category | Char | 6 | WBSL2 as selected by user - assignment from Workforce file |
200 | Reference Number 1 | Char | 20 | Blank |
210 | Reference Number 2 | Char | 20 | Blank |
220 | Organization Abbreviation | Char | 6 | Blank |
230 | Project Abbreviation | Char | 6 | Blank |
240 | Sequence Number | Numeric | 1 | Blank |
250 | Effective Billing Date | Char | 10 | Blank |
260 | Project-Account Abbrev. | Char | 6 | Blank |
270 | Multi-State Code | Char | 2 | Blank |
280 | Reference Sequence Num | Char | 1 | Blank |
290 | Timesheet Line Date | Char | 10 | Blank |
290 | Notes | Char | 254 | Blank |