Foundation, Integration & Semantic Model
SOW 3.1 — the governed layer that makes every number in this platform traceable, defined and owned.
Mapped fields
24
Business ↔ technical
Approved measures
13
14 total defined
Calculation rules
8
Owner-approved logic
Source objects
8
ADG, Kronos, OAC, app-managed
Access roles
6
Row-level scoped
Business-friendly data dictionary
Technical field names mapped to approved agency terminology, with owner and sensitivity.
24 fields
| Employee ID | PERSON_NUMBER | ADG_HR_EMPLOYEE_D | Oracle HCM (ADG) | Workforce | Code | Standard | HR Systems | Agency-unique person number used to join payroll, timecard and benefits records. |
|---|---|---|---|---|---|---|---|---|
| Employee Name | FULL_NAME | ADG_HR_EMPLOYEE_D | Oracle HCM (ADG) | Workforce | Text | Standard | HR Systems | Legal name as recorded in the human resources system of record. |
| Rank | JOB_TITLE | ADG_HR_ASSIGNMENT_F | Oracle HCM (ADG) | Workforce | Text | Standard | HR Systems | Sworn or civilian classification effective on the work date. |
| Division | ORG_LEVEL_2 | ADG_HR_ORG_D | Oracle HCM (ADG) | Workforce | Text | Standard | HR Systems | Assigned organizational division (Patrol District, Special Operations, School Resources…). |
| Unit | ORG_LEVEL_3 | ADG_HR_ORG_D | Oracle HCM (ADG) | Workforce | Text | Standard | HR Systems | Operating unit or capability group such as SWAT, K-9, Drone Team, Dispatch. |
| Assigned Cost Center | HOME_COST_CENTER | ADG_HR_ASSIGNMENT_F | Oracle HCM (ADG) | Workforce | Code | Standard | Accounting | Cost center the employee is budgeted against, independent of where hours are charged. |
| Charged Cost Center | CHARGE_COST_CENTER | ADG_PAY_TXN_F | Oracle Payroll (ADG) | Payroll | Code | Standard | Finance / Payroll | Cost center actually charged on the payroll transaction; drives 3.5 cost-center controls. |
| Job Code | JOB_CODE | ADG_PAY_TXN_F | Oracle Payroll (ADG) | Payroll | Code | Standard | Finance / Payroll | Activity code identifying event, contract or routine duty for the hours worked. |
| Pay Type | ELEMENT_NAME | ADG_PAY_TXN_F | Oracle Payroll (ADG) | Payroll | Text | Standard | Finance / Payroll | Regular, Overtime, Holiday Worked, Holiday Not Worked or Special Assignment pay element. |
| Hours | HOURS_QTY | ADG_PAY_TXN_F | Oracle Payroll (ADG) | Payroll | Number | Standard | Finance / Payroll | Hours paid on the transaction for the given pay type and work date. |
| Gross Pay | PAY_AMOUNT | ADG_PAY_TXN_F | Oracle Payroll (ADG) | Payroll | Currency | Standard | Finance / Payroll | Gross dollars paid on the transaction before employer burden. |
| Pay Period | PAY_PERIOD_ID | ADG_PAY_PERIOD_D | Oracle Payroll (ADG) | Payroll | Code | Standard | Finance / Payroll | Semi-monthly payroll cycle the transaction posted in; used for quarter-end cutoffs. |
| Payroll Transaction ID | PAY_TXN_ID | ADG_PAY_TXN_F | Oracle Payroll (ADG) | Payroll | Code | Standard | Finance / Payroll | Source key providing traceability from any dashboard total back to payroll detail. |
| SRD Code | SRD_ACTIVITY_CODE | TK_DAILY_DETAIL | Kronos Export | Contract | Code | Standard | Finance / Contracts | School resource deputy activity codes 51–54 distinguishing billable school coverage. |
| Benefit Class | COVERAGE_TIER | ADG_BEN_ELECTION_D | Oracle Benefits | Benefits | Text | Standard | HR Benefits | Elected coverage tier (EE Only, EE + Spouse, EE + Children, Family). |
| Employer Benefit Cost | ER_CONTRIB_AMT | ADG_BEN_RATE_F | Oracle Benefits | Benefits | Currency | Standard | HR Benefits | Employer share of medical, dental, vision, life, retirement and other benefit programs. |
| Date of Birth | DATE_OF_BIRTH | ADG_HR_PERSON_D | Oracle HCM (ADG) | Benefits | Date | Restricted | HR Benefits | Used for carrier census age banding. Restricted field — row-level access required. |
| Dependent Relationship | DEP_RELATION | ADG_BEN_DEPENDENT_D | Oracle Benefits | Benefits | Text | Restricted | HR Benefits | Spouse, child or other eligible dependent covered under the employee's election. |
| Contract | CONTRACT_ID | contract_master | Application Managed | Contract | Code | Standard | Finance / Contracts | Governed contract register key covering municipal, hospital, school board and charter agreements. |
| Billing Rate | BILL_RATE | contract_master | Application Managed | Contract | Currency | Standard | Finance / Contracts | Contracted hourly billing rate or fixed-fee equivalent used for reimbursement. |
| Event | EVENT_ID | event_master | Application Managed | Event | Code | Standard | Business Analytics | Coded activity such as graduation, pop-up security event or emergency response. |
| Object Code | GL_OBJECT_CODE | ADG_GL_SEGMENT_D | Oracle GL (ADG) | General Ledger | Code | Standard | Accounting | Expenditure object code translated into operational categories for command staff. |
| Adopted Budget | BUDGET_AMT | ADG_GL_BUDGET_F | Oracle GL (ADG) | Budget | Currency | Standard | Budget Office | Board-adopted appropriation for the fiscal year, cost center and object code. |
| Encumbrance | ENCUMBRANCE_AMT | ADG_GL_ENCUMBRANCE_F | Oracle GL (ADG) | Budget | Currency | Standard | Budget Office | Open purchase-order commitments not yet expended. |
Restricted fields are masked unless the requesting role carries Benefits & Census Access. Access to restricted fields is logged.