Reporting View Target: TRACKING_REQUIREMENT

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Financial Aid Reporting View Reports

Banner Operational Data Store
Reporting View Target: TRACKING_REQUIREMENT_SLOT

Description Uses data from the FINAID_TRACKING_REQUIREMENT reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of TRACKING REQS and a delivered or institution defined internal code. Delivered internal codes of FAPLTREQ may be used independently by the institution.
Key & Frequency One row per person per aid year per profile code per requirement rule.
Recommended Search Columns PERSON_UID, AID_YEAR, PROFILE_CODE, REQUIREMENT_RULE
ACTIVITY_DATE

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target

ACTIVITY_DATE Date record was inserted or updated. DATE
NA

SYSDATE

NO
NO

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

NO
NO

AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(63)
RRRAREQ

RRRAREQ_AIDY_CODE

NO
NO

DISBURSEMENT_REQ_IND1 Defines whether a tracking code is required and must be satisfied for disbursement. VARCHAR2(1)
RRRAREQ

RRRAREQ_DISB_IND

NO
NO

DISBURSEMENT_REQ_IND2 Defines whether a tracking code is required and must be satisfied for disbursement. VARCHAR2(1)
RRRAREQ

RRRAREQ_DISB_IND

NO
NO

DISBURSEMENT_REQ_IND3 Defines whether a tracking code is required and must be satisfied for disbursement. VARCHAR2(1)
RRRAREQ

RRRAREQ_DISB_IND

NO
NO

FUND1 Financial Aid Fund code to be associated with information in this record. VARCHAR2(63)
RRRAREQ

RRRAREQ_FUND_CODE

NO
NO

FUND2 Financial Aid Fund code to be associated with information in this record. VARCHAR2(63)
RRRAREQ

RRRAREQ_FUND_CODE

NO
NO

FUND3 Financial Aid Fund code to be associated with information in this record. VARCHAR2(63)
RRRAREQ

RRRAREQ_FUND_CODE

NO
NO

FUND_TITLE1 Full title of the financial aid fund code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

FUND_TITLE2 Full title of the financial aid fund code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

FUND_TITLE3 Full title of the financial aid fund code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

INSTITUTION1 Institution from which a financial aid transcript is required. VARCHAR2(63)
RRRAREQ

RRRAREQ_SBGI_CODE

NO
NO

INSTITUTION2 Institution from which a financial aid transcript is required. VARCHAR2(63)
RRRAREQ

RRRAREQ_SBGI_CODE

NO
NO

INSTITUTION3 Institution from which a financial aid transcript is required. VARCHAR2(63)
RRRAREQ

RRRAREQ_SBGI_CODE

NO
NO

INSTITUTION_DESC1 Source/background institution name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

INSTITUTION_DESC2 Source/background institution name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

INSTITUTION_DESC3 Source/background institution name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

MEMO_IND1 Defines whether the specific tracking requirement code should be satisfied in order for any fund to be credit memo'd. VARCHAR2(1)
RRRAREQ

RRRAREQ_MEMO_IND

NO
NO

MEMO_IND2 Defines whether the specific tracking requirement code should be satisfied in order for any fund to be credit memo'd. VARCHAR2(1)
RRRAREQ

RRRAREQ_MEMO_IND

NO
NO

MEMO_IND3 Defines whether the specific tracking requirement code should be satisfied in order for any fund to be credit memo'd. VARCHAR2(1)
RRRAREQ

RRRAREQ_MEMO_IND

NO
NO

MORE_SPECIFIC_REQ_IND1 Indicates whether additional requirements of the same type exist for the student. VARCHAR2(1)
FUNCTION

F_MORE_SPECIFIC_REQUIREMENTS

NO
NO

MORE_SPECIFIC_REQ_IND2 Indicates whether additional requirements of the same type exist for the student. VARCHAR2(1)
FUNCTION

F_MORE_SPECIFIC_REQUIREMENTS

NO
NO

MORE_SPECIFIC_REQ_IND3 Indicates whether additional requirements of the same type exist for the student. VARCHAR2(1)
FUNCTION

F_MORE_SPECIFIC_REQUIREMENTS

NO
NO

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

NO
NO

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NO
NO

PACKAGING_REQ_IND1 Define whether the tracking requirement code must be satisfied in order for any fund to be packaged. VARCHAR2(1)
RRRAREQ

RRRAREQ_PCKG_IND

NO
NO

PACKAGING_REQ_IND2 Define whether the tracking requirement code must be satisfied in order for any fund to be packaged. VARCHAR2(1)
RRRAREQ

RRRAREQ_PCKG_IND

NO
NO

PACKAGING_REQ_IND3 Define whether the tracking requirement code must be satisfied in order for any fund to be packaged. VARCHAR2(1)
RRRAREQ

RRRAREQ_PCKG_IND

NO
NO

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER
RRRAREQ

RRRAREQ_PIDM

NO
NO

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

NO
NO

PROFILE_CODE This BUSNIESS PROFILE code is stored as MGRSDAX_PROFILE_CODE column and is used to set up display rules specific to an institution office or role. This may be used to define security for the rows of data available to a reporting user, or to select data through a reporting tool selection criteria. VARCHAR2(63)
MGRSDAX

MGRSDAX_PROFILE_CODE

NO
NO

REQUIREMENT1 Code associated with the tracking requirement. VARCHAR2(63)
RRRAREQ

RRRAREQ_TREQ_CODE

NO
NO

REQUIREMENT2 Code associated with the tracking requirement. VARCHAR2(63)
RRRAREQ

RRRAREQ_TREQ_CODE

NO
NO

REQUIREMENT3 Code associated with the tracking requirement. VARCHAR2(63)
RRRAREQ

RRRAREQ_TREQ_CODE

NO
NO

REQUIREMENT_DESC1 Requirement description. VARCHAR2(255)
FUNCTION
RRRAREQ

GOKODSF.F_GET_DESC
RRRAREQ_TREQ_DESC

NO
NO
NO

REQUIREMENT_DESC2 Requirement description. VARCHAR2(255)
FUNCTION
RRRAREQ

GOKODSF.F_GET_DESC
RRRAREQ_TREQ_DESC

NO
NO
NO

REQUIREMENT_DESC3 Requirement description. VARCHAR2(255)
FUNCTION
RRRAREQ

GOKODSF.F_GET_DESC
RRRAREQ_TREQ_DESC

NO
NO
NO

REQUIREMENT_RULE TRACKING_REQUIREMENT_RULE is stored as MGRSDAX_INTERNAL_CODE column and is used to define a specific hierarchy or sequence for display of the values in a slotted reporting view. This may be used to specify the values for each slot or to select data through a reporting tool selection criteria. VARCHAR2(255)
MGRSDAX

MGRSDAX_INTERNAL_CODE

NO
NO

SATISFIED_IND1 Indicates whether the tracking requirement code has been satisfied. VARCHAR2(1)
RRRAREQ

RRRAREQ_SAT_IND

NO
NO

SATISFIED_IND2 Indicates whether the tracking requirement code has been satisfied. VARCHAR2(1)
RRRAREQ

RRRAREQ_SAT_IND

NO
NO

SATISFIED_IND3 Indicates whether the tracking requirement code has been satisfied. VARCHAR2(1)
RRRAREQ

RRRAREQ_SAT_IND

NO
NO

STATUS1 Course status code of the most recent change to this tracking requirement. It is a required field. It can be used to prevent creation of sections of the course based on the active/inactive flag associated with the status code. VARCHAR2(63)
RRRAREQ

RRRAREQ_TRST_CODE

NO
NO

STATUS2 Course status code of the most recent change to this tracking requirement. It is a required field. It can be used to prevent creation of sections of the course based on the active/inactive flag associated with the status code. VARCHAR2(63)
RRRAREQ

RRRAREQ_TRST_CODE

NO
NO

STATUS3 Course status code of the most recent change to this tracking requirement. It is a required field. It can be used to prevent creation of sections of the course based on the active/inactive flag associated with the status code. VARCHAR2(63)
RRRAREQ

RRRAREQ_TRST_CODE

NO
NO

STATUS_DATE1 Last date the requirement status was updated. DATE
RRRAREQ

RRRAREQ_STAT_DATE

NO
NO

STATUS_DATE2 Last date the requirement status was updated. DATE
RRRAREQ

RRRAREQ_STAT_DATE

NO
NO

STATUS_DATE3 Last date the requirement status was updated. DATE
RRRAREQ

RRRAREQ_STAT_DATE

NO
NO

STATUS_DESC1 Description of the most recent change to this tracking requirement. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

STATUS_DESC2 Description of the most recent change to this tracking requirement. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

STATUS_DESC3 Description of the most recent change to this tracking requirement. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

Ver: 9.2

Description	Uses data from the FINAID_TRACKING_REQUIREMENT reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of TRACKING REQS and a delivered or institution defined internal code. Delivered internal codes of FAPLTREQ may be used independently by the institution.
Key & Frequency	One row per person per aid year per profile code per requirement rule.
Recommended Search Columns	PERSON_UID, AID_YEAR, PROFILE_CODE, REQUIREMENT_RULE ACTIVITY_DATE

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	NA	SYSDATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(63)	RRRAREQ	RRRAREQ_AIDY_CODE	NO	NO
DISBURSEMENT_REQ_IND1	Defines whether a tracking code is required and must be satisfied for disbursement.	VARCHAR2(1)	RRRAREQ	RRRAREQ_DISB_IND	NO	NO
DISBURSEMENT_REQ_IND2	Defines whether a tracking code is required and must be satisfied for disbursement.	VARCHAR2(1)	RRRAREQ	RRRAREQ_DISB_IND	NO	NO
DISBURSEMENT_REQ_IND3	Defines whether a tracking code is required and must be satisfied for disbursement.	VARCHAR2(1)	RRRAREQ	RRRAREQ_DISB_IND	NO	NO
FUND1	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RRRAREQ	RRRAREQ_FUND_CODE	NO	NO
FUND2	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RRRAREQ	RRRAREQ_FUND_CODE	NO	NO
FUND3	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RRRAREQ	RRRAREQ_FUND_CODE	NO	NO
FUND_TITLE1	Full title of the financial aid fund code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_TITLE2	Full title of the financial aid fund code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
FUND_TITLE3	Full title of the financial aid fund code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
INSTITUTION1	Institution from which a financial aid transcript is required.	VARCHAR2(63)	RRRAREQ	RRRAREQ_SBGI_CODE	NO	NO
INSTITUTION2	Institution from which a financial aid transcript is required.	VARCHAR2(63)	RRRAREQ	RRRAREQ_SBGI_CODE	NO	NO
INSTITUTION3	Institution from which a financial aid transcript is required.	VARCHAR2(63)	RRRAREQ	RRRAREQ_SBGI_CODE	NO	NO
INSTITUTION_DESC1	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
INSTITUTION_DESC2	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
INSTITUTION_DESC3	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MEMO_IND1	Defines whether the specific tracking requirement code should be satisfied in order for any fund to be credit memo'd.	VARCHAR2(1)	RRRAREQ	RRRAREQ_MEMO_IND	NO	NO
MEMO_IND2	Defines whether the specific tracking requirement code should be satisfied in order for any fund to be credit memo'd.	VARCHAR2(1)	RRRAREQ	RRRAREQ_MEMO_IND	NO	NO
MEMO_IND3	Defines whether the specific tracking requirement code should be satisfied in order for any fund to be credit memo'd.	VARCHAR2(1)	RRRAREQ	RRRAREQ_MEMO_IND	NO	NO
MORE_SPECIFIC_REQ_IND1	Indicates whether additional requirements of the same type exist for the student.	VARCHAR2(1)	FUNCTION	F_MORE_SPECIFIC_REQUIREMENTS	NO	NO
MORE_SPECIFIC_REQ_IND2	Indicates whether additional requirements of the same type exist for the student.	VARCHAR2(1)	FUNCTION	F_MORE_SPECIFIC_REQUIREMENTS	NO	NO
MORE_SPECIFIC_REQ_IND3	Indicates whether additional requirements of the same type exist for the student.	VARCHAR2(1)	FUNCTION	F_MORE_SPECIFIC_REQUIREMENTS	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PACKAGING_REQ_IND1	Define whether the tracking requirement code must be satisfied in order for any fund to be packaged.	VARCHAR2(1)	RRRAREQ	RRRAREQ_PCKG_IND	NO	NO
PACKAGING_REQ_IND2	Define whether the tracking requirement code must be satisfied in order for any fund to be packaged.	VARCHAR2(1)	RRRAREQ	RRRAREQ_PCKG_IND	NO	NO
PACKAGING_REQ_IND3	Define whether the tracking requirement code must be satisfied in order for any fund to be packaged.	VARCHAR2(1)	RRRAREQ	RRRAREQ_PCKG_IND	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RRRAREQ	RRRAREQ_PIDM	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PROFILE_CODE	This BUSNIESS PROFILE code is stored as MGRSDAX_PROFILE_CODE column and is used to set up display rules specific to an institution office or role. This may be used to define security for the rows of data available to a reporting user, or to select data through a reporting tool selection criteria.	VARCHAR2(63)	MGRSDAX	MGRSDAX_PROFILE_CODE	NO	NO
REQUIREMENT1	Code associated with the tracking requirement.	VARCHAR2(63)	RRRAREQ	RRRAREQ_TREQ_CODE	NO	NO
REQUIREMENT2	Code associated with the tracking requirement.	VARCHAR2(63)	RRRAREQ	RRRAREQ_TREQ_CODE	NO	NO
REQUIREMENT3	Code associated with the tracking requirement.	VARCHAR2(63)	RRRAREQ	RRRAREQ_TREQ_CODE	NO	NO
REQUIREMENT_DESC1	Requirement description.	VARCHAR2(255)	FUNCTION RRRAREQ	GOKODSF.F_GET_DESC RRRAREQ_TREQ_DESC	NO NO	NO
REQUIREMENT_DESC2	Requirement description.	VARCHAR2(255)	FUNCTION RRRAREQ	GOKODSF.F_GET_DESC RRRAREQ_TREQ_DESC	NO NO	NO
REQUIREMENT_DESC3	Requirement description.	VARCHAR2(255)	FUNCTION RRRAREQ	GOKODSF.F_GET_DESC RRRAREQ_TREQ_DESC	NO NO	NO
REQUIREMENT_RULE	TRACKING_REQUIREMENT_RULE is stored as MGRSDAX_INTERNAL_CODE column and is used to define a specific hierarchy or sequence for display of the values in a slotted reporting view. This may be used to specify the values for each slot or to select data through a reporting tool selection criteria.	VARCHAR2(255)	MGRSDAX	MGRSDAX_INTERNAL_CODE	NO	NO
SATISFIED_IND1	Indicates whether the tracking requirement code has been satisfied.	VARCHAR2(1)	RRRAREQ	RRRAREQ_SAT_IND	NO	NO
SATISFIED_IND2	Indicates whether the tracking requirement code has been satisfied.	VARCHAR2(1)	RRRAREQ	RRRAREQ_SAT_IND	NO	NO
SATISFIED_IND3	Indicates whether the tracking requirement code has been satisfied.	VARCHAR2(1)	RRRAREQ	RRRAREQ_SAT_IND	NO	NO
STATUS1	Course status code of the most recent change to this tracking requirement. It is a required field. It can be used to prevent creation of sections of the course based on the active/inactive flag associated with the status code.	VARCHAR2(63)	RRRAREQ	RRRAREQ_TRST_CODE	NO	NO
STATUS2	Course status code of the most recent change to this tracking requirement. It is a required field. It can be used to prevent creation of sections of the course based on the active/inactive flag associated with the status code.	VARCHAR2(63)	RRRAREQ	RRRAREQ_TRST_CODE	NO	NO
STATUS3	Course status code of the most recent change to this tracking requirement. It is a required field. It can be used to prevent creation of sections of the course based on the active/inactive flag associated with the status code.	VARCHAR2(63)	RRRAREQ	RRRAREQ_TRST_CODE	NO	NO
STATUS_DATE1	Last date the requirement status was updated.	DATE	RRRAREQ	RRRAREQ_STAT_DATE	NO	NO
STATUS_DATE2	Last date the requirement status was updated.	DATE	RRRAREQ	RRRAREQ_STAT_DATE	NO	NO
STATUS_DATE3	Last date the requirement status was updated.	DATE	RRRAREQ	RRRAREQ_STAT_DATE	NO	NO
STATUS_DESC1	Description of the most recent change to this tracking requirement.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
STATUS_DESC2	Description of the most recent change to this tracking requirement.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
STATUS_DESC3	Description of the most recent change to this tracking requirement.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO