YE_W2CP_TXFRM_V (SQL View)	Index Back
Boxes available for W-2c PR. Boxes available for W-2c PR.

YE_W2CP_TXFRM_V

(SQL View)

Boxes available for W-2c PR.

SELECT (TO_NUMBER(TO_CHAR(A.EFFDT ,'YYYY'))) , A.BOX , A.DESCR FROM PS_TAXFORM_BOX A WHERE A.BOX IN ('05','06','07','08','09','10','11','12','13','14','15','16','16B','17','18','19','20','21','22','23') AND A.TAXFORM_ID = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year

2 BOX Character(4) VARCHAR2(4) NOT NULL Box

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
2	BOX	Character(4)	VARCHAR2(4) NOT NULL	Box
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description