TRN_GRP_RES_TBL (SQL Table)	Index Back
Group Enrolllment Result Table Default Result record used in Group Enrollment. This record can be modified when using refinement queries for Administer Training Groups. Note that the SBR is provided and maintained by Group Build, only the fields necessary for Administer Training must be added.

TRN_GRP_RES_TBL

(SQL Table)

Group Enrolllment Result Table

Default Result record used in Group Enrollment. This record can be modified when using refinement queries for Administer Training Groups. Note that the SBR is provided and maintained by Group Build, only the fields necessary for Administer Training must be added.

# 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 Record

5 JOB_EFFDT Date(10) DATE Job Effective Date

6 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence

#	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 Record
5	JOB_EFFDT	Date(10)	DATE	Job Effective Date
6	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence