GPFR_DUCS_NUMBERGPFR_DUCS_CDGPFR_DUCS_TYPEGPFR_ROW_NUMGPFR_DUCS_DT_VW(SQL View) |
Index Back |
|---|---|
GEN and DT1 Records joinGEN and DT1 Records join for the DUCS file update page |
| SELECT A.GPFR_DUCS_NUMBER , A.GPFR_DUCS_CD , A.GPFR_DUCS_TYPE , A.GPFR_ROW_NUM , A.GPFR_ROW_NUM2 , A.GPFR_DUCS_RECORD , A.GPFR_DUCS_R1_ID , A.GPFR_DUCS_R1_NAME1 FROM PS_GPFR_DUCS_R A , PS_GPFR_DUCS_GEN B WHERE A.GPFR_DUCS_NUMBER=B.GPFR_DUCS_NUMBER AND A.GPFR_DUCS_CD=B.GPFR_DUCS_CD AND A.GPFR_DUCS_TYPE=B.GPFR_DUCS_TYPE AND A.GPFR_DUCS_REG_FLG=B.GPFR_DUCS_REG_FLG AND A.GPFR_ROW_NUM=B.GPFR_ROW_NUM AND A.GPFR_ROW_NUM2=0 AND A.GPFR_DUCS_RECORD='DT1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_DUCS_NUMBER |
Number(10,0) | DECIMAL(10) NOT NULL | DUCS Process Instance |
| 2 | GPFR_DUCS_CD |
Character(10) | VARCHAR2(10) NOT NULL | GPFR: DUCS Code |
| 3 | GPFR_DUCS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | GPFR: DUCS Type |
| 4 | GPFR_ROW_NUM |
Number(5,0) | INTEGER NOT NULL | Used as counter for row or column number |
| 5 | GPFR_ROW_NUM2 | Number(5,0) | INTEGER NOT NULL | Used as counter for row or column number (level2). Used in the DUCS/BDA/TRC reports. |
| 6 | GPFR_DUCS_RECORD | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Record Code |
| 7 | GPFR_DUCS_R1_ID | Character(35) | VARCHAR2(35) NOT NULL | Identification Number |
| 8 | GPFR_DUCS_R1_NAME1 | Character(35) | VARCHAR2(35) NOT NULL | Name for the Declared Unit |