SCC_STG_CRSGRD(SQL Table) |
Index Back |
---|---|
Course Grade HistoryCourse Grade History Staging record. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCC_TEMP_ID | Number(16,0) | DECIMAL(16) NOT NULL | Temp Constituent ID |
2 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
3 | EXT_COURSE_NBR | Number(3,0) | SMALLINT NOT NULL |
External Course Number
Default Value: EXT_COURSE.EXT_COURSE_NBR |
4 | LASTUPDDTTM | DateTime(26) | TIMESTAMP NOT NULL |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime |
5 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Default Value: EXT_COURSE.EXT_ORG_ID Prompt Table: ACAD_HISTORY |
6 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
7 | CRSE_GRADE_INPUT | Character(3) | VARCHAR2(3) NOT NULL |
Grade Input
A=A |
8 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
9 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
10 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
11 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |