PY_IC_W4_AUDIT

#	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	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
7	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
8	SPECIAL_FWT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Special FWT Status A=Non-Resident Alien E=Exempt (not subject to FIT) G=Maintain gross (no tax WH) N=None
9	FWT_MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	FWT Marital Status M=Married S=Single
10	FWT_ALLOWANCES	Number(3,0)	SMALLINT NOT NULL	FWT Allowances
11	FWT_ADDL_AMT	Number(8,2)	DECIMAL(7,2) NOT NULL	FWT Additional Amount
12	FWT_ADDL_PCT	Number(6,3)	DECIMAL(5,3) NOT NULL	FWT Additional Percentage
13	FUT_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Exempt from FUT Y/N Table Edit Default Value: COMPANY_TBL.FUT_EXEMPT
14	EIC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Earned Income Credit Status M=Married, both spouses filing N=Not applicable S=Single,or Head of Household U=Married without spouse filing Default Value: N
15	STATUTORY_EE	Character(1)	VARCHAR2(1) NOT NULL	Statutory Employee Y/N Table Edit Default Value: N
16	DECEASED	Character(1)	VARCHAR2(1) NOT NULL	Deceased Y/N Table Edit Default Value: N
17	PENSION_PLAN	Character(1)	VARCHAR2(1) NOT NULL	Retirement Plan Y/N Table Edit Default Value: N
18	LEGAL_REP	Character(1)	VARCHAR2(1) NOT NULL	Legal Representative Y/N Table Edit Default Value: N
19	DEFERRED_COMP	Character(1)	VARCHAR2(1) NOT NULL	Deferred Compensation Y/N Table Edit Default Value: N
20	USE_TOTAL_WAGE	Character(1)	VARCHAR2(1) NOT NULL	Use Total Wage for Multi-State Y/N Table Edit Default Value: N
21	LAST_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Last Action C=System D=Hire Process O=Online User S=Supplier Deduction File W=Employee Self Service User
22	W4_PRCSS	Character(1)	VARCHAR2(1) NOT NULL	W4 Process Flag N=None S=Notification Sent W=New W-4 Received
23	W5_PRCSS	Character(1)	VARCHAR2(1) NOT NULL	W5 Process Flag N=None S=Notification Sent W=New W-5 Received
24	LOCK_IN_RECVD	Character(1)	VARCHAR2(1) NOT NULL	Lock-In Letter Received Y/N Table Edit Default Value: N
25	LOCK_IN_LIMIT	Number(3,0)	SMALLINT NOT NULL	Limit On Allowances
26	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update
27	DATE_OF_ENTRY	Date(10)	DATE	Date of Entry
28	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: TREATY_CNTRY_VW
29	FORM_1001_RECD	Character(1)	VARCHAR2(1) NOT NULL	Form W8 Recd N=No X=Not Applicable Y=Yes Default Value: N
30	FORM_1001_SUBMT_DT	Date(10)	DATE	W8 In Effect Date
31	FORM_1001_EXP_DT	Date(10)	DATE	Form W8 Expiration Date. When this expiration date is reached, the Payroll Calculation will use the "Before Form" tax rate to calculate Non Resident Alien tax.
32	FORM_8233_RECD	Character(1)	VARCHAR2(1) NOT NULL	Form 8233 Recd N=No X=Not Applicable Y=Yes Default Value: N
33	FORM_8233_SUBMT_DT	Date(10)	DATE	Form 8233 Submission Date
34	FORM_8233_EXP_DT	Date(10)	DATE	Form 8233 Expiration Date. When this expiration date is reached, the Payroll Calculation will use the "Before Form" tax rate to calculate Non Resident Alien tax.
35	TAXPAYER_ID_NO	Character(9)	VARCHAR2(9) NOT NULL	Taxpayer ID Number
36	TREATY_EXP_DT	Date(10)	DATE	Treaty Exp Date
37	TREATY_ID	Character(10)	VARCHAR2(10) NOT NULL	Treaty ID Prompt Table: TREATY_NRA_TBL
38	FORM_1078_RECD	Character(1)	VARCHAR2(1) NOT NULL	Form W9 Received N=No Y=Yes Default Value: N
39	FORM_1078_SUBMT_DT	Date(10)	DATE	W9 Submit Date
40	THIRDPARTY_SICKPAY	Character(1)	VARCHAR2(1) NOT NULL	Third-party sick pay Y/N Table Edit Default Value: N
41	MARRIED_FILE_SINGL	Character(1)	VARCHAR2(1) NOT NULL	Married File Single Y/N Table Edit Default Value: N
42	NRA_EXEMPT_WHRULE	Character(1)	VARCHAR2(1) NOT NULL	Exempt indicator for Non Resident Alien employees that witholding rules not applicable. N=Subject to Rule R=Not Applicable Y=Exempt from Rule Y/N Table Edit Default Value: N
43	NQDC_W2_RPTG	Character(1)	VARCHAR2(1) NOT NULL	Non Qualified prevously Deferred payments from the State are paid in another state. A=Applies N=Not Applicable Default Value: N