GPUS_SWT_MS_VW (SQL View)	Index Back
Marital Status View 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.

GPUS_SWT_MS_VW

(SQL View)

Marital Status View

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.GPUS_SWT_MAR_STAT FROM PS_GPUS_SWT_MAR_ST A WHERE A.EFF_STATUS = 'A' AND A.GPUS_SWT_MAR_STAT = 'N' AND NOT EXISTS ( SELECT 'X' FROM PS_GPUS_SWT_MAR_ST A1 WHERE A1.EFF_STATUS = 'A' AND A1.STATE = A.STATE AND A1.GPUS_SWT_MAR_STAT <> '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: GPUS_STATE_VW

3 GPUS_SWT_MAR_STAT Character(1) VARCHAR2(1) NOT NULL SWT Marital 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: GPUS_STATE_VW
3	GPUS_SWT_MAR_STAT	Character(1)	VARCHAR2(1) NOT NULL	SWT Marital Status