EMPL_ID 
ColumnName  EMPL_ID 
Definition 
Name: Batch ID. Description: Employee ID identifier for the history record.
 

EFFECTIVE_DT 
ColumnName  EFFECTIVE_DT 
Definition 
Name: Batch Type. Description: The start date for using this history record.
 

WORK_SCHEDULE_CD 
ColumnName  WORK_SCHEDULE_CD 
Definition 
Name: Transaction ID. Description: The current work schedule for the employee.
 

CLASS_CD 
ColumnName  CLASS_CD 
Definition 
Name: Employee ID. Description: The current employee class for the employee.
 

TS_SCHEDULE_CD 
ColumnName  TS_SCHEDULE_CD 
Definition 
Name: Wizard Type. Description: The current timesheet frequency for the employee.
 

DFLT_UDT01_ID 
ColumnName  DFLT_UDT01_ID 
Definition 
Name: . Description: The current default value for this UDT01 for the employee.
 

DFLT_UDT02_ID 
ColumnName  DFLT_UDT02_ID 
Definition 
Name: . Description: The current default value for this UDT02 for the employee.
 

DFLT_UDT03_ID 
ColumnName  DFLT_UDT03_ID 
Definition 
Name: . Description: The current default value for this UDT03 for the employee.
 

DFLT_UDT04_ID 
ColumnName  DFLT_UDT04_ID 
Definition 
Name: . Description: The current default value for this UDT04 for the employee.
 

DFLT_UDT05_ID 
ColumnName  DFLT_UDT05_ID 
Definition 
Name: . Description: The current default value for this UDT05 for the employee.
 

DFLT_UDT06_ID 
ColumnName  DFLT_UDT06_ID 
Definition 
Name: . Description: The current default value for this UDT06 for the employee 
 

DFLT_UDT07_ID 
ColumnName  DFLT_UDT07_ID 
Definition 
Name: . Description: The current default value for this UDT07 for the employee 
 

DFLT_UDT08_ID 
ColumnName  DFLT_UDT08_ID 
Definition 
Name: Expense Date. Description: The current default value for this UDT08 for the employee.
 

DFLT_UDT09_ID 
ColumnName  DFLT_UDT09_ID 
Definition 
Name: Provider. Description: The current default value for this UDT09 for the employee.
 

DFLT_UDT10_ID 
ColumnName  DFLT_UDT10_ID 
Definition 
Name: Merchant Name. Description: The current default value for this UDT10 for the employee.
 

MODIFIED_BY 
ColumnName  MODIFIED_BY 
Definition 
Name: Ticket Number. Description: The User ID of the person who last modified this record.
 

ROWVERSION 
ColumnName  ROWVERSION 
Definition 
Name: Departure Date. Description: The number of times this record has been updated.
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Return date. Description: Date and Time the record was last modified.
 

RATE1_RATE 
ColumnName  RATE1_RATE 
Definition 
Name: Number of Units. Description: Employee’s first user-defined rate. 
 

RATE2_RATE 
ColumnName  RATE2_RATE 
Definition 
Name: Pay Method . Description: Employee’s second user-defined rate. 
 

FRINGE_REDUCTION_RATE 
ColumnName  FRINGE_REDUCTION_RATE 
Definition 
Name: Transaction Currency. Description: Employee’s Fringe Reduction Rate. 
 

CP_COMPANY_CD 
ColumnName  CP_COMPANY_CD 
Definition 
Name: Transaction to Base Currency Exchange Rate. Description: Costpoint Company Code.
 

UDT06_CP_COMPANY_CD 
ColumnName  UDT06_CP_COMPANY_CD 
Definition 
Name: Transaction Currency Unit Rate. Description: Costpoint Company Code for DFLT_UDT06_ID field.
 

UDT07_CP_COMPANY_CD 
ColumnName  UDT07_CP_COMPANY_CD 
Definition 
Name: Transaction Currency Daily Room Rate. Description: Costpoint Company Code for DLFT_UDT07_ID field.
 

EXP_CLASS_CD 
ColumnName  EXP_CLASS_CD 
Definition 
Name: Transaction Currency Daily Tax Rate. Description: User-specified unique identifier for this table.
 

DFLT_UDT11_ID 
ColumnName  DFLT_UDT11_ID 
Definition 
Name: Transaction Currency Incurred Amount. Description: The current default value for this UDT11 for the employee.
 

DFLT_UDT12_ID 
ColumnName  DFLT_UDT12_ID 
Definition 
Name: Transaction Currency Tax Amount. Description: The current default value for this UDT12 for the employee.
 

DFLT_UDT13_ID 
ColumnName  DFLT_UDT13_ID 
Definition 
Name: Start Date. Description: The current default value for this UDT13 for the employee.
 

DFLT_UDT14_ID 
ColumnName  DFLT_UDT14_ID 
Definition 
Name: End date. Description: The current default value for this UDT14 for the employee.
 

DFLT_UDT15_ID 
ColumnName  DFLT_UDT15_ID 
Definition 
Name: Number of Nights. Description: The current default value for this UDT15 for the employee.