GVT_DRUG_T_LANG (SQL Table)	Index Back
EE Drug Test Tracking Use GVT_DRUG_TEST to record information about drug testing administered to the employee. This data is part of the Health and Safety module. Related Language record for GVT_DRUG_TEST.

GVT_DRUG_T_LANG

(SQL Table)

EE Drug Test Tracking

Use GVT_DRUG_TEST to record information about drug testing administered to the employee. This data is part of the Health and Safety module. Related Language record for GVT_DRUG_TEST.

Related Language Record for GVT_DRUG_TEST

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EXAM_DT Date(10) DATE NOT NULL Exam Date

3 GVT_DRUG_TEST_TYPE Character(1) VARCHAR2(1) NOT NULL Drug Testing Type
F=For Cause
M=Mandatory
R=Random

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 PHYSICIAN_NAME Character(50) VARCHAR2(50) NOT NULL Physician Name

6 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EXAM_DT	Date(10)	DATE NOT NULL	Exam Date
3	GVT_DRUG_TEST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Drug Testing Type F=For Cause M=Mandatory R=Random
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	PHYSICIAN_NAME	Character(50)	VARCHAR2(50) NOT NULL	Physician Name
6	COMMENTS	Long Character	CLOB	Comment