Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRTIME


                              PRTIME FILE

                       Employee Pay/Hours History

Contains employee pay and hours history information.

REFERENCED BY

BN305     BN340     BN345     BN66.1    HCDL.1    HR170
HR70.1    PA495     PA594     PR05.1    PR139     PR140
PR141     PR160     PR180     PR188     PR189     PR250
PR251     PR253     PR260     PR261     PR262     PR270
PR274     PR278     PR282     PR418     PR51.1    PR51.3
PR80.1    PR80.2    PR84.1    PR86.1    PR89.1    UK13.1
UK141     UK145     UK201     UK202     UK50.3    UK50.4
PR292     PR289     TA146     TA170     BN100     BN101
BN102     BN103     BN105     BN145     BN245     BN31.1
BN31.2    BN32.1    BN32.2    BN32.3    BN45.1    BN531
BN71.1    BN72.1    BS12.1    BS13.1    BS14.1    BS15.1
BS32.1    PR131     PR132     UK110     TA147     TM570
TM70.1    TM71.1    HR00.1    HR01.1    PR09.1    PR229
PR29.1    PR529

UPDATED BY

ET530     LP54.1    PR195     PR197     PR300     PR560
PR82.1    PR85.1    UK560

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PRT-COMPANY            Numeric 4                                 ET530   PR195
Element: Company Hr    Identifies the HR company if the          PR197   PR560
                       resource type = V.  Identifies the HR     PR82.1  PR85.1
                       company if the resource type = E.  It is  UK560
                       blank for type A, P or Q resources.

PRT-EMPLOYEE           Numeric 9                                 ET530   PR195
Element: Employee      Contains the employee number. Each        PR197   PR560
                       person employed by the company is         PR82.1  PR85.1
                       assigned a unique number. The system      UK560
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PRT-CHECK-ID           Numeric 12                                ET530   PR195
Element: Check Id      Contains the payment identification       PR197   PR560
                       number (unique payment identifier used    PR82.1  PR85.1
                       in tracking payment information).         UK560

PRT-PAY-SUM-GRP        Alpha 3                                   ET530   PR195
Element: Pay Sum Grp   Contains the pay summary group            PR197   PR560
                       associated with the time record.          PR82.1  PR85.1
                                                                 UK560

PRT-TIME-SEQ           Numeric 12                                ET530   PR195
Element: Time Seq      Contains the sequence number assigned     PR197   PR560
                       to the time record.                       PR82.1  PR85.1
                                                                 UK560

PRT-JOB-CODE           Alpha 9                                   ET530   PR195
Element: Job Code      Contains a user-defined code that         PR197   PR560
                       represents a type of job.                 PR82.1  PR85.1
                                                                 UK560

PRT-PROCESS-LEVEL      Alpha 5                                   ET530   PR195
Element: Process Lev Hr                                          PR197   PR560
                                                                 PR82.1  PR85.1
                                                                 UK560

PRT-WORK-STATE         Alpha 2                                   ET530   PR195
Element: Work State    Contains the 2-character value that       PR197   PR560
                       identifies employee's work state.         PR82.1  PR85.1
                                                                 UK560

PRT-HOURS              Signed 7.2                                BN31.1  BN31.2
Element: Hours         Contains the hours associated with the    BN32.1  BN32.2
                       time record.                              BN32.3  BN66.1
                                                                 ET530   PR140
                                                                 PR189   PR195
                                                                 PR197   PR278
                                                                 PR560   PR80.1
                                                                 PR82.1  PR85.1
                                                                 PR89.1  UK560

PRT-RATE               Signed 13.4                               ET530   PR195
Element: Rate          Contains the rate associated with the     PR197   PR82.1
                       time record.                              PR85.1  UK50.3

PRT-WAGE-AMOUNT        Signed 13.2                               BN66.1  ET530
Element: Wage Amount   Contains the wage amount associated       PR140   PR189
                       with the time record.                     PR195   PR197
                                                                 PR278   PR418
                                                                 PR560   PR80.1
                                                                 PR82.1  PR85.1
                                                                 PR89.1  UK560

PRT-DEPARTMENT         Alpha 5                                   ET530   PR195
Element: Department    Contains the department associated with   PR197   PR560
                       the time record.                          PR82.1  PR85.1
                                                                 UK560

PRT-PCT-DIST-FLAG      Alpha 1                                   ET530   PR195
Element: Pct Dist Flag Contains the value that indicates if      PR197   PR82.1
                       the system is to use the defined          PR85.1
                       override distribution information
                       instead of the normal general ledger
                       account defaulting for this time record.

PRT-SHIFT              Numeric 1                                 ET530   PR195
Element: Shift         Contains the shift number associated      PR197   PR560
                       with the pay.                             PR82.1  PR85.1
                                                                 UK560

PRT-DST-ACCT-UNIT      Alpha 15                                  ET530   PR195
Element: Acct Unit     Contains the general ledger accounting    PR197   PR560
                       unit to which the amount is posted.       PR82.1  PR85.1
                                                                 UK560

PRT-DST-ACCOUNT        Numeric 6                                 ET530   PR195
Element: Account       Contains the general ledger account to    PR197   PR560
                       which the amount is posted.               PR82.1  PR85.1
                                                                 UK560

PRT-DST-SUB-ACCT       Numeric 4                                 ET530   PR195
Element: Sub Acct      Contains the general ledger subaccount    PR197   PR560
                       to which the amount is posted.            PR82.1  PR85.1
                                                                 UK560

PRT-DIST-COMPANY       Numeric 4                                 ET530   PR195
Element: Company       Contains the company number to which      PR197   PR560
                       the transaction is posted. A valid        PR82.1  PR85.1
                       intercompany relationship must be         UK560
                       defined in the General Ledger system.

PRT-TR-DATE            Numeric 8  (yyyymmdd)                     ET530   PR195
Element: Tr Date       Contains the time record date.            PR197   PR560
                                                                 PR82.1  PR85.1
                                                                 UK560

PRT-UNION-CODE         Alpha 10                                  ET530   PR195
Element: Union Code    Contains the union code associated with   PR197   PR560
                       the time record.                          PR82.1  PR85.1
                                                                 UK560

PRT-OT-PREM-AMT        Signed 13.2                               BN66.1  ET530
Element: Ot Prem Amt   Contains the overtime premium amount      PR140   PR189
                       for the time record.                      PR195   PR197
                                                                 PR278   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 UK560

PRT-SHIFT-DIFF         Signed 13.2                               ET530   PR195
Element: Shift Diff    Contains the shift premium rate           PR197   PR82.1
                       associated  with the time record.         PR85.1

PRT-PAYROLL-YEAR       Numeric 4                                 ET530   PR195
Element: Payroll Year  Contains the payroll year associated      PR197   PR560
                       with the time record.                     PR82.1  PR85.1
                                                                 UK560

PRT-QUARTER            Numeric 1                                 ET530   PR195
Element: Quarter       Contains the fiscal quarter for the       PR197   PR560
                       data stored in this record.               PR82.1  PR85.1
                                                                 UK560

PRT-PCD-SEQ-NBR        Numeric 4                                 ET530   PR195
Element: Pcd Seq Nbr   Contains the sequence number associated   PR197   PR560
                       with the time record relative to the pay  PR82.1  PR85.1
                       code.                                     UK560

PRT-PER-END-DATE       Numeric 8  (yyyymmdd)                     ET530   PR195
Element: Per End Date  Contains the period end date associated   PR197   PR560
                       with the time record.                     PR82.1  PR85.1
                                                                 TA170   UK560

PRT-CHECK-TYPE         Alpha 1                                   ET530   PR195
Element: Check Type    Contains the payment type.                PR197   PR560
                       S = System                                PR82.1  PR85.1
                       M = Manual                                UK560
                       J = Adjustment
                       P = Partial ACH
                       R = Reversal
                       G = Gross Up
                       A = ACH

PRT-LOCAT-CODE         Alpha 10                                  ET530   PR195
Element: Locat Code                                              PR197   PR82.1
                                                                 PR85.1

PRT-WC-STATE           Alpha 2                                   ET530   PR195
Element: Wc State      Contains the workers' compensation        PR197   PR560
                       state associated with the time record.    PR82.1  PR85.1
                                                                 UK560

PRT-OT-RECORD          Alpha 1                                   ET530   PR195
Element: Ot Record     Contains the value that indicates if      PR197   PR82.1
                       the time record was created for           PR85.1
                       retroactive or overtime pay.
                       Y = Yes
                       R = Retro
                       F = Flex
                       T = Tips
                       U = Updated
                       X = Exemption Processed
                       O = Offset Time Record
                       P = Payout

PRT-POSITION           Alpha 12                                  ET530   PR195
Element: Position      Contains the user-defined code that       PR197   PR82.1
                       represents a position in the company.     PR85.1

PRT-ACTIVITY           Alpha 15                                  ET530   PR195
Element: Activity      Activities are the processes or           PR197   PR560
                       procedures that produce work. Cost        PR82.1  PR85.1
                       objects (products, services, customers,   UK560
                       and so on) are the reasons for
                       performing the activity.


PRT-ACCT-CATEGORY      Alpha 5                                   ET530   PR195
Element: Acct Category Account categories are groupings of       PR197   PR560
                       costs, revenues, or a combination of      PR82.1  PR85.1
                       both used for reporting and inquiries     UK560
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

PRT-TIME-ACC-FLAG      Alpha 1                                   ET530   PR195
Element: Time Acc Flag Contains an L (Last) if an employee is    PR197   PR82.1
                       terminating employment with the company   PR85.1
                       and you are issuing the final payment
                       through PR80.1 (Manual Payment).

PRT-SHFT-DIFF-RATE     Signed 13.4                               ET530   PR195
Element: Shft Diff Rate                                          PR197   PR82.1
                                                                 PR85.1

PRT-OT-RATE            Signed 13.4                               ET530   PR195
Element: Ot Rate                                                 PR197   PR82.1
                                                                 PR85.1

PRT-ATN-OBJ-ID         Numeric 12                                ET530   PR195
Element: Obj Id        This is the object identifier. It is      PR197   PR82.1
                       used to relate commitments or posted      PR85.1
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

PRT-GLT-OBJ-ID         Numeric 12                                ET530   PR195
Element: Obj Id        This is the object identifier. It is      PR197   PR82.1
                       used to relate commitments or posted      PR85.1
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

PRT-RECONCILED         Alpha 1                                   ET530   PR195
Element: Reconciled    Y = Yes                                   PR197   PR82.1
                       " " = No                                  PR85.1

PRT-TAX-FREQ-OVER      Numeric 1                                 ET530   PR195
Element: Tax Freq Over 1 = Weekly                                PR197   PR82.1
                       2 = Biweekly                              PR85.1
                       3 = Semi-monthly
                       4 = Monthly
                       5 = Daily
                       6 = Quarterly
                       7 = Semi-annually
                       8 = Annually

PRT-REMUN-CODE         Alpha 4                                   ET530   PR195
Element: Remun Code    Contains the remuneration code. Valid     PR197   PR82.1
                       value is C001 = Bonus.                    PR85.1
                       E002 = US Pay Advances
                       E003 = US Athletic Facilities
                       E004 = US Non-Qual Plan Awrds and Prz
                       E005 = US Back Pay
                       E006 = US Bonuses
                       E007 = US Business Expense
                       E009 = US Gifts
                       E010 = US Commissions
                       E013 = US Discounts
                       E014 = US Dismissal/Severance
                       E015 = US Educational Assistance
                       E016 = US Employment Agency
                       E017 = US Qual Equip/Tool/Uniform
                       E018 = US Business Use of Company Car
                       E019 = US Personal Use of Company Car
                       E020 = US No Additional Cost Services
                       E021 = US Golden Parachute
                       E022 = US Group Legal Services
                       E023 = US Guaranteed Wage
                       E024 = US Jury Duty Pay
                       E025 = US Below Market Loans to Empl
                       E026 = US Meals and Lodging
                       E027 = US Supplemental Military Pay
                       E028 = US Qualified Moving Expenses
                       E029 = US Non-Cash Fringe
                       E030 = US Outplacement Services
                       E031 = US Overtime
                       E032 = US Qualified Parking
                       E033 = US Pre-employment Reimbursmnt
                       E034 = US Probationary Pay
                       E035 = US Regular Wages
                       E036 = US Scholarships
                       E037 = US Sick/Disability Pay
                       E038 = US Standby/Idle Time
                       E039 = US Stock Purch & Incentive Pln
                       E040 = US Supper Money
                       E041 = US Supplemental Unemployment
                       E042 = US Taxes Paid by Employer
                       E043 = US Tips
                       E044 = US Travel; Exp Reimbursement
                       E045 = US Tuition Reimbursement
                       E046 = US Union Pay
                       E047 = US Vacation Pay
                       E048 = US Group Term Life G.T. 50000
                       E049 = US Ministers Housing Allowance
                       E999 = US Custom Earnings

PRT-BUS-NBR-GRP        Alpha 4                                   ET530   PR195
Element: Bus Nbr Grp   Contains the business number group.       PR197   PR560
                                                                 PR82.1  PR85.1
                                                                 UK560

PRT-REPORT-ENTITY      Alpha 5                                   ET530   PR195
Element: Report Entity Contains the report entity.               PR197   PR560
                                                                 PR82.1  PR85.1
                       Report Entity is the Process Level or     UK560
                       Company that this Process Level reports
                       to for tax reporting.  If the Process
                       Level itself is independent then the
                       independent Process Level is the Report
                       Entity.  If the Process Level is non
                       independent and is associated to a
                       independent head Process Level then the
                       independent head Process Level is the
                       Report Entity.  If the Process Level is
                       non independent and is not associated to
                       a independent head Process Level then
                       the Company is the Report Entity.

PRT-QC-ENT-NBR-GRP     Alpha 4                                   ET530   PR195
Element: Qc Ent Nbr GrpContains the Quebec Enterprise number     PR197   PR560
                       group.                                    PR82.1  PR85.1
                                                                 UK560

PRT-WC-CLASS           Alpha 4                                   ET530   PR195
Element: Wc Class      Contains the workers' compensation        PR197   PR560
                       class.                                    PR82.1  PR85.1

PRT-CURRENCY-CODE      Alpha 5                                   ET530   PR195
Element: Currency Code This field contains the company base      PR197   PR560
                       currency code established in Company      PR82.1  PR85.1
                       (GL10.1 ).                                UK560

PRT-CURR-ND            Numeric 1                                 ET530   PR195
Element: Acct Nd       The number of decimals assigned to a      PR197   PR560
                       particular account as determined by the   PR82.1  PR85.1
                       account currency.                         UK560


PRT-HM-PROCESS-LEV     Alpha 5                                   ET530   PR195
Element: Process Lev Hr                                          PR197   PR560
                                                                 PR82.1  PR85.1
                                                                 UK560

PRT-CA-WC-CLASS        Alpha 10                                  ET530   PR195
Element: Ca Wc Class   Contains the Canadian WC Class from       PR197   PR560
                       employees job. Use to identify the        PR82.1  PR85.1
                       PRTIME wages by WC Class.

PRT-COUNTRY-CODE       Alpha 2                                   ET530   PR195
Element: Country Code  The country code.  Required for VAT and   PR197   PR560
                       intrastat reporting.  Must be defined in  PR82.1  PR85.1
                        IN01.1 (Country Maintenance).            UK560

PRT-PENS-SEQ-NBR       Numeric 4                                 ET530   PR195
Element: Pens Seq Nbr                                            PR197   PR560
                                                                 PR82.1  PR85.1
                                                                 UK560

PRT-ABN-OBJ-ID         Numeric 12
Element: Abn Obj Id    This element is not used.

PRT-PAY-UNITS          Signed 7.2                                ET530   PR195
Element: Pay Units                                               PR197   PR560
                                                                 PR82.1  PR85.1

PRT-UNIT-MEASURE       Alpha 12                                  ET530   PR195
Element: Unit Measure                                            PR197   PR560
                                                                 PR82.1  PR85.1

PRT-USER-ID            Alpha 10  (Lower Case)                    ET530   LP54.1
Element: User                                                    PR195   PR197
                                                                 PR560   PR82.1
                                                                 PR85.1  UK560

PRT-DATE-STAMP         Numeric 8  (yyyymmdd)                     ET530   LP54.1
Element: Date Stamp    This field contains the server date       PR195   PR197
                       (month, date, and year) of the last       PR560   PR82.1
                       change to this record.                    PR85.1  UK560

PRT-NON-EARNINGS       Numeric 1                                 ET530   PR195
Element: Non Earnings  0 = No - wages                            PR197   PR560
                       1 = Yes - other remuneration              PR82.1  PR85.1

PRT-ORIG-OBJ-ID        Numeric 12                                ET530   PR195
Element: Orig Obj Id                                             PR197   PR82.1
                                                                 PR85.1

PRT-RECORD-TYPE        Alpha 1                                   ET530   PR195
Element: Record Type   This field identifies the type of         PR197   PR82.1
                       record defined.                           PR85.1

                       Valid values are:
                       S = Summary
                       D = Detail

PRT-ATTEND-CODE        Alpha 2                                   ET530   PR195
Element: Attend Code   A user-defined alphanumeric code that     PR197   PR82.1
                       represents a reason for an employee's     PR85.1
                       absence or hours worked.  Examples of
                       attendance codes are, sick, vacation,
                       overtime, on the job injury, snow day,
                       tardy, left early, and so on. Validated
                       in the Attendance Code file.

PRT-REASON-CODE        Alpha 4                                   ET530   LP54.1
Element: Ta Reason Cd                                            PR195   PR197
                                                                 PR560   PR82.1
                                                                 PR85.1  UK560

PRT-TES-OBJ-ID         Numeric 12                                ET530   PR195
Element: Tes Obj Id                                              PR197   PR560
                                                                 PR82.1  PR85.1
                                                                 UK560

PRT-RETRO-PENSION      Alpha 1                                   ET530   PR195
Element: Retro Pension " " = No                                  PR197   PR82.1
                       N = No                                    PR85.1
                       Y = Yes; open payment

PRT-SERVICE-CODE       Alpha 4                                   ET530   PR195
Element: Ta Service Cd                                           PR197   PR560
                                                                 PR82.1  PR85.1
                                                                 UK560

PRT-TIME-STAMP         Numeric 6  (hhmmss)                       ET530   LP54.1
Element: Time Stamp    Contains the server time (hour, minute,   PR195   PR197
                       and second) when the record was last      PR560   PR82.1
                       changed.                                  PR85.1  UK560

PRT-CREATE-DATE        Numeric 8  (yyyymmdd)                     ET530   PR195
Element: Date Stamp    This field contains the server date       PR197   PR560
                       (month, date, and year) of the last       PR82.1  PR85.1
                       change to this record.                    UK560

PRT-CREATE-TIME        Numeric 6  (hhmmss)                       ET530   PR195
Element: Time Stamp    Contains the server time (hour, minute,   PR197   PR560
                       and second) when the record was last      PR82.1  PR85.1
                       changed.                                  UK560

PRT-CREATE-USER-ID     Alpha 10  (Lower Case)                    ET530   PR195
Element: User Id       Contains the user ID of the person who    PR197   PR560
                       last changed this record.                 PR82.1  PR85.1
                                                                 UK560

                         PRTIME FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRTSET1   COMPANY                                                BN305   BN340
          EMPLOYEE                                               BN345   BN66.1
          CHECK-ID                                               ET530   HCDL.1
          PAY-SUM-GRP                                            HR170   HR70.1
          TIME-SEQ                                               PA495   PA594
                                                                 PR05.1  PR139
                                                                 PR140   PR141
                                                                 PR160   PR180
                                                                 PR188   PR189
                                                                 PR195   PR197
                                                                 PR250   PR251
                                                                 PR253   PR260
                                                                 PR261   PR262
                                                                 PR270   PR274
                                                                 PR278   PR282
                                                                 ...

PRTSET10  COMPANY       KeyChange
          HM-PROCESS-LEV
          EMPLOYEE
          CHECK-ID
          PAY-SUM-GRP
          TIME-SEQ

PRTSET2   COMPANY       KeyChange                                BN66.1  PR139
          EMPLOYEE                                               PR140   PR189
          PAYROLL-YEAR                                           PR195   PR292
          QUARTER                                                PR80.1  PR89.1
          PAY-SUM-GRP
          PROCESS-LEVEL
          WORK-STATE
          CHECK-ID
          TIME-SEQ

PRTSET3   COMPANY       KeyChange                                PR289   TA146
          EMPLOYEE                                               TA170
          PER-END-DATE
          CHECK-ID
          TIME-SEQ

PRTSET4   COMPANY       KeyChange                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          TR-DATE                                                BN105   BN145
          TIME-SEQ                                               BN245   BN31.1
          CHECK-ID                                               BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN340   BN45.1
                                                                 BN531   BN66.1
                                                                 BN71.1  BN72.1
                                                                 BS12.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  LP54.1
                                                                 PR131   PR132
                                                                 PR140   PR189
                                                                 PR195   PR278
                                                                 ...

PRTSET6   COMPANY       KeyChange                                HR00.1  HR01.1
          PROCESS-LEVEL                                          PR09.1  PR131
          TR-DATE
          EMPLOYEE
          TIME-SEQ
          CHECK-ID

PRTSET7   COMPANY       KeyChange                                PR131
          TR-DATE
          EMPLOYEE
          TIME-SEQ
          CHECK-ID

PRTSET8   COMPANY       Subset                                   ET530   PR160
          EMPLOYEE      Where PENS-SEQ-NBR != Zeroes             PR180   PR195
          PENS-SEQ-NBR                                           PR197   PR229
          CHECK-ID                                               PR29.1  PR529
          TIME-SEQ                                               PR560   PR80.2
                                                                 PR82.1  PR85.1
                                                                 UK560

PRTSET9   COMPANY       Subset                                   ET530
          EMPLOYEE      Where ORIG-OBJ-ID != Zeroes
          ORIG-OBJ-ID
          TIME-SEQ

                         PRTIME FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Category  ACACCTCAT    Required
                            When PRT-ACCT-CATEGORY != Spaces

                            PRT-ACCT-CATEGORY     -> AAX-ACCT-CATEGORY

Activity       ACACTIVITY   Required
                            When PRT-ACTIVITY   != Spaces
                            And  PRT-ATN-OBJ-ID != Zeroes

                            PRT-ACTIVITY          -> ACV-ACTIVITY

Actrans        ACTRANS      Not Required

                            PRT-ATN-OBJ-ID        -> ATN-OBJ-ID

Company        PRSYSTEM     Required

                            PRT-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Department     DEPTCODE     Required
                            When PRT-DEPARTMENT != Spaces

                            PRT-COMPANY           -> DPT-COMPANY
                            PRT-PROCESS-LEVEL     -> DPT-PROCESS-LEVEL
                            PRT-DEPARTMENT        -> DPT-DEPARTMENT

Dist Account   GLMASTER     Required
                            When PRT-DST-ACCOUNT != Zeroes

                            PRT-DIST-COMPANY      -> GLM-COMPANY
                            PRT-DST-ACCT-UNIT     -> GLM-ACCT-UNIT
                            PRT-DST-ACCOUNT       -> GLM-ACCOUNT
                            PRT-DST-SUB-ACCT      -> GLM-SUB-ACCOUNT

Dist Company   GLSYSTEM     Required
                            When PRT-DIST-COMPANY != Zeroes

                            PRT-DIST-COMPANY      -> GLS-COMPANY

Employee       EMPLOYEE     Required

                            PRT-COMPANY           -> EMP-COMPANY
                            PRT-EMPLOYEE          -> EMP-EMPLOYEE

Job Code       JOBCODE      Required
                            When PRT-JOB-CODE != Spaces

                            PRT-COMPANY           -> JBC-COMPANY
                            PRT-JOB-CODE          -> JBC-JOB-CODE

Pay Code       PRPAYCODE    Required

                            PRT-COMPANY           -> PCD-COMPANY
                            PRT-PCD-SEQ-NBR       -> PCD-SEQ-NBR

Pay Sum Group  PAYSUMGRP    Required

                            PRT-COMPANY           -> PSG-COMPANY
                            PRT-PAY-SUM-GRP       -> PSG-PAY-SUM-GRP

Paymastr       PAYMASTR     Required

                            PRT-COMPANY           -> PYM-COMPANY
                            PRT-EMPLOYEE          -> PYM-EMPLOYEE
                            PRT-CHECK-ID          -> PYM-CHECK-ID

Prcheck        PRCHECK      Required

                            PRT-COMPANY           -> PCH-COMPANY
                            PRT-CHECK-ID          -> PCH-CHECK-ID

Process Level  PRSYSTEM     Required

                            PRT-COMPANY           -> PRS-COMPANY
                            PRT-PROCESS-LEVEL     -> PRS-PROCESS-LEVEL

Prqcentgrp     PRQCENTGRP   Not Required

                            PRT-COMPANY           -> PQC-COMPANY
                            PRT-PROCESS-LEVEL     -> PQC-PROCESS-LEVEL
                            PRT-QC-ENT-NBR-GRP    -> PQC-QC-ENT-NBR-GRP

Reason Code    TAREASCODE   Required
                            When (PRT-REASON-CODE != Spaces )

                            PRT-COMPANY           -> TRE-COMPANY
                            PRT-REASON-CODE       -> TRE-REASON-CODE

Service Code   TASERVCODE   Required
                            When (PRT-SERVICE-CODE != Spaces )

                            PRT-COMPANY           -> TSC-COMPANY
                            PRT-SERVICE-CODE      -> TSC-SERVICE-CODE

Taempserv      TAEMPSERV    Not Required
                            Valid When PRT-TES-OBJ-ID != Zeroes

                            PRT-COMPANY           -> TES-COMPANY
                            PRT-EMPLOYEE          -> TES-EMPLOYEE
                            PRT-TES-OBJ-ID        -> TES-TES-OBJ-ID

Trsgblck       TRSGBLCK     Not Required

                            PRT-COMPANY           -> TRS-COMPANY
                            PRT-EMPLOYEE          -> TRS-EMPLOYEE
                            PRT-TIME-SEQ          -> TRS-TIME-SEQ

Union          PCODES       Required
                            When PRT-UNION-CODE != Spaces

                            "UN"                  -> PCO-TYPE
                            PRT-UNION-CODE        -> PCO-CODE

Wc Province    PRPROVINCE   Required
                            When (PRT-WC-STATE    != Spaces )
                            And  (PRT-CA-WC-CLASS != Spaces )

                            PRT-WC-STATE          -> PPV-PROVINCE

Wc State       PRSTATE      Required
                            When (PRT-WC-STATE != Spaces )
                            And  (PRT-WC-CLASS != Spaces )

                            PRT-WC-STATE          -> PSA-STATE

Work Province  PRPROVINCE   Required
                            When (PRT-WORK-STATE  != Spaces )
                            And  (PRT-CA-WC-CLASS != Spaces )

                            PRT-WORK-STATE        -> PPV-PROVINCE

Work State     PRSTATE      Required
                            When (PRT-WORK-STATE != Spaces )
                            And  (PRT-WC-CLASS   != Spaces )

                            PRT-WORK-STATE        -> PSA-STATE

                         PRTIME FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pay Classes    PSGRELATE

                            PRT-COMPANY           -> PSR-COMPANY
                            PRT-PAY-SUM-GRP       -> PSR-PAY-SUM-GRP
                                                     PSR-PAY-CLASS

Position       PAPOSITION
                            Valid When PRT-POSITION != Spaces

                            PRT-COMPANY           -> POS-COMPANY
                            PRT-POSITION          -> POS-POSITION
                                                     POS-EFFECT-DATE