HS_TEST_METHOD

(SQL Table)
 Index Back

Test Method Table

The Test Method Table is used to maintain Test Method codes that can be later associated with employees who receive tests.

  • Parent record: HS_TEST_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_VLD_HR_08

    2 TEST_CODE Character(4) VARCHAR2(4) NOT NULL Code for type of test
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 HS_TEST_METHOD Character(2) VARCHAR2(2) NOT NULL Test Method
    1=Blood
    10=Tissue
    11=Urine
    12=X-ray
    13=MRI
    14=CT Scan
    15=Mammogram
    16=Ultrasound
    2=Mouth Swab
    3=Nasal Swab
    4=Nasopharynx Swab
    5=Saliva
    6=Skin
    7=Spinal Fluid
    8=Stool
    9=Throat Swab
    5 HS_ENABLE_METHOD Character(1) VARCHAR2(1) NOT NULL Enable in Self-Service?

    Y/N Table Edit

    Default Value: Y