SCC_AUDIO_TST_H

(SQL View)
 Index Back

Audiometric Exams

Use AUDIOMETRIC_TST to record information about hearing examinations administered to the employee. This data is part of the Health and Safety module.

SELECT ' ' , %DateNull , ' ' , %DateNull , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , ' ' , ' ' , ' ' , DB2_NULL_LONG FROM %Table(INSTALLATION_SA) , PS_DB2_NULL_FLDS

  • Related Language Record: SCC_AUDIO_TSTLN

  • Parent record: PERSON

    • # 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 AUDIOMTR_SER_NBR Character(5) VARCHAR2(5) NOT NULL Audiometer Serial #
    28 LF_250_FREQ Character(1) VARCHAR2(1) NOT NULL Left 250 Frequency

    Y/N Table Edit

    Default Value: N

    29 LF_500_FREQ Character(1) VARCHAR2(1) NOT NULL Left 500 Frequency

    Y/N Table Edit

    Default Value: N

    30 LF_1000_FREQ Character(1) VARCHAR2(1) NOT NULL Left 1000 Frequency

    Y/N Table Edit

    Default Value: N

    31 LF_2000_FREQ Character(1) VARCHAR2(1) NOT NULL Left 2000 Frequency

    Y/N Table Edit

    Default Value: N

    32 LF_3000_FREQ Character(1) VARCHAR2(1) NOT NULL Left 3000 Frequency

    Y/N Table Edit

    Default Value: N

    33 LF_4000_FREQ Character(1) VARCHAR2(1) NOT NULL Left 4000 Frequency

    Y/N Table Edit

    Default Value: N

    34 LF_5000_FREQ Character(1) VARCHAR2(1) NOT NULL Left 5000 Frequency

    Y/N Table Edit

    Default Value: N

    35 LF_6000_FREQ Character(1) VARCHAR2(1) NOT NULL Left 6000 Frequency

    Y/N Table Edit

    Default Value: N

    36 LF_7000_FREQ Character(1) VARCHAR2(1) NOT NULL Left 7000 Frequency

    Y/N Table Edit

    Default Value: N

    37 LF_8000_FREQ Character(1) VARCHAR2(1) NOT NULL Left 8000 Frequency

    Y/N Table Edit

    Default Value: N

    38 RT_250_FREQ Character(1) VARCHAR2(1) NOT NULL Right 250 Frequency

    Y/N Table Edit

    Default Value: N

    39 RT_500_FREQ Character(1) VARCHAR2(1) NOT NULL Right 500 Frequency

    Y/N Table Edit

    Default Value: N

    40 RT_1000_FREQ Character(1) VARCHAR2(1) NOT NULL Right 1000 Frequency

    Y/N Table Edit

    Default Value: N

    41 RT_2000_FREQ Character(1) VARCHAR2(1) NOT NULL Right 2000 Frequency

    Y/N Table Edit

    Default Value: N

    42 RT_3000_FREQ Character(1) VARCHAR2(1) NOT NULL Right 3000 Frequency

    Y/N Table Edit

    Default Value: N

    43 RT_4000_FREQ Character(1) VARCHAR2(1) NOT NULL Right 4000 Frequency

    Y/N Table Edit

    Default Value: N

    44 RT_5000_FREQ Character(1) VARCHAR2(1) NOT NULL Right 5000 Frequency

    Y/N Table Edit

    Default Value: N

    45 RT_6000_FREQ Character(1) VARCHAR2(1) NOT NULL Right 6000 Frequency

    Y/N Table Edit

    Default Value: N

    46 RT_7000_FREQ Character(1) VARCHAR2(1) NOT NULL Right 7000 Frequency

    Y/N Table Edit

    Default Value: N

    47 RT_8000_FREQ Character(1) VARCHAR2(1) NOT NULL Right 8000 Frequency

    Y/N Table Edit

    Default Value: N

    48 LF_250_DB Signed Number(4,0) DECIMAL(3) NOT NULL Left 250 Decibel
    49 LF_500_DB Signed Number(4,0) DECIMAL(3) NOT NULL Left 500 Decibel
    50 LF_1000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Left 1000 Decibel
    51 LF_2000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Left 2000 Decibel
    52 LF_3000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Left 3000 Decibel
    53 LF_4000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Left 4000 Decibel
    54 LF_5000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Left 5000 Decibel
    55 LF_6000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Left 6000 Decibel
    56 LF_7000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Left 7000 Decibel
    57 LF_8000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Left 8000 Decibel
    58 RT_250_DB Signed Number(4,0) DECIMAL(3) NOT NULL Right 250 Decibel
    59 RT_500_DB Signed Number(4,0) DECIMAL(3) NOT NULL Right 500 Decibel
    60 RT_1000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Right 1000 Decibel
    61 RT_2000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Right 2000 Decibel
    62 RT_3000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Right 3000 Decibel
    63 RT_4000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Right 4000 Decibel
    64 RT_5000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Right 5000 Decibel
    65 RT_6000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Right 6000 Decibel
    66 RT_7000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Right 7000 Decibel
    67 RT_8000_DB Signed Number(4,0) DECIMAL(3) NOT NULL Right 8000 Decibel
    68 HEARING_CLASS Character(2) VARCHAR2(2) NOT NULL Hearing Classification
    AB=Abnormal
    AS=Abnormal Shift
    EL=Early Loss Indication
    NM=Normal
    69 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
    70 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    71 COMMENTS Long Character CLOB Comment