FORM_8863

(SQL Table)
Index Back

Form 8863 for 1998

This table holds data for Form 8863, Education Credits for 1998 tax year.

# 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