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

SGHE 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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).    

RORHOLD

RORHOLD_AIDY_CODE

 
AID_YEAR_DESC Financial aid year name.    

ROIAIDY

ROIAIDY_DESC

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

NA

SYSDATE

 
DOMAIN_VALUE Domain column for future use, not currently populated.    

NA

NA

 
HOLD Code for the type of hold associated with this record.    

RORHOLD

RORHOLD_HOLD_CODE

 
HOLD_ACTIVITY_DATE Date record was inserted or updated.    

RORHOLD

RORHOLD_ACTIVITY_DATE

 
HOLD_DESC Hold description.    

RTVHOLD

RTVHOLD_DESC

 
HOLD_DISBURSEMENT_IND Indicates hold to prevent disbursement of applicant's aid.    

RTVHOLD

RTVHOLD_DISB_IND

 
HOLD_EXPLANATION User specified free form explanation for the hold.    

RORHOLD

RORHOLD_REASON

 
HOLD_FROM_DATE Effective begin date of hold.    

RORHOLD

RORHOLD_FROM_DATE

 
HOLD_MEMO_IND Indicates hold to prevent memo of applicant's aid.    

RTVHOLD

RTVHOLD_MEMO_IND

 
HOLD_PACKAGING_IND Indicates hold to prevent packaging of applicant's financial aid award.    

RTVHOLD

RTVHOLD_PCKG_IND

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

RORHOLD

RORHOLD_RELEASE_IND

 
HOLD_TO_DATE End date when the hold expires.    

RORHOLD

RORHOLD_TO_DATE

 
HOLD_USER_CREATOR System ID of the user who created the hold.    

RORHOLD

RORHOLD_USER_ID

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

NA

NA

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

NA

NA

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

RORHOLD

RORHOLD_PIDM

 
ZONE_VALUE Zone column for future use, not currently populated.    

NA

NA

 


Ver: 8.3