GPFR_AF_FEE_ND(SQL Table) |
Index Back |
|---|---|
Record created for fees inputRecord created for fees input component |
| # | 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_SNDREF |
Character(10) | VARCHAR2(10) NOT NULL |
Application Framework - Sending Reference
Prompt Table: GPFR_INPUT_DATA |
| 4 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: GPFR_AF_SND_VW |
| 5 | GPFR_AF_FEE_ID |
Character(20) | VARCHAR2(20) NOT NULL |
Fee Identifier
Prompt Table: PERS_SRCH_GBL |
| 6 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Default Value: 0 Prompt Table: PER_ORG_ASGN_VW |
| 7 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 8 | GPFR_AF_KEY_NODE |
Number(8,0) | INTEGER NOT NULL |
Application Framework - Key Node
Prompt Table: GPFR_AF_FEE_VW |
| 9 | GPFR_AF_KEY_EXTRCT |
Character(50) | VARCHAR2(50) NOT NULL | Application Framework - Key Extract |