Created by Corina C Larsen, last modified by Miki Yanagi on Jun 12, 2020
View of the extracted table of student course information, updated only on the census dates. This table returns results quickly, and is very good for doing historical reporting based on census figures.
App Engine Program (UM_STUCRSCEN) creates this table based on UM_STD_ENR_ARC table.
| Key | Record.Fieldname | Format | XLAT | Heading Text | Notes |
|---|---|---|---|---|---|
| → | ACAD_CAREER - Academic Career | Char4 | Career | ||
| ACAD_GROUP - Academic Group | Char5 | Acad Group | |||
| ACAD_ORG - Academic Organization | Char10 | Acad Org | |||
| ACAD_PROG - Academic Program | Char5 | Acad Prog | |||
| ASSOCIATED_CLASS - Associated Class | Num4.0 | Assoc | |||
| ASSOCIATION_99 - Association 99 | Char1 | Assoc 99 | |||
| AUDIT_GRADE_BASIS - Audit Grading Basis | Char1 | Audit | |||
| CAMPUS - Campus | Char5 | Campus | |||
| → | CATALOG_NBR - Catalog Nbr | Char10 | Catalog | CATALOG_NBR field values begin with a space (eg. ' 101'), most likely to insert a space between SUBJECT and CATALOG_NBR (eg. 'ENG 101'). | |
| → | CENSUS_DT - Census Date | Date | Census Dt | ||
| CLASS_NBR - Class Nbr | Num5.0 | Class Nbr | |||
| CLASS_SECTION - Class Section | Char4 | Section | |||
| CLASS_STAT - Class Status | Char1 | N | Class Stat | ||
| CLASS_TYPE - Class Type | Char1 | N | Class Type | ||
| CRSE_CAREER - Course Career | Char4 | Course Car | |||
| CRSE_COUNT - Course Count | Num3.2 | Crse Count | |||
| CRSE_GRADE_INPUT - Grade Input | Char3 | Grade In | |||
| CRSE_GRADE_OFF - Official Grade | Char3 | Grade | |||
| → | CRSE_ID - Course ID | Char6 | Course ID | ||
| → | CRSE_OFFER_NBR - Course Offering Nbr | Num2.0 | Offer Nbr | ||
| DESCR - Description | Char30 | Descr | |||
| DESCR_LOCATION - Location Description | Char30 | Description | |||
| DROP_CLASS_IF_ENRL - Drop This Class if Enrolled | Num5.0 | Drop if Enroll | |||
| DYN_CLASS_NBR - Dynamic Class Nbr | Num5.0 | Dyn Class Nbr | |||
| EARN_CREDIT - Earn Credit | Char1 | EarnCredit | |||
| → | EMPLID - Empl ID | Char11 | ID | ||
| ENRL_ACTION_LAST - Last Enrollment Action | Char2 | Last Act | |||
| ENRL_ACTN_PRC_LAST - Last Enrollment Action Process | Char2 | Process | |||
| ENRL_ACTN_RSN_LAST - Last Enrl Action Reason | Char4 | Reason | |||
| ENRL_ADD_DT - Enrollment Add Date | Date | Add Dt | |||
| ENRL_CAP - Enrollment Capacity | Num4.0 | Cap Enrl | |||
| ENRL_DROP_DT - Enrollment Drop Date | Date | Drop Dt | |||
| ENRL_REQ_SOURCE - Enrollment Request Source | Char2 | N | Source | ||
| ENRL_STAT - Enrollment Status | Char1 | N | Enrl Stat | ||
| ENRL_STATUS_REASON - Enrollment Status Reason | Char4 | N | Reason | ||
| FIRST_NAME - First Name | Char30 | First Name | |||
| GRADE_CATEGORY - Grade Category | Char4 | N | Grade Category | ||
| GRADE_DT - Grade Date | Date | Grade Dt | |||
| GRADE_POINTS - Grade Points | Num7.3 | Grd Points | |||
| GRADE_POINTS_FA - Financial Aid Grade Points | Num7.3 | FA Grd Pt | |||
| GRADING_BASIS_DT - Grading Basis Date | Date | Basis Dt | |||
| GRADING_BASIS_ENRL - Grading Basis | Char3 | Grade Base | |||
| GRADING_SCHEME_ENR - Field is not active yet | Char3 | Field not activ | |||
| GRD_PTS_PER_UNIT - Grade Points Per Unit | Num7.3 | Grd Pt/Unt | |||
| INCLUDE_IN_GPA - Include in GPA | Char1 | Incl GPA | |||
| → | INSTITUTION - Academic Institution | Char5 | Institution | ||
| INSTRUCTION_MODE - Instruction Mode | Char2 | Mode | |||
| INSTRUCTOR_ID - Instructor ID | Char11 | Instructor | |||
| LAST_DROP_DT_STMP - Last Drop Date Stamp | Date | Last Drop Date | |||
| LAST_DROP_TM_STMP - Last Drop Time Stamp | Time | Last Drop Time | |||
| LAST_ENRL_DT_STMP - Last Enrollment Date Stamp | Date | Last Enrl Date | |||
| LAST_ENRL_TM_STMP - Last Enrollment Time Stamp | Time | Last Enrl Time | |||
| LAST_NAME - Last Name | Char30 | Last | |||
| LAST_UPD_DT_STMP - Last Update Date Stamp | Date | Last Upd Date | |||
| LAST_UPD_ENREQ_SRC - Enrollment Request Source | Char2 | N | Source | ||
| LAST_UPD_TM_STMP - Last Update Time Stamp | Time | Last Upd Time | |||
| LOCATION - Location Code | Char10 | Location | |||
| MANDATORY_GRD_BAS - Mandatory Grading Basis | Char1 | Mandatory | |||
| MIDDLE_NAME - Middle Name | Char30 | Middle | |||
| NAME_PREFIX - Name Prefix | Char4 | Prefix | |||
| NAME_SUFFIX - Name Suffix | Char15 | Suffix | |||
| NOTIFY_STDNT_CHNG - Notify Student of Change | Char2 | N | Notify Student | ||
| OVRD_GRADING_BASIS - Override Grading Basis | Char1 | Grading Basis | |||
| RELATE_CLASS_NBR_1 - Field is not active yet | Num5.0 | Field not activ | |||
| RELATE_CLASS_NBR_2 - Field is not active yet | Num5.0 | Field not activ | |||
| REPEAT_CANDIDATE - Repeat Candidate Flag | Char1 | Rpt Candidat | |||
| REPEAT_CODE - Repeat Code | Char4 | Repeat | |||
| REPEAT_DT - Repeat Date | Date | Repeat Dt | |||
| SCTN_COMBINED_ID - Combined Sections ID | Char4 | Comb Sects ID | |||
| SEL_GROUP - Tuition Group | Char10 | Group | |||
| SESSION_CODE - Session | Char3 | N | Session | ||
| SSR_COMPONENT - Course Component | Char3 | Component | The translation is on psxlatitem. (fieldname ='SSR_COMPONENT') | ||
| STATUS_DT - Status Date | Date | Stat Dt | |||
| STDNT_ENRL_STATUS - Student Enrollment Status | Char2 | N | Status | ||
| STDNT_SPEC_PERM - Student Specific Permissions | Char1 | Stdnt Spec | |||
| → | STRM - Term | Char4 | Term | ||
| SUBJECT - Subject Area | Char8 | Subject | |||
| TSCRPT_NOTE_EXISTS - Transcript Note Exists Flag | Char1 | Tscrpt Ex | |||
| TSCRPT_NOTE_ID - Transcript Note ID | Char4 | Note ID | |||
| UM_ACAD_ORG_DESCR - Academic Organization Descript | Char30 | Acad Org Dsecr | |||
| UM_CENTER_CD - Center Code | Char4 | Center | |||
| UM_CENTER_DESCR - Center Description | Char25 | Center Descr | |||
| UM_DISTANCE_FLAG - Distance Flag | Char2 | Distance Flag | |||
| UM_DIST_ATTR_FLAG - Distance Attribute Flag | Char2 | N | Dist Attr Flag | ||
| UM_IMODE - Imode | Char10 | Imode | |||
| UNITS_ACAD_PROG - Academic Progress Units | Num4.2 | Prgrss Unt | |||
| UNITS_ATTEMPTED - Units Attempted | Char1 | N | Units Att | ||
| UNITS_MAXIMUM - Maximum Units | Num4.2 | Max Units | |||
| UNITS_MINIMUM - Minimum Units | Num4.2 | Min Units | |||
| UNT_BILLING - Billing Units | Num4.2 | Bill Units | |||
| UNT_EARNED - Units Earned | Num4.2 | 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 | |||
| VALID_ATTEMPT - Valid Attempted Grade | Char1 | Valid Attempt |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.
SQL code Expand source
SELECT A.EMPLID
, %DateOut(BB.CENSUS_DT)
, %DateOut(A.ARCHIVE_DT)
, A.ARCHIVE_FLAG
, A.CHANGE_FLG
, A.DELETE_FLAG
, A.ENROL_FLAG
, A.ACAD_CAREER
, A.INSTITUTION
, A.STRM
, A.CLASS_NBR
, A.CRSE_CAREER
, A.SESSION_CODE
, A.STDNT_ENRL_STATUS
, A.ENRL_STATUS_REASON
, A.ENRL_ACTION_LAST
, A.ENRL_ACTN_RSN_LAST
, A.ENRL_ACTN_PRC_LAST
, %DateOut(A.STATUS_DT)
, %DateOut(A.ENRL_ADD_DT)
, %DateOut(A.ENRL_DROP_DT)
, A.UNT_TAKEN
, A.UNT_PRGRSS
, A.UNT_PRGRSS_FA
, A.UNT_BILLING
, A.CRSE_COUNT
, A.GRADING_BASIS_ENRL
, %DateOut(A.GRADING_BASIS_DT)
, A.OVRD_GRADING_BASIS
, A.CRSE_GRADE_OFF
, A.CRSE_GRADE_INPUT
, %DateOut(A.GRADE_DT)
, A.REPEAT_CODE
, %DateOut(A.REPEAT_DT)
, A.ASSOCIATED_CLASS
, A.AUDIT_GRADE_BASIS
, A.EARN_CREDIT
, A.INCLUDE_IN_GPA
, A.UNITS_ATTEMPTED
, A.GRADE_POINTS
, A.GRADE_POINTS_FA
, A.GRD_PTS_PER_UNIT
, A.MANDATORY_GRD_BAS
, A.INSTRUCTOR_ID
, A.DROP_CLASS_IF_ENRL
, A.ASSOCIATION_99
, A.TSCRPT_NOTE_ID
, A.TSCRPT_NOTE_EXISTS
, A.NOTIFY_STDNT_CHNG
, A.REPEAT_CANDIDATE
, A.VALID_ATTEMPT
, A.GRADE_CATEGORY
, A.SEL_GROUP
, A.DYN_CLASS_NBR
, A.UNT_EARNED
, %DateOut(A.LAST_UPD_DT_STMP)
, %TimeOut(A.LAST_UPD_TM_STMP)
, %DateOut(A.LAST_ENRL_DT_STMP)
, %TimeOut(A.LAST_ENRL_TM_STMP)
, %DateOut(A.LAST_DROP_DT_STMP)
, %TimeOut(A.LAST_DROP_TM_STMP)
, A.ENRL_REQ_SOURCE
, A.LAST_UPD_ENREQ_SRC
, A.GRADING_SCHEME_ENR
, A.RELATE_CLASS_NBR_1
, A.RELATE_CLASS_NBR_2
, A.ACAD_PROG
, A.CRSE_ID
, A.CRSE_OFFER_NBR
, A.CLASS_SECTION
, A.ACAD_GROUP
, A.SUBJECT
, A.CATALOG_NBR
, A.DESCR
, A.SSR_COMPONENT
, A.ENRL_STAT
, A.CLASS_STAT
, A.CLASS_TYPE
, A.STDNT_SPEC_PERM
, A.CAMPUS
, A.LOCATION
, A.INSTRUCTION_MODE
, A.DESCR_LOCATION
, A.UM_DISTANCE_FLAG
, A.UM_CENTER_CD
, A.UM_CENTER_DESCR
, A.LAST_NAME
, A.FIRST_NAME
, A.MIDDLE_NAME
, A.NAME_PREFIX
, A.NAME_SUFFIX
, A.UM_DIST_ATTR_FLAG
, A.UM_IMODE
, A.ENRL_CAP
, A.ACAD_ORG
, A.UM_ACAD_ORG_DESCR
, A.SCTN_COMBINED_ID
, A.UNITS_MINIMUM
, A.UNITS_MAXIMUM
, A.UNITS_ACAD_PROG
FROM SYSADM.PS_UM_STD_ENR_ARC A
, PSPRCSRQST AA
, SYSADM.PS_UM_RUN_UMSTUCEN BB
WHERE AA.PRCSNAME = 'UM_STUCRSCEN'
AND BB.OPRID = AA.OPRID
AND BB.RUN_CNTL_ID = AA.RUNCNTLID
AND AA.PRCSINSTANCE = %Bind(PROCESS_INSTANCE)
AND A.STRM = BB.UM_BEGIN_TERM
AND A.ARCHIVE_DT = (
SELECT MAX(A_D.ARCHIVE_DT)
FROM SYSADM.PS_UM_STD_ENR_ARC A_D
WHERE A_D.EMPLID = A.EMPLID
AND A_D.CLASS_NBR = A.CLASS_NBR
AND A_D.CRSE_ID = A.CRSE_ID
AND A_D.CRSE_OFFER_NBR = A.CRSE_OFFER_NBR
AND A_D.CLASS_SECTION = A.CLASS_SECTION
AND A_D.STRM = A.STRM
AND A_D.ACAD_CAREER = A.ACAD_CAREER
AND A_D.INSTITUTION = A.INSTITUTION
AND TRUNC(A_D.ARCHIVE_DT) <= BB.AS_OF_DATE )
AND (A.ARCHIVE_FLAG = 'Y'
OR A.CHANGE_FLG = 'Y')
AND A.STDNT_ENRL_STATUS = 'E'
AND (A.EARN_CREDIT = 'Y'
OR (A.UNITS_ATTEMPTED <> 'N'
AND A.AUDIT_GRADE_BASIS = 'N')
AND A.ENRL_DROP_DT IS NULL )
AND A.ACAD_CAREER <> 'NCRD'