Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: CONSTANT Common
SGHE Banner Operational Data Store Composite View Source: CONSTANT - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
'ACCOUNT' NA       NA
'ACTIVE' NA       NA
'ACYR' NA       NA
'AIDY' NA       NA
'ATYP' NA       NA
'ACADEMIC YEAR' NA COMPOSITE VIEW

AS_YEAR_TYPE_DEFINITION

YEAR_TYPE_DESC

NA
'AID YEAR' NA COMPOSITE VIEW

AR_YEAR_TYPE_DEFINITION

YEAR_TYPE_DESC

NA
'BAN-ALUMNI' NA       NA
'BAN-ALUMNI' FOR ADVANCEMENT,'BAN-HR' FOR HR NA       NA
'BAN-HR' NA       NA
'C' NA COMPOSITE VIEW

AS_GPA_LEVEL

GPA_GROUPING

NA
'COLLEGE' NA COMPOSITE VIEW

AS_PREVIOUS_EDUCATION_PCOL

INSTITUTION_TYPE_DESC

NA
'CUMULATIVE VALUES' NA COMPOSITE VIEW

AS_GPA_LEVEL

GPA_GROUPING_DESC

NA
'EL' NA COMPOSITE VIEW

AS_ENROLLMENT_HISTORY

ENROLLMENT_STATUS

NA
'FA_PROC_YR' NA COMPOSITE VIEW

AS_YEAR_TYPE_DEFINITION

YEAR_TYPE

NA
'FTYP' NA       NA
'FUND' NA       NA
'FINANCIAL AID PROCESSING YEAR FOR AN ACADEMIC PERIOD' NA COMPOSITE VIEW

AS_YEAR_TYPE_DEFINITION

YEAR_TYPE_DESC

NA
'H' TBD COMPOSITE VIEW

AS_PREVIOUS_EDUCATION_HSCH

SOURCE_FLAG

 
'HIGHSCHOOL' NA COMPOSITE VIEW

AS_PREVIOUS_EDUCATION_HSCH

INSTITUTION_TYPE_DESC

NA
'INACTIVE' NA       NA
'INST_AIDY' NA       NA
'INSTITUTION AID YEAR AND CURRENT ACADEMIC PERIOD' NA COMPOSITE VIEW

AR_YEAR_TYPE_DEFINITION

YEAR_TYPE_DESC

NA
'LEVEL' NA COMPOSITE VIEW

AS_GPA_LEVEL

ACADEMIC_STUDY_AREA

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

AS_ENROLLMENT_HISTORY

AS_GPA_LEVEL

AS_STUDENT_COURSE_TRANSFER

AS_YEAR_TYPE_DEFINITION

AS_STUDENT_COURSE_HISTORY

AS_STUDENT_COURSE_HISTORY

AS_STUDENT_COURSE_TRANSFER

ENROLLMENT_EXISTS_IND

GPA_TIME_IND

INSTITUTION_COURSE_IND

YEAR_TYPE

TRANSFER_COURSE_IND

IN_PROGRESS_COURSE_IND

IN_PROGRESS_COURSE_IND

NA
'NON-TIME BASED' NA COMPOSITE VIEW

AS_GPA_LEVEL

GPA_TIME_IND_DESC

NA
'O' NA COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

ENTITY_IND

NA
'ORGN' NA       NA
'P' NA COMPOSITE VIEW

AS_PREVIOUS_EDUCATION_PCOL

AA_CONSTITUENT

AS_GPA_TERM

AS_GPA_TERM

SOURCE_FLAG

ENTITY_IND

GPA_GROUPING

GPA_TIME_IND

NA
'PRIMARY' NA       NA
'PROGRAM' NA       NA
'PERIOD BASED VALUES' NA COMPOSITE VIEW

AS_GPA_TERM

GPA_GROUPING_DESC

NA
'PERIOD' NA COMPOSITE VIEW

AS_GPA_TERM

GPA_TIME_IND_DESC

NA
'SECONDARY' NA       NA
'TERM' SHAINST COMPOSITE VIEW

AS_GPA_TERM

ACADEMIC_STUDY_AREA

NA
'Y' SHATCKS COMPOSITE VIEW

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT

AS_ENROLLMENT_HISTORY

AS_STUDENT_COURSE_TRANSFER

AS_STUDENT_COURSE_HISTORY

ENROLLED_IND

AR_CHGS_ACCEPTANCE_IND

ACADEMIC_HISTORY_EXISTS_IND

ENROLLMENT_EXISTS_IND

REGISTERED_IND

TRANSFER_COURSE_IND

INSTITUTION_COURSE_IND

NA
0 NA COMPOSITE VIEW

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

TOTAL_BILLING

TOTAL_CEU_BILLING

TOTAL_NON_CEU_BILLING

NA
ADVANCEMENT FISCAL YEAR NA COMPOSITE VIEW

AA_YEAR_TYPE_DEFINITION

YEAR_TYPE_DESC

 
ADVANCEMENT GIFT SOCIETY YEAR NA COMPOSITE VIEW

AA_YEAR_TYPE_DEFINITION

YEAR_TYPE_DESC

 
ADV_FISC NA COMPOSITE VIEW

AA_YEAR_TYPE_DEFINITION

YEAR_TYPE

 
ADV_GIFT_SOC NA COMPOSITE VIEW

AA_YEAR_TYPE_DEFINITION

YEAR_TYPE

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

AA_ADVANCEMENT_RATING

INTERNAL_IND

NA
HIGH SCHOOL NA        
HARD CODED VALUES '00' THROUGH '14' NA COMPOSITE VIEW

AF_GRANT_LEDGER

GRANT_PERIOD

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

AF_OPERATING_LEDGER

FISCAL_PERIOD

NA
L NA COMPOSITE VIEW

AS_TRANSCRIPT_LEVEL_COMMENT

COMMENT_TYPE

 
LEVEL NA COMPOSITE VIEW

AS_TRANSCRIPT_LEVEL_COMMENT

COMMENT_TYPE_DESC

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

AA_SOLICITOR

GIFT_PLEDGE_IND

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

AA_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 COMPOSITE VIEW

AA_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 COMPOSITE VIEW

AA_RELATIONSHIP

RELATION_SOURCE

 
SOURCE APVXREF THEN 'X'; SOURCE APVCSPS THEN 'S';SOURCE APVCHLD THEN 'C' NA       NA
T NA COMPOSITE VIEW

AS_TRANSCRIPT_TERM_COMMENT

COMMENT_TYPE

 
TERM NA COMPOSITE VIEW

AS_TRANSCRIPT_TERM_COMMENT

COMMENT_TYPE_DESC

 


Ver: 8.0