GVT_HEALTH_TEST (SQL Table)	Index Back
GVT Previous Health Card Tests GVT // This record is used to store the Tests an employee has previously taken. It is part of the Health Card Panel group. You can create multiple rows for each employee.

GVT_HEALTH_TEST

(SQL Table)

GVT Previous Health Card Tests

GVT // This record is used to store the Tests an employee has previously taken. 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_PRE_TST_DT Date(10) DATE NOT NULL GVT Previously Taken Test Date

3 GVT_PREV_TESTS Character(20) VARCHAR2(20) NOT NULL GVT Previous Tests

#	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_PRE_TST_DT	Date(10)	DATE NOT NULL	GVT Previously Taken Test Date
3	GVT_PREV_TESTS	Character(20)	VARCHAR2(20) NOT NULL	GVT Previous Tests