VERIF_STU_FLDS

#	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
3	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year
4	FIELD_NUMBER	Number(3,0)	SMALLINT NOT NULL	Field Number
5	USE_FOR_FED	Character(1)	VARCHAR2(1) NOT NULL	Use For Federal Verification Y/N Table Edit Default Value: Y
6	USE_FOR_INST	Character(1)	VARCHAR2(1) NOT NULL	Use For Instituional Verif Y/N Table Edit Default Value: Y
7	USE_FOR_IND_FED	Character(1)	VARCHAR2(1) NOT NULL	Use in Fed Ver with Indep Stu Y/N Table Edit Default Value: Y
8	USE_FOR_DEP_FED	Character(1)	VARCHAR2(1) NOT NULL	Use in Fed Verif with Dep Stu Y/N Table Edit Default Value: Y
9	USE_FOR_IND_INST	Character(1)	VARCHAR2(1) NOT NULL	Use in Inst Verif for Ind Stu Y/N Table Edit Default Value: Y
10	USE_FOR_DEP_INST	Character(1)	VARCHAR2(1) NOT NULL	Use in Inst Verif with Dep Stu Y/N Table Edit Default Value: Y
11	TOL_AMT_FED	Signed Number(8,0)	DECIMAL(7) NOT NULL	Tolerance Amt Federal
12	TOL_AMT_INST	Signed Number(8,0)	DECIMAL(7) NOT NULL	Tolerance Amount Institutional
13	TOL_PCT_FED	Signed Number(4,0)	DECIMAL(3) NOT NULL	Tolerance Pct Federal
14	TOL_PCT_INST	Signed Number(4,0)	DECIMAL(3) NOT NULL	Tolerance Pct Institutional
15	AMT_PCT_IND_FED	Character(1)	VARCHAR2(1) NOT NULL	Amount Pct Indicator Federal A=Use Amount P=Use Pct Default Value: A
16	AMT_PCT_IND_INST	Character(1)	VARCHAR2(1) NOT NULL	Amt or Pct Institutional A=Use Amount P=Use Pct Default Value: A
17	TABLE_ID	Character(1)	VARCHAR2(1) NOT NULL	Child Table Key