GPAU_NRP_PSM_VW(SQL View) |
Index Back |
|---|---|
Empl Payment Summ CertificateThis record holds temp table for the employee's payment summary per tax year. The payment summary is keyed by emplid, pay enity and balance group id. |
| SELECT EMPLID ,EMPL_RCD ,PAY_ENTITY ,BALANCE_GRP_NUM ,GP_PAYGROUP ,PIN_NUM + 50000000 ,PIN_CODE ,GPAU_ACCUM_TOT ,GPAU_SRC_PIN_NUM + 50000000 ,GPAU_SRC_PIN_CODE ,GPAU_ERN_DED_TOT ,SOVR_VAL_CHAR FROM PS_GPAU_PSM_EXCEPT |
| # | 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 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 4 | BALANCE_GRP_NUM | Character(3) | VARCHAR2(3) NOT NULL | This field will be used to determine the grouping of balances from the different jobs of the employee. |
| 5 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 6 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 7 | PIN_CODE | Character(22) | VARCHAR2(22) NOT NULL | Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN) |
| 8 | GPAU_ACCUM_TOT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Total for the earning/Deduction YTD Accumulator |
| 9 | GPAU_SRC_PIN_NUM | Number(8,0) | INTEGER NOT NULL | This field stores Pin Number for the TER FM DUR START used in EOY processing |
| 10 | GPAU_SRC_PIN_CODE | Character(22) | VARCHAR2(22) NOT NULL | Earning/Deduction Pin Code - for EOY Exeption Reporting |
| 11 | GPAU_ERN_DED_TOT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Total for the earning/Deduction Total of Period earnings |
| 12 | SOVR_VAL_CHAR | Character(25) | VARCHAR2(25) NOT NULL | Supporting Element Character Value |