SCC_EYE_EXA_QVW

(SQL View)
 Index Back

Eye 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.FAR_L_COR1 , A.FAR_L_COR2 , A.FAR_L_UNCOR1 , A.FAR_L_UNCOR2 , A.FAR_R_COR1 , A.FAR_R_COR2 , A.FAR_R_UNCOR1 , A.FAR_R_UNCOR2 , A.NEAR_L_COR1 , A.NEAR_L_COR2 , A.NEAR_L_UNCOR1 , A.NEAR_L_UNCOR2 , A.NEAR_R_COR1 , A.NEAR_R_COR2 , A.NEAR_R_UNCOR1 , A.NEAR_R_UNCOR2 , A.COLOR_VIS_RESULTS , A.CORRECTION_REQD , A.REFERRAL , A.DESCR , A.COMMENTS FROM PS_EYE_EXAM A

  • Related Language Record: EYE_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 FAR_L_COR1 Number(2,0) SMALLINT NOT NULL Far Left Corrected 1
    28 FAR_L_COR2 Number(3,0) SMALLINT NOT NULL Far Left Corrected 2
    29 FAR_L_UNCOR1 Number(2,0) SMALLINT NOT NULL Far Left Uncorrected 1
    30 FAR_L_UNCOR2 Number(3,0) SMALLINT NOT NULL Far Left Uncorrected 2
    31 FAR_R_COR1 Number(2,0) SMALLINT NOT NULL Far Right Corrected 1
    32 FAR_R_COR2 Number(3,0) SMALLINT NOT NULL Far Right Corrected 2
    33 FAR_R_UNCOR1 Number(2,0) SMALLINT NOT NULL Far Right Uncorrected 1
    34 FAR_R_UNCOR2 Number(3,0) SMALLINT NOT NULL Far Right Uncorrected 2
    35 NEAR_L_COR1 Number(2,0) SMALLINT NOT NULL Near Left Corrected 1
    36 NEAR_L_COR2 Number(3,0) SMALLINT NOT NULL Near Left Corrected 2
    37 NEAR_L_UNCOR1 Number(2,0) SMALLINT NOT NULL Near Left Uncorrected 1
    38 NEAR_L_UNCOR2 Number(3,0) SMALLINT NOT NULL Near Left Uncorrected 2
    39 NEAR_R_COR1 Number(2,0) SMALLINT NOT NULL Near Right Corrected 1
    40 NEAR_R_COR2 Number(3,0) SMALLINT NOT NULL Near Right Corrected 2
    41 NEAR_R_UNCOR1 Number(2,0) SMALLINT NOT NULL Near Right Uncorrected 1
    42 NEAR_R_UNCOR2 Number(3,0) SMALLINT NOT NULL Near Right Uncorrected 2
    43 COLOR_VIS_RESULTS Character(1) VARCHAR2(1) NOT NULL Color Vision Results
    A=Abnormal
    N=Normal

    Default Value: N

    44 CORRECTION_REQD Character(1) VARCHAR2(1) NOT NULL Correction Required

    Y/N Table Edit

    Default Value: N

    45 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
    46 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    47 COMMENTS Long Character CLOB Comment