Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TPPARAM


                              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