AUDIO_TST_LANG (SQL Table)	Index Back
Audiometric Exams - RelLang Use AUDIOMETRIC_TST to record information about hearing examinations administered to the employee. This data is part of the Health and Safety module.

AUDIO_TST_LANG

(SQL Table)

Audiometric Exams - RelLang

Use AUDIOMETRIC_TST to record information about hearing examinations administered to the employee. This data is part of the Health and Safety module.

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 EXAM_DT Date(10) DATE NOT NULL Exam Date
Default Value: %date

3 EXAM_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Type of Exam
ANN=Annual
BIE=Biennal
DOT=Department of Transport
DRG=Drug Screening
EXP=Exposure
FFD=Fit for Duty
GEN=General Health
HTB=Inspection for Tuberculosis
LRH=Labor-Related Health
NEW=New Hire
OTP=Pre-Overseas Transfer
OTT=Post-Overseas Transfer
PRE=Pre-Employment
PSV=Periodic Surveillance
TUB=Tuberculosis

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

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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 Prompt Table: PERSON
2	EXAM_DT	Date(10)	DATE NOT NULL	Exam Date Default Value: %date
3	EXAM_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Type of Exam ANN=Annual BIE=Biennal DOT=Department of Transport DRG=Drug Screening EXP=Exposure FFD=Fit for Duty GEN=General Health HTB=Inspection for Tuberculosis LRH=Labor-Related Health NEW=New Hire OTP=Pre-Overseas Transfer OTT=Post-Overseas Transfer PRE=Pre-Employment PSV=Periodic Surveillance TUB=Tuberculosis
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	COMMENTS	Long Character	CLOB	Comment