Transaction Date Filters
Data is extracted from Lawson System Foundation (LSF) into IRC using the Payroll Insight for Lawson and analyzed. Transaction date filters are used for scoping during extraction and analysis.
This table lists the objects, date fields for full extraction, date fields for Incremental extraction, and additional filters.
Note: Incremental extraction is supported only by the Lawson 10.x Insight.
| Object name | Date field for full extraction | Index for full extraction | Date field for incremental extraction | Index for incremental extraction |
|---|---|---|---|---|
| APPLICANT | NA | NA | NA | NA |
| ATTENDCODE | NA | NA | NA | NA |
| ATTENDHIST | R_DATE | ATHSET1 | DATE_
STAMP |
ATHSET5 |
| BENEFICRY | NA | NA | NA | NA |
| BENEFIT | NA | NA | NA | NA |
| BNCHANGE | CREATE_
DATE |
BNHSET3 | DATE_
STAMP |
BNHSET3 |
| BNCOVERAGE | NA | NA | NA | NA |
| DEDCODE | NA | NA | NA | NA |
| EMACHDEPST | NA | NA | NA | NA |
| EMDEDMASTR | NA | NA | NA | NA |
| EMPINVEST | CREATION_
DATE |
EMISET3 | UPD_DATE | EMISET3 |
| EMPLOYEE | NA | NA | NA | NA |
| EMSTATUS | NA | NA | NA | NA |
| HRHISTORY | DATE_
STAMP |
HRHSET5 | NA | NA |
| INTERVIEW | IV_DATE | ITVSET2 | NA | NA |
| JOBCODE | NA | NA | NA | NA |
| LPEMPLEAVE | CREATE_
DATE |
LELSET4 | DATE_
STAMP |
LELSET4 |
| PAEMPLOYEE | NA | NA | NA | NA |
| PAEMPPOS | NA | NA | NA | NA |
| PAJOBREQ | REQUEST_
DATE |
PJRSET7 | DATE_
STAMP |
PJRSET7 |
| PAPOSITION | NA | NA | NA | NA |
| PAREQOFFER | R_DATE | PRFSET1 | DATE_
STAMP |
PRFSET3 |
| PAYDEDUCTN | REFER PAYMASTR DATE FOR EXTRACTION | REFER PAYMASTR INDEX FOR EXTRACTION | NA | NA |
| PAYMASTR | CHECK_
DATE |
PYMSET4 | DATE_
STAMP |
PYMSET6 |
| PERSACTHST | DATE_
STAMP |
PAHSET6 | NA | NA |
| PRAUDIT | R_DATE | PRUSET3 | CHECK_
DATE |
PRUSET3 |
| PRCHECK | CHECK_
DATE |
PCHSET9 | NA | NA |
| PRDISTRIB | REFER PAYMASTR DATE FOR EXTRACTION | REFER PAYMASTR INDEX FOR EXTRACTION | NA | NA |
| PREMDEDHST | NA | NA | NA | NA |
| PROVERTIME | NA | NA | NA | NA |
| PRPAYCODE | NA | NA | NA | NA |
| PRRATEHIST | DATE_
STAMP |
PRHSET5 | NA | NA |
| PRSYSTEM | NA | NA | NA | NA |
| PRTIME | CREATE_
DATE |
PRTSET13 | DATE_
STAMP |
PRTSET13 |
| STANDTIME | CREATE_
DATE |
STMSET7 | DATE_
STAMP |
STMSET7 |
| TAEMPTRANS | CREATE_
DATE |
TTRSET10 | DATE_
STAMP |
TTRSET10 |