FORM_8863(SQL Table) |
Index Back |
---|---|
Form 8863 for 1998This 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 |