FE_MGR_LOC_STA (SQL Table)	Index Back
Reporting Change approval flow This record is a child of FE_MGR_REP_DAT and is used to store data about each step of the worflow approval process for a fed SS Reporting Change request.

FE_MGR_LOC_STA

(SQL Table)

Reporting Change approval flow

This record is a child of FE_MGR_REP_DAT and is used to store data about each step of the worflow approval process for a fed SS Reporting Change request.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.

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

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

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

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

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

7 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

8 TRANS_DT Date(10) DATE Transaction Date

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

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

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

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

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

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

15 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRANSACTION_NBR	Number(15,0)	DECIMAL(15) NOT NULL	08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
2	STEP	Number(2,0)	SMALLINT NOT NULL	Step
3	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
4	EMPLID_TO	Character(11)	VARCHAR2(11) NOT NULL	Empl ID To
5	ROLENAME_CURR_APPR	Character(30)	VARCHAR2(30) NOT NULL	Stores the Role Name of the Current Approver in Federal Self-Service Transactions.
6	EMPLID_CURR_APPR	Character(11)	VARCHAR2(11) NOT NULL	Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.
7	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
8	TRANS_DT	Date(10)	DATE	Transaction Date
9	CURRENT_STEP	Number(3,0)	SMALLINT NOT NULL	Current Step Number
10	GVT_WIP_ACTVTY	Character(10)	VARCHAR2(10) NOT NULL	Federal WIP activity
11	GVT_WIP_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Work-in-Progress Status
12	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
13	GVT_TRK_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Emplid of Tracking Row
14	GVT_TRK_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record of Tracking Row Default Value: 0
15	COMMENTS	Long Character	CLOB	Comment