R_PATXUPD(SQL Table) |
Index Back |
|---|---|
PATXUPDRATXUPD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 2 | LOCALITY | Character(10) | VARCHAR2(10) NOT NULL | Locality |
| 3 | EFFDT | Date(10) | DATE | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | LOCALITY_NAME | Character(40) | VARCHAR2(40) NOT NULL | Locality Name |
| 6 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 7 | OTH_LOCALITY | Character(10) | VARCHAR2(10) NOT NULL | School District Code (LST |
| 8 | OTH_LOCALITY_NAME | Character(40) | VARCHAR2(40) NOT NULL | Other Locality Name |
| 9 | MAINT_RESPONSBLTY | Character(1) | VARCHAR2(1) NOT NULL |
Maintenance Responsibility
C=Customer P=PeopleSoft |
| 10 | LOC_TAX_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Local Tax Calculation Type
F=Rate x FLSA Hours Worked G=Rate x Taxable Gross M=Amount Per Month P=Amount Per Pay Period Q=Amount Per Quarter S=Rate x State Withholding T=Graduated Tax Tables Y=Amount Per Year |
| 11 | WITHHOLD_WRK_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Withhold On Work Locality Only |
| 12 | LOC_JURISDCTN | Character(1) | VARCHAR2(1) NOT NULL |
Local Jurisdiction
C=Combined D=School District M=Municipality O=Other S=State T=County |
| 13 | PARTIAL_IND | Character(1) | VARCHAR2(1) NOT NULL | Partial Indicator (LST) |
| 14 | RESIDENT_TAX_RT | Number(12,6) | DECIMAL(11,6) NOT NULL | Resident Tax Rate |
| 15 | NONRESIDENT_TAX_RT | Number(12,6) | DECIMAL(11,6) NOT NULL | Nonresident Tax Rate |
| 16 | TAX_CLASS | Character(1) | VARCHAR2(1) NOT NULL | Tax Balance Class |