FE_REAS_STA_VW(SQL View) |
Index Back |
|---|---|
eApps Reassignment STA VWeApps Reassignment STA record VW for Review Change Request Component |
| SELECT A.EMPLID ,A.EMPL_RCD ,A.ACTION_DT_SS ,A.TRANS_EFFSEQ ,A.STEP ,A.ROLENAME ,A.EMPLID_TO ,A.ROLENAME_CURR_APPR ,A.EMPLID_CURR_APPR ,A.TRANS_DT ,A.FE_APPRSTEP_ACTION ,B.ORIGINATOR_ID ,B.TRANSACTION_NAME ,B.WF_STATUS ,C.DESCR FROM PS_FE_MGR_REAS_STA A ,PS_FE_MGR_REAS_DAT B ,PS_GVT_WIP_RECORD C WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.ACTION_DT_SS = B.ACTION_DT_SS AND A.TRANS_EFFSEQ = B.TRANS_EFFSEQ AND B.TRANSACTION_NAME = C.GVT_WIP_RECORD |
| # | 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 | 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 | 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 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 11 | 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 |
| 12 | ORIGINATOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Originator's ID |
| 13 | TRANSACTION_NAME | Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name |
| 14 | 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 |
| 15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |