GVT_HEALTH_DRUG (SQL Table)	Index Back
GVT Sensitive Drug List GVT // This record is used to store the drugs that an employee has allergy or is sensitive to. It is part of the Health Card Panel group. You can create multiple rows for each employee.

GVT_HEALTH_DRUG

(SQL Table)

GVT Sensitive Drug List

GVT // This record is used to store the drugs that an employee has allergy or is sensitive to. It is part of the Health Card Panel group. You can create multiple rows for each employee.

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 GVT_SENSITV_DRUG Character(20) VARCHAR2(20) NOT NULL Drug Sensitivities

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	GVT_SENSITV_DRUG	Character(20)	VARCHAR2(20) NOT NULL	Drug Sensitivities