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 Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
EMPL_ID![]() |
VARCHAR(20) | NO | Name: Employee ID. Description: Unique identifier for the employee. |
|
LAST_NAME | VARCHAR(30) | NO | Name: Last Name. Description: Employees last name. |
|
FIRST_NAME | VARCHAR(30) | NO | Name: First Name. Description: Employees first name. |
|
INITIAL_NAME | VARCHAR(1) | YES | Name: Middle Initial. Description: Employees middle initial. |
|
GOVT_EMPL_ID | VARCHAR(20) | YES | Name: Government ID. Description: Employees government ID, i.e., social security number. |
|
VENDOR_ID | VARCHAR(20) | YES | Name: Vendor ID. Description: The identifying vendor ID for this employee. |
|
PAYROLL_ID | VARCHAR(20) | YES | Name: Payroll ID. Description: The payroll ID for the employee. For use with the payroll interface. |
|
PAYROLL_EMPL_ID | VARCHAR(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 | VARCHAR(30) | YES | Name: Home Phone Number. Description: Employees home telephone number. |
|
WORK_PHONE_NO_S | VARCHAR(30) | YES | Name: Work Phone Number. Description: Employee work telephone number. |
|
FAX_NO_S | VARCHAR(30) | YES | Name: Fax Number. Description: Employee fax number. |
|
CELL_PHONE_NO_S | VARCHAR(30) | YES | Name: Cell Phone Number. Description: Employee cell phone number. |
|
PAGER_NO_S | VARCHAR(30) | YES | Name: Pager Number. Description: Employee pager number. |
|
MAIL_ADDRESS_S | VARCHAR(254) | YES | Name: E-mail Address. Description: The employees e-mail address. Multiple e-mail addresses are delimited by commas. |
|
LOGIN_EMPL_ID | VARCHAR(20) | NO | Name: Login ID. Description: The ID with which the employee logs on to the system. |
|
ROLE_CD![]() |
VARCHAR(10) | NO | Name: Security Role. Description: The employees role for system rights. |
|
CODE1_CD | VARCHAR(20) | YES | Name: User Defined Code 1. Description: First user-defined alphanumeric field. |
|
CODE2_CD | VARCHAR(20) | YES | Name: User Defined Code 2. Description: Second user-defined alphanumeric field. |
|
CODE3_CD | VARCHAR(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 | VARCHAR(1) | NO | Name: Active Flag. Description: Logical as to whether the employee is active. |
|
MODIFIED_BY | VARCHAR(20) | NO | Name: Modified By. Description: The User ID of the person who last modified this record. |
|
ROWVERSION | NUMERIC(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![]() |
VARCHAR(3) | NO | Name: Pay Currency. Description: The employee’s pay currency. |
|
TITLE_DESC | VARCHAR(30) | YES | Name: Title. Description: The title of the employee. |
|
LOCATION_DESC | VARCHAR(30) | YES | Name: Location . Description: The location of the employee |
|
TEMP_PASSWORD_S | VARCHAR(50) | YES |
EMPL Keys |
Key Name | Key Type | Keys |
RI_F00025 | Inversion Entry | ROLE_CD |
RI_F00132 | Inversion Entry | CURRENCY_CD |
SI_0006 | Alternate Key | LOGIN_EMPL_ID |
PI_0031 | PrimaryKey | EMPL_ID |
EMPL Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
ROLE | Non-Identifying | One To Zero or More | ROLE_CD | NO | |||
CURRENCY | Non-Identifying | One To Zero or More | CURRENCY_CD | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
EMPL_GROUP_EMPL | Identifying | One To Zero or More | NO | ||||
EMPL_GROUP_SPVSR | Identifying | One To Zero or More | NO | ||||
EMPL_HISTORY | Identifying | One To Zero or More | NO | ||||
EMPL_PREFERENCE | Identifying | One To Zero or More | NO | ||||
TS | Identifying | One To Zero or More | NO | ||||
TS_REVISION | Non-Identifying | One To Zero or More | NO | ||||
TS_REVISION | Non-Identifying | One To Zero or More | NO | ||||
TS_AUDIT | Non-Identifying | One To Zero or More | NO | ||||
EMPL_CHARGE_FAVORITES | Identifying | One To Zero or More | NO | ||||
CHARGE_BRANCH_CHARGE_EMPL | Identifying | One To Zero or More | NO | ||||
EMPL_LEAVE | Identifying | One To Zero or More | NO | ||||
DESKTOP_TASKS | Identifying | One To Zero or More | NO | ||||
DESKTOP_ALERTS | Identifying | One To Zero or More | NO | ||||
EMPL_MENU | Identifying | One To Zero or More | NO | ||||
EMPL_DESKTOP_LEFT | Identifying | One To Zero or More | NO | ||||
EMPL_DESKTOP_RIGHT | Identifying | One To Zero or More | NO | ||||
TS_LINE | Non-Identifying | One To Zero or More | NO | ||||
UDT01_SPVSR | Identifying | One To Zero or More | NO | ||||
UDT02_SPVSR | Identifying | One To Zero or More | NO | ||||
EMPL_ACCESS | Identifying | One To Zero or More | NO | ||||
EMPL_PAY_METHOD | Identifying | One To Zero or More | NO | ||||
EXP_RPT | Non-Identifying | One To Zero or More | NO | ||||
EXP_RPT_REVISION | Non-Identifying | One To Zero or More | NO | ||||
EXP_RPT_EXPENSE_ATTENDEE | Non-Identifying | One To Zero or More | NO | ||||
DESKTOP_EXPENSE_ALERTS | Identifying | One To Zero or More | NO | ||||
DESKTOP_SCHEDULE_TASKS | Identifying | One To Zero or More | NO | ||||
EXP_RPT_EXPENSE | Non-Identifying | Zero or One to Zero or More | NO | ||||
EXP_BATCH_TYPE | Non-Identifying | Zero or One to Zero or More | NO | ||||
BATCH_EXPENSE_EDIT | Non-Identifying | One To Zero or More | NO | ||||
BATCH_EXPENSE_OUTSTANDING | Non-Identifying | One To Zero or More | NO | ||||
TS_EXPORT_ADJUSTMENT | Identifying | One To Zero or More | NO | ||||
ADVANCE_OUTSTANDING | Identifying | One To Zero or More | NO | ||||
DESKTOP_DELEGATION_EMPLOYEE | Identifying | One To Zero or More | NO | ||||
DESKTOP_DELEGATION_EMPLOYEE | Identifying | One To Zero or More | NO | ||||
DESKTOP_DELEGATION_UDT | Identifying | One To Zero or More | NO | ||||
DESKTOP_DELEGATION_UDT | Identifying | One To Zero or More | NO | ||||
SCREEN_PARAMETER | Non-Identifying | One To Zero or More | NO | ||||
SCHEDULED_PROCESS | Non-Identifying | One To Zero or More | NO | ||||
SCHEDULED_PROCESS | Identifying | One To Zero or More | NO | ||||
EXP_AUTH | Non-Identifying | One To Zero or More | NO | ||||
EXP_AUTH_REVISION | Non-Identifying | One To Zero or More | NO | ||||
DESKTOP_AUTH_TASKS | Identifying | One To Zero or More | NO | ||||
DESKTOP_SELF_SERVICE_TASKS | Identifying | One To Zero or More | NO | ||||
DESKTOP_SELF_SERVICE_ALERTS | Identifying | One To Zero or More | NO | ||||
EXP_RPT_TASKS_EMPL | Identifying | One To Zero or More | NO | ||||
EXP_AUTH_TASKS_EMPL | Identifying | One To Zero or More | NO | ||||
UDT01 | Non-Identifying | One To Zero or More | NO | ||||
UDT02 | Non-Identifying | One To Zero or More | NO | ||||
EMPL_CHARGE_FAVORITES_CP | Identifying | One To Zero or More | NO | ||||
CORRECT_EXP_RPT_TASKS_EMPL | Identifying | One To Zero or More | NO | ||||
CORRECT_ADVANCE_OUTSTANDING | Identifying | One To Zero or More | NO | ||||
LOCATION | Non-Identifying | One To Zero or More | NO | ||||
TASK | Non-Identifying | One To Zero or More | NO | ||||
CORRECT_TASK | Non-Identifying | Zero or One to Zero or More | NO | ||||
TASK_EMPL | Identifying | One To Zero or More | NO | ||||
CORRECT_TASK_EMPL | Identifying | One To Zero or More | NO | ||||
EXP_ADVANCE | Non-Identifying | One To Zero or More | NO | ||||
EXP_ADVANCE_REVISION | Non-Identifying | One To Zero or More | NO | ||||
EXP_AUTH_WARNING | Non-Identifying | One To Zero or More | NO | ||||
EXP_AUTH_EXPENSE_WARNING | Non-Identifying | One To Zero or More | NO | ||||
EXP_AUTH_CHARGE_WARNING | Non-Identifying | One To Zero or More | NO | ||||
EXP_RPT_WARNING | Non-Identifying | One To Zero or More | NO | ||||
EXP_RPT_EXPENSE_WARNING | Non-Identifying | One To Zero or More | NO | ||||
EXP_RPT_CHARGE_WARNING | Non-Identifying | One To Zero or More | NO | ||||
CORRECT_EXP_RPT_WARNING | Non-Identifying | One To Zero or More | NO | ||||
CORRECT_EXP_RPT_EXPENSE_WARN | Non-Identifying | One To Zero or More | NO | ||||
CORRECT_EXP_RPT_CHARGE_WARNING | Non-Identifying | One To Zero or More | NO |