| # |
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.
Default Value: PY_YE_OPT_TAX.PY_TAX_YEAR
Prompt Table:
PY_TAX_YEAR
|
| 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
Default Value: PY_YE_OPT_TAX.TAXFORM_ID
Prompt Table:
PY_YE_OPT_TAX
|
| 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_SS |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if report destination is a self-service application.
Y/N Table Edit
Default Value: N
|
| 7 |
PY_YE_RPT_BURST |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if report bursting is required.
Y/N Table Edit
|
| 8 |
PY_RPT_BATCH_SIZE |
Number(6,0) |
INTEGER NOT NULL |
Indicates the batch sizes for breaking down a large report.
|
| 9 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 10 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|