FE_MARITAL_STA (SQL Table)	Index Back
Marital Status approval flow This record is a child of FE_MARITAL_DAT and is used to store data about each step of the worflow approval process for eFed SS Marital Status Change requests.

FE_MARITAL_STA

(SQL Table)

Marital Status approval flow

This record is a child of FE_MARITAL_DAT and is used to store data about each step of the worflow approval process for eFed SS Marital Status Change requests.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 ACTION_DT_SS Date(10) DATE *Effective Date

4 TRANS_EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 STEP Number(2,0) SMALLINT NOT NULL Step

6 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

7 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL Empl ID To

8 ROLENAME_CURR_APPR Character(30) VARCHAR2(30) NOT NULL Stores the Role Name of the Current Approver in Federal Self-Service Transactions.

9 EMPLID_CURR_APPR Character(11) VARCHAR2(11) NOT NULL Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.

10 FE_APPRSTEP_ACTION Character(3) VARCHAR2(3) NOT NULL This field holds translates Submit, Approve, Deny. It used to track which action was taken on each step of an approval process
A=Approve
D=Deny
P=Pending
PUS=Pushback
R=Request

11 TRANS_DT Date(10) DATE Transaction Date

12 CURRENT_STEP Number(3,0) SMALLINT NOT NULL Current Step Number

13 GVT_WIP_ACTVTY Character(10) VARCHAR2(10) NOT NULL Federal WIP activity

14 GVT_WIP_STATUS Character(3) VARCHAR2(3) NOT NULL Work-in-Progress Status

15 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

16 GVT_TRK_EMPLID Character(11) VARCHAR2(11) NOT NULL Emplid of Tracking Row

17 GVT_TRK_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record of Tracking Row
Default Value: 0

18 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	ACTION_DT_SS	Date(10)	DATE	*Effective Date
4	TRANS_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	STEP	Number(2,0)	SMALLINT NOT NULL	Step
6	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
7	EMPLID_TO	Character(11)	VARCHAR2(11) NOT NULL	Empl ID To
8	ROLENAME_CURR_APPR	Character(30)	VARCHAR2(30) NOT NULL	Stores the Role Name of the Current Approver in Federal Self-Service Transactions.
9	EMPLID_CURR_APPR	Character(11)	VARCHAR2(11) NOT NULL	Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.
10	FE_APPRSTEP_ACTION	Character(3)	VARCHAR2(3) NOT NULL	This field holds translates Submit, Approve, Deny. It used to track which action was taken on each step of an approval process A=Approve D=Deny P=Pending PUS=Pushback R=Request
11	TRANS_DT	Date(10)	DATE	Transaction Date
12	CURRENT_STEP	Number(3,0)	SMALLINT NOT NULL	Current Step Number
13	GVT_WIP_ACTVTY	Character(10)	VARCHAR2(10) NOT NULL	Federal WIP activity
14	GVT_WIP_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Work-in-Progress Status
15	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
16	GVT_TRK_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Emplid of Tracking Row
17	GVT_TRK_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record of Tracking Row Default Value: 0
18	COMMENTS	Long Character	CLOB	Comment