SWT_MARSTAT_NVW (SQL View)	Index Back
State/Fed Marital Status N Vw This view list states with ONLY 'N' as valid Marital Status; used to set default in Marital Status to 'N' when applicable if there's a change of State in Tax Data.

SWT_MARSTAT_NVW

(SQL View)

State/Fed Marital Status N Vw

This view list states with ONLY 'N' as valid Marital Status; used to set default in Marital Status to 'N' when applicable if there's a change of State in Tax Data.

SELECT A.EFFDT , A.STATE , A.SWT_MAR_STATUS FROM PS_SWT_MARSTAT_TBL A WHERE A.EFF_STATUS = 'A' AND A.SWT_MAR_STATUS = 'N' AND NOT EXISTS ( SELECT 'X' FROM PS_SWT_MARSTAT_TBL A1 WHERE A1.EFF_STATUS = 'A' AND A1.STATE = A.STATE AND A1.SWT_MAR_STATUS <> 'N')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

2 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TAX_TBL

3 SWT_MAR_STATUS Character(1) VARCHAR2(1) NOT NULL SWT Marital/Tax Status

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
2	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TAX_TBL
3	SWT_MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	SWT Marital/Tax Status