SCHEDULE_H

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
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: AID_YEAR_TBL
4	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
5	SCH_NBR	Character(4)	VARCHAR2(4) NOT NULL	Schedule Number
6	H_TOT_LINE_1	Signed Number(7,0)	DECIMAL(6) NOT NULL	1 Total Line 1
7	H_SS_TAXES	Signed Number(7,0)	DECIMAL(6) NOT NULL	2 Social Security Taxes
8	H_TOT_LINE_3	Signed Number(7,0)	DECIMAL(6) NOT NULL	3 Total Line 3
9	H_MEDICARE_TAXES	Signed Number(7,0)	DECIMAL(6) NOT NULL	4 Medicare Taxes
10	H_FED_INCOME_TAX	Signed Number(7,0)	DECIMAL(6) NOT NULL	5 Fed Income Tax Withheld
11	H_LINE_6	Signed Number(7,0)	DECIMAL(6) NOT NULL	6 Add Lines 2,4, and 5
12	H_ADV_ERND_INC_CRD	Signed Number(7,0)	DECIMAL(6) NOT NULL	7 Advance EIC Payments
13	H_TOT_LINE_8	Signed Number(7,0)	DECIMAL(6) NOT NULL	8 Total Line 8
14	H_LINE_9	Character(1)	VARCHAR2(1) NOT NULL	9 Line 9 Y/N Table Edit Default Value: N
15	H_LINE_10	Character(1)	VARCHAR2(1) NOT NULL	10 Line 10 Y/N Table Edit Default Value: N
16	H_LINE_11	Character(1)	VARCHAR2(1) NOT NULL	11 Line 11 Y/N Table Edit Default Value: N
17	H_LINE_12	Character(1)	VARCHAR2(1) NOT NULL	12 Line 12 Y/N Table Edit Default Value: N
18	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: ST_NAMES_FA_VW
19	H_STATE_REP_NBR	Signed Number(7,0)	DECIMAL(6) NOT NULL	14 State Reporting Number
20	H_LINE_15	Signed Number(7,0)	DECIMAL(6) NOT NULL	15 Contributions Paid
21	H_TOT_FUTA_TAX	Signed Number(7,0)	DECIMAL(6) NOT NULL	16 Total Wages Sub to FUTA
22	H_FUTA_TAX	Signed Number(7,0)	DECIMAL(6) NOT NULL	17 FUTA Tax
23	H_TOT_LINE_19_COLH	Signed Number(7,0)	DECIMAL(6) NOT NULL	19 Totals Column h
24	H_TOT_LINE_19_COLI	Signed Number(7,0)	DECIMAL(6) NOT NULL	19 Totals Columns I
25	H_LINE_20	Signed Number(7,0)	DECIMAL(6) NOT NULL	20 Add Cols h & i of line 19
26	H_LINE_21	Signed Number(7,0)	DECIMAL(6) NOT NULL	21 Total Wages Sub to FUTA
27	H_LINE_22	Signed Number(7,0)	DECIMAL(6) NOT NULL	22 Line 22
28	H_LINE_23	Signed Number(7,0)	DECIMAL(6) NOT NULL	23 Line 23
29	H_LINE_24	Signed Number(7,0)	DECIMAL(6) NOT NULL	24 Smaller of line 20 or 23
30	H_LINE_25	Signed Number(7,0)	DECIMAL(6) NOT NULL	25 FUTA Tax
31	H_LINE_26	Signed Number(7,0)	DECIMAL(6) NOT NULL	26 Amount From Line 8 Default Value: SCHEDULE_H.H_TOT_LINE_8
32	H_LINE_27	Signed Number(7,0)	DECIMAL(6) NOT NULL	27 Add Line 17/25 & line 26
33	H_LINE_28	Character(1)	VARCHAR2(1) NOT NULL	28 Line 28 Y/N Table Edit Default Value: N