EXPORT_LABOR 
Default Table Name  EXPORT_LABOR 
Definition 
 Name: Export Labor Distribution Entries .     Description: This table contains data staged to exported timesheet entries for labor distribution.
 

EXPORT_LABOR Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
BATCH_ID(PK)    VARCHAR(10)  NO 
Name: Batch ID. Description: The ID of the batch of which this record is a member. From screen input.
 
TIMESHEET_DT(PK)    DATE  NO 
Name: Timesheet Date. Description: The column date for this cell. From screen input.
 
EMPL_ID(PK)    VARCHAR(20)  NO 
Name: Employee ID. Description: Employee ID identifier. It defaults from the TS table.
 
TS_SCHEDULE_CD(PK)    VARCHAR(10)  NO 
Name: Timesheet Schedule. Description: Timesheet frequency identifier. It defaults from the TS table.
 
YEAR_NO_CD(PK)    VARCHAR(4)  NO 
 
PERIOD_NO_CD(PK)    VARCHAR(3)  NO 
Name: Timesheet Period. Description: Period number for timesheet frequency. It defaults from the TS table.
 
LINE_NO(PK)    NUMERIC(10, 0)  NO 
Name: Timesheet Line. Description: The timesheet line number to which this timesheet cell belongs. It defaults from the TS_LINE table.
 
HRS_DT(PK)    DATE  NO 
Name: Hours Date. Description: The column date for this cell. It defaults from the TS_CELL table.
 
REVISION_NO    NUMERIC(10, 0)  NO 
Name: Revision Number. Description: The current revision of the timesheet. It defaults from the TS table.
 
CLASS_CD    VARCHAR(20)  NO 
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    VARCHAR(10)  NO 
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    VARCHAR(120)  NO 
Name: Charge Description. Description: Description of the charge on the line from the TS_LINE table.
 
CHARGE_TREE_CD    VARCHAR(50)  YES 
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    VARCHAR(50)  YES 
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    VARCHAR(100)  YES 
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    VARCHAR(50)  NO 
Name: UDT01 ID. Description: The UDT01 identifier for the line. It defaults from the TS_LINE table.
 
UDT02_ID    VARCHAR(50)  YES 
Name: UDT02 ID. Description: The UDT02 identifier for the line. It defaults from the TS_LINE table.
 
UDT03_ID    VARCHAR(20)  YES 
Name: UDT03 ID. Description: The UDT03 identifier for the line. It defaults from the TS_LINE table.
 
UDT04_ID    VARCHAR(20)  YES 
Name: UDT04 ID. Description: The UDT04 identifier for the line. It defaults from the TS_LINE table.
 
UDT05_ID    VARCHAR(20)  YES 
Name: UDT05 ID. Description: The UDT05 identifier for the line. It defaults from the TS_LINE table.
 
UDT06_ID    VARCHAR(20)  YES 
Name: UDT06 ID. Description: The UDT06 identifier for the line. It defaults from the TS_LINE table.
 
UDT07_ID    VARCHAR(20)  YES 
Name: UDT07 ID. Description: The UDT07 identifier for the line. It defaults from the TS_LINE table.
 
UDT08_ID    VARCHAR(20)  YES 
Name: UDT08 ID. Description: The UDT08 identifier for the line. It defaults from the TS_LINE table.
 
UDT09_ID    VARCHAR(20)  YES 
Name: UDT09 ID. Description: The UDT09 identifier for the line. It defaults from the TS_LINE table.
 
UDT10_ID    VARCHAR(20)  NO 
Name: UDT10 ID. Description: The UDT10 identifier for the line. It defaults from the TS_LINE table.
 
ETC_HRS    NUMERIC(8, 2)  NO 
Name: Estimate to Complete Hours. Description: The estimate-to-complete hours for this employee. It defaults from the TS_LINE table.
 
BILLABLE_FL    VARCHAR(1)  NO 
Name: Billable Flag. Description: Logical as to whether the hours are billable. It defaults from the TS_LINE table.
 
HRS    NUMERIC(8, 2)  NO 
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    VARCHAR(1)  NO 
Name: Correction Flag. Description: Logical as to whether this cell is a correcting entry. This value defaults from the TS_CELL table.
 
ENTERED_DTT    DATE  NO 
Name: Entered Date/Time. Description: The date and time when the hours were entered. This value defaults from the TS_CELL table.
 
OT_FL    VARCHAR(1)  NO 
Name: Overtime Flag. Description: Logical as to whether this UDT10 ID is for overtime. This value defaults from the UDT10 table.
 
COST_FL    VARCHAR(1)  NO 
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    VARCHAR(30)  YES 
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    VARCHAR(254)  YES 
Name: Timesheet Comments. Description: Notes about the entire timesheet. It defaults from the TS table - first 254 characters.
 
SHORT_LINE_TEXT    VARCHAR(254)  YES 
Name: Timesheet Line Comments. Description: User-provided notes about the line. It defaults from the TS_LINE table - first 254 characters.
 
SHORT_CELL_TEXT    VARCHAR(254)  YES 
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    VARCHAR(10)  NO 
Name: Employee Costpoint Company. Description: Costpoint Company Code for Employee.
 
UDT06_CP_COMPANY_CD    VARCHAR(10)  YES 
Name: UDT06 Costpoint Company. Description: Costpoint Company Code for UDT06 field.
 
UDT07_CP_COMPANY_CD    VARCHAR(10)  YES 
Name: UDT07 Costpoint Company. Description: Costpoint Company Code for UDT07 field.
 
REVERSAL_FL    VARCHAR(1)  NO 
Name: Reversal Flag. Description: Logical as to whether entry is a reversing entry.
 
S_CP_TS_TYPE_CD    VARCHAR(1)  NO 
Name: Costpoint Timesheet Type. Description: The Costpoint Timesheet Type. The valid values are: R – Regular. C – Correcting. N – Reversal. D - Replacement
 
RATE1_AMT    NUMERIC(15, 5)  NO 
Name: Rate 1 Amount. Description: The prorated amount for rate1 minus the exported amount for rate 1.
 
RATE2_AMT    NUMERIC(15, 5)  NO 
Name: Rate 2 Amount. Description: The prorated amount for rate2 minus the exported amount for rate 2.
 
UDT11_ID    VARCHAR(20)  YES 
Name: UDT11 ID. Description: The UDT11 identifier for the line. It defaults from the TS_LINE table.
 
UDT12_ID    VARCHAR(20)  YES 
Name: UDT12 ID. Description: The UDT12 identifier for the line. It defaults from the TS_LINE table.
 
UDT13_ID    VARCHAR(20)  YES 
Name: UDT13 ID. Description: The UDT13 identifier for the line. It defaults from the TS_LINE table.
 
UDT14_ID    VARCHAR(20)  YES 
Name: UDT14 ID. Description: The UDT14 identifier for the line. It defaults from the TS_LINE table.
 
UDT15_ID    VARCHAR(20)  YES 
Name: UDT15 ID. Description: The UDT15 identifier for the line. It defaults from the TS_LINE table.
 
SEQ_NO(PK)    NUMERIC(10, 0)  NO 
Name: Sequence Number. Description: Synthetic key to support recasts
 
RATE1_RATE    NUMERIC(15, 5)  NO 
Name: User Defined Rate 1. Description: User-defined rate 1.
 
CP_TS_COMPLETE_FL    VARCHAR(1)  NO 
Name: Costpoint TS Complete Flag. Description: Logical as to whether this timesheet had an approved status when exported.
 
CP_TS_INPROCESS_FL    VARCHAR(1)  NO 
Name: Costpoint TS In-process Flag. Description: Logical as to whether this timesheet hour record was an in process export.
 
TS_UDT10_ID    VARCHAR(20)  YES 
Name: UDT10 used for recast Description: UDT10 ID that started the recasting process.
 
S_STATUS_CD    VARCHAR(1)  YES 
Name: Status code for export Description: Status code used in export of Labor records.
 
MODIFIED_BY    VARCHAR(20)  NO 
 
TIME_STAMP    DATE  NO 
 

EXPORT_LABOR Keys 
Key Name  Key Type  Keys 
PI_0092  PrimaryKey  BATCH_ID, TIMESHEET_DT, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, LINE_NO, HRS_DT, SEQ_NO 
SI_0045  Inversion Entry  BATCH_ID, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD 

EXPORT_LABOR Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype