GPBR_TER_DAT_VW

(SQL View)
Index Back

Termination Catalog Codes

Terminations Catalog Codes Used as parent record for: GPBR_TER_ER_DTL

SELECT DISTINCT GPBR_RPT_PROC_TYPE , EFFDT FROM PS_GPBR_TER_ER_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPBR_RPT_PROC_TYPE Character(3) VARCHAR2(3) NOT NULL Process Report Type
001=Homolognet Termination
002=Homolognet Payroll
003=Homolognet Absences
004=eSocial Termination
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date