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 |