UPD_SR_RPT_AET(SQL Table) |
Index Back |
---|---|
SR - Use for updateUse 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 |