EMPLIDEMPL_RCDEFFDTEFFSEQGPUS_PYGPASN_VW(SQL View) |
Index Back |
|---|---|
Pay Group Assignment ViewGP US and Payroll for North America pay group assignment by employee |
| SELECT J.EMPLID , J.EMPL_RCD , J.EFFDT , J.EFFSEQ , J.COMPANY , PG1.PAY_ENTITY , J.GP_PAYGROUP , J.PAYGROUP FROM PS_JOB J , PS_GP_PYGRP PG1 WHERE J.GP_PAYGROUP IN ( SELECT PG2.GP_PAYGROUP FROM PS_GP_PYGRP PG2 WHERE PG2.PAY_ENTITY IN ( SELECT PE2.PAY_ENTITY FROM PS_GP_PYENT PE2 WHERE PE2.COUNTRY = 'USA')) AND J.PAY_SYSTEM_FLG = 'GP' AND J.GP_PAYGROUP = PG1.GP_PAYGROUP |
| # | 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 Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 6 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 7 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 8 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |