VC_TM_GRP_LNG (SQL View)	Index Back
Groups in Tree Mgr, RelLang Related Language Rec for VC_TM_GRP_SRCH GB definition Search Record within Tree Manager. The user can see the groups depending on the security of the group. The group security is set up by components. This view applies the security setup for the component that is defined on the tree structure VC_GROUP_STRUCT

VC_TM_GRP_LNG

(SQL View)

Groups in Tree Mgr, RelLang

Related Language Rec for VC_TM_GRP_SRCH GB definition Search Record within Tree Manager. The user can see the groups depending on the security of the group. The group security is set up by components. This view applies the security setup for the component that is defined on the tree structure VC_GROUP_STRUCT

SELECT A.GB_GROUP_ID , A.OPRID , B.LANGUAGE_CD , A.DESCR FROM PS_VC_TM_GRP_SRCH A , PS_GB_GROUPTBL_LNG B WHERE B.GB_GROUP_ID = A.GB_GROUP_ID AND B.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GB_GROUP_TBL A1 WHERE A1.GB_GROUP_ID = B.GB_GROUP_ID AND A1.EFFDT <= %CurrentDateIn )

Related Language Record for VC_TM_GRP_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description