| # |
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.
|