EMPLIDPrompt Table: STUDENT_AID
INSTITUTIONPrompt Table: INSTITUTION_TBL
AID_YEARPrompt Table: STUDENT_AID
SEQUENCE_NBRSCH_NBRY/N Table Edit
Default Value: N
Prompt Table: COUNTRY_TBL
Y/N Table Edit
Default Value: N
SCHEDULE1(SQL Table) |
Index Back |
|---|---|
Interest and Dividend IncomeData collection table for schedule 1 |
| # | 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 | S1_TOT_LINE2 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 2 Total Line 2 |
| 7 | S1_EXCLUDABLE_INT | Signed Number(7,0) | DECIMAL(6) NOT NULL | 3 Excludable Interest |
| 8 | S1_P1_TOTAL | Signed Number(7,0) | DECIMAL(6) NOT NULL | 4 Total Part I |
| 9 | B_DIV_INC | Signed Number(7,0) | DECIMAL(6) NOT NULL | 6 Line 6 |
| 10 | B_CAPTL_GAIN | Signed Number(7,0) | DECIMAL(6) NOT NULL | 7 Capital gain distributions |
| 11 | B_NON_TAX_DIST | Signed Number(7,0) | DECIMAL(6) NOT NULL | 8 Nontaxable distributions |
| 12 | B_DIVIDEND_TOT | Signed Number(7,0) | DECIMAL(6) NOT NULL | 9 Line 7 + Line 8 |
| 13 | S1_P2_TOTAL | Signed Number(7,0) | DECIMAL(6) NOT NULL | 6 Total Part II |
| 14 | B_FOREIGN_ACCOUNT | Character(1) | VARCHAR2(1) NOT NULL |
11a Foreign Account
Y/N Table Edit Default Value: N |
| 15 | B_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
b Country
Prompt Table: COUNTRY_TBL |
| 16 | B_FOREIGN_DISTR | Character(1) | VARCHAR2(1) NOT NULL |
12 Foreign distribution
Y/N Table Edit Default Value: N |