Created by Corina C Larsen, last modified on Nov 14, 2017
Search Tags: McGladrey, production
JIRA Reference:
REPORT-224
-
New views and table for McGladrey Project
Closed
Table Purpose
The PS_UM_CLASSREV_VW view was created to run the SQL code used to select all the class revenue information associated with each student's enrollment for terms >= 1230. This view used the PS_UM_FEECLASS_CUR view to generate the class revenue.
Table Location
This PeopleSoft table is located in the CS Reporting database.
| Key | Record.Fieldname | Format | XLAT | Heading Text |
| ACAD_CAREER - Academic Career | Char4 | N | Career | |
| ACAD_GROUP - Academic Group | Char5 | Acad Group | ||
| ACAD_ORG - Academic Organization | Char10 | Acad Org | ||
| ASSOCIATED_CLASS - Associated Class | Num4.0 | Assoc | ||
| CATALOG_NBR - Catalog Nbr | Char10 | Catalog | ||
| → | CLASS_NBR - Class Nbr | Num5.0 | Class Nbr | |
| CLASS_SECTION - Class Section | Char4 | Section | ||
| CLASS_TYPE - Class Type | Char1 | N | Class Type | |
| COMBINED_SECTION - Combined Section | Char1 | N | Comb Sect | |
| COURSE_TITLE - Course Title | Char30 | Title | ||
| CRSE_CAREER - Course Career | Char4 | Course Car | ||
| CRSE_ID - Course ID | Char6 | Course ID | ||
| CRSE_OFFER_NBR - Course Offering Nbr | Num2.0 | Offer Nbr | ||
| CRS_TOPIC_ID - Course Topic ID | Num3.0 | Topic ID | ||
| → | EMPLID - Empl ID | Char11 | ID | |
| ENRL_ADD_DT - Enrollment Add Date | Date | Add Dt | ||
| ENRL_DROP_DT - Enrollment Drop Date | Date | Drop Dt | ||
| ENRL_STATUS_REASON - Enrollment Status Reason | Char4 | N | Reason | |
| → | INSTITUTION - Academic Institution | Char5 | Institution | |
| → | SESSION_CODE - Session | Char3 | N | Session |
| STDNT_ENRL_STATUS - Student Enrollment Status | Char2 | N | Status | |
| → | STRM - Term | Char4 | Term | |
| SUBJECT - Subject Area | Char8 | Subject | ||
| SUBJECT_DESCR - Subject Description | Char30 | Subject | ||
| TERM_BEGIN_DT - Term Begin Date | Date | Begin Date | ||
| TERM_END_DT - Term Ending Date | Date | End Date | ||
| TUITION_RES - Tuition Residency | Char5 | Tuition | ||
| UM_ACAD_GROUP_DESC - Academic Group Descr | Char30 | Acad Group | ||
| UM_ACAD_ORG_DESCR - Academic Organization Descript | Char30 | Acad Org Dsecr | ||
| UM_AFTER_TERM_END - Class ends after term end | Char1 | After Term Ends | ||
| UM_CLASS_CAMPUS - Class Campus | Char5 | Class Campus | ||
| UM_CLASS_CAMP_DESC - Class Campus Descr | Char30 | Class Campus | ||
| UM_CLASS_COMPONENT - Class Component | Char3 | Class Component | ||
| UM_CLASS_COMP_DESC - Class Component Descr | Char30 | Class Component | ||
| UM_CLASS_END_DT - Class End Date | Date | Class End Dt | ||
| UM_CLASS_ID - Class ID | Char10 | Class ID | ||
| UM_CLASS_START_DT - Class Start Date | Date | Class Start Dt | ||
| UM_CLASS_TYPE_DESC - Class Type Description | Char30 | Class Type | ||
| UM_COLLEGE_LVL - College Level | Char20 | College Level | ||
| UM_COLL_LVL_DESCR - College Level Description | Char30 | College Level | ||
| UM_COMB_SECT_ID - Combined Section ID | Char4 | Comb Sect ID | ||
| UM_COURSE_FEES_AMT - Course Fee | SNm18.2 | Course Fee | ||
| UM_DEPARTMENT_LVL - Department Level | Char20 | Department Leve | ||
| UM_DEPT_LVL_DESCR - Department Level Descr | Char30 | Dept Level | ||
| UM_DIVISION_LVL - Division Level | Char20 | Division Levl | ||
| UM_DIV_LVL_DESCR - Division Level Descr | Char30 | Division Level | ||
| UM_FREE_FORM_TOPIC - Free Format Topic | Char30 | Free Form Topic | ||
| UM_PRIM_COMPONENT - Primary Component | Char3 | Prim Component | ||
| UM_PRIM_COMP_CLASS - Primary Component Class | Char8 | Prim Comp Class | ||
| UM_PRIM_INSTR_SECT - Primary Section | Char4 | Primary Section | ||
| UM_PRIM_SECTION - Primary Section | Char1 | Prim Section | ||
| UM_PROGRAM_FEE_AMT - Program Fee | SNm18.2 | Program Fee | ||
| UM_PROGRAM_LVL - Program Level | Char20 | Program Level | ||
| UM_PROG_LVL_DESCR - Program Level Descr | Char30 | Program Level | ||
| UM_SCHL_LVL_DESCR - School Level Description | Char30 | School Level | ||
| UM_SCHOOL_LVL - School Level | Char20 | School Level | ||
| UM_SESSION_DESCR - Session Description | Char30 | Session Descr | ||
| UM_STU_ENRL_STAT - Student Enroll Status Descr | Char30 | Stu Enrl Status | ||
| UM_SUBJECT_LVL - Subject Level | Char20 | Subject Level | ||
| UM_SUBJ_LVL_DESCR - Subject Level Descr | Char30 | Subject Level | ||
| UM_TOPIC_NAME - Topic | Char30 | Topic | ||
| UM_TUITION_AMT - Tuition Amount | SNm18.2 | Tuition Amt | ||
| UM_TUT_RESID_DESCR - Tuition Residency | Char30 | Tuit Residency | ||
| UM_UNIVERSITY_LVL - University Level | Char20 | University Leve | ||
| UM_UNIV_LVL_DESCR - University Level Description | Char30 | Univ Level | ||
| UNT_BILLING - Billing Units | Num4.2 | Bill Units | ||
| UNT_PRGRSS - Units Taken-Academic Progress | Num4.2 | Progress | ||
| UNT_PRGRSS_FA - Units Taken-Fin Aid Progress | Num4.2 | FA Progress | ||
| UNT_TAKEN - Units Taken | SNm5.2 | Unit Taken |