GPJP_RC_YEA

(SQL Table)
Index Back

Common YEA run control

Common YEA run control used for several reports and processes.

# 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
3 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number

Prompt Table: GPJP_TAXESIT_VW

4 DATE_YEAR_VAL Number(4,0) SMALLINT NOT NULL Date Year Value
5 GPJP_YEA_RPTTYP Character(2) VARCHAR2(2) NOT NULL Report Type.
10=Withholding Tax Report
20=Wage Payment Report