EMPL |
Default Table Name | EMPL |
Definition |
EMPL Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EMPL_ID![]() |
VARCHAR2(12) | NO | ||
LV_PD_CD![]() |
VARCHAR2(4) | YES | ||
TAXBLE_ENTITY_ID![]() |
VARCHAR2(10) | YES | ||
SSN_ID | VARCHAR2(11) | NO | ||
ORIG_HIRE_DT | DATE | NO | ||
ADJ_HIRE_DT | DATE | YES | ||
TERM_DT | DATE | YES | ||
S_EMPL_STATUS_CD | VARCHAR2(3) | NO | ||
UNIT_AMT | NUMBER(10, 4) | NO | ||
SPVSR_NAME | VARCHAR2(25) | NO | ||
LAST_NAME | VARCHAR2(25) | NO | ||
FIRST_NAME | VARCHAR2(20) | NO | ||
MID_NAME | VARCHAR2(10) | NO | ||
PREF_NAME | VARCHAR2(10) | NO | ||
NAME_PRFX_CD | VARCHAR2(6) | NO | ||
NAME_SFX_CD | VARCHAR2(6) | NO | ||
NOTES | VARCHAR2(254) | NO | ||
TS_PD_CD![]() |
VARCHAR2(4) | NO | ||
BIRTH_DT | DATE | YES | ||
CITY_NAME | VARCHAR2(25) | NO | ||
COUNTRY_CD![]() |
VARCHAR2(8) | YES | ||
LAST_FIRST_NAME | VARCHAR2(25) | NO | ||
LN_1_ADR | VARCHAR2(30) | NO | ||
LN_2_ADR | VARCHAR2(30) | NO | ||
LN_3_ADR | VARCHAR2(30) | NO | ||
MAIL_STATE_DC![]() |
VARCHAR2(15) | YES | ||
POSTAL_CD | VARCHAR2(10) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
LOCATOR_CD | VARCHAR2(20) | NO | ||
PRIR_NAME | VARCHAR2(25) | NO | ||
COMPANY_ID | VARCHAR2(10) | NO | ||
LAST_REVIEW_DT | DATE | YES | ||
NEXT_REVIEW_DT | DATE | YES | ||
SEX_CD | VARCHAR2(1) | YES | ||
MARITAL_CD | VARCHAR2(1) | YES | ||
ELIG_AUTO_PAY_FL | VARCHAR2(1) | NO | ||
EMAIL_ID | VARCHAR2(60) | NO | ||
MGR_EMPL_ID | VARCHAR2(12) | YES | ||
S_RACE_CD | VARCHAR2(10) | NO | ||
PR_SERV_EMPL_ID | VARCHAR2(12) | NO | ||
COUNTY_NAME | VARCHAR2(25) | NO | ||
TS_PD_REG_HRS_NO | NUMBER(5, 0) | NO | ||
PAY_PD_REG_HRS_NO | NUMBER(5, 0) | NO | ||
DISABLED_FL | VARCHAR2(1) | NO | ||
MOS_REVIEW_NO | NUMBER(5, 0) | NO | ||
CONT_NAME_1 | VARCHAR2(25) | NO | ||
CONT_NAME_2 | VARCHAR2(25) | NO | ||
CONT_PHONE_1 | VARCHAR2(20) | NO | ||
CONT_PHONE_2 | VARCHAR2(20) | NO | ||
CONT_REL_1 | VARCHAR2(15) | NO | ||
CONT_REL_2 | VARCHAR2(15) | NO | ||
UNION_EMPL_FL | VARCHAR2(1) | NO | ||
VISA_TYPE_CD![]() |
VARCHAR2(10) | YES | ||
VET_STATUS_S | VARCHAR2(1) | YES | ||
VET_STATUS_V | VARCHAR2(1) | YES | ||
VET_STATUS_O | VARCHAR2(1) | YES | ||
VET_STATUS_R | VARCHAR2(1) | YES | ||
ESS_PIN_ID | VARCHAR2(120) | YES | ||
PIN_UPDATED_FL | VARCHAR2(1) | NO | ||
S_ESS_COS_CD![]() |
VARCHAR2(2) | YES | ||
HOME_EMAIL_ID | VARCHAR2(60) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
VET_RELEASE_DT | DATE | YES | ||
CONTRACTOR_FL | VARCHAR2(1) | NO | ||
BLIND_FL | VARCHAR2(1) | YES | ||
VISA_DT | DATE | YES | ||
VET_STATUS_A | VARCHAR2(1) | YES | ||
VET_STATUS_D | VARCHAR2(1) | YES | ||
TIME_ENTRY_TYPE | VARCHAR2(40) | YES | ||
BADGE_GROUP | VARCHAR2(60) | YES | ||
BADGE_ID | VARCHAR2(60) | YES | ||
LOGIN_ID | VARCHAR2(60) | YES | ||
SFT_FL | VARCHAR2(1) | YES | ||
MES_FL | VARCHAR2(1) | YES | ||
CLOCK_FL | VARCHAR2(1) | YES | ||
PLANT_ID | VARCHAR2(30) | YES | ||
EMPL_SOURCE_CD | VARCHAR2(15) | YES | ||
SR_EXPORT_DT | DATE | YES | ||
BIRTH_CITY_NAME | VARCHAR2(25) | YES | ||
BIRTH_MAIL_STATE_DC | VARCHAR2(15) | YES | ||
BIRTH_COUNTRY_CD![]() |
VARCHAR2(8) | YES |
EMPL Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0041 | PrimaryKey | EMPL_ID |
EMPL Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
LV_PD | Non-Identifying | Zero or One to Zero or More | F00560 | LV_PD_CD | NO | NO | NO | ||
MAIL_STATE | Non-Identifying | Zero or One to Zero or More | F00570 | COUNTRY_CD, MAIL_STATE_DC | NO | NO | NO | ||
TAXBLE_ENTITY | Non-Identifying | Zero or One to Zero or More | F00590 | TAXBLE_ENTITY_ID | NO | NO | NO | ||
TS_PD | Non-Identifying | One To Zero or More | F00600 | TS_PD_CD | NO | NO | NO | ||
S_ESS_COS_CD | Non-Identifying | Zero or One to Zero or More | F21572 | S_ESS_COS_CD | NO | NO | NO | ||
VISA_TYPE | Non-Identifying | Zero or One to Zero or More | F21620 | VISA_TYPE_CD | NO | NO | NO | ||
COUNTRY | Non-Identifying | Zero or One to Zero or More | FK_EMPL_BI_IDX | BIRTH_COUNTRY_CD | NO | NO | NO | ||
COUNTRY | Non-Identifying | Zero or One to Zero or More | FK_EMPL_CC_IDX | COUNTRY_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
BUYER | Non-Identifying | One To Zero or More | F00440 | NO | NO | NO | |||
EMPL_LAB_CAT | Identifying | One To Zero or More | F00620 | NO | NO | NO | |||
EMPL_LV_ACCRL | Identifying | One To Zero or More | F00680 | NO | NO | NO | |||
EMPL_LV_HIST | Non-Identifying | One To Zero or More | F00710 | NO | NO | NO | |||
EMPL_LV_JNL | Identifying | One To Zero or More | F00750 | NO | NO | NO | |||
EMPL_PAY_TYPE_DFLT | Identifying | One To Zero or More | F00780 | NO | NO | NO | |||
DFLT_REG_TS | Identifying | One To Zero or More | F00820 | NO | NO | NO | |||
DFLT_OT_TS | Identifying | One To Zero or More | F00821 | NO | NO | NO | |||
H_EMPL_PERF_RECOG | Identifying | One To Zero or More | F0090 | NO | NO | NO | |||
EMPL_PHONE | Identifying | One To Zero or More | F00910 | NO | NO | NO | |||
INVT_TRN | Non-Identifying | One To Zero or More | F01260 | NO | NO | NO | |||
INVT_TRN | Non-Identifying | One To Zero or More | F01270 | NO | NO | NO | |||
JE_TRN_LAB_EMPL | Non-Identifying | One To Zero or More | F02000 | NO | NO | NO | |||
PROJ_EMPL | Identifying | One To Zero or More | F03830 | NO | NO | NO | |||
PROJ_EMPL_RT_SCH | Non-Identifying | One To Zero or More | F03900 | NO | NO | NO | |||
RECPT_HDR | Non-Identifying | One To Zero or More | F04220 | NO | NO | NO | |||
RES_HDR | Non-Identifying | One To Zero or More | F04420 | NO | NO | NO | |||
TS_HDR | Identifying | One To Zero or More | F04810 | NO | NO | NO | |||
PROJ | Non-Identifying | One To Zero or More | F06451 | NO | NO | NO | |||
VEND | Non-Identifying | One To Zero or More | F06468 | NO | NO | NO | |||
EMPL_CEIL | Identifying | One To Zero or More | F08242 | NO | NO | NO | |||
EMPL_DED | Identifying | One To Zero or More | F09070 | NO | NO | NO | |||
EMPL_CNTRB | Identifying | One To Zero or More | F09080 | NO | NO | NO | |||
EMPL_BANK_HDR | Identifying | One To Zero or More | F09100 | NO | NO | NO | |||
EMPL_PAYROLL | Identifying | One To Zero or More | F09120 | NO | NO | NO | |||
EMPL_EARNINGS | Identifying | One To Zero or More | F09125 | NO | NO | NO | |||
JE_TRN_LAB_EMPL_HS | Non-Identifying | One To Zero or More | F09248 | NO | NO | NO | |||
EMPL_LV_BAL | Identifying | One To Zero or More | F09335 | NO | NO | NO | |||
VEND_RTRN_HDR | Non-Identifying | One To Zero or More | F09393 | NO | NO | NO | |||
EMPL_ACCT_GRP_DFLT | Identifying | One To Zero or More | F09430 | NO | NO | NO | |||
EMPL_PROJ_TS_DFLT | Identifying | One To Zero or More | F09432 | NO | NO | NO | |||
EMPL_WKS_WORKED | Identifying | One To Zero or More | F09610 | NO | NO | NO | |||
EMPL_TAX | Identifying | One To Zero or More | F09761 | NO | NO | NO | |||
EMPL_TS_LN_TYPE_DF | Identifying | One To Zero or More | F09839 | NO | NO | NO | |||
ORG_MGR_DFLT | Non-Identifying | One To Zero or More | F09855 | NO | NO | NO | |||
ORG_MGR_DFLT | Non-Identifying | One To Zero or More | F09856 | NO | NO | NO | |||
ORG_MGR_DFLT | Non-Identifying | One To Zero or More | F09897 | NO | NO | NO | |||
EMPL_RF_S1_HDR | Identifying | One To Zero or More | F09918 | NO | NO | NO | |||
EMPL_RF_S2_HDR | Identifying | One To Zero or More | F09920 | NO | NO | NO | |||
EMPL_RF_S3 | Identifying | One To Zero or More | F09923 | NO | NO | NO | |||
EMPL_RF_S4 | Identifying | One To Zero or More | F09924 | NO | NO | NO | |||
EMPL_RF_S5 | Identifying | One To Zero or More | F09925 | NO | NO | NO | |||
HS_ORG_BUD_BY_EMPL | Identifying | One To Zero or More | F09934 | NO | NO | NO | |||
FED_W2_FILE | Identifying | One To Zero or More | F09974 | NO | NO | NO | |||
STATE_W2_FILE | Identifying | One To Zero or More | F09978 | NO | NO | NO | |||
LOCAL_W2_FILE | Identifying | One To Zero or More | F09981 | NO | NO | NO | |||
SALES_REP | Non-Identifying | One To Zero or More | F10054 | NO | NO | NO | |||
SO_ISSUE_HDR | Non-Identifying | One To Zero or More | F10093 | NO | NO | NO | |||
SHIP_TRN | Non-Identifying | One To Zero or More | F10102 | NO | NO | NO | |||
H_EMPL_DEPENDENT | Identifying | One To Zero or More | F20397 | NO | NO | NO | |||
H_NOTIF_LET_JNL | Non-Identifying | One To Zero or More | F20403 | NO | NO | NO | |||
H_CODA_EMPL_INFO | Identifying | One To Zero or More | F20408 | NO | NO | NO | |||
H_REL_EMPL_INFO | Non-Identifying | One To Zero or More | F20416 | NO | NO | NO | |||
H_DETL_POS_DESC | Non-Identifying | One To Zero or More | F20423 | NO | NO | NO | |||
H_ED_SKILL_TRAIN | Identifying | One To Zero or More | F20426 | NO | NO | NO | |||
H_EMPL_CAREER_PLAN | Non-Identifying | One To Zero or More | F20429 | NO | NO | NO | |||
H_EMPL_DOCS | Identifying | One To Zero or More | F20437 | NO | NO | NO | |||
H_EMPL_EXIT_INTV | Identifying | One To Zero or More | F20439 | NO | NO | NO | |||
H_EMPL_PHOTOS | Identifying | One To Zero or More | F20445 | NO | NO | NO | |||
H_EMPL_PROP | Identifying | One To Zero or More | F20448 | NO | NO | NO | |||
H_EMPL_SEC_STATUS | Identifying | One To Zero or More | F20464 | NO | NO | NO | |||
H_EMPL_VEHICLE_HDR | Identifying | One To Zero or More | F20471 | NO | NO | NO | |||
H_POS_RQ_RQST | Non-Identifying | One To Zero or More | F20485 | NO | NO | NO | |||
H_RQ_APPRVR | Identifying | One To Zero or More | F20486 | NO | NO | NO | |||
H_DETL_POS_DESC | Non-Identifying | One To Zero or More | F20539 | NO | NO | NO | |||
H_POS_RQ_RQST | Non-Identifying | One To Zero or More | F20541 | NO | NO | NO | |||
EMPL_PROJ_LT_DFLT | Identifying | One To Zero or More | F20612 | NO | NO | NO | |||
EMPL_PAG_LT_DFLT | Identifying | One To Zero or More | F20614 | NO | NO | NO | |||
EMPL_LT_DFLT | Identifying | One To Zero or More | F20621 | NO | NO | NO | |||
H_GRVNCE_HDR | Identifying | One To Zero or More | F20631 | NO | NO | NO | |||
PC_SUPERVISOR | Non-Identifying | One To Zero or More | F20686 | NO | NO | NO | |||
PLANNER | Non-Identifying | One To Zero or More | F20756 | NO | NO | NO | |||
TS_LN_MO | Identifying | One To Zero or More | F20827 | NO | NO | NO | |||
MO_ROUT_LN_COMPL | Non-Identifying | One To Zero or More | F20835 | NO | NO | NO | |||
MO_ROUT_LN_INSP | Non-Identifying | One To Zero or More | F20837 | NO | NO | NO | |||
HB_EMPL_PKG | Identifying | One To Zero or More | F20920 | NO | NO | NO | |||
HB_EMPL_DEP_BNFIC | Identifying | One To Zero or More | F20925 | NO | NO | NO | |||
HB_EMPL_LIFE | Identifying | One To Zero or More | F20927 | NO | NO | NO | |||
TS_LN_SO | Identifying | One To Zero or More | F20933 | NO | NO | NO | |||
BUD_CO_LN_HRS | Non-Identifying | One To Zero or More | F20969 | NO | NO | NO | |||
HB_DEP_FSA_ELEC | Identifying | One To Zero or More | F20982 | NO | NO | NO | |||
HB_MED_FSA_ELEC | Identifying | One To Zero or More | F20989 | NO | NO | NO | |||
HB_EMPL_QUAL_EVENT | Identifying | One To Zero or More | F20990 | NO | NO | NO | |||
HB_EMPL_MED_DATA | Identifying | One To Zero or More | F20992 | NO | NO | NO | |||
IMPACT_GRP_USER | Non-Identifying | Zero or One to Zero or More | F21036 | NO | NO | NO | |||
MAINT_GRP_USER | Non-Identifying | One To Zero or More | F21038 | NO | NO | NO | |||
EC_APP_TITLE_USER | Non-Identifying | One To Zero or More | F21063 | NO | NO | NO | |||
EMPL_ALLOW_CD | Identifying | One To Zero or More | F21271 | NO | NO | NO | |||
EMPL_DRUG_TEST | Identifying | One To Zero or More | F21308 | NO | NO | NO | |||
CREW_TS_LN | Identifying | One To Zero or More | F21323 | NO | NO | NO | |||
UNION_PROFLE_PROJ | Non-Identifying | One To Zero or More | F21334 | NO | NO | NO | |||
UNION_PROFLE_PROJ | Non-Identifying | One To Zero or More | F21336 | NO | NO | NO | |||
CREW_ASSIGN | Non-Identifying | One To Zero or More | F21343 | NO | NO | NO | |||
CREW_ASSIGN_SETUP | Identifying | One To Zero or More | F21345 | NO | NO | NO | |||
H_EMPL_CERT | Identifying | One To Zero or More | F21347 | NO | NO | NO | |||
H_EMPL_NOTES | Identifying | One To Zero or More | F21349 | NO | NO | NO | |||
H_EMPL_DISCPLN_ACT | Non-Identifying | One To Zero or More | F21405 | NO | NO | NO | |||
AUTOCR_ASSET_EDIT | Non-Identifying | One To Zero or More | F21419 | NO | NO | NO | |||
FA_TEMPLATE | Non-Identifying | One To Zero or More | F21422 | NO | NO | NO | |||
FA_AUTOCR_RECPT | Non-Identifying | One To Zero or More | F21460 | NO | NO | NO | |||
EMPL_SUP_ADR | Identifying | One To Zero or More | F21525 | NO | NO | NO | |||
HB_EMPL_CURR_ELEC | Identifying | One To Zero or More | F21538 | NO | NO | NO | |||
HB_EMPL_ESS_ELEC | Identifying | One To Zero or More | F21540 | NO | NO | NO | |||
HB_DEP_ESS_ELEC | Identifying | One To Zero or More | F21541 | NO | NO | NO | |||
HB_EMPL_ESS_LIFE | Identifying | One To Zero or More | F21542 | NO | NO | NO | |||
HB_EMPL_ESS_BNFIC | Identifying | One To Zero or More | F21543 | NO | NO | NO | |||
X_ESS_EMPL_DED | Identifying | One To Zero or More | F21569 | NO | NO | NO | |||
BOX_12_W2_FILE | Identifying | One To Zero or More | F21574 | NO | NO | NO | |||
H_AFF_PLAN_SETUP | Non-Identifying | One To Zero or More | F21578 | NO | NO | NO | |||
EMPL_BOND_HDR2 | Identifying | One To Zero or More | F21587 | NO | NO | NO | |||
H_OSHA_300_HDR | Non-Identifying | One To Zero or More | F21591 | NO | NO | NO | |||
EMPL_TAX_MULTI | Identifying | One To Zero or More | F21627 | NO | NO | NO | |||
EMPL_GARN_WAGE | Identifying | One To Zero or More | F21721 | NO | NO | NO | |||
EMPL_GRN | Identifying | One To Zero or More | F21772 | NO | NO | NO | |||
HS_EMPL_CEIL | Identifying | One To Zero or More | FK_HS_EMPL_CEIL_EM_IDX | NO | NO | NO | |||
SUTA_QTR_RPT_DATA | Identifying | One To Zero or More | FK_SUTA_QTR_RPT_DATA_EM_IDX | NO | NO | NO |