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 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. For use with the payroll interface.
 

PAYROLL_EMPL_ID 
ColumnName  PAYROLL_EMPL_ID 
Definition 
Name: Payroll Employee ID. Description: The payroll Employee ID for the employee. For use 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: Termination 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: Employee work telephone number.
 

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

CELL_PHONE_NO_S 
ColumnName  CELL_PHONE_NO_S 
Definition 
Name: Cell Phone Number. Description: Employee cell phone number.
 

PAGER_NO_S 
ColumnName  PAGER_NO_S 
Definition 
Name: Pager Number. Description: Employee 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 commas.
 

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.
 

MODIFIED_BY 
ColumnName  MODIFIED_BY 
Definition 
Name: Modified By. Description: The User ID of the person who last modified this record.
 

ROWVERSION 
ColumnName  ROWVERSION 
Definition 
Name: Row Version. Description: The number of times this record has been updated.
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: Date and time the record was last modified.
 

CURRENCY_CD 
ColumnName  CURRENCY_CD 
Definition 
Name: Pay Currency. Description: The employee’s pay 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
 

TEMP_PASSWORD_S 
ColumnName  TEMP_PASSWORD_S 
Definition