EMPLIDEMPL_RCDERNCD_SPCLPAY_END_DTFMLA_EARNS_VW(SQL View) |
Index Back |
|---|---|
Vw-Special Earns used by FMLAThis view of Pay Earnings and Pay Special Earnings is used in the FMLA module as the source for a hidden work scroll. The view assists in retrieving the payroll hours earned by an employee in order to make a determination of eligibility for FMLA protected leave. |
| SELECT E.EMPLID ,E.EMPL_RCD ,S.ERNCD_SPCL ,E.PAY_END_DT ,E.EARNS_BEGIN_DT ,S.SPCL_HRS FROM PS_PAY_EARNINGS E , PS_PAY_SPCL_EARNS S WHERE E.ADDL_NBR = ( SELECT MAX(E1.ADDL_NBR) FROM PS_PAY_EARNINGS E1 WHERE E1.COMPANY = E.COMPANY AND E1.PAYGROUP = E.PAYGROUP AND E1.PAY_END_DT = E.PAY_END_DT AND E1.OFF_CYCLE = E.OFF_CYCLE AND E1.PAGE_NUM = E.PAGE_NUM AND E1.LINE_NUM = E.LINE_NUM AND E1.EMPL_RCD = E.EMPL_RCD) AND S.COMPANY = E.COMPANY AND S.PAYGROUP = E.PAYGROUP AND S.PAY_END_DT = E.PAY_END_DT AND S.OFF_CYCLE = E.OFF_CYCLE AND S.PAGE_NUM = E.PAGE_NUM AND S.LINE_NUM = E.LINE_NUM AND S.EMPL_RCD = E.EMPL_RCD |
| # | 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 | ERNCD_SPCL |
Character(3) | VARCHAR2(3) NOT NULL | Special Accumulator Code |
| 4 | PAY_END_DT |
Date(10) | DATE | Pay Period End Date |
| 5 | EARNS_BEGIN_DT | Date(10) | DATE | Earnings Begin Date |
| 6 | SPCL_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Special Hours |