COMPANYPAYGROUPPAY_END_DTOFF_CYCLEPAGE_NUMLINE_NUMSEPCHKEMPLIDEMPL_RCDSTATELOCALITYTAX_CLASSTRW_PY_ER_U_TAX(SQL View) |
Index Back |
|---|---|
NA Payroll ER US Tax ViewThis view retrieves employer US Tax pay detail from North American Payroll. |
| SELECT PC.COMPANY , PC.PAYGROUP , PC.PAY_END_DT , PC.OFF_CYCLE , PC.PAGE_NUM , PC.LINE_NUM , PC.SEPCHK , PC.EMPLID , PC.EMPL_RCD , PT.STATE , PT.LOCALITY , PT.TAX_CLASS , 0 , PT.TAX_CUR , PG.CURRENCY_CD , PC.PAYCHECK_NBR , PC.CHECK_DT , 'USA' FROM PS_PAY_CHECK PC , PS_PAYGROUP_TBL PG , PS_PAY_TAX PT WHERE PC.PAYCHECK_STATUS IN ('F','R') AND PC.COMPANY = PG.COMPANY AND PC.PAYGROUP = PG.PAYGROUP AND PG.EFFDT = ( SELECT MAX(PG_ED.EFFDT) FROM PS_PAYGROUP_TBL PG_ED WHERE PG.COMPANY = PG_ED.COMPANY AND PG.PAYGROUP = PG_ED.PAYGROUP AND PG_ED.EFFDT <= PC.PAY_END_DT) AND PC.COMPANY = PT.COMPANY AND PC.PAYGROUP = PT.PAYGROUP AND PC.PAY_END_DT = PT.PAY_END_DT AND PC.OFF_CYCLE = PT.OFF_CYCLE AND PC.PAGE_NUM = PT.PAGE_NUM AND PC.LINE_NUM = PT.LINE_NUM AND PC.SEPCHK = PT.SEPCHK AND PT.TAX_CUR <> 0 AND PT.TAX_CLASS IN ('E','J','L','N','Q','R','S','X','Z','Y','U','M','6') |
| # | 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 | PAY_END_DT |
Date(10) | DATE | Pay Period End Date |
| 4 | OFF_CYCLE |
Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
| 5 | PAGE_NUM |
Number(5,0) | INTEGER NOT NULL | Page Nbr |
| 6 | LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Line Nbr |
| 7 | SEPCHK |
Number(2,0) | SMALLINT NOT NULL | Separate check number. |
| 8 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 9 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 10 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 11 | LOCALITY |
Character(10) | VARCHAR2(10) NOT NULL | Locality |
| 12 | TAX_CLASS |
Character(3) | VARCHAR2(3) NOT NULL | Tax Balance Class |
| 13 | TRW_CUR_EE_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Employee Current Deduction |
| 14 | TRW_CUR_ER_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Employer Current Amount |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | PAYCHECK_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Paycheck number. |
| 17 | CHECK_DT | Date(10) | DATE | Check date. |
| 18 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |