[Datamart-News] OSPS Datamart field addition (revised)

[Datamart Support]

Due to some unforeseen circumstances, we will have to delay the population of the 'Position Num' field in the OSPS Labor Cost table of the Datamart.

Our revised plan is to populate the data with the next OSPS load of April. Therefore, on May 13, 2013, the field will be populated.

Thanks for your understanding and patience.

Aaron Wallace
Sr. Datamart Business Analyst
Department of Administrative Services
Data Classification: Level 1 - Published

From: datamart-news-bounces at listsmart.osl.state.or.us<mailto:datamart-news-bounces at listsmart.osl.state.or.us> [mailto:datamart-news-bounces at listsmart.osl.state.or.us] On Behalf Of Datamart Support
Sent: Monday, April 08, 2013 9:20 AM
To: datamart-news at listsmart.osl.state.or.us<mailto:datamart-news at listsmart.osl.state.or.us>
Subject: [Datamart-News] OSPS Datamart field addition

The Datamart team implemented a new column called "POSITION_NUM" to the following tables this past weekend:

OSPS_LABOR_COST
OSPS_LABOR_COST_B
OSPS_LABOR_COST_PB
OSPS_LABOR_COST_PP

The first month that will be populated will be for March 2013 - which will load the night of April 9.

The new field will be populated on a 'go forward' basis only. This means if you query data earlier than March 2013, the "Position_Num" field will be blank. In addition, only data from March 2013 forward will show actual information.

Please let me know if you have any questions.

Thanks,

Aaron Wallace
Sr. Datamart Business Analyst
Department of Administrative Services
Data Classification: Level 1 - Published
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20130416/726f63f9/attachment.html>