SCC_RULE_BENTVW(SQL View) |
Index Back |
|---|---|
Rules Engine Base Entity ViewThis view is created to return all valid base entities for a specific rule category in the Rules Engine |
| SELECT A.SCC_ENT_PRFL_ID , C.SCC_ENT_PRFL_NAME , C.SCC_ENT_P_PRFL_ID , A.SCC_ENTITY_ID , B.SCC_ENTITY_NAME , A.SCC_ENT_VIEW_ID , A.SCC_ENT_BASE_ALLOW FROM PS_SCC_ENT_VW_PRFL A , PS_SCC_ENTITY_REG B , PS_SCC_ENTITY_PRFL C WHERE A.SCC_ENTITY_ID = B.SCC_ENTITY_ID AND A.SCC_ENT_PRFL_ID = C.SCC_ENT_PRFL_ID AND A.SCC_ENT_BASE_ALLOW = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_ENT_PRFL_ID | Character(40) | VARCHAR2(40) NOT NULL | Entity Profile ID |
| 2 | SCC_ENT_PRFL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Entity Profile Name |
| 3 | SCC_ENT_P_PRFL_ID | Character(40) | VARCHAR2(40) NOT NULL | Parent Profile ID |
| 4 | SCC_ENTITY_ID | Character(40) | VARCHAR2(40) NOT NULL | Entitiy ID |
| 5 | SCC_ENTITY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Entitiy Name |
| 6 | SCC_ENT_VIEW_ID | Character(40) | VARCHAR2(40) NOT NULL | Entity View ID |
| 7 | SCC_ENT_BASE_ALLOW | Character(1) | VARCHAR2(1) NOT NULL | Allow This Entity as a base entity |