P_EXAM_RESULT (SQL Table)	Index Back
EE Physical Exams Use PHYSICAL_EXAM to record information about physical examinations administered to the employee. This data is part of the Health and Safety module.

P_EXAM_RESULT

(SQL Table)

EE Physical Exams

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

Parent record: PER_ORG_ASGN_VW

# 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

5 EXAM_RESULTS Character(1) VARCHAR2(1) NOT NULL Exam Results
A=Partial Pass
F=Fail
M=Monitoring Required
N=No Show for Exam
P=Pass

#	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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	EXAM_RESULTS	Character(1)	VARCHAR2(1) NOT NULL	Exam Results A=Partial Pass F=Fail M=Monitoring Required N=No Show for Exam P=Pass