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
PR195 PR197 PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPP-COMPANY Numeric 4 PR195 PR197
Company The company number represents an PR82.1 PR85.1
established company and is entered on
all function codes.
TPP-PROCESS-LEVEL Alpha 5
Process Level Contains the process level the pay is
associated with for allocation.
TPP-DEPARTMENT Alpha 5
Department Contains the department the pay is
associated with for allocation.
TPP-SHIFT Numeric 1
Shift Contains the shift number the
allocation is associated with.
TPP-ALLOC-METHOD Alpha 1
Allocation 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
Allocation Percent Contains the allocation percent for the
allocation method.
TPP-EST-NAME Alpha 30 (Lower Case)
Establishment Name Contains the establishment name.
TPP-EST-ADDR1 Alpha 30 (Lower Case)
Establishment Contains the first line of the
Address 1 establishment address.
TPP-EST-ADDR2 Alpha 30 (Lower Case)
Establishment Contains the second line of the
Address 2 establishment address.
TPP-EST-ADDR3 Alpha 30 (Lower Case)
Address 3
TPP-EST-ADDR4 Alpha 30 (Lower Case)
Address 4
TPP-EST-CITY Alpha 21 (Lower Case)
Establishment City Contains the city of the establishment
address.
TPP-EST-STATE Alpha 2
Establishment State Contains the state of the establishment
address.
TPP-EST-ZIP Alpha 10
Establishment Zip Contains the postal code of the
Code establishment address.
TPP-EST-NBR Alpha 30
Establishment Number Contains the establishment number.
TPP-LST-RUN-DATE Numeric 8 (yyyymmdd)
Last Run Date Contains the system date that defaults
when you run TP100 (Shortfall Allocation
Calculation).
TPP-LST-TIP-SEQ Numeric 4 PR195 PR197
Lst Tip Seq Contains the number used to uniquely PR82.1 PR85.1
identify tip records.
TPP-CTRL-TOT-FLG Alpha 1
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
Tran Cont Code Contains the Transmitter Control Code
assigned by the IRS.
TPP-EST-TYPE Alpha 1
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 PR195 PR197
PROCESS-LEVEL PR82.1 PR85.1
DEPARTMENT
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
|
