GPBR_ABS_AR_VW

(SQL View)
Index Back

Effective date for Abs Act/Rsn

eSocial: Effective date for Absence Action/Reason

SELECT DISTINCT EFFDT ,EFF_STATUS FROM PS_GPBR_ABS_TAKREA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

2 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A