PHYSICAL_EXAM(SQL Table) |
Index Back |
---|---|
EE Physical ExamsUse PHYSICAL_EXAM to record information about physical examinations administered to the employee. This data is part of the Health and Safety module. |
# | 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 | NEXT_EXAM_DT | Date(10) | DATE | Next Exam Date |
5 | BASELINE | Character(1) | VARCHAR2(1) NOT NULL |
Baseline
Y/N Table Edit Default Value: N |
6 | PHYSICIAN_ID | Character(11) | VARCHAR2(11) NOT NULL |
Physician ID
Prompt Table: PHYSICIAN_SRCH |
7 | PHYSICIAN_NAME | Character(50) | VARCHAR2(50) NOT NULL | Physician Name |
8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: SCC_CNT_ADFMTVW |
9 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
10 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
11 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
12 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
13 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
14 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
15 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
16 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
17 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
18 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
19 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
20 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
21 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
22 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
23 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
24 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
25 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
26 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
27 | ORGAN_DONOR | Character(1) | VARCHAR2(1) NOT NULL |
Organ Donor
Y/N Table Edit Default Value: N |
28 | BLOOD_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Blood Type
A+=A+ A-=A- AB+=AB+ AB-=AB- B+=B+ B-=B- O+=O+ O-=O- U=Unknown Default Value: U |
29 | BLOOD_DONOR | Character(1) | VARCHAR2(1) NOT NULL |
Blood Donor
Y/N Table Edit Default Value: N |
30 | 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 |
31 | REFERRAL | Character(1) | VARCHAR2(1) NOT NULL |
Referral
A=Audiologist E=Employee Assistance Program H=Hospital N=None Required O=Optometrist P=Personal Physician S=Specialist |
32 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
33 | CAPABILITY_CD_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Work Capability
A=Able To Work Normally I=Unable to work R=Able To Work With Restrictions Default Value: A |
34 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table: REG_REGION_TBL |
35 | HS_TIMEZONE1 | Character(9) | VARCHAR2(9) NOT NULL |
Health and Safety Time Zone Field 1
Prompt Table: PSTIMEZONE |
36 | EXAM_TM_FRA | Time(15) | TIMESTAMP | Exam Time |
37 | NEXT_EXAM_TM_FRA | Time(15) | TIMESTAMP | Next Exam Time |
38 | PHYDIS_TYPE_CD_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Disability Type
P=Partial Disability T=Total Disability |
39 | PHYDIS_TIME_CD_FRA | Character(3) | VARCHAR2(3) NOT NULL |
Disability Period
PAR=Temporary Disability PER=Permanent Disability |
40 | PHYDIS_FROM_DT_FRA | Date(10) | DATE | From Date |
41 | PHYDIS_TO_DT_FRA | Date(10) | DATE | To Date |
42 | MEDICAL_ORG_FRA_CD | Character(3) | VARCHAR2(3) NOT NULL |
Medical Organism Code - FRA
Prompt Table: MED_ORG_FRA_TBL |
43 | FP_NEXT_EXAM_TYP | Character(3) | VARCHAR2(3) NOT NULL |
Next Medical Exam Type
ANN=Annual Medical exam DEP=Drug Testing FOR=Fitness PRE=Pre_Employment SUR=Routine Exam |
44 | COMMENTS | Long Character | CLOB | Comment |
45 | GVT_EXAM_TIME_IN | Time(15) | TIMESTAMP | GVT Exam Time In |
46 | GVT_EXAM_TIME_OUT | Time(15) | TIMESTAMP | GVT Exam Time Out |
47 | GVT_OVERALL_HEALTH | Character(1) | VARCHAR2(1) NOT NULL |
Overall Health
E=Excellent F=Failing G=Good P=Poor T=Terminal |