JC_BDGT_L_VW

(SQL View)
 Index Back

Budget Job Codes View (LNG)

The JOBCODE_BDGT_VW selects all current jobcodes which are not used by position management. These jobcodes are available for budgeting. (Language)

SELECT DISTINCT B.SETID , B.BUDGET_DEPTID , A.SETID , A.JOBCODE , D.LANGUAGE_CD , D.DESCR FROM PS_JOBCODE_TBL A , PS_DEPT_TBL B , PS_SET_JOB_DEP_VW C , PS_JOBCODE_LANG D WHERE A.SETID = C.SETID_JOBCODE AND B.SETID = C.SETID AND ((A.EFFDT > B.EFFDT AND NOT EXISTS ( SELECT 'X' FROM PS_JOBCODE_TBL A1 WHERE A1.SETID = A.SETID AND A1.JOBCODE = A.JOBCODE AND A1.EFFDT < A.EFFDT AND A1.EFFDT > B.EFFDT) AND NOT EXISTS ( SELECT 'X' FROM PS_DEPT_TBL B1 WHERE B1.SETID = B.SETID AND B1.DEPTID = B.DEPTID AND B1.EFFDT < A.EFFDT AND B1.EFFDT > B.EFFDT)) OR A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_JOBCODE_TBL A2 WHERE A2.SETID = A.SETID AND A2.JOBCODE = A.JOBCODE AND A2.EFFDT <= B.EFFDT)) AND D.SETID = A.SETID AND D.JOBCODE = A.JOBCODE AND D.EFFDT = A.EFFDT

  • Related Language Record for JOBCODE_BDGT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    3 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    4 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description