SAE_GROUP_VW

(SQL View)
 Index Back

SAIP Group Table

Table to hold groups, especially non enrollment based groups.

SELECT AUTH_UID.SAE_GRP_AUTHUSERID ,GRP.SAE_GROUP_NO ,GRP.SAE_GROUP_NAME ,GRP.SAE_GRP_BEGIN_DT ,GRP.SAE_GRP_END_DT FROM %Table(SAE_GRP_AUTHS) AUTH_UID , %Table(SAE_GROUP_TBL) GRP WHERE AUTH_UID.SAE_GROUP_NO = GRP.SAE_GROUP_NO AND AUTH_UID.SAE_GRP_AUTH_TYPE = 'U' UNION SELECT DISTINCT ROLEUSER2.ROLEUSER ,GRP2.SAE_GROUP_NO ,GRP2.SAE_GROUP_NAME ,GRP2.SAE_GRP_BEGIN_DT ,GRP2.SAE_GRP_END_DT FROM PS_SAE_GRP_AUTHS AUTH_ROLE2 , PS_SAE_GROUP_TBL GRP2 , PSROLEUSER ROLEUSER2 WHERE AUTH_ROLE2.SAE_GROUP_NO = GRP2.SAE_GROUP_NO AND AUTH_ROLE2.SAE_GRP_AUTH_TYPE = 'R' AND ROLEUSER2.ROLENAME = AUTH_ROLE2.SAE_GRP_AUTHROLE

  • Related Language Record: SAE_GROUP_VW_LN

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