COUNTRYGPFR_AF_APPLGPFR_AF_APPL_VERGPFR_AF_NODE_NAMEGPFR_DSN_UPMG_V(SQL View) |
Index Back |
|---|---|
Update DSN Data Key MessagesUpdate DSN Data Key Messages |
| SELECT A.COUNTRY , A.GPFR_AF_APPL ,A.GPFR_AF_APPL_VER ,A.GPFR_DT_XVALUES , B.DESCR254 FROM PS_GPFR_DT_XVALUES A , PS_GPFR_DT_VALUES B WHERE A.COUNTRY=B.COUNTRY AND A.GPFR_AF_APPL=B.GPFR_AF_APPL AND A.GPFR_DA_DATTYP=B.GPFR_DA_DATTYP AND A.GPFR_AF_APPL_VER=B.GPFR_AF_APPL_VER AND A.GPFR_DA_CODE=B.GPFR_DA_CODE AND A.COUNTRY='FRA' AND A.GPFR_AF_APPL='DSN' AND A.GPFR_DA_DATTYP='UPDDATA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | GPFR_AF_APPL |
Character(10) | VARCHAR2(10) NOT NULL | Application Framework - Application |
| 3 | GPFR_AF_APPL_VER |
Number(8,0) | INTEGER NOT NULL | Application Framework - Application |
| 4 | GPFR_AF_NODE_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Application Framework - Node Name |
| 5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |