EMPL 
Default Table Name  EMPL 
Definition 
 Name: Employee .     Description: This is the master table for employees. It contains attributes that are not date sensitive.
 

EMPL Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EMPL_ID(PK)    VARCHAR2(20)  NO 
Name: Employee ID. Description: Unique identifier for the employee.
 
LAST_NAME    VARCHAR2(30)  NO 
Name: Last Name. Description: Employees last name.
 
FIRST_NAME    VARCHAR2(30)  NO 
Name: First Name. Description: Employees first name.
 
INITIAL_NAME    VARCHAR2(1)  YES 
Name: Middle Initial. Description: Employees middle initial.
 
GOVT_EMPL_ID    VARCHAR2(20)  YES 
Name: Government ID. Description: Employees government ID, i.e., social security number.
 
VENDOR_ID    VARCHAR2(20)  YES 
Name: Vendor ID. Description: The identifying vendor ID for this employee.
 
PAYROLL_ID    VARCHAR2(20)  YES 
Name: Payroll ID. Description: The payroll ID for the employee. For use with the payroll interface.
 
PAYROLL_EMPL_ID    VARCHAR2(20)  YES 
Name: Payroll Employee ID. Description: The payroll Employee ID for the employee. For use with the payroll interface.
 
HIRE_DT    DATE  YES 
Name: Hire date. Description: The employees hire date.
 
TERMINATE_DT    DATE  YES 
Name: Termination date. Description: Date that the employee was terminated.
 
HOME_PHONE_NO_S    VARCHAR2(30)  YES 
Name: Home Phone Number. Description: Employees home telephone number.
 
WORK_PHONE_NO_S    VARCHAR2(30)  YES 
Name: Work Phone Number. Description: Employee work telephone number.
 
FAX_NO_S    VARCHAR2(30)  YES 
Name: Fax Number. Description: Employee fax number.
 
CELL_PHONE_NO_S    VARCHAR2(30)  YES 
Name: Cell Phone Number. Description: Employee cell phone number.
 
PAGER_NO_S    VARCHAR2(30)  YES 
Name: Pager Number. Description: Employee pager number.
 
MAIL_ADDRESS_S    VARCHAR2(254)  YES 
Name: E-mail Address. Description: The employees e-mail address. Multiple e-mail addresses are delimited by commas.
 
LOGIN_EMPL_ID    VARCHAR2(20)  NO 
Name: Login ID. Description: The ID with which the employee logs on to the system.
 
ROLE_CD(FK)    VARCHAR2(10)  NO 
Name: Security Role. Description: The employees role for system rights.
 
CODE1_CD    VARCHAR2(20)  YES 
Name: User Defined Code 1. Description: First user-defined alphanumeric field.
 
CODE2_CD    VARCHAR2(20)  YES 
Name: User Defined Code 2. Description: Second user-defined alphanumeric field.
 
CODE3_CD    VARCHAR2(20)  YES 
Name: User Defined Code 3. Description: Third user-defined alphanumeric field.
 
DATE1_DT    DATE  YES 
Name: User Defined Date 1. Description: First user-defined date field.
 
DATE2_DT    DATE  YES 
Name: User Defined Date 2. Description: Second user-defined date field.
 
DATE3_DT    DATE  YES 
Name: User Defined Date 3. Description: Third user-defined date field.
 
ACTIVE_FL    VARCHAR2(1)  NO 
Name: Active Flag. Description: Logical as to whether the employee is active.
 
MODIFIED_BY    VARCHAR2(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMBER(10, 0)  NO 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
CURRENCY_CD(FK)    VARCHAR2(3)  NO 
Name: Pay Currency. Description: The employee’s pay currency.
 
TITLE_DESC    VARCHAR2(30)  YES 
Name: Title. Description: The title of the employee.
 
LOCATION_DESC    VARCHAR2(30)  YES 
Name: Location . Description: The location of the employee
 
TEMP_PASSWORD_S    VARCHAR2(50)  YES 
 

EMPL Primary and Unique Keys 
Key Name  Key Type  Keys 
SI_0006  Index  LOGIN_EMPL_ID 
PI_0031  PrimaryKey  EMPL_ID 

EMPL Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
ROLE  Non-Identifying  One To Zero or More  F00025      ROLE_CD  NO  NO 
CURRENCY  Non-Identifying  One To Zero or More  F00132      CURRENCY_CD  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
EMPL_GROUP_EMPL  Identifying  One To Zero or More  F00028        NO  NO 
EMPL_GROUP_SPVSR  Identifying  One To Zero or More  F00030        NO  NO 
EMPL_HISTORY  Identifying  One To Zero or More  F00031        NO  NO 
EMPL_PREFERENCE  Identifying  One To Zero or More  F00036        NO  NO 
TS  Identifying  One To Zero or More  F00038        NO  NO 
TS_REVISION  Non-Identifying  One To Zero or More  F00043        NO  NO 
TS_REVISION  Non-Identifying  One To Zero or More  F00044        NO  NO 
TS_AUDIT  Non-Identifying  One To Zero or More  F00048        NO  NO 
EMPL_CHARGE_FAVORITES  Identifying  One To Zero or More  F00062        NO  NO 
CHARGE_BRANCH_CHARGE_EMPL  Identifying  One To Zero or More  F00071        NO  NO 
EMPL_LEAVE  Identifying  One To Zero or More  F00078        NO  NO 
DESKTOP_TASKS  Identifying  One To Zero or More  F00090        NO  NO 
DESKTOP_ALERTS  Identifying  One To Zero or More  F00092        NO  NO 
EMPL_MENU  Identifying  One To Zero or More  F00094        NO  NO 
EMPL_DESKTOP_LEFT  Identifying  One To Zero or More  F00096        NO  NO 
EMPL_DESKTOP_RIGHT  Identifying  One To Zero or More  F00098        NO  NO 
TS_LINE  Non-Identifying  One To Zero or More  F00103        NO  NO 
UDT01_SPVSR  Identifying  One To Zero or More  F00107        NO  NO 
UDT02_SPVSR  Identifying  One To Zero or More  F00110        NO  NO 
EMPL_ACCESS  Identifying  One To Zero or More  F00114        NO  NO 
EMPL_PAY_METHOD  Identifying  One To Zero or More  F00164        NO  NO 
EXP_RPT  Non-Identifying  One To Zero or More  F00207        NO  NO 
EXP_RPT_REVISION  Non-Identifying  One To Zero or More  F00215        NO  NO 
EXP_RPT_EXPENSE_ATTENDEE  Non-Identifying  One To Zero or More  F00231        NO  NO 
DESKTOP_EXPENSE_ALERTS  Identifying  One To Zero or More  F00242        NO  NO 
DESKTOP_SCHEDULE_TASKS  Identifying  One To Zero or More  F00247        NO  NO 
EXP_RPT_EXPENSE  Non-Identifying  One To Zero or More  F00259        NO  NO 
EXP_BATCH_TYPE  Non-Identifying  One To Zero or More  F00288        NO  NO 
BATCH_EXPENSE_EDIT  Non-Identifying  One To Zero or More  F00292        NO  NO 
BATCH_EXPENSE_OUTSTANDING  Non-Identifying  One To Zero or More  F00298        NO  NO 
TS_EXPORT_ADJUSTMENT  Identifying  One To Zero or More  F00303        NO  NO 
ADVANCE_OUTSTANDING  Identifying  One To Zero or More  F00305        NO  NO 
DESKTOP_DELEGATION_EMPLOYEE  Identifying  One To Zero or More  F00321        NO  NO 
DESKTOP_DELEGATION_EMPLOYEE  Identifying  One To Zero or More  F00322        NO  NO 
DESKTOP_DELEGATION_UDT  Identifying  One To Zero or More  F00325        NO  NO 
DESKTOP_DELEGATION_UDT  Identifying  One To Zero or More  F00326        NO  NO 
SCREEN_PARAMETER  Non-Identifying  One To Zero or More  F00329        NO  NO 
SCHEDULED_PROCESS  Non-Identifying  One To Zero or More  F00333        NO  NO 
SCHEDULED_PROCESS  Identifying  One To Zero or More  F00334        NO  NO 
EXP_AUTH  Non-Identifying  One To Zero or More  F00351        NO  NO 
EXP_AUTH_REVISION  Non-Identifying  One To Zero or More  F00365        NO  NO 
DESKTOP_AUTH_TASKS  Identifying  One To Zero or More  F00371        NO  NO 
DESKTOP_SELF_SERVICE_TASKS  Identifying  One To Zero or More  F00378        NO  NO 
DESKTOP_SELF_SERVICE_ALERTS  Identifying  One To Zero or More  F00381        NO  NO 
EXP_RPT_TASKS_EMPL  Identifying  One To Zero or More  F00387        NO  NO 
EXP_AUTH_TASKS_EMPL  Identifying  One To Zero or More  F00390        NO  NO 
UDT01  Non-Identifying  One To Zero or More  F00402        NO  NO 
UDT02  Non-Identifying  One To Zero or More  F00403        NO  NO 
EMPL_CHARGE_FAVORITES_CP  Identifying  One To Zero or More  F00417        NO  NO 
CORRECT_EXP_RPT_TASKS_EMPL  Identifying  One To Zero or More  F00436        NO  NO 
CORRECT_ADVANCE_OUTSTANDING  Identifying  One To Zero or More  F00438        NO  NO 
LOCATION  Non-Identifying  One To Zero or More  F00442        NO  NO 
TASK  Non-Identifying  One To Zero or More  F00474        NO  NO 
CORRECT_TASK  Non-Identifying  One To Zero or More  F00486        NO  NO 
TASK_EMPL  Identifying  One To Zero or More  F00489        NO  NO 
CORRECT_TASK_EMPL  Identifying  One To Zero or More  F00492        NO  NO 
EXP_ADVANCE  Non-Identifying  One To Zero or More  F00500        NO  NO 
EXP_ADVANCE_REVISION  Non-Identifying  Zero or One to Zero or More  F00505        NO  NO 
EXP_AUTH_WARNING  Non-Identifying  One To Zero or More  F00525        NO  NO 
EXP_AUTH_EXPENSE_WARNING  Non-Identifying  One To Zero or More  F00527        NO  NO 
EXP_AUTH_CHARGE_WARNING  Non-Identifying  One To Zero or More  F00529        NO  NO 
EXP_RPT_WARNING  Non-Identifying  One To Zero or More  F00531        NO  NO 
EXP_RPT_EXPENSE_WARNING  Non-Identifying  One To Zero or More  F00533        NO  NO 
EXP_RPT_CHARGE_WARNING  Non-Identifying  One To Zero or More  F00535        NO  NO 
CORRECT_EXP_RPT_WARNING  Non-Identifying  One To Zero or More  F00537        NO  NO 
CORRECT_EXP_RPT_EXPENSE_WARN  Non-Identifying  One To Zero or More  F00539        NO  NO 
CORRECT_EXP_RPT_CHARGE_WARNING  Non-Identifying  One To Zero or More  F00541        NO  NO