EMPLIDEMPL_RCDREQUEST_DTEFFSEQHR_RESIG_DATE_V(SQL View) |
Index Back |
|---|---|
Resignation date ViewView used to fetch employee resignation date details in fluid approval summary Page |
| SELECT A.EMPLID , A.EMPL_RCD , A.REQUEST_DT , A.EFFSEQ ,A.LAST_DAY_AT_WRK ,A.EFFDT_FROM ,A.HR_ESS_COMMENTS , ( SELECT B.DESCR FROM ps_ACTN_REASON_TBL B WHERE A.ACTION = B.ACTION AND B.ACTION_REASON=A.ACTION_REASON AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM ps_ACTN_REASON_TBL B1 WHERE B1.ACTION =b.ACTION AND B1.ACTION_REASON=b.ACTION_REASON AND B1.EFFDT <= %CurrentDateIn ) AND B.EFF_STATUS='A') AS DESCR ,'' ,'' FROM PS_HR_RESIGN_DAT A |
| # | 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 | REQUEST_DT |
Date(10) | DATE | Request Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | LAST_DAY_AT_WRK | Date(10) | DATE | Last Day at Work |
| 6 | EFFDT_NEW | Date(10) | DATE | New Effective Date |
| 7 | HR_ESS_COMMENTS | Long Character | CLOB | Comments for ESS Job Action |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | LAST_WRKNG_DAY_S | Character(15) | VARCHAR2(15) NOT NULL | last working day to show in Approvals page |
| 10 | EFFDT_S | Character(15) | VARCHAR2(15) NOT NULL | String to show effective date value on appprovlas page |