EMPLIDEMPL_RCDCONTRACT_NUMY/N Table Edit
GPFR_TER_SEG_VW(SQL View) |
Index Back |
|---|---|
Terminated Employees ViewView to retrieve Terminated employees from Segmentation Triggers |
| SELECT DISTINCT SEG.EMPLID , SEG.EMPL_RCD , CONT.CONTRACT_NUM , NAM.LAST_NAME , NAM.FIRST_NAME , SEG.TRGR_EFFDT TERM_DATE , ACT.ACTION_DESCR , RES.DESCR ,'Current' TERM_PRD , CONT.CONTRACT_BEGIN_DT , CONT.CONTRACT_END_DT , %DateAdd(SEG.TRGR_EFFDT,-1) TRGR_EFFDT , JOB.GP_PAYGROUP , 'Y' SLT FROM 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 SEG.TRGR_EVENT_ID IN ( SELECT TRGR_EVENT_ID FROM PS_GPFR_TERM_TRG WHERE TRGR_TYPE='S') AND SEG.EMPLID=JOB.EMPLID AND SEG.EMPL_RCD=JOB.EMPL_RCD AND SEG.SEG_TRGR_STATUS = 'A' AND CONT.EMPLID=SEG.EMPLID AND CONT.CONTRACT_END_DT = %DateAdd(SEG.TRGR_EFFDT,-1) AND SEG.EMPLID=NAM.EMPLID AND NOT EXISTS( SELECT 'X' FROM PS_GP_PYE_SEG_STAT PYESTAT WHERE PYESTAT.EMPLID=SEG.EMPLID AND PYESTAT.EMPL_RCD=SEG.EMPL_RCD AND PYESTAT.SEG_END_DT = %DateAdd(SEG.TRGR_EFFDT,-1) AND PYESTAT.PYE_CALC_STAT = '70') AND JOB.EFFDT=SEG.TRGR_EFFDT AND JOB.ACTION=ACT.ACTION AND JOB.ACTION_REASON=RES.ACTION_REASON |
| # | 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 Rcd Nbr |
| 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 |