HS_VACC_DTL_DAT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Region
4	IMMUN_CODE	Character(4)	VARCHAR2(4) NOT NULL	Immunization Code
5	START_DATE	Date(10)	DATE	Date
6	HS_VACC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Indicates if an employee has completed the vaccine series. D=Vaccine Declined N=Partially Vaccinated U=Not Vaccinated Y=Fully Vaccinated
7	VACCINE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Vaccine
8	HS_MANUFACTURER_ID	Character(4)	VARCHAR2(4) NOT NULL	Health and safety manufacturer id
9	HS_DOSE_NUM	Character(1)	VARCHAR2(1) NOT NULL	Vaccine dose number 1=1st Dose 2=2nd Dose 3=3rd Dose 4=4th Dose 5=5th Dose
10	HS_LOT_NUM	Character(30)	VARCHAR2(30) NOT NULL	Vaccine lot number
11	HS_VACC_SITE	Character(1)	VARCHAR2(1) NOT NULL	Vaccination Site 1=Workplace 2=Other
12	HS_LOCATION	Character(50)	VARCHAR2(50) NOT NULL	Location Name
13	HS_VACC_COMPLETE	Character(1)	VARCHAR2(1) NOT NULL	Indicates if an employee has completed the vaccine series. N=No Y=Yes
14	HS_NEXT_DUE_DATE	Date(10)	DATE	Next due date for a vaccine
15	HS_DECLINE_VACCINE	Character(1)	VARCHAR2(1) NOT NULL	Indicates if employee declines a vaccine N=No Y=Yes
16	HS_DECLINE_REASON	Character(1)	VARCHAR2(1) NOT NULL	Reason for declining a vaccine A=Allergic Reaction M=Medical Exemption O=Other P=Personal Reasons R=Religious Beliefs
17	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
18	HS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Last Updated
19	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.