HS_TEST_TBL

(SQL Table)
 Index Back

Test Table

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

  • Related Language Record: HS_TEST_LANG

  • Parent Record Of HS_TEST_METHOD HS_TEST_RESULT

    • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 HS_TEST_TYPE Character(2) VARCHAR2(2) NOT NULL Test Type
    A=Antibody
    B=Biopsy
    D=Diagnostic
    G=Genetic
    I=Imaging
    S=Screening
    8 HS_ESS_AVAIL_FLG Character(1) VARCHAR2(1) NOT NULL Self-Service flag

    Y/N Table Edit

    Default Value: N

    9 HS_ENABLE_ATT Character(1) VARCHAR2(1) NOT NULL Enable Attachments (ATT) Flag

    Y/N Table Edit

    Default Value: N

    10 HS_REQUIRE_ATT Character(1) VARCHAR2(1) NOT NULL Enable Attachments (ATT) Flag

    Y/N Table Edit

    Default Value: N

    11 HS_ENABLE_ACK Character(1) VARCHAR2(1) NOT NULL Enable Acknowledgements (ACK) Flag

    Y/N Table Edit

    Default Value: N

    12 ESIGN_CATEGORY_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Category

    Prompt Table: ESIGN_CATEGORY

    13 ESIGN_ID Character(5) VARCHAR2(5) NOT NULL Acknowledgement ID

    Prompt Table: ESIGN_HDR

    14 HS_ENABLE_AWE Character(1) VARCHAR2(1) NOT NULL Enable Approval Workflow Engine (AWE) Flag

    Y/N Table Edit

    Default Value: N

    15 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

    Prompt Table: HS_AWE_PRCS_VW

    16 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID

    Prompt Table: HS_AWE_DEFN_VW