SCC_PHYS_EX_QVW

(SQL View)
 Index Back

Physical Exams Query View


SELECT A.EMPLID , A.EXAM_DT , A.EXAM_TYPE_CD , A.NEXT_EXAM_DT , A.BASELINE , A.PHYSICIAN_ID , A.PHYSICIAN_NAME , %subrec(ADDRESS_SBR, A) , %subrec(PHONE_SBR, A) , A.ORGAN_DONOR , A.BLOOD_TYPE , A.BLOOD_DONOR , A.EXAM_RESULTS , A.REFERRAL , A.DESCR , %subrec(P_EXAMFRA_SBR, A) , %subrec(PHYS_EXA_FP_SBR, A) , A.COMMENTS , %subrec(EXAM_FED_SBR, A) FROM PS_PHYSICAL_EXAM A

  • Related Language Record: PHYS_EXAM_LANG

    • # 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