Time accruals screen

You must still be on TA ?? I don't have that table on my system. We have migrated to LP.
Or do you mean TAEMPSERV table?

TAEMPSERV
REFERENCED BY HR00.1 HR01.1 HR02.1 HR06.1 HR506 LP08.2
LP09.2 LP251 LP260 LP262 LP60.3 LP60.4
LP60.1 LP60.2 LP62.1 LP62.2 LP102 LP188
LP145 LP198 LP61.1


UPDATED BY BN134 BN150 BN305 BN66.1 HR11.1 HR11.2
HR511 PR521 LP130 LP140 LP197 LP353
LP53.1 LP54.1 LP553 LP554 PA02.1 PA100
PA102 PA115 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PR110 PR113
PR120 PR128 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR130 PR131 PR132 PR134 PR135
PR136 PR137 PR139 PR140 PR189 PR195
PR197 PR29.1 PR32.1 PR32.2 PR33.1 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR35.9 PR36.1 PR37.1 PR38.1
PR39.1 PR45.1 PR529 PR530 PR560 PR582
PR80.1 PR80.4 PR82.1 PR85.1 PR89.1 UK102
UK330 UK560 TA147 TP135

We still on TA but I am testing LP abs management. Yes, I meant TAEMPSERV table. I am having an issue with LP140 reporting records for dates that are not in the current processing period and I need to see where these records are comeing from. I browsed the taempserv table and they are no there. I browsed the TAemptrans table and see the records there but therewasn't any records when I ran LP140. 

I think you can see the service records on LP60

Perfect, I am able to see service records on LP60 screen and those recs are not there for the current pay period being processed. Hmm.... Thanks a lot!

Hi, can someone please help me understand the relation between the TAEMPSERV and the  TIMERECORDS table? I am running LP140 to calculate accruals for a pay period that hasn't closed yet. For some weird reason, LP140rpt is showing extra transactions from other pay periods and I have no idea where these records are coming from. I see them in the TAEMPTRANS table with a status = 2 (processed).  if there are only 2 records in the timerecord table and LP53, where are the extra records coming from?

I don't believe there is a relationship between TIMERECORD and LP. TIMERECORD is the before PR140 version of the data and I believe the LP140 processes records that have been processed. Have you looked at the DBURF for the LP140? It doesn't list TIMERECORD or PRTIME (the post PR140 version of the data).

Karen

DBURF for LP140
Updated Files
CKPOINT -
PRMONITOR -
TAEEMASTER -
TAEMPSERV -
TAEMPTRANS -
Referenced Files
DEPTCODE -
EMPLOYEE -
HREMPUSF -
HRHISTORY -
HRUSERFLDS -
OBJID -
PAEMPLOYEE -
PAEMPPOS -
PCODES -
PROVERTIME -
PRPROCGRP -
PRSYSTEM -
TAACCRUAL -
TACALC -
TAELIGIBLE -
TAENROLL -
TAFORMULAS -
TAFORMULAX -
TALIMIT -
TALOSHRS -
TAPAYROLL -
TAPLAN -
TASERVCODE -
TASERVICE -
TASERVRULE -
TASTRUCTUR -
TATABLE -
TATABLEX -
TATRANSUM -

According to my SchemaSpy output (attached), there is not a direct relationship between these two tables.

Thank you so much, Greg.