EMPLIDPrompt Table: STUDENT_AID
INSTITUTIONPrompt Table: INSTITUTION_TBL
AID_YEARPrompt Table: STUDENT_AID
SEQUENCE_NBRSCH_NBRSCHEDULE_A(SQL Table) |
Index Back |
|---|---|
Schdule A--Itemized DeductionsData collection for schedule A |
| # | 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 |
| 6 | A_MED_TOTAL | Signed Number(7,0) | DECIMAL(6) NOT NULL | 4 Total Medical & Dental Exp |
| 7 | A_INCOME_TAX | Signed Number(7,0) | DECIMAL(6) NOT NULL | 5 State and Local |
| 8 | A_REL_TAX | Signed Number(7,0) | DECIMAL(6) NOT NULL | 6 Real Estate |
| 9 | A_PERSONAL_TAX | Signed Number(7,0) | DECIMAL(6) NOT NULL | 7 Personal Property |
| 10 | A_OTHER_TAX | Signed Number(7,0) | DECIMAL(6) NOT NULL | 8 Other Taxes |
| 11 | A_TAX_TOTAL | Signed Number(7,0) | DECIMAL(6) NOT NULL | 9 Total of Taxes Paid |
| 12 | A_1098_INTRST | Signed Number(7,0) | DECIMAL(6) NOT NULL | 10 Home Mortgage |
| 13 | A_NON_1098_INTRST | Signed Number(7,0) | DECIMAL(6) NOT NULL | 11 Home mortgage -unreported |
| 14 | A_POINTS | Signed Number(7,0) | DECIMAL(6) NOT NULL | 12 Points Not Reported |
| 15 | A_INVSTMT_INTRST | Signed Number(7,0) | DECIMAL(6) NOT NULL | 13 Investment |
| 16 | A_INTRST_TOT | Signed Number(7,0) | DECIMAL(6) NOT NULL | 14 Total of Interest Paid |
| 17 | A_CHRTY_CASH | Signed Number(7,0) | DECIMAL(6) NOT NULL | 15 Gifts by Cash |
| 18 | A_CHRTY_GIFT | Signed Number(7,0) | DECIMAL(6) NOT NULL | 16 Gifts Other Than Cash |
| 19 | A_CHRTY_PRIOR | Signed Number(7,0) | DECIMAL(6) NOT NULL | 17 Carryover from Prior Year |
| 20 | A_CHRTY_TOT | Signed Number(7,0) | DECIMAL(6) NOT NULL | 18 Total of Gifts to Charity |
| 21 | A_CASUALTY | Signed Number(7,0) | DECIMAL(6) NOT NULL | 19 Casualty Loss |
| 22 | A_JOB_EXPNS | Signed Number(7,0) | DECIMAL(6) NOT NULL | 20 Unreimbursed Emp Exp |
| 23 | A_TAX_FEE | Signed Number(7,0) | DECIMAL(6) NOT NULL | 21 Tax Fees |
| 24 | A_OTHER_EXP | Signed Number(7,0) | DECIMAL(6) NOT NULL | 22 Other Expenses |
| 25 | A_MISC_TOT | Signed Number(7,0) | DECIMAL(6) NOT NULL | 23 Total of Job Expenses |
| 26 | A_LINE_25 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 25 Multiply AGI by 2% |
| 27 | A_JOB_EXP_ALLOW | Signed Number(7,0) | DECIMAL(6) NOT NULL | 26 Total of Misc Deduction |
| 28 | A_MISC_EXP | Signed Number(7,0) | DECIMAL(6) NOT NULL | 27 Other Misc Expenses |
| 29 | A_TOT_DED | Signed Number(7,0) | DECIMAL(6) NOT NULL | 28 Total Deduction |
| 30 | SFA_A_QUAL_MOR_INS | Signed Number(7,0) | DECIMAL(6) NOT NULL | Qualified Mortgage Insurance |