TPPARAM FILE
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
ET530 PR195 PR197 PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPP-COMPANY Numeric 4 ET530 PR195
Element: Company Hr PR197 PR82.1
PR85.1
TPP-PROCESS-LEVEL Alpha 5
Element: Process Lev HrContains the process level the pay is
associated with for allocation.
TPP-DEPARTMENT Alpha 5
Element: Department Contains the department the pay is
associated with for allocation.
TPP-SHIFT Numeric 1
Element: Shift Contains the shift number the
allocation is associated with.
TPP-ALLOC-METHOD Alpha 1
Element: Alloc Method Contains the value that determines the
allocation method. Valid values are:
G = Individual Gross Receipts.
H = Hours Worked.
TPP-ALLOC-PCT Signed 7.3
Element: Alloc Pct Contains the allocation percent for the
allocation method.
TPP-EST-NAME Alpha 30 (Lower Case)
Element: Est Name Contains the establishment name.
TPP-EST-ADDR1 Alpha 30 (Lower Case)
Element: Est Addr1 Contains the first line of the
establishment address.
TPP-EST-ADDR2 Alpha 30 (Lower Case)
Element: Est Addr2 Contains the second line of the
establishment address.
TPP-EST-ADDR3 Alpha 30 (Lower Case)
Element: Est Addr3
TPP-EST-ADDR4 Alpha 30 (Lower Case)
Element: Est Addr4
TPP-EST-CITY Alpha 18 (Lower Case)
Element: Est City Contains the city of the establishment
address.
TPP-EST-STATE Alpha 2
Element: Est State Contains the state of the establishment
address.
TPP-EST-ZIP Alpha 10
Element: Est Zip Contains the postal code of the
establishment address.
TPP-EST-NBR Alpha 30
Element: Est Nbr Contains the establishment number.
TPP-LST-RUN-DATE Numeric 8 (yyyymmdd)
Element: Lst Run Date Contains the system date that defaults
when you run TP100 (Shortfall Allocation
Calculation).
TPP-LST-TIP-SEQ Numeric 4 ET530 PR195
Element: Lst Tip Seq Contains the number used to uniquely PR197 PR82.1
identify tip records. PR85.1
TPP-CTRL-TOT-FLG Alpha 1
Element: Ctrl Tot Flg 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 Alpha 5
Element: Tran Cont CodeContains the Transmitter Control Code
assigned by the IRS.
TPP-EST-TYPE Alpha 1
Element: Est Type 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 ET530 PR195
PROCESS-LEVEL PR197 PR82.1
DEPARTMENT PR85.1
SHIFT
TPPARAM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|