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

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       The company number represents an
                       established company and is entered on
                       all function codes.

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: Sequence NumbeThe time sequence field insures the
                       record is unique.  It is incremented
                       automatically.

PPT-PAY-CODE           Alpha 4                                   HS35.1  HS36.1
Element: Payment 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: Account CategoAccount 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.

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: Accounting UniThe 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: Subaccount

PPT-PROCESS-LEVEL      Alpha 5                                   HS35.1  HS36.1
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

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: Grade         Contains the Pay Grade if used.

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

PPT-ATTEND-CODE        Alpha 2                                   HS35.1  HS36.1
Element: Attendance CodA 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.

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

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

PPT-COMMENT            Alpha 40  (Lower Case)                    HS35.1  HS36.1
Element: Comment Line  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
Account Currency
Code

PPT-LOCAT-CODE         Alpha 10
Element: Location

PPT-ABN-OBJ-ID         Numeric 12
Element: Abn Obj Id

PPT-PAY-UNITS          Signed 7.2
Element: Pay Units

PPT-UNIT-MEASURE       Alpha 12
Element: Unit Measure

                         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

PPTSET2   COMPANY       KeyChange
          EMPLOYEE
          PAY-CODE
          TIME-SEQ

PPTSET3   COMPANY       KeyChange
          EMPLOYEE
          ACTIVITY
          TIME-SEQ

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

PPTSET5   COMPANY       KeyChange
          EMPLOYEE
          STATUS
          TIME-SEQ

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

PPTSET7   COMPANY
          EMPLOYEE
          HISTORY
          DATE
          TIME-SEQ

                         PRPENDTIME FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Required

                            PPT-ACTIVITY         -> ACV-ACTIVITY  (ACVSET1)

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