PRTAXID

Tax Identification Number

Contains the user-defined tax authority. Tax authorities provide a link between the Payroll system and the Business Software, Inc. tax tables. You can define tax authorities for a company or for a specific process level. Tax deductions must be tied to the appropriate BSI tax codes for proper calculation. Reports are available in the BSI system to provide listings of tax codes. This file also contains additional EINs (Employer Identification Numbers) for the company or process level as well as the minimum wage defined for the tax authority, and additional information required by specific states for state reporting.

REFERENCED BY
BN297 BN299 PR160 PR180 PR227 PR250
PR251 PR252 PR253 PR287 PR290 PR291
PR294 PR296 PR297 PR299 PR80.2 UK145


UPDATED BY
HR00.1 HR01.1 PR06.1 PR06.2 PR06.4 PR06.5
PR06.6 PR06.7 PR06.8 PR06.9 PR07.1 PR07.2
PR07.3 PR07.4 PR07.5 PR07.6 PR07.7 PR07.8
PR07.9 PR67.1 PR67.2 PR67.3 PR67.4 PR67.6
PR67.7 PR67.8 PR67.9 PR68.1 PR68.2 PR68.3
PR68.4 PR68.5 PR68.6 PR68.7 PR68.8 PR68.9
PR69.2 UK06.1 PR206 PR292 UK201

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTI-TAX-ID-CODE
Element: Tax Id Code		Alpha 10
Contains the user-defined tax authority.
PR06.1 PR06.2
PR06.4 PR06.5
PR06.6 PR06.7
PR06.8 PR06.9
PR07.1 PR07.2
PR07.3 PR07.4
PR07.5 PR07.6
PR07.7 PR07.8
PR07.9 PR67.1
PR67.2 PR67.3
PR67.4 PR67.6
PR67.7 PR67.8
PR67.9 PR68.1
PR68.2 PR68.3
PR68.4 PR68.5
PR68.6 PR68.7
PR68.8 PR68.9
PR69.2 UK06.1
PTI-COMPANY
Element: Company Hr		Numeric 4
Contains the company number for state type tax authorities that require this additional information for quarterly reporting.
PR06.2 PR06.4
PR06.5 PR06.6
PR06.7 PR06.8
PR06.9 PR07.1
PR07.2 PR07.3
PR07.4 PR07.5
PR07.6 PR07.7
PR07.8 PR07.9
PR67.1 PR67.2
PR67.3 PR67.4
PR67.6 PR67.7
PR67.8 PR67.9
PR68.1 PR68.2
PR68.3 PR68.4
PR68.5 PR68.6
PR68.7 PR68.8
PR68.9 PR69.2
UK06.1
PTI-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
Contains the process level for state type tax authorities that require this additional information for quarterly reporting.
PR06.2 PR06.4
PR06.5 PR06.6
PR06.7 PR06.8
PR06.9 PR07.1
PR07.2 PR07.3
PR07.4 PR07.5
PR07.6 PR07.7
PR07.8 PR07.9
PR67.1 PR67.2
PR67.3 PR67.4
PR67.6 PR67.7
PR67.8 PR67.9
PR68.1 PR68.2
PR68.3 PR68.4
PR68.5 PR68.6
PR68.7 PR68.8
PR68.9 PR69.2
UK06.1
PTI-TAX-ID-NBR
Element: Tax Id		Alpha 20
Contains the employer identification number associated with the tax authority.
PR06.1 PR06.2
PR69.2
PTI-EMP-ACCT-NBR
Element: Emp Acct Nbr		Alpha 20
Contains the employer account number associated with the tax authority.
PR06.1 PR06.2
PR69.2
PTI-CONTACT-TITLE
Element: Contact Title		Alpha 30
Contains the title of the individual who is the contact person. This applies only to states that required this additional information for quarterly reporting.
PR06.4 PR07.1
PR07.2 PR07.3
PR07.5 PR67.1
PR67.6 PR67.9
PR68.3 PR68.4
PTI-CONTACT-AREA
Element: Contact Area		Numeric 3
Contains the area code portion of the telephone number for the contact person defined for the tax authority. This applies to state type tax authorities that require this additional information for quarterly reporting.
PR06.4 PR07.1
PR07.2 PR07.3
PR07.5 PR67.1
PR67.6 PR67.9
PR68.3 PR68.4
PTI-CONTACT-PRE
Element: Contact Pre		Numeric 3
Contains the prefix portion of the telephone number for the contact person defined for the tax authority. This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR06.4 PR07.1
PR07.2 PR07.3
PR07.5 PR67.1
PR67.6 PR67.9
PR68.3 PR68.4
PTI-CONTACT-SUF
Element: Contact Suf		Numeric 4
Contains the suffix portion of the telephone number for the contact person defined for the tax authority. This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR06.4 PR07.1
PR07.2 PR07.3
PR07.5 PR67.1
PR67.6 PR67.9
PR68.3 PR68.4
PTI-CONTACT-EXT
Element: Contact Ext		Numeric 4
Contains the telephone extension number for the contact person defined for the tax authority. This applies only to state type tax authorities that require this additional information.
PR06.4 PR07.1
PR07.2 PR07.3
PR07.5 PR67.1
PR67.6 PR67.9
PR68.4
PTI-TAX-TYPE-CODE
Element: Tax Type Code		Alpha 1
Contains the value that indicates if the employer is a T (Taxable Employer) or a non-profit, R (Reimbursable Employer).
PR06.4 PR07.6
PR67.2 PR67.8
PR68.8
PTI-UI-TAX-RATE
Element: Ui Tax Rate		Signed 5.3
Contains the unemployment insurance tax rate defined for the tax authority. This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR06.4 PR06.8
PR06.9 PR07.1
PR07.2 PR07.5
PR67.1 PR67.2
PR67.3 PR67.9
PR68.1 PR68.2
PR68.3 PR68.4
PR68.5 PR68.7
PTI-UNDERPAYMENT
Element: Underpayment		Signed 11.2
Contains the underpayment from the previous quarter. This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR06.4 PR07.1
PR07.4 PR07.5
PR07.8 PR67.2
PR67.3 PR68.3
PR68.4 PR68.5
PTI-INTEREST
Element: Interest		Signed 11.2
Contains the interest amount associated with tax authority. This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR06.4 PR07.1
PR07.5 PR67.1
PR67.2 PR67.3
PR68.1 PR68.2
PR68.3 PR68.4
PR68.5 PR68.8
PTI-PENALTY
Element: Penalty		Signed 11.2
Contains the penalty amount associated with the tax authority. This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR06.4 PR07.1
PR07.5 PR67.1
PR67.2 PR67.3
PR68.3 PR68.4
PR68.5 PR68.8
PTI-CREDIT
Element: Credit		Signed 11.2
Contains credits or overpayments that are associated with the tax authority. This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR06.4 PR07.1
PR07.5 PR67.2
PR67.3 PR67.9
PR68.3 PR68.4
PR68.5
PTI-MONTH-1-EMPS
Element: Month 1 Emps		Numeric 7
Contains the number of employees covered by unemployment insurance who worked or received pay for the first month of the quarter, including the 12th day of the month. This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR06.4 PR06.7
PR06.8 PR06.9
PR07.1 PR07.2
PR07.3 PR07.4
PR07.5 PR07.6
PR07.8 PR07.9
PR67.1 PR67.2
PR67.3 PR67.4
PR67.9 PR68.1
PR68.2 PR68.3
PR68.4 PR68.5
PR68.6 PR68.7
PR68.8 PR68.9
PTI-MONTH-2-EMPS
Element: Month 2 Emps		Numeric 7
Contains the number of employees covered by unemployment insurance who worked or received pay in the second month of the quarter including the 12th day of the month. This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR06.4 PR06.7
PR06.8 PR06.9
PR07.1 PR07.2
PR07.3 PR07.4
PR07.5 PR07.6
PR07.8 PR07.9
PR67.1 PR67.2
PR67.3 PR67.4
PR67.9 PR68.1
PR68.2 PR68.3
PR68.4 PR68.5
PR68.6 PR68.7
PR68.8 PR68.9
PTI-MONTH-3-EMPS
Element: Month 3 Emps		Numeric 7
Contains the number of employees covered by unemployment insurance who worked or received pay for the third month of the quarter, including the 12th day of the month. This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR06.4 PR06.7
PR06.8 PR06.9
PR07.1 PR07.2
PR07.3 PR07.4
PR07.5 PR07.6
PR07.8 PR07.9
PR67.1 PR67.2
PR67.3 PR67.4
PR67.9 PR68.1
PR68.2 PR68.3
PR68.4 PR68.5
PR68.6 PR68.7
PR68.8 PR68.9
PTI-DOC-CNTRL-NBR
Element: Doc Cntrl Nbr		Alpha 9
Contains the document control number. This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR06.4 PR67.2
PR67.9 PR68.3
PR68.4
PTI-TAPE-AUTH-NBR
Element: Tape Auth Nbr		Numeric 4
Contains the number assigned when authorization is granted, WR-43 (Magnetic Tape Transmittal Form). This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR06.5 PR07.9
PR68.4 PR68.9
PTI-MULTI-CODE
Element: Multi Code		Numeric 1
Contains the value that indicates if the employer has employees in more than one county or industry. A value of 0 (zero) indicates No, and a value of 1 indicates Yes. This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR68.9
PTI-MULTI-LOC
Element: Multi Loc		Numeric 1
Contains the value that indicates if the employer has employees at more than one location within the county. A value of 1 indicates Yes, and zero indicates No. This applies only to state type tax authorities that require this additional information for quarterly reporting.
PR68.9
PTI-REMITTER-NBR
Element: Remitter Nbr		Numeric 6
Contains the remitter number assigned to the tax authority for the company or process level. The remitter number is used to track and process magnetic media. This only applies to state type tax authorities that require this additional information for quarterly reporting.
PR06.7 PR06.9
PR67.1 PR67.2
PR68.1 PR68.2
PR68.8
PTI-SUFFIX-CODE
Element: Suffix Code		Alpha 5
Contains the suffix code assigned to the company or process level. This only applies to state type tax authorities that require this additional information for quarterly reporting.
PR06.4 PR06.5
PR06.6 PR06.7
PR06.8 PR06.9
PR07.1 PR07.6
PR07.7 PR67.1
PR67.2 PR67.6
PR67.7 PR67.8
PR67.9 PR68.3
PR68.4
PTI-EMPLOY-CODE
Element: Employ Code		Alpha 1

A = Agriculture
H = Household
M = Military
Q = Medicare Qualified Gov't EE
X = Railroad
R = Regular
" " = Regular
PR06.2 PR67.2
PR69.2
PTI-TAX-DIST-NBR
Element: Tax Dist Nbr		Alpha 3
PR06.8 PR68.8
UK06.1
PTI-TAX-DIST-NAME
Element: Tax Dist Name		Alpha 40
PR67.2 PR68.3
UK06.1
PTI-TAX-OFF-REF
Element: Tax Off Ref		Alpha 7
PR68.6 UK06.1
PTI-YE-PERMIT-NBR
Element: Ye Permit Nbr		Alpha 12
PR07.7 UK06.1
PTI-ECON-NBR
Element: Econ Nbr		Alpha 9
To be valid, Econ Nbr field must be entered as an 'E' character followed by 7 digits between 3,000,000 and 3,900,000 then a final alphabetic character. Valid Examples could include E3121552K or E3899121M or E3000345H.
UK06.1
PTI-ADDR1
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
PR67.2 UK06.1
PTI-ADDR2
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
UK06.1
PTI-ADDR3
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
UK06.1
PTI-ADDR4
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
PR67.2 UK06.1
PTI-STATE
Element: State		Alpha 2
This field contains the two-character state code of the address.
PR67.2
PTI-ZIP
Element: Zip		Alpha 10
This field contains the postal code of the address.
PR67.2 UK06.1


PRTAXID FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTISET1 TAX-ID-CODE
COMPANY
PROCESS-LEVEL
...
BN297 BN299
HR00.1 HR01.1
PR06.1 PR06.2
PR06.4 PR06.5
PR06.6 PR06.7
PR06.8 PR06.9
PR07.1 PR07.2
PR07.3 PR07.4
PR07.5 PR07.6
PR07.7 PR07.8
PR07.9 PR160
PR180 PR206
PR227 PR250
PR251 PR252
PR253 PR287


PRTAXID FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
When PTI-COMPANY !=Zeroes
PTI-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Process Level PRSYSTEM Required
When PTI-COMPANY !=Zeroes
AndPTI-PROCESS-LEVEL !=Spaces
PTI-COMPANY->PRS-COMPANY
PTI-PROCESS-LEVEL->PRS-PROCESS-LEVEL
Tax Id Code PRTAXAUTH Required
PTI-TAX-ID-CODE->PRX-TAX-ID-CODE

File created: Wed Jun 08 20:51:13 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.