GM_CMP_LST

(SQL View)
 Index Back

Comp App WL view


SELECT DISTINCT B.BUSPROCNAME , B.ACTIVITYNAME , B.EVENTNAME , B.WORKLISTNAME , B.BUSINESS_UNIT , B.PROPOSAL_ID , B.VERSION_ID , B.SUB_PROP_NBR , B.STATUS_CMPNT_GR , B.STATUS_DT , B.COMPONENT_ID_GR FROM PSWORKLIST A , PS_GM_CMP_APPR_WL B WHERE B.BUSPROCNAME= 'GM_GRANTS_BP' AND B.ACTIVITYNAME = 'GM_COMPONET_APPR' AND B.EVENTNAME= 'APP_REV' AND B.WORKLISTNAME= 'Approve Review Proposal' AND A.BUSPROCNAME=B.BUSPROCNAME AND A.ACTIVITYNAME=B.ACTIVITYNAME AND A.EVENTNAME=B.EVENTNAME AND A.WORKLISTNAME=B.WORKLISTNAME AND A.INSTANCEID=B.INSTANCEID AND A.TRANSACTIONID=B.TRANSACTIONID AND A.INSTSTATUS<2

  • Parent Record Of GM_CMP_APPR_LST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
    2 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
    3 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
    4 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    6 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
    7 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
    8 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
    9 STATUS_CMPNT_GR Character(3) VARCHAR2(3) NOT NULL Status
    APR=Approved
    ASG=Assigned
    DRF=Draft
    FSH=Finished
    IPG=In Progress
    NOA=Not Approved
    SNB=Send Back
    10 STATUS_DT Date(10) DATE Status Date
    11 COMPONENT_ID_GR Character(18) VARCHAR2(18) NOT NULL Component ID