SSR_TSRSLT_MLSA(SQL Table) |
Index Back |
---|---|
Transcript RecordStudent Milestone Attempts |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(9) | VARCHAR2(9) NOT NULL | Report Request Nbr | |
2 | Number(5,0) | INTEGER NOT NULL | Request Seq Nbr | |
3 | Number(2,0) | SMALLINT NOT NULL | Report Number | |
4 | Number(5,0) | INTEGER NOT NULL | Sequence Number | |
5 | Character(2) | VARCHAR2(2) NOT NULL | Print Area Code | |
6 | Character(4) | VARCHAR2(4) NOT NULL | Transcript Result Row Type | |
7 | Character(5) | VARCHAR2(5) NOT NULL | Academic Program | |
8 | Number(4,0) | SMALLINT NOT NULL | Milestone Nbr | |
9 | 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 |