HS_AWE_TEST_VW

(SQL View)
 Index Back

Test Result Details for AWE

Test Result record for AWE.

SELECT HS1.EMPLID , HS1.ACTION_DT_SS , HS1.EFFSEQ , HS1.HS_EMPLID ,HS1.REG_REGION ,HS1.TEST_CODE ,HS1.START_DATE , NM.NAME_DISPLAY , ' ' ,TS.DESCR , ' ' , ' ' FROM PS_HS_SS_TEST_DAT HS1 , PS_PERSON_NAME NM , PS_SET_CNTRL_GROUP RR , PS_HS_TEST_TBL TS WHERE NM.EMPLID = HS1.EMPLID AND HS1.REG_REGION=RR.SETCNTRLVALUE AND RR.REC_GROUP_ID = 'HR_08' AND RR.SETID=TS.SETID AND HS1.TEST_CODE=TS.TEST_CODE AND TS.EFFDT=( SELECT MAX(I.EFFDT) FROM PS_HS_TEST_TBL I WHERE I.SETID=RR.SETID AND I.TEST_CODE=HS1.TEST_CODE AND I.EFF_STATUS='A' AND I.EFFDT <=%CurrentDateIn)

  • Related Language Record: HS_AWE_TEST_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 ACTION_DT_SS Date(10) DATE NOT NULL Transaction Date

    Default Value: %date

    3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

    Default Value: 0

    4 HS_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID for Health and Safety

    Prompt Table: HS_PER_ORG_ASGN

    5 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_REGION_TBL

    6 TEST_CODE Character(4) VARCHAR2(4) NOT NULL Code for type of test

    Prompt Table: HS_TEST_TBL

    7 START_DATE Date(10) DATE Start Date for Gen Standing PO
    8 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    9 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    12 ADDRESSLONG Long Character CLOB Address Long