HGA_ABS_TYPE_VW (SQL View)	Index Back
Absence Type Identifies the Absence Types associated with Absence Take Definitions

HGA_ABS_TYPE_VW

(SQL View)

Absence Type

Identifies the Absence Types associated with Absence Take Definitions

SELECT USED_BY , COUNTRY , ABS_TYPE_OPTN , EFFDT , EFF_STATUS , DESCR FROM PS_GP_ABS_TYPE A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GP_ABS_TYPE A1 WHERE A1.USED_BY = A.USED_BY AND A1.ABS_TYPE_OPTN = A.ABS_TYPE_OPTN AND A1.COUNTRY = A.COUNTRY AND A1.EFFDT <= %CurrentDateIn)

Related Language Record: HGA_ABS_TYPE_LV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
A=All Countries
C=Specific Country

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: GP_COUNTRY

3 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 ABS_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Absence Type Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	USED_BY	Character(1)	VARCHAR2(1) NOT NULL	USED_BY A=All Countries C=Specific Country
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: GP_COUNTRY
3	ABS_TYPE_OPTN	Character(3)	VARCHAR2(3) NOT NULL	Absence Type
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	ABS_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Absence Type Description