Reporting View Target: TRACKING_REQUIREMENT

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

SGHE 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 Name Business Definition Database Data Type Domain Value Source Name Source Column

ACTIVITY_DATE Activity Date Date record was inserted or updated DATE
NA

SYSDATE

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

NA

AID_YEAR Aid Year Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(63)
RRRAREQ

RRRAREQ_AIDY_CODE

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

RRRAREQ_DISB_IND

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

RRRAREQ_DISB_IND

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

RRRAREQ_DISB_IND

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

RRRAREQ_FUND_CODE

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

RRRAREQ_FUND_CODE

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

RRRAREQ_FUND_CODE

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

RRRAREQ_SBGI_CODE

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

RRRAREQ_SBGI_CODE

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

RRRAREQ_SBGI_CODE

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

MEMO_IND1 Memo Indicator 1 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

MEMO_IND2 Memo Indicator 2 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

MEMO_IND3 Memo Indicator 3 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

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

F_MORE_SPECIFIC_REQUIREMENTS

MORE_SPECIFIC_REQ_IND2 More Specific Req Indicator 2 Indicates whether additional requirements of the same type exist for the student. VARCHAR2(1)
FUNCTION

F_MORE_SPECIFIC_REQUIREMENTS

MORE_SPECIFIC_REQ_IND3 More Specific Req Indicator 3 Indicates whether additional requirements of the same type exist for the student. VARCHAR2(1)
FUNCTION

F_MORE_SPECIFIC_REQUIREMENTS

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

NA

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

NA

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

RRRAREQ_PCKG_IND

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

RRRAREQ_PCKG_IND

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

RRRAREQ_PCKG_IND

PERSON_UID Person UID System generated Banner unique ID which gets assigned to all person and non-person records within Banner. NUMBER
RRRAREQ

RRRAREQ_PIDM

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

NA

PROFILE_CODE 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

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

RRRAREQ_TREQ_CODE

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

RRRAREQ_TREQ_CODE

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

RRRAREQ_TREQ_CODE

REQUIREMENT_DESC1 Requirement Description 1 Requirement description. VARCHAR2(255)
FUNCTION
RRRAREQ

GOKODSF.F_GET_DESC
RRRAREQ_TREQ_DESC

REQUIREMENT_DESC2 Requirement Description 2 Requirement description. VARCHAR2(255)
FUNCTION
RRRAREQ

GOKODSF.F_GET_DESC
RRRAREQ_TREQ_DESC

REQUIREMENT_DESC3 Requirement Description 3 Requirement description. VARCHAR2(255)
FUNCTION
RRRAREQ

GOKODSF.F_GET_DESC
RRRAREQ_TREQ_DESC

REQUIREMENT_RULE 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

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

RRRAREQ_SAT_IND

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

RRRAREQ_SAT_IND

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

RRRAREQ_SAT_IND

STATUS1 Status 1 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

STATUS2 Status 2 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

STATUS3 Status 3 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

STATUS_DATE1 Status Date 1 Last date the requirement status was updated. DATE
RRRAREQ

RRRAREQ_STAT_DATE

STATUS_DATE2 Status Date 2 Last date the requirement status was updated. DATE
RRRAREQ

RRRAREQ_STAT_DATE

STATUS_DATE3 Status Date 3 Last date the requirement status was updated. DATE
RRRAREQ

RRRAREQ_STAT_DATE

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

Ver: 9.0

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 Name	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated	DATE	NA	SYSDATE
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AID_YEAR	Aid Year	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(63)	RRRAREQ	RRRAREQ_AIDY_CODE
DISBURSEMENT_REQ_IND1	Disbursement Req Indicator 1	Defines whether a tracking code is required and must be satisfied for disbursement.	VARCHAR2(1)	RRRAREQ	RRRAREQ_DISB_IND
DISBURSEMENT_REQ_IND2	Disbursement Req Indicator 2	Defines whether a tracking code is required and must be satisfied for disbursement.	VARCHAR2(1)	RRRAREQ	RRRAREQ_DISB_IND
DISBURSEMENT_REQ_IND3	Disbursement Req Indicator 3	Defines whether a tracking code is required and must be satisfied for disbursement.	VARCHAR2(1)	RRRAREQ	RRRAREQ_DISB_IND
FUND1	Fund 1	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RRRAREQ	RRRAREQ_FUND_CODE
FUND2	Fund 2	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RRRAREQ	RRRAREQ_FUND_CODE
FUND3	Fund 3	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RRRAREQ	RRRAREQ_FUND_CODE
FUND_TITLE1	Fund Title 1	Full title of the financial aid fund code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
FUND_TITLE2	Fund Title 2	Full title of the financial aid fund code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
FUND_TITLE3	Fund Title 3	Full title of the financial aid fund code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION1	Institution 1	Institution from which a financial aid transcript is required.	VARCHAR2(63)	RRRAREQ	RRRAREQ_SBGI_CODE
INSTITUTION2	Institution 2	Institution from which a financial aid transcript is required.	VARCHAR2(63)	RRRAREQ	RRRAREQ_SBGI_CODE
INSTITUTION3	Institution 3	Institution from which a financial aid transcript is required.	VARCHAR2(63)	RRRAREQ	RRRAREQ_SBGI_CODE
INSTITUTION_DESC1	Institution Description 1	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_DESC2	Institution Description 2	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_DESC3	Institution Description 3	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MEMO_IND1	Memo Indicator 1	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
MEMO_IND2	Memo Indicator 2	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
MEMO_IND3	Memo Indicator 3	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
MORE_SPECIFIC_REQ_IND1	More Specific Req Indicator 1	Indicates whether additional requirements of the same type exist for the student.	VARCHAR2(1)	FUNCTION	F_MORE_SPECIFIC_REQUIREMENTS
MORE_SPECIFIC_REQ_IND2	More Specific Req Indicator 2	Indicates whether additional requirements of the same type exist for the student.	VARCHAR2(1)	FUNCTION	F_MORE_SPECIFIC_REQUIREMENTS
MORE_SPECIFIC_REQ_IND3	More Specific Req Indicator 3	Indicates whether additional requirements of the same type exist for the student.	VARCHAR2(1)	FUNCTION	F_MORE_SPECIFIC_REQUIREMENTS
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PACKAGING_REQ_IND1	Packaging Req Indicator 1	Define whether the tracking requirement code must be satisfied in order for any fund to be packaged.	VARCHAR2(1)	RRRAREQ	RRRAREQ_PCKG_IND
PACKAGING_REQ_IND2	Packaging Req Indicator 2	Define whether the tracking requirement code must be satisfied in order for any fund to be packaged.	VARCHAR2(1)	RRRAREQ	RRRAREQ_PCKG_IND
PACKAGING_REQ_IND3	Packaging Req Indicator 3	Define whether the tracking requirement code must be satisfied in order for any fund to be packaged.	VARCHAR2(1)	RRRAREQ	RRRAREQ_PCKG_IND
PERSON_UID	Person UID	System generated Banner unique ID which gets assigned to all person and non-person records within Banner.	NUMBER	RRRAREQ	RRRAREQ_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROFILE_CODE	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
REQUIREMENT1	Requirement 1	Code associated with the tracking requirement.	VARCHAR2(63)	RRRAREQ	RRRAREQ_TREQ_CODE
REQUIREMENT2	Requirement 2	Code associated with the tracking requirement.	VARCHAR2(63)	RRRAREQ	RRRAREQ_TREQ_CODE
REQUIREMENT3	Requirement 3	Code associated with the tracking requirement.	VARCHAR2(63)	RRRAREQ	RRRAREQ_TREQ_CODE
REQUIREMENT_DESC1	Requirement Description 1	Requirement description.	VARCHAR2(255)	FUNCTION RRRAREQ	GOKODSF.F_GET_DESC RRRAREQ_TREQ_DESC
REQUIREMENT_DESC2	Requirement Description 2	Requirement description.	VARCHAR2(255)	FUNCTION RRRAREQ	GOKODSF.F_GET_DESC RRRAREQ_TREQ_DESC
REQUIREMENT_DESC3	Requirement Description 3	Requirement description.	VARCHAR2(255)	FUNCTION RRRAREQ	GOKODSF.F_GET_DESC RRRAREQ_TREQ_DESC
REQUIREMENT_RULE	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
SATISFIED_IND1	Satisfied Indicator 1	Indicates whether the tracking requirement code has been satisfied.	VARCHAR2(1)	RRRAREQ	RRRAREQ_SAT_IND
SATISFIED_IND2	Satisfied Indicator 2	Indicates whether the tracking requirement code has been satisfied.	VARCHAR2(1)	RRRAREQ	RRRAREQ_SAT_IND
SATISFIED_IND3	Satisfied Indicator 3	Indicates whether the tracking requirement code has been satisfied.	VARCHAR2(1)	RRRAREQ	RRRAREQ_SAT_IND
STATUS1	Status 1	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
STATUS2	Status 2	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
STATUS3	Status 3	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
STATUS_DATE1	Status Date 1	Last date the requirement status was updated.	DATE	RRRAREQ	RRRAREQ_STAT_DATE
STATUS_DATE2	Status Date 2	Last date the requirement status was updated.	DATE	RRRAREQ	RRRAREQ_STAT_DATE
STATUS_DATE3	Status Date 3	Last date the requirement status was updated.	DATE	RRRAREQ	RRRAREQ_STAT_DATE
STATUS_DESC1	Status Description 1	Description of the most recent change to this tracking requirement.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
STATUS_DESC2	Status Description 2	Description of the most recent change to this tracking requirement.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
STATUS_DESC3	Status Description 3	Description of the most recent change to this tracking requirement.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC