PHYEXAM_IND_VW(SQL View) |
Index Back |
|---|---|
Physical Exam - View |
| SELECT A.EMPLID ,A.EXAM_DT ,A.EXAM_TYPE_CD , A.BLOOD_TYPE FROM PS_PHYSICAL_EXAM A WHERE A.BLOOD_TYPE <> ' ' AND A.EXAM_DT = ( SELECT MAX( B.EXAM_DT) FROM PS_PHYSICAL_EXAM B WHERE A.EMPLID = B.EMPLID AND A.EXAM_TYPE_CD = B.EXAM_TYPE_CD AND B.BLOOD_TYPE <> ' ') |
| # | 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 | Exam 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 | 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 |