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
SCC_EDS_CAT_VW(SQL View) |
Index Back |
|---|
| SELECT SCC_ENTITY_ID , SCC_ENT_PRFL_ID , SCC_ENT_VIEW_ID , SCC_ENT_BASE_ALLOW FROM PS_SCC_ENT_VW_PRFL |
| # | 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 |