RETURN TO DIMENSION TABLE REPORTS LIST
Financial Aid Pre-Student Star Recruiting And Admission Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_FINANCIAL_AID_STATUS

Description Financial Aid Status Dimension table provides information on the processing steps completed for financial aid. This information includes award offered, accepted, declined or canceled and paid. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
AWARD_ACCEPTED_IND Indicator specifies whether or not an award has been accepted by student applicant. The VALUES or 'Y' - has been and 'N' - has not been. VARCHAR2(63)

AWARD_BY_PERSON

AWARD_ACCEPT_IND

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION

AWARD_CANCELED_IND Indicator specifies whether or not an award has been canceled for the student applicant. The VALUES or 'Y' - has been and 'N' - has not been. VARCHAR2(63)

AWARD_BY_PERSON

AWARD_CANCEL_IND

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION

AWARD_DECLINED_IND Indicator specifies whether or not an award has been declined by the student applicant. The VALUES or 'Y' - has been and 'N' - has not been. VARCHAR2(63)

AWARD_BY_PERSON

AWARD_DECLINE_IND

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION

AWARD_OFFERED_IND Indicator specifies whether or not an award has been offered to the student applicant. The VALUES or 'Y' - has been and 'N' - has not been. VARCHAR2(63)

AWARD_BY_PERSON

AWARD_OFFER_IND

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION

AWARD_PAID_IND Indicator specifies whether or not an award has been paid to the student applicant. The VALUES or 'Y' - has been and 'N' - has not been. VARCHAR2(63)

AWARD_BY_PERSON

FUNCTION

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION

FINANCIAL_AID_STATUS_KEY Key for the financial aid status dimension. NUMBER

ETL GENERATED

NA

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION



Ver: 3.1