GPFR_DUCS_TYPEPrompt Table: GPFR_DUCS
GPFR_PAR2_FILELANGUAGE_CDGPFR_DUCS_P2LVW(SQL View) |
Index Back |
|---|---|
GPFR_DUCS_P2_VW Related LangGPFR_DUCS_P2_VW Related Language |
| SELECT B.GPFR_DUCS_TYPE , A.GPFR_PAR2_FILE , A.LANGUAGE_CD , A.DESCR FROM PS_GPFR_DUCSP2_LNG A , PS_GPFR_DUCS_PAR2 B WHERE A.GPFR_PAR2_FILE = B.GPFR_PAR2_FILE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_DUCS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
GPFR: DUCS Type
Prompt Table: GPFR_DUCS |
| 2 | GPFR_PAR2_FILE |
Character(3) | VARCHAR2(3) NOT NULL | GPFR: File Type |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |