[Datamart-News] OSPS Datamart field addition

[Datamart Support]

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/20130408/6fe55d24/attachment.html>