FE_MGR_SEPA_STA

(SQL Table)
Index Back

Wkflow for EE Transfer SS

This record is a child of HR_TRANSFER_DAT and is used to store data about each step of the worflow approval process for a Employee Transfer request.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 ACTION_DT_SS Date(10) DATE Termination 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 EmplID 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
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 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 Rec# of Tracking Row

Default Value: 0

18 COMMENTS Long Character CLOB Comment