SCHEDULE_E

#	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	E_RENTS_RECEIVED	Signed Number(7,0)	DECIMAL(6) NOT NULL	3 Rents Received
7	E_ROYALTIES	Signed Number(7,0)	DECIMAL(6) NOT NULL	4 Royalties Received
8	E_MRTG_INT	Signed Number(7,0)	DECIMAL(6) NOT NULL	12 Mortgage Interest
9	E_TOT_LINE_19	Signed Number(7,0)	DECIMAL(6) NOT NULL	19 Add Lines 5 Through 18
10	E_DEPRECIATION	Signed Number(7,0)	DECIMAL(6) NOT NULL	20 Depreciation
11	E_INCOME	Signed Number(7,0)	DECIMAL(6) NOT NULL	24 Income
12	E_LOSSES	Signed Number(7,0)	DECIMAL(6) NOT NULL	25 Losses
13	E_TOT_LINE_26	Signed Number(7,0)	DECIMAL(6) NOT NULL	26 Total rental Real Estate
14	E_TOT_LINE_29	Signed Number(7,0)	DECIMAL(6) NOT NULL	29 Clmns (h) + (k) line 28a
15	E_TOT_LINE_30	Signed Number(7,0)	DECIMAL(6) NOT NULL	30 Add (g),(i),(j) line 28b
16	E_TOT_PART_31	Signed Number(7,0)	DECIMAL(6) NOT NULL	31 Total Partnership
17	E_EMP_A_ID_NBR	Character(9)	VARCHAR2(9) NOT NULL	32a EIN(A)
18	E_EMP_B_ID_NBR	Character(9)	VARCHAR2(9) NOT NULL	32b EIN(B)
19	E_TOT_LINE_34	Signed Number(7,0)	DECIMAL(6) NOT NULL	34 Add (d),(f) Of Line 33a
20	E_TOT_LINE_35	Signed Number(7,0)	DECIMAL(6) NOT NULL	35 Add (c), (e) Of Line 33b
21	E_TOT_LINE_36	Signed Number(7,0)	DECIMAL(6) NOT NULL	36 Total Estate Income/Loss
22	E_TOT_LINE_38	Signed Number(7,0)	DECIMAL(6) NOT NULL	38 Combine (d) and (e)
23	E_NET_FARM_RENT_IN	Signed Number(7,0)	DECIMAL(6) NOT NULL	39 Net Farm Rental Income
24	E_TOT_INCOME	Signed Number(7,0)	DECIMAL(6) NOT NULL	40 TOTAL Income or (Loss)
25	E_RCNCL_FARM_INC	Signed Number(7,0)	DECIMAL(6) NOT NULL	41 Reconciliation of Farming
26	E_RCNCL_REAL_PRO	Signed Number(7,0)	DECIMAL(6) NOT NULL	42 Reconciliation for Real E