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 |