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