HR_TEAM_GPBL_WK (SQL Table)	Index Back
Absences Work SQL Table Work SQL table used to hold both TL and GP absences in the My Team component.

HR_TEAM_GPBL_WK

(SQL Table)

Absences Work SQL Table

Work SQL table used to hold both TL and GP absences in the My Team component.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 HRS_DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 ABSENCE_BALANCE_4 Signed Number(20,6) DECIMAL(18,6) NOT NULL Field used to display absence management balance on My Team fluid page.

5 UNIT_TYPE1 Character(1) VARCHAR2(1) NOT NULL Unit type or unit of measure in which the absence balances are displayed. Field used in My Team fluid page.
D=Days
H=Hours

6 ASOFDATE Date(10) DATE As of Date

7 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	HRS_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	ABSENCE_BALANCE_4	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Field used to display absence management balance on My Team fluid page.
5	UNIT_TYPE1	Character(1)	VARCHAR2(1) NOT NULL	Unit type or unit of measure in which the absence balances are displayed. Field used in My Team fluid page. D=Days H=Hours
6	ASOFDATE	Date(10)	DATE	As of Date
7	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions