GLPC_ACTV_VW

(SQL View)
 Index Back

Activity Prompt View

Selects distinct Activity IDs -- used as prompt edit table for Activity ID lookup on Detail Project Maintenance component

SELECT DISTINCT ACTIVITY_ID , DESCR FROM PS_PROJ_ACT_FS

  • Related Language Record: GLPC_ACTV_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description