DFLT_REG_TS
The Timesheet Line Defaults (DFLT_REG_TS) table stores timesheet default values for the employee for Talent Management staging.
Costpoint Destination Table | Costpoint Destination Field | Costpoint Field Description | Required (Y/N) | Talent Management/Default Source |
---|---|---|---|---|
DFLT_REG_TS | ACCT_ID | Account ID | N | CP Job Template |
DFLT_REG_TS | CHG_ORG_ID | Charge organization ID | N | req_department_code |
DFLT_REG_TS | EMPL_ID | Employee ID | Y (if auto ID generation is not enabled | user_employee_id |
DFLT_REG_TS | GENL_LAB_CAT_CD | General labor category (GLC) | Y ( if the Allow Edit of Timesheet Line GLC checkbox is not selected in the Configure Labor Settings screen.) | CP Job Template, Hardcoded |
DFLT_REG_TS | LAB_LOC_CD | Labor location | N | CP Job Template |
DFLT_REG_TS | MODIFIED_BY | ID of the user who last created or modified row | N | N/A |
DFLT_REG_TS | PAY_TYPE | Pay type | N | CP Job Template, CP Company Default |
DFLT_REG_TS | PROJ_ID | Project | N | CP Job Template |
DFLT_REG_TS | REF_STRUC_1_ID | Reference number 1 | N | CP Job Template |
DFLT_REG_TS | REF_STRUC_2_ID | Reference number 2 | N | CP Job Template |
DFLT_REG_TS | ROWVERSION | System-assigned number to handle row concurrency | N | N/A |
DFLT_REG_TS | TIME_STAMP | Date and time of row creation or last modification | N | N/A |
DFLT_REG_TS | WORK_COMP_CD | Workers compensation code | Y (if Require Default Workers' Compensation Code is selected in the Login Company's Configure Labor Settings screen) | CP Job Template; CP Company Default |
Parent Topic: Talent Management to Costpoint Data Mapping