SCC_ETYPEREG_VW(SQL View) |
Index Back |
---|
SELECT SCC_ENTITY_TYPE_ID , SCC_ENTITY_ID , SCC_ENTITY_NAME FROM PS_SCC_ENTITY_REG |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCC_ENTITY_TYPE_ID | Character(40) | VARCHAR2(40) NOT NULL |
Entity Type ID
Prompt Table: SCC_ENTITY_TYPE |
2 | SCC_ENTITY_ID | Character(40) | VARCHAR2(40) NOT NULL | Entitiy ID |
3 | SCC_ENTITY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Entitiy Name |