GPFR_AF_FEES(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_DA_SNDREF |
| 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 |
| 6 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Default Value: 0 |
| 7 | EFFDT |
Date(10) | DATE NOT NULL |
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(12) | VARCHAR2(12) NOT NULL | Application Framework - Key Extract |
| 10 | GPFR_AF_KEY_ATTR |
Number(8,0) | INTEGER NOT NULL |
Application Framework - Key Attribute
Prompt Table: GPFR_AF_FEAT_VW |
| 11 | GPFR_AF_CHAR_VAL | Character(50) | VARCHAR2(50) NOT NULL | Application Framework - Character |
| 12 | GPFR_AF_DATE_VAL | Date(10) | DATE | Application Framework - Date |
| 13 | GPFR_AF_NUM_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Application Framework - Number |