RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: CONSTANT Common Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: CONSTANT

Source Column Source Form Target Type Target Target Column Calculation Formula
'ACCOUNT' NA

REPORTING VIEW

FOAPAL_NO_ATTRIBUTES

FOAPAL_ELEMENT_TYPE

NA
'ACTIVE' NA       NA
'ACYR' NA

REPORTING VIEW

YEAR_TYPE_DEFINITION

YEAR_TYPE

NA
'AIDY' NA

REPORTING VIEW

YEAR_TYPE_DEFINITION

YEAR_TYPE

NA
'ATYP' NA

REPORTING VIEW

FOAPAL_NO_ATTRIBUTES

FOAPAL_ELEMENT_TYPE

NA
'ACADEMIC YEAR' NA

REPORTING VIEW

YEAR_TYPE_DEFINITION

YEAR_TYPE_DESC

NA
'AID YEAR' NA

REPORTING VIEW

YEAR_TYPE_DEFINITION

YEAR_TYPE_DESC

NA
'BAN-ALUMNI' NA

REPORTING VIEW

CURRENT_EMPLOYMENT

ID_SOURCE

NA
'BAN-ALUMNI' FOR ADVANCEMENT,'BAN-HR' FOR HR NA       NA
'BAN-HR' NA

REPORTING VIEW

CURRENT_EMPLOYMENT

ID_SOURCE

NA
'C' NA

REPORTING VIEW

GPA

GPA_GROUPING

NA
'COLLEGE' NA

REPORTING VIEW

PREVIOUS_EDUCATION

COMBINED_ACADEMIC_OUTCOME

INSTITUTION_TYPE_DESC

INSTITUTION_TYPE_DESC

NA
'CUMULATIVE VALUES' NA

REPORTING VIEW

GPA

GPA_GROUPING_DESC

NA
'EL' NA       NA
'FA_PROC_YR' NA

REPORTING VIEW

YEAR_TYPE_DEFINITION

YEAR_TYPE

NA
'FTYP' NA

REPORTING VIEW

FOAPAL_NO_ATTRIBUTES

FOAPAL_ELEMENT_TYPE

NA
'FUND' NA

REPORTING VIEW

FOAPAL_NO_ATTRIBUTES

FOAPAL_ELEMENT_TYPE

NA
'FINANCIAL AID PROCESSING YEAR FOR AN ACADEMIC PERIOD' NA

REPORTING VIEW

YEAR_TYPE_DEFINITION

YEAR_TYPE_DESC

NA
'HIGHSCHOOL' NA

REPORTING VIEW

PREVIOUS_EDUCATION

INSTITUTION_TYPE_DESC

NA
'INACTIVE' NA       NA
'INST_AIDY' NA

REPORTING VIEW

YEAR_TYPE_DEFINITION

YEAR_TYPE

NA
'INSTITUTION AID YEAR AND CURRENT ACADEMIC PERIOD' NA

REPORTING VIEW

YEAR_TYPE_DEFINITION

YEAR_TYPE_DESC

NA
'LEVEL' NA

REPORTING VIEW

GPA

ACADEMIC_STUDY_AREA

This indicates the academic study area is LEVEL.
'LOCATION' NA

REPORTING VIEW

FOAPAL_NO_ATTRIBUTES

FOAPAL_ELEMENT_TYPE

NA
'N' NA

REPORTING VIEW

STUDENT_COURSE

STUDENT_COURSE

GPA

COMBINED_ACADEMIC_OUTCOME

ACADEMIC_STUDY

ACTIVITY

INSTITUTION_COURSE_IND

IN_PROGRESS_COURSE_IND

GPA_TIME_IND

INTERNAL_ACADEMIC_OUTCOME_IND

PRIMARY_PROGRAM_IND

ADVANCEMENT_ACTIVITY_IND

NA
'NON-TIME BASED' NA

REPORTING VIEW

GPA

GPA_TIME_IND_DESC

NA
'O' NA

REPORTING VIEW

GIFT_AUXILIARY

GIFT_MATCHING

GIFT_MATCHING_TRANSACTION

GIFT_MULTIPLE

PLEDGE

GIFT_ASSOCIATED_ENTITY

GIFT_MEMO

PLEDGE_TRANSACTION

FUNDING_INTEREST

CONSTITUENT_ENTITY

GIFT_TRANSACTION

CAMPAIGN_GIVING_HISTORY

MEMBERSHIP_INTEREST

GIFT

ANNUAL_GIVING

DESIGNATION_GIVING_HISTORY

PROSPECT_INFO

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

NA
'ORGN' NA

REPORTING VIEW

FOAPAL_NO_ATTRIBUTES

FOAPAL_ELEMENT_TYPE

NA
'P' NA

REPORTING VIEW

FUNDING_INTEREST

PROSPECT_INFO

ANNUAL_GIVING

GIFT_AUXILIARY

GIFT

GIFT_MATCHING_TRANSACTION

MEMBERSHIP_INTEREST

GIFT_MATCHING

GIFT_MULTIPLE

PLEDGE

GPA

DESIGNATION_GIVING_HISTORY

PLEDGE_TRANSACTION

GIFT_MEMO

GIFT_TRANSACTION

GPA

GIFT_ASSOCIATED_ENTITY

CAMPAIGN_GIVING_HISTORY

CONSTITUENT_ENTITY

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

GPA_TIME_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

GPA_GROUPING

ENTITY_IND

ENTITY_IND

ENTITY_IND

NA
'PRIMARY' NA       NA
'PROGRAM' NA

REPORTING VIEW

FOAPAL_NO_ATTRIBUTES

FOAPAL_ELEMENT_TYPE

NA
'PERIOD BASED VALUES' NA

REPORTING VIEW

GPA

GPA_GROUPING_DESC

NA
'PERIOD' NA

REPORTING VIEW

GPA

GPA_TIME_IND_DESC

NA
'SECONDARY' NA       NA
'TERM' SHAINST       NA
'Y' SHATCKS

REPORTING VIEW

COMBINED_ACADEMIC_OUTCOME

ACTIVITY

STUDENT_COURSE

INTERNAL_ACADEMIC_OUTCOME_IND

ADVANCEMENT_ACTIVITY_IND

INSTITUTION_COURSE_IND

NA
0 NA       NA
BAN-ALUMNI FOR ADVANCEMENT, BAN-HR FOR HR NA       NA
DATA SOURCE IS AMRPRRT THEN 'Y'; DATA SOURCE IS AMREXRT THEN 'N' NA

REPORTING VIEW

ADVANCEMENT_RATING

INTERNAL_IND

NA
HARD CODED VALUES '00' THROUGH '14' NA

REPORTING VIEW

GRANT_LEDGER

GRANT_PERIOD

NA
HARD CODED VALUES '01' THROUGH '14' FGIBDST

REPORTING VIEW

OPERATING_LEDGER

FISCAL_PERIOD

NA
MALE; FEMALE; NOT REPORTED SPAPERS       Constants for Gender selection.
PRIMARY NA       NA
SOURCE AGRGSOL THEN 'G'; SOURCE AGRPSOL THEN 'P' NA

REPORTING VIEW

SOLICITATION

GIFT_PLEDGE_IND

NA
SOURCE AOBORGN THEN 'Y', ELSE 'N' NA

REPORTING VIEW

ORGANIZATION_CONTACT

PRIMARY_CONTACT_IND

NA
SOURCE APRCHLD AND APRXREF THEN 'CHILD/CROSS REFERENCE'; APRCHLD THEN 'CHILD'; APRCSPS AND APRXREF THEN 'SPOUSE/CROSS REFERENCE'; APRCSPS THEN 'SPOUSE'; APRXREF THEN 'CROSS REFERENCE' TBD

REPORTING VIEW

RELATIONSHIP

RELATION_SOURCE_DESC

 
SOURCE APRCHLD AND APRXREF THEN 'CX'; SOURCE APRCHLD THEN 'C'; SOURCE APRCSPS AND APRXREF THEN 'SX'; SOURCE APRCSPS THEN 'S'; SOURCE APRXREF THEN 'X' TBD

REPORTING VIEW

RELATIONSHIP

RELATION_SOURCE

 
SOURCE APVXREF THEN 'X'; SOURCE APVCSPS THEN 'S';SOURCE APVCHLD THEN 'C' NA       NA


Ver: 3.1