Reporting View Target: SATISFACTORY_ACAD

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

SGHE Banner Operational Data Store
Reporting View Target: SATISFACTORY_ACAD_PROGRESS

Description Contains data on the student's satisfactory academic progress for the aid year as defined by a federal standard for calculation.
Key & Frequency One row per person per aid year per academic period.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD
AID_YEAR, ACADEMIC_PERIOD

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACADEMIC_PERIOD Academic Period Academic period code to be associated with information in this record. VARCHAR2(63)
RORSAPR

RORSAPR_TERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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_PERIOD Aid Period Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc. VARCHAR2(63)
NA

NA

AID_PERIOD_DESC Aid Period Description Financial Aid period description. 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)
NA

NA

AID_YEAR_DESC Aid Year Description Financial aid year name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

ID ID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to eachuniversity constituent. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

RORSAPR_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

SATISFACTORY_ACAD_PROG_CODE Satisfactory Acad Prog Code Student satisfactory academic progress (SAP) code. VARCHAR2(63)
RORSAPR

RORSAPR_SAPR_CODE

SATISFACTORY_ACAD_PROG_DESC Satisfactory Acad Prog Description Specifies the satisfactory academic progress (SAP) associated with the SAP code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

Ver: 9.0

Description	Contains data on the student's satisfactory academic progress for the aid year as defined by a federal standard for calculation.
Key & Frequency	One row per person per aid year per academic period.
Recommended Search Columns	PERSON_UID, ACADEMIC_PERIOD AID_YEAR, ACADEMIC_PERIOD

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Academic period code to be associated with information in this record.	VARCHAR2(63)	RORSAPR	RORSAPR_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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_PERIOD	Aid Period	Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc.	VARCHAR2(63)	NA	NA
AID_PERIOD_DESC	Aid Period Description	Financial Aid period description.	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)	NA	NA
AID_YEAR_DESC	Aid Year Description	Financial aid year name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ID	ID	Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to eachuniversity constituent.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	Person UID	System generated Banner unique ID which gets assigned to all person and non-person records within Banner.	NUMBER	RORSAPR	RORSAPR_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
SATISFACTORY_ACAD_PROG_CODE	Satisfactory Acad Prog Code	Student satisfactory academic progress (SAP) code.	VARCHAR2(63)	RORSAPR	RORSAPR_SAPR_CODE
SATISFACTORY_ACAD_PROG_DESC	Satisfactory Acad Prog Description	Specifies the satisfactory academic progress (SAP) associated with the SAP code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC