SCC_IDM_CNT_PRV

(SQL View)
 Index Back

Provision and Apps view

This view selects all the provisioned apps or all the publicly available apps

SELECT A.OPRID ,A.SCC_APPL_CONTXT_ID ,B.SCC_APPL_CONTEXT ,B.URL ,B.EFF_STATUS ,B.SCC_IDM_PRV_CONTXT ,B.MENUNAME ,B.BARNAME ,B.ITEMNAME ,B.PNLGRPNAME ,B.PAGE_NAME ,B.SCC_NUR_ACCES_MODE ,B.MSGNODENAME FROM PS_SCC_IDM_PROVISN A , PS_SCC_IDM_APPS B WHERE A.SCC_APPL_CONTXT_ID = B.SCC_APPL_CONTXT_ID AND B.EFF_STATUS = 'A' UNION SELECT ' ' ,B.SCC_APPL_CONTXT_ID ,B.SCC_APPL_CONTEXT ,B.URL ,B.EFF_STATUS ,B.SCC_IDM_PRV_CONTXT ,B.MENUNAME ,B.BARNAME ,B.ITEMNAME ,B.PNLGRPNAME ,B.PAGE_NAME ,B.SCC_NUR_ACCES_MODE ,B.MSGNODENAME FROM PS_SCC_IDM_APPS B WHERE B.SCC_IDM_PRV_CONTXT = 'P' AND B.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SCC_APPL_CONTXT_ID Character(30) VARCHAR2(30) NOT NULL NUR Application Context ID :Autogenerated
3 SCC_APPL_CONTEXT Character(30) VARCHAR2(30) NOT NULL Application Context definition
4 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
6 SCC_IDM_PRV_CONTXT Character(1) VARCHAR2(1) NOT NULL Provisioning Context
G=Guest Provisioned
P=Auto Provisioned
S=Secure Provisioning
7 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
8 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
9 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
10 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
11 PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name
12 SCC_NUR_ACCES_MODE Character(1) VARCHAR2(1) NOT NULL NUR transfer Access mode
A=Add Mode
C=Correction Mode
L=Update Display All
U=Update Display Mode
13 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).