GPMX_IACC_DT_VW (SQL View)	Index Back
Eff. dates for Init Accum Mex. Setup record to store effective dates and status for the accumulators to be initialized after rehire.

GPMX_IACC_DT_VW

(SQL View)

Eff. dates for Init Accum Mex.

Setup record to store effective dates and status for the accumulators to be initialized after rehire.

SELECT DISTINCT EFFDT , EFF_STATUS FROM PS_GPMX_INIT_ACCUM

Parent Record Of GPMX_INIT_ACCUM GPMX_NRP_IAC_AD GPMX_NRP_IAC_VW

# 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