FORM_8863

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: STUDENT_AID
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
3	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Prompt Table: STUDENT_AID
4	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
5	SCH_NBR	Character(4)	VARCHAR2(4) NOT NULL	Schedule Number Default Value: 8863
6	F8863_LINE_2	Signed Number(7,0)	DECIMAL(6) NOT NULL	2 Add the amounts in (d) (f)
7	F8863_LINE_3	Signed Number(7,0)	DECIMAL(6) NOT NULL	3 Add the amounts on line 2
8	F8863_LINE_5	Signed Number(7,0)	DECIMAL(6) NOT NULL	5 Add the amounts on line 4
9	F8863_LINE_6	Signed Number(7,0)	DECIMAL(6) NOT NULL	6 Smaller of line 5 or $5000
10	F8863_LINE_7	Signed Number(11,3)	DECIMAL(9,3) NOT NULL	7 Multiply line 6 by .20
11	F8863_LINE_8	Signed Number(7,0)	DECIMAL(6) NOT NULL	8 Add lines 3 and 7
12	F8863_LINE_9	Signed Number(7,0)	DECIMAL(6) NOT NULL	9 Enter Allowance
13	F8863_LINE_10	Signed Number(7,0)	DECIMAL(6) NOT NULL	10 Enter Allowance
14	F8863_LINE_11	Signed Number(7,0)	DECIMAL(6) NOT NULL	11 Subtract line 10 from 9
15	F8863_LINE_12	Signed Number(7,0)	DECIMAL(6) NOT NULL	12 Enter Allowance
16	F8863_LINE_13	Signed Number(11,3)	DECIMAL(9,3) NOT NULL	13 Is line 11 > or < line 12?
17	F8863_LINE_14	Signed Number(7,0)	DECIMAL(6) NOT NULL	14 Multiply line 8 by line 13
18	F8863_LINE_15	Signed Number(7,0)	DECIMAL(6) NOT NULL	15 Enter 1040 line 40
19	F8863_LINE_16	Signed Number(7,0)	DECIMAL(6) NOT NULL	16 Total from 1040 line 40-41
20	F8863_LINE_17	Signed Number(7,0)	DECIMAL(6) NOT NULL	17 Subtract line 16 from 15
21	F8863_LINE_18	Signed Number(7,0)	DECIMAL(6) NOT NULL	18 Total Credit Line 14 or 17