HS_SS_JOB_TSVWL

(SQL View)
Index Back

Health & Safety Job for Appr

JOB in Fl Approval

SELECT HDR.EMPLID , HDR.ACTION_DT_SS , HDR.EFFSEQ , HDR.HS_EMPLID , HDR.REG_REGION , HDR.TEST_CODE , HDR.START_DATE ,C.LANGUAGE_CD , C.DESCR FROM PS_HS_SS_TEST_DAT HDR , PS_JOB JOB , PS_JOBCODE_LANG C WHERE JOB.EMPLID = HDR.EMPLID AND JOB.JOB_INDICATOR='P' AND JOB.SETID_JOBCODE = C.SETID AND JOB.JOBCODE = C.JOBCODE AND %EffdtCheck(JOBCODE_LANG, C, %CurrentDateIn) AND JOB.EFFDT=( SELECT MAX(EFFDT) FROM PS_JOB JOB2 WHERE JOB.EMPLID=JOB2.EMPLID AND JOB.EMPL_RCD=JOB2.EMPL_RCD AND JOB2.JOB_INDICATOR='P' AND JOB2.EFFDT<=%CurrentDateIn) AND JOB.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB WHERE EMPLID = JOB.EMPLID AND EMPL_RCD = JOB.EMPL_RCD AND EFFDT = JOB.EFFDT AND JOB_INDICATOR='P')

  • Related Language Record for HS_SS_JOB_TS_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    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 NOT NULL Start Date for Gen Standing PO
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 JOB_DESCR Character(30) VARCHAR2(30) NOT NULL Job Description