COMPANYPAYGROUPEMPLIDEMPL_RCDPY_MOD_US_TDJOB(SQL View) |
Index Back |
|---|---|
Paycheck Modeling Temp DisableThis view list temporarily disabled paycheck modeling paygroups. |
| SELECT DISTINCT A.COMPANY , A.PAYGROUP , A.EMPLID , A.EMPL_RCD , D.START_DT , D.START_TIME , D.END_DT , D.END_TIME FROM PS_JOB_CURR_ALL_VW A , PS_PAYGROUP_TBL B , PS_PY_MOD_ATPGP_VW D WHERE A.EMPL_STATUS IN ('A','P','Q','U') AND B.COMPANY = A.COMPANY AND B.PAYGROUP = A.PAYGROUP AND B.EFF_STATUS = 'A' AND B.COUNTRY = 'USA' AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_PAYGROUP_TBL B_ED WHERE B.COMPANY = B_ED.COMPANY AND B.PAYGROUP = B_ED.PAYGROUP AND B_ED.EFFDT <= %CurrentDateIn) AND D.COMPANY = A.COMPANY AND D.PAYGROUP = A.PAYGROUP |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | START_TIME | Time(15) | TIMESTAMP | Interview Start Time |
| 7 | END_DT | Date(10) | DATE | end date |
| 8 | END_TIME | Time(15) | TIMESTAMP | Interview End Time |