Overview

Regent Award is designed with different rules to determine whether an ISIR is made “Active” during the Import ISIR process. If the ISIR does not meet the appropriate criteria, the ISIR is not made “active.” Regent Award considers single or multiples ISIR imports during the "Active" determination logic.

Bulk ISIR Imports

When ISIRs are loaded in bulk (i.e., YTD ISIR - all ISIR’s for a student for a given FAY are considered in the same transaction) – and no ISIR’s have been previously loaded for the student – the entire set of ISIR’s must be considered at once and the highest transaction in this order will be set active:

‘D’ or ‘S’ sources
or ‘A’ sources (when no ‘D’ or ‘S’ sources exist)
or a NULL (aka blank) source when there is only one ISIR for the student for that FAY

Multiple ISIR’s in a single file

If an ISIR file has multiple ISIR’s (same FAY) for the same student, only 1 ISIR is reviewed to determine eligibility for becoming active. Regent Award will use a combination of the ISIR’s Correction Source, Rejection Status, and Transaction Number to determine which ISIR will be reviewed:

Regent Award will first review the Correction Source of both ISIR’s to determine how to proceed:

Correction Source D (CPS generated) and S (School Generated) are equal in being the highest priority.
- If both ISIR’s have a D and/or S, the ISIR with the higher transaction number is reviewed.
- If both ISIR’s have a different Correction Source, other than Source A, the ISIR with the highest priority is reviewed.
Correction Source A (Applicant Generated) is the second priority.
- If both ISIR’s have an A, the Rejection Status is reviewed; valid ISIR’s take priority over rejected ISIR’s.
- If both ISIR’s have the same Rejection Status, the ISIR with the higher transaction number is reviewed.
Correction Source Blank/Null (No Correction) is the third priority.
- If both ISIR’s have no correction, the ISIR with the higher transaction number is reviewed.

Workflow

Single File ISIR Imports

If there are no ISIRs for that award year, make the ISIR active, regardless of all other conditions.

When subsequent ISIRs (those with higher transaction numbers) are received, the subsequent ISIR with the highest transaction number is set at as the Active ISIR unless the ISIR was initiated as a result of an applicant action which did not resolve a reject condition.

If the subsequent ISIR was initiated as an applicant action and the subsequent ISIR did not clear a reject condition, then a task must be initiated for staff to manually review the ISIR record. Scenarios highlighted in the chart below.

When subsequent ISIRs (those with higher transaction numbers) are received, the subsequent ISIR with the highest transaction number is set at as the Active ISIR unless the ISIR was initiated as a result of an applicant action which resulted in the student being selected for verification.

If the subsequent ISIR was initiated as an applicant action and the subsequent ISIR resulted in the student being selected for verification, then a task must be initiated for staff to manually review the ISIR record. Scenarios highlighted in the chart below.

If the subsequent ISIR was initiated as a result of applicant action, and the subsequent ISIR clears any SAR C Code (a subset of all SAR Comment Codes - complete list below - see this Wiki under the ISIR section for a link to the spec for the SAR codes per award year), the subsequent ISIR with the highest transaction number is set at as the Active ISIR.

SAR C- Codes:

Note that SAR C-Codes are ACTIONABLE, whereas the comment codes that are not listed here are informational only.

Complete list of SAR C Codes: 10, 20, 30, 33, 38, 39, 41, 42, 43, 46, 53, 54, 56, 57, 58, 63, 64, 65, 66, 67, 77, 79, 86, 90, 100, 101, 102, 105, 107, 109, 115, 116, 124, 132, 133, 134, 135, 136, 138, 141, 142, 144, 146, 162, 173, 180, 254, 255, 256, 260, 289, 290, 291, 292, 293, 294, 309, 310, 311, 312, 313, 314, 346, 347, 359, 360, 392, 393 and 399.

If the subsequent ISIR was initiated as an applicant action, check to see if the previous ISIR contained the comment codes 156 or 157:

If yes, and the codes have been cleared, set to active ISIR.
If yes, and the codes have not been cleared, do not set subsequent ISIR to active.
If no, do nothing, unless any of the other conditions for setting the active ISIR applies.
Note: 156 and 157 relate to a tax filing status of “will file". If the student/parent changes their tax filing status to one of the other statuses, then I believe that this comment will be removed. For this condition, we would want to set the ISIR to active as would be done for the “C” codes.

For 2012-2013 ISIRs, and subsequent years, if the subsequent ISIR was initiated as an applicant action, that updated the value for either of the Student IRS Data Flag or the Parent IRS Data Flag fields to go from an original value of 01, 03, 04, 05 or 06, to a changed value of 02, Regent Award shall automatically set the ISIR to the active ISIR.

If the ISIR meets this logic, then it will be set active regardless of whether it is a new or old ISIR that is/is not selected for verification or if it is a new or old ISIR that has/does not have rejects.
If the value of this flag is originally 02 and there is no change to the ISIR, do nothing, unless any of the other conditions for setting the active ISIR applies.
If the value of this flag is originally 02, and there is a change to the ISIR, do nothing unless any of the other conditions for setting the active ISIR applies.

If any scenario above proves to be true, then the ISIR should be set as active. The scenarios do not have to prove out other scenarios when processing.

Active ISIR Logic

When Should the Incoming ISIR Automatically become the Active ISIR?

Regent Award is designed with pre-defined rules that determine whether or not an ISIR is made “Active” during the Import ISIR process. If the ISIR does not meet the appropriate criteria, the ISIR is not made “active.” Please see the matrix (below) for the ISIR Active Rules.

Regent Award first evaluates all of the scenarios that will make an ISIR active. Users can view these cases in the “Make this the Active ISIR” column on the attached spreadsheet where the value is “Yes.” If the ISIR meets one of these criteria, Regent Award stops reviewing and marks the ISIR as “Active.”

The exceptions are is scenario #20 and #21 below. These are specific conditions that prevent an ISIR from becoming active - even if this ISIR meets the criteria for another Scenario in this list.

Excel version of matrix

Scenario Number	Is there an existing ISIR for FAY?	Existing Active ISIR Selected for Verification	Existing Active ISIR is Verified	Existing Active ISIR Has Rejects?	Existing Active ISIR Has Other Conditions?	Received Correction to Existing Active ISIR	Received ISIR Source of Correction	Received ISIR Selected for Verification?	Received ISIR V-group has changed?	Received ISIR Has Rejects?	Received ISIR Trans# higher than existing	Received ISIR Other Conditions?	Make this the Active ISIR	Comments
		Existing ISIR				Received ISIR
1	No												Yes
2	Yes						Any				No		No
3	Yes	No		No		Yes	Applicant	No		Yes	Yes		No
4	Yes	No		No		Yes	Applicant	Yes		No	Yes		Yes
5	Yes	No		Yes		Yes	Applicant	Yes		No	Yes		Yes
6	Yes	Yes		No		Yes	Applicant	Yes		Yes	Yes		No
7	Yes	Yes		Yes		Yes	Applicant	Yes		No	Yes		Yes
8	Yes	No		No		Yes	Applicant	No		No	Yes		No
9	Yes	No		Yes		Yes	Applicant	No		Yes	Yes		No
10	Yes	Yes		Yes		Yes	Applicant	Yes		Yes	Yes		No
11	Yes	No		No		Yes	Applicant	Yes		Yes	Yes		Yes
12	Yes	No		Yes		Yes	Applicant	No		No	Yes		Yes
13	Yes	Yes		No		Yes	Applicant	Yes	No	No	Yes		No	Updated for the 16/17 to account for a change to V-group
14	Yes				Has comment code 156 or 157	Yes	Applicant				Yes	No longer has comment code 156 or 156	Yes
15	Yes				Has comment code 156 or 157	Yes	Applicant				Yes	Still has comment code 156 or 157	No
16	Yes				Has any SAR C Code (See complete list of SAR C Codes)		Applicant			UPDATEDNo		As compared to the existing active ISIR: The comment code is cleared or the set of associated SAR C Codes is different in any way Note: This scenario does not include when the current active ISIR contains no C Code but a new applicant ISIR does contain C Codes.	Yes
17	Yes				Student IRS Data Flag or the Parent IRS Data Flag = 01, 03, 04, 05 or 06	Yes	Applicant				Yes	Student IRS Data Flag or the Parent IRS Data Flag = 02	Yes
18	Yes					Yes	School or CPS				Yes		Yes
19	Yes	Yes		No		Yes	School, CPS or Applicant	Yes	Yes	No	Yes		Yes	Updated for the 16/17 to account for a change to V-group
20	Yes					Yes	School					Field #371 (ETI) has a value of 1,3,5,7,8,9, or Blank	No	This is a special condition that prevents* an ISIR from becoming active - even if this ISIR meets the criteria for another Scenario in this list.*
21	Yes	Yes	Yes				Applicant		No				No	If the user makes this ISIR active, it will inherit the verification status of the current active ISIR.

NOTE: Any block that is empty in the grid above means that any value is acceptable.
In scenario 8, the ISIR should not be set to active as the only change was one initiated by the student.
In scenario 11, the ISIR should be set to active as there is now a reject condition that needs to be resolved or a verification that needs to be performed.
FYI: A user with the “Set Active ISIR” permissions can mark any previous ISIR to be the active one. This will override any scenarios listed above

Automatic Active ISIR Logic