INAS_FED_EXT

#	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	INAS_RULE_SET	Character(4)	VARCHAR2(4) NOT NULL	Option Rule Set BASE=CSS Rules/Values HLTH=Health Professional STD=Undergrad/Graduate
5	INAS_DATA_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Data Source B=Both Federal & Institutional F=Federal Data I=Institutional Data
6	INAS_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Calc Type B=Both FM & IM F=Federal Methodology I=Institutional Methodology
7	BUDGET_DURATION	Number(2,0)	SMALLINT NOT NULL	Budget Duration
8	DEPENDENCY_OVERIDE	Character(1)	VARCHAR2(1) NOT NULL	Dependency Override I=Independent - Prof Judgement N=No - Suppress
9	CALC_FED_TAX_S_FM	Character(1)	VARCHAR2(1) NOT NULL	Calc Fed Tax Y/N Table Edit
10	CALC_FED_TAX_P_FM	Character(1)	VARCHAR2(1) NOT NULL	Calc Fed Tax Y/N Table Edit
11	CALC_PC_FOR_IND	Character(1)	VARCHAR2(1) NOT NULL	Calc a PC for Independent Y/N Table Edit
12	ALWNC_TUIT_S	Character(5)	VARCHAR2(5) NOT NULL	Tuition
13	ALWNC_MED_DENT_S	Character(10)	VARCHAR2(10) NOT NULL	Medical/Dental
14	ALWNC_OTHER_S	Character(5)	VARCHAR2(5) NOT NULL	Other
15	ASSET_ALWNC_S	Character(10)	VARCHAR2(10) NOT NULL	Asset Allowance
16	ASSET_OTHER	Character(6)	VARCHAR2(6) NOT NULL	Other Income Allwnc
17	ALWNC_TUIT_P	Character(10)	VARCHAR2(10) NOT NULL	Tuition
18	ALWNC_MED_DENT_P	Character(10)	VARCHAR2(10) NOT NULL	Medical/Dental
19	ALWNC_OTHER_P	Character(5)	VARCHAR2(5) NOT NULL	Other Income Allwnc
20	ASSET_ALWNC_P	Character(10)	VARCHAR2(10) NOT NULL	Asset
21	ASSET_OTHER_P	Character(6)	VARCHAR2(6) NOT NULL	Other Asset Allwnc
22	ADJ_EFC_AMT	Signed Number(6,0)	DECIMAL(5) NOT NULL	Adjust EFC
23	EIC_OVERRIDE_S	Character(1)	VARCHAR2(1) NOT NULL	Override Student EIC Asmptn 1=Override Asmptns-Use ISIR EIC 3=Don't Override Asmptns
24	EIC_OVERRIDE_P	Character(1)	VARCHAR2(1) NOT NULL	Override Parent EIC Asmptn 1=Override Asmptns-Use ISIR EIC 3=Don't Override Asmptns
25	PAR_NO_CLG_OVRRD	Character(1)	VARCHAR2(1) NOT NULL	Override Par Num in Col Asmptn 1=Override Asmptns-Use ISIR NIC 3=Don't Override Asmptns
26	BUDGET_DURATION_A	Number(2,0)	SMALLINT NOT NULL	Budget Duration - Acad Per
27	BUDGET_DURATION_N	Number(2,0)	SMALLINT NOT NULL	Budget Duration - Non-Std
28	BIRTH_YR_REJ_OVRRD	Character(1)	VARCHAR2(1) NOT NULL	Birth Year Reject Override. Option to override INAS' 'Birth Year' reject edit. 1=Suppress Reject A-Use reptd BY 3=Don't Suppress Reject A
29	TAXES_PD_REJ_OVRRD	Character(1)	VARCHAR2(1) NOT NULL	Option to override the 'Dependent student's Parent's Taxes Paid' and the 'Indepedent student's Taxes Paid' reject edits. 1=Suppress Reject C-Use reptd TP 3=Don't Suppress Reject C
30	OVRD_SC_AMT_A	Signed Number(8,0)	DECIMAL(7) NOT NULL	Student Contribution Override for the Academic Award Period.
31	OVRD_SC_AMT_N	Signed Number(8,0)	DECIMAL(7) NOT NULL	Student Contribution Override for the Non-Standard Award Period.
32	OVRD_SC_AMT	Signed Number(8,0)	DECIMAL(7) NOT NULL	Student Contribution Override for the Aid Year.
33	OVRD_PC_AMT_A	Signed Number(8,0)	DECIMAL(7) NOT NULL	Parent Contribution Override for the Academic Award Period.
34	OVRD_PC_AMT_N	Signed Number(8,0)	DECIMAL(7) NOT NULL	Parent Contribution Override for the Non-Standard Award Period.
35	OVRD_PC_AMT	Signed Number(8,0)	DECIMAL(7) NOT NULL	Parent Contribution Override for the Aid Year.
36	OVRD_EFC_AMT_A	Signed Number(8,0)	DECIMAL(7) NOT NULL	Estimated Family Contribution Override for the Academic Award Period.
37	OVRD_EFC_AMT_N	Signed Number(8,0)	DECIMAL(7) NOT NULL	Estimated Family Contribution Override for the Non-Standard Award Period.
38	OVRD_EFC_AMT	Signed Number(8,0)	DECIMAL(7) NOT NULL	Estimated Family Contribution Override for the Aid Year.
39	USE_EFC_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Flag that triggers usage of EFC Override values in Need Analysis calculations.
40	FM_EFC_PRORTN_ACAD	Character(1)	VARCHAR2(1) NOT NULL	Academic Proration Method 1=Use Monthly EFCs 2=Adjust Based on Total EFC 3=Proportion Monthly Share
41	FM_EFC_PRORTN_NSTD	Character(1)	VARCHAR2(1) NOT NULL	Non-Standard Proration Method 1=Leading Months 2=Trailing Months 3=FA Term Based
42	SSN_NO_DOB_REJ_OVR	Character(1)	VARCHAR2(1) NOT NULL	Option to suppress ISIR Reject 'R' - SSN Match but no Date of Birth match. 1=Suppress Reject R 3=Don't Suppress Reject R
43	SSN_D_NAME_REJ_OVR	Character(1)	VARCHAR2(1) NOT NULL	Option to suppress ISIR Reject 'S' - Dad SSN Match but no Date of Birth match. 1=Suppress Reject S 3=Don't Suppress Reject S
44	SSN_M_NAME_REJ_OVR	Character(1)	VARCHAR2(1) NOT NULL	Option to suppress ISIR Reject 'T' - Mom SSN Match but no Date of Birth match. 1=Suppress Reject T 3=Don't Suppress Reject T
45	SSN_NONM_REJ_OVR	Character(1)	VARCHAR2(1) NOT NULL	Option to suppress ISIR Reject 'D' - SSN Match but no Name match. 1=Suppress Reject D 3=Don't Suppress Reject D
46	SSN_D_NONM_REJ_OVR	Character(1)	VARCHAR2(1) NOT NULL	Option to suppress ISIR Reject 'E' - Father SSN Match but no Name match. 1=Suppress Reject E 3=Don't Suppress Reject E
47	SSN_M_NONM_REJ_OVR	Character(1)	VARCHAR2(1) NOT NULL	Option to suppress ISIR Reject 'F' - Mother SSN Match but no Name match. 1=Suppress Reject F 3=Don't Suppress Reject F
48	DEPNDNCY_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Dependency Override Indicator 1=Dependent To Independent 2=Cancel Dep Override-Corr Only 3=Override Failed 4=Homeless Youth Determination