RETURN TO COMPOSITE VIEW REPORTS LIST
Financial Aid Composite View Reports

SGHE Operational Data Store
Composite View Target: AR_AWARD_BY_PERSON

Description Source composite view contains each applicant and award information for each fund and time indication.

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

RPRATRM

RPRATRM_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

AID_PERIOD Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc. VARCHAR2(1)

NA

NA

AID_PERIOD_DESC Financial Aid period description. VARCHAR2(1)

NA

NA

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)

RPRATRM

RPRATRM_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

AWARD_ACCEPT_AMOUNT Accepted amount for the financial aid fund that was accepted by students. NUMBER(11, 2)

RPRATRM

RPRATRM_ACCEPT_AMT

AWARD_ACCEPT_IND Indicates whether the person accepted this financial aid award. VARCHAR2(1)

RTVAWST

RTVAWST_ACCEPT_IND

AWARD_AUTHORIZE_AMOUNT Authorized amount for the financial aid fund for the person. NUMBER(11, 2)

RPRATRM

RPRATRM_AUTHORIZE_AMT

AWARD_CANCEL_AMOUNT Canceled amount for the financial aid fund for the person. NUMBER(11, 2)

RPRATRM

RPRATRM_CANCEL_AMT

AWARD_CANCEL_IND Indicates whether this financial aid award was canceled. VARCHAR2(1)

RTVAWST

RTVAWST_CANCEL_IND

AWARD_DECLINE_AMOUNT Declined amount for the financial aid award for the person. NUMBER(11, 2)

RPRATRM

RPRATRM_DECLINE_AMT

AWARD_DECLINE_IND Indicates whether this financial aid award was declined. VARCHAR2(1)

RTVAWST

RTVAWST_DECLINE_IND

AWARD_LOAD_MISMATCH_IND Indicates that the package load does not match any of the disbursement load indicators. VARCHAR2(1)

FUNCTION

F_GET_PCKG_LOAD_IND

AWARD_MEMO_AMOUNT Memo amount for the financial aid award for the person. This amount is intended but does not yet fit into any of the other financial aid amount groupings. NUMBER(11, 2)

RPRATRM

RPRATRM_MEMO_AMT

AWARD_OFFER_AMOUNT Current offered amount for the financial aid award for the person. NUMBER(11, 2)

RPRATRM

RPRATRM_OFFER_AMT

AWARD_OFFER_IND Indicates whether this financial aid award was offered. VARCHAR2(1)

RTVAWST

RTVAWST_OFFER_IND

AWARD_PACKAGE_LOAD_IND Identifies the student enrollment load at the time of packaging as either full time, three-quarter time, half time or less than half time. VARCHAR2(1)

RPRATRM

RPRATRM_PCKG_LOAD_IND

AWARD_PAID_AMOUNT Paid or disbursed amount for the financial aid award for the person. NUMBER(11, 2)

RPRATRM

RPRATRM_PAID_AMT

AWARD_STATUS Current status for the financial aid award. VARCHAR2(4)

RPRAWRD

RPRAWRD_AWST_CODE

AWARD_STATUS_DATE Date that the financial aid award status was changed. DATE

RPRAWRD

RPRAWRD_AWST_DATE

AWARD_STATUS_DESC Description for the financial aid status. VARCHAR2(30)

RTVAWST

RTVAWST_DESC

CALC_STUDENT_ADJ_CREDITS Calculates and displays the student's adjusted credits for the academic period. NUMBER

FUNCTION

ROKMISC.F_CALC_STUD_ADJ_HRS

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

NA

SYSDATE

DISBURSEMENT_FINALIZE_IND Indicates whether all disbursements have been made within the academic period. VARCHAR2(1)

RPRATRM

RPRATRM_DISB_FINAL_IND

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

NA

NA

FUND Financial Aid Fund code to be associated with information in this record. VARCHAR2(6)

RPRATRM

RPRATRM_FUND_CODE

FUND_TITLE Full title of the financial aid fund code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

INSTITUTION_AID_IND Indicates whether the person is receiving a financial aid award that is identified with a financial aid fund type of as institution aid. VARCHAR2(1)

FUNCTION

F_INST_AID_FNC

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)

RPRATRM

RPRATRM_PIDM

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(1)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(1)

NA

NA

TERM_PERCENT_OF_DISTRIBUTION Distribution of the award over the academic periods associated with the record. NUMBER(6, 3)

RPRATRM

RPRATRM_DIST_PCT

TIME_STATUS_IND Student's enrollment status at the time of packaging. E.g., three quarter time, half time, full time. VARCHAR2(1)

RPRATRM

RPRATRM_PCKG_LOAD_IND

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

NA

NA



Ver: 3.1