PY_IC_W2_WL

(SQL Table)
Index Back

WEB - Payroll W2 Request WL

This record has been created to support web-enablement of Replacement-W2 request.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
2 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
3 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
4 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
5 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
6 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
8 W2_YEAR Number(4,0) SMALLINT NOT NULL W2 Request for year
9 NAME Character(50) VARCHAR2(50) NOT NULL Name
10 W2_MAIL_ADDRESS Character(1) VARCHAR2(1) NOT NULL W-2 Mailing Address
H=Home Address
M=Mailing Address
W=Work Location
11 TEXT_W2_REQUEST Character(100) VARCHAR2(100) NOT NULL Request for replacement W2