[Datamart-News] OPSA Datamart field update (new)

[Klopfenstein, Theresa]

THANK YOU.  Much needed field


Theresa Klopfenstein, CPP Payroll Accountant 3
Oregon State Police
255 Capitol Street NE, Suite 400                                                                      PEBB OPEN ENROLLMENT
Salem,OR 97310                                                                                                     September 1 through October 31
Office Phone : (503) 934-0206                                                                          Don't Forget to Renew or Enroll
Fax: (503) 378-8282
  tklopfe at osp.state.or.us                                                                                 ePaystub effective 12/1/13

http://www.oregon.gov/DAS/EGS/FBS/OSPS/epayroll/Pages/index.aspx

From: Datamart-News [mailto:datamart-news-bounces at listsmart.osl.state.or.us] On Behalf Of WALLACE Aaron * EGS
Sent: Monday, October 21, 2013 9:12 AM
To: datamart-news at listsmart.osl.state.or.us
Subject: [Datamart-News] OPSA Datamart field update (new)

The OSPS Datamart has some new fields within the 'Labor Cost' tables. They are the 'Rept Dist Code' and 'Pay Dist Code'.

These fields will contain data starting with the September pay period and going forward.

The fields will show up in all 'OSPS Labor Cost' tables; however, you will need to complete a 'Sync with Database' operation for the fields to show in previous created queries.

'REPT DIST CODE' Definition: A code established by the agency for the identification of divisions/units for the purpose of personnel report distribution and subtotals. Corresponds to the "RDC" field in PPDB. OSPA Screen Reference: P030

'PAY DIST CODE' Definition: Also called the "check distribution code". An optional field for agencies to define the work group to which an employee is assigned. Corresponds to the "PAY DISTR" field in PPDB.

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/20131021/6eb98950/attachment.html>