Delivered EUL Content for the Campus Solutions Warehouse
This chapter discusses the delivered Discoverer content for the Campus Solutions Warehouse.
Delivered EUL Content for the Campus Solutions Warehouse
The Discoverer End User Layer (EUL) is the backbone of your PeopleSoft business intelligence reporting solution. PeopleSoft has developed the Discoverer EUL to provide a business-focused view of your database. The PeopleSoft delivered Discoverer EUL content serves as the building blocks for the Campus Solutions Warehouse Discoverer reports.
Discoverer reports are organized by business area. Business areas are made up of folders that contain information with a common business purpose. Each business area is represented by a fact table (star schema). PeopleSoft business areas are grouped by subject area. This chapter discusses the delivered content, listed by subject area.
PeopleSoft assumes that you are familiar with Discoverer and understand how to use this business intelligence reporting tool.
The Campus Solutions Warehouse Discoverer content includes the following subject areas:
Admissions and Recruiting
Student Records
Student Financial Services
See Oracle's Business Intelligence Discoverer Administrator's Guide
See Understanding End User Layer Business Area Terms.
See Also
Performance Management Warehouse CSW Dimensions
Performance Management Warehouse CSW Facts
Performance Management Warehouse Shared Dimensions
Campus Solutions Warehouse Admissions and Recruiting Discoverer Business Areas
This section describes the content for the Admissions and Recruiting business areas in the Campus Solutions Warehouse. This section discusses these business areas:
Recruiting
Admission Application
Admission Application Status
External Academic Summary
External Test Scores
Prospects to Applicants to Enrollees
Admissions and Recruiting − Recruiting Business Area
The Recruiting business area contains information on prospective students and the associated academic institutions, academic careers, academic programs, plans, and subplans. It also contains data on the recruiting categories, regions, and the recruiters to which the prospective students are assigned. With this fact group, you can answer questions such as how many prospects are there for a particular academic program?
This section describes the content for Recruiting business area.
Dimension Folders
This table lists the dimension folders in the Recruiting business area:
|
Folder |
Description |
Table |
|
Dimension Academic Career |
This dimension represents all academic careers that an institution offers. |
PS_D_ACAD_CAR |
|
Dimension Academic Level |
This dimension represents the academic level associated with a Student. for e.g. First Year, Second Year, Freshman, Sophomore etc. |
PS_D_ACAD_LVL |
|
Dimension Academic Load |
This dimension represents the academic loads offered, for e.g. Full Time, Part Time etc. |
PS_D_ACAD_LOAD |
|
Dimension Academic Plan |
This dimension represents all the academic plans within an academic program of an institution. |
PS_D_ACAD_PLAN |
|
Dimension Academic Program |
This dimension represents all the academic programs of an institution. |
PS_D_ACAD_PROG |
|
Dimension Academic Subplan |
This dimension represents all the academic sub plans with an academic plan of an institution. |
PS_D_ACAD_SPLAN |
|
Dimension Admit Type |
The admit type dimension. It defines the admit types that are assigned to prospects and applications to clarify the type of prospect or applicant, such as first year, readmit, or transfer. |
PS_D_ADMIT_TYPE |
|
Dimension Campus |
This dimension represents all the campuses for an Institution. |
PS_D_CAMPUS |
|
Dimension Day Last School Graduation Date |
This is a role playing dimension based on Dimension Day for last school graduation date. |
PS_D_DAY |
|
Dimension Day Recruiting Status Date |
This is a role playing dimension based on Dimension Day for recruiting status date. |
PS_D_DAY |
|
Dimension Day Referral Source Date |
This is a role playing dimension based on Dimension Day for referral source date. |
PS_D_DAY |
|
Dimension External Organization Last School Attended |
This is a role playing dimension based on Dimension External Organization for last school attended. |
PS_D_EXT_ORG |
|
Dimension Institution |
This dimension represents all the academic institutions. |
PS_D_INSTITUTION |
|
Dimension Person |
This dimension represents the most current personal information of both employees and non-employees of an organization. |
PS_D_PERSON |
|
Dimension Person Attribute |
This dimension represents all the additional attributes of a person which are specific to the student role. |
PS_D_PERSON_ATTR |
|
Dimension Person Recruiter |
This is a role playing dimension based on Dimension Person for recruiter. |
PS_D_PERSON |
|
Dimension Recruiting Center |
The recruiting center dimension. The recruiting center helps to identify the prospects and recruiters who belong to a particular recruiting office. |
PS_D_RECRT_CNTR |
|
Dimension Recruiting Status |
The recruiting status dimension. It indicates the level of interest, at the academic career level, that the institution has in the prospective student. |
PS_D_RECRT_STAT |
|
Dimension Recruitment Category |
The recruitment category dimension. It defines special categories of prospective students to be targeted for recruiting and admissions purposes. |
PS_D_RECRT_CTGRY |
|
Dimension Referral Source |
The referral source dimension. It tracks how prospects or applicants learned of the institution and indicates why they were originally added to the system. |
PS_D_RFRL_SRC |
|
Dimension Region for Campus Solution |
The region dimension for the Campus Solution. It defines the geographical groupings that the institution uses for recruiting and admissions. A region can be a continent, a country, a state, a portion of a state, a mix of states, and etc. |
PS_D_REGION_CS |
|
Dimension Residency |
The residency dimension. It defines the residency of a prospect or applicant to the institution. |
PS_D_RSDNCY |
|
Dimension Term Admit Term |
This is a role playing dimension represents all the academic admit terms of an institution. |
PS_D_TERM |
|
Relate Person Residency |
The person and residency relationship table. It defines the residency status of a person to the institution. |
PS_R_PERSON_RSDNCY |
Fact Folder
This table lists the fact folder in the Recruiting business area:
|
Folder |
Description |
Table |
|
Fact Student Recruiting |
The student recruiting fact table. This contains data on prospective students and the associated academic institutions, academic careers, academic programs, plans and subplans. |
PS_F_STU_RECRT |
Metrics
This table lists the metrics in the Recruiting business area:
|
Metric |
Description |
Derivation |
|
Applicant Count |
This is the count of the prospective students who have submitted admission applications. |
COUNT_DISTINCT(CASE WHEN Application On File Flag = 'Y' THEN Prospect Sid ELSE NULL END) |
|
Prospect Count |
This is the count of the prospective students. |
COUNT_DISTINCT(Prospect Sid) |
|
Recruiting Row Count |
This is the row count field of the student recruiting fact table. It always has value 1. |
PS_F_STU_RECRT.RECRT_CNT |
Admissions and Recruiting − Admission Application Business Area
The Admission Application business area contains information about an applicant’s application data, such as the associated academic institutions, academic career, academic programs, plans and subplans. With this business area you are able to answer data business questions about the how many applicants or applications have been received. You can also track information about the applicant such as academic level, their academic load, their residency status and how they applied.
This section describes the content for Admission Application business area.
Dimension Folders
This table lists the dimension folders in the Admission Application business area:
|
Folder |
Description |
Table |
|
Dimension Academic Career |
This dimension represents all academic careers that an institution offers. |
PS_D_ACAD_CAR |
|
Dimension Academic Level |
This dimension represents the academic level associated with a Student. for e.g. First Year, Second Year, Freshman, Sophomore etc. |
PS_D_ACAD_LVL |
|
Dimension Academic Load |
This dimension represents the academic loads offered, for e.g. Full Time, Part Time etc. |
PS_D_ACAD_LOAD |
|
Dimension Academic Plan |
This dimension represents all the academic plans within an academic program of an institution. |
PS_D_ACAD_PLAN |
|
Dimension Academic Program |
This dimension represents all the academic programs of an institution. |
PS_D_ACAD_PROG |
|
Dimension Academic Program Dual Academic Program |
This is a role playing dimension based on Dimension Academic Program for dual academic program. |
PS_D_ACAD_PROG |
|
Dimension Academic Subplan |
This dimension represents all the academic sub plans with an academic plan of an institution. |
PS_D_ACAD_SPLAN |
|
Dimension Admit Type |
The admit type dimension. It defines the admit types that are assigned to prospects and applications to clarify the type of prospect or applicant, such as first year, readmit, or transfer. |
PS_D_ADMIT_TYPE |
|
Dimension Application Center |
The application center dimension. The application centers are where admissions applications are processed. Defining application centers enables tracking which office is handling a specific application. |
PS_D_APPL_CNTR |
|
Dimension Application Method |
The application method dimension. Application methods indicate how or in what form an application was received. |
PS_D_APPL_MTHD |
|
Dimension Campus |
This dimension represents all the campuses for an Institution. |
PS_D_CAMPUS |
|
Dimension Day Application Completion Date |
This is a role playing dimension based on Dimension Day for admission application completion date. |
PS_D_DAY |
|
Dimension Day Application Date |
This is a role playing dimension based on Dimension Day for admission application date. |
PS_D_DAY |
|
Dimension Day Last School Graduation Date |
This is a role playing dimension based on Dimension Day for last school graduation date. |
PS_D_DAY |
|
Dimension External Organization Last School Attended |
This is a role playing dimension based on Dimension External Organization for last school attended. |
PS_D_EXT_ORG |
|
Dimension Institution |
This dimension represents all the academic institutions. |
PS_D_INSTITUTION |
|
Dimension Person |
This dimension represents the most current personal information of both employees and non-employees of an organization. |
PS_D_PERSON |
|
Dimension Person Attribute |
This dimension represents all the additional attributes of a person which are specific to the student role. |
PS_D_PERSON_ATTR |
|
Dimension Person Recruiter |
This is a role playing dimension based on Dimension Person for recruiter. |
PS_D_PERSON |
|
Dimension Recruitment Category |
The recruitment category dimension. It defines special categories of prospective students to be targeted for recruiting and admissions purposes. |
PS_D_RECRT_CTGRY |
|
Dimension Region for Campus Solution |
The region dimension for the Campus Solution. It defines the geographical groupings that the institution uses for recruiting and admissions. A region can be a continent, a country, a state, a portion of a state, a mix of states, and etc. |
PS_D_REGION_CS |
|
Dimension Residency |
The residency dimension. It defines the residency of a prospect or applicant to the institution. |
PS_D_RSDNCY |
|
Dimension Term Admit Term |
This is a role playing dimension represents all the academic admit terms of an institution. |
PS_D_TERM |
|
Dimension Term Expected Graduation Term |
This dimension represents all the academic terms of an institution. |
PS_D_TERM |
|
Relate Person Residency |
The person and residency relationship table. It defines the residency status of a person to the institution. |
PS_R_PERSON_RSDNCY |
Fact Folder
This table lists the fact folder in the Admission Application business area:
|
Folder |
Description |
Table |
|
Fact Admission Application |
The student admission application fact table. This contains data on applicants and the associated academic institutions, academic careers, academic programs, plans and sub-plans. |
PS_F_ADM_APPL |
Metrics
This table lists the metrics in the Admission Application business area:
|
Metric |
Description |
Derivation |
|
Application Count |
This is the count of the admission applications. |
COUNT_DISTINCT(TO_CHAR(Applicant Sid,'0000000000')||TO_CHAR(Academic Career Sid,'0000000000')||TO_CHAR(Student Career Number,'000')||Application Number) |
|
Applicant Count |
This is the count of the admission applicants. |
COUNT_DISTINCT(Applicant Sid) |
|
Application Row Count |
This is the row count field of the student admission application fact table. It always has value 1. |
PS_F_ADM_APPL.APPL_CNT |
Admissions and Recruiting − Admission Application Status Business Area
The Admission Application Status business area contains information on the application status changes (e.g. applied, admitted, waitlisted, denied, matriculated) and their effective dates. Each status change is represented as a row in the fact table. It also contains information on the program actions and action reasons. Use this business area to answer questions about:
admission rates
enrollment rates
yields of the application process
How many applicants were admitted for a particular academic program?
This section describes the content for Admission Application Status business area.
Dimension Folders
This table describes the dimension folders in the Admission Application Status business area.
|
Folder |
Description |
Table |
|
Dimension Academic Career |
This dimension represents all academic careers that an institution offers. |
PS_D_ACAD_CAR |
|
Dimension Academic Level |
This dimension represents the academic level associated with a Student. for e.g. First Year, Second Year, Freshman, Sophomore etc. |
PS_D_ACAD_LVL |
|
Dimension Academic Load |
This dimension represents the academic loads offered, for e.g. Full Time, Part Time etc. |
PS_D_ACAD_LOAD |
|
Dimension Academic Plan |
This dimension represents all the academic plans within an academic program of an institution such as Music. |
PS_D_ACAD_PLAN |
|
Dimension Academic Program |
This dimension represents all the academic programs of an institution such as Bachelor of Arts |
PS_D_ACAD_PROG |
|
Dimension Academic Program Dual Academic Program |
This is a role playing dimension based on Dimension Academic Program for dual academic program. |
PS_D_ACAD_PROG |
|
Dimension Academic Subplan |
This dimension represents all the academic sub plans with an academic plan of an institution such as Piano |
PS_D_ACAD_SPLAN |
|
Dimension Admit Type |
The admit type dimension. It defines the admit types that are assigned to prospects and applications to clarify the type of prospect or applicant, such as first year, readmit, or transfer. |
PS_D_ADMIT_TYPE |
|
Dimension Campus |
This dimension represents all the campuses for an Institution. |
PS_D_CAMPUS |
|
Dimension Day Action Date |
The action date role playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension Institution |
This dimension represents all the academic institutions. This is the institution being applied to. |
PS_D_INSTITUTION |
|
Dimension Person |
This dimension represents the most current personal information of both employees and non-employees of an organization. This is the Applicant. |
PS_D_PERSON |
|
Dimension Person Attribute |
This dimension represents all the additional attributes of a person that are specific to the student role. |
PS_D_PERSON_ATTR |
|
Dimension Program Action |
This dimension represents all the academic program actions. |
PS_D_PROG_ACN |
|
Dimension Program Action Reason |
This dimension represents all the academic program action reasons. |
PS_D_PROG_ACN_RSN |
|
Dimension Program Status |
This dimension represents all the academic program statuses. |
PS_D_PROG_STAT |
|
Dimension Residency |
The residency dimension. It defines the residency of a prospect or applicant to the institution. |
PS_D_RSDNCY |
|
Dimension Term Admit Term |
This is a role playing dimension represents all the academic admit terms of an institution. |
PS_D_TERM |
|
Dimension Term Expected Graduation Term |
This dimension represents all the academic terms of an institution. This is the term the student is expected to graduate. |
PS_D_TERM |
|
Dimension Relate Person Residency |
The person and residency relationship table. It defines the residency status of a person to the institution. |
PS_R_PERSON_RSDNCY |
Fact Folder
This table describes the fact folder in the Admissions and Recruiting - Admission Application Status business area.
|
Folder |
Description |
Table |
|
Fact Admission Application Status |
The student admission application status fact table. This contains data on the application status changes and the effective dates. Each status change is represented as a row in the table. |
PS_F_ADM_APPL_STAT |
Metrics
This table describes the metrics in the Admissions and Recruiting - Admission Application Status business area.
|
Metric |
Description |
Derivation |
|
Applicant Count |
This is the count of the admission applicants. |
COUNT_DISTINCT(Applicant Sid) |
|
Application Status Row Count |
This is the row count field of the student admission application status fact table. It always has value 1. |
PS_F_ADM_APPL_STAT.APPL_STAT_CNT |
Admissions and Recruiting − External Academic Summary Business Area
The External Academic Summary business area tracks information on the external, i.e. outside this institution, test scores of prospects and applicants. With this business area you can answer questions such as:
what was an applicants GPA or class percentile
the institution where the GPA was earned
the average GPA of the prospects or applicants in a particular external organization
This section describes the content for External Academic Summary business area.
Dimension Folders
This table lists the dimension folders in the Admissions and Recruiting − External Academic Summary business area.
|
Folder |
Description |
Table |
|
Dimension Academic Rank Type |
The academic rank type dimension. It defines the different academic rank types. |
PS_D_ACAD_RANK_TYP |
|
Dimension Academic Unit Type |
The academic unit type dimension. It defines the different academic unit types. |
PS_D_ACAD_UNIT_TYP |
|
Dimension Degree External Degree |
This is a role playing dimension based on Dimension Degree for external degree. |
PS_D_DEG |
|
Dimension External Academic Career |
The external academic career dimension. It defines the academic careers from the external organizations such as High School, Undergraduate, Graduate |
PS_D_EXT_ACAD_CAR |
|
Dimension External Academic Level |
The external academic level dimension. It defines the academic levels from the external organizations such as Tenth Grade, Postdoctoral |
PS_D_EXT_ACAD_LVL |
|
Dimension External Academic Summary Type |
The external academic summary type dimension. It defines the type of the academic summary data from the external organizations that is captured for prospects and applicants. For example, it can mirror academic levels on a transcript, such as High School Grade 9, High School Overall, Undergraduate Third Year, and Post-Baccalaureate Overall. |
PS_D_EXT_SUMM_TYP |
|
Dimension External Organization |
The external organization dimension. It defines the external organizations for posting external education data and the last school attended for admissions applicant data. |
PS_D_EXT_ORG |
|
Dimension External Term |
The external term dimension. It defines the terms from the external organizations. |
PS_D_EXT_TERM |
|
Dimension GPA Type |
The GPA type dimension. It defines the different grade point average types. |
PS_D_GPA_TYPE |
|
Dimension Institution |
This dimension represents all the academic institutions. |
PS_D_INSTITUTION |
|
Dimension Person |
This dimension represents the most current personal information of both employees and non-employees of an organization. |
PS_D_PERSON |
|
Dimension Person Attribute |
This dimension represents all the additional attributes of a person that are specific to the student role. |
PS_D_PERSON_ATTR |
|
Dimension Year External Term Year |
This is a role playing dimension based on Dimension Year for external term year. |
PS_D_YEAR |
|
Dimension Relate External Degree |
The external degree relate table. It lists the degrees a prospect or applicant has received from the external organizations. |
PS_R_EXT_DEG |
Fact Folder
This table lists the fact folder in the Admissions and Recruiting − External Academic Summary business area.
|
Folder |
Description |
Table |
|
Fact External Academic Summary |
The external academic summary fact table. This contains data on the external academic information of the prospects and applicants. |
PS_F_EXT_ACAD_SUMM |
Metrics
This table lists metric in the Admissions and Recruiting − External Academic Summary business area. With this business area you can answer questions such as:
How many course units did the prospects or applicants in a particular external organization attempt?
How many course units did the prospects or applicants in a particular external organization complete?
What is the class rank of the prospects or applicants in a particular external organization?
What is the class size of the prospects or applicants in a particular external organization?
What is the GPA of the prospects or applicants in a particular external organization?
What is the converted GPA of the prospects or applicants?
What is the percentile of the prospects or applicants in a particular external organization?
What is the average rank of the prospects or applicants in a particular external organization?
|
Metric |
Description |
Derivation |
|
Class Percentile |
The percentile attained in the external courses or academics. |
PS_F_EXT_ACAD_SUMM.CLASS_PERCENTILE |
|
Class Rank |
The class rank of the prospect / applicant where he/she has taken the external courses or academics. |
PS_F_EXT_ACAD_SUMM.CLASS_RANK |
|
Class Size |
The size of the class of the prospect / applicant where he/she has taken the external courses or academics. |
PS_F_EXT_ACAD_SUMM.CLASS_SIZE |
|
Converted GPA |
The GPA converted per the standards of the enrolled/admitted school/organization standards. |
PS_F_EXT_ACAD_SUMM.CONVERTED_GPA |
|
External GPA |
The GPA attained by the prospect / applicant in the external courses or academics. |
PS_F_EXT_ACAD_SUMM.EXT_GPA |
|
Units Attempted |
This is the total number of the course units that the prospect/applicant has attempted. |
PS_F_EXT_ACAD_SUMM.UNITS_ATTMPTD |
|
Units Completed |
This is the total number of the course units that the prospect/applicant has completed. |
PS_F_EXT_ACAD_SUMM.UNITS_CMPLTD |
Admissions and Recruiting − External Test Scores Business Area
The External Test Scores business area tracks information on the external, i.e. outside this institution, test scores of prospects and applicants. With this business area you can answer questions such as what was the average SAT test score for the applicants, and so on.
This section describes the content for External Test Scores business area.
Dimension Folders
This table lists the dimension folders in the Admissions and Recruiting − External Test Scores business area.
|
Folder |
Description |
Table |
|
Dimension Day External Test Date |
This is a role playing dimension based on Dimension Day for external test date. |
PS_D_DAY |
|
Dimension External Academic Level |
The external academic level dimension. It defines the academic levels from the external organizations. |
PS_D_EXT_ACAD_LVL |
|
Dimension External Test Component |
The external test component dimension. An external test can be any type of academic test that a student must take to qualify admission, satisfy prerequisites, or receive advanced placement credit. Each test has its components. |
PS_D_EXT_TST_CMPNT |
|
Dimension Person |
This dimension represents the most current personal information of both employees and non-employees of an organization. |
PS_D_PERSON |
|
Dimension Person Attribute |
This dimension represents all the additional attributes of a person which are specific to the student role. |
PS_D_PERSON_ATTR |
|
Dimension Test Data Source |
The test data source dimension. It indicates how the test scores were provided to the institution. |
PS_D_TST_DATA_SRC |
Fact Folder
This table lists the fact folder in the Admissions and Recruiting − External Test Scores business area.
|
Folder |
Description |
Table |
|
Fact External Test Scores |
The external test scores fact table. This contains data on the external test scores of the prospects and applicants. These scores are the scores for the standard entrance tests such as SAT and GRE. These scores are used in the application evaluation. |
PS_F_EXT_TESTSCORE |
Metrics
This table lists metric in the Admissions and Recruiting − External Test Scores business area.
|
Metric |
Description |
Derivation |
|
Average Score |
This is the average numeric score. |
AVG(Numeric Score) |
|
Numeric Score |
This is the numeric test score. |
PS_F_EXT_TESTSCORE.NUMERIC_SCORE |
|
Score Percentile |
This is the score percentile. |
PS_F_EXT_TESTSCORE.SCORE_PERCENTILE |
Admissions and Recruiting − Prospects to Applicants to Enrollees Business Area
The Prospects to Applicants to Enrollees business area tracks the path of prospects, applicants and enrollees by admissions term and referral service. With this business area you can answer questions such as:
How many prospects led to how many applicants.
How many applicants successfully where enrollees.
What were the yields from prospects to applicants for a particular admit term.
What were the yields from applicants to enrollees for a particular admit term.
This section describes the content for Prospects to Applicants to Enrollees business area.
Dimension Folders
This table lists the dimension folders in the Admissions and Recruiting − Prospects to Applicants to Enrollees business area.
|
Folder |
Description |
Table |
|
Dimension Person |
This dimension represents the most current personal information of both employees and non-employees of an organization. It can be a prospect, an applicant and a student. |
PS_D_PERSON |
|
Dimension Term Admit Term |
This is a role playing dimension represents all the academic admit terms of an institution. |
PS_D_TERM |
|
Dimension Referral Source |
The referral source dimension. It tracks how prospects or applicants learned of the institution and indicates why they were originally added to the system. |
PS_D_RFRL_SRC |
Fact Folder
This table lists the fact folder in the Admissions and Recruiting − Prospects to Applicants to Enrollees business area.
|
Folder |
Description |
Table |
|
Fact Prospects to Applicants to Enrollees |
This custom folder contains data on prospective students, applicants and enrollees by admit term and referral source. |
It is built based on a SQL query against multiple tables. |
Metrics
This table lists metric in the Admissions and Recruiting − Prospects to Applicants to Enrollees business area.
|
Metric |
Description |
Derivation |
|
Applicant Count |
This is the count of the prospective students who have submitted admission applications. |
COUNT_DISTINCT(CASE WHEN Application On File Flag = 'Y' THEN Prospect Sid ELSE NULL END) |
|
Enrollee Count |
This is the count of the applicants who have been matriculated and enrolled in classes. |
COUNT_DISTINCT(CASE WHEN Enrollment Flag = 'Y' THEN Prospect Sid ELSE NULL END) |
|
Prospect Count |
This is the count of the prospective students. |
COUNT_DISTINCT(Prospect Sid) |
Hierarchy
|
Hierarchy |
Column |
Description |
|
Admit Term |
Dimension Term Admit Term.Admit Institution -> Dimension Term Admit Term.Admit Academic Career -> Dimension Term Admit Term.Admit Term |
This is the hierarchy for admit term, career and institution. |
|
Dual Academic Program 1 |
Dimension Academic Program Dual Academic Program.Dual Institution -> Dimension Academic Program Dual Academic Program.Dual Academic Career -> Dimension Academic Program Dual Academic Program.Dual Academic Program |
This is the hierarchy for dual academic program, career and institution. |
|
Dual Academic Program 2 |
Dimension Academic Program Dual Academic Program.Dual Institution -> Dimension Academic Program Dual Academic Program.Dual Academic Group -> Dimension Academic Program Dual Academic Program.Dual Academic Program |
This is the hierarchy for dual academic program, group and institution. |
|
Expected Graduation Term |
Dimension Term Expected Graduation Term.Expected Graduation Institution -> Dimension Term Expected Graduation Term.Expected Graduation Academic Career -> Dimension Term Expected Graduation Term.Expected Graduation Term |
This is the hierarchy for expected graduation term, career and institution. |
|
External Test Component |
Dimension External Test Component.External Test -> Dimension External Test Component.External Test Component |
This is the hierarchy for external test component and external test. |
Campus Solutions Warehouse Student Records Discoverer Business Areas
This section describes the content for the Compensation business areas in the Campus Solutions Warehouse. This section discusses these business areas:
Term Enrollment
Class Enrollment
Academic Program Detail
Academic Plan Summary
Class Instructor
Institution Summary
Student Records − Term Enrollment Business Area
The Term Enrollment Business Area business area contains the details on an individual student’s enrollment for a given term. This section describes the content for Term Enrollment business area. This business area helps answers questions such as:
What are the enrollment metrics for this term?
What is average GPA by Institution, Career and Program?
What is average time to graduate by Institution, Career and Program?
Dimension Folders
This table lists the dimension folders in the Term Enrollment business area:
|
Folder |
Description |
Table |
|
Dimension Academic Level End Term |
This is a role-playing dimension represents the academic level associated with a Student such as First Year, Second Year, Freshman, Sophomore and so on, at the end of the term. |
PS_D_ACAD_LVL |
|
Dimension Academic Level Projected |
This is a role-playing dimension represents the projected academic level associated with a Student such as First Year, Second Year, Freshman, Sophomore and so on. |
PS_D_ACAD_LVL |
|
Dimension Academic Level Start Term |
This is a role-playing dimension represents the academic level associated with a Student such as First Year, Second Year, Freshman, Sophomore and so on, at the beginning of the term. |
PS_D_ACAD_LVL |
|
Dimension Academic Load |
This dimension represents the academic loads offered, for example Full Time, Part Time and so on. |
PS_D_ACAD_LOAD |
|
Dimension Academic Organization |
This dimension represents all the academic organizational entities of an institution. |
PS_D_ACAD_ORG |
|
Dimension Academic Organization Tree |
This dimension tracks the hierarchical relationship between academic organizations. |
PS_V_ACAD_ORG |
|
Dimension Academic Program |
This dimension represents all the academic programs of an institution. |
PS_D_ACAD_PROG |
|
Dimension Academic Standing |
This dimension represents all the academic standings of an Institution. |
PS_D_ACAD_STNDNG |
|
Dimension Day Fully Enroll Date |
The fully enroll date role playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension Day Withdrawn Date |
The withdrawn date role playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension Person |
This dimension represents the most current personal information of both employees and non-employees of an organization. |
PS_D_PERSON |
|
Dimension Person Attribute |
This dimension represents all the additional attributes of a person which are specific to the student role. |
PS_D_PERSON_ATTR |
|
Dimension Program Action |
This dimension represents all the academic program actions. |
PS_D_PROG_ACN |
|
Dimension Program Action Reason |
This dimension represents all the academic program action reasons. |
PS_D_PROG_ACN_RSN |
|
Dimension Program Status |
This dimension represents all the academic program statuses. |
PS_D_PROG_STAT |
|
Dimension Student Cohort |
This dimension represents all the student cohorts (student attributes) of an Institution. |
PS_D_STDNT_COHORT |
|
Dimension Student Group |
This dimension represents all the student groups of an Institution. |
PS_D_STDNT_GRP |
|
Dimension Term |
This dimension represents all the academic terms of an institution. |
PS_D_TERM |
|
Dimension Year Academic |
The academic year role playing dimension based on the year dimension. |
PS_D_YEAR |
|
Dimension Relate Student Cohort |
This related dimension table represents the relationship between a student (person) to the cohorts (attributes). |
PS_R_STDNT_COHORT |
|
Dimension Relate Student Group |
This related dimension table represents the relationship between a student (person) to the groups. |
PS_R_STDNT_GRP |
Fact Folder
This table lists the fact folder in the Term Enrollment business area:
|
Folder |
Description |
Table |
|
Fact Term Enrollment |
This fact includes information about an individual student's enrollment entry for a given term. |
PS_F_TERM_ENRLMT |
Metrics
This table lists the metrics in the Term Enrollment business area:
Student Records − Class Enrollment Business Area
The Class Enrollment business area contains information about students enrolled in the offered classes and their performance. This business area helps answer questions like:
What classes are scheduled for this term?
Can I track and analyze the workload of the faculty?
This section describes the content in the Class Enrollment business area.
Dimension Folders
This table lists the dimension folders in the Class Enrollment business area:
|
Folder |
Description |
Table |
|
Dimension Academic Level End Term |
This is a role-playing dimension represents the academic level associated with a Student. For example: First Year, Second Year, Freshman, Sophomore and so on, at the end of the term. |
PS_D_ACAD_LVL |
|
Dimension Academic Level Projected |
This is a role-playing dimension represents the projected academic level associated with a Student. For example: First Year, Second Year, Freshman, Sophomore and so on. |
PS_D_ACAD_LVL |
|
Dimension Academic Level Start Term |
This is a role-playing dimension represents the academic level associated with a Student. For example First Year, Second Year, Freshman, Sophomore and so on, at the beginning of the term. |
PS_D_ACAD_LVL |
|
Dimension Academic Load |
This dimension represents the academic loads offered, such as Full Time, Part Time. |
PS_D_ACAD_LOAD |
|
Dimension Academic Organization |
This dimension represents all the academic organizational entities of an institution. |
PS_D_ACAD_ORG |
|
Dimension Academic Organization Tree |
This dimension tracks the hierarchical relationship between academic organizations. |
PS_V_ACAD_ORG |
|
Dimension Academic Program |
This dimension represents all the academic programs of an institution. |
PS_D_ACAD_PROG |
|
Dimension Academic Standing |
This dimension represents all the academic standings of an Institution. |
PS_D_ACAD_STNDNG |
|
Dimension Day Fully Enroll Date |
The fully enroll date role playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension Day Withdrawn Date |
The withdrawn date role playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension Person |
This dimension represents the most current personal information about the student. |
PS_D_PERSON |
|
Dimension Person Attribute |
This dimension represents all the additional attributes of a person that are specific to the student role. |
PS_D_PERSON_ATTR |
|
Dimension Program Action |
This dimension represents all the academic program actions. |
PS_D_PROG_ACN |
|
Dimension Program Action Reason |
This dimension represents all the academic program action reasons. |
PS_D_PROG_ACN_RSN |
|
Dimension Program Status |
This dimension represents all the academic program statuses. |
PS_D_PROG_STAT |
|
Dimension Student Cohort |
This dimension represents all the student cohorts (student attributes) of an Institution. |
PS_D_STDNT_COHORT |
|
Dimension Student Group |
This dimension represents all the student groups of an Institution. |
PS_D_STDNT_GRP |
|
Dimension Term |
This dimension represents all the academic terms of an institution. |
PS_D_TERM |
|
Dimension Year Academic |
The academic year role playing dimension based on the year dimension. |
PS_D_YEAR |
|
Dimension Relate Student Cohort |
This related dimension table represents the relationship between a student (person) to the cohorts (attributes). |
PS_R_STDNT_COHORT |
|
Dimension Relate Student Group |
This related dimension table represents the relationship between a student (person) to the groups. |
PS_R_STDNT_GRP |
Fact Folder
This table lists the fact folder in the Class Enrollment business area:
|
Folder |
Description |
Table |
|
Fact Term Enrollment |
This fact includes information about an individual student's enrollment entry for a given term. |
PS_F_TERM_ENRLMT |
Complex Metrics
This table lists the complex metrics in the Class Enrollment business area:
|
Metric |
Derivation |
|
Course Count |
This is the total count of the courses taken by the student for a term. |
|
Cumulative Grade Point Average |
This is the cumulative Grade Point Average (GPA) of the student. |
|
Current Grade Point Average |
This is the current Grade Point Average (GPA) of a student in a term. |
|
Grade Points |
This metric is the grade points earned by the student. |
|
Maximum Audit Units |
This is the maximum audit unit. |
|
Maximum Units towards Non Grade Point Average |
This is the maximum total unit not towards Grade Point Average (GPA). |
|
Maximum Total Units |
This is the maximum total unit. |
|
Maximum Wait Units |
This is the maximum wait unit. |
|
Minimum Total Units |
This is the minimum total unit. |
|
Other Units |
This is the units from other credits |
|
Units Passed for Grade Point Average |
This is the ‘units passed’ for Grade Point Average (GPA) by the student. |
|
Units Passed for Non Grade Point Average |
This is the ‘units passed’ for non Grade Point Average (GPA) by the student. |
|
Units Passed in Progress |
This is the class units passed by the student. |
|
Units in Progress for Grade Point Average |
This is the ‘units in progress’ for Grade Point Average (GPA) by the student. |
|
Units in Progress for Non Grade Point Average |
This is the ‘units in progress’ for non Grade Point Average (GPA) by the student. |
|
Row Count |
This is a dummy rowcount number that is always set to 1 and can be used for deriving various metrics. |
|
Units Taken for Grade Point Average |
This is the units taken for Grade Point Average (GPA) by the student. |
|
Units Taken for Non Grade Point Average |
This is the ‘units taken’ for non Grade Point Average (GPA) by the student. |
|
Units Taken in Progress |
This is the units progressed by the student. |
|
Total Term Units |
This is the total term units. |
|
Units Transferred |
This is the ’units transferred’ by the student. |
Hierarchy
This table lists the Hierarchies for the Class Enrollment business area:
|
Hierarchy |
Column |
Description |
|
Academic Organization Tree |
This is the hierarchy for the academic organization tree. |
ACAD_ORG_SID |
|
Academic Program Alternate |
This is the academic program hierarchy by Institution, Group and Program |
ACAD_PROG_SID |
|
Academic Program |
This is the academic program hierarchy by Institution, Career, and Program |
ACAD_PROG_SID |
|
Full Enroll Date |
This is the hierarchy for enroll date. |
ENROLL_DT_SID |
|
Withdrawn Date |
This is the hierarchy for withdrawn date. |
WDN_DT_SID |
|
Term |
This is the hierarchy for term, career and institution. |
TERM_SID |
Student Records − Academic Program Detail Business Area
The Academic Program Detail business area provides and individual program action entry for a particular student for a given academic program. This Business Area helps to answer question such as:
How many students are full time? Part time?
How many students are expected to graduate this term
What are the student groups at a particular campus?
This section describes the content in the Academic Program Detail business area.
Dimension Folders
This table lists the dimension folders in the Academic Program Detail business area:
|
Folder |
Description |
Table |
|
Dimension Academic Load |
This dimension represents the academic loads offered, for e.g. Full Time, Part Time etc. |
PS_D_ACAD_LOAD |
|
Dimension Academic Organization |
This dimension represents all the academic organizational entities of an institution. |
PS_D_ACAD_ORG |
|
Dimension Academic Organization Tree |
This dimension tracks the hierarchical relationship between academic organizations. |
PS_V_ACAD_ORG |
|
Dimension Academic Program |
This dimension represents all the academic programs of an institution. |
PS_D_ACAD_PROG |
|
Dimension Academic Subplan |
This dimension represents all the academic sub plans with an academic plan of an institution. |
PS_D_ACAD_SPLAN |
|
Dimension Campus |
This dimension represents all the campuses for an Institution. |
PS_D_CAMPUS |
|
Dimension Day Action Date |
The action date role-playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension Person |
This dimension represents the most current personal information of the student. |
PS_D_PERSON |
|
Dimension Person Attribute |
This dimension represents all the additional attributes of a person that are specific to the student role. |
PS_D_PERSON_ATTR |
|
Dimension Program Action |
This dimension represents all the academic program actions. |
PS_D_PROG_ACN |
|
Dimension Program Action Reason |
This dimension represents all the academic program action reasons. |
PS_D_PROG_ACN_RSN |
|
Dimension Program Status |
This dimension represents all the academic program statuses. |
PS_D_PROG_STAT |
|
Dimension Student Cohort |
This dimension represents all the student cohorts (student attributes) of an Institution. |
PS_D_STDNT_COHORT |
|
Dimension Student Group |
This dimension represents all the student groups of an Institution. |
PS_D_STDNT_GRP |
|
Dimension Term Admit Term |
This is a role playing dimension represents all the academic admit terms of an institution. |
PS_D_TERM |
|
Dimension Term Completed Term |
This dimension represents all the academic terms of an institution. |
PS_D_TERM |
|
Dimension Term Expected Graduation Term |
This dimension represents all the academic terms of an institution. |
PS_D_TERM |
|
Dimension Term Requirement Term |
This dimension represents all the academic terms of an institution. |
PS_D_TERM |
|
Dimension Relate Academic Subplan |
This related dimension table represents the relationship between an academic plan to its subplans. |
PS_R_ACAD_SPLAN |
|
Dimension Relate Student Cohort |
This related dimension table represents the relationship between a student (person) to the cohorts (attributes). |
PS_R_STDNT_COHORT |
|
Dimension Relate Student Group |
This related dimension table represents the relationship of a student (person) to the groups. |
PS_R_STDNT_GRP |
Fact Folder
This table lists the fact folder in the Academic Program Detail business area:
|
Folder |
Description |
Table |
|
Fact Academic Program Detail |
This fact includes information about an individual program action entry for a particular student for a given academic program. |
PS_F_ACAD_PROG_DTL |
Metrics
This table lists the metrics in the Academic Program Detail business area:
|
Metric Name |
Description |
Database Object Name |
|
Action Count |
This is a dummy row count number that is always set to 1 and can be used for deriving various metrics. |
PS_F_ACAD_PROG_DTL.ACN_CNT |
Hierarchy
This table lists the Hierarchy for the Academic Program Details business Area:
|
Hierarchy |
Column |
Description |
|
Academic Organization Tree Hierarchy |
This is the hierarchy for the academic organization tree. |
ACAD_ORG_SID |
|
Academic Program Alternate Hierarchy |
This is the academic program hierarchy by Institution, Group and Program |
ACAD_PROG_SID |
|
Academic Program Hierarchy |
This is the academic program hierarchy by Institution, Career, and Program |
ACAD_PROG_SID |
|
Action Date Hierarchy |
This is the hierarchy for date. |
ACTION_DT_SID |
|
Admit Term Hierarchy |
This is the hierarchy for admit term, career and institution. |
ADMIT_TERM_SID |
|
Campus Hierarchy |
This is the campus hierarchy by Institution, campus |
CAMPUS_SID |
|
Expected Graduation Term Hierarchy |
This is the hierarchy for expected graduation term, career and institution. |
EXP_GRAD_TERM_SID |
Student Records − Academic Plan Summary Business Area
The Academic Plan Summary business area provides analysis for benefit enrollment data, as well as the capability to calculate benefit valuations that are not processed via the payroll system.
This section describes the content in the Academic Plan Summary business area.
Dimension Folders
This section lists the dimension folders in the Academic Plan Summary business area:
|
Folder |
Description |
Table |
|
Dimension Academic Load |
This dimension represents the academic loads offered, for e.g. Full Time, Part Time etc. |
PS_D_ACAD_LOAD |
|
Dimension Academic Organization |
This dimension represents all the academic organizational entities of an institution. |
PS_D_ACAD_ORG |
|
Dimension Academic Organization Tree |
This dimension tracks the hierarchical relationship between academic organizations. |
PS_V_ACAD_ORG |
|
Dimension Academic Plan |
This dimension represents all the academic plans within an academic program of an institution. |
PS_D_ACAD_PLAN |
|
Dimension Academic Subplan |
This dimension represents all the academic sub plans with an academic plan of an institution. |
PS_D_ACAD_SPLAN |
|
Dimension Admit Type |
The admit type dimension. It defines the admit types that are assigned to prospects and applications to clarify the type of prospect or applicant, such as first year, readmit, or transfer. |
PS_D_ADMIT_TYPE |
|
Dimension Award |
This dimension represents all the awards which an Institution confers to its students. |
PS_D_AWD |
|
Dimension Campus |
This dimension represents all the campuses for an Institution. |
PS_D_CAMPUS |
|
Dimension Day Degree Conferral Date |
The degree conferral date role playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension Degree |
This dimension represents all the degrees, which an Institution confers to its students. |
PS_D_DEG |
|
Dimension Degree Honors |
This dimension represents all the degree honors which an Institution confers to its students. |
PS_D_DEG_HONORS |
|
Dimension Degree Status |
This dimension represents all the gender details. |
PS_D_DEG_STAT |
|
Dimension Person |
This dimension represents the most current personal information of both employees and non-employees of an organization. |
PS_D_PERSON |
|
Dimension Person Attribute |
This dimension represents all the additional attributes of a person which are specific to the student role. |
PS_D_PERSON_ATTR |
|
Dimension Program Action |
This dimension represents all the academic program actions. |
PS_D_PROG_ACN |
|
Dimension Program Action Reason |
This dimension represents all the academic program action reasons. |
PS_D_PROG_ACN_RSN |
|
Dimension Program Status |
This dimension represents all the academic program statuses. |
PS_D_PROG_STAT |
|
Dimension Student Cohort |
This dimension represents all the student cohorts (student attributes) of an Institution. |
PS_D_STDNT_COHORT |
|
Dimension Student Group |
This dimension represents all the student groups of an Institution. |
PS_D_STDNT_GRP |
|
Dimension Term Admit Term |
This is a role-playing dimension represents the entire academic admit terms of an institution. |
PS_D_TERM |
|
Dimension Term Completed Term |
This dimension represents all the academic terms of an institution. |
PS_D_TERM |
|
Dimension Term Expected Graduation Term |
This dimension represents all the academic terms of an institution. |
PS_D_TERM |
|
Dimension Term Requirement Term |
This dimension represents all the academic terms of an institution. |
PS_D_TERM |
|
Dimension Relate Academic Subplan |
This related dimension table represents the relationship between an academic plan to its subplans. |
PS_R_ACAD_SPLAN |
|
Dimension Relate Award |
This related dimension table represents the relationship between a student (person) to the awards he/she has received. |
PS_R_AWD |
|
Dimension Relate Degree Honors |
This related dimension table represents the relationship between a student’s (person) degree to the honors he/she has received. |
PS_R_DEG_HONORS |
|
Dimension Relate Student Cohort |
This related dimension table represents the relationship between a student (person) to the cohorts (attributes). |
PS_R_STDNT_COHORT |
|
Dimension Relate Student Group |
This related dimension table represents the relationship between a student (person) to the groups. |
PS_R_STDNT_GRP |
Fact Folder
This table lists the fact folder in the Academic Plan Summary business area:
|
Folder |
Description |
Table |
|
Fact Academic Plan Summary |
This fact includes information about an individual student's summary entry for a given academic plan and related academic program. Each row will have the most current information about an individual student and a particular academic plan. |
PS_F_ACADPLAN_SUMM |
Metrics
This table lists the metrics in the Academic Plan Summary business area:
|
Metric Name |
Description |
Database Object Name |
|
Degree GPA Points |
This is the student's final degree GPA for an academic program. |
PS_F_ACADPLAN_SUMM.DEG_GPA_PTS |
|
Row Count |
This is a dummy row count number, which is always set to 1 and can be used for deriving various metrics. |
PS_F_ACADPLAN_SUMM.ROW_CNT |
Hierarchy
This table lists the hierarchy for the Academic Plan Summary business area:
|
Hierarchy |
Column |
Description |
|
Academic Organization Tree |
This is the hierarchy for the academic organization tree. |
ACAD_ORG_SID |
|
Academic Program Alternate |
This is the academic program hierarchy by Institution, Group and Program |
ACAD_PROG_SID |
|
Academic Program |
This is the academic program hierarchy by Institution, Career, and Program |
ACAD_PROG_SID |
|
Admit Date |
This is the hierarchy based on admit date. |
ACTION_DT_SID |
|
Activated Date |
This is the hierarchy based on program activate date. |
ACTION_DT_SID |
|
Completed Date |
This is the hierarchy based on program complete date. |
ACTION_DT_SID |
|
Admit Term |
This is the hierarchy for admit term, Academic Career and Institution. |
ADMIT_TERM_SID |
|
Campus |
This is the campus hierarchy by Campus and Institution. |
CAMPUS_SID |
|
Expected Graduation Term |
This is the hierarchy for expected graduation term, Academic Career and Institution. |
EXP_GRAD_TERM_SID |
Student Records − Class Instructor Business Area
The Class Instructor business area contains information about a specific class being held and the assigned instructor. This business area helps in answering questions like can I track and analyze the workload of the faculty?
This section describes the content in the Class Instructor business area.
Dimension Folders
This table lists the dimension folders in the Class Instructor business area:
|
Folder |
Description |
Table |
|
Dimension Academic Group |
This dimension represents all the academic groups of an institution. |
PS_D_ACAD_GRP |
|
Dimension Academic Organization |
This dimension represents all the academic organizational entities of an institution. |
PS_D_ACAD_ORG |
|
Dimension Academic Organization Tree |
This dimension tracks the hierarchical relationship between academic organizations. |
PS_V_ACAD_ORG |
|
Dimension Campus |
This dimension represents all the campuses for an Institution. |
PS_D_CAMPUS |
|
Dimension Course |
This dimension represents all the course offerings for an Institution. |
PS_D_CRSE |
|
Dimension Day End Date |
The end date role-playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension Day Start Date |
The start date role-playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension Facility |
This dimension represents all the facilities in various campuses of an Institution. This where the class is held. |
PS_D_FCLTY |
|
Dimension Instruction Mode |
This dimension represents all the course mode of instructions like distant, classroom etc. |
PS_D_INSTRCTN_MODE |
|
Dimension Instructor Class Role |
This dimension stores the different roles that can be played by faculty/instructor, for example Prim Instr (Prime Instructor). |
PS_D_INSTRCTR_ROLE |
|
Dimension Instructor Load |
This dimension represents the instructors load such as full-time, part-time. |
PS_D_INSTRCTR_LOAD |
|
Dimension Location |
The Location dimension includes a list of work sites for an organization. Location is used to establish physical locations in an organization such as corporate headquarters, branch offices, remote sales offices, and so on. |
PS_D_LOCATION |
|
Dimension Person |
This dimension represents the most current personal information of an instructor. |
PS_D_PERSON |
|
Dimension Person Attribute |
This dimension represents all the additional attributes of a person that are specific to the student role. |
PS_D_PERSON_ATTR |
|
Dimension SSR Component |
This dimension represents all the SSR components i.e. course sections of a course. |
PS_D_SSR_COMP |
|
Dimension Session |
This dimension represents all the academic sessions of a term. |
PS_D_SESSION |
Fact Folder
This table lists the fact folder in the Class Instructor business area:
|
Folder |
Description |
Table |
|
Fact Class Instructor |
This fact includes information about an individual class scheduled for a particular term. |
PS_F_CLASS_INSTRCT |
Metrics
This table lists the metrics in the Class Instructor business area:
|
Metric Name |
Description |
Database Object Name |
|
Assignment Percentage |
This is the assignment percentage of the instructor. |
PS_F_CLASS_INSTRCT.ASGN_PCT |
|
Instructor Load Percentage |
This is the percentage of the weekly instructor load |
PS_F_CLASS_INSTRCT.INSTRCTR_LOAD_PCT |
|
Row Count |
This is a dummy row count number which is always set to 1 and can be used for deriving various metrics. |
PS_F_CLASS_INSTRCT.ROW_CNT |
|
Week Workload Hour Count |
This is the weekly workload hours of the instructor. |
PS_F_CLASS_INSTRCT.WEEK_WRKLD_HR_CNT |
Hierarchy
This table lists the Hierarchies for the Class Instructor business area:
|
Hierarchy |
Column |
Description |
|
Academic Organization Tree Hierarchy |
This is the hierarchy for the academic organization tree. |
ACAD_ORG_SID |
|
Start Date Hierarchy |
This is the hierarchy for start date. |
STRT_DT_SID |
|
End Date Hierarchy |
This is the hierarchy for end date. |
END_DT_SID |
|
Campus Hierarchy |
This is the campus hierarchy by Institution, campus |
CAMPUS_SID |
|
Location Hierarchy |
This is the HR location hierarchy |
LOC_SID |
|
Session Hierarchy |
This is the Session hierarchy |
SESSION_SID |
|
Course Hierarchy |
This is the Course hierarchy |
CRSE_SID |
Student Records − Institution Summary Business Area
The Institution Summary business area contains important metrics like graduation rate and retention rate and aids in analysis of these metrics across several years for the different compositions of the student body. This business area helps in answering questions like:
What is Student Retention and Graduation rates year over year by Cohort, Gender and Ethnicity?
Are my undergraduate students doing better this year compared to last year?
This section describes the content in the Institution Summary business area.
Dimension Folders
This table lists the dimension folders in the Institution Summary business area:
|
Folder |
Description |
Table |
|
Dimension Academic Program |
This dimension represents all the academic programs of an institution. |
PS_D_ACAD_PROG |
|
Dimension Admit Type |
The admit type dimension. It defines the admit types that are assigned to prospects and applications to clarify the type of prospect or applicant, such as first year, readmit, or transfer. |
PS_D_ADMIT_TYPE |
|
Dimension Ethnic Group |
This dimension represents all the ethnic groups. |
PS_D_ETHNIC_GRP |
|
Dimension Gender |
This dimension represents all the gender details. |
PS_D_GNDR |
|
Dimension Student Cohort |
This dimension represents all the student cohorts (student attributes) of an Institution. |
PS_D_STDNT_COHORT |
|
Dimension Term Admit Term |
This is a role playing dimension represents all the academic admit terms of an institution. |
PS_D_TERM |
|
Dimension Year Admit |
The year dimension. |
PS_D_YEAR |
Fact Folder
This table lists the fact folder in the Institution Summary business area:
|
Folder |
Description |
Table |
|
Fact Institution Summary |
This fact includes information about the retention and graduation counts of an institution. Each row will have calculated metrics for every academic plan, admit term, admit type, student gender, ethnicity, and student cohort with a snapshot |
PS_F_INST_SUMM |
Metrics
This table lists the metrics in the Institution Summary business area:
|
Metric Name |
Description |
Database Object Name |
|
Full Time Headcount |
This is the total full time headcount for the cohort for a program at the time of admittance. |
PS_F_INST_SUMM.FT_HEAD_CNT |
|
Part Time Headcount |
This is the total part time head count for the cohort for a program at the time of admittance. |
PS_F_INST_SUMM.PT_HEAD_CNT |
|
Total Headcount |
This is the total headcount for the cohort for a program at the time of admittance. |
PS_F_INST_SUMM.TOT_HEAD_CNT |
|
1 Year Allowable Exclusion Count |
This is the cumulative allowable exclusion year 1 headcount for the cohort for a program. |
PS_F_INST_SUMM.YR_1_ALLW_EXCL_CNT |
|
1 Year Graduation Count |
This is the total graduation count for the cohort for a program after 1 year of the admit term. |
PS_F_INST_SUMM.YR_1_GRAD_CNT |
|
1 Year Retention Count |
This is the total retention count for the cohort for a program after 1 year of the fall admit term. |
PS_F_INST_SUMM.YR_1_RTNTN_CNT |
|
2 Year Allowable Exclusion Count |
This is the cumulative allowable exclusion year 2 headcount for the cohort for a program. |
PS_F_INST_SUMM.YR_2_ALLW_EXCL_CNT |
|
2 Year Graduation Count |
This is the total graduation count for the cohort for a program after 2 years of the admit term. |
PS_F_INST_SUMM.YR_2_GRAD_CNT |
|
2 Year Retention Count |
This is the total retention count for the cohort for a program after 2 years of the fall admit term. |
PS_F_INST_SUMM.YR_2_RTNTN_CNT |
|
3 Year Allowable Exclusion Count |
This is the cumulative allowable exclusion year 3 headcount for the cohort for a program. |
PS_F_INST_SUMM.YR_3_ALLW_EXCL_CNT |
|
3 Year Graduation Count |
This is the total graduation count for the cohort for a program after 3 years of the admit term. |
PS_F_INST_SUMM.YR_3_GRAD_CNT |
|
3 Year Retention Count |
This is the total retention count for the cohort for a program after 3 years of the fall admit term. |
PS_F_INST_SUMM.YR_3_RTNTN_CNT |
|
4 Year Allowable Exclusion Count |
This is the cumulative allowable exclusion year 4 headcount for the cohort for a program. |
PS_F_INST_SUMM.YR_4_ALLW_EXCL_CNT |
|
4 Year Graduation Count |
This is the total graduation count for the cohort for a program after 4 years of the admit term. |
PS_F_INST_SUMM.YR_4_GRAD_CNT |
|
4 Year Retention Count |
This is the total retention count for the cohort for a program after 4 years of the fall admit term. |
PS_F_INST_SUMM.YR_4_RTNTN_CNT |
|
5 Year Allowable Exclusion Count |
This is the cumulative allowable exclusion year 5 headcount for the cohort for a program. |
PS_F_INST_SUMM.YR_5_ALLW_EXCL_CNT |
|
5 Year Graduation Count |
This is the total graduation count for the cohort for a program after 5 years of the admit term. |
PS_F_INST_SUMM.YR_5_GRAD_CNT |
|
5 Year Retention Count |
This is the total retention count for the cohort for a program after 5 years of the fall admit term. |
PS_F_INST_SUMM.YR_5_RTNTN_CNT |
|
6 Year Allowable Exclusion Count |
This is the cumulative allowable exclusion year 6 headcount for the cohort for a program. |
PS_F_INST_SUMM.YR_6_ALLW_EXCL_CNT |
|
6 Year Graduation Count |
This is the total graduation count for the cohort for a program after 6 years of the admit term. |
PS_F_INST_SUMM.YR_6_GRAD_CNT |
|
6 Year Retention Count |
This is the total retention count for the cohort for a program after 6 years of the fall admit term. |
PS_F_INST_SUMM.YR_6_RTNTN_CNT |
|
7 Year Allowable Exclusion Count |
This is the cumulative allowable exclusion year 7 headcount for the cohort for a program. |
PS_F_INST_SUMM.YR_7_ALLW_EXCL_CNT |
|
7 Year Graduation Count |
This is the total graduation count for the cohort for a program after 7 years of the admit term. |
PS_F_INST_SUMM.YR_7_GRAD_CNT |
|
7 Year Retention Count |
This is the total retention count for the cohort for a program after 7 years of the fall admit term. |
PS_F_INST_SUMM.YR_7_RTNTN_CNT |
Hierarchy
This table lists the Hierarchy for the Class Instructor business area:
|
Hierarchy |
Column |
Description |
|
Academic Program Alternate Hierarchy |
This is the academic program hierarchy by Institution, Academic Group and Academic Program. |
ACAD_PROG_SID |
|
Academic Program Hierarchy |
This is the academic program hierarchy by Institution, Academic Career, and Academic Program. |
ACAD_PROG_SID |
|
Admit Term Hierarchy |
This is the hierarchy for admit term, Academic Career and Institution. |
ADMIT_TERM_SID |
Campus Solutions Warehouse Student Financial Services Business Areas
This section describes the content for the Student Financial Services business areas in the Campus Solutions Warehouse. This EUL comprises the financial awards as well as the analysis of student payments. This section discusses these business areas:
Award Disbursement
Award Snapshot
Bill Summary
Pending Payments
Student Financials Transactions
Student Financial Services − Award Disbursement Business Area
The Award Disbursement business area contains details regarding term based detail information associated with a student’s financial awards from the institution. This Business Area can help answer questions such as:
How much financial aid was disbursed by Institution?
What was the distribution of disbursements across Financial Aid types (grants, loans, and so on) ?
This section describes the content in the Award Disbursement business area.
Dimension Folders
This table lists the dimension folders in the Award Disbursement business area:
|
Folder |
Description |
Table |
|
Dimension Academic Career |
This dimension represents all academic careers that an institution offers. |
PS_D_ACAD_CAR |
|
Dimension Aid Year |
This contains the details about the federal aid year. |
PS_D_AID_YR |
|
Dimension Award Period |
This contains the different award periods, which can be used for financial aid awarding. |
PS_D_AWD_PRD |
|
Dimension Award Status |
This categorizes the status of a financial aid award as Accepted/Offered/Authorized etc., |
PS_D_AWD_STAT |
|
Dimension Business Unit Student Financials |
This is a role-playing dimension based on Dimension Business Unit and used to store student financials business units. |
PS_D_BUSINESS_UNIT |
|
Dimension Day Application Received Date |
The day dimension. |
PS_D_DAY |
|
Dimension Day Application Status Date |
The day dimension. |
PS_D_DAY |
|
Dimension Dependency Status |
This contains the dependency information of the student applying for financial aid. |
PS_D_DPNDCY_STAT |
|
Dimension Disbursement |
This contains the Disbursement Plan and Split Code values established for each financial aid Item Type, by Career. |
PS_D_DISB |
|
Dimension Federal Aid Application |
This contains attributes necessary to maintain the FAFSA (Free Application for Federal Student Aid) application and changes to Institutional Student Information Record (ISIR) data. |
PS_D_FED_AID_APP |
|
Dimension Financial Aid Item Type |
This contains attributes that may be associated with financial aid item types, used to define the type of financial aid award. |
PS_D_FA_ITEM_TYPE |
|
Dimension Financial Aid Type |
This contains the category or type of financial aid offered via an Financial Aid Item Type |
PS_D_FIN_AID_TYPE |
|
Dimension Institution |
This dimension represents all the academic institutions. |
PS_D_INSTITUTION |
|
Dimension Person |
This dimension represents the most current personal information of both employees and non-employees of an organization. |
PS_D_PERSON |
|
Dimension Student Aid Attributes |
This contains a record for each student applying for aid and contains the attributes, high level information relating to the application, awarding and processing of financial aid for the year. The status fields indicate if aid-processing st |
PS_D_STU_AID_ATTR |
|
Dimension Student Financial Aid Terms |
This contains student information by Institution and Term. The primary use of this table is to provide a consolidated view of student term data for Financial Aid processing purposes. |
PS_D_STU_FA_TERM |
|
Dimension Term |
This dimension represents all the academic terms of an institution. |
PS_D_TERM |
Fact Folder
This table lists the fact folder in the Award Disbursement business area:
|
Folder |
Description |
Table |
|
Fact Award Disbursement |
This contains term based detail information associated with a student's awards: amount, status, disbursement, aid type, etc. |
PS_F_AWD_DISB |
Metrics
This table lists the metrics in the Award Disbursement business area:
|
Metric Name |
Description |
Database Object Name |
|
Accepted Amount |
This is a number representing the dollar amount of a financial aid award (Item Type) accepted by a student. |
PS_F_AWD_DISB.ACCEPTED_AMT |
|
Authorized Amount |
This is a number representing the dollar amount of a financial aid award (Item Type) which has been authorized to be disbursed to a student. |
PS_F_AWD_DISB.AUTHORIZED_AMT |
|
Disbursed Amount |
This is a number representing the total dollar amount of a financial aid award (Item Type) which was disbursed to a student. |
PS_F_AWD_DISB.DISBURSED_AMT |
|
Offered Amount |
This is a number representing the dollar amount of a financial aid award (Item Type) offered to a student. |
PS_F_AWD_DISB.OFFERED_AMT |
Item Class
This table describes the Item Class in the Award Disbursement business area:
|
Item Class Name |
Item Name |
|
List of Previous Business Units |
Business Unit |
Hierarchy
This table describes the Hierarchy in the Award Disbursement business area:
|
Hierarchy |
Column |
Description |
|
Term Hierarchy |
This is the term hierarchy by Institution, Career, and Term |
PS_D_TERM.TERM_SD |
|
Student Financials - Institution |
This is the institution hierarchy by Institution and Career. |
PS_D_ACAD_CAR.INSTITUTION_SD |
Student Financial Services - Award Snapshot Business Area
The Award Snapshot business area contains periodical snapshots of the award amounts and counts. The period is user determined and can be a week, month, quarter, and so on. This Business Area answers questions such as:
What were the types of award and which student received it?
A summary of any particular student awards for a specific time.
How many awards, by type, were awarded by institution?
This section describes the contents of the Activity Cost business area.
Dimension Folders
This table lists the dimension folders in the Award Snapshot business area:
|
Folder |
Description |
Table |
|
Dimension Academic Career |
This dimension represents all academic careers that an institution offers. This the specific career for the award recipient. |
PS_D_ACAD_CAR |
|
Dimension Aid Year |
This contains the details about the federal aid year. |
PS_D_AID_YR |
|
Dimension Award Status |
This categorizes the status of a financial aid award as Accepted/Offered/Authorized etc., |
PS_D_AWD_STAT |
|
Dimension Day Application Received Date |
The day dimension. |
PS_D_DAY |
|
Dimension Day Application Status Date |
The day dimension. |
PS_D_DAY |
|
Dimension Day Snapshot Date |
A role-playing dimension based on dimension day used for snapshot date. |
PS_D_DAY |
|
Dimension Federal Aid Application |
This contains attributes necessary to maintain the FAFSA (Free Application for Federal Student Aid) application and changes to Institutional Student Information Record (ISIR) data. |
PS_D_FED_AID_APP |
|
Dimension Financial Aid Item Type |
This contains attributes that may be associated with financial aid item types, used to define the type of financial aid award. |
PS_D_FA_ITEM_TYPE |
|
Dimension Financial Aid Type |
This contains the category or type of financial aid offered via an Financial Aid Item Type |
PS_D_FIN_AID_TYPE |
|
Dimension Institution |
This dimension represents all the academic institutions. |
PS_D_INSTITUTION |
|
Dimension Person |
This dimension represents the most current personal information of both employees and non-employees of an organization. |
PS_D_PERSON |
|
Dimension Student Aid Attributes |
This contains a record for each student applying for aid and contains the attributes, high level information relating to the application, awarding and processing of financial aid for the year. The status fields indicate if aid-processing st |
PS_D_STU_AID_ATTR |
Fact Folder
This table lists the fact folder in the Award Snapshot business area:
|
Folder |
Description |
Table |
|
Fact Award Snapshot |
This periodic snapshot summary table provides award amount and count of awards issued. The frequency at which this table is loaded determines the snapshot period. |
PS_F_AWD_SNPSHT |
Metrics
This table lists the metrics in the Award Snapshot business area:
|
Metric Name |
Description |
Database Object Name |
|
Accepted Amount |
This is a number representing the dollar amount of a financial aid award (Item Type) accepted by a student. |
PS_F_AWD_SNPSHT.ACCEPTED_AMT |
|
Authorized Amount |
This is a number representing the dollar amount of a financial aid award (Item Type) which has been authorized to be disbursed to a student. |
PS_F_AWD_SNPSHT.AUTHORIZED_AMT |
|
Award Count |
A number representing the count of financial aid award to a student. This can represent the offered, disbursed, accepted or authorized amount depending on the award status |
PS_F_AWD_SNPSHT.AWD_CNT |
|
Disbursed Amount |
This is a number representing the total dollar amount of a financial aid award (Item Type) which was disbursed to a student. |
PS_F_AWD_SNPSHT.DISBURSED_AMT |
|
Offered Amount |
This is a number representing the dollar amount of a financial aid award (Item Type) offered to a student. |
PS_F_AWD_SNPSHT.OFFERED_AMT |
Hierarchy
This table lists the hierachies available in the Award Snapshot business area:
|
Hierarchy |
Column |
Description |
|
Snapshot Date |
Snapshot Day --> Snapshot Month --> Snapshot Quarter --> Snapshot Year |
PS_D_DAY.DAY_DT |
|
Student Financials - Institution |
This is the institution hierarchy by Institution and Career. |
PS_D_ACAD_CAR.INSTITUTION_SD |
Student Financial Services − Bill Summary Business Area
The Bill Summary business area contains data relating to the academic costs incurred by a Student or an external organization. The Bill Summary Snapshot business area contains accumulative snapshots of the bill amounts and counts. The period is user determined and can be a week, month, quarter, and so on.
This section describes the content of the Bill Summary business area.
Dimension Folders
This table lists the dimension folders in the Bill Summary business area:
|
Folder |
Description |
Table |
|
Dimension Academic Career |
This dimension represents all academic careers that an institution offers. |
PS_D_ACAD_CAR |
|
Dimension Academic Level |
This dimension represents the academic level associated with a Student. for e.g. First Year, Second Year, Freshman, Sophomore etc. |
PS_D_ACAD_LVL |
|
Dimension Academic Plan |
This dimension represents all the academic plans within an academic program of an institution. |
PS_D_ACAD_PLAN |
|
Dimension Academic Program |
This dimension represents all the academic programs of an institution. |
PS_D_ACAD_PROG |
|
Dimension Business Unit Student Financials |
This is a role playing dimension based on Dimension Business Unit and used to store student financials business units. |
PS_D_BUSINESS_UNIT |
|
Dimension Day Snapshot Date |
A role-playing dimension based on dimension day used for snapshot date. |
PS_D_DAY |
|
Dimension External Organization |
The external organization dimension. It defines the external organizations for posting external education data and the last school attended for admissions applicant data. |
PS_D_EXT_ORG |
|
Dimension Person |
This dimension represents the most current personal information of both employees and non-employees of an organization. |
PS_D_PERSON |
Fact Folder
This table lists the fact folder in the Bill Summary business area:
|
Folder |
Description |
Table |
|
Fact Bill Snapshot |
This contains the (billing) summary information of billed and paid amounts. |
PS_F_BIL_SNPSHT |
Metrics
This table lists the metrics available in the Bill Summary business area:
|
Metric Name |
Description |
Database Object Name |
|
Late Payment Count |
This is the count of bills that has been paid beyond the bill due date as of the snapshot date for a student or external organization. |
PS_F_BIL_SNPSHT.LATE_PYMNT_CNT |
|
Overdue Bill Count |
This is the count of overdue bills that has not been paid as of the snapshot date for a student or external organization. |
PS_F_BIL_SNPSHT.OVERDUE_BILL_CNT |
|
Total Bill Amount |
The amount billed to a student or external org in an invoice. This amount is represented with the transaction currency. |
PS_F_BIL_SNPSHT.TOT_BILL_AMT |
|
Total Paid Amount |
The payment made by a student or external org against an invoice. This amount is represented with the transaction currency. |
PS_F_BIL_SNPSHT.TOT_PAID_AMT |
Item Class
This table lists the item class available in the Bill Summary business area:
|
Item Class Name |
Item Name |
|
List of Previous Business Units |
Business Unit |
Hierarchy
This table lists the hierarchies available in the Bill Summary business area:
|
Hierarchy |
Column |
Description |
|
Academic Plan Alternate Hierarchy |
This is the academic plan hierarchy by Institution, Group Program and Plan. |
PS_D_ACAD_PLAN.ACAD_PLAN_SD |
|
Academic Plan Hierarchy |
This is the academic plan hierarchy by Institution, Career, Program and Plan. |
PS_D_ACAD_PLAN.ACAD_PLAN_SD |
|
Academic Program Alternate Hierarchy |
This is the academic program hierarchy by Institution, Group and Program |
PS_D_ACAD_PROG.ACAD_PROG_SD |
|
Academic Program Hierarchy |
This is the academic program hierarchy by Institution, Career, and Program |
PS_D_ACAD_PROG.ACAD_PROG_SD |
|
Snapshot Date |
Snapshot Day --> Snapshot Month --> Snapshot Quarter --> Snapshot Year |
PS_D_DAY.DAY_DT |
|
Student Financials - Institution |
This is the institution hierarchy by Institution and Career. |
PS_D_ACAD_CAR.INSTITUTION_SD |
Student Financial Services − Pending Payments Business Area
The Pending Payments business area contains the information about student’s payments, charges and payments balance. The information can be seen organized by Institution, Career and Term. This Business Area answers questions such as:
What was the amount of charges for a particular student for a term?
What was the amount of payments received against pending invoices for a particular student?
This section describes the content in the Pending Payments business area.
Dimension Folders
This table lists the dimension folders in the Pending Payments business area:
|
Folder |
Description |
Table |
|
Dimension Business Unit Student Financials |
This is a role playing dimension based on Dimension Business Unit and used to store student financials business units. |
PS_D_BUSINESS_UNIT |
|
Dimension External Organization |
The external organization dimension. It defines the external organizations for posting external education data and the last school attended for admissions applicant data. |
PS_D_EXT_ORG |
|
Dimension Person |
This dimension represents the most current personal information of both employees and non-employees of an organization. |
PS_D_PERSON |
|
Dimension Term |
This dimension represents all the academic terms of an institution. |
PS_D_TERM |
|
Dimension Year Academic |
The academic year role playing dimension based on the year dimension. |
PS_D_YEAR |
Fact Folder
This table lists the fact folder in the Pending Payments business area:
|
Folder |
Description |
Table |
|
Fact Pending Payments |
This contains the amount charged by the institution and amount paid by the student or external organization, for that charge. |
PS_F_PYMNT_PENDING |
Metrics
This table lists the metrics in the Pending Payments business area:
|
Metric Name |
Description |
Database Object Name |
|
Charge Amount |
The amount of payments made by a student or external organization against an invoice. This amount is represented with the transaction currency. |
PS_F_PYMNT_PENDING.CHRG_AMT |
|
Payment Amount |
The amount billed to a student or external organization in an invoice. This amount is represented with the transaction currency. |
PS_F_PYMNT_PENDING.PYMNT_AMT |
Item Class
This table lists the item class for the Pending Payments business area:
|
Item Class Name |
Item Name |
|
List of Previous Business Units |
Business Unit |
Hierarchy
This table lists the hierarchy in the Pending Payments business area:
|
Hierarchy |
Column |
Description |
|
Term Hierarchy |
This is the term hierarchy by Institution, Career, and Term |
PS_D_TERM.TERM_SD |
Student Financial Services − Student Financials Transaction Business Area
The Student Financials Transaction business area contains specific financial transaction information for a student or an external organization. These transactions can either be a charge transaction or a payment transaction. This Business Area answers questions about the institutions financial transactions with several hierarchies of drill down.
This section describes the content in the Student Financial Transaction business area.
Dimension Folders
This table lists the dimension folders in the Student Financials Transaction business area:
|
Folder |
Description |
Table |
|
Dimension Academic Career |
This dimension represents all academic careers that an institution offers. |
PS_D_ACAD_CAR |
|
Dimension Account Term |
This dimension table contains codes used to indicate the status for a bill in student financials. Sample status values are cancelled and initiated. |
PS_D_ACCT_TERM |
|
Dimension Account Type |
This dimension table contains codes used to indicate the status for a bill in student financials. Sample status values are cancelled and initiated. |
PS_D_ACCT_TYPE |
|
Dimension Aid Year |
This contains the details about the federal aid year. |
PS_D_AID_YR |
|
Dimension Business Unit Student Financials |
This is a role-playing dimension based on Dimension Business Unit and used to store student financials business units. |
PS_D_BUSINESS_UNIT |
|
Dimension Day Actual Billed Date |
The actual billed date role-playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension Day Billed Date |
The billed date role-playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension Day Disbursement Date |
The disbursement date role-playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension Day Transaction Due Date |
The transaction due date role-playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension Day Transaction Paid Date |
The transaction paid date role-playing dimension based on the day dimension. |
PS_D_DAY |
|
Dimension External Organization |
The external organization dimension. It defines the external organizations for posting external education data and the last school attended for admissions applicant data. |
PS_D_EXT_ORG |
|
Dimension Item Type |
This dimension table contains codes used to indicate the status for a bill in student financials. Sample status values are cancelled and initiated. |
PS_D_ITEM_TYPE |
|
Dimension Person |
This dimension represents the most current personal information of both employees and non-employees of an organization. |
PS_D_PERSON |
|
Dimension Year Academic |
The academic year role-playing dimension based on the year dimension. |
PS_D_YEAR |
|
Dimension Year Calendar |
The calendar year role-playing dimension based on the year dimension. |
PS_D_YEAR |
Fact Folder
This table lists the fact folder in the Student Financials Transaction business area:
|
Folder |
Description |
Table |
|
Fact Student Financials Transactions |
This contains the details of student financial transactions such as charges, payments, reversals, refund etc., |
PS_F_SF_TRAN |
Metrics
This table lists the metrics in the Employee Student Financials Transaction business area:
|
Metric Name |
Description |
Database Object Name |
|
Encumbered Amount |
The amount of payments made by a student or external organization against an invoice. This amount is represented with the transaction currency. |
PS_F_SF_TRAN.ENCMBRD_AMT |
|
Paid Amount |
The amount paid by a student or external organization. This amount is represented with the transaction currency. |
PS_F_SF_TRAN.PAID_AMT |
|
Transaction Amount |
The amount associated with a student financial transaction. This amount is represented with the transaction currency. |
PS_F_SF_TRAN.TRAN_AMT |
Item Class
This table lists the item class for the Pending Payments business area:
|
Item Class Name |
Item Name |
|
List of Previous Business Units |
Business Unit |
Hierarchy
This table lists the hierarchy in the Pending Payments business area:
|
Hierarchy |
Column |
Description |
|
Student Financials - Actual Billed Date |
Actual Billed Day --> Actual Billed Month --> Actual Billed Quarter --> Actual Billed Year |
PS_D_DAY.DAY_DT |
|
Student Financials - Billed Date |
Billed Day --> Billed Month --> Billed Quarter --> Billed Year |
PS_D_DAY.DAY_DT |
|
Student Financials - Disbursement Date |
Disbursement Day --> Disbursement Month --> Disbursement Quarter --> Disbursement Year |
PS_D_DAY.DAY_DT |
|
Student Financials - Transaction Due Date |
Transaction Due Day --> Transaction Due Month --> Transaction Due Quarter --> Transaction Due Year |
PS_D_DAY.DAY_DT |
|
Student Financials - Transaction Paid Date |
Transaction Paid Day --> Transaction Paid Month --> Transaction Paid Quarter --> Transaction Paid Year |
PS_D_DAY.DAY_DT |
|
Student Financials - Institution |
This is the institution hierarchy by Institution and Career. |
PS_D_ACAD_CAR.INSTITUTION_SD |