Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRPENDTIME


                            PRPENDTIME FILE

The Pending Time Record file contains time records that have been input
through the Web Time Entry process.

REFERENCED BY

HS34.1    PR20.4

UPDATED BY

HS04.1    HS35.1    HS36.1    HS535     HR11.1    PA115


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PPT-COMPANY            Numeric 4                                 HS35.1  HS36.1
Element: Company Hr

PPT-EMPLOYEE           Numeric 9                                 HS35.1  HS36.1
Element: 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.

PPT-TIME-SEQ           Numeric 12                                HS35.1  HS36.1
Element: Time Seq      The time sequence field insures the
                       record is unique.  It is incremented
                       automatically.

PPT-PAY-CODE           Alpha 4                                   HS35.1  HS36.1
Element: Pay Code      Contains the pay code. A pay code is a
                       user-defined code that identifies a kind
                       of pay.

PPT-HOURS              Signed 7.2                                HS04.1  HS35.1
Element: Hours         Contains the hours.                       HS36.1

PPT-DATE               Numeric 8  (yyyymmdd)                     HS35.1  HS36.1
Element: Date          This field contains the time record
                       date.

PPT-RATE               Signed 13.4                               HS35.1  HS36.1
Element: Rate          Contains the pay rate.

PPT-JOB-CODE           Alpha 9                                   HS35.1  HS36.1
Element: Job Code      Contains a user-defined code that
                       represents a type of job.

PPT-POSITION           Alpha 12                                  HS35.1  HS36.1
Element: Position      Contains the user-defined code that
                       represents a position in the company.

PPT-SHIFT              Numeric 1                                 HS35.1  HS36.1
Element: Shift         Contains the shift number associated
                       with the pay.

PPT-ACTIVITY           Alpha 15                                  HS35.1  HS36.1
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


PPT-ACCT-CATEGORY      Alpha 5                                   HS35.1  HS36.1
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       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

PPT-GL-COMPANY         Numeric 4                                 HS35.1  HS36.1
Element: Company       This field represents the General
                       Ledger Company this time record is
                       associated with.

PPT-ACCT-UNIT          Alpha 15                                  HS35.1  HS36.1
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


PPT-ACCOUNT            Numeric 6                                 HS35.1  HS36.1
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

PPT-SUB-ACCOUNT        Numeric 4                                 HS35.1  HS36.1
Element: Sub Acct      This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

PPT-PROCESS-LEVEL      Alpha 5                                   HS35.1  HS36.1
Element: Process Lev Hr

PPT-DEPARTMENT         Alpha 5                                   HS35.1  HS36.1
Element: Department    Contains the department.

PPT-SCHEDULE           Alpha 9                                   HS35.1  HS36.1
Element: Schedule      Contains the pay schedule if used.

PPT-PAY-GRADE          Alpha 3                                   HS35.1  HS36.1
Element: Pay Grade     Contains the Pay Grade if used.

PPT-PAY-STEP           Numeric 2                                 HS35.1  HS36.1
Element: Pay Step      Contains the Pay Step if used.

PPT-ATTEND-CODE        Alpha 2                                   HS35.1  HS36.1
Element: Attend Code   A user-defined alphanumeric code that
                       represents a reason for an employee's
                       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.

PPT-OCCURRENCE         Alpha 1                                   HS35.1  HS36.1
Element: Occurrence    Contains the attendance occurrence if
                       used.

PPT-STATUS             Numeric 1                                 HS04.1  HS35.1
Element: Status        This field displays the status of the     HS36.1  HS535
                       transaction.
                       0 = Entered
                       1 = Submitted
                       2 = Approved
                       3 = On Hold
                       4 = Rejected
                       5 = Entered; historical
                       6 = Submitted; historical
                       7 = Approved; historical
                       8 = On Hold; historical
                       9 = Rejected; historical

PPT-USER-ID            Alpha 10  (Lower Case)                    HS04.1  HS35.1
Element: User                                                    HS36.1  HS535

PPT-PROXY-ID           Alpha 10  (Lower Case)                    HS35.1
Element: Proxy Id

PPT-COMMENT            Alpha 40  (Lower Case)                    HS35.1  HS36.1
Element: Comment       This field contains the comment
                       narrative.

PPT-MANAGER-ID         Alpha 10  (Lower Case)                    HS35.1  HS36.1
Element: Manager Id    Contains the Id of the manager who
                       approved the record.

PPT-HISTORY            Alpha 1                                   HS35.1  HS36.1
Element: History       Y = Yes
                       N = No

PPT-USERFIELD1         Alpha 10                                  HS35.1  HS36.1
Element: Userfield1    Contains users specified information.

PPT-USERFIELD2         Alpha 10                                  HS35.1  HS36.1
Element: Userfield2    Contains user specified information.

PPT-TIMECARD-TYPE      Numeric 1                                 HS04.1  HS35.1
Element: Timecard Type Contains the time card type.  Valid       HS36.1
                       values are:

                       0 = Normal.

                       1 = Exception.
                       2

PPT-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

PPT-CURR-ND            Numeric 1
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


PPT-LOCAT-CODE         Alpha 10
Element: Locat Code

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

PPT-PAY-UNITS          Signed 7.2
Element: Pay Units

PPT-UNIT-MEASURE       Alpha 12
Element: Unit Measure

PPT-REASON-CODE        Alpha 4
Element: Ta Reason Cd

PPT-DATE-STAMP         Numeric 8  (yyyymmdd)                     HS04.1  HS36.1
Element: Date Stamp    This field contains the server date       HS535
                       (month, date, and year) of the last
                       change to this record.

PPT-TIME-STAMP         Numeric 6  (hhmmss)                       HS04.1  HS36.1
Element: Time Stamp    Contains the server time (hour, minute,   HS535
                       and second) when the record was last
                       changed.

PPT-CREATE-DATE        Numeric 8  (yyyymmdd)                     HS36.1
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

PPT-CREATE-TIME        Numeric 6  (hhmmss)                       HS36.1
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

PPT-CREATE-USER-ID     Alpha 10  (Lower Case)                    HS36.1
Element: User Id       Contains the user ID of the person who
                       last changed this record.

                         PRPENDTIME FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PPTSET1   COMPANY                                                HR11.1  PA115
          EMPLOYEE                                               HS34.1  HS35.1
          TIME-SEQ                                               HS36.1  PR20.4

PPTSET4   COMPANY                                                HS04.1  HS35.1
          EMPLOYEE                                               HS36.1  HS535
          DATE
          TIME-SEQ

PPTSET6   COMPANY                                                HS35.1  HS36.1
          EMPLOYEE
          TIME-SEQ*

                         PRPENDTIME FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Required

                            PPT-ACTIVITY         -> ACV-ACTIVITY

Acuom          ACUOM        Required
                            When PPT-UNIT-MEASURE != Spaces

                            PPT-UNIT-MEASURE     -> UOM-UNIT-MEASURE

Deptcode       DEPTCODE     Required

                            PPT-COMPANY          -> DPT-COMPANY
                            PPT-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            PPT-DEPARTMENT       -> DPT-DEPARTMENT

Employee       EMPLOYEE     Required

                            PPT-COMPANY          -> EMP-COMPANY
                            PPT-EMPLOYEE         -> EMP-EMPLOYEE

Jobcode        JOBCODE      Required

                            PPT-COMPANY          -> JBC-COMPANY
                            PPT-JOB-CODE         -> JBC-JOB-CODE

Prsystem       PRSYSTEM     Required

                            PPT-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

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

                            PPT-COMPANY          -> TRE-COMPANY
                            PPT-REASON-CODE      -> TRE-REASON-CODE