SCC_DS_MAP_IDPrompt Table: ADM_FUNCTN_TBL
SCC_CG_DTASRC_V(SQL View) |
Index Back |
|---|---|
CommGen Data Source ViewCommGen Data Source is used as a prompt view for the CommGen Data Source registry page. |
| SELECT A.SCC_DS_MAP_ID , A.ADMIN_FUNCTION , B.DESCR FROM PS_SCC_CG_DTASRC A , PSXPDATASRC B WHERE B.DS_TYPE = 'XMD' AND B.DS_ID = A.SCC_DS_MAP_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_DS_MAP_ID |
Character(30) | VARCHAR2(30) NOT NULL | CommGen Data Source name that maps to XML Publisher Data Source ID. |
| 2 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table: ADM_FUNCTN_TBL |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |