COUNTRYGPFR_AF_APPLGPFR_AF_NODE_SETGPFR_AF_EXTRACT_IDCOMPANYEMPLIDEMPL_RCDGPFR_AF_SIT_BGN_DTGPFR_AF_SIT_END_DTGPFR_AF_KEY_NODEGPFR_AF_KEY_EXTRCTGPFR_AF_LVL_1_ORDGPFR_AF_LVL_1_VALGPFR_AF_LVL_2_ORDGPFR_AF_LVL_2_VALGPFR_DSN_EXD_VW(SQL View) |
Index Back |
|---|---|
AF Extraction - Deleted DataDeleted data from Extraction table |
| SELECT DISTINCT COUNTRY ,GPFR_AF_APPL ,GPFR_AF_NODE_SET ,GPFR_AF_EXTRACT_ID ,COMPANY ,EMPLID ,EMPL_RCD ,GPFR_AF_SIT_BGN_DT ,GPFR_AF_SIT_END_DT ,GPFR_AF_KEY_NODE ,GPFR_AF_KEY_EXTRCT ,GPFR_AF_NODE_NAME ,ESTABID ,GPFR_AF_LVL_1_ORD ,GPFR_AF_LVL_1_VAL ,GPFR_AF_LVL_2_ORD ,GPFR_AF_LVL_2_VAL , GPFR_AF_LEVEL ,GPFR_AF_ORDER FROM PS_GPFR_DSN_EXD_BK |
| # | 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_NODE_SET |
Character(16) | VARCHAR2(16) NOT NULL | Application Framework - Node Set |
| 4 | GPFR_AF_EXTRACT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Application Framework - Extraction ID |
| 5 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 6 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 8 | GPFR_AF_SIT_BGN_DT |
Date(10) | DATE NOT NULL | Application Framework - Situation Begin Date |
| 9 | GPFR_AF_SIT_END_DT |
Date(10) | DATE NOT NULL | Application Framework - Situation End Date |
| 10 | GPFR_AF_KEY_NODE |
Number(8,0) | INTEGER NOT NULL | Application Framework - Key Node |
| 11 | GPFR_AF_KEY_EXTRCT |
Character(50) | VARCHAR2(50) NOT NULL | Application Framework - Key Extract |
| 12 | GPFR_AF_NODE_NAME | Character(20) | VARCHAR2(20) NOT NULL | Application Framework - Node Name |
| 13 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 14 | GPFR_AF_LVL_1_ORD |
Number(6,0) | INTEGER NOT NULL | Application Framework - Level 1 |
| 15 | GPFR_AF_LVL_1_VAL |
Character(50) | VARCHAR2(50) NOT NULL | Application Framework - Key Value 1 |
| 16 | GPFR_AF_LVL_2_ORD |
Number(6,0) | INTEGER NOT NULL | Application Framework - Level 2 |
| 17 | GPFR_AF_LVL_2_VAL |
Character(50) | VARCHAR2(50) NOT NULL | Application Framework - Key Value 2 |
| 18 | GPFR_AF_LEVEL | Number(2,0) | SMALLINT NOT NULL | Application Framework - Level |
| 19 | GPFR_AF_ORDER | Number(6,0) | INTEGER NOT NULL | Application Framework - Order |