PROJ_ACTV_VW

(SQL View)
 Index Back

Activity Prompt View by setid

Used in GL allocations to prompt for project activities. Dynamically prompted via the FS_FLD_PROMPT table.

SELECT B.SET_OVERRIDE ,A.PROJECT_ID ,A.ACTIVITY_ID ,A.DESCR FROM PS_PROJ_ACTIVITY A , PS_PROJECT B WHERE B.PROJECT_ID = A.PROJECT_ID AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND A.EFF_STATUS = 'A' AND A.SUMMARY_ACT = 'N'

  • Related Language Record: PROJ_ACTV_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description