Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Financial Aid Composite View Reports

Banner Operational Data Store
Composite View Target: AR_FINAID_HOLD

Description Contains all of the financial aid holds (restrictions) for a person.
Key & Frequency One row per person per hold per hold from date per hold to date.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(4)

RORHOLD

RORHOLD_AIDY_CODE

NO

NO
AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

ROIAIDY

ROIAIDY_DESC

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

NO

NO
HOLD Code for the type of hold associated with this record. VARCHAR2(2)

RORHOLD

RORHOLD_HOLD_CODE

NO

NO
HOLD_ACTIVITY_DATE Date record was inserted or updated. DATE

RORHOLD

RORHOLD_ACTIVITY_DATE

NO

NO
HOLD_ALL_AID_IND Indicates whether the hold prevents packaging, disbursement or memo of all aid. VARCHAR2(1)

RTVHOLD

RTVHOLD_ALL_AID_IND

NO

NO
HOLD_DESC Hold description. VARCHAR2(30)

RTVHOLD

RTVHOLD_DESC

NO

NO
HOLD_DISBURSEMENT_IND Indicates hold to prevent disbursement of applicant's aid. VARCHAR2(1)

RTVHOLD

RTVHOLD_DISB_IND

NO

NO
HOLD_EXPLANATION User specified free form explanation for the hold. VARCHAR2(30)

RORHOLD

RORHOLD_REASON

NO

NO
HOLD_FEDERAL_AID_IND Indicates whether the hold prevents packaging, disbursement or memo of Federal aid. VARCHAR2(1)

RTVHOLD

RTVHOLD_FEDERAL_AID_IND

NO

NO
HOLD_FROM_DATE Effective begin date of hold. DATE

RORHOLD

RORHOLD_FROM_DATE

NO

NO
HOLD_INSTITUTIONAL_AID_IND Indicates whether the hold prevents packaging, disbursement or memo of Institutional aid. VARCHAR2(1)

RTVHOLD

RTVHOLD_INST_AID_IND

NO

NO
HOLD_MEMO_IND Indicates hold to prevent memo of applicant's aid. VARCHAR2(1)

RTVHOLD

RTVHOLD_MEMO_IND

NO

NO
HOLD_PACKAGING_IND Indicates hold to prevent packaging of applicant's financial aid award. VARCHAR2(1)

RTVHOLD

RTVHOLD_PCKG_IND

NO

NO
HOLD_PERIOD The period associated with the hold. VARCHAR2(15)

RORHOLD

RORHOLD_PERIOD

NO

NO
HOLD_PERIOD_DESC The description of the period associated with the hold. VARCHAR2(30)

ROBPRDS

ROBPRDS_DESC

NO

NO
HOLD_RELEASE_IND Indicates if only the hold creator can release the hold (Y) or if any user can release the hold (N). VARCHAR2(1)

RORHOLD

RORHOLD_RELEASE_IND

NO

NO
HOLD_STATE_AID_IND Indicates whether the hold prevents packaging, disbursement or memo of State aid. VARCHAR2(1)

RTVHOLD

RTVHOLD_STATE_AID_IND

NO

NO
HOLD_TITLE_IV_AID_IND Indicates whether the hold prevents packaging, disbursement or memo of Title IV aid. VARCHAR2(1)

RTVHOLD

RTVHOLD_TITLE_IV_AID_IND

NO

NO
HOLD_TO_DATE End date when the hold expires. DATE

RORHOLD

RORHOLD_TO_DATE

NO

NO
HOLD_USER_CREATOR System ID of the user who created the hold. VARCHAR2(30)

RORHOLD

RORHOLD_USER_ID

NO

NO
MIF_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)

NA

NA

NO

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

RORHOLD

RORHOLD_PIDM

NO

NO
ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA

NO

NO


Ver: