TL_GROUP_DTL (SQL Table)	Index Back
Group Detail This record contains information about specific employees assigned to a group within Time & Labor. Static group members will be in this record automatically. Dynamic group members will be in this record only once the group is refreshed.

TL_GROUP_DTL

(SQL Table)

Group Detail

This record contains information about specific employees assigned to a group within Time & Labor. Static group members will be in this record automatically. Dynamic group members will be in this record only once the group is refreshed.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GROUP_ID Character(5) VARCHAR2(5) NOT NULL Group ID

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

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

4 GROUP_TYPE_IND Character(1) VARCHAR2(1) NOT NULL Type of Group: Static or Dynamic
D=Dynamic
S=Static
Default Value: S

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GROUP_ID	Character(5)	VARCHAR2(5) NOT NULL	Group ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	GROUP_TYPE_IND	Character(1)	VARCHAR2(1) NOT NULL	Type of Group: Static or Dynamic D=Dynamic S=Static Default Value: S