PTPG_PGRIDNAMELANGUAGE_CDPTPG_PGVW_VWLNG(SQL View) |
Index Back |
|---|---|
PVG Viewer View |
| SELECT DISTINCT A.PTPG_PGRIDNAME ,B.PTPG_DSVALUE ,A.LANGUAGE_CD ,C.PTPVG_VIEWDESCR ,A.PTPG_PGRIDTITLE FROM PSPGCORELANG A , PSPGSETTINGS B , PSPGVIEWOPTLANG C WHERE A.PTPG_PGRIDNAME=B.PTPG_PGRIDNAME AND A.PTPG_PGRIDNAME=C.PTPG_PGRIDNAME AND A.LANGUAGE_CD=C.LANGUAGE_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTPG_PGRIDNAME |
Character(30) | VARCHAR2(30) NOT NULL | Pivot Grid Name (see PSPGCORE). |
| 2 | PTPG_DSNAME | Character(30) | VARCHAR2(30) NOT NULL | Data Source Name |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | PTPVG_VIEWDESCR | Character(254) | VARCHAR2(254) NOT NULL | View Description |
| 5 | PTPG_PGRIDTITLE | Character(30) | VARCHAR2(30) NOT NULL | Pivot Grid Title |