GPBR_TER_AR_VW (SQL View)	Index Back
Effective date for Ter Act/Rsn eSocial: Effective date for Termination Action/Reason

GPBR_TER_AR_VW

(SQL View)

Effective date for Ter Act/Rsn

eSocial: Effective date for Termination Action/Reason

SELECT DISTINCT EFFDT ,EFF_STATUS FROM PS_GPBR_TER_ACTREA

Parent Record Of GPBR_OTH_ACTREA GPBR_TER_ACTREA

# 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

#	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