Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Financial Aid Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AR_SATISFACTORY_ACAD_PROGRESS

Description Source composite view contains satisfactory academic progress information recorded within financial aid for the student.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period code to be associated with information in this record. VARCHAR2(6)

RORSAPR

RORSAPR_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

ROKODSF.F_GET_FINAID_PROC_YEAR

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

RORSAPR

RORSAPR_PIDM

SATISFACTORY_ACAD_PROG_CODE Student satisfactory academic progress (SAP) code. VARCHAR2(6)

RORSAPR

RORSAPR_SAPR_CODE

SATISFACTORY_ACAD_PROG_DESC Specifies the satisfactory academic progress (SAP) associated with the SAP code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: 8.0