AUD_GRADE(SQL Table) |
Index Back |
---|---|
Grade Audit Rec |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | AUDIT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | The OPRID of the user who made the changes audited on an audit record. |
2 | AUDIT_STAMP | DateTime(26) | TIMESTAMP | Date and Time Stamp |
3 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |
4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
5 | 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 Prompt Table: STDNT_CAREER |
6 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
7 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_TBL |
8 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL |
Class Nbr
Prompt Table: CLASS_TBL_VW |
9 | CRSE_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Course Career
Default Value: CLASS_TBL_VW.ACAD_CAREER |
10 | 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 Default Value: CLASS_TBL_VW.SESSION_CODE |
11 | SESSN_ENRL_CNTL | Character(3) | VARCHAR2(3) NOT NULL | Enrollment Control Session |
12 | STDNT_ENRL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Student Enrollment Status
D=Dropped E=Enrolled W=Waiting Default Value: E |
13 | ENRL_STATUS_REASON | Character(4) | VARCHAR2(4) NOT NULL |
Enrollment Status Reason
ADRP=Administrative Drop ALIM=Appointment Limit Exceeded CANC=Dropped (class cancelled) CREQ=Co-Requisite Enrollment DROP=Dropped (was enrolled) DRWL=Dropped (was wait listed) ENRL=Enrolled EWAT=Enrolled from Wait List FULL=Section is Full RCAP=Reserve Slots Full RCMP=Related Component SLIM=Session Limit Exceeded TIME=Time Conflict Exsists TIMR=Time Conflict Resolved TLIM=Term Limit Exceeded WDRW=Withdrawn from Class Default Value: ENRL |
14 | ENRL_ACTION_LAST | Character(2) | VARCHAR2(2) NOT NULL |
Last Enrollment Action
Prompt Table: XL_ENRL_ACTN_VW |
15 | ENRL_ACTN_RSN_LAST | Character(4) | VARCHAR2(4) NOT NULL |
Last Enrl Action Reason
Prompt Table: ENRL_RSN_TBL |
16 | ENRL_ACTN_PRC_LAST | Character(2) | VARCHAR2(2) NOT NULL |
Last Enrollment Action Process
C=Course Cancelled E=Enrollment G=Grade Post R=Enrollment Request Default Value: E |
17 | STATUS_DT | Date(10) | DATE NOT NULL |
Status Date
Default Value: %date |
18 | ENRL_ADD_DT | Date(10) | DATE |
Enrollment Add Date
Default Value: %date |
19 | ENRL_DROP_DT | Date(10) | DATE | Enrollment Drop Date |
20 | UNT_TAKEN | Number(6,2) | DECIMAL(5,2) NOT NULL | Units Taken |
21 | UNT_PRGRSS | Number(6,2) | DECIMAL(5,2) NOT NULL | Units Taken-Academic Progress |
22 | UNT_PRGRSS_FA | Number(6,2) | DECIMAL(5,2) NOT NULL | Units Taken-Fin Aid Progress |
23 | UNT_BILLING | Number(6,2) | DECIMAL(5,2) NOT NULL | Billing Units |
24 | CRSE_COUNT | Number(5,2) | DECIMAL(4,2) NOT NULL | Course Count |
25 | GRADING_BASIS_ENRL | Character(3) | VARCHAR2(3) NOT NULL |
Grading Basis
Prompt Table: %EDITTABLE |
26 | GRADING_BASIS_DT | Date(10) | DATE |
Grading Basis Date
Default Value: %date |
27 | OVRD_GRADING_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Override Grading Basis
Default Value: N |
28 | CRSE_GRADE_OFF | Character(3) | VARCHAR2(3) NOT NULL |
Official Grade
Prompt Table: GRADE_TBL_VW |
29 | CRSE_GRADE_INPUT | Character(3) | VARCHAR2(3) NOT NULL |
Grade Input
A=A Prompt Table: GRADE_TBL_VW |
30 | GRADE_DT | Date(10) | DATE | Grade Date |
31 | REPEAT_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Repeat Code
NTEA=No Taking Exam/Assessment Prompt Table: REPEAT_CODE_TBL |
32 | REPEAT_DT | Date(10) | DATE | Repeat Date |
33 | CLASS_PRMSN_NBR | Number(6,0) | INTEGER NOT NULL | Class Permission Nbr |
34 | ASSOCIATED_CLASS | Number(4,0) | SMALLINT NOT NULL |
Associated Class
Default Value: CLASS_TBL_VW.ASSOCIATED_CLASS |
35 | STDNT_POSITIN | Number(8,0) | INTEGER NOT NULL | Student Position |
36 | AUDIT_GRADE_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Audit Grading Basis
Y/N Table Edit Default Value: GRADE_BASIS_VW.AUDIT_GRADE_BASIS |
37 | EARN_CREDIT | Character(1) | VARCHAR2(1) NOT NULL |
Earn Credit
Y/N Table Edit |
38 | INCLUDE_IN_GPA | Character(1) | VARCHAR2(1) NOT NULL |
Include in GPA
Y/N Table Edit |
39 | UNITS_ATTEMPTED | Character(1) | VARCHAR2(1) NOT NULL |
Units Attempted
I=In Progress N=No Y=Yes |
40 | GRADE_POINTS | Number(10,3) | DECIMAL(9,3) NOT NULL | Grade Points |
41 | GRADE_POINTS_FA | Number(10,3) | DECIMAL(9,3) NOT NULL | Financial Aid Grade Points |
42 | GRD_PTS_PER_UNIT | Number(10,3) | DECIMAL(9,3) NOT NULL | Grade Points Per Unit |
43 | MANDATORY_GRD_BAS | Character(1) | VARCHAR2(1) NOT NULL |
Mandatory Grading Basis
Y/N Table Edit Default Value: N |
44 | RSRV_CAP_NBR | Number(3,0) | SMALLINT NOT NULL | Reserve Capacity Sequence |
45 | RQMNT_DESIGNTN | Character(4) | VARCHAR2(4) NOT NULL |
This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
Prompt Table: RQMNT_DESIG_TBL |
46 | RQMNT_DESIGNTN_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Requirement Designation Option
N=No Y=Yes |
47 | RQMNT_DESIGNTN_GRD | Character(1) | VARCHAR2(1) NOT NULL |
Requirement Designation Grade
N=Not Satisfied S=Satisfied |
48 | INSTRUCTOR_ID | Character(11) | VARCHAR2(11) NOT NULL |
Instructor ID
Prompt Table: %EDITTABLE2 |
49 | DROP_CLASS_IF_ENRL | Number(5,0) | INTEGER NOT NULL |
Drop This Class if Enrolled
Prompt Table: CLASS_TBL_VW |
50 | ASSOCIATION_99 | Character(1) | VARCHAR2(1) NOT NULL |
Association 99
Y/N Table Edit Default Value: N |
51 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID |
52 | TSCRPT_NOTE_ID | Character(4) | VARCHAR2(4) NOT NULL |
Transcript Note ID
Prompt Table: TSCRPT_NOTE_TBL |
53 | TSCRPT_NOTE_EXISTS | Character(1) | VARCHAR2(1) NOT NULL |
Transcript Note Exists Flag
Y/N Table Edit Default Value: N |
54 | NOTIFY_STDNT_CHNG | Character(2) | VARCHAR2(2) NOT NULL |
Notify Student of Change
DP=Dropped/Class Canceled WE=Enrolled From WaitList WL=WaitList Status Change |
55 | REPEAT_CANDIDATE | Character(1) | VARCHAR2(1) NOT NULL |
Repeat Candidate Flag
Y/N Table Edit Default Value: N |
56 | VALID_ATTEMPT | Character(1) | VARCHAR2(1) NOT NULL | Valid Attempted Grade |
57 | GRADE_CATEGORY | Character(4) | VARCHAR2(4) NOT NULL |
The default value of NONE is delivered with the system and should not be deleted.
TXFR=Transfer Pass (Sample) |
58 | SEL_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Tuition Group |
59 | DYN_CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Dynamic Class Nbr |
60 | UNT_EARNED | Number(6,2) | DECIMAL(5,2) NOT NULL | Units Earned |