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 | 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
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 |