HS_SS_IMMUN_DAT

(SQL Table)
 Index Back

SS Vaccine Details

Vaccine Details workflow record for self service.

  • Related Language Record: HS_SS_IMMUN_LNG

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

    Prompt Table: PERSON

    2 ACTION_DT_SS Date(10) DATE NOT NULL Transaction Date
    3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    4 HS_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID for Health and Safety

    Prompt Table: HS_PER_ORG_ASGN

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

    Prompt Table: REG_REGION_TBL

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

    Prompt Table: HS_IMMUN_TBL

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

    Prompt Table: HS_MANUFACT_TBL

    11 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
    12 HS_LOT_NUM Character(30) VARCHAR2(30) NOT NULL Vaccine lot number
    13 HS_VACC_SITE Character(1) VARCHAR2(1) NOT NULL Vaccination Site
    1=Workplace
    2=Other
    14 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

    Prompt Table: SET_VLD_HR_03

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

    Prompt Table: HS_LOCATION_VW

    16 HS_LOCATION Character(50) VARCHAR2(50) NOT NULL Location Name
    17 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

    18 HS_NEXT_DUE_DATE Date(10) DATE Next due date for a vaccine
    19 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

    20 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
    21 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.
    22 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.
    23 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    24 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    25 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    26 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    27 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    28 CITY Character(30) VARCHAR2(30) NOT NULL City
    29 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    30 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    31 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    32 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    33 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    34 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    35 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    36 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    37 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    38 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    39 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
    40 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    41 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    42 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    43 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    44 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    45 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    46 SS_STAT_INDICATOR Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    A=Approved
    B=CI failed - Errors & Warnings
    C=Cancelled
    D=Denied
    E=Errors Encountered
    I=In Approval Process
    M=Administrator Action Required
    S=Success
    W=Warnings Encountered

    Default Value: I

    47 SS_WARNING_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

    Y/N Table Edit

    Default Value: N

    48 SS_FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

    Y/N Table Edit

    Default Value: N

    49 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
    A=Approved
    C=Cancelled
    D=Denied
    E=Error. Contact Administrator.
    F=Awaiting final approval
    I=In Approval Process
    M=Administrator is Processing
    N=Not Available
    P=Rework
    S=Submitted
    V=Data Saved
    50 HS_SS_STATUS Character(1) VARCHAR2(1) NOT NULL Health and Safety self-service status
    A=Received
    D=Employee Declined
    M=More Information Requested
    N=Request Denied
    P=In Progress
    R=Approved
    S=Submitted
    V=Recorded

    Default Value: P