GPFR_DSN_SR_DAT(SQL View) |
Index Back |
|---|---|
DSN Sending ref dataDSN Extraction sending reference data |
| SELECT DISTINCT B.GPFR_AF_EXTRACT_ID , B.GPFR_AF_NODE_SET , B.GPFR_AF_SNDREF , B.COMPANY , B.GPFR_DSN_IND_FIN , B.ESTABID , B.GPFR_AF_EXT_BGN_DT , B.GPFR_AF_EXT_END_DT , B.GPFR_AF_APPL FROM PS_GPFR_DSN_CIESTB B ,PS_GPFR_AF_RUN_DFN A WHERE B.COUNTRY='FRA' AND B.COUNTRY=A.COUNTRY AND B.GPFR_AF_APPL=A.GPFR_AF_APPL AND B.GPFR_AF_EXTRACT_ID=A.GPFR_AF_EXTRACT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_AF_EXTRACT_ID | Character(18) | VARCHAR2(18) NOT NULL | Application Framework - Extraction ID |
| 2 | GPFR_DSN_DSNTYPE | Character(16) | VARCHAR2(16) NOT NULL | DSN: DSN Type or Node Set |
| 3 | GPFR_AF_SNDREF | Character(10) | VARCHAR2(10) NOT NULL | Application Framework - Sending Reference |
| 4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | GPFR_DSN_IND_FIN | Character(1) | VARCHAR2(1) NOT NULL | Sending reference extraction finalized |
| 6 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 7 | GPFR_AF_EXT_BGN_DT | Date(10) | DATE | Application Framework - Extraction Begin Date |
| 8 | GPFR_AF_EXT_END_DT | Date(10) | DATE | Application Framework - Extraction End Date |
| 9 | GPFR_AF_APPL | Character(10) | VARCHAR2(10) NOT NULL | Application Framework - Application |