STDNT_GRPS_HNMV

(SQL View)
 Index Back

Student Groups History Name Vw

This view joins PS_STDNT_GRPS_HIST withHCR_PERSON_NM_I. It will select all effective dates rows so it contains the history by effective date to which Groups a student belongs to.

SELECT A.EMPLID ,A.INSTITUTION ,A.STDNT_GROUP ,A.EFFDT ,A.EFF_STATUS ,B.NAME ,B.LAST_NAME_SRCH ,A.LASTUPDDTTM ,A.LASTUPDOPRID ,A.SCC_LASTUPDTYPE ,A.COMMENTS FROM PS_STDNT_GRPS_HIST A , PS_HCR_PERSON_NM_I B WHERE A.EMPLID = B.EMPLID

  • 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
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    8 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.
    9 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.
    10 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
    11 COMMENTS Long Character CLOB Comment