INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
EFFDTDefault Value: %date
A=Annual MPN
M=Mulit-Year MPN
E=Electronic MPN
P=Paper MPN
A=Accepted Awards
O=Offered Awards
Y/N Table Edit
Default Value: N
SFA_PERKMPN_OPT(SQL Table) |
Index Back |
|---|---|
Perkins MPN Setup OptionsInstitution level setup info for printing Perkins MPN. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | SFA_MPN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
MPN Type
A=Annual MPN M=Mulit-Year MPN |
| 4 | SFA_MPN_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
MPN Format
E=Electronic MPN P=Paper MPN |
| 5 | SFA_MPN_CREATE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Create Option
A=Accepted Awards O=Offered Awards |
| 6 | SFA_MPN_CREATE_COM | Character(1) | VARCHAR2(1) NOT NULL |
Create Communication
Y/N Table Edit Default Value: N |
| 7 | SFA_MPN_SCHL_NAME | Character(50) | VARCHAR2(50) NOT NULL | School Name |
| 8 | SFA_MPN_SCHL_ADDR1 | Character(55) | VARCHAR2(55) NOT NULL | Address Line 1 |
| 9 | SFA_MPN_SCHL_ADDR2 | Character(55) | VARCHAR2(55) NOT NULL | Address Line 2 |
| 10 | SFA_MPN_SCHL_CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 11 | SFA_MPN_SCHL_STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 12 | SFA_MPN_SCHL_ZIPCD | Character(12) | VARCHAR2(12) NOT NULL | Postal Code |