SCC_ENTITY_IDPrompt Table: SCC_ENTITY_PT
SCC_ENT_PRFL_IDPrompt Table: SCC_EPFL_EDS_PT
Prompt Table: SCC_ENTITY_VW_V
Y/N Table Edit
Default Value: N
10=Category
20=Rules Engine
30=Web Service
40=Data Set Catagory
SCC_RLEDSCAT_VW(SQL View) |
Index Back |
|---|---|
Rules Engine EDS CategoryThis view is used for prompting for entity data set categories in the rules engine. |
| SELECT A.SCC_ENTITY_ID , A.SCC_ENT_PRFL_ID , A.SCC_ENT_VIEW_ID , A.SCC_ENT_BASE_ALLOW , B.SCC_ENT_PRFL_TYPE , B.SCC_ENT_P_PRFL_ID , B.SCC_ENT_PRFL_NAME , B.SCC_ENT_PRFL_DESCR FROM PS_SCC_ENT_VW_PRFL A , PS_SCC_ENTITY_PRFL B WHERE A.SCC_ENT_PRFL_ID = B.SCC_ENT_PRFL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_ENTITY_ID |
Character(40) | VARCHAR2(40) NOT NULL |
Entitiy ID
Prompt Table: SCC_ENTITY_PT |
| 2 | SCC_ENT_PRFL_ID |
Character(40) | VARCHAR2(40) NOT NULL |
Entity Profile ID
Prompt Table: SCC_EPFL_EDS_PT |
| 3 | SCC_ENT_VIEW_ID | Character(40) | VARCHAR2(40) NOT NULL |
Entity View ID
Prompt Table: SCC_ENTITY_VW_V |
| 4 | SCC_ENT_BASE_ALLOW | Character(1) | VARCHAR2(1) NOT NULL |
Allow This Entity as a base entity
Y/N Table Edit Default Value: N |
| 5 | SCC_ENT_PRFL_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Entity Profile Type
10=Category 20=Rules Engine 30=Web Service 40=Data Set Catagory |
| 6 | SCC_ENT_P_PRFL_ID | Character(40) | VARCHAR2(40) NOT NULL | Parent Profile ID |
| 7 | SCC_ENT_PRFL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Entity Profile Name |
| 8 | SCC_ENT_PRFL_DESCR | Long Character | CLOB | Entity Profile Description |