ISIR_INST_CNTRL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
2	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL
3	CPS_SCHOOL_CODE	Character(6)	VARCHAR2(6) NOT NULL	CPS School Code. Also known as Title IV School Code Prompt Table: INST_SCHOOL_CDS
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	LVL_SUSPEND_RECORD	Character(1)	VARCHAR2(1) NOT NULL	Student Status Suspend Level 0=0 - Anyone not loaded 1=1 - Recruit or higher 2=2 - Inactive Admits or higher 3=3 - Applicant or higher 4=4 - Admitted or higher 5=5 - Accepted/Continuing only
7	LVL_ADD_RECORD	Character(1)	VARCHAR2(1) NOT NULL	Student Status Add Level 0=0 - Load everyone 1=1 - Recruits or higher 2=2 - Inactive admits or higher 3=3 - Applicants or higher 4=4 - Active admits or higher 5=5 - Accepted/Continuing only
8	UPDATE_NAME	Character(1)	VARCHAR2(1) NOT NULL	Update Name Y/N Table Edit Default Value: N
9	SFA_UPDATE_ADDRESS	Character(1)	VARCHAR2(1) NOT NULL	Update Addresses 1=Discard Incoming Address 2=Add if blank - Do not update 3=Always Update Default Value: 2
10	UPDATE_PERSONAL	Character(1)	VARCHAR2(1) NOT NULL	Update Bio/Demo Data Y/N Table Edit Default Value: N
11	REVIEW_ISIR_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Ed Verification Completed A=Load Record D=Discard Incoming Record S=Suspend Incoming Record
12	LOAD_COMP_REJECT	Character(1)	VARCHAR2(1) NOT NULL	ISIR Compute Rejects A=Load Record D=Discard Incoming Record S=Suspend Incoming Record
13	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type Prompt Table: ADDRESS_TYP_TBL
14	OVRD_ADDR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Override Address Type Y/N Table Edit Default Value: N
15	INST_STATUS_SWITCH	Character(1)	VARCHAR2(1) NOT NULL	Inst. Review Status Completed A=Load Record D=Discard Incoming Record S=Suspend Incoming Record
16	MAX_MATCH_LEVEL	Number(3,0)	SMALLINT NOT NULL	Max Search Match Level Prompt Table: SEARCH_ORDR_TBL
17	NSLDS_LOAD	Character(1)	VARCHAR2(1) NOT NULL	Load NSLDS Data Y/N Table Edit Default Value: N
18	SM_BYPASS	Character(1)	VARCHAR2(1) NOT NULL	Bypass Search Match Y/N Table Edit Default Value: N
19	SM_BYPASS_NM_ACTN	Character(1)	VARCHAR2(1) NOT NULL	No Match Action A=Add If No Match Found K=Skip If No Match Found S=Suspend If No Match Found
20	ISIR_ADD_PROSPECT	Character(1)	VARCHAR2(1) NOT NULL	Create Prospect Data Y/N Table Edit Default Value: N
21	ISIR_USE_CURRDT	Character(1)	VARCHAR2(1) NOT NULL	Use Current Date As Effdt Y/N Table Edit Default Value: N
22	ISIR_CALL_INAS_RT	Character(1)	VARCHAR2(1) NOT NULL	Call INAS in Load Y/N Table Edit Default Value: Y
23	ISIR_CORR_INASCALL	Character(1)	VARCHAR2(1) NOT NULL	INAS Correction Calc Options 1=Always Call EFC Calc 2=Store EFC Calc Request 3=Call EFC Calc if EFC Change 4=Never Call EFC Calc Default Value: 4
24	ISIR_DL_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Update Drivers License 1=Discard Incoming DL 2=Add if blank 3=Always Update
25	ISIR_EFC_NM_SUSP	Character(1)	VARCHAR2(1) NOT NULL	Suspend on EFC Mismatch Y/N Table Edit
26	ISIR_SYSG_LOAD_SW	Character(1)	VARCHAR2(1) NOT NULL	System Generated ISIR Action A=Load Record D=Discard Incoming Record F=Force Load Incoming Record S=Suspend Incoming Record
27	NSLDS_CORR_LOAD	Character(1)	VARCHAR2(1) NOT NULL	Load NSLDS Data
28	ISIR_CORR_NM_SUSP	Character(1)	VARCHAR2(1) NOT NULL	Suspend Other School Initiated Y/N Table Edit Default Value: Y
29	ISIR_EFC_OVRD_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch to determine whether the ISIR Load should use or ignore an EFC Override or suspend the record I=Ignore EFC Override Values S=Suspend Incoming Record U=Use EFC Override Values Default Value: S
30	SFA_NSLDS_AGGR_UPD	Character(1)	VARCHAR2(1) NOT NULL	FA-Aggregates: NSLDS Data Push option from ISIR/FAH load (Y/N), Y/N Table Edit Default Value: N
31	ISIR_EM_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Update Email Options 1=Discard Incoming EM 2=Add if blank 3=Always Update
32	ISIR_PH_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Update Phone Options 1=Discard Incoming PH 2=Add if blank 3=Always Update
33	ISIR_CORR_STD_SUSP	Character(1)	VARCHAR2(1) NOT NULL	Suspend Student Initiated Y/N Table Edit Default Value: Y
34	SFA_ISIR_REQ_FATM	Character(1)	VARCHAR2(1) NOT NULL	Require FA Term Y/N Table Edit