EMPLIDEMPL_RCDACTION_DT_SSEFFSEQHR_RETIREDAT_V2(SQL View) |
Index Back |
|---|---|
Retirement Fluid Approval ViewRetirement Fluid Approval View |
| SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.ACTION_DT_SS , A.EFFSEQ , A.ACTION , A.ACTION_REASON_SS , JC.DESCR , WF.ACTION_DESCR , WF1.DESCR , EMP.NAME , REQ.NAME , %Sql(HR_HT_EMAIL_DATE,A.ACTION_DT_SS ) , ' ' FROM PS_HR_RETIRE_DAT A , PS_PERSON_NAME EMP , PS_PERSON_NAME REQ , PSOPRDEFN OPR , PS_ACTION_TBL_VW WF , PS_ACTN_REASON_VW WF1 , PS_CURRENT_JOB JOB , PS_JOBCODE_TBL JC WHERE A.EMPLID = EMP.EMPLID AND A.ORIGINATORID = OPR.OPRID AND OPR.EMPLID =REQ.EMPLID AND WF.ACTION = A.ACTION AND WF1.ACTION = A.ACTION AND WF1.ACTION_REASON = A.ACTION_REASON_SS AND JOB.EMPLID = A.EMPLID AND JOB.EMPL_RCD = A.EMPL_RCD AND JC.SETID = JOB.SETID_JOBCODE AND JOB.JOBCODE = JC.JOBCODE AND JC.EFFDT = ( SELECT MAX(JCC.EFFDT) FROM PS_JOBCODE_TBL JCC WHERE JC.SETID = JCC.SETID AND JC.JOBCODE = JCC.JOBCODE AND JCC.EFFDT <= %CurrentDateIn) |
| # | 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 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 6 | ACTION_REASON_SS | Character(3) | VARCHAR2(3) NOT NULL | Action Reason field for use on Self Service panels. |
| 7 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |
| 8 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 9 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 10 | EMPLNAME | Character(50) | VARCHAR2(50) NOT NULL | EmplName |
| 11 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 12 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description |
| 13 | DESCR15 | Character(15) | VARCHAR2(15) NOT NULL | Short Description |