Table slot9.WORLD.TSTA.EMPLOYEES
This table stores the employee information. RMS users can be flagged as an employee in the admin screens
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
EJS_EMP_ID number 30
ASSIGNMENT_LOGS.EJS_EMP_ID AL_EMP_FK R
CALENDAR_SHIFT_USERS.EMPLOYEE_ID CALSHIFTU_EMP1_FK R
CERTIFICATION_EMPLOYEE.EJS_EMP_ID CERTEMP_EMP1_FK R
CITATION_EMPLOYEES.EJS_EMP_ID CITEMP_EMP1_FK R
COURSE_INSTANCE_EMPLOYEE.EJS_EMP_ID CRSIEMP_EMP1_FK R
DV_CRASHES.EMPLOYEE_ID CRASH_EMP1_FK R
DV_OFFICERS.EMPLOYEE_ID DVOFF_EMP1_FK R
EMP_LANGUAGE_VW.EJS_EMP_ID Implied Constraint R
EMP_LANGUAGES.EJS_EMP_ID EMP_LANG_EMP1_FK R
EMP_RISK_LEVELS.EJS_EMP_ID EMPRSKL_EMP1_FK R
EMP_SCHEDULES.EJS_EMP_ID ES1_EMP1_FK R
EMP_SENIORITY_VW.EJS_EMP_ID Implied Constraint R
EMP_SERVICE_HISTORIES.EJS_EMP_ID EMPSRVHST_EMP1_FK R
EMP_SERVICE_HISTORY_VW.EJS_EMP_ID Implied Constraint R
EMP_VW.EJS_EMP_ID Implied Constraint R
EMPLOYEE_ADDRESSES.EJS_EMP_ID EMP_ADDR_EMP1_FK C
EMPLOYEE_AFFILIATIONS.EJS_EMP_ID EMPAFF_EMP1_FK R
EMPLOYEE_ATTACHMENTS.EJS_EMP_ID EMP1ATT_EMP1_FK C
EMPLOYEE_CLASSIFICATIONS.EJS_EMP_ID EMPCLS_EMP1_FK R
EMPLOYEE_CONTACTS.EJS_EMP_ID EMPCONT_EMP1_FK R
EMPLOYEE_EDUCATION.EJS_EMP_ID EMPEDU_EMP1_FK R
EMPLOYEE_GROUP_EMPLOYEES.EJS_EMP_ID EGEMPS_EMP1_FK R
EMPLOYEE_IMAGES.EMP_EJS_EMP_ID EMP_IMA_EMP1_FK R
EMPLOYEE_INFO.EJS_EMP_ID EMPINF_EMP1_FK R
EMPLOYEE_MEDICAL.EMPLOYEE_ID EMED_EMP_FK R
EMPLOYEE_MISC_IDS.EJS_EMP_ID EMPMISC_EMP1_FK R
EMPLOYEE_SALARY_VW.EJS_EMP_ID Implied Constraint R
EMPLOYEE_SKILLS.EJS_EMP_ID EMPSKILL_EMP1_FK R
EMPLOYEES.MASTER_EMP_ID EMP1_EMP1_FK R
ENROLLMENTS.EJS_EMP_ID ENR120_EMP1_FK R
EVIDENCE.EJS_EMP_ID EVI_EMP1_FK R
EVIDENCE_COC_MOST_RECENT_VW.EJS_EMP_ID Implied Constraint R
EVIDENCE_CUSTODY_VW.EJS_EMP_ID Implied Constraint R
EVIDENCE_STATUS_VW.EJS_EMP_ID Implied Constraint R
FLEET_MILEAGE_LOG.EMP_EJS_EMP_ID FML_EMP_FK R
INCIDENT_EMPLOYEES.EJS_IMP_ID INC_EMP_EMP_FK R
ITEM_CUSTODIES.EMPLOYEE_ID ITCU_EMP1_FK R
ITEM_INSPECTION_ITEMS.EMPLOYEE_ID ITINSPI_EMP1_FK R
ITEM_INSTANCES.EMPLOYEE_ID ITII_EMP1_FK R
JS_EVIDENCE_VW.EJS_EMP_ID Implied Constraint R
K9_ACTIVITY.EMPLOYEE_ID K9ACT_EMP1_FK R
K9_DEPLOYMENT.EMPLOYEE_ID K9DEP_EMP1_FK R
K9_DOGS.EMPLOYEE_ID K9DOG_EMP1_FK R
K9_TRAINING.EMPLOYEE_ID K9TRN_EMP1_FK R
PERSONNEL_CERT_SEARCH_VIEW.EJS_EMP_ID Implied Constraint R
PERSONNEL_COURSE_SEARCH_VIEW.EJS_EMP_ID Implied Constraint R
PERSONNEL_SEARCH_VIEW.EJS_EMP_ID Implied Constraint R
PHONES.EJS_EMP_ID PHONE_EMP1_FK R
PROPERTY_HOLD_CUSTODIES.EMPLOYEE_ID PROPHOCUST_EMP1_FK R
PROPERTY_HOLDS.DISPOSITION_EMPLOYEE_ID PROPHO_EMP1_FK R
SALARY.EMPLOYEE_ID SALY_EMP_FK R
SALARY.SUPERVISOR_ID SALY_S_EMP_FK R
TRAINING_EXPIRED_CERT_VW.EJS_EMP_ID Implied Constraint R
TRAINING_EXPIRED_COURSES_VW.EJS_EMP_ID Implied Constraint R
EJS sequence to uniquely identify an employee.
EMPLOYEE_ID varchar2 20  √  null Employee id from the agency.
EMERGENCY_PHONE varchar2 14  √  null The phone number to cal in case of emegency.
RANK varchar2 255  √  null The rank of the employee, if one applies.
LOGIN_ID varchar2 100  √  null
IJIS_USER_PROFILES.LOGIN_ID EMP1_IUP_1_FK R
The login ID for a user.
OFFICER_ID number 38  √  null
OFFICERS.OFFICER_ID EMP1_OFF_1_FK R
Officer ID number
ATT_ID number 6  √  null An id to uniquely identify a Public/Private Defender.
BLOOD_CODE varchar2 30  √  null
BLOOD_TYPE_CODES.CODE EMP1_BLOOD_CD_FK R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE EMP1_AGNCY_CD_FK R
Agency involved
CREATOR_ID varchar2 100  √  null Audit field.
CREATOR_DATE date 7  √  null Audit field.
UPDATOR_ID varchar2 100  √  null Audit field.
UPDATOR_DATE date 7  √  null Audit field.
EMP_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE EMP1_EMP_TYPE_CODE_EJS_CODE_FK R
DL_NUMBER varchar2 30  √  null
LONGEVITY_DATE date 7  √  null
DL_STATE_CODE varchar2 30  √  null
EJS_CODES.CODE EMP1_DL_STATE_CODE_EJS_CODE_FK R
SEX_CODE varchar2 30  √  null
EJS_CODES.CODE EMP1_SEX_CODE_EJS_CODE_FK R
TITLE_CODE varchar2 30  √  null
EJS_CODES.CODE EMP1_TITLE_CODE_EJS_CODE_FK R
ETHNICITY_CODE varchar2 30  √  null
EJS_CODES.CODE EMP1_ETHNICITY_COD_EJS_CODE_FK R
RACE_CODE varchar2 30  √  null
EJS_CODES.CODE EMP1_RACE_CODE_EJS_CODE_FK R
NUM_ASSIGNED number 6  √  null Number of assigned cases.
NUM_CLOSED number 6  √  null Number of closed cases.
NUM_PENDING number 6  √  null Number of pending cases.
LAST_ASSIGNED_DATE date 7  √  null Date last assigned.
ACTIVE varchar2 1 'Y'
DL_STATE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EMP1_DL_STATE_CODE_EJS_CODE_FK R
EMP_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EMP1_EMP_TYPE_CODE_EJS_CODE_FK R
ETHNICITY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EMP1_ETHNICITY_COD_EJS_CODE_FK R
RACE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EMP1_RACE_CODE_EJS_CODE_FK R
SEX_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EMP1_SEX_CODE_EJS_CODE_FK R
TITLE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EMP1_TITLE_CODE_EJS_CODE_FK R
REC_ID number 0  √  null
EMERGENCY_CONTACT varchar2 255  √  null
SUFFIX varchar2 30  √  null Employee Suffix
EMPLOYEE_LEVEL_CODE varchar2 30  √  null
EJS_CODES.CODE EMP1_LEVEL_CODE_EJS_CD_FK R
Employee Level Code
EMPLOYEE_LEVEL_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EMP1_LEVEL_CODE_EJS_CD_FK R
Employee Level Code Type
DATE_HIRED date 7  √  null Employee Hire Date
BARGAINING_UNIT varchar2 30  √  null Employee Bargaining Unit
HAND_DOMINANCE_CODE varchar2 30  √  null
EJS_CODES.CODE EMP1_HAND_CODE_EJS_CD_FK R
Employee Hand Dominance Code
HAND_DOMINANCE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EMP1_HAND_CODE_EJS_CD_FK R
Employee Hand Dominance Code Type
SWORN_FLAG varchar2 1  √  null Employee Sworn Y/N Flag
START_DATE date 7  √  null Employee Start Date
END_DATE date 7  √  null Employee End Date
ACTIVE_STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE EMP1_ACTIVE_CD_EJS_CD_FK R
Employee Active Status Code
ACTIVE_STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EMP1_ACTIVE_CD_EJS_CD_FK R
Employee Active Status Code Type
MASTER_EMP_ID number 30  √  null
EMPLOYEES.EJS_EMP_ID EMP1_EMP1_FK R
Master Employee ID Foreign Keys To Most Recent Employee ID
ENC_SSN raw 32  √  null The social security number for the employee.
ENC_DOB raw 32  √  null The date the employee was born.
ENC_PLACE_OF_BIRTH raw 512  √  null The place the employee was born.
ENC_LNAME raw 64  √  null The last name of the employee
ENC_FNAME raw 64  √  null The first name of the employee.
ENC_MNAME raw 64  √  null
ENC_MAIDEN_NAME raw 64  √  null Employee Maiden Name

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
ACTIVE IN ('Y', 'N') CK_EMP1_ACTIVE
"ACTIVE" IS NOT NULL EMP1_ACTIVE_NN
"AGENCY_CODE" IS NOT NULL EMP1_AGENCY_CODE_NN
"EJS_EMP_ID" IS NOT NULL EMP1_EJS_EMP_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
EJS_EMP_ID Primary key Asc EMP1_PK
ACTIVE_STATUS_CODE_TYPE + ACTIVE_STATUS_CODE Performance Asc/Asc EMP1_ACTIVE_CD_EJS_CD_FK_I
AGENCY_CODE Performance Asc EMP1_AGNCY_CD_FK_I
BLOOD_CODE Performance Asc EMP1_BLOOD_CD_FK_I
DL_STATE_CODE_TYPE + DL_STATE_CODE Performance Asc/Asc EMP1_DL_STATE_CODE_EJS_CODE_I
MASTER_EMP_ID Performance Asc EMP1_EMP1_FK_I
EMP_TYPE_CODE_TYPE + EMP_TYPE_CODE Performance Asc/Asc EMP1_EMP_TYPE_CODE_EJS_CODE_I
EMP_TYPE_CODE Performance Asc EMP1_ETC_FK_I
ETHNICITY_CODE Performance Asc EMP1_ETH_CD_FK_I
ETHNICITY_CODE_TYPE + ETHNICITY_CODE Performance Asc/Asc EMP1_ETHNICITY_COD_EJS_CODE_I
HAND_DOMINANCE_CODE_TYPE + HAND_DOMINANCE_CODE Performance Asc/Asc EMP1_HAND_CODE_EJS_CD_FK_I
LOGIN_ID Performance Asc EMP1_IUP_1_FK_I
EMPLOYEE_LEVEL_CODE_TYPE + EMPLOYEE_LEVEL_CODE Performance Asc/Asc EMP1_LEVEL_CODE_EJS_CD_FK_I
OFFICER_ID Performance Asc EMP1_OFF_1_FK_I
RACE_CODE_TYPE + RACE_CODE Performance Asc/Asc EMP1_RACE_CODE_EJS_CODE_I
RACE_CODE Performance Asc EMP1_RACE_FK_I
SEX_CODE_TYPE + SEX_CODE Performance Asc/Asc EMP1_SEX_CODE_EJS_CODE_I
SEX_CODE Performance Asc EMP1_SEX_FK_I
DL_STATE_CODE Performance Asc EMP1_STATE_CD_FK_I
TITLE_CODE Performance Asc EMP1_TC1_FK_I
TITLE_CODE_TYPE + TITLE_CODE Performance Asc/Asc EMP1_TITLE_CODE_EJS_CODE_I

Close relationships  within of separation: