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. |