HS_IMMUN_TBL

(SQL Table)
 Index Back

Immunization Table

The Immunization Table is used to maintain Immunization codes that can be later associated with employees who receive Immunization.

  • Related Language Record: HS_IMMUN_LANG

  • Parent Record Of HS_VACCINE_TBL HS_VACCINE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_VLD_HR_08

    2 IMMUN_CODE Character(4) VARCHAR2(4) NOT NULL Immunization Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 HS_YEARS_MONTHS Number(3,0) SMALLINT NOT NULL Years
    8 HS_SCHEDULE Character(4) VARCHAR2(4) NOT NULL Schedule
    M=Months
    Y=Years
    9 HS_ESS_AVAIL_FLG Character(1) VARCHAR2(1) NOT NULL Self-Service flag

    Y/N Table Edit

    Default Value: N

    10 HS_ENABLE_VAC_DTL Character(1) VARCHAR2(1) NOT NULL Display Manufacturer Details

    Y/N Table Edit

    Default Value: N

    11 HS_ENABLE_VAC_DUE Character(1) VARCHAR2(1) NOT NULL Display Next Due Date

    Y/N Table Edit

    Default Value: N

    12 HS_ENABLE_ATT Character(1) VARCHAR2(1) NOT NULL Enable Attachments (ATT) Flag

    Y/N Table Edit

    Default Value: N

    13 HS_REQUIRE_ATT Character(1) VARCHAR2(1) NOT NULL Enable Attachments (ATT) Flag

    Y/N Table Edit

    Default Value: N

    14 HS_ENABLE_ACK Character(1) VARCHAR2(1) NOT NULL Enable Acknowledgements (ACK) Flag

    Y/N Table Edit

    Default Value: N

    15 ESIGN_CATEGORY_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Category

    Prompt Table: ESIGN_CATEGORY

    16 ESIGN_ID Character(5) VARCHAR2(5) NOT NULL Acknowledgement ID

    Prompt Table: ESIGN_HDR

    17 HS_ENABLE_AWE Character(1) VARCHAR2(1) NOT NULL Enable Approval Workflow Engine (AWE) Flag

    Y/N Table Edit

    Default Value: N

    18 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

    Prompt Table: HS_AWE_PRCS_VW

    19 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID

    Prompt Table: HS_AWE_DEFN_VW