SCC_ENT_PRFL_IDSCC_ENTITY_IDPrompt Table: SCC_ENTITY_PT
Prompt Table: SCC_ENTITY_VW_V
SCC_ENT_VP_VW(SQL View) |
Index Back |
|---|---|
Entity View Profile ViewEntity View Profile View |
| SELECT SCC_ENT_PRFL_ID , SCC_ENTITY_ID , SCC_ENT_VIEW_ID FROM PS_SCC_ENT_VW_PRFL UNION SELECT A.SCC_ENT_PRFL_ID , B.SCC_ENTITY_ID , B.SCC_ENT_VIEW_ID FROM PS_SCC_ENTITY_PRFL A , PS_SCC_ENT_VW_PRFL B WHERE A.SCC_ENT_P_PRFL_ID=B.SCC_ENT_PRFL_ID AND B.SCC_ENTITY_ID NOT IN ( SELECT SCC_ENTITY_ID FROM PS_SCC_ENT_VW_PRFL WHERE SCC_ENT_PRFL_ID=A.SCC_ENT_PRFL_ID) |
| # | 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_ENTITY_ID |
Character(40) | VARCHAR2(40) NOT NULL |
Entitiy ID
Prompt Table: SCC_ENTITY_PT |
| 3 | SCC_ENT_VIEW_ID | Character(40) | VARCHAR2(40) NOT NULL |
Entity View ID
Prompt Table: SCC_ENTITY_VW_V |