GPUS_W4_FRM_VW (SQL View)	Index Back
Prompt Table - W4 Form Version Prompt Table for the W-4 Form Version

GPUS_W4_FRM_VW

(SQL View)

Prompt Table - W4 Form Version

Prompt Table for the W-4 Form Version

SELECT W.GPUS_EE_TAX_W4_FRM, W.GPUS_W4_FORM_VER, X.XLATLONGNAME FROM PS_GPUS_W4_FRM_DAT W, PSXLATITEM X WHERE X.FIELDNAME = 'GPUS_W4_FORM_VER' AND W.GPUS_W4_FORM_VER = X.FIELDVALUE AND X.EFFDT = (SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPUS_EE_TAX_W4_FRM Character(4) VARCHAR2(4) NOT NULL Employee Tax Type and W-4 Form Combination for Dynamic Prompt

2 GPUS_W4_FORM_VER Character(2) VARCHAR2(2) NOT NULL Federal Withholding Form Version
19=2019 or Earlier
19=W-4 - 2019 or Earlier
20=2020 or Later
20=W-4 - 2020 or Later
22=W-4P - 2022 or Later

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPUS_EE_TAX_W4_FRM	Character(4)	VARCHAR2(4) NOT NULL	Employee Tax Type and W-4 Form Combination for Dynamic Prompt
2	GPUS_W4_FORM_VER	Character(2)	VARCHAR2(2) NOT NULL	Federal Withholding Form Version 19=2019 or Earlier 19=W-4 - 2019 or Earlier 20=2020 or Later 20=W-4 - 2020 or Later 22=W-4P - 2022 or Later
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description