slide1
Download
Skip this Video
Download Presentation
AGENDA

Loading in 2 Seconds...

play fullscreen
1 / 30

AGENDA - PowerPoint PPT Presentation


  • 80 Views
  • Uploaded on

AGENDA. Introductions Input\Output 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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' AGENDA' - cheryl


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

AGENDA

  • Introductions
  • Input\Output Sources
  • Four Major Subject Areas
  • Position Data
  • Appointment Data
  • Employee Data
  • Security/Access
  • Question And Answer
slide2
DMS People First! IT/Data Team:
slide3

AGENDA

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

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

slide5

AGENDA

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

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

slide7

AGENDA

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

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
slide9

AGENDA

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

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

slide11

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
slide12

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
slide13

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
slide14

AGENDA

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

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
slide16

AGENDA

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

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
slide20

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%[email protected]!fT6gS7&hR8iQ9*jP0kO~lNmMnLo?KpJq;IrHsG:tFuEvDwCxByAz"

slide22

AGENDA

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

AGENDA

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

Data Warehouse Architecture

  • Data Model
  • Data Driven “Not” Column Driven
  • Transaction Data
  • Historical Data
slide25

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

slide27

Data Warehouse Architecture

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

COPESView Recurring Payment Data in T_APPOINTMENT

Data Warehouse Recurring Payment Data

  • NO TABLE CHANGES
  • NO SQL CHANGES
  • NO IMR CHANGES
slide29

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
slide30

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
ad