EMPL |
Default Table Name | EMPL |
Definition |
EMPL Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EMPL_ID![]() |
VARCHAR2(20) | NO | ||
LAST_NAME | VARCHAR2(30) | NO | ||
FIRST_NAME | VARCHAR2(30) | NO | ||
INITIAL_NAME | VARCHAR2(1) | YES | ||
GOVT_EMPL_ID | VARCHAR2(20) | YES | ||
VENDOR_ID | VARCHAR2(20) | YES | ||
PAYROLL_ID | VARCHAR2(20) | YES | ||
PAYROLL_EMPL_ID | VARCHAR2(20) | YES | ||
HIRE_DT | DATE | YES | ||
TERMINATE_DT | DATE | YES | ||
HOME_PHONE_NO_S | VARCHAR2(30) | YES | ||
WORK_PHONE_NO_S | VARCHAR2(30) | YES | ||
FAX_NO_S | VARCHAR2(30) | YES | ||
CELL_PHONE_NO_S | VARCHAR2(30) | YES | ||
PAGER_NO_S | VARCHAR2(30) | YES | ||
MAIL_ADDRESS_S | VARCHAR2(254) | YES | ||
LOGIN_EMPL_ID | VARCHAR2(20) | NO | ||
ROLE_CD![]() |
VARCHAR2(20) | NO | ||
CODE1_CD | VARCHAR2(20) | YES | ||
CODE2_CD | VARCHAR2(20) | YES | ||
CODE3_CD | VARCHAR2(20) | YES | ||
DATE1_DT | DATE | YES | ||
DATE2_DT | DATE | YES | ||
DATE3_DT | DATE | YES | ||
ACTIVE_FL | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
ROWVERSION | NUMBER(10, 0) | NO | ||
TIME_STAMP | DATE | NO | ||
CURRENCY_CD![]() |
VARCHAR2(3) | NO | ||
TITLE_DESC | VARCHAR2(30) | YES | ||
LOCATION_DESC | VARCHAR2(30) | YES | ||
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 | Initially Deferred |
ROLE | Non-Identifying | One To Zero or More | F00025 | ROLE_CD | NO | NO | NO | ||
CURRENCY | Non-Identifying | One To Zero or More | F00132 | CURRENCY_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
EMPL_GROUP_EMPL | Identifying | One To Zero or More | F00028 | NO | NO | NO | |||
EMPL_GROUP_SPVSR | Identifying | One To Zero or More | F00030 | NO | NO | NO | |||
EMPL_HISTORY | Identifying | One To Zero or More | F00031 | NO | NO | NO | |||
EMPL_PREFERENCE | Identifying | One To Zero or More | F00036 | NO | NO | NO | |||
TS | Identifying | One To Zero or More | F00038 | NO | NO | NO | |||
TS_REVISION | Non-Identifying | One To Zero or More | F00043 | NO | NO | NO | |||
TS_REVISION | Non-Identifying | One To Zero or More | F00044 | NO | NO | NO | |||
TS_AUDIT | Non-Identifying | One To Zero or More | F00048 | NO | NO | NO | |||
EMPL_CHARGE_FAVORITES | Identifying | One To Zero or More | F00062 | NO | NO | NO | |||
CHARGE_BRANCH_CHARGE_EMPL | Identifying | One To Zero or More | F00071 | NO | NO | NO | |||
EMPL_LEAVE | Identifying | One To Zero or More | F00078 | NO | NO | NO | |||
DESKTOP_TASKS | Identifying | One To Zero or More | F00090 | NO | NO | NO | |||
DESKTOP_ALERTS | Identifying | One To Zero or More | F00092 | NO | NO | NO | |||
EMPL_MENU | Identifying | One To Zero or More | F00094 | NO | NO | NO | |||
EMPL_DESKTOP_LEFT | Identifying | One To Zero or More | F00096 | NO | NO | NO | |||
EMPL_DESKTOP_RIGHT | Identifying | One To Zero or More | F00098 | NO | NO | NO | |||
TS_LINE | Non-Identifying | One To Zero or More | F00103 | NO | NO | NO | |||
UDT01_SPVSR | Identifying | One To Zero or More | F00107 | NO | NO | NO | |||
UDT02_SPVSR | Identifying | One To Zero or More | F00110 | NO | NO | NO | |||
EMPL_ACCESS | Identifying | One To Zero or More | F00114 | NO | NO | NO | |||
EMPL_PAY_METHOD | Identifying | One To Zero or More | F00164 | NO | NO | NO | |||
EXP_RPT | Non-Identifying | One To Zero or More | F00207 | NO | NO | NO | |||
EXP_RPT_REVISION | Non-Identifying | One To Zero or More | F00215 | NO | NO | NO | |||
EXP_RPT_EXPENSE_ATTENDEE | Non-Identifying | One To Zero or More | F00231 | NO | NO | NO | |||
DESKTOP_EXPENSE_ALERTS | Identifying | One To Zero or More | F00242 | NO | NO | NO | |||
DESKTOP_SCHEDULE_TASKS | Identifying | One To Zero or More | F00247 | NO | NO | NO | |||
EXP_RPT_EXPENSE | Non-Identifying | One To Zero or More | F00259 | NO | NO | NO | |||
EXP_BATCH_TYPE | Non-Identifying | One To Zero or More | F00288 | NO | NO | NO | |||
BATCH_EXPENSE_EDIT | Non-Identifying | One To Zero or More | F00292 | NO | NO | NO | |||
BATCH_EXPENSE_OUTSTANDING | Non-Identifying | One To Zero or More | F00298 | NO | NO | NO | |||
TS_EXPORT_ADJUSTMENT | Identifying | One To Zero or More | F00303 | NO | NO | NO | |||
ADVANCE_OUTSTANDING | Identifying | One To Zero or More | F00305 | NO | NO | NO | |||
DESKTOP_DELEGATION_EMPLOYEE | Identifying | One To Zero or More | F00321 | NO | NO | NO | |||
DESKTOP_DELEGATION_EMPLOYEE | Identifying | One To Zero or More | F00322 | NO | NO | NO | |||
DESKTOP_DELEGATION_UDT | Identifying | One To Zero or More | F00325 | NO | NO | NO | |||
DESKTOP_DELEGATION_UDT | Identifying | One To Zero or More | F00326 | NO | NO | NO | |||
SCREEN_PARAMETER | Non-Identifying | One To Zero or More | F00329 | NO | NO | NO | |||
SCHEDULED_PROCESS | Non-Identifying | One To Zero or More | F00333 | NO | NO | NO | |||
SCHEDULED_PROCESS | Identifying | One To Zero or More | F00334 | NO | NO | NO | |||
EXP_AUTH | Non-Identifying | One To Zero or More | F00351 | NO | NO | NO | |||
EXP_AUTH_REVISION | Non-Identifying | One To Zero or More | F00365 | NO | NO | NO | |||
DESKTOP_AUTH_TASKS | Identifying | One To Zero or More | F00371 | NO | NO | NO | |||
DESKTOP_SELF_SERVICE_TASKS | Identifying | One To Zero or More | F00378 | NO | NO | NO | |||
DESKTOP_SELF_SERVICE_ALERTS | Identifying | One To Zero or More | F00381 | NO | NO | NO | |||
EXP_RPT_TASKS_EMPL | Identifying | One To Zero or More | F00387 | NO | NO | NO | |||
EXP_AUTH_TASKS_EMPL | Identifying | One To Zero or More | F00390 | NO | NO | NO | |||
UDT01 | Non-Identifying | One To Zero or More | F00402 | NO | NO | NO | |||
UDT02 | Non-Identifying | One To Zero or More | F00403 | NO | NO | NO | |||
EMPL_CHARGE_FAVORITES_CP | Identifying | One To Zero or More | F00417 | NO | NO | NO | |||
CORRECT_EXP_RPT_TASKS_EMPL | Identifying | One To Zero or More | F00436 | NO | NO | NO | |||
CORRECT_ADVANCE_OUTSTANDING | Identifying | One To Zero or More | F00438 | NO | NO | NO | |||
LOCATION | Non-Identifying | One To Zero or More | F00442 | NO | NO | NO | |||
TASK | Non-Identifying | One To Zero or More | F00474 | NO | NO | NO | |||
CORRECT_TASK | Non-Identifying | One To Zero or More | F00486 | NO | NO | NO | |||
TASK_EMPL | Identifying | One To Zero or More | F00489 | NO | NO | NO | |||
CORRECT_TASK_EMPL | Identifying | One To Zero or More | F00492 | NO | NO | NO | |||
EXP_ADVANCE | Non-Identifying | One To Zero or More | F00500 | NO | NO | NO | |||
EXP_ADVANCE_REVISION | Non-Identifying | One To Zero or More | F00505 | NO | NO | NO | |||
EXP_AUTH_WARNING | Non-Identifying | One To Zero or More | F00525 | NO | NO | NO | |||
EXP_AUTH_EXPENSE_WARNING | Non-Identifying | One To Zero or More | F00527 | NO | NO | NO | |||
EXP_AUTH_CHARGE_WARNING | Non-Identifying | One To Zero or More | F00529 | NO | NO | NO | |||
EXP_RPT_WARNING | Non-Identifying | One To Zero or More | F00531 | NO | NO | NO | |||
EXP_RPT_EXPENSE_WARNING | Non-Identifying | One To Zero or More | F00533 | NO | NO | NO | |||
EXP_RPT_CHARGE_WARNING | Non-Identifying | One To Zero or More | F00535 | NO | NO | NO | |||
CORRECT_EXP_RPT_WARNING | Non-Identifying | One To Zero or More | F00537 | NO | NO | NO | |||
CORRECT_EXP_RPT_EXPENSE_WARN | Non-Identifying | One To Zero or More | F00539 | NO | NO | NO | |||
CORRECT_EXP_RPT_CHARGE_WARNING | Non-Identifying | One To Zero or More | F00541 | NO | NO | NO | |||
CORRECT_TS | Identifying | One To Zero or More | F00551 | NO | NO | NO | |||
CORRECT_TS_LINE | Non-Identifying | One To Zero or More | F00559 | NO | NO | NO | |||
CORRECT_TS_REVISION | Non-Identifying | One To Zero or More | F00563 | NO | NO | NO | |||
CORRECT_TS_REVISION | Non-Identifying | One To Zero or More | F00564 | NO | NO | NO | |||
CORRECT_TS_AUDIT | Non-Identifying | One To Zero or More | F00566 | NO | NO | NO | |||
CORRECT_TS_EXPORT_ADJUSTMENT | Identifying | One To Zero or More | F00569 | NO | NO | NO |