IMPORT_EMPL_HISTORY 
Default Table Name  IMPORT_EMPL_HISTORY 
Definition 
 Name: Employee History Import  .     Description: This staging table contains historical information for employees that will be imported to Deltek Time and Expense if validations are passed.
 

IMPORT_EMPL_HISTORY Columns 
ColumnName  Domain  Datatype  NULL  Definition 
USER_COMPANY_ID    VARCHAR2(30)  NO 
Name: Domain. Description: Alias for database schema that shall be updated.
 
S_IMPORT_CD    VARCHAR2(1)  NO 
Name: Import Type. Description: Indicates the type of transaction. The valid values are: A - Add. C - Change. D - Delete. B - Batch 
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: A time/date stamp that indicates when the record was originally inserted into table.
 
EXTERNAL_USER    VARCHAR2(20)  NO 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 
EMPL_ID    VARCHAR2(20)  NO 
Name: Employee ID. Description: Employee ID for history record.
 
EFFECTIVE_DT    DATE  NO 
Name: Effective Date. Description: The start date for using this history record.
 
WORK_SCHEDULE_CD    VARCHAR2(10)  YES 
Name: Work Schedule. Description: The current work schedule for the employee.
 
CLASS_CD    VARCHAR2(20)  YES 
Name: Timesheet Class. Description: The current employee class for the employee.
 
TS_SCHEDULE_CD    VARCHAR2(10)  YES 
Name: Timesheet Schedule. Description: The current timesheet frequency for the employee.
 
DFLT_UDT01_ID    VARCHAR2(50)  YES 
Name: Default UDT01 ID. Description: The current default UDT01 for the employee.
 
DFLT_UDT02_ID    VARCHAR2(50)  YES 
Name: Default UDT02 ID. Description: The current default UDT02 for the employee.
 
DFLT_UDT03_ID    VARCHAR2(20)  YES 
Name: Default UDT03 ID. Description: The current default UDT03 for the employee.
 
DFLT_UDT04_ID    VARCHAR2(20)  YES 
Name: Default UDT04 ID. Description: The current default UDT04 for the employee.
 
DFLT_UDT05_ID    VARCHAR2(20)  YES 
Name: Default UDT05 ID. Description: The current default UDT05 for the employee.
 
DFLT_UDT06_ID    VARCHAR2(20)  YES 
Name: Default UDT06 ID. Description: The current default UDT06 for the employee.
 
DFLT_UDT07_ID    VARCHAR2(20)  YES 
Name: Default UDT07 ID. Description: The current default UDT07 for the employee.
 
DFLT_UDT08_ID    VARCHAR2(20)  YES 
Name: Default UDT08 ID. Description: The current default UDT08 for the employee.
 
DFLT_UDT09_ID    VARCHAR2(20)  YES 
Name: Default UDT09 ID. Description: The current default UDT09 for the employee.
 
DFLT_UDT10_ID    VARCHAR2(20)  YES 
Name: Default UDT10 ID. Description: The current default UDT10 for the employee.
 
CP_COMPANY_CD    VARCHAR2(10)  NO 
Name: Costpoint Company. Description: Employee’s Costpoint Company Code Value should be “1” if not Costpoint Multi-Company
 
RATE1_RATE    NUMBER(15, 5)  NO 
Name: User Defined Rate 1 Rate. Description: Employee’s first user-defined rate. 
 
RATE2_RATE    NUMBER(15, 5)  NO 
Name: User Defined Rate 2 Rate. Description: Employee’s second user-defined rate. 
 
FRINGE_REDUCTION_RATE    NUMBER(15, 5)  NO 
Name: Fringe Reduction Rate. Description: Employee’s Fringe Reduction Rate. 
 
UDT06_CP_COMPANY_CD    VARCHAR2(10)  YES 
Name: UDT06 Costpoint Company. Description: Costpoint Company Code DFLT_UDT06_ID column.
 
UDT07_CP_COMPANY_CD    VARCHAR2(10)  YES 
Name: UDT07 Costpoint Company. Description: Costpoint Company Code DFLT_UDT07_ID column.
 
EXP_CLASS_CD    VARCHAR2(20)  YES 
Name: Expense Class. Description: The default expense class for the employee at this point in history.
 
DFLT_UDT11_ID    VARCHAR2(20)  YES 
Name: Default UDT11 ID. Description: The current default UDT11 for the employee.
 
DFLT_UDT12_ID    VARCHAR2(20)  YES 
Name: Default UDT12 ID. Description: The current default UDT12 for the employee.
 
DFLT_UDT13_ID    VARCHAR2(20)  YES 
Name: Default UDT13 ID. Description: The current default UDT13 for the employee.
 
DFLT_UDT14_ID    VARCHAR2(20)  YES 
Name: Default UDT14 ID. Description: The current default UDT14 for the employee.
 
DFLT_UDT15_ID    VARCHAR2(20)  YES 
Name: Default UDT15 ID. Description: The current default UDT15 for the employee.
 

IMPORT_EMPL_HISTORY Primary and Unique Keys 
Key Name  Key Type  Keys 

IMPORT_EMPL_HISTORY Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable