FE_MGR_RETI_DAT

(SQL Table)
Index Back

Stage Record for Retire SS

Used for 8.3 Workflow. Used on Page.FE_MGR_RETIRE.

# 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 Retirement Date
4 TRANS_EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

Default Value: R

6 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction 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 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
9 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
10 ORIGINATOR_ID Character(11) VARCHAR2(11) NOT NULL Originator's ID
11 FE_SS_STAT_IND Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 eFed Workflow Enhancements
A=Administrator Action Required
B=CI failed - Errors & Warnings
C=Cancelled
D=Denied
E=Error with CI
F=Error with Approval Routing
I=In Approval Process
M=Manually Entered into PAR
P=Automatically Sent to PAR
S=Completed
W=Warnings Encountered
12 FE_SS_FUTURE_FLAG Character(1) VARCHAR2(1) NOT NULL Future Flag

Y/N Table Edit

13 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
14 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
15 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code
16 GVT_LEG_AUTH_1 Character(3) VARCHAR2(3) NOT NULL Legal Authority (1)
17 GVT_LEG_AUTH_2 Character(3) VARCHAR2(3) NOT NULL Legal Authority (2)
18 GVT_SF50_REMARK Character(3) VARCHAR2(3) NOT NULL SF50 Remark Code
19 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

20 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

Prompt Table: ACTN_REASON_TBL
Set Control Field: DESCR

21 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
22 FE_SS_STAT_MSG_SET Number(5,0) INTEGER NOT NULL CI Message Set Nbr Result
23 FE_SS_STAT_MSG_NBR Number(5,0) INTEGER NOT NULL CI Message Number Result