GPFR_DA_SNDREFGPFR_DA_RECIPGPFR_DA_ERR_REC(SQL View) |
Index Back |
|---|---|
View to display Error ListView to display Error List |
| SELECT DISTINCT B.GPFR_DA_SNDREF , B.GPFR_DA_RECIP , A.GPFR_DA_STRUCT , A.GPFR_DA_RECORD , A.GPFR_DA_DESCR , C.MESSAGE_TEXT FROM PS_GPFR_DA_RECORD A , PS_GPFR_DA_DAT_LOG B , PSMSGCATDEFN C WHERE A.GPFR_DA_STRUCT = B.GPFR_DA_STRUCT AND A.GPFR_DA_RECORD= B.GPFR_DA_RECORD AND B.MESSAGE_SET_NBR = C.MESSAGE_SET_NBR AND B.MESSAGE_NBR = C.MESSAGE_NBR AND A.GPFR_DA_OPTION NOT IN('I','D') AND B.GPFR_DA_VAL_STATUS NOT IN ('P') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_DA_SNDREF |
Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
| 2 | GPFR_DA_RECIP |
Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
| 3 | GPFR_DA_STRUCT | Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
| 4 | GPFR_DA_RECORD | Character(10) | VARCHAR2(10) NOT NULL | DADS related record |
| 5 | GPFR_DA_DESCR | Character(60) | VARCHAR2(60) NOT NULL | DADS related field |
| 6 | MESSAGE_TEXT | Character(100) | VARCHAR2(100) NOT NULL | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |