USER_COMPANY_ID 
ColumnName  USER_COMPANY_ID 
Definition 
Name: Domain. Description: Alias for database schema that will 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: Unique identifier for the employee.
 

LAST_NAME 
ColumnName  LAST_NAME 
Definition 
Name: Last Name. Description: Employees last name.
 

FIRST_NAME 
ColumnName  FIRST_NAME 
Definition 
Name: First Name. Description: Employees first name.
 

INITIAL_NAME 
ColumnName  INITIAL_NAME 
Definition 
Name: Middle Initial. Description: Employees middle initial.
 

GOVT_EMPL_ID 
ColumnName  GOVT_EMPL_ID 
Definition 
Name: Government Employee ID. Description: Employees government ID, i.e., social security number.
 

VENDOR_ID 
ColumnName  VENDOR_ID 
Definition 
Name: Vendor ID. Description: The identifying vendor ID for this employee.
 

PAYROLL_ID 
ColumnName  PAYROLL_ID 
Definition 
Name: Payroll ID. Description: The payroll ID for the employee to be used with the payroll interface.
 

PAYROLL_EMPL_ID 
ColumnName  PAYROLL_EMPL_ID 
Definition 
Name: Payroll Employee ID. Description: The payroll employee ID for the employee to be used with the payroll interface.
 

HIRE_DT 
ColumnName  HIRE_DT 
Definition 
Name: Hire Date. Description: The employees hire date.
 

TERMINATE_DT 
ColumnName  TERMINATE_DT 
Definition 
Name: Terminate Date. Description: Date that the employee was terminated.
 

HOME_PHONE_NO_S 
ColumnName  HOME_PHONE_NO_S 
Definition 
Name: Home Phone Number. Description: Employees home telephone number.
 

WORK_PHONE_NO_S 
ColumnName  WORK_PHONE_NO_S 
Definition 
Name: Work Phone Number. Description: Employees work telephone number.
 

FAX_NO_S 
ColumnName  FAX_NO_S 
Definition 
Name: Fax Number. Description: Employees fax number.
 

CELL_PHONE_NO_S 
ColumnName  CELL_PHONE_NO_S 
Definition 
Name: Mobile Phone Number. Description: Employees cell phone number.
 

PAGER_NO_S 
ColumnName  PAGER_NO_S 
Definition 
Name: Pager Number. Description: Employees pager number.
 

MAIL_ADDRESS_S 
ColumnName  MAIL_ADDRESS_S 
Definition 
Name: E-mail Address. Description: The employees e-mail address. Multiple e-mail addresses are delimited by a comma.
 

LOGIN_EMPL_ID 
ColumnName  LOGIN_EMPL_ID 
Definition 
Name: Login ID. Description: The ID with which the employee logs on to the system.
 

ROLE_CD 
ColumnName  ROLE_CD 
Definition 
Name: Security Role. Description: The employees role for system rights.
 

CODE1_CD 
ColumnName  CODE1_CD 
Definition 
Name: User Defined Code 1. Description: First user-defined alphanumeric field.
 

CODE2_CD 
ColumnName  CODE2_CD 
Definition 
Name: User Defined Code 2. Description: Second user-defined alphanumeric field.
 

CODE3_CD 
ColumnName  CODE3_CD 
Definition 
Name: User Defined Code 3. Description: Third user-defined alphanumeric field.
 

DATE1_DT 
ColumnName  DATE1_DT 
Definition 
Name: User Defined Date 1. Description: First user-defined date field.
 

DATE2_DT 
ColumnName  DATE2_DT 
Definition 
Name: User Defined Date 2. Description: Second user-defined date field.
 

DATE3_DT 
ColumnName  DATE3_DT 
Definition 
Name: User Defined Date 3. Description: Third user-defined date field.
 

ACTIVE_FL 
ColumnName  ACTIVE_FL 
Definition 
Name: Active Flag. Description: Logical as to whether the employee is active.
 

CURRENCY_CD 
ColumnName  CURRENCY_CD 
Definition 
Name: Pay Currency. Description: The employee’s base currency.
 

TITLE_DESC 
ColumnName  TITLE_DESC 
Definition 
Name: Title. Description: The title of the employee.
 

LOCATION_DESC 
ColumnName  LOCATION_DESC 
Definition 
Name: Location . Description: The location of the employee