Go To View:
-- Select a View --
AA_ADVANCEMENT_RATING
AA_ANNUAL_GIVING
AA_CAMPAIGN
AA_CAMPAIGN_COMMENT
AA_CAMPAIGN_DESIGNATION
AA_CAMPAIGN_EXPENSE
AA_CAMPAIGN_FUNDRAISER
AA_CAMPAIGN_GIVING_HISTORY
AA_CAMPAIGN_MAIL
AA_CAMPAIGN_SOLICITATION
AA_CONSTITUENT
AA_CONSTITUENT_CONTACT
AA_CONSTITUENT_PLAN
AA_CONSTITUENT_STAFF_ASSIGN
AA_CON_CONF_COMMENT_SUBJ
AA_CON_ENTITY_CONF_COMMENT
AA_DEGREE
AA_DESIGNATION
AA_DESIGNATION_ADJUSTMENT
AA_DESIGNATION_ATTRIBUTE
AA_DESIGNATION_CLASS_YEAR
AA_DESIGNATION_COMMENT
AA_DESIGNATION_COMMENT_SUBJ
AA_DESIGNATION_FINAID_FUND
AA_DESIGNATION_GIVING_HISTORY
AA_DESIGNATION_ID
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_INTEREST
AA_MAIL
AA_MEMBERSHIP
AA_MEMBERSHIP_DUES
AA_MEMBERSHIP_INTEREST
AA_ORGANIZATIONAL_CONSTITUENT
AA_ORGANIZATION_CONTACT
AA_ORGANIZATION_FUNDING_AREA
AA_PLEDGE
AA_PLEDGE_ASSOCIATED_ENTITY
AA_PLEDGE_AUXILIARY
AA_PLEDGE_CONDITIONAL
AA_PLEDGE_INSTALLMENT
AA_PLEDGE_MATCHING
AA_PREVIOUS_EMPLOYMENT
AA_PROJECT_INTEREST
AA_PROSPECT_CONF_COMMENT
AA_PROSPECT_CONF_COMMENT_SUBJ
AA_PROSPECT_CONTACT_EXPENSE
AA_PROSPECT_INFO
AA_PROSPECT_MOVES_MANAGEMENT
AA_PROSPECT_PROPOSAL
AA_PROSPECT_PROPOSAL_MASTER
AA_PROSPECT_PROPOSAL_PROJECT
AA_PROSPECT_PROPOSAL_RESULT
AA_PROSPECT_STAFF_ASSIGNMENT
AA_RELATIONSHIP
AA_SALUTATION
AA_SOLICITOR
AA_SOLICITOR_ASSIGNMENT
AA_SOLICITOR_ASSIGNMENT_RESULT
AA_SOLICITOR_ORGANIZATION
AA_SOLICITOR_ORG_COMMENT
AA_SOLICITOR_ORG_FUNDRAISER
AA_SOL_ORG_FUNDRAISER_GOAL
AA_SOL_ORG_GOAL
AA_SPECIAL_ACTIVITY
AA_SPECIAL_ACTIVITY_YEAR
AA_SPECIAL_PURPOSE_GROUP
AA_VALIDATION
AA_YEAR_TYPE_DEFINITION
AE_ACCOUNTING
AE_APPROVAL_HISTORY
AE_AUTHORIZATION
AE_CIRC_HEADER_STEP
AE_CIRC_RECIP_NOTIF
AE_DELEGATE_ASSIGNMENT
AE_EXPENSE_ITEM
AE_EXPENSE_ITEM_TAX
AE_ITINERARY
AE_PORTFOLIO
AE_PROFILE
AE_REIMBURSEMENT
AE_STATUS_HISTORY
AF_ACCOUNT_ATTRIBUTES_ODS
AF_ACCOUNT_HIERARCHY
AF_ACCOUNT_HIERARCHY_FISCAL
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_CLAUSE
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_HIERARCHY_FISCAL
AF_FUND_TYPE_ATTRIBUTES_ODS
AF_GENERAL_LEDGER
AF_GRANT
AF_GRANT_ATTRIBUTES_ODS
AF_GRANT_BILLING_DETAIL
AF_GRANT_DEFERRED_COST
AF_GRANT_EVENT
AF_GRANT_EVENT_STATUS
AF_GRANT_FUND
AF_GRANT_LEDGER
AF_GRANT_PERSONNEL
AF_INVOICE
AF_INVOICE_ACCOUNTING
AF_INVOICE_CHECK
AF_INVOICE_ITEM
AF_INVOICE_TAX_RATE
AF_LOCATION_ATTRIBUTES_ODS
AF_LOCATION_HIERARCHY
AF_LOCATION_HIERARCHY_FISCAL
AF_OPERATING_LEDGER
AF_ORGANIZATION_ATTRIBUTES_ODS
AF_ORGANIZATION_HIERARCHY
AF_ORGN_HIERARCHY_FISCAL
AF_PROGRAM_ATTRIBUTES_ODS
AF_PROGRAM_HIERARCHY
AF_PROGRAM_HIERARCHY_FISCAL
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
AF_VENDOR_TAXABLE_REPORTING
AG_ALTERNATIVE_ID
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_FMLA_LEAVE_COMMENT
AN_JOB_FTE_TRACKING
AN_LABOR_COST_DISTRIBUTION
AN_PAYROLL_DISTRIBUTION
AN_PERSONNEL_ACTION
AN_PERSONNEL_ACTION_COMMENT
AN_PERSONNEL_ACTION_EARNING
AN_PERSONNEL_ACTION_GENERAL
AN_PERSONNEL_ACTION_LABOR_DIST
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_FAMILY_MEDICAL_LEAVE_HIST
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_STUDENT_PERIOD_DEFINITION
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_ENROLLMENT_WITHDRAWAL
AS_FACULTY
AS_FACULTY_ATTRIBUTE
AS_FACULTY_CONTRACT
AS_FACULTY_DEPARTMENT_COLLEGE
AS_FACULTY_FEEDBACK
AS_FACULTY_FEEDBACK_DETAIL
AS_FIELD_OF_STUDY
AS_GENERAL_STUDENT
AS_GENSTU_END_TERM
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_CLASSIFICATION
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_TRANSFERRED_COURSE
AS_STUDENT_WORK_EXPERIENCE
AS_TELEPHONE
AS_TEST
AS_TRANSCRIPT_LEVEL_COMMENT
AS_TRANSCRIPT_TERM_COMMENT
AS_VALIDATION
AS_VETERAN_CERTIFICATION
AS_VISA
AS_YEAR_TYPE_DEFINITION
AT_ACCOUNT
AT_ACCOUNT_DETAIL
AT_APPLICATION_OF_PAYMENT
AT_AR_DEPOSIT
AT_CONTRACT
AT_CONTRACT_PAYMENT_DETAIL
AT_EXEMPTION
AT_GRANT_ACCOUNT_DETAIL
AT_GRANT_APPLICATION_PAYMENT
AT_INSTALLMENT_PLAN
AT_LEDGER_ACCOUNTING
AT_MEMO
AT_MISCELLANEOUS_TRANSACTION
AT_STUDENT_TAX_NOTIFICATION
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_ADMR_CODE
SOAPCOL
SORPCOL_DATA_ORIGIN
NA
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
SORPCOL_USER_ID
NA
Ver: