RD_DEP_WRK_LVW

(SQL View)
Index Back

Department View

Related language record for RD_DEP_WRK_VW.

SELECT A.BO_ID , C.DEPTID ,D.ROLE_TYPE_ID ,C.LANGUAGE_CD , C.DESCR FROM PS_RD_PERSON A , PS_RC_WRKR_JOB B , PS_DEPT_TBL_LANG C ,PS_RD_WRKR_ASGN D WHERE A.PERSON_ID = B.PERSON_ID AND B.SETID_DEPT = C.SETID AND B.DEPTID = C.DEPTID AND D.PERSON_ID=A.PERSON_ID AND d.primary_ind='Y' AND C.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_DEPT_TBL A1 WHERE C.SETID = A1.SETID AND C.DEPTID = A1.DEPTID AND A1.EFFDT <=%CurrentDateIn AND A1.EFF_STATUS = 'A')

  • Related Language Record for RD_DEP_WRK_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    2 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
    3 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description