SCHEDULE_D

#	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	D_ST_TOT_FROM_21	Signed Number(7,0)	DECIMAL(6) NOT NULL	2 Short-Term Totals From 21
7	D_ST_SP_AMT	Signed Number(7,0)	DECIMAL(6) NOT NULL	3 Total Short-Term Sales
8	D_NET_ST_LOSS	Signed Number(7,0)	DECIMAL(6) NOT NULL	5 Net Short-Term Loss
9	D_NET_ST_GAIN	Signed Number(7,0)	DECIMAL(6) NOT NULL	5 Loss/Gain from Sch K-1
10	D_ST_CRY_LOSS	Signed Number(7,0)	DECIMAL(6) NOT NULL	6 Loss Carryover
11	D_TOT_ST_LOSS	Signed Number(7,0)	DECIMAL(6) NOT NULL	7 Total
12	D_TOT_ST_GAIN	Signed Number(7,0)	DECIMAL(6) NOT NULL	7 Total Short-Term Gain
13	D_NET_ST_CPT_GN_LS	Signed Number(7,0)	DECIMAL(6) NOT NULL	8 Net Loss/Gain
14	D_LT_FROM_23	Signed Number(7,0)	DECIMAL(6) NOT NULL	10 Long-Term Totals From 23
15	D_LT_SP_AMT	Signed Number(7,0)	DECIMAL(6) NOT NULL	11 Total Long-Term Sales
16	D_LT_L12_LOSS	Signed Number(7,0)	DECIMAL(6) NOT NULL	12 Loss
17	D_LT_L12_GAIN	Signed Number(7,0)	DECIMAL(6) NOT NULL	12 Loss/Gains from Forms
18	D_NET_LT_LOSS	Signed Number(7,0)	DECIMAL(6) NOT NULL	13 Loss/Gain From Sch K-1
19	D_NET_LT_GAIN	Signed Number(7,0)	DECIMAL(6) NOT NULL	13 Net Long Term Gain
20	D_CPT_GAIN_DISTRB	Signed Number(7,0)	DECIMAL(6) NOT NULL	14 Capital Gain Distribution
21	D_LT_CRY_LOSS	Signed Number(7,0)	DECIMAL(6) NOT NULL	15 Loss Carryover
22	D_TOT_LT_LOSS	Signed Number(7,0)	DECIMAL(6) NOT NULL	16 Total
23	D_TOT_LT_GAIN	Signed Number(7,0)	DECIMAL(6) NOT NULL	16 Total Long-Term Gain
24	D_NET_LT_CPT_GN_LS	Signed Number(7,0)	DECIMAL(6) NOT NULL	17 Net Loss/Gain
25	D_TOT_GAIN	Signed Number(7,0)	DECIMAL(6) NOT NULL	18 Total Gain
26	D_TOT_LOSS	Signed Number(7,0)	DECIMAL(6) NOT NULL	19 Total Loss
27	D_ST_TOT_L21	Signed Number(7,0)	DECIMAL(6) NOT NULL	21 Totals
28	D_LT_TOT_L23	Signed Number(7,0)	DECIMAL(6) NOT NULL	23 Totals
29	SD_TAXABLE_INCOME	Signed Number(7,0)	DECIMAL(6) NOT NULL	19 Taxable Income
30	SD_DIFRNCE_26_22	Signed Number(7,0)	DECIMAL(6) NOT NULL	27 Subtract line 26 from 22
31	SD_SMALLER_28_29	Signed Number(7,0)	DECIMAL(6) NOT NULL	30 Smaller of line 28 or 29
32	SD_LARGER_30_31	Signed Number(7,0)	DECIMAL(6) NOT NULL	32 Larger of line 30 or 31
33	SD_MULTIPLY_36_10	Signed Number(7,0)	DECIMAL(6) NOT NULL	37 Multiply 36 by .10
34	SD_DIFRNCE_39_38	Signed Number(7,0)	DECIMAL(6) NOT NULL	40 Subtract line 39 from 38
35	SD_MULTIPLY_40_20	Signed Number(7,0)	DECIMAL(6) NOT NULL	41 Multiply line 40 by .20
36	SD_DIFRNCE_45_42	Signed Number(7,0)	DECIMAL(6) NOT NULL	46 Subtract line 45 from 42
37	SD_MULTIPLY_46_25	Signed Number(7,0)	DECIMAL(6) NOT NULL	47 Multiply line 46 by .25
38	SD_ADD_32_36_40_46	Signed Number(7,0)	DECIMAL(6) NOT NULL	49 Add lines 32, 36, 40 & 46
39	SD_DIFRNCE_49_48	Signed Number(7,0)	DECIMAL(6) NOT NULL	50 Subtract line 49 from 48
40	SD_MULTIPLY_50_28	Signed Number(7,0)	DECIMAL(6) NOT NULL	51 Multiply line 50 by .28
41	SD_33_37_41_47_51	Signed Number(7,0)	DECIMAL(6) NOT NULL	52 Add lines 33,37,41,47 & 51
42	SD_TAX_TAXABLE_INC	Signed Number(7,0)	DECIMAL(6) NOT NULL	54 Tax on Taxable Income
43	SD_TAX	Signed Number(7,0)	DECIMAL(6) NOT NULL	25 Tax
44	SD_LINE20_TAX	Signed Number(7,0)	DECIMAL(6) NOT NULL	39 Tax on amount on line 20