GPFR_DUCS_CDGPFR_DUCS_TYPEGPFR_DUCS_EN1LANGUAGE_CDGPFR_DU_ENVWLNG(SQL View) |
Index Back |
|---|---|
DUCS Estab. for Others Lang VWDUCS Establishment view for Other type - Related Language view. |
| SELECT E.GPFR_DUCS_CD , E.GPFR_DUCS_TYPE , E.GPFR_DUCS_EN1 , C0.LANGUAGE_CD , C0.DESCR FROM PS_GPFR_DUCS_ESTAB E , PS_GPFR_DUCSC0_LNG C0 WHERE E.GPFR_DUCS_TYPE = '903' AND C0.GPFR_CONT_CD = E.GPFR_DUCS_EN1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_DUCS_CD |
Character(10) | VARCHAR2(10) NOT NULL | GPFR: DUCS Code |
| 2 | GPFR_DUCS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | GPFR: DUCS Type |
| 3 | GPFR_DUCS_EN1 |
Character(10) | VARCHAR2(10) NOT NULL | GPFR: Establishment |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |