PROJ_ACT_SET_VW

(SQL View)
Index Back

Project Activities Setid View


SELECT B.SET_OVERRIDE ,A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ACTIVITY_ID ,A.DESCR FROM PS_PROJECT B , PS_PROJ_ACTIVITY A WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.COSTING_ACT_SW = 'Y'

  • Related Language Record: PROJ_ACTSET_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    4 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description