GPFR_DUCS_CDGPFR_DUCS_TYPEGPFR_DUCS_EN1GPFR_DUCS_EN1VW(SQL View) |
Index Back |
|---|---|
DUCS EN1 ViewDUCS EN1 View for DUCS Type 903 |
| SELECT E.GPFR_DUCS_CD , E.GPFR_DUCS_TYPE , E.GPFR_DUCS_EN1 , C0.DESCR FROM PS_GPFR_DUCS_ESTAB E , PS_GPFR_DUCS_CONT0 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |