SCC_STG_CRSGRD

(SQL Table)
Index Back

Course Grade History

Course Grade History Staging record.

  • Parent record: SCC_STG_EXTCRS
  • # 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