SPF_NX_BDACT_VW

(SQL View)
 Index Back

SELECT A.SPF_FROM_USERTYPE , A.SPF_TO_USERTYPE , A.SPF_LAST_ACT_TYPE , A.SPF_LAST_ACT_CODE , A.SPF_NEXT_ACT_TYPE , A.SPF_NEXT_ACT_CODE , B.DESCR , B.ACTIVITYNAME , B.EVENTNAME FROM PS_SPF_NXT_BID_ACT A , PS_SPF_BID_ACTION B WHERE A.SPF_NEXT_ACT_TYPE = B.BID_ACTION_TYPE AND A.SPF_NEXT_ACT_CODE = B.CODE

  • Related Language Record: SPF_NXBDACT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SPF_FROM_USERTYPE Character(4) VARCHAR2(4) NOT NULL Sent From user type used for determining the available bid actions
    REQ=Requester
    SPC=Service Provider Contact
    SVC=Service Coordinator
    2 SPF_TO_USERTYPE Character(4) VARCHAR2(4) NOT NULL Sent to User Type used for determining the next available bid actions
    REQ=Requester
    SPC=Service Provider Contact
    SVC=Service Coordinator
    3 SPF_LAST_ACT_TYPE Character(5) VARCHAR2(5) NOT NULL The last bid action type
    4 SPF_LAST_ACT_CODE Character(4) VARCHAR2(4) NOT NULL the last bid action code
    5 SPF_NEXT_ACT_TYPE Character(5) VARCHAR2(5) NOT NULL the next bid action type
    6 SPF_NEXT_ACT_CODE Character(4) VARCHAR2(4) NOT NULL the next bid action code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
    9 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow