Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EFFECT-DATE


                              FIELD USAGE REPORT


    FIELDNAME - EFFECT-DATE   

  FieldName      In File     Element        Occurs    FldType    IndexUsg
-------------------------------------------------------------------------------
  EFFECT-DATE    ACSTRAUD    DATE                     FT_DB      SRASET1   
                             yyyymmdd,  8      

                 ADAMOUNTSX  EFFECT-DATE              FT_DB      BADSET1   
                             yyyymmdd,  8                        BADSET2   
                                                                 BADSET3   

                 ADAVGBAL    EFFECT-DATE              FT_DB      ADVSET1   
                             yyyymmdd,  8                        ADVSET2   

                 ADCFBAL     EFFECT-DATE              FT_DB      ADLSET1   
                             yyyymmdd,  8                        ADLSET2   

                 BNCHANGE    EFFECT-DATE              FT_DB      BNHSET1   
                             yyyymmdd,  8                        BNHSET2   

                 BNGRPCHG    EFFECT-DATE              FT_DB      BNGSET1   
                             yyyymmdd,  8                        BNGSET2   
                                                                 BNGSET4   

                 BNTRANS     EFFECT-DATE              FT_DB      BNTSET2   
                             yyyymmdd,  8      

                 CUCONV      EFFECT-DATE              FT_DB      CCNSET1   
                             yyyymmdd,  8                        CCNSET2   
                                                                 CCNSET3   

                 CUCONVREL   EFFECT-DATE              FT_DB      CURSET2   
                             yyyymmdd,  8      

                 DEDCODE     EFFECT-DATE              FT_DB      
                             yyyymmdd,  8      

                 EMDEDMASTR  EFFECT-DATE              FT_DB      EDMSET5   
                             yyyymmdd,  8      

                 FAMSTSHIST  EFFECT-DATE              FT_DB      FSHSET1   
                             yyyymmdd,  8      

                 GLCONTROL   EFFECT-DATE              FT_DB      
                             yyyymmdd,  8      

                 GLREMOTETX  EFFECT-DATE              FT_DB      
                             yyyymmdd,  8      

                 GLTRANS     EFFECT-DATE              FT_DB      
                             yyyymmdd,  8      

                 GLTRANSREL  EFFECT-DATE              FT_DB      
                             yyyymmdd,  8      

                 GMLABDIST   EFFECT-DATE              FT_DB      GMLSET3   
                             yyyymmdd,  8                        GMLSET4   
                                                                 GMLSET5   

                 GMLABDISTX  EFFECT-DATE              FT_DB      GMASET4   
                             yyyymmdd,  8                        GMASET5   
                                                                 GMASET6   

                 HISTERR     EFFECT-DATE              FT_DB      HERSET1   
                             yyyymmdd,  8                        HERSET2   
                                                                 HERSET3   

                 HRCONTNBR   EFFECT-DATE              FT_DB      
                             yyyymmdd,  8      

                 HRPOSUSD    EFFECT-DATE              FT_DB      HPDSET1   
                             yyyymmdd,  8                        HPDSET2   

                 HRSUPER     EFFECT-DATE              FT_DB      
                             yyyymmdd,  8      

                 HRWRKDTL    DATE                     FT_DB      WSDSET1   
                             yyyymmdd,  8                        WSDSET2   

                 HRWRKSCHD   DATE                     FT_DB      WSCSET1   
                             yyyymmdd,  8                        WSCSET2   

                 JOBCODE     EFFECT-DATE              FT_DB      
                             yyyymmdd,  8      

                 ONETMDED    EFFECT-DATE              FT_DB      OTDSET2   
                             yyyymmdd,  8                        OTDSET3   

                 PABUDGET    EFFECT-DATE              FT_DB      PABSET1   
                             yyyymmdd,  8                        PABSET2   
                                                                 PABSET3   

                 PAEMPAPTST  EFFECT-DATE              FT_DB      
                             yyyymmdd,  8      

                 PAEMPPOS    EFFECT-DATE              FT_DB      PEPSET1   
                             yyyymmdd,  8                        PEPSET2   
                                                                 PEPSET3   
                                                                 PEPSET4   
                                                                 PEPSET5   
                                                                 PEPSET6   
                                                                 PEPSET7   
                                                                 PEPSET9   

                 PAFOLLOWUP  EFFECT-DATE              FT_DB      PAFSET2   
                             yyyymmdd,  8      

                 PAGRDISTEP  EFFECT-DATE              FT_DB      PGISET2   
                             yyyymmdd,  8      

                 PAINCICOST  EFFECT-DATE              FT_DB      PAISET2   
                             yyyymmdd,  8      

                 PAJOBREQ    EFFECT-DATE              FT_DB      
                             yyyymmdd,  8      

                 PAOFFLANG   EFFECT-DATE              FT_DB      
                             yyyymmdd,  8      

                 PAPEPAUDIT  EFFECT-DATE              FT_DB      PEASET1   
                             yyyymmdd,  8                        PEASET2   
                                                                 PEASET3   

                 PAPOSCHG    EFFECT-DATE              FT_DB      PPCSET1   
                             yyyymmdd,  8      

                 PAPOSERR    EFFECT-DATE              FT_DB      PPESET1   
                             yyyymmdd,  8                        PPESET2   

                 PAPOSITION  EFFECT-DATE              FT_DB      POSSET1   
                             yyyymmdd,  8                        POSSET2   
                                                                 POSSET3   
                                                                 POSSET4   
                                                                 POSSET6   

                 PAPOSRULE   EFFECT-DATE              FT_DB      PPRSET1   
                             yyyymmdd,  8                        PPRSET2   
                                                                 PPRSET3   

                 PDCARD      DATE                     FT_DB      
                             yyyymmdd,  8      

                 PDPROGRAM   DATE                     FT_DB      
                             yyyymmdd,  8      

                 PERSACTHST  EFFECT-DATE              FT_DB      PAHSET1   
                             yyyymmdd,  8                        PAHSET4   
                                                                 PAHSET5   

                 PERSACTION  EFFECT-DATE              FT_DB      PCTSET1   
                             yyyymmdd,  8                        PCTSET2   
                                                                 PCTSET3   
                                                                 PCTSET4   

                 PRADIBON    EFFECT-DATE              FT_DB      PIBSET1   
                             yyyymmdd,  8                        PIBSET2   
                                                                 PIBSET3   

                 PRMINWAGE   EFFECT-DATE              FT_DB      PMWSET1   
                             yyyymmdd,  8                        PMWSET2   
                                                                 PMWSET3   

                 PROGPAY     EFFECT-DATE              FT_DB      PGPSET1   
                             yyyymmdd,  8                        PGPSET2   

                 PROGPAYEND  EFFECT-DATE              FT_DB      PEDSET1   
                             yyyymmdd,  8                        PEDSET2   

                 PROGPAYENT  EFFECT-DATE              FT_DB      PETSET1   
                             yyyymmdd,  8                        PETSET2   

                 PROGRATE    EFFECT-DATE              FT_DB      PGASET1   
                             yyyymmdd,  8                        PGASET2   

                 PRONWAGES   EFFECT-DATE              FT_DB      POWSET1   
                             yyyymmdd,  8      

                 PROTPAYPRD  EFFECT-DATE              FT_DB      PRYSET1   
                             yyyymmdd,  8                        PRYSET2   
                                                                 PRYSET3   

                 PROTWRKPRD  EFFECT-DATE              FT_DB      PRWSET1   
                             yyyymmdd,  8                        PRWSET2   
                                                                 PRWSET3   

                 PROVERTIME  EFFECT-DATE              FT_DB      PROSET1   
                             yyyymmdd,  8                        PROSET2   

                 PRPENFSRC   EFFECT-DATE              FT_DB      
                             yyyymmdd,  8      

                 PRPENPAY    EFFECT-DATE              FT_DB      PNPSET1   
                             yyyymmdd,  8                        PNPSET3   

                 PRRATES     EFFECT-DATE              FT_DB      PRRSET2   
                             yyyymmdd,  8      

                 PRSAGDTL    EFFECT-DATE              FT_DB      SGDSET1   
                             yyyymmdd,  8                        SGDSET2   
                                                                 SGDSET3   

                 PRSAGHEAD   EFFECT-DATE              FT_DB      SGHSET1   
                             yyyymmdd,  8                        SGHSET2   
                                                                 SGHSET3   

                 PRSHIFTHDR  EFFECT-DATE              FT_DB      PSHSET1   
                             yyyymmdd,  8                        PSHSET2   

                 PRSHIFTTBL  EFFECT-DATE              FT_DB      PSBSET1   
                             yyyymmdd,  8                        PSBSET2   
                                                                 PSBSET3   

                 PRTIMEDATE  EFFECT-DATE              FT_DB      PTMSET1   
                             yyyymmdd,  8                        PTMSET2   

                 PWCURATES   DATE                     FT_DB      PW6SET1   
                             yyyymmdd,  8      

                 STANDTIME   EFFECT-DATE              FT_DB      
                             yyyymmdd,  8      

                 TMLEAVE     EFFECT-DATE              FT_DB      TLVSET1   
                             yyyymmdd,  8                        TLVSET2   
                                                                 TLVSET3   
                                                                 TLVSET4   

                 TXTAXRATE   EFFECT-DATE              FT_DB      TXRSET1   
                             yyyymmdd,  8                        TXRSET2   
                                                                 TXRSET3   

                 TXTAXTABLE  EFFECT-DATE              FT_DB      TXTSET1   
                             yyyymmdd,  8      

                 UKNIRATES   EFFECT-DATE              FT_DB      NIRSET1   
                             yyyymmdd,  8                        NIRSET2   

                 UKTXCDUPL   EFFECT-DATE              FT_DB      UKLSET1   
                             yyyymmdd,  8      

                 WCCLASS     EFFECT-DATE              FT_DB      WCCSET1   
                             yyyymmdd,  8                        WCCSET2   

                 WCCLASSHDR  EFFECT-DATE              FT_DB      WCHSET1   
                             yyyymmdd,  8                        WCHSET2   
                                                                 WCHSET3   


                 In File     CndUsage                 DerivedUsage
                 --------------------------------------------------------------
                 ACSTRAUD    

                 ADAMOUNTSX  

                 ADAVGBAL    

                 ADCFBAL     

                 BNCHANGE    

                 BNGRPCHG    

                 BNTRANS     

                 CUCONV      

                 CUCONVREL   

                 DEDCODE     

                 EMDEDMASTR  

                 FAMSTSHIST  

                 GLCONTROL   

                 GLREMOTETX  

                 GLTRANS     

                 GLTRANSREL  

                 GMLABDIST   

                 GMLABDISTX  

                 HISTERR     

                 HRCONTNBR   

                 HRPOSUSD    

                 HRSUPER     

                 HRWRKDTL    

                 HRWRKSCHD   

                 JOBCODE     

                 ONETMDED    

                 PABUDGET    CURRENT                  

                 PAEMPAPTST  

                 PAEMPPOS    

                 PAFOLLOWUP  

                 PAGRDISTEP  

                 PAINCICOST  

                 PAJOBREQ    

                 PAOFFLANG   

                 PAPEPAUDIT  

                 PAPOSCHG    

                 PAPOSERR    

                 PAPOSITION  ACTIVE-CURRENT           
                             CURRENT                  

                 PAPOSRULE   

                 PDCARD      

                 PDPROGRAM   

                 PERSACTHST  

                 PERSACTION  LþC                      WF-PEND-ACT

                 PRADIBON    

                 PRMINWAGE   

                 PROGPAY     

                 PROGPAYEND  

                 PROGPAYENT  

                 PROGRATE    

                 PRONWAGES   

                 PROTPAYPRD  

                 PROTWRKPRD  

                 PROVERTIME  

                 PRPENFSRC   

                 PRPENPAY    

                 PRRATES     

                 PRSAGDTL    

                 PRSAGHEAD   

                 PRSHIFTHDR  

                 PRSHIFTTBL  

                 PRTIMEDATE  

                 PWCURATES   

                 STANDTIME   

                 TMLEAVE     

                 TXTAXRATE   

                 TXTAXTABLE  

                 UKNIRATES   

                 UKTXCDUPL   

                 WCCLASS     

                 WCCLASSHDR  


                 In File     RuleUsage
                 --------------------------------------------------------------
                 ACSTRAUD    

                 ADAMOUNTSX  

                 ADAVGBAL    

                 ADCFBAL     

                 BNCHANGE    

                 BNGRPCHG    

                 BNTRANS     

                 CUCONV      

                 CUCONVREL   

                 DEDCODE     

                 EMDEDMASTR  

                 FAMSTSHIST  

                 GLCONTROL   

                 GLREMOTETX  

                 GLTRANS     

                 GLTRANSREL  

                 GMLABDIST   

                 GMLABDISTX  

                 HISTERR     

                 HRCONTNBR   

                 HRPOSUSD    

                 HRSUPER     

                 HRWRKDTL    

                 HRWRKSCHD   

                 JOBCODE     

                 ONETMDED    

                 PABUDGET    

                 PAEMPAPTST  

                 PAEMPPOS    

                 PAFOLLOWUP  

                 PAGRDISTEP  

                 PAINCICOST  

                 PAJOBREQ    

                 PAOFFLANG   

                 PAPEPAUDIT  

                 PAPOSCHG    

                 PAPOSERR    

                 PAPOSITION  

                 PAPOSRULE   

                 PDCARD      

                 PDPROGRAM   

                 PERSACTHST  

                 PERSACTION  

                 PRADIBON    

                 PRMINWAGE   

                 PROGPAY     

                 PROGPAYEND  

                 PROGPAYENT  

                 PROGRATE    

                 PRONWAGES   

                 PROTPAYPRD  

                 PROTWRKPRD  

                 PROVERTIME  

                 PRPENFSRC   

                 PRPENPAY    

                 PRRATES     

                 PRSAGDTL    

                 PRSAGHEAD   

                 PRSHIFTHDR  

                 PRSHIFTTBL  

                 PRTIMEDATE  

                 PWCURATES   

                 STANDTIME   

                 TMLEAVE     

                 TXTAXRATE   

                 TXTAXTABLE  

                 UKNIRATES   

                 UKTXCDUPL   

                 WCCLASS     

                 WCCLASSHDR  


                 In File     Relation
                 --------------------------------------------------------------
                 ACSTRAUD    

                 ADAMOUNTSX  

                 ADAVGBAL     ADCFBAL

                 ADCFBAL      ADAVGBAL

                 BNCHANGE    

                 BNGRPCHG    

                 BNTRANS     

                 CUCONV      

                 CUCONVREL   

                 DEDCODE     

                 EMDEDMASTR  

                 FAMSTSHIST  

                 GLCONTROL   

                 GLREMOTETX  

                 GLTRANS     

                 GLTRANSREL  

                 GMLABDIST   

                 GMLABDISTX  

                 HISTERR      POSITION

                 HRCONTNBR   

                 HRPOSUSD     HR-HIST-DT
                              POSITION

                 HRSUPER     

                 HRWRKDTL     WORK-SCH

                 HRWRKSCHD    WORK-DTL

                 JOBCODE     

                 ONETMDED    

                 PABUDGET    

                 PAEMPAPTST  

                 PAEMPPOS    

                 PAFOLLOWUP  

                 PAGRDISTEP  

                 PAINCICOST  

                 PAJOBREQ    

                 PAOFFLANG   

                 PAPEPAUDIT   HRHISTORY
                              PAY-HIST

                 PAPOSCHG     POS-CHG-ERROR
                              POSITION

                 PAPOSERR     POS-CHG
                              POSITION

                 PAPOSITION   HR-HIST-DT
                              POS-CHG-ERROR
                              POS-USER
                              POSCHANGE
                              USER-FIELDS

                 PAPOSRULE   

                 PDCARD      

                 PDPROGRAM   

                 PERSACTHST   COMMENTS

                 PERSACTION  

                 PRADIBON     PROGPAY

                 PRMINWAGE   

                 PROGPAY      PROGPAYEND
                              PROGPAYENT
                              PROGRATE

                 PROGPAYEND  

                 PROGPAYENT  

                 PROGRATE     PROGPAY

                 PRONWAGES   

                 PROTPAYPRD   OVERTIME-PLAN

                 PROTWRKPRD   OVERTIME-PLAN

                 PROVERTIME   PAY-PRD-SCHED
                              WRK-PRD-SCHED

                 PRPENFSRC    PENS-PAYMENT

                 PRPENPAY    

                 PRRATES     

                 PRSAGDTL     SAG-HEAD
                              SAG-HEAD-G

                 PRSAGHEAD    RATE

                 PRSHIFTHDR   SHIFT-TABLE

                 PRSHIFTTBL   SHIFT-HEADER

                 PRTIMEDATE   OVERTIME-PLAN
                              PROTPAYPRD

                 PWCURATES   

                 STANDTIME   

                 TMLEAVE      TMLVLIMS

                 TXTAXRATE   

                 TXTAXTABLE  

                 UKNIRATES   

                 UKTXCDUPL   

                 WCCLASS      CLASS-HEADER

                 WCCLASSHDR   CLASSES