core-ct application securitycore-ct application security statewide hrms, financials and reporting...
TRANSCRIPT
![Page 1: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/1.jpg)
Core-CT Application Security
Statewide HRMS, Financials and Reporting System
Date Revised: January 10, 2019
1
![Page 2: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/2.jpg)
Core-CT Application Security Overview
In this presentation we will cover
• Understanding (Peoplesoft) Security
• Security Roles and Responsibilities
• New Hires (HR)
• Password Reset – Employee (Portal)
• Distributed User Profiles - Liaison (Portal)
• The CO-1092 (HR & FIN)
• Row and TL Group Security (HR)
• Security Queries (EPM)
2
![Page 3: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/3.jpg)
UNDERSTANDING SECURITY
3
![Page 4: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/4.jpg)
Within Core-CT, all security is defined through the use of User
Profiles, Roles, and Permission Lists.
User Profiles A set of attributes to all Core-CT user including user ID and Password
Roles Assigned to User Profiles to allow access to complete assigned Core-CT
functions, e.g., Requestor to create ePro Requisitions
Permission Lists Assigned to Role to define specific Core-CT page access.
Row Level Security Assigned to users to allow access to data tables without allowing access to all
of the data on that table. E.g., access might be restricted to a selected DeptID
User Security
4
![Page 5: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/5.jpg)
5
User Security
Page Permissions -------------> Role -> ------------------------ User
![Page 6: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/6.jpg)
• Role: CT GENERAL BUYER and Permission Lists assigned to the role
ROLES - FIN
6
![Page 7: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/7.jpg)
• Role: CT GENERAL BUYER and Permission Lists assigned to the role
ROLES - FIN
According to your
security access, this
may appear as a link
that would allow you to
see the CTPOVWR
Permission List
7
![Page 8: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/8.jpg)
8
ROLES - HRMS Role: CT AGY PAYROLL SPECIALIST and Permission Lists assigned to the role
![Page 9: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/9.jpg)
9
ROLES - HRMS Role: CT AGY PAYROLL SPECIALIST and Permission Lists assigned to the role
This tab does not appear on the HRMS Roles page
![Page 10: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/10.jpg)
Role Descriptions (from the Role Handbooks)
http://www.core-ct.state.ct.us/security/pdf/hrms_role_handbook_task_55_9_1.pdf http://www.core-ct.state.ct.us/security/fin_sec.html
• What the description tells you
10
![Page 11: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/11.jpg)
Roles Pages and Reports Job Aid http://www.core-ct.state.ct.us/security/hrms_sec.html
11
![Page 12: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/12.jpg)
OSC - Accounts Payable Division
Segregation of Duties
http://www.core-ct.state.ct.us/security/fin_sec.html
Roles
12
![Page 13: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/13.jpg)
DAS – Statewide Human Resources
Segregation of Duties
http://www.core-ct.state.ct.us/security/pdf/hr_seg_duties9_1.pdf
Roles
13
![Page 14: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/14.jpg)
SECURITY ROLES AND RESPONSIBILITIES
14
![Page 15: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/15.jpg)
Security Roles
• CT AGY FINANCIALS SEC LIAISON
• CT AGY HRMS SECURITY LIAISON
• CT SECURITY LIAISON (Portal)
• CT_CO1092_LIAISON (HRMS and FIN)
• CT_CO1092_APPRV_MGR (HRMS and FIN)
• CT AGY ROW TLGRP SEC (HRMS)
15
![Page 16: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/16.jpg)
• CT AGY FINANCIALS SEC LIAISON
• CT AGY HRMS SECURITY LIAISON
– Both roles are responsible for monitoring and auditing all authorized access to the Core-CT application assigned to their agency personnel, and acting as point of contact for the Core-CT application Security Team for all agency Core-CT security matters
Security Roles
16
![Page 17: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/17.jpg)
• CT SECURITY LIAISON
– HRMS or Financial
• Responsible for resetting passwords, locking out user accounts, updating email addresses, monitoring system profile setup
• Portal access only
Security Roles
17
![Page 18: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/18.jpg)
• CT_CO1092_LIAISON
– HRMS or Financial
• Responsible for creating and managing online CO-1092 Security Requests
• CT_CO1092_APPRV_MGR
– HRMS or Financial
• Responsible for approving or denying the online CO-1092 Security Requests
Security Roles
18
![Page 19: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/19.jpg)
• CT AGY ROW TLGRP SEC - HRMS only
• Effective November 8, 2016
• Responsible for modifying Row Level Security
• Responsible for modifying TL Group Security
Refer to the ‘Department Row Level and Time & Labor (TL) Group Security Training for Agencies - Addendum to the CO1092 Training for Liaisons’
Security Roles
19
![Page 20: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/20.jpg)
• DAS Review and Approve
– HRMS Central Approval
• HR Roles, TL Roles, PY Roles, BN Roles, EPM Roles, Core-CT Security
• OSC Review and Approve
– Financials Central Approval
• AM/IN Roles, CO-512, AP/PO Roles, PC/CA Roles, GL Roles, Core-CT Security
Central Security Roles
20
![Page 21: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/21.jpg)
Security Roles MEMORANDUM NO. 2014-19
Comptroller’s Core-CT Systems Security for State Employees • PURPOSE
This memo replaces memoranda 2010-34 and 2011-23. The purpose of this memo is to advise all state agencies of the importance of having appropriate internal controls over and within the Core-CT Financial and Human Resource Management System (HRMS) to ensure that all transactions are properly authenticated and authorized. Guarding against unauthorized and inappropriate access to the Core-CT system is critical because of the integration of the Financial and HRMS Systems. Unrestricted access to the Core-CT system compromises the controls provided by segregation of duties and other safeguards that are part of manually operated systems.
http://www.osc.ct.gov/2014memos/numbered/201419.htm
21
![Page 22: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/22.jpg)
NEW HIRES
22
![Page 23: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/23.jpg)
New Hires
• New user IDs are created automatically
– One day after the effective date of employment, or action date in Job Data, whichever is greater
– User name is the same as the employee ID
– Temporary password
• First four letters of the user’s last name (all UPPERCASE) followed by the last four digits of the user’s SS #
• Expires on first use, employee will be prompted to reset the password upon logging in
23
![Page 24: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/24.jpg)
New Hires
• Resetting Temporary Password – The system will
prompt at first sign in • Type in temporary
password
• Type in its replacement two times
• Click OK
– Password must meet PW requirements
24
![Page 25: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/25.jpg)
New Hires • Setting Up the
Forgotten Password Help – General Profile
Information • Primary Email
Account – Check box
• Email Type = ‘Business’
• Email Address
• Click Save
25
![Page 26: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/26.jpg)
New Hires • Change or set up
forgotten password help –
– Select Question from Drop-Down
– Enter Response
– Click OK
26
![Page 27: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/27.jpg)
New Hires
• Dynamic Role Assignment - Initial Roles
– CT PORTAL SIGNON REGULAR (4am – 8pm)
– CT SIGNON REGULAR (4am – 8pm)
– CT PORTAL USER
– CT HRMS USER
– CT PORTAL USER JUD
– CT HRMS USER JUD
• Judicial employees only – no Employee Self Service
27
![Page 28: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/28.jpg)
New Hires
• Dynamic Role Assignment - Initial Roles cont. – CT_H_U_EPAY
• View Paycheck, W-2 and W-2c
– CT EMPLOYEE • If a Time and Labor agency
– CT AGY TL TIME REPORTER • If a Time and Labor agency
– CT AGY LIMITED TIME ENTRY • If the agency chooses to limit time entry
to current pay period only
28
![Page 29: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/29.jpg)
29
New Hires
![Page 30: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/30.jpg)
PASSWORD RESET EMPLOYEE
30
![Page 31: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/31.jpg)
Employee Password Reset
31
![Page 32: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/32.jpg)
Employee Password Reset (if Profile is Set Up)
32
![Page 33: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/33.jpg)
Employee Password Reset (if Profile is Set Up)
33
![Page 34: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/34.jpg)
Employee Password Reset (Profile Not Set Up)
34 34
![Page 35: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/35.jpg)
35
Employee Password Reset
![Page 36: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/36.jpg)
Employee Password Reset (from Home Page)
36
![Page 37: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/37.jpg)
Password Policy • All passwords expire in ninety (90) days.
• Users will be warned for fifteen (15) days prior to the password expiration.
• Five (5) logon attempts are allowed before the account is locked out.
• The password can not match the User ID.
• The password must be at least eight (8) characters in length, three (3) of which must be digits.
37
![Page 38: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/38.jpg)
• Six (6) passwords are retained in the system.
• Both alphabetic and numerical characters are allowed.
• Passwords should be obscure rather than obvious.
• All users with valid email addresses must set up their User Profile in Core-CT to be able to use the password reset feature in Core-CT.
• Only authorized agency security liaisons can request password resets.
38
Password Policy
![Page 39: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/39.jpg)
DISTRIBUTED USER PROFILE CT SECURITY LIAISON
39
![Page 40: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/40.jpg)
Distributed User Profile
• Single Sign on - Background
– EPM, HRMS, and Financials are separate applications
– Core-CT Portal is the gateway to HR, FIN and EPM
– Core-CT Portal integrates and syncs all User IDs and passwords in all applications
40
![Page 41: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/41.jpg)
Distributed User Profile Password Reset – CT SECURITY LIAISON
• Navigation: PeopleTools > Security > User Profiles > Distributed User Profiles
41
![Page 42: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/42.jpg)
• Navigation: PeopleTools > Security > User Profiles > Distributed User Profiles – Click on the Forgotten Password tab
Distributed User Profile
42
![Page 43: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/43.jpg)
Distributed User Profile
43
![Page 44: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/44.jpg)
• Click OK and then Save
Distributed User Profile
44
![Page 45: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/45.jpg)
Distributed User Profile
45
Uncheck the box and contact your employee. Ask them to use the
“Forgot My Password” feature.
![Page 46: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/46.jpg)
• Navigation: PeopleTools > Security > User Profiles > Distributed User Profiles – Click on the Forgotten Password tab
Distributed User Profile
46
![Page 47: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/47.jpg)
• Change the Password and Confirm Password – At least 8 characters including 3 digits
– Case sensitive
– Example: VRX58AB2
• Click the Password Expired checkbox – This will cause the password to expired when first
used
• Optional: If the Account Locked Out box is checked, then click to uncheck
• Click Save
Distributed User Profile Password Reset
47
![Page 48: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/48.jpg)
Distributed User Profile Password Reset
Five (5) unsuccessful logon attempts are allowed before the account is locked out
48
![Page 49: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/49.jpg)
Distributed User Profile
49
![Page 50: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/50.jpg)
• Click OK if you get this warning
• The user password has been reset
– Email or directly contact the user with their new password
Distributed User Profile Password Reset
50
![Page 51: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/51.jpg)
• If the user has not set up their forgotten password help – Contact the user and instruct them to complete
– http://www.core-ct.state.ct.us/support/ppt/pwreset.pps
– If a User’s email is invalid and they use the Forgot Your Password feature, the Password email will be routed to the Outlook Undeliverable email server. The Core-CT help desk will forward these emails to the Security Liaisons for correction. The attachment in the email will include the new temporary password for this user.
Distributed User Profile Auditing Email and Profiles
51
![Page 52: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/52.jpg)
THE CO-1092 CT_CO1092_LIAISON (HRMS and FIN)
CT_CO1092_APPRV_MGR (HRMS and FIN)
52
![Page 53: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/53.jpg)
CO-1092
• Each agency is responsible for maintaining their users’ access in Core-CT
– Roles
• Segregation of Duties
• Job duty changes
– Locking Accounts of Access upon Separation
• Agency separation or transfer
• Security Audit
53
![Page 54: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/54.jpg)
CO-1092
• Roles and access are maintained online
– HRMS CO1092 pages
• To request HR roles and/or
• EPM HR table access
– Financials CO1092 pages
• To request Financial roles and/or
• EPM FIN table access
54
![Page 55: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/55.jpg)
The Automated Process
55
![Page 56: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/56.jpg)
Transaction Numbers
56
![Page 57: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/57.jpg)
57
HRMS CO-1092 Form
57
![Page 58: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/58.jpg)
58
HRMS CO-1092 Form
![Page 59: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/59.jpg)
59
HRMS CO-1092 Form
![Page 60: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/60.jpg)
60
HRMS CO-1092 Form
http://www.core-ct.state.ct.us/security/hrms_sec.html
![Page 61: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/61.jpg)
FIN CO-1092 Form
61
![Page 62: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/62.jpg)
62
FIN CO-1092 Form
![Page 63: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/63.jpg)
63
FIN CO-1092 Form
![Page 64: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/64.jpg)
64
Roles Requiring FIN Appendix
![Page 65: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/65.jpg)
Roles Requiring FIN Appendix
65
![Page 66: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/66.jpg)
FIN Appendix
66
![Page 67: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/67.jpg)
FIN Appendix Form
http://www.core-ct.state.ct.us/security/xls/fin_appdx.xls Naming Convention: LastNameDate (example: Doe20130523)
67
![Page 68: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/68.jpg)
• General or Program Buyer
• Purchase Order Amount Approver 1, 2
• Purchase Order Budget Approver (CO-512 also required)
• Requester
• Catalog Viewer
• Requisition Amount Approver 1, 2, 3, 4
• Requisition Budget Approver
• Requisition Purchasing Approver (CO-512 also required)
• Alternate Approver (CO-512 also required)
Roles Requiring FIN Appendix
68
![Page 69: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/69.jpg)
• Adjustment Voucher Processor
• Journal Voucher Processor
• Voucher Maintenance Processor
• Voucher Processor
• Voucher Approver (CO-512 also required)
• CT PSA_POS REQUESTER
• CT AGY SERVICE APPROVER
• CT_F_A_PSA_POS_SUBMITTER
• CT OPM BUDGET APPROVER 1 and 2
Roles Requiring FIN Appendix - Cont.
69
![Page 70: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/70.jpg)
• OSC CO1092 Requires FIN appendix for
– Origins, AP/PO Business Units, Ship-to-Locations, etc. for Buyers, Requesters and Approvers
– OSC/APD requires agencies to submit a new or updated CO-512 when requesting any final approval roles within five days
– OSC will not approve any SOD conflicts
Important Reminders!
70
![Page 71: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/71.jpg)
• The CO-1092 Financial Appendix is available on-line – http://www.core-ct.state.ct.us/security/xls/fin_appdx.xls
– This form can be completed and attached to the on-line CO-1092 Form
• The Comments Page cannot be used in lieu of the FIN Appendix
• For more information on Roles requiring route controls values, please go to the Core-CT Security Website – http://www.core-ct.state.ct.us/security/
Important Reminders!
71
![Page 72: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/72.jpg)
72
FIN CO-1092 Form
http://www.core-ct.state.ct.us/security/fin_sec.html
![Page 73: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/73.jpg)
Submit Request
73
![Page 74: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/74.jpg)
FIN
Ap
pro
val R
ou
tin
g
74
![Page 75: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/75.jpg)
HR
MS
Ap
pro
val R
ou
tin
g
![Page 76: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/76.jpg)
Tips When Assigning Roles
• Refer to the HRMS and FIN Role handbooks for all functional role definitions
• Users who will require Transactional (add/update) access do NOT require corresponding Viewer roles as well.
Examples: CT AGY HR SPECIALIST does NOT need the CT AGY HR VIEWER role CT AGY PAYROLL SPECIALIST does NOT need the CT AGY PAYROLL VIEWER Role Voucher Approver does NOT need the CT VOUCHER VIEWER or CT AGY AP VIEWER roles
• All Viewer roles are intended to provide non-transactional users with View-only Access, where approved
76
![Page 77: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/77.jpg)
Tips When Assigning Roles
• All HRMS and FIN transactional, reporting or viewer roles include EPM Reporting table Access. Examples: CT AGY HR SPECIALIST or CT AGY HR VIEWER give access to corresponding tables in EPM Voucher Approver or CT VOUCHER VIEWER or CT AGY AP VIEWER both give access to corresponding tables in EPM
77
![Page 78: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/78.jpg)
Tips When Assigning Roles
• In addition to roles that give table access in EPM, a user will also need the CT EPM PRIVATE which gives access to the EPM Query Manager Component navigation.
• EPM only roles (CT_E%) are only required when a user does NOT have access to corresponding data (update or view) in the sources systems (HRMS or Financials).
• Employees should seek training via HR/FIN UPK exercises or Core-CT job aids or training classes prior to receiving roles.
78
![Page 79: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/79.jpg)
TERMINATIONS, TRANSFERS-OUT AND RETIREES
79
![Page 80: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/80.jpg)
Terminations / Transfers-Out / Retirees
• Inactivation of User IDs is automated
– Nightly Batch Process
– All non-dynamic roles will be removed from User Profile; row security is also removed
– One day after the effective date or action date, whichever is greater, of the Termination, Transfer or Retirement row
– Exception: Employees w/ Multiple User IDs and multiple jobs
80
![Page 81: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/81.jpg)
Terminations / Transfers-Out / Retirees
LIAISONS - LOCK ACCOUNTS!
• User Profiles should be Locked Out upon Termination, Transfer-Out or Retiring.
• What is your agency policy when you need to inactivate a user?
• Please contact [email protected] for guidance.
81
![Page 82: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/82.jpg)
Distributed User Profile Lock Out a Former Employee
82
![Page 83: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/83.jpg)
QUERIES
83
![Page 84: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/84.jpg)
84
Objectives
•In this part of the training, you will learn to: – Use the basic concept of Query in Core-CT. We
will specifically focus on the following topics: • Running an Existing Core Security Query and Viewing
Results
![Page 85: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/85.jpg)
85
EPM Warehouse
Transactional Data
Informatica
(ETL)
Source Tables
Core
HRMS
Reporting Tables
Data Loader
(App Engine)
Core
Financials
PS Query/
nVision/
Crystal
Live Data
Static Data
EPM
Reporting
Using PS
Query
Data Architecture
![Page 86: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/86.jpg)
Know your Terms
• Field: Fields store date (ie Jobcode, Voucher ID, Employee ID) in Core-CT
• Table (or Record): Collection of related data fields arranged in columns and rows
• EPM Staging Tables: Copies of the HRMS and Financial transactional tables
• EPM Reporting Tables: (Denormalized Tables that EPM users to build queries
• Denormalize: The process of combining information stored in separate tables together into one table.
86
![Page 87: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/87.jpg)
87
Key Fields
![Page 88: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/88.jpg)
EPM - Security Reporting Tables •User Profiles
– CTW_PSOPERDEFNFN (FN)
– CTW_PSOPERDEFNHR (HR)
•Roles and Pages
– CTW_PSROLECLSFN (FN)
– CTW_PSROLECLSHR (HR)
– CTW_PSROLEUSEFN (FN)
– CTW_PSROLEUSEHR (HR)
•HR Department and TL group Permissions
– CTW_SCRTYTBLDEP
– CTW_TL_GRP_SEC
•CO-1092 Security Reporting
– CTW_FCO1092_RPT (FN)
– CTW_HCO1092_RPT (HR)
88
![Page 89: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/89.jpg)
EPM – HR Reporting Tables
• Shared HR Reporting Tables
– CTW_EMPLOYEE_VW
– CTW_NAMES
– CTW_PERSNL_DATA
– CTW_TL_GROUP
– CTW_TL_WRKGRP
– CTW_TLEMPDATA
– CTW_TLGROUP_DTL
89
![Page 90: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/90.jpg)
90
•Navigation:
•Core-CT EPM> Reporting Tools>Query>Query Manager>Advanced Search
![Page 91: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/91.jpg)
91
EPM – HR Security Queries
HR - CT_CORE_SEC_EPM_SYSTEM_PROFILE – Employee system profile
information
- CT_CORE_SEC_GROUP_ID_DETAIL –CORE Security group ID details
- CT_CORE_SEC_HRACCT_LOCKED –HR User ID locked out or not
- CT_CORE_SEC_HRROLES_BY_EMPLID – HR roles by EmplID
- CT_CORE_SEC_HRROLES_EMP_ACTIVE – HR roles audit for active employee
- CT_CORE_SEC_HRROLES_EMP_TERMED – HR roles assigned/termed
employee
![Page 92: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/92.jpg)
92
EPM – HR Security Queries
HR (Cont.) - CT_CORE_SEC_HRSPC_SEG_DUTY – HR specialist segregation of duty
- CT_CORE_SEC_HRUSERID_BY_ROLE – HR User ID by role name
- CT_CORE_SEC_ROWSEC_HR_DEPTID – Row security & HR DEPTID access
- CT_CORE_SEC_ROWSEC_NOT_DPTLR – Dynamic only users without DPTLR
- CT_CORE_SEC_ROWSEC_TLGRP_APPV – Row security & TL groups for
approvers
- CT_CORE_SEC_TIME_APPROVERS – Time approvers by location
- CT_CORE_SEC_USERID_BY_EMPLID – OPRID by EmplID search
![Page 93: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/93.jpg)
93
EPM - FIN Security Queries
FIN - CT_CORE_SEC_AGY_ACRONYM_MATCH – UserID does not match DEPTID
- CT_CORE_SEC_FNACCT_LOCKED – FN User ID locked out or not
- CT_CORE_SEC_FNROLES_BY_EMPLID – FN roles by EmplID
- CT_CORE_SEC_FNROLES_EMP_ACTIVE – FN roles audit for active
employee
- CT_CORE_SEC_FNROLES_EMP_TERMED – FN roles assigned/termed
employee
- CT_CORE_SEC_FNUSERID_BY_ROLE – FN User ID by role name
- CT_CORE_SEC_REQUESTR_BY_ORIGIN – Requesters by origin
![Page 94: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/94.jpg)
94
EPM – FIN Security Queries FIN AP/PO Workflow
- CT_CORE_SEC_APPROVRS_BY_ORIGIN – Approvers by origin
- CT_CORE_SEC_AP_ORIGINS_W_DESCR – AP origins by agency
- CT_CORE_SEC_OPRID_PPL_BY_ORIGIN – OPRID & PPL by origin
- CT_CORE_SEC_PO_ORIGIN_W_DESCR – PO origins by agency
- CT_CORE_SEC_ROLES_BY_AP_ORIGIN – User roles by origin
- CT_CORE_SEC_ROLES_BY_ORIGIN_BU – User roles by business
unit/origin
- CT_CORE_SEC_VCHR_APPRVRS_ORIGIN – Voucher approvers by
origin
![Page 95: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/95.jpg)
95
CT_CORE_SEC_AGY_ACRONYM_MATCH UserID Does Not Match DeptID - Prompt for DeptID and returns a list of all Core UserID's where the agency acronym in the description does not match the DeptID in Job Data. **Central Security will be running this report monthly
![Page 96: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/96.jpg)
CT_CORE_SEC_AP_ORIGINS_W_DESCR CT_CORE_SEC_PO_ORIGINS_W_DESCR
This report returns a list of AP or PO origins by Agency Acronym
96
![Page 97: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/97.jpg)
CT_CORE_SEC_APPROVRS_BY_ORIGIN
Query returns active approvers by Origin Number.
97
![Page 98: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/98.jpg)
Using the Profile information from the Portal this report will return all agency employees with email information (if entered) and will show if the security question and answer are completed.
98
CT_CORE_SEC_EMP_SYSTEM_PROFILE
![Page 99: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/99.jpg)
CT_CORE_SEC_FNACCT_LOCKED CT_CORE_SEC_HRACCT_LOCKED
Using the FN or HR Security tables this report returns all users with Job Data Employee Status and whether or not they are locked out of the system.
99
![Page 100: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/100.jpg)
CT_CORE_SEC_FNROLES_BY_EMPLID CT_CORE_SEC_HRROLES_BY_EMPLID
Using the FN or HR Security tables this report is designed to return all roles that an employee is assigned. Prompt for EmpID#
100
![Page 101: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/101.jpg)
CT_CORE_SEC_FNROLES_EMP_ACTIVE CT_CORE_SEC_HRROLES_EMP_ACTIVE
Using the FN or HR security tables this report returns roles for active agency employees. Use for Segregation of Duty & other role audits.
101
![Page 102: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/102.jpg)
CT_CORE_SEC_FNROLES_EMP_TERMED CT_CORE_SEC_HRROLES_EMP_TERMED
Using the FN or HR security tables this report returns roles that a terminated employee is still assigned. It will let you know if the UserID is locked out or not.
102
![Page 103: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/103.jpg)
CT_CORE_SEC_FNUSERID_BY_ROLE CT_CORE_SEC_HRUSERID_BY_ROLE
Using the FN or HR Security tables this report is designed to return USERID's associated with a specific Role name and Agency. Role names do not include always underscores, for example: CT AGY HRMS SECURITY LIAISON.
103
![Page 104: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/104.jpg)
CT_CORE_SEC_GROUP_ID_DETAIL
Using the Security Tables this query returns all active members of a specific, GroupID.
104
![Page 105: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/105.jpg)
HR Specialist Seg of Duty - Query is designed to return USERID's for an HR Segregation of Duty report. Lists all CT AGY HR SPECIALIST and if they have either the CT AGY TL SPECIALIST and/or, CT AGY PAYROLL SPECIALIST roles.
105
CT_CORE_SEC_HRSPC_SEG_DUTY
![Page 106: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/106.jpg)
CT_CORE_SEC_OPRID_PPL_BY_ORIGIN
Query returns active OPRID and primary permission list by Origin Number.
106
![Page 107: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/107.jpg)
CT_CORE_SEC_REQUESTR_BY_ORIGIN
Query returns active requestors by Origin Number.
107
![Page 108: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/108.jpg)
CT_CORE_SEC_ROLES_BY_AP_ORIGIN
Query returns user roles by AP Origin Number.
108
![Page 109: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/109.jpg)
CT_CORE_SEC_ROLES_BY_ORIGIN_BU
Query returns user roles by business unit and Origin
109
![Page 110: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/110.jpg)
CT_CORE_SEC_ROWSEC_HR_DEPTID
Row Sec & HR DeptID Access - Using the HRMS security tables this report returns a list of all HRMS Users, their Row Security and what DeptID’s they have access to.
110
![Page 111: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/111.jpg)
CT_CORE_SEC_ROWSEC_NOT_DPTLR
Dynamic Only Users w/Out DPTLR - Using the HRMS security tables this report returns a list of all HRMS Dynamic only users with Row Security does not equal DPTLR. **Central Security will be running this report monthly.
111
![Page 112: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/112.jpg)
CT_CORE_SEC_ROWSEC_TLGRP_APPV
Row Sec & TL Groups for Appvrs - Using the HRMS security tables this report returns a list of all TL Approvers, their HRMS Row Security, and TL GroupID information.
112
![Page 113: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/113.jpg)
CT_CORE_SEC_TIME_APPROVERS
Time Approvers by Location - Time approvers by TL Group ID and Location, both wildcard enabled. Query returns time approvers and those employees whose time is approved. Please try to limit the output by using a location.
113
![Page 114: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/114.jpg)
CT_CORE_SEC_USERID_BY_EMPLID
Query returns all CORE UserID's by employee ID search
114
![Page 115: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/115.jpg)
CT_CORE_SEC_VCHR_APPRVRS_ORIGIN
Query returns active voucher approvers by Origin Number.
115
![Page 116: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/116.jpg)
CT_CORE_SEC_FNCO1092_AGING CT_CORE_SEC_HRCO1092_AGING
CO1092 forms w/ days in pending status. Query prompts on Department.
116
![Page 117: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/117.jpg)
CT_CORE_SEC_FNCO1092_BY_DEPT CT_CORE_SEC_HRCO1092_BY_DEPTID
CO1092 forms pending by department.
117
![Page 118: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/118.jpg)
CT_CORE_SEC_FNCO1092_BY_EMPLID CT_CORE_SEC_HRCO1092_BY_EMPLID
CO1092 forms pending by employee ID.
118
![Page 119: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/119.jpg)
CT_CORE_SEC_FNCO1092_CMMTS CT_CORE_SEC_HRCO1092_CMMTS
CO1092 comments by transaction number.
119
![Page 120: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/120.jpg)
CT_CORE_SEC_FNCO1092_TRANSNBR CT_CORE_SEC_HRCO1092_TRANSNBR
CO1092 information by transaction number.
120
![Page 121: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/121.jpg)
EPM Job Aids & Other Info
121
![Page 122: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/122.jpg)
122
EPM Job Aids & Other Info
![Page 123: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/123.jpg)
Stay Tuned…
• More Security Queries are in the works!
• SEC101 – Core-CT Application Security Course will so be offered on a regular basis. Keep an eye out for Security Bulletins with the announcement!
123
![Page 124: Core-CT Application SecurityCore-CT Application Security Statewide HRMS, Financials and Reporting System Date Revised: January 10, 2019 1 . Core-CT Application Security Overview In](https://reader033.vdocuments.us/reader033/viewer/2022053008/5f0b6a7b7e708231d4306908/html5/thumbnails/124.jpg)
QUESTIONS?
124