TRN_GRP_RES_VW (SQL View)	Index Back
Group Enrollment View This view is used in the scroll area of the group enrollment panel. The view is created in order do the search in the chunking panel by name or emplid.

TRN_GRP_RES_VW

(SQL View)

Group Enrollment View

This view is used in the scroll area of the group enrollment panel. The view is created in order do the search in the chunking panel by name or emplid.

SELECT DISTINCT A.GB_GROUP_ID , A.VERSIONGBQDM , A.EMPLID , A.EMPL_RCD , B.NAME FROM PS_TRN_GRP_RES_TBL A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 VERSIONGBQDM Number(10,0) DECIMAL(10) NOT NULL Version Number

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
Prompt Table: PER_ORG_ASGN

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
2	VERSIONGBQDM	Number(10,0)	DECIMAL(10) NOT NULL	Version Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: PER_ORG_ASGN
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name