GM_CMP_APPR_LST

(SQL View)
Index Back

Comp App WL view


SELECT 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 , A.OPRID , B.INSTANCEID , B.TRANSACTIONID , B.LAST_REQ_ID , B.PROF_ROLE_TYPE , A.ORIGINATORID , B.GM_COMP_APP_ACT 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: GM_CMP_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
    12 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    13 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
    14 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
    15 LAST_REQ_ID Number(8,0) INTEGER NOT NULL Last Requirement ID
    16 PROF_ROLE_TYPE Character(4) VARCHAR2(4) NOT NULL Role Type
    17 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    18 GM_COMP_APP_ACT Character(1) VARCHAR2(1) NOT NULL Action
    A=Approved
    B=Send Back
    D=Deleted by System
    E=Not generated
    G=Reassigned
    N=Notified
    R=Reviewed
    S=Submitted
    T=Not Approved