|
|
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).
REFERENCED BY
TP10.1 TP115 TP120 TP125 TP130 TP20.1
TP20.2 TP20.3 TP200 TP220 TP230 TP231
TP40.1 TP40.2 TP40.3 TP40.4
UPDATED BY
PR197 PR82.1 PR85.1 TP00.1 TP00.2 TP00.3
TP00.4 TP100 TP135 TP30.1 TP30.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPP-COMPANY Numeric 4 PR197 PR82.1
Element: Company Hr Identifies the AP company if the PR85.1 TP00.1
resource type = V. Identifies the HR TP00.2 TP00.3
company if the resource type = E. It is TP00.4
blank for type A, P or Q resources.
TPP-PROCESS-LEVEL Alpha 5 TP00.2 TP00.3
Element: Process Lev HrContains the process level the pay is TP00.4
associated with for allocation.
TPP-DEPARTMENT Alpha 5 TP00.3 TP00.4
Element: Department Contains the department the pay is
associated with for allocation.
TPP-SHIFT Numeric 1 TP00.4
Element: Shift Contains the shift number the
allocation is associated with.
TPP-ALLOC-METHOD Alpha 1 TP00.1 TP00.2
Element: Allocation MetContains the value that determines the TP00.3 TP00.4
allocation method. Valid values are:
G = Individual Gross Receipts.
H = Hours Worked.
TPP-ALLOC-PCT Signed 7.3 TP00.1 TP00.2
Element: Allocation PerContains the allocation percent for the TP00.3 TP00.4
allocation method.
TPP-EST-NAME Alpha 30 (Lower Case) TP00.1 TP00.2
Element: Establishment Contains the establishment name. TP00.3
TPP-EST-ADDR1 Alpha 30 (Lower Case) TP00.1 TP00.2
Establishment Contains the first line of the TP00.3
Address 1 establishment address.
TPP-EST-ADDR2 Alpha 30 (Lower Case) TP00.1 TP00.2
Establishment Contains the second line of the TP00.3
Address 2 establishment address.
TPP-EST-ADDR3 Alpha 30 (Lower Case) TP00.1 TP00.2
Element: Address 3 TP00.3
TPP-EST-ADDR4 Alpha 30 (Lower Case) TP00.1 TP00.2
Element: Address 4 TP00.3
TPP-EST-CITY Alpha 18 (Lower Case) TP00.1 TP00.2
Element: Establishment Contains the city of the establishment TP00.3
address.
TPP-EST-STATE Alpha 2 TP00.1 TP00.2
Element: Establishment Contains the state of the establishment TP00.3
address.
TPP-EST-ZIP Alpha 10 TP00.1 TP00.2
Establishment Zip Contains the postal code of the TP00.3
Code establishment address.
TPP-EST-NBR Alpha 30 TP00.1 TP00.2
Element: Establishment Contains the establishment number. TP00.3
TPP-LST-RUN-DATE Numeric 8 (yyyymmdd) TP00.1 TP00.2
Element: Last Run Date Contains the system date that defaults TP00.3 TP00.4
when you run TP100 (Shortfall Allocation TP100
Calculation).
TPP-LST-TIP-SEQ Numeric 4 PR197 PR82.1
Element: Lst Tip Seq Contains the number used to uniquely PR85.1 TP135
identify tip records. TP30.1 TP30.2
TPP-CTRL-TOT-FLG Alpha 1 TP00.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 TP00.1 TP00.2
Element: Tran Cont CodeContains the Transmitter Control Code TP00.3
assigned by the IRS.
TPP-EST-TYPE Alpha 1 TP00.1 TP00.2
Element: Est Type Contains the value that identifies the TP00.3
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 PR197 PR82.1
PROCESS-LEVEL PR85.1 TP00.1
DEPARTMENT TP00.2 TP00.3
SHIFT TP00.4 TP10.1
TP100 TP115
TP120 TP125
TP130 TP135
TP20.1 TP20.2
TP20.3 TP200
TP220 TP230
TP231 TP30.1
TP30.2 TP40.1
TP40.2 TP40.3
TP40.4
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
Alc Gross ALCGROSS Delete Restricted
TPP-COMPANY -> AGR-COMPANY
TPP-ALLOC-METHOD -> AGR-ALLOC-METHOD
TPP-PROCESS-LEVEL -> AGR-PROCESS-LEVEL
TPP-DEPARTMENT -> AGR-DEPARTMENT
TPP-SHIFT -> AGR-SHIFT
AGR-RECORD-DATE
Alc Summ ALCSUMM Delete Restricted
TPP-COMPANY -> ASM-COMPANY
TPP-PROCESS-LEVEL -> ASM-PROCESS-LEVEL
TPP-DEPARTMENT -> ASM-DEPARTMENT
TPP-SHIFT -> ASM-SHIFT
ASM-PAYROLL-YEAR
Emp Gross EMPGROSS Delete Restricted
TPP-COMPANY -> EGR-COMPANY
TPP-PROCESS-LEVEL -> EGR-PROCESS-LEVEL
TPP-DEPARTMENT -> EGR-DEPARTMENT
TPP-SHIFT -> EGR-SHIFT
EGR-RECORD-DATE
EGR-EMPLOYEE
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 Control TIPCTL Delete Restricted
TPP-COMPANY -> TPC-COMPANY
TPP-PROCESS-LEVEL -> TPC-PROCESS-LEVEL
TPP-DEPARTMENT -> TPC-DEPARTMENT
TPP-SHIFT -> TPC-SHIFT
TPC-RECORD-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
|
