GRADE_RSTR_TYPE(SQL Table) |
Index Back |
---|---|
Grade Roster TypeThe Grade Roster Type table contains aggregate information specific to a grade roster. |
# | 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 Default Value: NRVW |
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 |