HS_VACCINE_VW(SQL View) |
Index Back |
---|---|
Vaccine TableThe Vaccine Table is used to maintain vaccine information that can be later associated with employees who receive Immunization. |
SELECT A.SETID , A.IMMUN_CODE , A.HS_MANUFACTURER_ID , B.DESCR50 , A.EFFDT FROM PS_HS_VACCINE_TBL A , PS_HS_MANUFACT_TBL B WHERE %EffdtCheck(HS_VACCINE_TBL A1, A, %CurrentDateIn) AND A.SETID = B.SETID AND A.HS_MANUFACTURER_ID = B.HS_MANUFACTURER_ID AND %EffdtCheck(HS_MANUFACT_TBL B1, B, %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_08 |
|
2 | Character(4) | VARCHAR2(4) NOT NULL | Vaccine | |
3 | Character(4) | VARCHAR2(4) NOT NULL | Health and safety manufacturer id | |
4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
5 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |