PY_RPT_OPT_VW2

(SQL View)
 Index Back

Year-End Form Report Options

Year-End Form Report Options by Taxform ID.

SELECT PY_TAX_YEAR , TAXFORM_ID , REPORT_DEFN_ID , TMPLDEFN_ID , PY_W2_COPY_TYPE , PY_YE_RPT_BURST , PY_YE_RPT_SS , PY_RPT_BATCH_SIZE FROM PS_PY_YE_OPT_RPT WHERE TAXFORM_ID IN ('A','T','R','V')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PY_TAX_YEAR Number(4,0) SMALLINT NOT NULL Represents the year for personal income tax purposes.
2 TAXFORM_ID Character(1) VARCHAR2(1) NOT NULL Tax Form Identification
A=T4A Slip
B=Business Payrolls Survey - CAN
C=WCB Assessable Earnings
E=Record of Employment
F=940 - Annual Employer's FUTA
I=W-2VI
J=W-2cVI
M=W-2GU
N=W-2cGU
P=W-2PR
Q=W-2cPR
R=RL-1 Slip
S=W-2AS
T=T4 Slip
U=W-2cAS
V=RL-2 Slip
W=W-2
X=W-2c
Y=1099-R
Z=1042-S

Prompt Table: TAXFORM_TBL

3 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).

Prompt Table: PY_RPT_DEFN_VW

4 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).

Prompt Table: PY_RPT_TMPL_VW

5 PY_W2_COPY_TYPE Character(1) VARCHAR2(1) NOT NULL W-2/W-2c Type
1=Government Copy
2=Employee Copy
4=Company Copy
5=Payee Copy
6=Payer Copy
6 PY_YE_RPT_BURST Character(1) VARCHAR2(1) NOT NULL Indicates if report bursting is required.

Y/N Table Edit

7 PY_YE_RPT_SS Character(1) VARCHAR2(1) NOT NULL Indicates if report destination is a self-service application.

Y/N Table Edit

Default Value: N

8 PY_RPT_BATCH_SIZE Number(6,0) INTEGER NOT NULL Indicates the batch sizes for breaking down a large report.