Lawson Insight Technical Documentation

                              FIELD USAGE REPORT


    FIELDNAME - DEPARTMENT    

  FieldName      In File     Element        Occurs    FldType    IndexUsg
-------------------------------------------------------------------------------
  DEPARTMENT     ALCGROSS    DEPARTMENT               FT_DB      AGRSET1   
                             Alpha,  5         

                 ALCSUMM     DEPARTMENT               FT_DB      ASMSET1   
                             Alpha,  5         

                 ATTENDHIST  DEPARTMENT               FT_DB      
                             Alpha,  5         

                 DEPTCODE    DEPARTMENT               FT_DB      DPTSET1   
                             Alpha,  5                           DPTSET2   

                 DEPTSEGBLK  DEPARTMENT               FT_DB      DSGSET1   
                             Alpha,  5         

                 EEODETAIL   DEPARTMENT               FT_DB      EODSET1   
                             Alpha,  5                           EODSET2   
                                                                 EODSET3   

                 EMDISTMAST  DEPARTMENT               FT_DB      
                             Alpha,  5         

                 EMPGROSS    DEPARTMENT               FT_DB      EGRSET1   
                             Alpha,  5                           EGRSET2   

                 EMPLOYEE    DEPARTMENT               FT_DB      EMPSET2   
                             Alpha,  5         

                 EMPSUMM     DEPARTMENT               FT_DB      ESMSET1   
                             Alpha,  5                           ESMSET2   
                                                                 ESMSET3   
                                                                 ESMSET4   

                 GMEFFORT    DEPARTMENT               FT_DB      EFHSET2   
                             Alpha,  5         

                 JOBCODE     DEPARTMENT               FT_DB      
                             Alpha,  5         

                 OSHA        DEPARTMENT               FT_DB      
                             Alpha,  5         

                 OSHESTDTL   DEPARTMENT               FT_DB      ODTSET1   
                             Alpha,  5                           ODTSET2   
                                                                 ODTSET3   
                                                                 ODTSET4   

                 PAASSIGNED  DEPARTMENT               FT_DB      PAASET1   
                             Alpha,  5                           PAASET2   

                 PABUDGET    DEPARTMENT               FT_DB      PABSET1   
                             Alpha,  5                           PABSET2   
                                                                 PABSET3   

                 PACANEEA    DEPARTMENT               FT_DB      PCESET1   
                             Alpha,  5                           PCESET2   
                                                                 PCESET3   

                 PAEMPPOS    DEPARTMENT               FT_DB      PEPSET5   
                             Alpha,  5                           PEPSET7   

                 PAENCUMBER  DEPARTMENT               FT_DB      PENSET1   
                             Alpha,  5                           PENSET2   

                 PAGRDI      DEPARTMENT               FT_DB      
                             Alpha,  5         

                 PAJOBREQ    DEPARTMENT               FT_DB      PJRSET3   
                             Alpha,  5         

                 PAPOSITION  DEPARTMENT               FT_DB      POSSET3   
                             Alpha,  5         

                 PAPOSRULE   DEPARTMENT               FT_DB      PPRSET1   
                             Alpha,  5                           PPRSET2   
                                                                 PPRSET3   

                 PAYMASTR    DEPARTMENT               FT_DB      
                             Alpha,  5         

                 PBDISTRIB   DEPARTMENT               FT_DB      
                             Alpha,  5         

                 PBHSTDTL    DEPARTMENT               FT_DB      
                             Alpha,  5         

                 PERSACTION  DEPARTMENT               FT_DB      
                             Alpha,  5         

                 PRBATCH     DEPARTMENT               FT_DB      
                             Alpha,  5         

                 PRDISTRIB   DEPARTMENT               FT_DB      
                             Alpha,  5         

                 PRFUNDSRC   DEPARTMENT               FT_DB      PFSSET1   
                             Alpha,  5                           PFSSET2   
                                                                 PFSSET3   

                 PRPENDTIME  DEPARTMENT               FT_DB      
                             Alpha,  5         

                 PRQUALIFY   DEPARTMENT               FT_DB      
                             Alpha,  5         

                 PRRATES     DEPARTMENT               FT_DB      PRRSET2   
                             Alpha,  5         

                 PRTIME      DEPARTMENT               FT_DB      
                             Alpha,  5         

                 PWEMPLY     DEPARTMENT               FT_DB      
                             Alpha,  5         

                 STANDTIME   DEPARTMENT               FT_DB      
                             Alpha,  5         

                 TAEMPSERV   DEPARTMENT               FT_DB      TESSET3   
                             Alpha,  5                           TESSET4   
                                                                 TESSET5   

                 TAENROLL    DEPARTMENT               FT_DB      TENSET1   
                             Alpha,  5                           TENSET2   
                                                                 TENSET3   

                 TIMERECORD  DEPARTMENT               FT_DB      
                             Alpha,  5         

                 TIPCTL      DEPARTMENT               FT_DB      TPCSET1   
                             Alpha,  5         

                 TMTIME      DEPARTMENT               FT_DB      
                             Alpha,  5         

                 TPPARAM     DEPARTMENT               FT_DB      TPPSET1   
                             Alpha,  5         


                 In File     CndUsage                 DerivedUsage
                 --------------------------------------------------------------
                 ALCGROSS    

                 ALCSUMM     

                 ATTENDHIST  DEPARTMENT               

                 DEPTCODE    

                 DEPTSEGBLK  

                 EEODETAIL   DEPARTMENT               

                 EMDISTMAST  DEPARTMENT               

                 EMPGROSS    

                 EMPLOYEE    DEPARTMENT               
                             PRPENFSRC:DEPT-EXISTS    

                 EMPSUMM     DEPARTMENT               

                 GMEFFORT    

                 JOBCODE     DEPARTMENT               

                 OSHA        DEPARTMENT               

                 OSHESTDTL   DEPARTMENT               

                 PAASSIGNED  DEPARTMENT               
                             NO-DEPT                  

                 PABUDGET    DEPARTMENT               

                 PACANEEA    DEPT-EXISTS              

                 PAEMPPOS    DEPARTMENT               

                 PAENCUMBER  DEPARTMENT               
                             NO-DEPT                  

                 PAGRDI      DEPARTMENT               

                 PAJOBREQ    DEPARTMENT               

                 PAPOSITION  DEPARTMENT               

                 PAPOSRULE   DEPARTMENT               
                             NO-DEPT                  

                 PAYMASTR    DEPARTMENT               

                 PBDISTRIB   

                 PBHSTDTL    

                 PERSACTION  DEPARTMENT               

                 PRBATCH     DEPARTMENT               

                 PRDISTRIB   DEPARTMENT               

                 PRFUNDSRC   

                 PRPENDTIME  

                 PRQUALIFY   DEPARTMENT               

                 PRRATES     DEPARTMENT               

                 PRTIME      DEPARTMENT               

                 PWEMPLY     

                 STANDTIME   DEPARTMENT               

                 TAEMPSERV   DEPARTMENT               

                 TAENROLL    DEPARTMENT               

                 TIMERECORD  DEPARTMENT               

                 TIPCTL      DEPARTMENT               

                 TMTIME      

                 TPPARAM     DEPARTMENT               


                 In File     RuleUsage
                 --------------------------------------------------------------
                 ALCGROSS    

                 ALCSUMM     

                 ATTENDHIST  

                 DEPTCODE    

                 DEPTSEGBLK  

                 EEODETAIL   

                 EMDISTMAST  

                 EMPGROSS    

                 EMPLOYEE    Assign TIMERECORD:

                 EMPSUMM     

                 GMEFFORT    

                 JOBCODE     

                 OSHA        

                 OSHESTDTL   

                 PAASSIGNED  

                 PABUDGET    

                 PACANEEA    

                 PAEMPPOS    

                 PAENCUMBER  

                 PAGRDI      

                 PAJOBREQ    

                 PAPOSITION  

                 PAPOSRULE   

                 PAYMASTR    

                 PBDISTRIB   

                 PBHSTDTL    

                 PERSACTION  

                 PRBATCH     

                 PRDISTRIB   

                 PRFUNDSRC   

                 PRPENDTIME  

                 PRQUALIFY   

                 PRRATES     

                 PRTIME      

                 PWEMPLY     

                 STANDTIME   

                 TAEMPSERV   

                 TAENROLL    

                 TIMERECORD  Assign

                 TIPCTL      

                 TMTIME      

                 TPPARAM     


                 In File     Relation
                 --------------------------------------------------------------
                 ALCGROSS     DEPARTMENT
                              TIP-PAY
                              TP-CONTROL
                              TPPARAM

                 ALCSUMM      ALC-GROSS
                              DEPARTMENT
                              EMP-SUMM
                              TIP-CONTROL
                              TIP-PAY
                              TPPARAM

                 ATTENDHIST   DEPARTMENT

                 DEPTCODE     ASSN-RESOURCE
                              BUDGET
                              DEPTSEGBLK
                              EMPLOYEE
                              PAENCUMBER
                              POSITION

                 DEPTSEGBLK   DEPARTMENT

                 EEODETAIL    DEPARTMENT

                 EMDISTMAST   DEPARTMENT

                 EMPGROSS     ALC-GROSS
                              ALC-SUMM
                              DEPARTMENT
                              EMP-SUMM
                              TIP-CONTROL
                              TIP-PAY
                              TPPARAM

                 EMPLOYEE     BNEMPGRNT:DEPARTMENT
                              DEPARTMENT
                              PATHFIND:DEPARTMENT
                              PRPENFSRC:PRFUNDSRC

                 EMPSUMM      ALC-GROSS
                              ALC-SUMM
                              DEPARTMENT
                              TIP-CONTROL
                              TIP-PAY
                              TPPARAM

                 GMEFFORT     DEPTCODE

                 JOBCODE      DEPARTMENT

                 OSHA         DEPARTMENT

                 OSHESTDTL    DEPARTMENT

                 PAASSIGNED   BUDGET
                              DEPARTMENT
                              PAENCUMBER
                              POS-RULES
                              REQ-NO-POS

                 PABUDGET     DEPARTMENT
                              PAENCUMBER
                              POS-RULES
                              REQ-JOB

                 PACANEEA     DEPARTMENT

                 PAEMPPOS     DEPARTMENT

                 PAENCUMBER   DEPARTMENT

                 PAGRDI       DEPARTMENT

                 PAJOBREQ     DEPARTMENT
                              POS-RULES

                 PAPOSITION   DEPARTMENT
                              POS-RULE

                 PAPOSRULE    DEPARTMENT

                 PAYMASTR     DEPARTMENT

                 PBDISTRIB   

                 PBHSTDTL    

                 PERSACTION   DEPARTMENT

                 PRBATCH      DEPARTMENT

                 PRDISTRIB    DEPARTMENT

                 PRFUNDSRC    DEPARTMENT

                 PRPENDTIME   DEPTCODE

                 PRQUALIFY    DEPARTMENT

                 PRRATES      DEPARTMENT

                 PRTIME       DEPARTMENT

                 PWEMPLY     

                 STANDTIME    DEPARTMENT

                 TAEMPSERV    DEPARTMENT

                 TAENROLL     DEPARTMENT

                 TIMERECORD   DEPARTMENT

                 TIPCTL       DEPARTMENT

                 TMTIME       DEPARTMENT

                 TPPARAM      ALC-GROSS
                              ALC-SUMM
                              DEPARTMENT
                              EMP-GROSS
                              EMP-SUMM
                              TIP-CONTROL
                              TIP-PAY