GM_PRJ_DPH1_LVW

(SQL View)
 Index Back

Project Dept Hist RelLang View


SELECT BUSINESS_UNIT , PROJECT_ID ,LASTUPDDTTM ,LASTUPDOPRID ,FIELDNAME , LANGUAGE_CD , DESCR FROM PS_GM_PRJ_DEPT_HIS HIS ,PS_DEPT_TBL_LANG DEPT WHERE DEPT.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE RECNAME='DEPT_TBL' AND SETCNTRLVALUE =HIS.BUSINESS_UNIT) AND DEPT.DEPTID= HIS.OLDVALUE AND %EffdtCheck(DEPT_TBL D1,DEPT,%CurrentDateIn) AND HIS.FIELDNAME IN ('DEPTID','MAJOR_SUBDIVISION') UNION SELECT BUSINESS_UNIT , PROJECT_ID ,LASTUPDDTTM ,LASTUPDOPRID ,FIELDNAME , LANGUAGE_CD , INST.DESCR FROM PS_GM_PRJ_DEPT_HIS HIS ,PS_GM_INST_LNG INST WHERE SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE RECNAME='GM_INSTITUTION' AND SETCNTRLVALUE =HIS.BUSINESS_UNIT) AND INST.INSTID = HIS.OLDVALUE AND HIS.FIELDNAME ='INSTID'

  • Related Language Record for GM_PRJ_DPH1_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    4 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR_LN1 Character(50) VARCHAR2(50) NOT NULL Description Line 1