GPFR_S89_NONSAL(SQL View) |
Index Back |
|---|---|
Non Salary ViewNon Salary View |
| SELECT ESTB.COUNTRY , ESTB.GPFR_AF_APPL , ESTB.GPFR_AF_NODE_SET , ESTB.GPFR_AF_EXTRACT_ID , ESTB.GPFR_DSN_TYPE , ESTB.COMPANY , ESTB.ESTABID , ESTB.GPFR_AF_SND_LVL2 , A.GPFR_AF_FEE_ID , A.EMPL_RCD , A.EFFDT , A.GPFR_AF_SNDREF , A.GPFR_AF_APPL_VER , A.GPFR_AF_KEY_NODE , A.GPFR_AF_KEY_ATTR , ESTB.GPFR_AF_EXT_BGN_DT , ESTB.GPFR_AF_EXT_END_DT , ESTB.GPFR_DSN_IND_FIN FROM PS_GPFR_AF_FEES A , PS_GPFR_AF_NODE B , PS_GPFR_AF_ATTR C , PS_GPFR_DSN_CIESTB ESTB WHERE 1 = 1 AND A.COUNTRY = B.COUNTRY AND A.COUNTRY = C.COUNTRY AND A.COUNTRY = ESTB.COUNTRY AND A.GPFR_AF_APPL = B.GPFR_AF_APPL AND A.GPFR_AF_APPL = C.GPFR_AF_APPL AND A.GPFR_AF_APPL = ESTB.GPFR_AF_APPL AND A.COMPANY = ESTB.COMPANY AND A.GPFR_AF_CHAR_VAL = ESTB.ESTABID AND A.GPFR_AF_SNDREF = ESTB.GPFR_AF_SNDREF AND A.GPFR_AF_KEY_NODE = B.GPFR_AF_KEY_NODE AND A.GPFR_AF_KEY_NODE = C.GPFR_AF_KEY_NODE AND A.GPFR_AF_KEY_ATTR = C.GPFR_AF_KEY_ATTR AND B.GPFR_AF_NODE_NAME = 'S89.G00.91' AND C.GPFR_AF_ATTR_NAME = '000' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 2 | GPFR_AF_APPL |
Character(10) | VARCHAR2(10) NOT NULL |
Application Framework - Application
Prompt Table: GPFR_AF_APPL |
| 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 | GPFR_DSN_TYPE |
Character(2) | VARCHAR2(2) NOT NULL | DSN Type |
| 6 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: GPFR_AF_SND_VW |
| 7 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 8 | GPFR_AF_SND_LVL2 |
Character(20) | VARCHAR2(20) NOT NULL | Sending Level |
| 9 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 10 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Default Value: 0 |
| 11 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 12 | GPFR_AF_SNDREF |
Character(10) | VARCHAR2(10) NOT NULL |
Application Framework - Sending Reference
Prompt Table: GPFR_DA_SNDREF |
| 13 | GPFR_AF_APPL_VER |
Number(8,0) | INTEGER NOT NULL |
Application Framework - Application
Prompt Table: GPFR_AF_VER_VW |
| 14 | GPFR_AF_KEY_NODE |
Number(8,0) | INTEGER NOT NULL |
Application Framework - Key Node
Prompt Table: GPFR_AF_FEE_VW |
| 15 | GPFR_AF_KEY_ATTR |
Number(8,0) | INTEGER NOT NULL |
Application Framework - Key Attribute
Prompt Table: GPFR_AF_FEAT_VW |
| 16 | GPFR_AF_EXT_BGN_DT | Date(10) | DATE | Application Framework - Extraction Begin Date |
| 17 | GPFR_AF_EXT_END_DT | Date(10) | DATE | Application Framework - Extraction End Date |
| 18 | GPFR_DSN_IND_FIN | Character(1) | VARCHAR2(1) NOT NULL |
Sending reference extraction finalized
Y/N Table Edit Default Value: N |