OSPS E-News ~ FW: OSPS Datamart field addition

[Announcements from OSPS to the users of the Oregon State Payroll Application]

OSPS is forwarding this message on behalf of the Datamart Support team.

Thank you,
Sandy

Sandy Ridderbusch, Oregon Statewide Payroll Services - (503) 373-0198
Visit Our Online Resource Center: http://oregon.gov/DAS/EGS/FBS/OSPS/

From: 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
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/osps-news/attachments/20130408/4a613b0a/attachment.html>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: ATT00001.txt
URL: <https://omls.oregon.gov/pipermail/osps-news/attachments/20130408/4a613b0a/attachment.txt>