GVT_DRUG_TEST

(SQL Table)
 Index Back

EE Drug Test Tracking

Use GVT_DRUG_TEST to record information about drug testing administered to the employee. This data is part of the Health and Safety module.

  • Related Language Record: GVT_DRUG_T_LANG

  • 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 GVT_DRUG_TEST_TYPE Character(1) VARCHAR2(1) NOT NULL Drug Testing Type
    F=For Cause
    M=Mandatory
    R=Random
    4 NEXT_EXAM_DT Date(10) DATE Next Exam Date
    5 GVT_UNION_DRUG_NEG Character(1) VARCHAR2(1) NOT NULL Union Negotiated

    Y/N Table Edit

    Default Value: N

    6 PHYSICIAN_NAME Character(50) VARCHAR2(50) NOT NULL Physician Name
    7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    8 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    9 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    10 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    11 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    12 CITY Character(30) VARCHAR2(30) NOT NULL City
    13 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    14 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    15 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    16 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    17 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    18 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    19 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    20 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    21 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    22 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    23 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    24 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    25 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    26 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
    27 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
    28 GVT_EXAM_TIME_IN Time(15) TIMESTAMP Exam Time In
    29 GVT_EXAM_TIME_OUT Time(15) TIMESTAMP Exam Time Out
    30 COMMENTS Long Character CLOB Comment