SCHEDULE_3

#	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	S3_65_OR_OLDER	Character(1)	VARCHAR2(1) NOT NULL	1 65 or older Y/N Table Edit Default Value: N
7	S3_UNDER_65	Character(1)	VARCHAR2(1) NOT NULL	2 Under 65 Y/N Table Edit Default Value: N
8	S3_BOTH_65_OR_OLDR	Character(1)	VARCHAR2(1) NOT NULL	3 Both were 65 or older Y/N Table Edit Default Value: N
9	S3_B_UN_65_ONE_RET	Character(1)	VARCHAR2(1) NOT NULL	Both spses un 65 & 1 retired Y/N Table Edit Default Value: N
10	S3_B_UN_65_TWO_RET	Character(1)	VARCHAR2(1) NOT NULL	Both sps un 65 & retired Y/N Table Edit Default Value: N
11	S3_1OV65_2UN65_RET	Character(1)	VARCHAR2(1) NOT NULL	One 65 & 2nd un65 & retired Y/N Table Edit Default Value: N
12	S3_F65_SUN65_NORET	Character(1)	VARCHAR2(1) NOT NULL	One 65 & 2nd un65 & no retired Y/N Table Edit Default Value: N
13	S3_65_LIVE_APART	Character(1)	VARCHAR2(1) NOT NULL	You 65 and lived apart Y/N Table Edit Default Value: N
14	S3_UN65_RET_L_APRT	Character(1)	VARCHAR2(1) NOT NULL	Under 65 retired & lived apart Y/N Table Edit Default Value: N
15	CONTINUED_DISABLED	Character(1)	VARCHAR2(1) NOT NULL	Your continued disabled Y/N Table Edit Default Value: N
16	S3_P1_STATUS_CKBOX	Character(1)	VARCHAR2(1) NOT NULL	Status Check Box of Part I Y/N Table Edit Default Value: N
17	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
18	S3_LINE_10	Signed Number(7,0)	DECIMAL(6) NOT NULL	10 Line 10
19	S3_LINE_11	Signed Number(7,0)	DECIMAL(6) NOT NULL	11 Line 11
20	S3_L12_SMLER_11_10	Signed Number(7,0)	DECIMAL(6) NOT NULL	12 Smaller of line 10 or 11
21	S3_LINE_13A	Signed Number(7,0)	DECIMAL(6) NOT NULL	13a Line 13a
22	S3_LINE_13B	Signed Number(7,0)	DECIMAL(6) NOT NULL	13b Line 13b
23	S3_LINE_13C	Signed Number(7,0)	DECIMAL(6) NOT NULL	13c Add lines 13a and 13b
24	S3_LINE_17_1040A	Signed Number(7,0)	DECIMAL(6) NOT NULL	14 Line 17 from 1040A
25	S3_LINE_15	Signed Number(7,0)	DECIMAL(6) NOT NULL	15 Line 15
26	S3_LINE_16	Signed Number(7,0)	DECIMAL(6) NOT NULL	16 Subtract 15 from 14
27	S3_L17_HALF_OF_L16	Signed Number(7,0)	DECIMAL(6) NOT NULL	17 One half of 16
28	S3_LINE_18	Signed Number(7,0)	DECIMAL(6) NOT NULL	18 Add 13c and 17
29	S3_LINE_19	Signed Number(7,0)	DECIMAL(6) NOT NULL	19 Subtract 18 from 12
30	S3_LINE_20	Signed Number(7,0)	DECIMAL(6) NOT NULL	20 Multiply 19 by 15%