HS_VACCINE_TBL (SQL Table)	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_TBL

(SQL Table)

Vaccine Table

The Vaccine Table is used to maintain vaccine information that can be later associated with employees who receive Immunization.

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 Immunization Code

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

4 HS_MANUFACTURER_ID Character(4) VARCHAR2(4) NOT NULL Health and safety manufacturer id
Prompt Table: HS_MANUFACT_TBL

5 HS_AUTHORIZED Character(4) VARCHAR2(4) NOT NULL Authorization
EUA=Emergency Use
FDA=Approved for Use
NONE=Not Authorized

6 HS_SERIES Character(1) VARCHAR2(1) NOT NULL Series
1=1 Dose
2=2 Doses
3=3 Doses
4=4 Doses
5=5 Doses

7 HS_YEARS Number(3,0) SMALLINT NOT NULL Years

8 HS_MONTHS Number(2,0) SMALLINT NOT NULL Months

#	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	Immunization Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	HS_MANUFACTURER_ID	Character(4)	VARCHAR2(4) NOT NULL	Health and safety manufacturer id Prompt Table: HS_MANUFACT_TBL
5	HS_AUTHORIZED	Character(4)	VARCHAR2(4) NOT NULL	Authorization EUA=Emergency Use FDA=Approved for Use NONE=Not Authorized
6	HS_SERIES	Character(1)	VARCHAR2(1) NOT NULL	Series 1=1 Dose 2=2 Doses 3=3 Doses 4=4 Doses 5=5 Doses
7	HS_YEARS	Number(3,0)	SMALLINT NOT NULL	Years
8	HS_MONTHS	Number(2,0)	SMALLINT NOT NULL	Months