DEPTIDEMPLIDEMPL_RCDGP_PAYGROUPPIN_NUMLANGUAGE_CDGP_CS_PACUM_VL(SQL View) |
Index Back |
|---|---|
Accumulator ViewRelated Language View for Accumulator View used in Pivot Grids for Processing Monitor |
| SELECT A.DEPTID , A.EMPLID , A.EMPL_RCD , A.GP_PAYGROUP , A.PIN_NUM , B.LANGUAGE_CD , B.DESCR FROM PS_GP_CS_PACUM_VW A , PS_GP_PIN_LANG B WHERE A.PIN_NUM = B.PIN_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 5 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |