GPFR_DA_SNDREFGPFR_DA_RECIPGPFR_DA_STRUCTGPFR_DA_COMPANYGPFR_DA_LOG_VW(SQL View) |
Index Back |
|---|---|
DADS data log info.DADS data log info. |
| SELECT DISTINCT A.GPFR_DA_SNDREF , A.GPFR_DA_RECIP , A.GPFR_DA_STRUCT , A.GPFR_DA_COMPANY , A.GPFR_DA_RECORD , B.GPFR_DA_DESCR , A.GPFR_DA_EMPLID , A.GPFR_DA_BGNDT , A.GPFR_DA_ENDDT , A.GPFR_DA_FEEREF , A.GPFR_DA_ESTAB FROM PS_GPFR_DA_DAT_LOG A , PS_GPFR_DA_RECORD B WHERE A.GPFR_DA_STRUCT = B.GPFR_DA_STRUCT AND A.GPFR_DA_RECORD = B.GPFR_DA_RECORD AND A.GPFR_DA_VAL_STATUS NOT IN ('P') AND B.GPFR_DA_OPTION NOT IN('I','D') |
| # | 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_COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | DADS related field |
| 5 | GPFR_DA_RECORD | Character(10) | VARCHAR2(10) NOT NULL | DADS related record |
| 6 | GPFR_DA_DESCR | Character(60) | VARCHAR2(60) NOT NULL | DADS related field |
| 7 | GPFR_DA_EMPLID | Character(16) | VARCHAR2(16) NOT NULL | DADS related field |
| 8 | GPFR_DA_BGNDT | Date(10) | DATE | DADS related field |
| 9 | GPFR_DA_ENDDT | Date(10) | DATE | DADSD related field |
| 10 | GPFR_DA_FEEREF | Character(20) | VARCHAR2(20) NOT NULL | DADS related field |
| 11 | GPFR_DA_ESTAB | Character(12) | VARCHAR2(12) NOT NULL | DADS related field |