SCHEDULE_2

#	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	S2_TOT_LINE_2	Signed Number(7,0)	DECIMAL(6) NOT NULL	2 Total of Part I
7	S2_QUALFY_PERSONS	Number(2,0)	SMALLINT NOT NULL	3 Qualifying Persons
8	S2_P2_QLFIED_EXP	Signed Number(7,0)	DECIMAL(6) NOT NULL	4 Qualified Expenses
9	S2_EARNED_INCOME	Signed Number(7,0)	DECIMAL(6) NOT NULL	5 Earned Income
10	S2_SPOUSE_INCOME	Signed Number(7,0)	DECIMAL(6) NOT NULL	6 Spouse's Income
11	S2_SMALLEST_4_5_6	Signed Number(7,0)	DECIMAL(6) NOT NULL	7 Smallest of line 4,5,6
12	S2_AMT_FROM_17	Signed Number(7,0)	DECIMAL(6) NOT NULL	7 Adjusted Gross Income
13	S2_DECIMAL_LINE_9	Number(3,2)	DECIMAL(2,2) NOT NULL	9 Decimal Amount
14	S2_LINE_10	Signed Number(7,0)	DECIMAL(6) NOT NULL	10 Multiply line 7 by line 9
15	S2_DPDNT_CARE_BNFT	Signed Number(7,0)	DECIMAL(6) NOT NULL	10 Dependent Care Benefits
16	S2_AMNT_FORFEITED	Signed Number(7,0)	DECIMAL(6) NOT NULL	11 Amount Forfeited
17	S2_DIFRNCE_11_12	Signed Number(7,0)	DECIMAL(6) NOT NULL	13 Subtract line 12 from 11
18	S2_P3_QLFIED_EXP	Signed Number(7,0)	DECIMAL(6) NOT NULL	13 Qualified Expenses
19	S2_SMALLER_13_14	Signed Number(7,0)	DECIMAL(6) NOT NULL	15 Smaller of line 13 or 14
20	S2_P3_ERND_INCOME	Signed Number(7,0)	DECIMAL(6) NOT NULL	16 Earned Income
21	S2_P3_SPOUSE_INC	Signed Number(7,0)	DECIMAL(6) NOT NULL	17 Spouse's Income
22	S2_LINE_18	Signed Number(7,0)	DECIMAL(6) NOT NULL	18 Smallest of line 15,16,17
23	S2_EXCLUDED_BENFTS	Signed Number(7,0)	DECIMAL(6) NOT NULL	19 Excluded Benefits
24	S2_TAXBLE_BENEFITS	Signed Number(7,0)	DECIMAL(6) NOT NULL	20 Taxable Benefits
25	S2P3_2_QLFY_EXPENS	Signed Number(7,0)	DECIMAL(6) NOT NULL	21 Qualified Expenses
26	S2_AMT_QLFY_PRSNS	Signed Number(7,0)	DECIMAL(6) NOT NULL	22 Amt for Qualifying Person
27	S2_AMT_FROM_19	Signed Number(7,0)	DECIMAL(6) NOT NULL	23 Amount from line 19
28	S2_DIF_22_23	Signed Number(7,0)	DECIMAL(6) NOT NULL	24 Subtract line 23 from 22
29	S2_SML_21_24	Signed Number(7,0)	DECIMAL(6) NOT NULL	25 Smaller of line 21 and 24