Go To View:
-- Select a View --
AA_ADVANCEMENT_RATING
AA_ANNUAL_GIVING
AA_CAMPAIGN_GIVING_HISTORY
AA_CONSTITUENT
AA_CONSTITUENT_CONTACT
AA_CONSTITUENT_PLAN
AA_CONSTITUENT_STAFF_ASSIGN
AA_DEGREE
AA_DESIGNATION_GIVING_HISTORY
AA_DONOR_CATEGORY
AA_EXCLUSION
AA_FUNDING_INTEREST
AA_GIFT
AA_GIFT_ASSOCIATED_ENTITY
AA_GIFT_AUXILIARY
AA_GIFT_MATCHING
AA_GIFT_MEMO
AA_GIFT_MULTIPLE
AA_GIFT_SOCIETY
AA_MAIL
AA_MEMBERSHIP
AA_MEMBERSHIP_DUES
AA_MEMBERSHIP_INTEREST
AA_ORGANIZATIONAL_CONSTITUENT
AA_ORGANIZATION_CONTACT
AA_PLEDGE
AA_PLEDGE_ASSOCIATED_ENTITY
AA_PLEDGE_AUXILIARY
AA_PLEDGE_CONDITIONAL
AA_PLEDGE_INSTALLMENT
AA_PLEDGE_MATCHING
AA_PREVIOUS_EMPLOYMENT
AA_PROSPECT_INFO
AA_PROSPECT_PROPOSAL
AA_RELATIONSHIP
AA_SALUTATION
AA_SOLICITOR
AA_SPECIAL_ACTIVITY
AA_SPECIAL_ACTIVITY_YEAR
AA_SPECIAL_PURPOSE_GROUP
AA_VALIDATION
AA_YEAR_TYPE_DEFINITION
AF_ACCOUNT_ATTRIBUTES_ODS
AF_ACCOUNT_HIERARCHY
AF_ACCOUNT_INDEX
AF_ACCOUNT_TYPE_ATTRIBUTES_ODS
AF_ACTIVITY_ATTRIBUTES_ODS
AF_ATTRIBUTE_SETS_ODS
AF_BUDGET_AVAILABILITY_LEDGER
AF_BUDGET_DETAIL
AF_CHART_ATTRIBUTES_ODS
AF_CHECKS
AF_ENCUMBRANCE
AF_ENCUMBRANCE_ACCOUNTING
AF_ENCUMBRANCE_LEDGER
AF_ENDOWMENT
AF_ENDOWMENT_ATTRIBUTES
AF_ENDOWMENT_DIST
AF_ENDOWMENT_MARKET_VALUES
AF_ENDOWMENT_UNITS
AF_FISCAL_PERIOD
AF_FIXED_ASSET_ADJUSTMENT
AF_FIXED_ASSET_ATTRIBUTES
AF_FIXED_ASSET_DEPRECIATION
AF_FIXED_ASSET_FUNDING_SOURCE
AF_FIXED_ASSET_ITEM
AF_FUND_ATTRIBUTES_ODS
AF_FUND_HIERARCHY
AF_FUND_TYPE_ATTRIBUTES_ODS
AF_GENERAL_LEDGER
AF_GRANT
AF_GRANT_ATTRIBUTES_ODS
AF_GRANT_BILLING_DETAIL
AF_GRANT_FUND
AF_GRANT_LEDGER
AF_INVOICE
AF_INVOICE_ACCOUNTING
AF_INVOICE_CHECK
AF_INVOICE_ITEM
AF_INVOICE_TAX_RATE
AF_LOCATION_ATTRIBUTES_ODS
AF_LOCATION_HIERARCHY
AF_OPERATING_LEDGER
AF_ORGANIZATION_ATTRIBUTES_ODS
AF_ORGANIZATION_HIERARCHY
AF_PROGRAM_ATTRIBUTES_ODS
AF_PROGRAM_HIERARCHY
AF_PROPOSAL
AF_PURCHASE_ORDER
AF_PURCHASE_ORDER_ACCOUNTING
AF_PURCHASE_ORDER_ITEM
AF_PURCHASE_ORDER_TAX_RATE
AF_RECEIVED_ITEM
AF_RETURNED_ITEM
AF_TEXT
AF_TRANSACTION_HISTORY
AF_VALIDATION
AF_VENDOR
AG_COMMUNICATION
AG_EVENT
AG_EVENT_INVITEE
AG_GEOGRAPHIC_REGION
AG_GEOGRAPHIC_REGION_INST
AG_INTERNET_ADDRESS
AG_VALIDATION
AN_EMPLOYEE_POSITION
AN_FISCAL_YEAR
AN_JOB_FTE_TRACKING
AN_LABOR_COST_DISTRIBUTION
AN_PAYROLL_DISTRIBUTION
AN_POSITION_BUDGET
AN_POSITION_DEFINITION
AN_POSITION_LABOR_DISTRIBUTION
AN_SALARY_RATE
AN_SUPERVISOR
AN_VALIDATION
AP_BARGAINING_UNIT
AP_BENEFICIARY_DEPENDENT
AP_BENEFIT_DEDUCTION
AP_CERTIFICATION
AP_EARNING_TOTALS_CY
AP_EARNING_TOTALS_FY
AP_EMPLOYEE
AP_EMPLOYEE_EARNING_CY
AP_EMPLOYEE_EARNING_FY
AP_FACULTY_APPOINTMENT_HISTORY
AP_FACULTY_RANK_HISTORY
AP_FACULTY_SABBATICAL_HISTORY
AP_HR_APPLICATION
AP_HR_APPLICATION_STATUS
AP_HR_REQUISITION
AP_INTERVIEW
AP_LEAVE_ACCRUAL
AP_LEAVE_BALANCE
AP_MONTHLY_DEDUCTION
AP_PAST_EMPLOYMENT
AP_PAYROLL_ATTENDANCE
AP_PAYROLL_DEDUCTION
AP_PAYROLL_DOCUMENT
AP_PAYROLL_EARNING
AP_PAYROLL_EMPLOYEE_POSITION
AP_PAYROLL_LABOR_DIST_OVERRIDE
AP_PAYROLL_TIMESHEET
AP_REFERENCE
AP_REVIEW
AP_SKILL
AP_TAX
AP_VALIDATION
AP_YEARLY_DEDUCTION
AR_APPLICANT_NEED
AR_APPLICANT_RESOURCE
AR_AWARD_BY_AID_YEAR
AR_AWARD_BY_FUND
AR_AWARD_BY_PERSON
AR_AWARD_DISBURSEMENT
AR_FINAID_APPLICANT_STATUS
AR_FINAID_APPLICATION1
AR_FINAID_APPLICATION2
AR_FINAID_APPLICATION3
AR_FINAID_APPLICATION4
AR_FINAID_BUDGET_COMPONENT
AR_FINAID_COMMENTS
AR_FINAID_ENROLLMENT
AR_FINAID_FUND
AR_FINAID_HOLD
AR_FINAID_MESSAGE
AR_FINAID_TRACKING_REQUIREMENT
AR_FUND_MESSAGE_RULE
AR_LOAN_AGGREGATES
AR_LOAN_APPLICATION
AR_LOAN_DISBURSEMENT
AR_NEED_ANALYSIS_ISIR_SPEC
AR_NEED_ANALYSIS_OVERRIDE
AR_NEED_ANALYSIS_PROFILE_SPEC
AR_SATISFACTORY_ACAD_PROGRESS
AR_USER_DEFINED_FIELDS
AR_VALIDATION
AR_YEAR_TYPE_DEFINITION
AS_ACADEMIC_HISTORY_EVENT
AS_ACADEMIC_OUTCOME
AS_ACADEMIC_STANDING
AS_ACTIVE_TERMS
AS_ADDRESS
AS_ADMINISTRATOR
AS_ADMISSIONS_APPLICATION
AS_ADMISSIONS_ATTRIBUTE
AS_ADMISSIONS_COHORT
AS_ADMISSIONS_DECISION
AS_ADMISSIONS_RATING
AS_ADMISSIONS_REQUIREMENT
AS_ADMISSIONS_SOURCE
AS_ADVISOR
AS_CONTACT
AS_COURSE_ATTRIBUTE
AS_COURSE_CATALOG
AS_COURSE_COREQ
AS_COURSE_LEVEL
AS_COURSE_OFFERING
AS_COURSE_OFFERING_FEES
AS_COURSE_PREREQ
AS_COURSE_SCHEDULE
AS_COURSE_SUPPLEMENTAL
AS_CURRICULUM
AS_CURRICULUM_FOS
AS_DISABILITY_INFORMATION
AS_ENROLLMENT
AS_ENROLLMENT_HISTORY
AS_FACULTY
AS_FACULTY_ATTRIBUTE
AS_FACULTY_CONTRACT
AS_FACULTY_DEPARTMENT_COLLEGE
AS_FIELD_OF_STUDY
AS_GENERAL_STUDENT
AS_GPA_LEVEL
AS_GPA_TERM
AS_HOLD
AS_INSTITUTION
AS_INSTITUTION_CHARACTERISTIC
AS_INSTITUTION_DEMOGRAPHIC
AS_INSTRUCTIONAL_ASSIGNMENT
AS_INTEREST
AS_LEARNER_CURRICULUM_FOS
AS_MEAL_ASSIGNMENT
AS_MEDICAL_INFORMATION
AS_MEETING_TIME
AS_NONINSTRUCTIONAL_ASSIGNMENT
AS_OFFERING_COREQ
AS_OFFERING_GRADE_MODE
AS_OFFERING_GRADE_TYPE
AS_OFFERING_PREREQ
AS_ORGANIZATION_ENTITY
AS_OUTCOME_HONOR_DEPT
AS_OUTCOME_HONOR_INST
AS_PERSON
AS_PHONE_ASSIGNMENT
AS_PREVIOUS_DEGREE
AS_PREVIOUS_EDUCATION_HSCH
AS_PREVIOUS_EDUCATION_PCOL
AS_PRE_STUDENT
AS_RACE
AS_RECRUITMENT_ATTRIBUTE
AS_RECRUITMENT_COHORT
AS_RECRUITMENT_INFORMATION
AS_RECRUITMENT_LEARNED
AS_RECRUITMENT_SOURCE
AS_ROOM_ASSIGNMENT
AS_SCHEDULE_ATTRIBUTE
AS_SECONDARY_SCHOOL_SUBJECT
AS_SPORT
AS_STUDENT_ACTIVITY
AS_STUDENT_ATTRIBUTE
AS_STUDENT_COHORT
AS_STUDENT_COURSE_ATTRIBUTE
AS_STUDENT_COURSE_ATTR_TRANS
AS_STUDENT_COURSE_GRADE_CHG
AS_STUDENT_COURSE_HISTORY
AS_STUDENT_COURSE_IN_PROGRESS
AS_STUDENT_COURSE_REG_AUDIT
AS_STUDENT_COURSE_TRANSFER
AS_STUDENT_WORK_EXPERIENCE
AS_TELEPHONE
AS_TEST
AS_TRANSCRIPT_LEVEL_COMMENT
AS_TRANSCRIPT_TERM_COMMENT
AS_VALIDATION
AS_VISA
AS_YEAR_TYPE_DEFINITION
AT_ACCOUNT
AT_ACCOUNT_DETAIL
AT_APPLICATION_OF_PAYMENT
AT_AR_DEPOSIT
AT_CONTRACT
AT_EXEMPTION
AT_GRANT_ACCOUNT_DETAIL
AT_GRANT_APPLICATION_PAYMENT
AT_INSTALLMENT_PLAN
AT_LEDGER_ACCOUNTING
AT_MEMO
AT_MISCELLANEOUS_TRANSACTION
AT_VALIDATION
RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: SORPCOL
Student
SGHE Banner Operational Data Store
Composite View Source: SORPCOL - NULL
Source Column
Source Form
Target Type
Target
Target Column
Calculation Formula
SORPCOL_ACTIVITY_DATE
TBD
COMPOSITE VIEW
AS_PREVIOUS_EDUCATION_PCOL
EDUCATION_ACTIVITY_DATE
SORPCOL_OFFICIAL_TRANS
SOAPCOL
NA
SORPCOL_PIDM
NA
NA
SORPCOL_SBGI_CODE
SOAPCOL
NA
SORPCOL_TRANS_RECV_DATE
SOAPCOL
NA
SORPCOL_TRANS_REV_DATE
SOAPCOL
NA
Ver: 8.1