1 / 30

AGENDA

AGENDA. Introductions InputOutput Sources Four Major Subject Areas Position Data Appointment Data Employee Data Security/Access Question And Answer. DMS People First! IT/Data Team: Michael Johnston (850)488-3923 DMS People First! IT/Data Team Manager michael.johnston@dms.myflorida.com

summer
Download Presentation

AGENDA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. AGENDA • Introductions • Input\Output Sources • Four Major Subject Areas • Position Data • Appointment Data • Employee Data • Security/Access • Question And Answer

  2. DMS People First! IT/Data Team: • Michael Johnston (850)488-3923 • DMS People First! IT/Data Team Manager • michael.johnston@dms.myflorida.com • Brenda Hough (850)488-2277 • HR Consultant • brenda.hough@dms.myflorida.com • Mike Davis (850)487-3230 • HR Consultant • mike.davis@dms.myflorida.com • Tim Vause (850)921-9740 • HR Consultant • tim.vause@dms.myflorida.com

  3. AGENDA • Introductions • Input\Output Sources • Four Major Subject Areas • Position Data • Appointment Data • Employee Data • Security/Access • Question And Answer

  4. Input Sources • PeopleFirst System • Wage Req. Detail Info. • Employee\Appointment Data • Organization Data • Position Data • Benefits Data PeopleFirst • BOSP (Salary Detail Information) COPES Historical BOSP • COPES Historical Data • Employee Transaction • Position Transaction • Leave Balance Training Direct Time Direct • Time Direct Historical Data • Training Direct Historical Data Data Warehouse • DSGI Historical Data DSGI Output • File Interfaces • HR File Interfaces • Benefit File Interfaces • Payroll Interfaces • COGNOS Impromptu • Reports Web Portal • Oracle Views • Standard Reports File Interfaces COGNOS Reports Web Portal

  5. AGENDA • Introductions • Input\Output Sources • Four Major Subject Areas • Position Data • Appointment Data • Employee Data • Security/Access • Question And Answer

  6. DWSOF All Active Organization Data Flair Account Data Organization Active Organization Active Position Active Position Active ORG WK Position Data Class Data Pay Grade Data Broadband Data Pay Band Data Building Facilities Data POS WK Appointment Data Basic Pay Data W4-W5 Data Appointment Active Appointment Active Employee Active Employee Active EMPLOYEE WK Employee Data

  7. AGENDA • Introductions • Input\Output Sources • Four Major Subject Areas • Position Data • Appointment Data • Employee Data • Security/Access • Question And Answer

  8. POS Rate Position Rate Information • Organization Code • Position Number Position Active Fund Code Other Cost Accumulator Position Fund Source Fund Type • Organization Code • Position Number KSA Knowledge\Skills Ability • OLO Code • Position Number

  9. AGENDA • Introductions • Input\Output Sources • Four Major Subject Areas • Position Data • Appointment Data • Employee Data • Security/Access • Question And Answer

  10. Appointment Active Recurring Pay Deductions FMLA Event Time Sheet Emp Wage Req Detail File 1 One-Time Pay Deductions Appointment Equipment Time Balance Pay Additive Substitutions Time Evaluation Messages Salary Detail Personal Work Schedule Supplimental Pay Deduct

  11. Appointment Active PAYMENT AND DEDUCTIONS Key Recurring Pay Deductions • APPT_WK • WAGE_TYPE • START_DATE Supplimental Pay Deduct • APPT_WK • WAGE_TYPE • START_DATE One-Time Pay Deductions • APPT_WK • WAGE_TYPE • ORIGIN_DATE Pay Additive • APPT_WK • WAGE_TYPE • BEGIN_DATE • END DATE

  12. Appointment Active TIME MANAGEMENT Time Sheet Key • APPT_WK • ATTENDANCE_TYPE • WORK_DATE Time Balance • APPT_WK • BAL_TYPE • BAL_EFFECTIVE_DATE Personal Work Schedule • APPT_WK • PWS_DATE • DAILY_WORK_SCHEDULE_CLASS Oncall Schedule • APPT_WK • START_DATE

  13. Appointment Active PAYROLL INTERFACE DATA Key Emp Wage Req Detail File 1 • APPT_WK • PAY_PERIOD_BEG_DATE • PAY_PERIOD_END_DATE Salary Detail • APPT_WK • BEG PAY PER DATE • END PAY PER DATE • RUN TYPE

  14. AGENDA • Introductions • Input\Output Sources • Four Major Subject Areas • Position Data • Appointment Data • Employee Data • Security/Access • Question And Answer

  15. Employee Active Key Address • EMPLOYEE_WK • ADDRESS_TYPE • CARE_OF Certification • EMPLOYEE_WK • CERTIFICATE_TYPE Education • EMPLOYEE_WK • MAJOR_CODE • EDUCATION_LEVEL Language • EMPLOYEE_WK • LANGUAGE_CD License • EMPLOYEE_WK • LICENSE_NUMBER

  16. AGENDA • Introductions • Input\Output Sources • Four Major Subject Areas • Position Data • Appointment Data • Employee Data • Security/Access • Question And Answer

  17. USR_SECURITY_TABLE • USER_ID is the Employee User Sign-on ID. • ORG_WK links the security to the Authorized Agency or Organization • ACCESS_FLAG determines the level of security access • PA – Privileged Access at the Agency Level • PO – Privileged Access at the Organization Level • SA – Privileged Access to any Agency Statewide • Confidential_Ind provides access to Confidential / Sworn Employee data • EMP_WK links the security record to the Employee table for maintenance • External_User_Flag is used to bypass Employee maintenance

  18. Convergys Single Sign-on Tie-In

  19. DATA WAREHOUSE ACCESS / ENCRYPTION TNSNAMES.ORA file addition (change all tnsnames.ora files on desktop): PSOFDW.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ???.???.??.??)(PORT = 1599)) ) (CONNECT_DATA = (SERVICE_NAME = psofdw) ) ) SQLNET.ORA Required File added to the NETWORK/ADMIN folder: SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) SQLNET.ENCRYPTION_CLIENT = ACCEPTED SQLNET.ENCRYPTION_TYPES_CLIENT = (RC4_256,RC4_128,RC4_56,RC4_40) SQLNET.CRYPTO_SEED = "Z#aY1bX%2cW3d@V4eU5!fT6gS7&hR8iQ9*jP0kO~lNmMnLo?KpJq;IrHsG:tFuEvDwCxByAz"

  20. AGENDA • Introductions • Input\Output Sources • Four Major Subject Areas • Position Data • Appointment Data • Employee Data • Security/Access • Question And Answer

  21. AGENDA • Introductions • Input\Output Sources • Four Major Subject Areas • Position Data • Appointment Data • Employee Data • Security/Access • Question And Answer

  22. Data Warehouse Architecture • Data Model • Data Driven “Not” Column Driven • Transaction Data • Historical Data

  23. DWSOF All Active Organization Data Flair Account Data Organization Active Organization Active Position Active Position Active ORG WK Position Data Class Data Pay Grade Data Broadband Data Pay Band Data Building Facilities Data POS WK Appointment Data Basic Pay Data W4-W5 Data Appointment Active Appointment Active Employee Active Employee Active EMPLOYEE WK Employee Data

  24. Data Warehouse Architecture • Data Model • COPESView to Data Warehouse Mapping Report (IMR) • Data Driven “Not” Column Driven • Transaction Data • Historical Data

  25. COPESView Recurring Payment Data in T_APPOINTMENT Data Warehouse Recurring Payment Data • NO TABLE CHANGES • NO SQL CHANGES • NO IMR CHANGES

  26. Data Warehouse Architecture • Data Model • COPESView to Data Warehouse Mapping Report (IMR) • Reference Report (IMR) • Payroll Data • Data Driven “Not” Column Driven • Transaction Data • Historical Data

  27. Data Warehouse Architecture • Data Model • COPESView to Data Warehouse Mapping Report (IMR) • Reference Report (IMR) • Payroll Data • Data Driven “Not” Column Driven • Transaction Data • Historical Data

More Related