ColumnName |
Domain |
Datatype |
NULL |
Definition |
EMPL_ID |
|
VARCHAR2(20) |
NO |
Name: Batch ID. Description: Employee ID identifier for the history record. |
EFFECTIVE_DT |
|
DATE |
NO |
Name: Batch Type. Description: The start date for using this history record. |
WORK_SCHEDULE_CD |
|
VARCHAR2(10) |
NO |
Name: Transaction ID. Description: The current work schedule for the employee. |
CLASS_CD |
|
VARCHAR2(20) |
NO |
Name: Employee ID. Description: The current employee class for the employee. |
TS_SCHEDULE_CD |
|
VARCHAR2(10) |
NO |
Name: Wizard Type. Description: The current timesheet frequency for the employee. |
DFLT_UDT01_ID |
|
VARCHAR2(50) |
YES |
Name: . Description: The current default value for this UDT01 for the employee. |
DFLT_UDT02_ID |
|
VARCHAR2(50) |
YES |
Name: . Description: The current default value for this UDT02 for the employee. |
DFLT_UDT03_ID |
|
VARCHAR2(20) |
YES |
Name: . Description: The current default value for this UDT03 for the employee. |
DFLT_UDT04_ID |
|
VARCHAR2(20) |
YES |
Name: . Description: The current default value for this UDT04 for the employee. |
DFLT_UDT05_ID |
|
VARCHAR2(20) |
YES |
Name: . Description: The current default value for this UDT05 for the employee. |
DFLT_UDT06_ID |
|
VARCHAR2(20) |
YES |
Name: . Description: The current default value for this UDT06 for the employee |
DFLT_UDT07_ID |
|
VARCHAR2(20) |
YES |
Name: . Description: The current default value for this UDT07 for the employee |
DFLT_UDT08_ID |
|
VARCHAR2(20) |
YES |
Name: Expense Date. Description: The current default value for this UDT08 for the employee. |
DFLT_UDT09_ID |
|
VARCHAR2(20) |
YES |
Name: Provider. Description: The current default value for this UDT09 for the employee. |
DFLT_UDT10_ID |
|
VARCHAR2(20) |
YES |
Name: Merchant Name. Description: The current default value for this UDT10 for the employee. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Ticket Number. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMBER(10, 0) |
NO |
Name: Departure Date. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Return date. Description: Date and Time the record was last modified. |
RATE1_RATE |
|
NUMBER(15, 5) |
NO |
Name: Number of Units. Description: Employee’s first user-defined rate. |
RATE2_RATE |
|
NUMBER(15, 5) |
NO |
Name: Pay Method . Description: Employee’s second user-defined rate. |
FRINGE_REDUCTION_RATE |
|
NUMBER(15, 5) |
NO |
Name: Transaction Currency. Description: Employee’s Fringe Reduction Rate. |
CP_COMPANY_CD |
|
VARCHAR2(10) |
NO |
Name: Transaction to Base Currency Exchange Rate. Description: Costpoint Company Code. |
UDT06_CP_COMPANY_CD |
|
VARCHAR2(10) |
YES |
Name: Transaction Currency Unit Rate. Description: Costpoint Company Code for DFLT_UDT06_ID field. |
UDT07_CP_COMPANY_CD |
|
VARCHAR2(10) |
YES |
Name: Transaction Currency Daily Room Rate. Description: Costpoint Company Code for DLFT_UDT07_ID field. |
EXP_CLASS_CD |
|
VARCHAR2(20) |
NO |
Name: Transaction Currency Daily Tax Rate. Description: User-specified unique identifier for this table. |
DFLT_UDT11_ID |
|
VARCHAR2(20) |
YES |
Name: Transaction Currency Incurred Amount. Description: The current default value for this UDT11 for the employee. |
DFLT_UDT12_ID |
|
VARCHAR2(20) |
YES |
Name: Transaction Currency Tax Amount. Description: The current default value for this UDT12 for the employee. |
DFLT_UDT13_ID |
|
VARCHAR2(20) |
YES |
Name: Start Date. Description: The current default value for this UDT13 for the employee. |
DFLT_UDT14_ID |
|
VARCHAR2(20) |
YES |
Name: End date. Description: The current default value for this UDT14 for the employee. |
DFLT_UDT15_ID |
|
VARCHAR2(20) |
YES |
Name: Number of Nights. Description: The current default value for this UDT15 for the employee. |