PSPGQRYPROMPLNG(SQL Table) |
Index Back |
---|---|
Pivot Grid Prompt record |
# | 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_VIEWNAME | Character(40) | VARCHAR2(40) NOT NULL | View Name |
3 | USERID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID
Default Value: - |
4 | PTPG_UNIQPROMPFLD | Character(30) | VARCHAR2(30) NOT NULL | Unique Prompt Name |
5 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
6 | PTPG_QRYPROMPNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Prompt Name |