EMPLIDEMPL_RCDCONTRACT_NUMY/N Table Edit
GPFR_TER_RTO_VW(SQL View) |
Index Back |
|---|---|
Terminated Employees ViewView to retrieve Terminated employees from Retro Triggers |
| SELECT DISTINCT RTO.EMPLID , SEG.EMPL_RCD , CONT.CONTRACT_NUM , NAM.LAST_NAME , NAM.FIRST_NAME , RTO.TRGR_EFFDT TERM_DATE , ACT.ACTION_DESCR , RES.DESCR ,'Retro' TERM_PRD , CONT.CONTRACT_BEGIN_DT , CONT.CONTRACT_END_DT , RTO.TRGR_EFFDT , JOB.GP_PAYGROUP , 'Y' SLT FROM PS_GP_RTO_TRGR RTO , PS_GP_SEG_TRGR SEG , PS_JOB JOB , PS_CNT_ACTIVE_VW CONT , PS_NAMES NAM , PS_ACTION_TBL ACT , PS_ACTN_REASON_TBL RES WHERE RTO.TRGR_EVENT_ID IN ( SELECT TRGR_EVENT_ID FROM PS_GPFR_TERM_TRG WHERE TRGR_TYPE='R') AND RTO.EMPLID=JOB.EMPLID AND CONT.EMPLID=RTO.EMPLID AND CONT.CONTRACT_END_DT = RTO.TRGR_EFFDT AND RTO.EMPLID=NAM.EMPLID AND RTO.TRGR_STATUS IN ('U','P') AND NOT EXISTS( SELECT 'X' FROM PS_GP_PYE_SEG_STAT PYESTAT WHERE PYESTAT.EMPLID=RTO.EMPLID AND PYESTAT.SEG_END_DT = RTO.TRGR_EFFDT AND PYESTAT.PYE_CALC_STAT = '70') AND JOB.EFFDT=%DateAdd(RTO.TRGR_EFFDT ,1) AND JOB.ACTION=ACT.ACTION AND JOB.ACTION_REASON=RES.ACTION_REASON AND SEG.SEG_TRGR_STATUS = 'A' AND SEG.EMPLID=RTO.EMPLID AND SEG.TRGR_EFFDT=%DateAdd(RTO.TRGR_EFFDT ,1) AND SEG.COUNTRY=RTO.COUNTRY AND SEG.TRGR_EVENT_ID=RTO.TRGR_EVENT_ID AND %DatePart(SEG.TRGR_CREATE_TS)=%DatePart(RTO.TRGR_CREATE_TS) |
| # | 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 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 5 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 6 | TERMINATION_DT | Date(10) | DATE | Termination Date |
| 7 | ACTION_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Action Description |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | GPFR_TERM_PERIOD | Character(8) | VARCHAR2(8) NOT NULL | Termination Period |
| 10 | CONTRACT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 11 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |
| 12 | TRGR_EFFDT | Date(10) | DATE | Trigger Effective Date |
| 13 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 14 | GPFR_TERM_ST | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if the employee must be processed or not in the termination process for GP France
Y/N Table Edit |