SAE_GROUP_VW_LN (SQL View)	Index Back
SAIP Group Related Language Related Language Table to hold groups, especially non enrollment based groups.

SAE_GROUP_VW_LN

(SQL View)

SAIP Group Related Language

Related Language Table to hold groups, especially non enrollment based groups.

SELECT AUTH_UID.SAE_GRP_AUTHUSERID ,GRPLANG.SAE_GROUP_NO ,GRPLANG.LANGUAGE_CD ,GRPLANG.SAE_GROUP_NAME FROM %Table(SAE_GRP_AUTHS) AUTH_UID , %Table(SAE_GROUP_LANG) GRPLANG WHERE AUTH_UID.SAE_GROUP_NO = GRPLANG.SAE_GROUP_NO

Related Language Record for SAE_GROUP_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 SAE_GROUP_NAME Character(30) VARCHAR2(30) NOT NULL Group Name is also used as the ims group identifier in the target system

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	SAE_GROUP_NAME	Character(30)	VARCHAR2(30) NOT NULL	Group Name is also used as the ims group identifier in the target system