HS_TEST_RESULT

(SQL Table)
 Index Back

Test Result Table

The Test Result Table is used to maintain Test Result 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_RESULT Character(2) VARCHAR2(2) NOT NULL Test Result
    1=Positive
    10=Not Applicable
    11=Normal
    12=Abnormal
    2=Negative
    3=Pass
    4=Fail
    5=Detected
    6=Not Detected
    7=Test Invalid
    8=Test Not Done
    9=Test Not Performed
    5 HS_ENABLE_RESULT Character(1) VARCHAR2(1) NOT NULL Enable in Self-Service?

    Y/N Table Edit

    Default Value: Y