SCC_IDM_APPS(SQL Table) |
Index Back |
---|---|
IDM ApplicationsIDM Applications available for provisioning |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCC_APPL_CONTXT_ID | Character(30) | VARCHAR2(30) NOT NULL | NUR Application Context ID :Autogenerated |
2 | SCC_APPL_CONTEXT | Character(30) | VARCHAR2(30) NOT NULL | Application Context definition |
3 | SCC_IDM_APPL_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Application Description |
4 | SCC_DEFAULT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default state flag
Y/N Table Edit Default Value: N |
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 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
8 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table: SCC_NUR_MENU_VW |
9 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table: SCC_NUR_MBAR_VW |
10 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL |
Item Name
Prompt Table: SCC_NUR_ITEM_VW |
11 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: SCC_NUR_COMP_VW |
12 | PAGE_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Page Name
Prompt Table: PSPAGENAME_VW |
13 | 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 |
14 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
Prompt Table: SCC_NUR_NODE_VW |
15 | SCC_NUR_ACTURLFLGT | Character(1) | VARCHAR2(1) NOT NULL |
NUR - Tester Active URL indicator
Y/N Table Edit Default Value: N |
16 | SCC_NUR_CFLAGURLT | Character(1) | VARCHAR2(1) NOT NULL |
Customize Tester URL Indicator
Y/N Table Edit Default Value: N |
17 | SCC_NUR_CUSTOMURLT | Character(254) | VARCHAR2(254) NOT NULL | Customized Tester URL |
18 | SCC_NUR_ACTURLFLAG | Character(1) | VARCHAR2(1) NOT NULL |
NUR - Prod. Active URL indicator
Y/N Table Edit Default Value: N |
19 | SCC_NUR_CFLAGURLP | Character(1) | VARCHAR2(1) NOT NULL |
Customize Production URL indicator
Y/N Table Edit Default Value: N |
20 | SCC_NUR_CUSTOMURLP | Character(254) | VARCHAR2(254) NOT NULL | Customized Production URL |
21 | DESCRLONG | Long Character | CLOB | Long Description |