SFA_PERK_MPN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
3	SFA_MPN_SEQ	Number(3,0)	SMALLINT NOT NULL	MPN Sequence
4	SFA_MPN_CREATE_DT	DateTime(26)	TIMESTAMP	MPN Created Date
5	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year
6	SFA_MPN_MULTI_IND	Character(1)	VARCHAR2(1) NOT NULL	Multi-Year Indicator Y/N Table Edit
7	SFA_EMPN_IND	Character(1)	VARCHAR2(1) NOT NULL	Electronic MPN Y/N Table Edit
8	SFA_MPN_CONSENT_DT	DateTime(26)	TIMESTAMP	Electronic Consent Date
9	SFA_MPN_SIGN_DT	Date(10)	DATE	Signature Date
10	SFA_MPN_SIGN_TIME	Time(15)	TIMESTAMP	Signature Time
11	SFA_MPN_RECEIVE_DT	Date(10)	DATE	Received Date
12	SFA_MPN_CLOSE_DT	Date(10)	DATE	MPN Closed Date
13	SFA_MPN_EXPIRE_DT	Date(10)	DATE	MPN Expire Date
14	SFA_MPN_CANCEL_DT	Date(10)	DATE	MPN Cancel Date
15	FORM_NAME	Character(18)	VARCHAR2(18) NOT NULL	Form Name is the unique id of the form. This corresponds to a page name.
16	SFA_MPN_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
17	SFA_MPN_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
18	SFA_MPN_MIDDLE_INT	Character(1)	VARCHAR2(1) NOT NULL	Middle Initial
19	SFA_MPN_ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address Line 1
20	SFA_MPN_ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address Line 2
21	SFA_MPN_CITY	Character(30)	VARCHAR2(30) NOT NULL	City
22	SFA_MPN_STATE_PROV	Character(6)	VARCHAR2(6) NOT NULL	State/Province
23	SFA_MPN_POSTAL_CD	Character(12)	VARCHAR2(12) NOT NULL	Zip Code
24	SFA_MPN_SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security Number
25	SFA_MPN_BIRTH_DT	Date(10)	DATE	Date of Birth
26	SFA_MPN_PHONE_NBR	Character(24)	VARCHAR2(24) NOT NULL	Phone Number
27	SFA_MPN_DRV_LIC_ST	Character(6)	VARCHAR2(6) NOT NULL	Driver's License State
28	SFA_MPN_DRV_LIC	Character(20)	VARCHAR2(20) NOT NULL	Driver's License Number
29	SFA_MPN_SCHL_NAME	Character(50)	VARCHAR2(50) NOT NULL	School Name
30	SFA_MPN_SCHL_ADDR1	Character(55)	VARCHAR2(55) NOT NULL	Address Line 1
31	SFA_MPN_SCHL_ADDR2	Character(55)	VARCHAR2(55) NOT NULL	Address Line 2
32	SFA_MPN_SCHL_CITY	Character(30)	VARCHAR2(30) NOT NULL	City
33	SFA_MPN_SCHL_STATE	Character(6)	VARCHAR2(6) NOT NULL	State
34	SFA_MPN_SCHL_ZIPCD	Character(12)	VARCHAR2(12) NOT NULL	Postal Code
35	SFA_MPN_INT_RATE	Number(6,3)	DECIMAL(5,3) NOT NULL	Annual Interest Rate