RD_PR_PGM_OPRVW

(SQL View)
 Index Back

Partner Program Search View

View of Partner Program. Used for user ID security.

SELECT A.SETID , A.PARTNER_PGM_ID , A.PARTNER_PGM_NAME , %Upper(A.PARTNER_PGM_NAME) , A.PARTNER_PGM_STATUS , A.PARTNER_TYPE , A.PARTNER_SUBTYPE , A.PARTNER_LEVEL , A.START_DATE , A.END_DATE , B.OPRID FROM PS_RD_PR_PROG A , PS_SEC_SETID_OPR B WHERE A.SETID = B.SETID

  • Related Language Record: RD_PR_PGM_LOPRV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Prompt Table: SP_SETID_NONVW

    2 PARTNER_PGM_ID Character(15) VARCHAR2(15) NOT NULL Partner Program ID
    3 PARTNER_PGM_NAME Character(50) VARCHAR2(50) NOT NULL Partner Program name
    4 PARTNER_PGM_NM_UPR Character(50) VARCHAR2(50) NOT NULL Partner Program name
    5 PARTNER_PGM_STATUS Character(1) VARCHAR2(1) NOT NULL Status of partner program
    A=Active
    I=Inactive
    P=Pending
    6 PARTNER_TYPE Character(4) VARCHAR2(4) NOT NULL Partner type

    Prompt Table: RD_PR_TYPE

    7 PARTNER_SUBTYPE Character(4) VARCHAR2(4) NOT NULL Partner subtype

    Prompt Table: RD_PR_SUBTYPE

    8 PARTNER_LEVEL Character(4) VARCHAR2(4) NOT NULL Partner level

    Prompt Table: RD_PR_LEVEL

    9 START_DATE Date(10) DATE Start Date
    10 END_DATE Date(10) DATE End date field to store an end date.
    11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).