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 |