PY_MOD_MARST_V2 (SQL View)	Index Back
State Marital Status Table This view is use to display valid marital status codes an employee is entitled to use. The view is use in Paycheck Modeling.

PY_MOD_MARST_V2

(SQL View)

State Marital Status Table

This view is use to display valid marital status codes an employee is entitled to use. The view is use in Paycheck Modeling.

SELECT DISTINCT A.EMPLID , A.STATE , B.SWT_MAR_STATUS , B.DESCRSHORT FROM PS_STATE_TAX_DATA A , PS_SWT_MARSTAT_TBL B WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_STATE_TAX_DATA A_ED WHERE A.EMPLID = A_ED. EMPLID AND A.STATE = A_ED.STATE AND A_ED.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND B.STATE = A.STATE AND B.EFFDT <= A.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 STATE Character(6) VARCHAR2(6) NOT NULL State

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

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
3	SWT_MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	SWT Marital/Tax Status
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description