PY_IC_W2_AUDIT (SQL Table)	Index Back
EE U.S. Federal Tax Data This record is used to record and maintain federal tax information that the system will use to calculate federal taxes for employees. The tax data is defined by company. A view W3PY_W4_FTX_VW based on this record has been created for the purpose of WEB-enabled W4 update. Changes made to the record FED_TAX_DATA would need to be analyzed and made to W3PY_W4_FTX_VW, if necessary.

PY_IC_W2_AUDIT

(SQL Table)

EE U.S. Federal Tax Data

This record is used to record and maintain federal tax information that the system will use to calculate federal taxes for employees. The tax data is defined by company. A view W3PY_W4_FTX_VW based on this record has been created for the purpose of WEB-enabled W4 update. Changes made to the record FED_TAX_DATA would need to be analyzed and made to W3PY_W4_FTX_VW, if necessary.

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.

2 AUDIT_STAMP DateTime(26) TIMESTAMP NOT NULL Date and Time Stamp

3 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

4 AUDIT_FLAG Character(1) VARCHAR2(1) NOT NULL Audit Flag
A=After
B=Before

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

6 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

7 W2_YEAR Number(4,0) SMALLINT NOT NULL W2 Request for year

8 W2_MAIL_ADDRESS Character(1) VARCHAR2(1) NOT NULL W-2 Mailing Address
H=Home Address
M=Mailing Address
W=Work Location
Default Value: H

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AUDIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The OPRID of the user who made the changes audited on an audit record.
2	AUDIT_STAMP	DateTime(26)	TIMESTAMP NOT NULL	Date and Time Stamp
3	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
4	AUDIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Audit Flag A=After B=Before
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
6	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
7	W2_YEAR	Number(4,0)	SMALLINT NOT NULL	W2 Request for year
8	W2_MAIL_ADDRESS	Character(1)	VARCHAR2(1) NOT NULL	W-2 Mailing Address H=Home Address M=Mailing Address W=Work Location Default Value: H