GPES_FILTER_CP

(SQL Table)
Index Back

Filter By

Filter By. Comparative Percentage of IRPF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

Default Value: GPES_RC_CP_IRPF.RUN_CNTL_ID

3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

5 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GP_PYENT

6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GP_PYGRP

7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

8 GPES_TAX_LOCATION Character(5) VARCHAR2(5) NOT NULL Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

Prompt Table: GPES_TAX_LOCATN

9 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50