PRPENDTIME – Pending Time Record

System: Payroll (PR)
Prefix: PPT
Primary key: COMPANY, EMPLOYEE, TIME-SEQ
Fields: 45
Updated by: 9 programs
Referenced by: 1 program

PRPENDTIME is the Pending Time Record table in Lawson Payroll (prefix PPT). It is indexed by COMPANY, EMPLOYEE, TIME-SEQ (PPTSET1); alternate indexes: PPTSET4, PPTSET6 and PPTSET7. It is related 1:1 to ACACTIVITY, ACUOM, DEPTCODE, EMPLOYEE, JOBCODE, PRSYSTEM and TAREASCODE. It is updated by HR11.1, HS04.1, HS19.2, HS35.1, HS36.1, HS535, HS536, PA115 and 1 more and referenced by HS34.1. The table has 45 fields, 4 indexes and 7 documented relations.

About PRPENDTIME

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

Fields (45)

Column = COBOL field name without the PPT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PPT-COMPANY` PK COMPANY	Numeric 4	—	HS19.2, HS35.1, HS36.1
`PPT-EMPLOYEE` PK EMPLOYEE	Numeric 9	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.	HS19.2, HS35.1, HS36.1
`PPT-TIME-SEQ` PK TIME_SEQ	Numeric 12	The time sequence field insures the record is unique. It is incremented automatically.	HS19.2, HS35.1, HS36.1
`PPT-PAY-CODE` PAY_CODE	Alpha 4	Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.	HS19.2, HS35.1, HS36.1
`PPT-HOURS` HOURS	Signed 7.2	Contains the hours.	HS04.1, HS19.2, HS35.1, HS36.1
`PPT-DATE` DATE	Numeric 8 (yyyymmdd)	This field contains the time record date.	HS19.2, HS35.1, HS36.1
`PPT-RATE` RATE	Signed 13.4	Contains the pay rate.	HS35.1, HS36.1
`PPT-JOB-CODE` JOB_CODE	Alpha 9	Contains a user-defined code that represents a type of job.	HS35.1, HS36.1
`PPT-POSITION` POSITION	Alpha 12	Contains the user-defined code that represents a position in the company.	HS35.1, HS36.1
`PPT-SHIFT` SHIFT	Numeric 1	Contains the shift number associated with the pay.	HS35.1, HS36.1
`PPT-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	HS35.1, HS36.1
`PPT-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	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	HS35.1, HS36.1
`PPT-GL-COMPANY` GL_COMPANY	Numeric 4	This field represents the General Ledger Company this time record is associated with.	HS35.1, HS36.1
`PPT-ACCT-UNIT` ACCT_UNIT	Alpha 15	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.	HS35.1, HS36.1
`PPT-ACCOUNT` ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	HS35.1, HS36.1
`PPT-SUB-ACCOUNT` SUB_ACCOUNT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	HS35.1, HS36.1
`PPT-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	—	HS35.1, HS36.1
`PPT-DEPARTMENT` DEPARTMENT	Alpha 5	Contains the department.	HS35.1, HS36.1
`PPT-SCHEDULE` SCHEDULE	Alpha 9	Contains the pay schedule if used.	HS35.1, HS36.1
`PPT-PAY-GRADE` PAY_GRADE	Alpha 3	Contains the Pay Grade if used.	HS35.1, HS36.1
`PPT-PAY-STEP` PAY_STEP	Numeric 2	Contains the Pay Step if used.	HS35.1, HS36.1
`PPT-ATTEND-CODE` ATTEND_CODE	Alpha 2	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.	HS35.1, HS36.1
`PPT-OCCURRENCE` OCCURRENCE	Alpha 1	Contains the attendance occurrence if used.	HS35.1, HS36.1
`PPT-STATUS` STATUS	Numeric 1	This field displays the status of the 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	HS04.1, HS35.1, HS36.1, HS535
`PPT-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	HS19.2, HS35.1, HS36.1, HS535
`PPT-PROXY-ID` PROXY_ID	Alpha 10 (Lower Case)	—	HS35.1
`PPT-COMMENT` COMMENT	Alpha 40 (Lower Case)	This field contains the comment narrative.	HS35.1, HS36.1
`PPT-MANAGER-ID` MANAGER_ID	Alpha 10 (Lower Case)	Contains the Id of the manager who approved the record.	HS04.1, HS19.2, HS35.1, HS36.1
`PPT-HISTORY` HISTORY	Alpha 1	— `Y` Yes `N` No	HS35.1, HS36.1
`PPT-USERFIELD1` USERFIELD1	Alpha 10	Contains users specified information.	HS35.1, HS36.1
`PPT-USERFIELD2` USERFIELD2	Alpha 10	Contains user specified information.	HS35.1, HS36.1
`PPT-TIMECARD-TYPE` TIMECARD_TYPE	Numeric 1	Contains the time card type. Valid values are: 2 `0` Normal. `1` Exception.	HS04.1, HS19.2, HS35.1, HS36.1
`PPT-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	—
`PPT-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	—
`PPT-LOCAT-CODE` LOCAT_CODE	Alpha 10	—	HS36.1
`PPT-ABN-OBJ-ID` ABN_OBJ_ID	Numeric 12	This element is not used.	HS19.2
`PPT-PAY-UNITS` PAY_UNITS	Signed 7.2	—	HS36.1
`PPT-UNIT-MEASURE` UNIT_MEASURE	Alpha 12	—	—
`PPT-REASON-CODE` REASON_CODE	Alpha 4	—	—
`PPT-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	HS04.1, HS19.2, HS36.1, HS535
`PPT-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	HS04.1, HS19.2, HS36.1, HS535
`PPT-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	HS19.2, HS36.1
`PPT-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	HS19.2, HS36.1
`PPT-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	Contains the user ID of the person who last changed this record.	HS19.2, HS36.1
`PPT-MEMO` MEMO	Alpha 64 (Lower Case)	—	HS19.2, HS35.1

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PPTSET1`	`COMPANY`, `EMPLOYEE`, `TIME-SEQ`	Primary		HR11.1, HS19.2, PA115, HS34.1, HS35.1, HS36.1, PR20.4
`PPTSET4`	`COMPANY`, `EMPLOYEE`, `DATE`, `TIME-SEQ`			HS04.1, HS35.1, HS36.1, HS535, HS536
`PPTSET6`	`COMPANY`, `EMPLOYEE`, `TIME-SEQ*`			HS19.2, HS35.1, HS36.1
`PPTSET7`	`COMPANY`, `ABN-OBJ-ID`, `EMPLOYEE`, `TIME-SEQ`	Subset	Where ABN-OBJ-ID != Zeroes	—

Relations

One to one (7) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`
Reason Code	TAREASCODE	Required	When (PPT-REASON-CODE != Spaces)	`PPT-COMPANY` → `TRE-COMPANY`, `PPT-REASON-CODE` → `TRE-REASON-CODE`

Programs

Updated by (9)

HR11.1 Employee
HS04.1 Time Record Status Update
HS19.2 Employee Paid Time Off Request
HS35.1 Pending Time Records
HS36.1 Pending Time Records
HS535 Pending Time Record Extract
HS536 Pending Time Record Purge
PA115 Employee Purge
PR20.4 Pay Code

Referenced by (1)

HS34.1 Prpendtime Edit Program