Menu


 

Data Roles & Definitions

 

This data is “what” you see when you run a report OR what you have access to when entering data on a screen.

GL Data is secured using one of the following codes:

  • Department Head (DPHD)
  • Department (DEPT)
  • Fund (FUND)
  • Org Key (KEY)
  • Ledger (GL or JL)

 

PY is secured using the Department Code

PE (Vendor) is secured using the Security Code

Codes are Department Specific

VENDOR is non-confidential

Data Role
GL/PY Component
Definition
ADMIN
Admin Department Only
N/A
AG
glk_gr = 'GL' AND glk_grp_part03 = '042'
DEPT: Agriculture
Air Pollution
glk_gr = 'GL' AND glk_grp_part03 = '219'
DEPT: Air Pollution
Animal Services
glk_gr = 'GL' AND glk_grp_part03 = '048'
DEPT: Animal Services
Assessor
glk_gr = 'GL' AND glk_grp_part06 = '04'
DEPT HEAD: Assessor
Auditor
Audit Department Only
N/A
Board of Supervisors
glk_gr = 'GL' AND glk_grp_part03 = '001'
DEPT: Board of Supervisors
Building
glk_gr = 'GL' AND glk_grp_part03 = '058'
DEPT: Building
Calmet
glk_gr = 'GL' AND glk_grp_part03 = '041'
DEPT: Cal Met
Cannabis Reg
glk_gr = 'GL' AND glk_grp_part03 = '052'
DEPT: Cannabis Reg
Central Finance - NO HR PY
Audit Department Only
N/A
CIP
glk_gr = 'GL' AND glk_key = '10401060'
Org Key: Capital Improvements
Clerk
(glk_gr = 'GL' AND glk_grp_part03 IN ('028','044')) or (glk_gr = 'JL' and glk_grp_part05 = '008')
DEPT: Clerk, Recorder, JL DEPT HEAD: ClerkRecorder
Clerk Recorder - Monthly Read Only
Clerk-Recorder monthly GL Only
N/A
CNEU
glk_gr = 'GL' AND glk_grp_part03 = '035'
DEPT: Calaveras Narc Enforce Pro
Code Compliance
glk_gr = 'GL' AND glk_grp_part03 = '058'
DEPT: Building
Coroner
glk_gr = 'GL' AND glk_grp_part03 = '045'
DEPT: Coroner
County Counsel                                                                                                                                                                        
(glk_gr = 'GL' AND (glk_grp_part06 = '07' or glk_sec_part01 IN ('061'))) or (glk_gr ='JL' and glk_grp_part04= '080' or glk_grp_part04 = '031') or (glk_gr = 'JL' and glk_grp_part05 = '999')                                                                                          
DEPT HEAD: County Counsel, IND: DaSoProbCaWks; JL DEPT: County Counsel, Public Defender, JL DEPTHEAD: Countywide
CSAs
glk_gr = 'GL' AND glk_grp_part03 = '205'
DEPT: Co Service Area
Dispatch
glk_gr = 'GL' AND glk_grp_part03 = '033'
DEPT: Dispatch
District Attorney
glk_gr = 'GL' AND glk_grp_part03 = '030'
DEPT: District Attorney
DRC
glk_gr = 'GL' AND glk_grp_part03 = '051'
DEPT: Day Reporting Center
Economic Development
glk_gr = 'GL' AND glk_grp_part03 = '062'
DEPT: Economic Development
Elections
(glk_gr = 'GL' AND glk_grp_part03 = '010') or (glk_gr = 'JL' and glk_grp_part05 = '008')
DEPT: Elections, JL DEPTHEAD: Clerk Recorder
Environmental Health
glk_gr = 'GL' AND glk_grp_part03 = '057'
DEPT: Environmental Health
FA ALL
All Fixed Assets (Insurance) - HR Only
N/A
Facilities
glk_gr = 'GL' AND glk_grp_part03 = '011'
DEPT: Facilities
FIRST 5
glk_gr = 'GL' AND glk_grp_part06 = '290'
DEPT HEAD: Child & Families Commission
Fish and Game
glk_gr = 'GL' AND glk_grp_part03 = '156'
DEPT: Fish & Game
HHSA- Behavior Health
glk_gr = 'GL' AND glk_grp_part03 = '127'
DEPT: BHS Mental Health
HHSA- CMCAA
glk_gr = 'GL' AND glk_grp_part02 = '1091'
FUND: CMCAA - JPA
HHSA- CWHS                                                                                              
glk_gr = 'GL' AND glk_grp_part03 IN ('097','096')or glk_key='10100190' or (glk_gr = 'JL' and glk_key='10104820')
DEPT: Assistance, Admin; Org Key: Veteran Services; JL 2023 Feb-April Storms
HHSA Grants
glk_gr = 'GL' AND glk_grp_part03 = '221'
DEPT: Grants-Loans
HHSA- Health
glk_gr = 'GL' AND glk_grp_part03 = '126'
DEPT: Health
HHSA -Mental Health
glk_gr = 'GL' AND glk_grp_part03 = '127' or glk_key = '10100190'
DEPT: BHS Mental Health; Org Key: Venterans Services
HHSA- Substance Abuse                   
(glk_gr = 'GL' AND glk_grp_part03 = '132') or (glk_gr = 'JL' and glk_grp_part04 = '811')
DEPT: BHS Sub. Use ; JL DEPT: BHS Mental Health
HR Full
HR Dept Only
N/A
HR- Full SSN Only
HR Dept Only
N/A
HR- Payroll Read Access
HR Dept Only
N/A
HR Read Only
Payroll Only
N/A
Information Technology
glk_gr = 'GL' AND glk_sec_part05 = 'IT01'
Sec Part: IT Group
Integrated Waste                                 
glk_gr = 'GL' AND glk_grp_part03 = '190' OR glk_gr = 'JL' AND glk_grp_part04 = '190'
DEPT: Integrated Waste Management; JL DEPT: IWM
IT Read Only
IT for Project GL Lookup - IT Only
N/A
Jail
glk_gr = 'GL' AND glk_grp_part03 = '038'
DEPT: Jail
JE Entry
Audit Department Only
N/A
JL- 99000019
glk_gr = 'JL' and glk_key = '99000019'
JL Key: COVID-19 EVENT
JL AP Batches
glk_gr = 'JL' and glk_key = '10108200'
JL Key: Electra Fire Incident
Library                                                
(glk_gr = 'GL' AND glk_grp_part03 = '065') or (glk_gr='JL' AND glk_grp_part04='065')
DEPT: Library; JL DEPT: Library                     
Library Adult Tutoring
(glk_gr = 'GL' AND glk_grp_part03 = '066') or (glk_gr='JL' AND glk_grp_part04='066')
DEPT: Calaveras Adult Tutoring; JL DEPT: Calaveras Adult Tutoring
Lighting Districts
glk_gr = 'GL' AND glk_grp_part03 = '200'
DEPT: Lighting District
Marine Safety
glk_gr = 'GL' AND glk_grp_part03 = '036'
DEPT: Marine Saftey
Museum
glk_gr = 'GL' AND glk_grp_part03 = '068'
DEPT: Museum
OES
(glk_gr = 'GL' AND glk_grp_part03 = '047') or (glk_gr = 'JL' AND glk_grp_part01 = '010') or (glk_gr = 'JL' and glk_key = '10104800')
DEPT: Office of Emergency Services; JL Program Type: Federal Emergency, JL Key: 2021-22 Winter Storm
OES - GL ONLY
(glk_gr = 'GL' AND glk_grp_part03 = '047')
DEPT: Office of Emergency Services
OES-PW Disasters
glk_gr = 'GL' and glk_grp_part03 = '047' or glk_gr = 'JL' and glk_grp_part04 = '047'
DEPT: Office of Emergency Services; JL DEPT: OES Grants
Onsite Wastewater
glk_gr = 'GL' AND glk_grp_part03 = '055'
DEPT: Onsite Sewage
Patrol
glk_gr = 'GL' AND glk_grp_part03 = '032'
DEPT: Sheriff
PE - Upload
Temp Vendor Upload AP templates - Audit & Elections
N/A
PE FULL
Audit Only
N/A
Planning
glk_gr = 'GL' AND glk_grp_part03 = '043'
DEPT: Planning
Probation
glk_gr = 'GL' AND glk_grp_part03 = '034'
DEPT: Probation
Public Access TV
glk_gr = 'GL' AND glk_grp_part03 = '805'
DEPT: PEG Television
Public Authority
(glk_gr = 'GL' AND glk_grp_part06 = '161') OR (glk_gr = 'JL' AND glk_grp_part05 = '161')
DEPT HEAD: Public Auth Director; JL DEPTHEAD: Public Auth Director
Public Defender
glk_gr = 'GL' AND glk_grp_part03 = '031'
DEPT: Public Defender
Public Works Admin
(glk_gr = 'GL' AND glk_grp_part06 = '17') or (glk_gr = 'JL' AND glk_grp_part01 = '010') or (glk_gr = 'JL' AND glk_grp_part06 = '017')
DEPT HEAD: Director of Public Works; JL Program Type: Federal Emergency, JL DEPTHEAD: Public Works Director
Public Works- Disaster Response/Recovery                            
glk_gr = 'GL' AND glk_grp_part03 = '076' and glk_grp_part07 = '08'                                                                                                                                                               
DEPT: Department of Public Works, Service Function: Disaster Response/ Recovery
PY Full
Audit Only
N/A
PY Read Only
Audit and HR Only
N/A
Sheriff All
glk_gr = 'GL' AND glk_grp_part06 = '10'
DEPT HEAD: Sheriff
Treasurer Tax Collector
glk_gr = 'GL' AND glk_grp_part06 = '05'
DEPT HEAD: Treasurer- Tax Collector
VETERAN
glk_gr = 'GL' AND glk_grp_part03 = '019' OR glk_key = '10100190'
DEPT: Veterans Services, Org Key: Veterans Services
Victim Witness
glk_gr = 'GL' AND glk_grp_part03 = '021'
DEPT: Victim-Witness Assistance

 

Calaveras County seal and link to County main website

Go to top

Copyright 2025 Calaveras County

Terms of Use | Privacy Statement | Accessibility