UPR10202 - Payroll Work Header
Query Builder
| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| USERID | User ID |
String | 16 | View | |
| PYRNTYPE | Pay Run Type |
Integer | 2 | View | |
| EMPLOYID | Employee ID |
String | 16 | View | |
| POSTED | Posted |
Boolean | 2 | View | |
| PYSTLTEX | Pay Subject To Local Tax Exists |
Boolean | 2 | View | |
| CHEKNMBR | Check Number |
String | 22 | View | |
| CHEKDATE | Check Date |
Date | 4 | View | |
| CHEKBKID | Checkbook ID |
String | 16 | View | |
| PYADNMBR | Payment/Adjustment Number |
Long Integer | 4 | View | |
| ACTINDX | Account Index |
Long Integer | 4 | View | |
| ADFDWHDG | Additional Federal Withholding |
Currency | 10 | View | |
| ESTFEDWH | Estimated Federal Withholding |
Currency | 10 | View | |
| HWKVCACR | Hours Worked For Vacation Accrual |
Currency | 10 | View | |
| HWKSKACR | Hours Worked For Sick Accrual |
Currency | 10 | View | |
| VACTMACC | Vacation Time Accrued |
Currency | 10 | View | |
| SKTMACCR | Sick Time Accrued |
Currency | 10 | View | |
| VACTMLBL | Vacation Time Liability |
Currency | 10 | View | |
| SKTMLBTY | Sick Time Liability |
Currency | 10 | View | |
| VACAVLBL | Vacation Available |
Long Integer | 4 | View | |
| SIKTIMAV | Sick Time Available |
Long Integer | 4 | View | |
| GRWGPRN | Gross Wages/Pay Run |
Currency | 10 | View | |
| NTWPYRN | Net Wages/Pay Run |
Currency | 10 | View | |
| FEDWGARR_1 | Federal Wage Array[1] |
Currency | 10 | View | |
| FEDWGARR_2 | Federal Wage Array[2] |
Currency | 10 | View | |
| FEDWGARR_3 | Federal Wage Array[3] |
Currency | 10 | View | |
| FEDWGARR_4 | Federal Wage Array[4] |
Currency | 10 | View | |
| FEDWGARR_5 | Federal Wage Array[5] |
Currency | 10 | View | |
| FEDWGARR_6 | Federal Wage Array[6] |
Currency | 10 | View | |
| FEDWGARR_7 | Federal Wage Array[7] |
Currency | 10 | View | |
| FEDWGARR_8 | Federal Wage Array[8] |
Currency | 10 | View | |
| Federal_Tips_Array_1 | Federal Tips Array[1] |
Currency | 10 | View | |
| Federal_Tips_Array_2 | Federal Tips Array[2] |
Currency | 10 | View | |
| Federal_Tips_Array_3 | Federal Tips Array[3] |
Currency | 10 | View | |
| Federal_Tips_Array_4 | Federal Tips Array[4] |
Currency | 10 | View | |
| Federal_Tips_Array_5 | Federal Tips Array[5] |
Currency | 10 | View | |
| Federal_Tips_Array_6 | Federal Tips Array[6] |
Currency | 10 | View | |
| Federal_Tips_Array_7 | Federal Tips Array[7] |
Currency | 10 | View | |
| Federal_Tips_Array_8 | Federal Tips Array[8] |
Currency | 10 | View | |
| FDWGPYRN | Federal Wages/Pay Run |
Currency | 10 | View | |
| Federal_TipsPay_Run | Federal Tips/Pay Run |
Currency | 10 | View | |
| ANFDWHDG | Annualized Federal Withholding |
Currency | 10 | View | |
| FDWDGPRN | Federal Withholding/Pay Run |
Currency | 10 | View | |
| FDTXTIPS | Federal Tax on Tips |
Currency | 10 | View | |
| FICASSWP | FICA/Social Security Wages/Pay Run |
Currency | 10 | View | |
| FICASS_TipsPay_Run | FICA/SS Tips/Pay Run |
Currency | 10 | View | |
| FCASWPR | FICA/Social Security Withholding/Pay Run |
Currency | 10 | View | |
| FICSTPTX | FICA/SS Tax on Tips |
Currency | 10 | View | |
| Uncollected_FICASS_TaxP | Uncollected FICA/SS Tax/Pay Run |
Currency | 10 | View | |
| FICAMWGP | FICA/Medicare Wages/Pay Run |
Currency | 10 | View | |
| FICAMed_TipsPay_Run | FICA/Med Tips/Pay Run |
Currency | 10 | View | |
| FICAMWPR | FICA/Medicare Withholding/Pay Run |
Currency | 10 | View | |
| FICMTPTX | FICA/Med Tax on Tips |
Currency | 10 | View | |
| Uncollected_FICAMed_TaxP | Uncollected FICA/Med Tax/Pay Run |
Currency | 10 | View | |
| EICWPYRN | EIC Wages/Pay Run |
Currency | 10 | View | |
| EPFICASS | Employer FICA/Social Security |
Currency | 10 | View | |
| EFICAMCR | Employer FICA/Medicare |
Currency | 10 | View | |
| Charged_Receipts | Charged Receipts |
Currency | 10 | View | |
| Reported_Receipts | Reported Receipts |
Currency | 10 | View | |
| Hours_Worked_For_Minimum | Hours Worked For Minimum Wage |
Currency | 10 | View | |
| Min_Wage_Bal_Applicable | Min Wage Bal Applicable Pay |
Currency | 10 | View | |
| Reported_Tips | Reported Tips |
Currency | 10 | View | |
| Charged_Tips | Charged Tips |
Currency | 10 | View | |
| ALOCTIPS | Allocated Tips |
Currency | 10 | View | |
| TipType | Tip Type |
Integer | 2 | View | |
| POSTEDDT | Posted Date |
Date | 4 | View | |
| GRWGFREIC | Gross Wages For EIC |
Currency | 10 | View | |
| CALCCHKERRS | Calc Check Errors |
Long Integer | 4 | View | |
| EFICASSWH | Employer FICA/Social Security Withholding |
Currency | 10 | View | |
| EFICASS_Tax_On_Tips | Employer FICA/SS Tax On Tips |
Currency | 10 | View | |
| EFICAMWPR | Employer FICA/Medicare Withholding |
Currency | 10 | View | |
| EFICAMed_Tax_On_Tips | Employer FICA/Med Tax On Tips |
Currency | 10 | View |