BO_IDOPRIDCS_SEC_APPL_VW(SQL View) |
Index Back |
|---|---|
CS_SEC_APPL_VWTable for audience generation. Maps an OPRID to accessible BO_Ids based on application center. |
| SELECT A.BO_ID , B.OPRID FROM PS_CS_ADM_APP_DATA A , PS_CS_SCRTY_APPCTR B WHERE A.CS_INSTITUTION = B.CS_INSTITUTION AND (A.CS_ADM_APPL_CTR = B.CS_ADM_APPL_CTR OR B.CS_ADM_APPL_CTR = 'ALL') |
| # | 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 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |