UM_D_STD_ENRL

Body

This table is updated by the daily process of UM_STUCRSTAB (Application Engine).  This page is restricted to the members of DARTS since it is not available in Query Manager. (Query users can use UM_D_STD_ENR_VW - Student Enrollment Table

Detailed Information 

Most data is from STDNT_ENRL - Student Enrollment Table and CLASS_TBL - Class Table.

Currently, the data is refreshed daily from STRM=1930 forward

Data Systems

  • PeopleSoft Campus Solutions Production CSPRD
  • PeopleSoft Campus Solutions Reporting CSRPT

View Application Engine Build Code
Download Application Engine Build Code

Column order  Name Type Nullable
2 ACAD_CAREER VARCHAR2(4)  
65 ACAD_GROUP VARCHAR2(5)  
89 ACAD_ORG VARCHAR2(10)  
61 ACAD_PROG VARCHAR2(5)  
29 ASSOCIATED_CLASS INTEGER  
40 ASSOCIATION_99 VARCHAR2(1)  
30 AUDIT_GRADE_BASIS VARCHAR2(1)  
74 CAMPUS VARCHAR2(5)  
67 CATALOG_NBR VARCHAR2(10)  
5 CLASS_NBR INTEGER  
64 CLASS_SECTION VARCHAR2(4)  
71 CLASS_STAT VARCHAR2(1)  
72 CLASS_TYPE VARCHAR2(1)  
6 CRSE_CAREER VARCHAR2(4)  
20 CRSE_COUNT NUMBER(4,2)  
25 CRSE_GRADE_INPUT VARCHAR2(3)  
24 CRSE_GRADE_OFF VARCHAR2(3)  
62 CRSE_ID VARCHAR2(6)  
63 CRSE_OFFER_NBR INTEGER  
68 DESCR VARCHAR2(30)  
77 DESCR_LOCATION VARCHAR2(30)  
39 DROP_CLASS_IF_ENRL INTEGER  
48 DYN_CLASS_NBR INTEGER  
31 EARN_CREDIT VARCHAR2(1)  
1 EMPLID VARCHAR2(11)  
10 ENRL_ACTION_LAST VARCHAR2(2)  
12 ENRL_ACTN_PRC_LAST VARCHAR2(2)  
11 ENRL_ACTN_RSN_LAST VARCHAR2(4)  
14 ENRL_ADD_DT DATE Y
88 ENRL_CAP INTEGER  
15 ENRL_DROP_DT DATE Y
56 ENRL_REQ_SOURCE VARCHAR2(2)  
70 ENRL_STAT VARCHAR2(1)  
9 ENRL_STATUS_REASON VARCHAR2(4)  
82 FIRST_NAME VARCHAR2(30)  
46 GRADE_CATEGORY VARCHAR2(4)  
26 GRADE_DT DATE Y
34 GRADE_POINTS NUMBER(9,3)  
35 GRADE_POINTS_FA NUMBER(9,3)  
22 GRADING_BASIS_DT DATE Y
21 GRADING_BASIS_ENRL VARCHAR2(3)  
58 GRADING_SCHEME_ENR VARCHAR2(3)  
36 GRD_PTS_PER_UNIT NUMBER(9,3)  
32 INCLUDE_IN_GPA VARCHAR2(1)  
3 INSTITUTION VARCHAR2(5)  
76 INSTRUCTION_MODE VARCHAR2(2)  
38 INSTRUCTOR_ID VARCHAR2(11)  
54 LAST_DROP_DT_STMP DATE Y
55 LAST_DROP_TM_STMP TIMESTAMP(6) Y
52 LAST_ENRL_DT_STMP DATE Y
53 LAST_ENRL_TM_STMP TIMESTAMP(6) Y
81 LAST_NAME VARCHAR2(30)  
50 LAST_UPD_DT_STMP DATE Y
57 LAST_UPD_ENREQ_SRC VARCHAR2(2)  
51 LAST_UPD_TM_STMP TIMESTAMP(6) Y
75 LOCATION VARCHAR2(10)  
37 MANDATORY_GRD_BAS VARCHAR2(1)  
83 MIDDLE_NAME VARCHAR2(30)  
84 NAME_PREFIX VARCHAR2(4)  
85 NAME_SUFFIX VARCHAR2(15)  
43 NOTIFY_STDNT_CHNG VARCHAR2(2)  
23 OVRD_GRADING_BASIS VARCHAR2(1)  
59 RELATE_CLASS_NBR_1 INTEGER  
60 RELATE_CLASS_NBR_2 INTEGER  
44 REPEAT_CANDIDATE VARCHAR2(1)  
27 REPEAT_CODE VARCHAR2(4)  
28 REPEAT_DT DATE Y
91 SCTN_COMBINED_ID VARCHAR2(4)  
47 SEL_GROUP VARCHAR2(10)  
7 SESSION_CODE VARCHAR2(3)  
69 SSR_COMPONENT VARCHAR2(3)  
13 STATUS_DT DATE  
8 STDNT_ENRL_STATUS VARCHAR2(2)  
73 STDNT_SPEC_PERM VARCHAR2(1)  
4 STRM VARCHAR2(4)  
66 SUBJECT VARCHAR2(8)  
42 TSCRPT_NOTE_EXISTS VARCHAR2(1)  
41 TSCRPT_NOTE_ID VARCHAR2(4)  
90 UM_ACAD_ORG_DESCR VARCHAR2(30)  
79 UM_CENTER_CD VARCHAR2(4)  
80 UM_CENTER_DESCR VARCHAR2(25)  
86 UM_DIST_ATTR_FLAG VARCHAR2(2)  
78 UM_DISTANCE_FLAG VARCHAR2(2)  
87 UM_IMODE VARCHAR2(10)  
94 UNITS_ACAD_PROG NUMBER(5,2)  
33 UNITS_ATTEMPTED VARCHAR2(1)  
93 UNITS_MAXIMUM NUMBER(5,2)  
92 UNITS_MINIMUM NUMBER(5,2)  
19 UNT_BILLING NUMBER(5,2)  
49 UNT_EARNED NUMBER(5,2)  
17 UNT_PRGRSS NUMBER(5,2)  
18 UNT_PRGRSS_FA NUMBER(5,2)  
16 UNT_TAKEN NUMBER(5,2)  
45 VALID_ATTEMPT VARCHAR2(1)  

 

Details

Details

Article ID: 158919
Created
Fri 5/10/24 4:28 AM
Modified
Mon 9/16/24 4:22 PM
Applies To
Faculty
Staff
Community

Related Services / Offerings

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)

Attachments

Attachments (1) Sort By: Sort Attachments ByName Sort Attachments ByDate

txt

SQL for UM_STUCRSTAB (creates UM_D_STD_ENR).txt Computer

Mon 9/16/24 3:21 PM
View
;