EMPLIDPrompt Table: PERSON
ACTION_DT_SSDefault Value: %date
EFFSEQDefault Value: 0
HS_EMPLIDPrompt Table: HS_PER_ORG_ASGN
REG_REGIONPrompt Table: REG_REGION_TBL
IMMUN_CODEPrompt Table: HS_IMMUN_TBL
START_DATELANGUAGE_CDHS_AWE_IMMUN_LV(SQL View) |
Index Back |
|---|---|
Immunization Details for AWEImmunization Details related language record for AWE. |
| SELECT HS.EMPLID , HS.ACTION_DT_SS , HS.EFFSEQ , HS.HS_EMPLID , HS.REG_REGION , HS.IMMUN_CODE , HS.START_DATE , L.LANGUAGE_CD , COALESCE(( SELECT NL.NAME_DISPLAY FROM PS_NAMES_LNG NL WHERE NL.EMPLID = HS.EMPLID AND NL.NAME_TYPE = 'PRI' AND NL.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(NAMES_LNG NL1, NL, %CurrentDateIn)), ( SELECT N.NAME_DISPLAY FROM PS_NAMES N WHERE N.EMPLID = HS.EMPLID AND N.NAME_TYPE = 'PRI' AND %EffdtCheck(NAMES N1, N, %CurrentDateIn)), ' ') , COALESCE(( SELECT HSL.DESCR100 FROM PS_HS_SS_IMMUN_LNG HSL WHERE HSL.EMPLID = HS.EMPLID AND HSL.ACTION_DT_SS = HS.ACTION_DT_SS AND HSL.EFFSEQ = HS.EFFSEQ AND HSL.HS_EMPLID = HS.HS_EMPLID AND HSL.REG_REGION = HS.REG_REGION AND HSL.IMMUN_CODE = HS.IMMUN_CODE AND HSL.START_DATE = HS.START_DATE AND HSL.LANGUAGE_CD = L.LANGUAGE_CD), ( SELECT HSD.DESCR100 FROM PS_HS_SS_IMMUN_DAT HSD WHERE HSD.EMPLID = HS.EMPLID AND HSD.ACTION_DT_SS = HS.ACTION_DT_SS AND HSD.EFFSEQ = HS.EFFSEQ AND HSD.HS_EMPLID = HS.HS_EMPLID AND HSD.REG_REGION = HS.REG_REGION AND HSD.IMMUN_CODE = HS.IMMUN_CODE AND HSD.START_DATE = HS.START_DATE), ' ') , ' ' , COALESCE(( SELECT IML.DESCR FROM PS_HS_IMMUN_LANG IML WHERE IML.SETID = RR.SETID AND IML.IMMUN_CODE = HS.IMMUN_CODE AND IML.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(HS_IMMUN_LANG IML1, IML, %CurrentDateIn)), ( SELECT IM1.DESCR FROM PS_HS_IMMUN_TBL IM1 WHERE IM1.SETID = RR.SETID AND IM1.IMMUN_CODE = HS.IMMUN_CODE AND %EffdtCheck(HS_IMMUN_TBL IMED, IM1, %CurrentDateIn)), ' ') , ' ' , ' ' , HS.HS_VACC_COMPLETE , HS.HS_DECLINE_VACCINE FROM PS_HS_SS_IMMUN_DAT HS, PS_SET_CNTRL_GROUP RR, PSLANGUAGES L WHERE HS.REG_REGION=RR.SETCNTRLVALUE AND RR.REC_GROUP_ID = 'HR_08' |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 9 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 10 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 11 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 13 | DESCR50_1 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 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 |