SCC_RESP_EX_QVW

(SQL View)
 Index Back

Respiratory 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.EXPOSURE_DT , A.EXPOSURE_TYPE , A.CONTAMINANT_AGENT , A.BUSINESS_UNIT , A.LOCATION , A.LOCATION_NAME , A.REFERRAL , A.DESCR , A.COMMENTS , %subrec(EXAM_FED_SBR, A) FROM %Table(RESPIRATORY_EXM) A

  • Related Language Record: RESPIR_EXAM_LNG

    • # 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 EXPOSURE_DT Date(10) DATE Date of Exposure
    28 EXPOSURE_TYPE Character(1) VARCHAR2(1) NOT NULL Exposure Type
    B=Biohazard
    C=Chemicals
    D=Dust
    F=Fumes
    H=High Atmosphere
    29 CONTAMINANT_AGENT Character(3) VARCHAR2(3) NOT NULL Contaminant Agent
    ASB=Asbestos
    BNP=Benzoyl Peroxide
    ETC=Ethyl Chloride
    LDA=Alkaline Lead
    LED=Lead
    MER=Mercury
    ORG=Organic Chemical Solvent
    RAD=Radiation
    SCD=Specific Chemical Disease
    SIL=Silica
    30 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_HR

    31 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    32 LOCATION_NAME Character(30) VARCHAR2(30) NOT NULL Location Name
    33 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
    34 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    35 COMMENTS Long Character CLOB Comment
    36 GVT_EXAM_TIME_IN Time(15) TIMESTAMP GVT Exam Time In
    37 GVT_EXAM_TIME_OUT Time(15) TIMESTAMP GVT Exam Time Out
    38 GVT_OVERALL_HEALTH Character(1) VARCHAR2(1) NOT NULL Overall Health
    E=Excellent
    F=Failing
    G=Good
    P=Poor
    T=Terminal