SCC_ENTITY_TYPE_IDSCC_ENTITY_IDLANGUAGE_CDSCC_ENT_C_PT_LN(SQL View) |
Index Back |
|---|
| SELECT A.SCC_ENTITY_TYPE_ID , B.SCC_ENTITY_ID , B1.LANGUAGE_CD , B1.SCC_ENTITY_NAME , B1.SCC_ENTITY_DESCR FROM PS_SCC_ENTITY_TYPE A , PS_SCC_ENTITY_REG B , PS_SCC_ENT_REG_LNG B1 WHERE B.SCC_ENTITY_ID = B1.SCC_ENTITY_ID AND B.SCC_ENTITY_ID IN ( SELECT C.SCC_ENTITY_ID FROM PS_SCC_ENTITY_REG C , PS_SCC_ENT_TYPE_CH D WHERE C.SCC_ENTITY_TYPE_ID=D.SCC_ENT_TYPE_CHID AND A.SCC_ENTITY_TYPE_ID=D.SCC_ENTITY_TYPE_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_ENTITY_TYPE_ID |
Character(40) | VARCHAR2(40) NOT NULL | Entity Type ID |
| 2 | SCC_ENTITY_ID |
Character(40) | VARCHAR2(40) NOT NULL | Entitiy ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | SCC_ENTITY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Entitiy Name |
| 5 | SCC_ENTITY_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Entitiy Description |