CRITICAL PATH ITEMS OR NEXT STEPS
Load historical data (Oct 2013 through Feb 2014)
02-08-2014
02-15-2014
 
PathNet Classic was being replaced by Cerner’s PathNet Module. In order to maintain reporting capabilities for the Lab, we needed to integrate PathNet data into the CDW and modify MicroStrategy to report from the new data source.   
Canceled
There are still open questions around two fact tables and the supporting ETL loads. Further data validation is needed. The open questions mean that additional research and testing is needed.
New request or projects
Created on Feb.  2, 2014 at  9:00 PM (EST). Owned by Willard, Richie.
Richie Willard
Show fields from Show fields from Show fields from a related table
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
Please wait while your new report is saved...
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:

Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

  • If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
  • If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistencies—in this case, changing all locations to New York. Then try the conversion again.

Read more about converting a column into a table.