COGNOS PACKAGE

COGNOS PACKAGE

COGNOS PACKAGE DOCUMENTATION Table of Content STUDENT MODULE ...

2MB Sizes 5 Downloads 30 Views

COGNOS PACKAGE DOCUMENTATION

Table of Content STUDENT MODULE ............................................................................................................................................... 3 Active Registration Package ................................................................................................................................ 3 Admission Application Package ........................................................................................................................... 5 Advisor Student List Package .............................................................................................................................. 7 Course Catalog Package....................................................................................................................................... 9 Enrollment Management Package .................................................................................................................... 10 Faculty Assignment Package ............................................................................................................................. 12 Government Reporting Package ....................................................................................................................... 14 Person Demographic Package ........................................................................................................................... 16 Person Supplemental Package .......................................................................................................................... 17 Recruitment Information Package .................................................................................................................... 19 Residential Life Package..................................................................................................................................... 21 Schedule Offering Package ................................................................................................................................ 23 Student Detail Package ...................................................................................................................................... 25 FINANCIAL AID MODULE ................................................................................................................................. 27 Financial Aid Application Package ..................................................................................................................... 27 Financial Aid Award and Disbursement ........................................................................................................... 29 Financial Aid Fund Package ............................................................................................................................... 31 ACCOUNT RECIEVABLE MODULE .................................................................................................................. 33 Receivable Customer Package .......................................................................................................................... 33 Receivable Revenue Package ............................................................................................................................ 35 COMMON MODULE ............................................................................................................................................. 37 Event Entity Package .......................................................................................................................................... 37 Institution Package ............................................................................................................................................. 38 Organization Entity Package .............................................................................................................................. 39 Person Demographic Package ........................................................................................................................... 41 Person Role Package .......................................................................................................................................... 43 OIT- Information Management & Reporting | ODS Package Description Document

1

Person Supplemental Package .......................................................................................................................... 45 Relationship Package .......................................................................................................................................... 47 ODS DECISION TREE DIAGRAM .................................................................................................................... 48 Cohort Diagram ................................................................................................................................................... 48 Financial Aid Cohort Diagram ............................................................................................................................ 49 Student Cohort Diagram .................................................................................................................................... 50 Course Cohort Diagram ...................................................................................................................................... 51 Admission Cohort Diagram ................................................................................................................................ 52

OIT- Information Management & Reporting | ODS Package Description Document

2

STUDENT MODULE Active Registration Package

Information Includes: Enrollment, academic study, advisor, awards by person, faculty, GPA by level, instructional assignment, meeting time, person address and detail, current telephone and student related information: cohort, course, course attribute, course registration audit, and extended. ODS View Link: http://raptor.gpc.edu:9050/metadata/bcreps/ActiveRegistration.html

Banner Tables:

SFBETRM SHRTATC SHRTTRM SPBPERS

SFRAREG SHRTCKG SIBFACD SPRADDR

SATURN SFRSTCR SGBSTDN SHRTCKL SHRTCKN SIBINST SIRASGN SPRIDEN SSBOVRR GENERAL

SGRADVR SHRTRCE SIRDPCL SSBSECT

SGRVETN SHRTRIT SORLCUR

GOREMAL FAISMGR NBRJOBS

Example of Filters: Filters Description Student's current enrollment status for this section or schedule offering of students who are Eligible to Register Academic standing or progress indicator for the student as determined at the beginning of The academic period before grades are assigned. Indicates the student may continue to enroll or must seek assistance prior to continuing to study at the institution. For example if a student is on Academic Probation or on Good Standing status

Criteria [Active Registration].[Enrollment].[ENROLLMENT_STAT US] = ‘EL’

Active Registration].[Academic Study].[ACADEMIC_STANDING] = ‘AP’ or [Active Registration].[Academic Study].[ACADEMIC_STANDING] =’GS’

OIT- Information Management & Reporting | ODS Package Description Document

3

If you want all registered students (excluding those auditing the class) add this filter. Student's current status for the academic period. May include active and permitted to register, inactive and stop registration, graduated, etc Institution profile defined display rule determines which address displays for this person or entity. This display the Enrolled Address or Preferred Address of the student.

[Active Registration].[Student Course].[REGISTRATION_STATUS] in ('RE','RW') [Active Registration].[Student].[STUDENT_STATUS] = ‘AS’ or [Active Registration].[Student].[STUDENT_STATUS] =’IS’ [Active Registration].]Person Address].[ADDRESS_RULE] in (‘ENRLADDR’,’PREFADDR’)

Sample Report: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

4

Admission Application Package Information Includes: Admissions related information: applications, attributes, cohorts, decisions, ratings, requirements, sources; and contacts, employment, Financial Aid applicant status, geographic region, institution, interests, person detail recruitment, and tests. ODS View Link: http://raptor.gpc.edu:9050/metadata/bcreps/AdmissionsApplication.html

Banner Tables:

SABSUPL SARRSRC SORHSCH SPRMEDI

SARAPPD SGRADVR SORINTS SRBRECR

ROBINST

RCRAPP1

GOBINTL

GOREMAL

SATURN SARCHKL SARCHRT SHRTRIT SORAPPT SORLCUR SORLFOS FAISMGR RORSTAT RTVBGRP GENERAL GORVISA

SARRRAT SORCONT SORTEST

SARRSRC SORDEGR SPRIDEN

RTVAPRD

RTVBGRP

Example of Filters: Filter Description To report on test scores, the test rule must be set A filter for Student Level is necessary if you are trying to only see Undergraduate or only see Graduate level students. Most current status of the application, whether the status is determined by institution or student. For example whether there has been a decision made or there is outstanding documents needed to complete the application This decision code indicates the applicant has accepted the admissions offer. Indicates the most recent decision pertaining to this admissions application.

Criteria [Admission Application].[Test Slot].[TEST_RULE] = 'SATACT' Example for Undergraduate: [Admission Application].[Admissions Application].[STUDENT_LEVEL] = ('US') [Admission Application].[Admissions Application].[APPLICATION_STATUS] =’D’ or [Admission Application].[Admissions Application].[APPLICATION_STATUS] = ‘I’ [Admission Application].[Admissions Decision].[APPLICANT_ACCEPT_IND] = ‘Y’ [Admission Application].[Admissions Decision].[ LATEST_DECISION_IND] = ‘Y’

OIT- Information Management & Reporting | ODS Package Description Document

5

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

6

Advisor Student List Package Information Includes: Student, academic outcome, academic study, advisors, advisor person address, enrollment, GPA by term, person address and detail, pre-student, student cohort, student course and course attribute, current telephone and transcript comments. ODS View Link: http://raptor.gpc.edu:9050/metadata/bcreps/AdvisorStudentList.html Banner Tables:

SARADAP SGRADVR SHRTATC SHRTRIT SORLCUR SPRMEDI

SCBCRSE SGRVETN SHRTATT SHRTTRM SORLFOS SRBRECR

GOBINTL

GOREMAL

SATURN SFBETRM SFRAREG SHBDIPL SHRATTC SHRTCKG SHRTCKN SMRPRLE SORCONT SORPCOL SPBPERS SSBOVRR SSBSECT GENERAL

SFRSTCR SHRDGMR SHRTGPA SORDEGR SPRADDR SSRSYLN

SGBSTDN SHRGRDE SHRTRCE SORHSCH SPRIDEN

Example of Filters: Filter Description This filter specifies if a student is a registered, withdrawn, Course Cancelled etc.

Criteria [Advisor Student List].[Student Course].[REGISTRATION_STATUS] like (‘R%’) or [Advisor Student List].[Student Course].[REGISTRATION_STATUS] like(‘W%’)

Type of GPA displayed. Valid values are Institution (courses completed at this institution), Transfer (courses completed at another institution and transferred for credit), or Overall (all courses completed).

[Advisor Student List].[GPA By Term].[GPA_TYPE] in (‘O’,’I’,’T’)

Indicates whether the person has graduated or earned any academic outcomes to date

[Advisor Student List].[Academic Outcome].[GRADUATED_IND] = ‘Y’

Indicates whether the student has matriculated, and [Advisor Student List].[Academic was formally admitted to a degree granting Study].[MATRICULATED_IND] = ‘Y’ academic study or program

OIT- Information Management & Reporting | ODS Package Description Document

7

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

8

Course Catalog Package Information Include: Course catalog, course related information: attribute, corequisite, prerequisite, level, schedule, attribute, and offering. ODS View Link: http://raptor.gpc.edu:9050/metadata/bcreps/CourseCatalog.html

Banner Tables:

SCBCRSE SSBOVRR

SCBSUPP SSBSECT

SATURN SCRLEVL SCRSCHD SSRSYLN

SCRRTST

SHRTCKN

Example of Filters: Filter Description Current identification number of the primary instructor.

Criteria [Course Catalog].[Schedule Offering].[PRIMARY_INSTRUCTOR_ID] =’Y’

Course number associated with the subject for the course.

[Course Catalog].[Course Catalog].[COURSE_NUMBER] = ‘1111’ [Course Catalog].[Course Catalog].[SUBJECT] = ‘HIST’

Instructional Subject Code for History

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

9

Enrollment Management Package

Information Includes: Enrollment, academic outcome, admissions application, constituent, person address and detail, recruitment information, student, student extended, and current telephone. ODS View Link: http://raptor.gpc.edu:9050/metadata/bcreps/EnrollmentManagement.html

Banner Tables: SARADAP SPBPERS STVESTS

SFBETRM SPRADDR STVSTST

SATURN SGBSTDN SGRVETN SPRIDEN SRBRECR

SORLCUR STVCITZ

SORLFOS STVCOLL

GENERAL GOREMAL Example of Filters: Filter Description To find students who are under review for their application status, use the criteria provided. Will provide the students who accounts for GPC enrollment headcount due to they’re at least 1 credit. GPC does not count students with less than 1 credit hour in the enrollment headcount. Indicates if the admissions application is complete and ready for review. Indicates whether the application is incomplete. Most current status of the application, whether the status is determined by institution or student. Example a status of ‘D’ indicate a decision has been made or ‘W’ which means the student’s application has been withdrawn. Student level associated with the coursework in the academic outcome. Examples, include ‘US’ which indicate undergraduate

Criteria [Enrollment Management].[Admissions Application].[APPLICATION_STATUS] = 'C' [Enrollment Management].[Enrollment].[TOTAL_CREDITS] >=1 [Enrollment Management].[Admissions Application].[COMPLETE_IND] = ‘Y’ [Enrollment Management].[Admissions Application].[INCOMPLETE_IND]= ‘Y’ [Enrollment Management].[Admissions Application].[APPLICATION_STATUS] = ‘D’ or [Enrollment Management].[Admissions Application].[APPLICATION_STATUS] =’W’ [Enrollment Management].[Admissions Application].[STUDENT_LEVEL] = ‘US’

OIT- Information Management & Reporting | ODS Package Description Document

10

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

11

Faculty Assignment Package

Information Includes: Faculty, employee position, faculty attribute, faculty department college, instructional assignment, labor cost distribution, meeting time, non-instructional assignment, person address and detail, schedule offering, and current telephone. ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/FacultyAssignment.html

Banner Tables: SCBCRSE SIRNIST SSRSYLN

SIBFACD SPRADDR

SATURN SIBINST SIRASGN SPRIDEN SSBOVRR

SIRATTR SSBSECT

SIRDPCL SSRMEET

GENERAL GOREMAL PUBLIC NBRJOBS Examples of Filter: Filter Description To verify that you have the primary instructor (current instructor) for each course in Cognos. (This is referencing the Primary Instructor field previously used in the view: BANINST1_AS_CATALOG_SCHEDULE_GPC)

To find email address assigned to all full and part time GPC faculty or staff members upon hiring use this criteria, and bring include field EMAIL_PREFERRED_ADDRESS

Criteria [Faculty Assignment].[Instructional Assignment].[PRIMARY_IND] = ‘Y’

[Faculty Assignment].[Person Detail].[EMAIL_PREFERRED] ='GPC'

OIT- Information Management & Reporting | ODS Package Description Document

12

Sample Report: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

13

Government Reporting Package

Information Includes: student, academic outcome, course, financial aid, financial aid fund, admissions; and person detail. ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/GovernmentReporting.html Banner Tables: SABSUPL SGRSPRT SORLCUR SSBSECT

SARADAP SCBCRSE SHRDGMR SHRLGPA SORLFOS SORTEST SSRMEET

RFRBASE

ROBINST

GOREMAL

GORVISA

SATURN SFBETRM SFRSTCR SIRASGN SORDEGR SPBPERS SPRADDR

SGBSTDN SORHSCH SPRIDEN

FAISMGR RPRATRM RPRAWD GENERAL

Example of Filters: Filter Description To verify that you have the primary instructor (current instructor) for each course in Cognos. (This is referencing the Primary Instructor field previously used in the view: BANINST1_AS_CATALOG_SCHEDULE_GPC)

If you want all enrolled (registered and withdrawn) students, add this filter.

If you want all registered students only, add this filter. When retrieving all enrolled or registered students it is necessary to pull credit hours greater than or equal to 1. If you need enrolled student’s current address, add this filter.

Criteria [Faculty Assignment].[Instructional Assignment].[PRIMARY_IND] = ‘Y’ ([Government Reporting].[Government Course].[REGISTRATION_STATUS] Like ('R%')) Or ([Government Reporting].[Government Course].[REGISTRATION_STATUS] Like ('W%')) [Government Reporting].[Government Course].[REGISTRATION_STATUS] in (‘RE’, ‘RW’) [Student Detail].[Student Course].[COURSE_CREDITS] >=1 [Government Reporting].[Person Address].[ADDRESS_RULE] = ‘ENRLADDR’

OIT- Information Management & Reporting | ODS Package Description Document

14

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

15

Person Demographic Package Information Includes: Person detail, address, geographic region, person sensitive, preferred address, relationship, salutation, and telephone. ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/PersonDemographic.html

Banner Tables:

SPBPERS

SPRADDR

GOBINTL

GOREMAL

AOBORGN APVXREF

APRCHLD MGRSDAX

SATURN SPRMEDI GENERAL GORPGEO GORVISA UNKNOWN APRCSPS APRSALU SPRIDEN

SPRTELE

APRXREF

APVCSPS

Examples of filters: Filter To query specific email address, use [EMAIL_PREFERRED] code If using Person Address, you need to indicate address rule name.

Criteria [PERSON DEMOGRAHIC].[PERSON DETAIL].[EMAIL PREFERRED] = ‘STUD’ [PERSON DEMOGRAPHIC].[PERSON ADDRESS].[ADDRESS_RULE]='PERMADDR'

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

16

Person Supplemental Package

Information Includes: Person detail, activity, certification, combined academic outcome, communication, contact, current employment, employment history, hold, interest, mail, medical information, international, veteran, previous degree and education, skill, test, and Visa. ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/PersonSupplemental.html Banner Tables: SHRTRAM SORINTS GOBINTL

SHRTRIT SORLCUR

SMRPRLE SORLFOS

SATURN SORCONT

SORDEGR

SORHSCH

GOREMAL

GENERAL GORVISA GTVEMAL

GTVLETR

GURMAIL

Example of Filters: Filter Description To only return one line per student, use the primary program indicator filter. If using Person Address, you need to indicate address rule name. GPA Overall – in most cases If you want to filter on a campus – use A for Alpharetta, C for Clarkston etc.

Criteria [Student Detail].[Academic Study].[PRIMARY_PROGRAM_IND] = 'Y' [Student Detail].[Person Address].[ADDRESS_RULE]='PERMADDR' [Student Detail].[GPA By Level].[GPA_TYPE] = 'O' [Student Detail].[Student Course].[CAMPUS] in (‘A’, ‘C’)

OIT- Information Management & Reporting | ODS Package Description Document

17

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

18

Recruitment Information Package Information Includes: Recruitment information, admissions, application, contact, geographic region, institution, institution characteristic and demographic, interest, person address and detail, pre-student, previous degree and education, secondary school subject, current, telephone, test, current Visa, and recruitment, related information: attribute, cohort, learned, and source, this package also includes Person Supplemental package. ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/RecruitmentInformation.html Banner Tables:

SABAUDF SOBSBGI SORCONT SORLFOS SPRIDEN

SABSUPL SORAPPT SORDEGR SORMAJR SPRMEDI

GOBINTL

GOREMAL

SARADAP SORBACD SORHSBJ SORPCOL SRBRECR

SATURN SARRSRC SORBCHR SORHSCH SORTEST SRRCHRT GENERAL

SHRTRAM SORBCNT SORINTS SPBPERS SRRRATT

SHRTRIT SORBDMO SORLCUR SPRADDR SRRRSRC

PUBLIC GORSGEO

GORVISA

Example of Filters: Filter To determine which address displays for a person or entity, indicate address rule name. Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.

Incoming freshmen accepted need to use all 2 filters.

Type of mail address recorded as preferred. Test score code associated with various tests, i.e., SAT, ACT, placement scores.

Criteria [Recruitment Information].[Person Address].[ADDRESS_RULE] ='ENRLADDR' [Recruitment Information].[Admissions Application].[STUDENT_LEVEL] = ‘US’ [Recruitment Information].[Admissions Application].[ADMISSIONS_POPULATION] in ( ‘N1’ , ‘P1’ , ‘I1’ , ‘N7’ , ‘P7’ , ‘I7’ , ‘N3’ , ‘P3’ , ‘I3’) [Recruitment Information].[Admissions Application].[STUDENT_POPULATION] = ‘F’ [Recruitment Information].[Person Detail].[EMAIL_PREFERRED] = ‘STUD’ [Recruitment Information].[Test].[TEST]= ‘A01’

OIT- Information Management & Reporting | ODS Package Description Document

19

Sample Report: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

20

Residential Life Package

Information Includes: Person detail, address, meal assignment, phone assignment, room assignment, academic study, and student. ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/ResidentialLife.html

Banner Tables:

SFBETRM SLRBCAT SPRADDR

SGBSTDN SLRMASG SPRIDEN

GOBINTL

GOREMAL

SATURN SHRTTRM SLBBLDG SLRRASG SORLCUR SPRMEDI GENERAL

SLBRDEF SORLFOS

SLBRMAP SPBPERS

Example of Filters: Filter To determine which address displays for a person or entity, indicate address rule name.

Criteria [Residential Life].[Address By Rule].[ADDRESS_RULE]= 'ENRLADDR'

To display type of address such as mailing, billing, temporary, and permanent for an address record, indicate address type.

[Residential Life].[Address By Rule].[ADDRESS_TYPE] = ‘MA’

Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.

[Residential Life].[Academic Study].[ STUDENT_LEVEL] = ‘US’

Student's primary curriculum for the academic period will be flagged with the PRIMARY_PROGRAM_IND set to Y.

[Residential Life].[Academic Study].[PRIMARY_PROGRAM_IND] = ‘Y’

OIT- Information Management & Reporting | ODS Package Description Document

21

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

22

Schedule Offering Package

Information Includes: Schedule offering, faculty, instructional assignment, meeting time, offering corequisite, offering grade type, offering prerequisite, schedule attribute, and course related information: attribute, catalog, corequisite, level, offering fees, prerequisite, prerequisite combined, and schedule. ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/ScheduleOffering.html

Banner Tables: SCBCRSE SCRRTST SIRICNT

SCBDESC SCRSCHD SPRIDEN

SATURN SCBSUPP SCRATTR SIBFACD SIBINST SSBOVRR SSBSECT

SCRCORQ SIRASGN SSRMEET

SCRLEVL SIRDPCL

Example of Filters: Filter Description Important to filter on Academic Period.

Criteria [Schedule Offering].[Schedule Offering].[Academic Period] = 201108

Important to filter on Campus. Use ‘A’ for sections offered on the Alpharetta campus. Also include ‘C’ if you want session offered on Clarkston campus.

[Schedule Offering].[Schedule Offering].[CAMPUS] = ‘A’ or [Schedule Offering].[Schedule Offering].[CAMPUS] = ‘C’

To filter on all sections for a particular subject area. For example, all Math sections (‘MATH’) or all Chemistry sections (‘CHEM’)

[Schedule Offering].[Schedule Offering].[SUBJECT] = ‘MATH’ or [Schedule Offering].[Schedule Offering].[SUBJECT] = ‘CHEM’

To filter on all Subject Code with Course Number 1111, bring in both Subject Code and Course Number fields.

[Schedule Offering].[Schedule Offering].[COURSE_NUMBER] = '1111'

To filter on only sections with enrollment. To filter on all courses that have Lab session, use like ‘% L’

[Schedule Offering].[Schedule Offering].[ACTUAL_ENROLLMENT] > 0 [Schedule Offering].[Schedule Offering].[COURSE_NUMBER] like ‘% L’

OIT- Information Management & Reporting | ODS Package Description Document

23

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

24

Student Detail Package

Information Includes: Student, academic outcome, academic study and extended, advisor, enrollment, financial aid enrollment, government course and student, GPA by level, GPA by term, hold, outcome departmental honor, outcome honor, outcome institutional honor, person address and detail, previous degree, previous education attendance, sport, current telephone, transcript comment, and student related information: activity, attribute, cohort, course, course attribute, and course grade change. ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/StudentDetail.html

Banner Tables: SCBCRSE SGRADVR SHRATTC SHRLGPA SHRTRCE SMRPRLE SPRHOLD

SCBSUPP SGRCHRT SHRATTR SHRTATC SHRTRCR SORLCUR SPRMEDI

MGRSDAX

RORENRL

GOBINTL

GOREMAL

SFBETRM SGRSACT SHRDGIH SHRTATT SHRTRIT SORLFOS SSRMEET

SATURN SFRAREG SGRSATT SHRDGDH SHRTCKG SHRTTRM SPBPERS SSRSYLN FAISMGR

SFRSTCR SGRSPRT SHRDGMR SHRTCKN SIBINST SPRADDR

SGBSTDN SGRVETN SHRGRDE SHRTGPA SIRASGN SPRIDEN

GENERAL GORVISA

Example of Reports: Filter Description To only return one line per student, use the primary program indicator filter. If using Person Address, you need to indicate address rule name. GPA Overall – in most cases If you want to filter on a campus – use A for Alpharetta, C for Clarkston etc.

Criteria [Student Detail].[Academic Study].[PRIMARY_PROGRAM_IND] = 'Y' [Student Detail].[Person Address].[ADDRESS_RULE]='PERMADDR' [Student Detail].[GPA By Level].[GPA_TYPE] = 'O' [Student Detail].[Student Course].[CAMPUS] in (‘A’, ‘C’)

OIT- Information Management & Reporting | ODS Package Description Document

25

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

26

FINANCIAL AID MODULE Financial Aid Application Package

Information Includes: Financial Aid applicant status, admissions application, applicant need, award by person, loan application, need analysis, person detail, previous degree, previous education attendance, satisfactory academic progress, user defined fields, and the following financial aid related information: budget component, comments, holds, and tracking requirements. ODS View Link: http://raptor.gpc.edu:9050/metadata/bcreps/FinancialAidApplication.html

Banner Tables: FAISMGR ROBINST RPRATRM

ROIAIDY RPRAWRD

RORHOLD RRRAREQ

SATURN SARRSRC

SGRADVR

SMRPRLE

RCRAPP RORSAPR RRRTMSG

RCRIMP RORSTAT

RFRBASE RORSTAT

SABAUDF SORLCUR

SABSUPL SPRIDEN

SARADAP

Example of Filters: Filter Description This determines the type of financial aid the student is receiving. For example if it is Grants, Loans, Work Study etc.

Criteria [Financial Aid Application].[Award By Person].[FUND_TYPE] in (‘GRNT’,’LOAN’)

Indicates whether the student has been Offered, Accepted, Declined etc. financial aid

[Financial Aid Application].[Award By Person].[AWARD_STATUS] in (‘ACPT’,’DECL’,’OFRD’)

Indicates whether the person accepted this financial aid award.

[Financial Aid Application].[Award By Person].[AWARD_ACCEPT_IND] =’Y’

Defines whether a tracking code is required and must be satisfied for disbursement. Indicates hold to prevent disbursement of applicant's aid.

[Financial Aid Application].[Finaid Tracking Requirement].[DISBURSEMENT_REQ_IND] = ‘Y’ [Financial Aid Application].[Finaid Hold].[HOLD_DISBURSEMENT_IND] = ‘Y’

OIT- Information Management & Reporting | ODS Package Description Document

27

Sample Report: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

28

Financial Aid Award and Disbursement Information Includes: Awards by person, awards by aid year, awards by fund, award disbursement, academic study, designation Financial Aid fund, enrollment, general ledger, GPA by term, person detail, receivable account detail, student, transaction history, and the following financial aid related information: applicant status, enrollment, fund, hold, and government. ODS View Link: http://raptor.gpc.edu:9050/metadata/bcreps/FinancialAidAwardandDisbursement.html

Banner Tables: RFRASPC RPRATRM

RFRBASE RPRAWRD

ROBINST

SFBETRM SPBPERS

SGBSTDN SPRADDR

SGRCHRT SPRIDEN

FAISMGR RORENRL

RORSTAT

RPRADSB

SATURN SGRSPRT

SHRTTRM

SHRTGPA

TAISMGR TBBDETC

TBRACCD

GTVCURR

GXVBANK

TBRDEPO GENERAL

Example of Filters: Filter Description Specifies whether verification is required.

Criteria [Financial Aid Award and Disbursement].[Finaid Applicant Status].[VERIFICATION_REQUIRED_IND] = ‘Y’

Indicates if the data associated with this person qualifies as a financial aid applicant for the associated aid year.

[Financial Aid Award and Disbursement].[Finaid Applicant Status].[FINAID_APPLICANT_IND] =’Y’

Indicates whether the student has been admitted to the institution for the academic period and student level in this record. Indicates that the student counts in the headcount, has current academic period credits registered greater than 0, and has been admitted to an academic outcome that grants a degree or award.

[Financial Aid Award and Disbursement].[Student].[ADMIT_IND] =’Y’

[Financial Aid Award and Disbursement].[Student].[ACADEMIC_OUTCOME_ENRO LLED_IND]= ‘Y’

OIT- Information Management & Reporting | ODS Package Description Document

29

Indicates whether the student is considered a continuing education student. Taking courses to earn continuing education units instead of credits. Indicates whether the student is receiving any financial aid for the award year of the associated term.

[Financial Aid Award and Disbursement].[Student].[CONTINUING_EDUCATION_I ND] = ‘Y’ [Financial Aid Award and Disbursement].[Student].[FIN_AID_APPLICANT_IND] = ‘Y’

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

30

Financial Aid Fund Package Information Includes: Awards by fund, awards by aid year, Financial Aid fund and Government Financial Aid Fund.

ODS View Link: http://raptor.gpc.edu:9050/metadata/bcreps/FinancialAidFund.html

Banner Tables:

RFRASPC RPRATRM

RFRBASE RPRAWRD

FAISMGR ROBINST RORENRL

RORSTAT

RPRADSB

SATURN SHRTGPA Example of Filters: Filter Description Packaging rule that indicates if this fund should only be used to reduce need, in the calculation of unmet need. It is mutually exclusive from the Replace EFC indicator. Indicates whether the person has been offered financial aid award. Indicates whether the person accepted this financial aid award. Indicates whether this financial aid award was declined. Specifies whether the award was system or manually generated. Determines whether Fund Type is General, Grant, loan or Work Study.

Criteria [Financial Aid Fund].[Finaid Fund].[NEED_BASED_IND] = ‘Y’ [Financial Aid Fund].[Award By Person].[AWARD_OFFER_IND] = ‘Y’ [Financial Aid Fund].[Award By Person].[AWARD_ACCEPT_IND]=’Y’ [Financial Aid Fund].[Award By Person].[AWARD_DECLINE_IND]= ‘Y’ [Financial Aid Fund].[Award By Aid Year].[SYSTEM_IND] = ‘Y’ [Financial Aid Fund].[Finaid Fund].[FUND_TYPE] in (‘GENL’, ‘GRNT’, ‘LOAN’, ‘WORK’)

OIT- Information Management & Reporting | ODS Package Description Document

31

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

32

ACCOUNT RECIEVABLE MODULE Receivable Customer Package Information Includes: Receivable account, contract third party, deposit, enrollment, exemption, hold, installment plan, miscellaneous transaction, organization entity and address, person address and detail, receivable account detail, and current telephone. ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/ReceivableCustomer.html Banner Links: TBBCONT TBBMISC TTVDCAT

TBBCPRF TBRACCD TTVDELI

TBBCSHR TBRACCT TTVDTYP

SPBPERS STVDISA STVMRTL

SPRADDR STVEMPT STVNATN

SPRHOLD STVETHN STVRELG

GOBINTL

GORMAL

GTVCELG

TAISMGR TBBCSTU TBBDETC TBRCOLC TBRDEPO TTVSRCE SATURN SPRIDEN SPRMEDI STVHLDD STVLANG STVSPON STVSPSR GENERAL GTVEMAL GTVNTYP

TBBESTU TBRISTL

TBBEXPT TBRMISD

SPRTELE STVLGCY STVSTAT

STVATYP STVMDEQ STVTERM

Example of Filters: Filter Description To identify the category for a receivable transaction types use the following example criteria. Some Examples are: Cash (‘CSH’) Deposit(‘DEP’), Testing Fees (‘TST’), Refund (‘RFD’) To find the type of hold associated with a student record use the following example criteria. Some Examples are: Project Degree (‘PD’), 48 Hour Advisement Hold (‘48’), Admissions & Records (‘DA’), Immunization (‘IM’)

Criteria [Receivable Customer].[Receivable Account Detail].[CATEGORY] = 'CSH'

[Receivable Customer].[Hold].[HOLD] in ('PD', '48', 'DA', 'IM', 'DH', 'RG', 'SP')

Indicates if this hold restriction prohibits graduation. Yes (Y’) or No (‘N’)

[Receivable Customer].[Hold].[GRADUATION_HOLD_IND] = ‘Y’

Indicates whether the hold is active or not. Yes (Y’) or No (‘N’).

ACTIVE_HOLD_IND = ‘N’

OIT- Information Management & Reporting | ODS Package Description Document

33

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

34

Receivable Revenue Package Information Includes: Receivable account detail, application of payment and detail accounting, award disbursement, contract, contract third party, deposit, exemption, general ledger, hold, installment plan, miscellaneous transaction, organization entity and address, person address and detail, receivable account, receivable accounting, receivable summary, current telephone, and transaction history. ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/ReceivableRevenue.html Banner Links: TBBCONT TBBEXPT TBRISTL

TBBCPRF TBBMISC TBRMISD

TBBCSHR TBRACCD TTVDCAT

SPBPERS STVDISA STVMRTL

SPRADDR STVEMPT STVNATN

SPRHOLD STVETHN STVRELG

GOBINTL

GORMAL

GTVCELG

RPRADSB

RTVRJCT

FGBGENL FTVFSPD

FGBTRND FTVFTYP

FGBTRNH FTVFUND

TAISMGR TBBCSTU TBBDETC TBRACCT TBRAPPL TTVDELI TTVDTYP SATURN SPRIDEN SPRMEDI STVHLDD STVLANG STVSPON STVSPSR GENERAL GTVCURR GTVEMAL FAISMGR FINANCE FTVACCT FTVACTV FTVLOCN FTVORGN

TBBEACT TBRCOLC TTVSRCE

TBBESTU TBRDEPO

SPRTELE STVLGCY STVSTAT

STVATYP STVMDEQ STVTERM

GTVNTYP

GXV BANK

FTVATYP FTVPROG

FTVDTYP FTVRUCL

Example of Filters: Filter Description To find the Transaction academic period code use this criteria To find transaction type: In State Tuition Student uses the following criteria. To find transaction type: Out-Of State Tuition Student use the following criteria To find transaction type: Non-Resident, Tuition Waived, the format for the parameter is 12(letter corresponding to the waiver type) % please see criteria example. To find transaction type: Senior Citizen Waiver use this criteria.

Criteria [Receivable Revenue].[Receivable Summary].[ACADEMIC_PERIOD] = '201108' [Receivable Revenue].[Receivable Summary].[DETAIL_CODE] Like '11%' and[Receivable Revenue].[Receivable Summary].[DETAIL_CODE] Not like '11T%' [Receivable Revenue].[Receivable Summary].[DETAIL_CODE] Like ‘120%’ [Receivable Revenue].[Receivable Summary].[DETAIL_CODE] Like ‘12B%’ Or Like ‘12C%’ Or Like ‘12D%’ Or Like ‘12E%’ [Receivable Revenue].[Receivable Summary].[DETAIL_CODE] = 'WISC'

OIT- Information Management & Reporting | ODS Package Description Document

35

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

36

COMMON MODULE Event Entity Package

Information Include: Event, event invitee, organization entity, person detail, and organization entity address. ODS View Link: http://raptor.gpc.edu:9050/metadata/bcreps/Event.html

Banner Tables: SLBEVNT SSRMEET

SPBPERS

GEBFUNC

GOBINTL

SATURN SPRADDR SPRIDEN

SPRMEDI

SPRTELE

GENERAL GOREMAL

Examples of Filters: Filter Description Type for the event. This might include meeting, conferences, field trips, advancement event, etc. Status code associated with the function. This determines if the function is Active. Gender Code associated with person attending event

Criteria [Event].[Event].[EVENT_TYPE] in (‘CLAS’, ‘MEET’,’RUSE’) [Event].[Event].[FUNCTION_STATUS]= 'A' [Event].[Person Detail].[GENDER] in (‘F’,’M’)

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

37

Institution Package

Information Includes: Institution, degree, person detail, previous education, previous education attendance, secondary school subject and the following institution related information: geographic region, characteristic, degree, demographic, and subject.

ODS View Link: http://raptor.gpc.edu:9050/metadata/bcreps/Institution.html Banner Tables: SHRTRAM SORBDMO GENERAL GOBINTL

SHRTRIT SORDEGR

SATURN SOBSBGI SORBACD SORHSCH SORPCOL

GOREMAL

GORSGEO

SORBCHR SPBPERS

SORBCHR SPRIDEN

Example of Filters: Filter Description Identifies a type for the source/background institution to be High School or College for reporting.

Criteria [Institution].[Institution].[INSTITUTION_TYPE] in (‘H’, ‘C’)

Indicates whether the transcript was an official transcript. Person's secondary institution diploma type. For example, college preparatory, vocational, general, etc. Indicates whether the person has been identified as a citizen of the institution's home country.

[Institution].[Previous Education Attendance].[OFFICIAL_TRANSCRIPT_IND] = ‘Y’ [Institution].[Previous Education Attendance].[SECONDARY_DIPLOMA] = ‘CP’ [Institution].[Person Detail].[CITIZENSHIP_IND]=’Y’

Sample Report: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

38

Organization Entity Packages

Information Includes: Organization entity, address current, contract, current employment, employment history, geographic region, organization entity address, organizational constituent, receivable account, and vendor. ODS View Link: http://raptor.gpc.edu:9050/metadata/bcreps/OrganizationEntity.html

Banner Tables: SPBPERS

SPRADDR

GOREMAL

GORPGEO

TBBACCT TBRCOLC

TBBCONT

AGBGIFT

AOBORGN

SATURN SPRIDEN SPRTELE GENERAL TAISMGR TBBCPRF TBBCSTU

TBBDETC

TBRACCD

ADVANCEMENT APREHIS PAYROLL

PPREXPE Example of Filters: Filter Description Indicates whether this is a person or an organization entity. This criteria specifies the Entity type.

Criteria [ACCOUNT_ENTITY_IND] in ('C',’P’) [Organization Entity].[Internet Address Current].[INTERNET_ADDRESS_TYPE] in (‘STUD’, ‘HOME’)

OIT- Information Management & Reporting | ODS Package Description Document

39

Sample Report: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

40

Person Demographic Package Information Includes: Person detail, address, geographic region, person sensitive, preferred address, relationship, salutation, and telephone. ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/PersonDemographic.html

Banner Tables:

SPBPERS

SPRADDR

GOBINTL

GOREMAL

AOBORGN APVXREF

APRCHLD

SATURN SPRMEDI GENERAL GORPGEO GORVISA ADVANCEMENT APRCSPS APRSALU SPRIDEN

SPRTELE

APRXREF

APVCSPS

Examples of filters: Filter Description To query specific email address, use [EMAIL_PREFERRED] code. For example: GPC email or personal email…. If using Person Address, you need to indicate address rule name. In this example, we use permanent address. To query American Indian or Alaska Native race, use [RACE] code. A person may have more than 1 race, and each row for each race. To query citizenship status, using [CITIZENSHIP_TYPE] code. For example U.S. Citizen: Born/Naturalized or Alien, Nonresident

Criteria [PERSON DEMOGRAHIC].[PERSON DETAIL].[EMAIL PREFERRED] = ‘STUD’ [PERSON DEMOGRAPHIC].[PERSON ADDRESS].[ADDRESS_RULE]='PERMADDR' [Person Demographic].[Person Sensitive Race].[RACE] = 'I' [Person Demographic].[Person].[CITIZENSHIP_TYPE] in ‘C or A’

OIT- Information Management & Reporting | ODS Package Description Document

41

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

42

Person Role Package Information Includes: Person detail, administrator, admissions application, advisor, constituent, employee, faculty, Financial Aid applicant status, Human Resource application, organization chart, pre-student, prospect, receivable account, recruitment, student, and vendor.

ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/PersonRole.html

Banner Tables:

SABAUDF SHRTTRM SMRPRLE SORLFOS SPRTELE

SABSUPL SIBFACD SORAINF SORMAJR SRBRECR

SATURN SARRSRC SIRASGN SORDEGR SPRADDR

SARADAP SIBINST SORCONT SORPCOL SRRLEND

SGBSTDN SIRDPCL SORHSCH SPRIDEN

SGRADVR SIRICNT SORLCUR SPRMEDI

GENERAL GOBINTL

GOREMAL

GURIDEN

TBBACCT

TBBCPRF

TAISMGR TBRACCD TBRCOLC FAISMGR

ROBINST

RORSTAT

AGBGIFT

AGBPLDG

NBBPOSN

NBRJOBS

PABAPPL PTVORGN

PABREQU

ADVANCEMENT AMRINFO AMRSTAF AORCONT POSITION CONTROL NTRPCLS PAYROLL PEBEMPL PERBFAC PTRBCAT

APBCONS

PTRECLS

Examples of filters: Filter Description To query admission campus, use [CAMPUS] code. ‘C’ for Clarkston, ‘A’ for Alpharetta… To query GPC email, use [EMAIL_PREFERRED] code To query major when students first apply, use code [MAJOR]

Criteria [Person Role].[Admissions Application].[CAMPUS] = ‘C’ [Person Role].[Person Detail].[EMAIL_PREFERRED] = 'STUD' [Person Role].[Admissions Application].[MAJOR] = 'ENGR'

OIT- Information Management & Reporting | ODS Package Description Document

43

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

44

Person Supplemental Package

Information Includes: Person detail, activity, certification, combined academic outcome, communication, contact, current employment, employment history, hold, interest, mail, medical information, international, veteran, previous degree and education, skill, test, and Visa. ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/PersonSupplemental.html

Banner Tables: SHRTRAM SORINTS SPRADDR

SHRTRIT SORLCUR SPRHOLD

SMRPRLE SORLFOS SPRIDEN

GOBINTL

GOREMAL

GORVISA

SGRDISA

SHBDIPL

SORAPPT

SATURN SORCONT SORPCOL SRBRECR GENERAL GTVEMAL STUDENT SORMAJR PUBLIC

SORDEGR SORTEST

SORHSCH SPBPERS

GTVLETR

GURMAIL

SPRMEDI

SGRSPRT AOBORGN APRMAIL

APRACLD ATVIGRP

PPRCERT

PPREXPE

ADVANCEMENT APRACTY APRADEG

APREHIS

APRIGRP

PAYROLL PPRSKIL

Example of Filters: Filter Description Type of outside interest associated with the prospect. Code for the type of hold associated with this record. Source/ background institution code for the high school or prior college.

Criteria [Person Supplemental].[Interest].[INTEREST]=’X6’ [Person Supplemental].[Hold].[HOLD]='CE' [Person Supplemental].[Previous Education].[INSTITUTION]='000003'

OIT- Information Management & Reporting | ODS Package Description Document

45

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

46

Relationship Package

Information Includes: Relationship, first and related party information for constituent, constituent entity, organization address, organizational constituent, organization, person address, person, and current telephone .

ODS Package Link: http://raptor.gpc.edu:9050/metadata/bcreps/Relationship.html

Banner Tables: SPBPERS

SPRADDR

GOBINTL

GOREMAL

AGBGIFT APRCSPS

AGBPLDG APRXREF

SPRIDEN

SATURN SPRTELE GENERAL

ADVANCEMENT AOBORGN APBCONS APVCSPS APVXREF

APRCATG ATVXREF

APRCHLD

Examples of Filters: Filter Description Gender of the person. Telephone type code associated with the organization's preferred telephone number.

Criteria [Relationship].[Person Related Party].[GENDER]= 'F' [Relationship].[Telephone Current First Party].[PHONE_TYPE] = 'EM'

Sample Reports: Report Name

Description

OIT- Information Management & Reporting | ODS Package Description Document

Report Path

47

ODS DECISION TREE DIAGRAM Cohort Diagram

OIT- Information Management & Reporting | ODS Package Description Document

48

Financial Aid Cohort Diagram

OIT- Information Management & Reporting | ODS Package Description Document

49

Student Cohort Diagram

OIT- Information Management & Reporting | ODS Package Description Document

50

Course Cohort Diagram

OIT- Information Management & Reporting | ODS Package Description Document

51

Admission Cohort Diagram

OIT- Information Management & Reporting | ODS Package Description Document

52