UPD_SR_RPT_AET

(SQL Table)
Index Back

SR - Use for update

Use for AE - updating GRADE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
3 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
A=A
6 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
7 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
ANC=ABC/NC Grading
AUD=Audit
BMT=Multi-Term Course: Not Graded
CNC=Credit / No Credit
EQV=Equivalent
GRD=Graded
HSC=Hundred Point Scale (NLD)
LAW=Law
MED=Medical School Grades
NOG=No Grade Associated
NON=Non-Graded Component
NQF=NQF Scale
OPT=Student Option
PNP=Pass/Not Pass
SUS=Satisfactory/Unsatisfactory
TRN=Transfer Grading Basis
TSC=Ten Point Scale (NLD)
8 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme
9 IN_PROGRESS_GRD Character(1) VARCHAR2(1) NOT NULL In Progress Grade
10 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA
11 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
12 SETID Character(5) VARCHAR2(5) NOT NULL SetID
13 SSR_INCL_GRD_RPTCK Character(1) VARCHAR2(1) NOT NULL Flag to identify how repeat check would process a given grade value
1=1) Count = Y Process = Y
2=2) Count = Y Process = N
3=3) Count = N Process = Y
4=4) Count = N Process = N
14 SSR_RPT_MATCH_OPT Character(1) VARCHAR2(1) NOT NULL Repeat Check Grade Matching Option
B=Best grade
W=Worst grade
15 SSR_RPTCK_OPT_02 Character(2) VARCHAR2(2) NOT NULL 2nd Option
BG=Best Grade Points Per Unit
CX=From Course Transfer Credit
EC=Earn Credit Flag = Y
EN=From Enrollment
IA=Include in GPA = Y
MD=Most Recent Date
MT=Most Recent Term
OX=From Other Transfer Credit
TX=From Test Transfer Credit
UA=Units Attempted = Y
WG=Worst Grade Points Per Unit