SFA_PERKMPN_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SFA_MPN_PRT_COUNT	Number(9,0)	DECIMAL(9) NOT NULL	Perkins MPN Print Count
3	SFA_MPN_RETURN_CD	Number(2,0)	SMALLINT NOT NULL	Perkins MPN Return Code
4	SFA_MPN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	MPN Type A=Annual MPN M=Mulit-Year MPN
5	SFA_MPN_FORMAT	Character(1)	VARCHAR2(1) NOT NULL	MPN Format E=Electronic MPN P=Paper MPN
6	SFA_MPN_CREATE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Create Option A=Accepted Awards O=Offered Awards
7	SFA_MPN_CREATE_COM	Character(1)	VARCHAR2(1) NOT NULL	Create Communication
8	SFA_MPN_SEQ	Number(3,0)	SMALLINT NOT NULL	MPN Sequence
9	SFA_MPN_SCHL_NAME	Character(50)	VARCHAR2(50) NOT NULL	School Name
10	SFA_MPN_SCHL_ADDR1	Character(55)	VARCHAR2(55) NOT NULL	Address Line 1
11	SFA_MPN_SCHL_ADDR2	Character(55)	VARCHAR2(55) NOT NULL	Address Line 2
12	SFA_MPN_SCHL_CITY	Character(30)	VARCHAR2(30) NOT NULL	City
13	SFA_MPN_SCHL_STATE	Character(6)	VARCHAR2(6) NOT NULL	State
14	SFA_MPN_SCHL_ZIPCD	Character(12)	VARCHAR2(12) NOT NULL	Postal Code
15	SFA_MPN_SS_PRINT	Character(1)	VARCHAR2(1) NOT NULL	Create MPN coming from SS
16	SFA_MPN_SS_REPRINT	Character(1)	VARCHAR2(1) NOT NULL	Reprint MPN coming from SS
17	LN_STD_OVRD	Character(1)	VARCHAR2(1) NOT NULL	Student Override
18	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic Career BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine
19	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year
20	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
21	EXPIRATION_DATE	Date(10)	DATE	Expiration Date
22	FORM_COLLATE_KEY	Character(250)	VARCHAR2(250) NOT NULL	Form Collate Key is the overall sort order key for the output of a set of forms, typically within a single FORM_PROC_INST.
23	FORM_FIELD_C040	Character(40)	VARCHAR2(40) NOT NULL	Form field char 40 holds all 40 char or less fields to be placed onto a form.
24	FORM_FIELD_C128	Character(128)	VARCHAR2(128) NOT NULL	Form field char 128 holds all 128 char to 41 char fields to be placed onto a form.
25	FORM_FIELD_C254	Character(254)	VARCHAR2(254) NOT NULL	Form field char 254 holds all 254 char to 129 char fields to be placed onto a form.
26	FORM_FIELD_LTYPE	Character(4)	VARCHAR2(4) NOT NULL	Form Field Length Type indicates which child form data table contains the data, depending on the length type (xlat). C040=Char 40 C128=Char 128 C254=Char 254 CLNG=Char Long
27	FORM_FIELD_NAME	Character(18)	VARCHAR2(18) NOT NULL	Form Field Name corresponds to a page field name, only for a printed form instead of an online page.
28	FORM_GROUP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Descr field from record FANLTR_FORM_TYP.
29	FORM_GROUP_ID	Character(18)	VARCHAR2(18) NOT NULL	Form Group ID groups forms together.
30	FORM_GROUP_SEQ	Number(9,0)	DECIMAL(9) NOT NULL	Form Group Sequence enables the sequencing of form groups within a FORM_PROC_INST. Each time a group of forms begins to print, this value is incremented and stays the same within that form group. If the same form group prints again, it is incremented again, so that it is not the same value if the same form group prints twice.
31	FORM_GROUP_SUB_SEQ	Number(7,0)	INTEGER NOT NULL	Form Group Sub Sequence is a sequence number within a form group, one per form. When a new form group begins to print, this sequence number starts back at one.
32	FORM_INPUT_INST	Number(10,0)	DECIMAL(10) NOT NULL	Form Input Instance is the process instance of the job that appended or initially loaded data into a set of output forms being grouped by the same FORM_PROC_INST.
33	FORM_NAME	Character(18)	VARCHAR2(18) NOT NULL	Form Name is the unique id of the form. This corresponds to a page name.
34	FORM_PROC_INST	Number(31,0)	DECIMAL(31) NOT NULL	Form Process Instance collects one or more input jobs (or process instances) into a single output collection for processing. Typically, one form process instance is one batch of output to be printed together.
35	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
36	IS_SCHEDULED_PROC	Character(1)	VARCHAR2(1) NOT NULL	Boolean Y/N indicates whether this is a scheduled process. Y -> it IS a scheduled process. N -> it is NOT a scheduled process. (e.g. remote call).
37	LAST_FORM_GRP_SEQ	Number(9,0)	DECIMAL(9) NOT NULL	Last Form Group Sequence.
38	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
39	PRINT_VIA_SCRIPT	Character(1)	VARCHAR2(1) NOT NULL	Boolean to indicate whether or not to print via a script, as opposed to printing directly to the printer.
40	PRINTER_NAME	Character(127)	VARCHAR2(127) NOT NULL	Printer Name
41	PRINTER_NAME_HOLD	Character(127)	VARCHAR2(127) NOT NULL	Printer Name Hold Save the old printer name here for later restoration.
42	PROCESSING_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Aid Package Processing Status 0=No Electronic Application 1=Applied 2=Ready For Counselor Review 3=Ready for Packaging 4=Repackage 9=Packaging Completed
43	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
44	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
45	SORT_NAME	Character(18)	VARCHAR2(18) NOT NULL	Sort Name is the name of a sort order.