BO_IDRO_PN_PGM_VW(SQL View) |
Index Back |
|---|---|
Parter with program info.Lists the partner's program fields that are used by the pricing engine. |
| SELECT PTN.BO_ID , PGM.PARTNER_PGM_ID , PGM.PARTNER_LEVEL , PGM.PARTNER_TYPE , PGM.PARTNER_SUBTYPE FROM PS_RD_PR_PGM PTN , PS_RD_PR_PROG PGM , PS_RD_COMPANY C WHERE PTN.PARTNER_PGM_ID = PGM.PARTNER_PGM_ID AND C.BO_ID = PTN.BO_ID AND C.SETID = PGM.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | PARTNER_PGM_ID | Character(15) | VARCHAR2(15) NOT NULL | Partner Program ID |
| 3 | PARTNER_LEVEL | Character(4) | VARCHAR2(4) NOT NULL | Partner level |
| 4 | PARTNER_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Partner type |
| 5 | PARTNER_SUBTYPE | Character(4) | VARCHAR2(4) NOT NULL | Partner subtype |