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