GPFR_AF_FEE_EDT(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 | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
|
2 | Character(10) | VARCHAR2(10) NOT NULL |
Application Framework - Application
Prompt Table: GPFR_AF_APPL |
|
3 | Character(10) | VARCHAR2(10) NOT NULL |
Application Framework - Sending Reference
Prompt Table: GPFR_DA_SNDREF |
|
4 | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: GPFR_AF_SND_VW |
|
5 | Character(20) | VARCHAR2(20) NOT NULL |
Fee Identifier
Prompt Table: PERS_SRCH_GBL |
|
6 | Number(3,0) | SMALLINT NOT NULL |
Empl Record
Default Value: 0 Prompt Table: PER_ORG_ASGN_VW |
|
7 | Date(10) | DATE |
Effective Date
Default Value: %date |