SCHEDULE_EIC

#	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 Default Value: EIC
6	EIC_CHILD1_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Child1
7	EIC_CHILD1_DOB	Date(10)	DATE	2 Year of Birth Child1
8	EIC_CHILD1_UNDR_24	Character(1)	VARCHAR2(1) NOT NULL	a Under age 24 Y/N Table Edit Default Value: N
9	EIC_CHILD1_DSBLD	Character(1)	VARCHAR2(1) NOT NULL	b Permanently Disabled Y/N Table Edit Default Value: N
10	EIC_CHILD1_SS_NBR	Character(9)	VARCHAR2(9) NOT NULL	4 SS NBR
11	EIC_CHILD1_REL	Character(2)	VARCHAR2(2) NOT NULL	5 Child's Relationship BR=Brother DA=Daughter GD=Grand Daughter GS=GrandSon NE=Nephew NI=Niece SD=Step Daughter SI=Sister SO=Son SS=Step Son
12	EIC_CHILD1_NBR_MNT	Number(3,0)	SMALLINT NOT NULL	6 Number of Months
13	EIC_CHILD2_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Child2
14	EIC_CHILD2_DOB	Date(10)	DATE	2 Year of Birth Child2
15	EIC_CHILD2_UNDR_24	Character(1)	VARCHAR2(1) NOT NULL	a Under Age 24 Y/N Table Edit Default Value: N
16	EIC_CHILD2_DSBLD	Character(1)	VARCHAR2(1) NOT NULL	b Permanently Disabled Y/N Table Edit Default Value: N
17	EIC_CHILD2_SS_NBR	Character(9)	VARCHAR2(9) NOT NULL	4 SS NBR
18	EIC_CHILD2_REL	Character(2)	VARCHAR2(2) NOT NULL	5 Relationship Child2 BR=Brother DA=Daughter GS=Grand Son NE=Nehpew NI=Niece SD=Step Daughter SI=Sister SO=Son SS=Step Son
19	EIC_CHILD2_NBR_MNT	Number(3,0)	SMALLINT NOT NULL	6 NBR of Months
20	EIC_CHILD1_YR_DOB	Character(4)	VARCHAR2(4) NOT NULL	2 Year of Birth
21	EIC_CHILD2_YR_DOB	Character(4)	VARCHAR2(4) NOT NULL	2 Year of Birth