HS_VACCINE_VW (SQL View)	Index Back
Vaccine Table The Vaccine Table is used to maintain vaccine information that can be later associated with employees who receive Immunization.

HS_VACCINE_VW

(SQL View)

Vaccine Table

The 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)

Related Language Record: HS_VACCINE_LVW

Parent record: HS_IMMUN_TBL

# 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 Vaccine

3 HS_MANUFACTURER_ID Character(4) VARCHAR2(4) NOT NULL Health and safety manufacturer id

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

5 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

#	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	Vaccine
3	HS_MANUFACTURER_ID	Character(4)	VARCHAR2(4) NOT NULL	Health and safety manufacturer id
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date