HS_AWE_IMMUN_VW(SQL View) |
Index Back |
|---|---|
Immunization Details for AWEImmunization Details record for AWE. |
| SELECT HS1.EMPLID , HS1.ACTION_DT_SS , HS1.EFFSEQ , HS1.HS_EMPLID , HS1.REG_REGION , HS1.IMMUN_CODE , HS1.START_DATE , NM.NAME_DISPLAY , HS1.DESCR100 , ' ' , IM.DESCR , ' ' , HS1.HS_MANUFACTURER_ID , ' ' , HS1.HS_VACC_COMPLETE , HS1.HS_DECLINE_VACCINE , HS1.HS_DECLINE_VACCINE FROM PS_HS_SS_IMMUN_DAT HS1 , PS_PERSON_NAME NM , PS_SET_CNTRL_GROUP RR , PS_HS_IMMUN_TBL IM WHERE NM.EMPLID = HS1.EMPLID AND HS1.REG_REGION=RR.SETCNTRLVALUE AND RR.REC_GROUP_ID = 'HR_08' AND RR.SETID=IM.SETID AND HS1.IMMUN_CODE=IM.IMMUN_CODE AND IM.EFFDT=( SELECT MAX(I.EFFDT) FROM PS_HS_IMMUN_TBL I WHERE I.SETID=RR.SETID AND I.IMMUN_CODE=HS1.IMMUN_CODE AND I.EFF_STATUS='A' AND I.EFFDT <=%CurrentDateIn) |
| # | 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
Default Value: %date |
| 3 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL |
Effective Sequence
Default Value: 0 |
| 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 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 9 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 10 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 12 | DESCR50_1 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 13 | HS_MANUFACTURER_ID | Character(4) | VARCHAR2(4) NOT NULL |
Health and safety manufacturer id
Prompt Table: HS_MANUFACT_TBL |
| 14 | ADDRESSLONG | Long Character | CLOB | Address Long |
| 15 | HS_VAC_CMPL_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Vaccination complete description |
| 16 | HS_VAC_DECL_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Declined Vaccine description |
| 17 | HS_DECLINE_VACCINE | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if employee declines a vaccine
N=No Y=Yes |