PBTIME FILE

                            Pay to Bill Time

REFERENCED BY

PBWC.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RTB-COMPANY          Numeric 4
Company              The company number represents an
                     established company and is entered on
                     all function codes.

RTB-EMPLOYEE         Numeric 9
Employee             Contains the employee number. Each
                     person employed by the company is
                     assigned a unique number. The system
                     uses the employee number to correlate
                     all of the information related to that
                     person.

RTB-CHECK-ID         Numeric 12
Internal Check ID    Contains the payment identification
Number               number (unique payment identifier used
                     in tracking payment information).

RTB-PAY-SUM-GRP      Alpha 3
Payment Summary
Group

RTB-TIME-SEQ         Numeric 12
Sequence Number

RTB-DED-GRP-AMT      Signed 15.2
Ded Grp Amt

RTB-DED-GRP-AMT-WC   Signed 15.2
Ded Grp Amt Wc

RTB-DED-GRP-AMT-SU   Signed 15.2
Ded Grp Amt Su

RTB-PCT-RATE-1       Signed 8.5
Pct Rate 1

RTB-PCT-RATE-2       Signed 8.5
Pct Rate 2

RTB-AMT-RATE-1       Signed 6.2
Amt Rate 1

RTB-AMT-RATE-2       Signed 6.2
Amt Rate 2

RTB-GROSS-AMT-1      Signed 15.2
Gross Amt 1

RTB-GROSS-AMT-2      Signed 15.2
Gross Amt 2

RTB-CLIENT-JOBID     Alpha 20
Client Jobid

RTB-TIME-USER-FLD    Alpha 20
Time User Fld

RTB-UNITS-AMOUNT     Signed 15.2
Units Amount         This is the units amount included in
                     the file.

RTB-UNIT-MEASURE     Alpha 12
Unit Measure

RTB-RATE             Signed 13.4
Rate                 Contains the percentage rate.

RTB-GROSS-CALC-AMT   Signed 15.2
Gross Calc Amt

RTB-CHECK-TYPE       Alpha 1
Payment Type         Contains the payment type.
                     S = System
                     M = Manual
                     J = Adjustment
                     P = Partial ACH
                     R = Reversal

                         PBTIME FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RTBSET1   COMPANY                                                PBWC.1
          EMPLOYEE
          CHECK-ID
          PAY-SUM-GRP
          TIME-SEQ

                         PBTIME FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Prtime         PRTIME       Required

                            RTB-COMPANY        -> PRT-COMPANY
                            RTB-EMPLOYEE       -> PRT-EMPLOYEE
                            RTB-CHECK-ID       -> PRT-CHECK-ID
                            RTB-PAY-SUM-GRP    -> PRT-PAY-SUM-GRP
                            RTB-TIME-SEQ       -> PRT-TIME-SEQ