SSR_GR_TYPE_VW(SQL View) |
Index Back |
|---|---|
Grade Roster Type ViewUsed by Grade Roster |
| SELECT DISTINCT A.STRM , A.CLASS_NBR , A.GRD_RSTR_TYPE_SEQ , A.GRADE_ROSTER_TYPE , A.GRADING_STATUS , A.GR_APPROVAL_STATUS , A.APPROVAL_DATE , A.POSTING_DATE , A.PARTIAL_POST , A.OVRD_GRADE_ROSTER , A.PROCESS_INSTANCE , A.DESCR FROM PS_GRADE_RSTR_TYPE A , PS_GRADE_ROSTER B WHERE B.STRM = A.STRM AND B.CLASS_NBR = A.CLASS_NBR AND B.GRD_RSTR_TYPE_SEQ = A.GRD_RSTR_TYPE_SEQ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  STRM |
Character(4) | VARCHAR2(4) NOT NULL | Term |
| 2 | CLASS_NBR |
Number(5,0) | INTEGER NOT NULL | Class Nbr |
| 3 | GRD_RSTR_TYPE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Grade Roster Type Sequence Nbr |
| 4 | GRADE_ROSTER_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Grade Roster
FIN=Final Grade MID=Mid-Term Grade |
| 5 | GRADING_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Grading Status
ERR=Error GRD=Grade Input Allowed POST=Posted RDY=Ready to Post Default Value: GRD |
| 6 | GR_APPROVAL_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Approval Status
APPR=Approved NRVW=Not Reviewed RDY=Ready for Review |
| 7 | APPROVAL_DATE | Date(10) | DATE | Approval Date |
| 8 | POSTING_DATE | Date(10) | DATE | Posting Date |
| 9 | PARTIAL_POST | Character(1) | VARCHAR2(1) NOT NULL |
Partial Post
Y/N Table Edit Default Value: N |
| 10 | OVRD_GRADE_ROSTER | Character(1) | VARCHAR2(1) NOT NULL |
Override Grade Roster
Y/N Table Edit Default Value: N |
| 11 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |