USER_COMPANY_ID 
ColumnName  USER_COMPANY_ID 
Definition 
Name: Domain. Description: Alias for database schema that shall be updated.
 

S_IMPORT_CD 
ColumnName  S_IMPORT_CD 
Definition 
Name: Import Type. Description: Indicates the type of transaction. The valid values are: A - Add. C - Change. D - Delete. B - Batch 
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: A time/date stamp that indicates when the record was originally inserted into table.
 

EXTERNAL_USER 
ColumnName  EXTERNAL_USER 
Definition 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 

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

EFFECTIVE_DT 
ColumnName  EFFECTIVE_DT 
Definition 
Name: Effective Date. Description: The start date for using this history record.
 

WORK_SCHEDULE_CD 
ColumnName  WORK_SCHEDULE_CD 
Definition 
Name: Work Schedule. Description: The current work schedule for the employee.
 

CLASS_CD 
ColumnName  CLASS_CD 
Definition 
Name: Timesheet Class. Description: The current employee class for the employee.
 

TS_SCHEDULE_CD 
ColumnName  TS_SCHEDULE_CD 
Definition 
Name: Timesheet Schedule. Description: The current timesheet frequency for the employee.
 

DFLT_UDT01_ID 
ColumnName  DFLT_UDT01_ID 
Definition 
Name: Default UDT01 ID. Description: The current default UDT01 for the employee.
 

DFLT_UDT02_ID 
ColumnName  DFLT_UDT02_ID 
Definition 
Name: Default UDT02 ID. Description: The current default UDT02 for the employee.
 

DFLT_UDT03_ID 
ColumnName  DFLT_UDT03_ID 
Definition 
Name: Default UDT03 ID. Description: The current default UDT03 for the employee.
 

DFLT_UDT04_ID 
ColumnName  DFLT_UDT04_ID 
Definition 
Name: Default UDT04 ID. Description: The current default UDT04 for the employee.
 

DFLT_UDT05_ID 
ColumnName  DFLT_UDT05_ID 
Definition 
Name: Default UDT05 ID. Description: The current default UDT05 for the employee.
 

DFLT_UDT06_ID 
ColumnName  DFLT_UDT06_ID 
Definition 
Name: Default UDT06 ID. Description: The current default UDT06 for the employee.
 

DFLT_UDT07_ID 
ColumnName  DFLT_UDT07_ID 
Definition 
Name: Default UDT07 ID. Description: The current default UDT07 for the employee.
 

DFLT_UDT08_ID 
ColumnName  DFLT_UDT08_ID 
Definition 
Name: Default UDT08 ID. Description: The current default UDT08 for the employee.
 

DFLT_UDT09_ID 
ColumnName  DFLT_UDT09_ID 
Definition 
Name: Default UDT09 ID. Description: The current default UDT09 for the employee.
 

DFLT_UDT10_ID 
ColumnName  DFLT_UDT10_ID 
Definition 
Name: Default UDT10 ID. Description: The current default UDT10 for the employee.
 

CP_COMPANY_CD 
ColumnName  CP_COMPANY_CD 
Definition 
Name: Costpoint Company. Description: Employee’s Costpoint Company Code Value should be “1” if not Costpoint Multi-Company
 

RATE1_RATE 
ColumnName  RATE1_RATE 
Definition 
Name: User Defined Rate 1 Rate. Description: Employee’s first user-defined rate. 
 

RATE2_RATE 
ColumnName  RATE2_RATE 
Definition 
Name: User Defined Rate 2 Rate. Description: Employee’s second user-defined rate. 
 

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

UDT06_CP_COMPANY_CD 
ColumnName  UDT06_CP_COMPANY_CD 
Definition 
Name: UDT06 Costpoint Company. Description: Costpoint Company Code DFLT_UDT06_ID column.
 

UDT07_CP_COMPANY_CD 
ColumnName  UDT07_CP_COMPANY_CD 
Definition 
Name: UDT07 Costpoint Company. Description: Costpoint Company Code DFLT_UDT07_ID column.
 

EXP_CLASS_CD 
ColumnName  EXP_CLASS_CD 
Definition 
Name: Expense Class. Description: The default expense class for the employee at this point in history.
 

DFLT_UDT11_ID 
ColumnName  DFLT_UDT11_ID 
Definition 
Name: Default UDT11 ID. Description: The current default UDT11 for the employee.
 

DFLT_UDT12_ID 
ColumnName  DFLT_UDT12_ID 
Definition 
Name: Default UDT12 ID. Description: The current default UDT12 for the employee.
 

DFLT_UDT13_ID 
ColumnName  DFLT_UDT13_ID 
Definition 
Name: Default UDT13 ID. Description: The current default UDT13 for the employee.
 

DFLT_UDT14_ID 
ColumnName  DFLT_UDT14_ID 
Definition 
Name: Default UDT14 ID. Description: The current default UDT14 for the employee.
 

DFLT_UDT15_ID 
ColumnName  DFLT_UDT15_ID 
Definition 
Name: Default UDT15 ID. Description: The current default UDT15 for the employee.