HS_VACC_DTL_VW

(SQL View)
 Index Back

Vaccination Details


SELECT A.EMPLID , A.EMPL_RCD , A.REG_REGION , A.IMMUN_CODE , A.START_DATE , A.HS_VACC_STATUS , A.VACCINE_DESCR , A.HS_MANUFACTURER_ID , A.HS_DOSE_NUM , A.HS_LOT_NUM , A.HS_VACC_SITE , A.HS_LOCATION , A.HS_VACC_COMPLETE , A.HS_NEXT_DUE_DATE , A.HS_DECLINE_VACCINE , A.HS_DECLINE_REASON , A.DESCR50 , A.HS_LASTUPDDTTM , A.LASTUPDDTTM FROM PS_HS_VACC_DTL_DAT A

  • Related Language Record: HS_VACC_DTL_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 REG_REGION Character(5) VARCHAR2(5) NOT NULL Region
    4 IMMUN_CODE Character(4) VARCHAR2(4) NOT NULL Immunization Code
    5 START_DATE Date(10) DATE Date
    6 HS_VACC_STATUS Character(1) VARCHAR2(1) NOT NULL Indicates if an employee has completed the vaccine series.
    D=Vaccine Declined
    N=Partially Vaccinated
    U=Not Vaccinated
    Y=Fully Vaccinated
    7 VACCINE_DESCR Character(30) VARCHAR2(30) NOT NULL Vaccine
    8 HS_MANUFACTURER_ID Character(4) VARCHAR2(4) NOT NULL Health and safety manufacturer id
    9 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
    10 HS_LOT_NUM Character(30) VARCHAR2(30) NOT NULL Vaccine lot number
    11 HS_VACC_SITE Character(1) VARCHAR2(1) NOT NULL Vaccination Site
    1=Workplace
    2=Other
    12 HS_LOCATION Character(50) VARCHAR2(50) NOT NULL Location Name
    13 HS_VACC_COMPLETE Character(1) VARCHAR2(1) NOT NULL Indicates if an employee has completed the vaccine series.
    N=No
    Y=Yes
    14 HS_NEXT_DUE_DATE Date(10) DATE Next due date for a vaccine
    15 HS_DECLINE_VACCINE Character(1) VARCHAR2(1) NOT NULL Indicates if employee declines a vaccine
    N=No
    Y=Yes
    16 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
    17 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    18 HS_LASTUPDDTTM DateTime(26) TIMESTAMP Last Updated
    19 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.