FE_MGR_RETI_DAT(SQL Table) |
Index Back |
---|---|
Stage Record for Retire SSUsed 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
|
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 |