/
SaltForecasts

SaltForecasts

Owned by Andrew Pierson (Unlicensed)
May 06, 2019

Information

  • Type: MS SQL Table

  • Schema: dbo

  • Data Origin:Data is provided from SALT delivery service.

  • Refresh Schedule: SaltForecasts table is refreshed by the APForecasts script each morning at 2:00AM by the RunForecasts batch file.

  • Script File Locations 

    • APForecasts: F:\TB-Applications\Tableau\APForecasts.R

    • RunForecasts: F:\TB-Applications\Tableau\RunForecasts.bat

Data Dictionary

Column NameData TypeDescription

CreatedDate

DateThe date that an order was attempted to be automatically filled by the SALT automated processor.
TransferStatusFactorTransfer status indicates the outcome of SALT's automated order processor. The statuses include: Blank, Delivered, and Failed which translate to business definitions of WIP, delivered order, and automated process failed, respectively.
QuantityNumericThe distinct count of invoice order numbers.

Schema Diagram

  • Data source is raw data from SALT

Related content