SSR_TSRSLT_MLSA

(SQL Table)
Index Back

Transcript Record

Student Milestone Attempts

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REPORT_REQUEST_NBR Character(9) VARCHAR2(9) NOT NULL Report Request Nbr
2 REQUEST_SEQ_NBR Number(5,0) INTEGER NOT NULL Request Seq Nbr
3 REPORT_NUMBER Number(2,0) SMALLINT NOT NULL Report Number
4 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
5 PRINT_AREA_CODE Character(2) VARCHAR2(2) NOT NULL Print Area Code
6 SSR_ROWTYPE Character(4) VARCHAR2(4) NOT NULL Transcript Result Row Type
7 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
8 MILESTONE_NBR Number(4,0) SMALLINT NOT NULL Milestone Nbr
9 ATTEMPT_NBR Number(3,0) SMALLINT NOT NULL Attempt Nbr
10 MILESTONE_COMPLETE Character(1) VARCHAR2(1) NOT NULL Milestone Complete
I=In Progress
N=Not Completed
Y=Completed
11 EFFDT Date(10) DATE Effective Date

Default Value: %date

12 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
13 DATE_ATTEMPTED Date(10) DATE Date Attempted
14 HOW_ATTEMPTED Character(2) VARCHAR2(2) NOT NULL How Attempted
A=Native Speaker
B=Attended Seminar
C=Submitted Work
D=Filed Petition
E=Exam Taken
15 DESCR Character(30) VARCHAR2(30) NOT NULL Description
16 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme
17 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)
18 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
A=A