PPP_PAR_EXM_BRA(SQL Table) |
Index Back |
---|---|
PPP Parameters Exam TypesPPP Parameters Exam Types |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PPP_PARAM_ID | Character(10) | VARCHAR2(10) NOT NULL | PPP Parameter ID |
2 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | 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 |
5 | MED_EXAM_TYPE_BRA | Character(3) | VARCHAR2(3) NOT NULL |
Medical Exam Type
AUD=Audiometric Exam EYE=Eye Exam PHY=Physical Exam RES=Respiratory Exam |