SCC_IDM_APPS(SQL Table) | 
Index Back | 
|---|---|
IDM ApplicationsIDM Applications available for provisioning | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | 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 |