STDNT_GRPS_HIST

(SQL Table)
 Index Back

Student Groups History

This table contains the history by effective date to which Groups a student belongs to.

  • Parent record: STDNT_GRPS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTN_SCRTY

    3 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group

    Prompt Table: INST_STGPU_SCTY

    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 LASTUPDDTTM DateTime(26) TIMESTAMP 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.
    7 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.
    8 SCC_LASTUPDTYPE Character(1) VARCHAR2(1) NOT NULL Used to display the most recent update type: Batch or Manual
    B=SCC_STD_GRP
    M=Manual
    9 COMMENTS Long Character CLOB Comment