EMPLIDEMPL_RCDACTION_DT_SSTRANS_EFFSEQTRANSACTION_NAMECAN=Cancelled
COM=Completed
COR=Corrected
IRR=IRR Reported
WIP=Work-in-progress
FE_DATAORGN_VW1(SQL View) |
Index Back |
|---|---|
Self Service Data Origin TableThis view will serve as a bridge between eFed Self-service transactions and the GVT tables. |
| SELECT A.EMPLID ,A.EMPL_RCD ,A.ACTION_DT_SS ,A.TRANS_EFFSEQ ,A.TRANSACTION_NAME ,B.ACTION_DT ,B.GVT_WIP_STATUS ,B.GVT_STATUS_TYPE FROM PS_FE_DATA_ORIGIN A , PS_GVT_JOB B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ |
| # | 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 | TRANSACTION_NAME |
Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name |
| 6 | ACTION_DT | Date(10) | DATE | Action Date |
| 7 | GVT_WIP_STATUS | Character(3) | VARCHAR2(3) NOT NULL | Work-in-Progress Status |
| 8 | GVT_STATUS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Status Type
CAN=Cancelled COM=Completed COR=Corrected IRR=IRR Reported WIP=Work-in-progress |