COMPANYPAYGROUPSTART_DTPY_MOD_ATPGP_VW(SQL View) |
Index Back |
|---|---|
Paycheck Modeling Pay GroupsPaycheck Modeling Authorized Paygroups: - Not locked due to regular payroll confirmation run - Status is Temporarily Disabled |
| SELECT DISTINCT D.COMPANY , D.PAYGROUP , E.START_DT , E.START_TIME , E.END_DT , E.END_TIME FROM PS_PY_MOD_PAYGRP D , PS_PY_MOD_PGRP_PRD E WHERE D.PY_MOD_BTCHRUN_LCK <> 'Y' AND D.PY_MOD_ACCES_CNTRL = 'T' AND E.COMPANY = D.COMPANY AND E.PAYGROUP = D.PAYGROUP AND E.END_DT = ( SELECT MIN(E_ED.END_DT) FROM PS_PY_MOD_PGRP_PRD E_ED WHERE E.COMPANY = E_ED.COMPANY AND E.PAYGROUP = E_ED.PAYGROUP AND E_ED.END_DT >= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 3 | START_DT |
Date(10) | DATE | Start Date |
| 4 | START_TIME | Time(15) | TIMESTAMP | Interview Start Time |
| 5 | END_DT | Date(10) | DATE | end date |
| 6 | END_TIME | Time(15) | TIMESTAMP | Interview End Time |