SCC_ENT_PRFL_IDPrompt Table: SCC_EPFL_EDS_PT
SCC_ENTITY_IDPrompt Table: SCC_ENTITY_PT
LANGUAGE_CDSCC_EDS_PT_LN(SQL View) |
Index Back |
|---|
| SELECT A.SCC_ENT_PRFL_ID , A.SCC_ENTITY_ID , B.LANGUAGE_CD , B.SCC_ENT_PRFL_NAME , C.SCC_ENTITY_NAME FROM PS_SCC_ENT_VW_PRFL A , PS_SCC_ENT_PRFL_LN B , PS_SCC_ENT_REG_LNG C , PS_SCC_ENTITY_PRFL D , PS_SCC_ENTITY_REG E WHERE A.SCC_ENTITY_ID=C.SCC_ENTITY_ID AND C.LANGUAGE_CD=B.LANGUAGE_CD AND A.SCC_ENT_PRFL_ID=B.SCC_ENT_PRFL_ID AND B.SCC_ENT_PRFL_ID=D.SCC_ENT_PRFL_ID AND C.SCC_ENTITY_ID=E.SCC_ENTITY_ID AND D.SCC_ENT_PRFL_TYPE='40' AND E.SCC_ENTITY_TYPE_ID='SCC_ETYPE_20130116133604' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_ENT_PRFL_ID |
Character(40) | VARCHAR2(40) NOT NULL |
Entity Profile ID
Prompt Table: SCC_EPFL_EDS_PT |
| 2 | SCC_ENTITY_ID |
Character(40) | VARCHAR2(40) NOT NULL |
Entitiy ID
Prompt Table: SCC_ENTITY_PT |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | SCC_ENT_PRFL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Entity Profile Name |
| 5 | SCC_ENTITY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Entitiy Name |