SAE_GROUP_TBL

(SQL Table)
 Index Back

SAIP Group Table

Table to hold groups, especially non enrollment based groups.

  • Related Language Record: SAE_GROUP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SAE_GROUP_NO Number(6,0) INTEGER NOT NULL Group Number identifier
    2 SAE_GROUP_NAME Character(30) VARCHAR2(30) NOT NULL Group Name is also used as the ims group identifier in the target system
    3 SAE_GRP_BEGIN_DT Date(10) DATE NOT NULL SAIP Group Begin Date
    4 SAE_GRP_END_DT Date(10) DATE NOT NULL SAIP Group End Date
    5 SAE_GRP_ROLETYPENO Number(6,0) INTEGER NOT NULL Group Role Type Number Identifier

    Prompt Table: SAE_GRPROLETYPE

    6 SAE_GRP_LAST_REFR DateTime(26) TIMESTAMP Last datetime when this group was refreshed via population selection.
    7 SAE_GRP_LAST_UPD DateTime(26) TIMESTAMP Last date and time that this group was updated.
    8 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

    Prompt Table: SAE_ACADORG_VW

    9 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    10 URL_ADDRESS Character(254) VARCHAR2(254) NOT NULL URL Address
    11 SAE_GROUP_DESCR Long Character CLOB Group Description