HR_MARSTATDAT_V (SQL View)	Index Back
Marital Status Staging Record Record is used for the Workflow staging record for Marital Status change

HR_MARSTATDAT_V

(SQL View)

Marital Status Staging Record

Record is used for the Workflow staging record for Marital Status change

SELECT A.EMPLID ,A.ACTION_DT_SS , A.EFFSEQ ,A.MAR_STATUS ,A.MAR_STATUS_DT ,B.NAME ,A.WF_STATUS , A.APPROVAL_REQUIRED FROM PS_HR_MAR_STAT_DAT A , PS_PERSON_NAME B WHERE A.APPROVAL_REQUIRED = 'Y' AND A.EMPLID=B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ACTION_DT_SS Date(10) DATE Termination Date

3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

4 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed

5 MAR_STATUS_DT Date(10) DATE This is the date that the employee's Marital status is/was effective. /* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons. 1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user. 2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */

6 NAME Character(50) VARCHAR2(50) NOT NULL Name

7 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved

8 APPROVAL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page.
N=No Approval Required
Y=Approval Required

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	ACTION_DT_SS	Date(10)	DATE	Termination Date
3	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
4	MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marital Status C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed
5	MAR_STATUS_DT	Date(10)	DATE	This is the date that the employee's Marital status is/was effective. /* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons. 1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user. 2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
6	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
7	WF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Workflow Status A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved
8	APPROVAL_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page. N=No Approval Required Y=Approval Required