Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Data Derivation and Data Rederivation Rules

Data Derivation and Data Rederivation Rules

Employee
    Employee. Age, Years- Derivation!
        Employee. Age, Years = Current Date - Employee. Birth Date
Well Type. Code, Derivation!
    Derive: On initial data entry
    Rederive:  When contributor's data value changes
    When Well Casing Type  Code = 'Black Steel' & Well. Depth <= 10
       Feet
    Well Type. Code = '1'
    When Well Casing Type  Code = 'Black Steel' & Well. Depth > 11 Feet
       & <= 100 Feet
    Well Type. Code = '2'
    When Well Casing Type  Code = 'Black Steel' & Well. Depth > 300
       Feet
    Well Type. Code = '3'
    And so on…
Product Shipment
    Product Shipment. Product Count, Derivation!
        Product Shipment. Product Count = Count of unique Products in
            Product Shipment
        Derive:  When Product Shipment Status. Code ='C'
        Rederive: None
    Product Shipment. Total Weight, Derivation!
        Product Shipment. Total Weight = Sum of all Product Load.
            Weight in Product Shipment
        Derive:  When Product shipment Status Code = 'C'
        Rederive:  None
    Product Shipment. Average Product Weight, Derivation!
        Produce Shipment. Average Product Weight = Product Shipment.
            Total Weight / Product Shipment. Product Count
        Derive: When contributors have been derived.
        Rederive:  None
Vehicle
    Vehicle. Yearly Miles, Derivation!
        January 1 {Sum Vehicle Trip. Miles} December 31
        Derive:  January 15 of following calendar year
        Rederive:  None


					  


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint