LMS_JBCD_NOMXVW

(SQL View)
 Index Back

LMS Current No Mx Job Codes Vw

LMS_JBCD_NOMXVW is a view of the JOBCODE_TBL which retrieves only the active, current effective-dated records that have only Non Matrix rate codes associated with.

SELECT A.SETID , A.JOBCODE ,A.DESCR ,A.DESCRSHORT FROM PS_JOBCODE_TBL A , PS_JBCDCMP_NOMX_V V WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_JOBCODE_TBL B WHERE B.JOBCODE = A.JOBCODE AND B.EFFDT <= %CurrentDateIn AND A.SETID = B.SETID) AND A.SETID = V.SETID AND A.JOBCODE = V.JOBCODE AND V.EFFDT = ( SELECT MAX(W.EFFDT) FROM PS_JBCDCMP_NOMX_V W WHERE W.SETID = V.SETID AND W.JOBCODE = V.JOBCODE AND W.COMP_RATECD = V.COMP_RATECD AND W.EFFDT <= A.EFFDT)

# 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_02

2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: JOBCODE_TBL

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description