EE_IMMUN_DTL

(SQL Table)
 Index Back

EE- Immunization Details Table

This is the Employee related Immunization Table. It is used to maintain allergy codes by REG_REGION.

  • Related Language Record: EE_IMMUN_LANG

  • Parent record: EE_IMMUN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_REGION_TBL

    3 IMMUN_CODE Character(4) VARCHAR2(4) NOT NULL Immunization Code

    Prompt Table: HS_IMMUN_TBL

    4 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
    5 END_DATE Date(10) DATE End Date
    6 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    7 HS_MANUFACTURER_ID Character(4) VARCHAR2(4) NOT NULL Health and safety manufacturer id

    Prompt Table: HS_VACCINE_VW

    8 HS_DOSE_NUM Character(1) VARCHAR2(1) NOT NULL Vaccine dose number
    1=1st Dose
    2=2nd Dose
    3=3rd Dose
    4=4th Dose
    5=5th Dose
    9 HS_LOT_NUM Character(30) VARCHAR2(30) NOT NULL Vaccine lot number
    10 HS_VACC_SITE Character(1) VARCHAR2(1) NOT NULL Vaccination Site
    1=Workplace
    2=Other
    11 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

    Prompt Table: SET_VLD_HR_03

    12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: HS_LOCATION_VW

    13 HS_LOCATION Character(50) VARCHAR2(50) NOT NULL Location Name
    14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    15 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    16 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    17 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    18 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    19 CITY Character(30) VARCHAR2(30) NOT NULL City
    20 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    21 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    22 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    23 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    24 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    25 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    26 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    27 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    28 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    29 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    30 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    31 HS_VACC_COMPLETE Character(1) VARCHAR2(1) NOT NULL Indicates if an employee has completed the vaccine series.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    32 HS_NEXT_DUE_DATE Date(10) DATE Next due date for a vaccine
    33 HS_DECLINE_VACCINE Character(1) VARCHAR2(1) NOT NULL Indicates if employee declines a vaccine
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    34 HS_DECLINE_REASON Character(1) VARCHAR2(1) NOT NULL Reason for declining a vaccine
    A=Allergic Reaction
    M=Medical Exemption
    O=Other
    P=Personal Reasons
    R=Religious Beliefs
    35 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    36 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.