STDNT_GRADE_RPT(SQL Table) |
Index Back |
---|---|
Output for Student Grade RptOutput table for the Student Grade report. Populated by SRGRDRPT.SQR and used by sr776---.rpt, a Crystal Report. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | SEQUENCE_NBR_6 | Number(6,0) | INTEGER NOT NULL | Sequence |
4 | LINE_SEQUENCE_NBR | Number(3,0) | SMALLINT NOT NULL | Line Sequence |
5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
6 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
7 | DESCR_INSTITUTION | Character(30) | VARCHAR2(30) NOT NULL | Description |
8 | DESCR_TERM | Character(30) | VARCHAR2(30) NOT NULL | Description |
9 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
10 | DESCR_CAREER | Character(30) | VARCHAR2(30) NOT NULL | Description |
11 | DESCR_PROG | Character(30) | VARCHAR2(30) NOT NULL | Description |
12 | DESCR_STDNT_GROUP | Character(30) | VARCHAR2(30) NOT NULL | Description |
13 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |
14 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
15 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
16 | SESSION_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Session
1=Regular Academic Session 10W=10 Week 12W=Twelve Week 4W1=Four Week - First 4W2=Four Week - Second 4W3=Four Week - Third 4W4=Four Week - Fourth 6W1=Six Week - First 6W2=Six Week - Second 8W1=Eight Week - First 8W2=Eight Week - Second A11=Medical Period 1, 4 Weeks A12=Medical Period 1, 8 Weeks A13=Medical Pd 1, 12 Weeks A21=Medical Period 2, 4 Weeks A22=Medical Period 2, 8 Weeks A23=Medical Period 2, 12 Week FYR=Full Year MIN=Mini Session OEE=Open Entry/Open Exit SM1=Semester 1 SM2=Semester 2 |
17 | CLASS_SECTION | Character(4) | VARCHAR2(4) NOT NULL | Class Section |
18 | CLASS_TOPIC | Character(30) | VARCHAR2(30) NOT NULL | Description |
19 | CLASS_MTG_NBR | Number(2,0) | SMALLINT NOT NULL | Class Meeting Pattern Nbr |
20 | SSR_COMPONENT | Character(3) | VARCHAR2(3) NOT NULL |
Course Component.
CLN=Clinical CON=Continuance DIS=Discussion FLD=Field Studies IND=Independent Study LAB=Laboratory LEC=Lecture PRA=Practicum RSC=Research SEM=Seminar SUP=Supervision THE=Thesis Research TUT=Tutorial |
21 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
22 | START_DT | Date(10) | DATE | Start Date |
23 | END_DT | Date(10) | DATE | end date |
24 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |
25 | UNT_TAKEN | Number(6,2) | DECIMAL(5,2) NOT NULL | Units Taken |
26 | CRSE_GRADE_OFF | Character(3) | VARCHAR2(3) NOT NULL | Official Grade |
27 | GRADE_POINTS | Number(10,3) | DECIMAL(9,3) NOT NULL | Grade Points |
28 | UNT_INPROG_GPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Units In Progress - GPA |
29 | TOT_INPROG_GPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Total In Progress - GPA |
30 | UNT_INPROG_NOGPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Unit In Progress - Not for GPA |
31 | TOT_INPROG_NOGPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Total In Progress -Not for GPA |
32 | UNT_TAKEN_GPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Units Taken Toward GPA |
33 | TOT_TAKEN_GPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Cumulative Units for GPA of Enrollments and Transfer Credits |
34 | UNT_TAKEN_NOGPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Units Taken Not Toward GPA |
35 | TOT_TAKEN_NOGPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Total Taken Not Toward GPA |
36 | UNT_PASSD_GPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Units Passed Toward GPA |
37 | TOT_PASSD_GPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Total Passed Toward GPA |
38 | UNT_PASSD_NOGPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Units Passed Not Toward GPA |
39 | TOT_PASSD_NOGPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Total Passed Not Toward GPA |
40 | TERM_GRADE_POINTS | Number(10,3) | DECIMAL(9,3) NOT NULL | Grade Points |
41 | TOT_GRADE_POINTS | Number(10,3) | DECIMAL(9,3) NOT NULL | Cumulative Grade Points of Enrollment and Transfer Credits |
42 | CUR_GPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Current GPA |
43 | CUM_GPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Cumulative GPA |