TPPARAM

Tip Parameters

Contains all company and allocation level parameters necessary to run the Tips system. It is created and maintained in TP00.1 (Company Allocation). You can print the information in this file using TP200 (Allocation Level Listing).
UPDATED BY
PR195 PR197 PR582 PR82.1 PR85.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPP-COMPANY
Element: Company Hr
Numeric 4
PR195 PR197
PR582 PR82.1
PR85.1
TPP-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
Contains the process level the pay is associated with for allocation.
TPP-DEPARTMENT
Element: Department
Alpha 5
Contains the department the pay is associated with for allocation.
TPP-SHIFT
Element: Shift
Numeric 1
Contains the shift number the allocation is associated with.
TPP-ALLOC-METHOD
Element: Alloc Method
Alpha 1
Contains the value that determines the allocation method. Valid values are: G = Individual Gross Receipts. H = Hours Worked.
TPP-ALLOC-PCT
Element: Alloc Pct
Signed 7.3
Contains the allocation percent for the allocation method.
TPP-EST-NAME
Element: Est Name
Alpha 30 (Lower Case)
Contains the establishment name.
TPP-EST-ADDR1
Element: Est Addr1
Alpha 30 (Lower Case)
Contains the first line of the establishment address.
TPP-EST-ADDR2
Element: Est Addr2
Alpha 30 (Lower Case)
Contains the second line of the establishment address.
TPP-EST-ADDR3
Element: Est Addr3
Alpha 30 (Lower Case)
TPP-EST-ADDR4
Element: Est Addr4
Alpha 30 (Lower Case)
TPP-EST-CITY
Element: Est City
Alpha 58 (Lower Case)
Contains the city of the establishment address.
TPP-EST-STATE
Element: Est State
Alpha 2
Contains the state of the establishment address.
TPP-EST-ZIP
Element: Est Zip
Alpha 10
Contains the postal code of the establishment address.
TPP-EST-NBR
Element: Est Nbr
Alpha 30
Contains the establishment number.
TPP-LST-RUN-DATE
Element: Lst Run Date
Numeric 8 (yyyymmdd)
Contains the system date that defaults when you run TP100 (Shortfall Allocation Calculation).
TPP-LST-TIP-SEQ
Element: Lst Tip Seq
Numeric 4
Contains the number used to uniquely identify tip records.
PR195 PR197
PR582 PR82.1
PR85.1
TPP-CTRL-TOT-FLG
Element: Ctrl Tot Flg
Alpha 1
Contains the value that determines if the total employee gross receipts entered in TP20.2 (Employee Gross Receipts Allocation) must balance to the allocation level gross receipts before TP100 (Tip Shortfall Allocation) can be run.
TPP-TRAN-CONT-CODE
Element: Tran Cont Code
Alpha 5
Contains the Transmitter Control Code assigned by the IRS.
TPP-EST-TYPE
Element: Est Type
Alpha 1
Contains the value that identifies the type of establishment. Valid values are: 1 = Evening meals only. 2 = Evening and other meals. 3 = Meals other than evening meals. 4 = Alcoholic beverages.


TPPARAM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TPPSET1 COMPANY
PROCESS-LEVEL
DEPARTMENT
SHIFT
PR195 PR197
PR582 PR82.1
PR85.1


TPPARAM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TPP-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Department DEPTCODE Required
When TPP-DEPARTMENT !=Spaces
TPP-COMPANY->DPT-COMPANY
TPP-PROCESS-LEVEL->DPT-PROCESS-LEVEL
TPP-DEPARTMENT->DPT-DEPARTMENT
Process Level PRSYSTEM Required
When TPP-PROCESS-LEVEL !=Spaces
TPP-COMPANY->PRS-COMPANY
TPP-PROCESS-LEVEL->PRS-PROCESS-LEVEL


TPPARAM FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Emp Summ EMPSUMM Delete Restricted
TPP-COMPANY->ESM-COMPANY
TPP-PROCESS-LEVEL->ESM-PROCESS-LEVEL
TPP-DEPARTMENT->ESM-DEPARTMENT
TPP-SHIFT->ESM-SHIFT
  ESM-EMPLOYEE
  ESM-PAYROLL-YEAR
  ESM-LST-CALC-DATE
Tip Pay TIPPAY Delete Restricted
TPP-COMPANY->TIP-COMPANY
TPP-PROCESS-LEVEL->TIP-TIP-PROC-LEV
TPP-DEPARTMENT->TIP-TIP-DEPART
TPP-SHIFT->TIP-SHIFT
  TIP-EMPLOYEE
  TIP-WRK-END-DATE
  TIP-SEQ-NBR


File created: Thu Jun 09 02:33:04 2016

Home
Contact Us



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