GPMY_8A_FI_AET

(SQL Table)
Index Back

Payee Rpt Extract State Record

State record for Payee Reports process run (preparation of the pay results for reporting - Application Engine)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 GPMY_TAX_NBR Character(12) VARCHAR2(12) NOT NULL GPMY_TAX_NBR
3 GPMY_CONTRIB_YEAR Number(4,0) SMALLINT NOT NULL Contribution Year
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
6 WHERE_CLAUSE Long Character(500) VARCHAR2(500) Where Clause
7 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
8 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
9 CREATION_DT Date(10) DATE Creation Date