Schema for HRS Version V1.0
Alphabetical Table Summary
aca-benefit-plan - ACA Benefit Plan codes
aca-category-code - (no description available)
aca-coverage-code - ACA Coverage Codes
aca-safe-harbor-code - (no description available)
accr-code - Accrual Block Code Definitions
accr-group - Accrual Group Code
atnd-accr - Attendance code -> Accrual Code assignments
atnd-code - Attendance Code Definitions
atnd-group - Attendance Code Ground definitions
atnd-unit - Attendance Unit Code Definitions
atnd-unit-xlate - Unit Translations File
benefit-class - Benefits Class definitions
benefit-code - Benefit Code Descriptions
cert-code - Certification Area codes
cert-type - Certification Type codes
comp-code - Company Code definitions
contact-code - Contact Code definitions
dc-record-type - (no description available)
dc-status-reason - (no description available)
deduct-group - Deduction Group definitions
degree-study - Areas of study for the degree
degree-type - Degree Type Definitions
dept-code - Department Code Definitions
district-1094c - (no description available)
div-code - Division Code Definitions
ecc-code - ECC Code Definitions
emp-1095c - Employee 1095c filing record
emp-aca - (no description available)
emp-accr - Employee Accrual Blocks
emp-adjust - Employee Adjustments
emp-atnd - Employee Attendance Entries
emp-benefit - Employee Benefits
emp-contact - Employee Contacts
emp-counter - Employee Counters
emp-dc - (no description available)
emp-deduct - Employee Deductions file
emp-deduct-rate - Employee Deduction/Payrate linkage
emp-degree - Employee Degrees
emp-demo - Employee Demographic Entry
emp-dependent - Employee Dependent Definition file
emp-distrib - Employee Distributions
emp-event - (no description available)
emp-fringe - (no description available)
emp-group - Employee Groupings File
emp-history - Employee Demographic Entry
emp-mpsers - (no description available)
emp-note - Employee Notes file
emp-pay-master - Employee Payroll Master
emp-payroll - The one per employee, once per payroll control file
emp-prof - Employee Professional Catagories
emp-quarter - Employee Quarterly Retirement reporting records
emp-rate - Employee Payrate records
emp-rate-hours - Employee Payrate Hourly detail
emp-rate-loc - Employee Payrate Locations records
emp-rate-savings - Employee payrate savings, typically used for Summer Savings
emp-retire - Employee Retirment Records
emp-site - Site Specific Employee data file
emp-state-item - Describes an employee state record entry
emp-taxes - Employee Taxes (FICA, Medicare, FIT, SIT & LIT)
emp-tdp - Employee DTL3 record
emp-unemp - Employee Unemployement counters
emp-w2 - Employee W2 Info
ethnic-code - Ethnic Code definitions
event-code - (no description available)
event-group - (no description available)
fringe-class - Fringe benefit classes
fringe-code - (no description available)
fringe-period - Fringe Benefit Period
grant-fund - (no description available)
history-code - Employee History Activity Codes
hrs-prof - HRS System wide profile
irs-class - IRS Deduction Classification codes
job-code - Definition of district job codes
loc-code - Location Codes
marital-code - Marital Status Codes
mpsers-period - (no description available)
mu-stat - Mass Update Status flags file
note-code - Definition of each of the possible note codes
pay-acct - Payroll Distribution Account List
pay-activity - Activity associated with Salary paid
pay-assign - Payroll Assignments
pay-assign-role - Role & Service of Pay Assignment
pay-check - Payroll Check file, one record per payroll check issued
pay-cycle - Payroll Cycle Definitions
pay-cycle-schd - Linkage file between cycles and the payroll active for them
pay-deduct - Payroll Master Deductions definition
pay-disburse - Record of per-payroll vendor disburements
pay-distrib - Payroll DIstributions file
pay-group - Payroll employee group definitions
pay-log - Payroll Message log file
pay-profile - Payroll System Profile
pay-rate - Master Payrate definitions
pay-schd - Payroll Schedule for a year One entry per
pay-year - Payroll Year definitions
permit-grade - Permit/Certification Grade Levels
permit-pop - Population Served with Permit/Certification
permit-status - Permit/Certification Status
permit-subject - Permit/Certification Subject Areas
permit-type - Permit Issuance/Renewal Types
prof-cert - Profession Catagory Certifications
prof-code - Profession Catagory Codes
relate-code - Describes relationships between other persons and the employ
replicate-queue - (no description available)
retire-code - Retirement code definitions
role-code - Role within position for which salary is paid
schd-item - Individual entries for each step/level of each payroll sched
schd-label - Labels or the Step/Level of the Payroll Schedule
schd-profile - Employee Contract Schedule/Step/Level profile
service-code - Service Codes for salary paid
site-fld-define - Site Field definitions
site-fld-group - Site field to user group mapping file. This is the interface
site-frame - Site Defined frame definitions
site-table-code - Site Table Codes
site-table-name - Site Table Names
status-code - Employee Status Codes
study-type - Code describing type of study
tax-table - Federal, State and Local tax tables
tdp-adjustment-type - TDP Adjustment type codes for MPSERS
tdp-deduct-reason - (no description available)
tran-code - Real World Translation Definitions
univ-code - University Codes
user-access - User access restrictions file. If there is no restriction
wage-code - (no description available)
Alphabetical Sequence Summary
codes: Min is 1, Init to 1, Increment by 1, Stop at limit
emp-item: Min is 0, Init to 0, Increment by 1, Cycle at limit
events: Min is 1, Init to 1, Increment by 1, Stop at limit
history: Min is 0, Init to 0, Increment by 1, Cycle at limit
mpsers: Min is 1, Init to 1, Increment by 1, Cycle at limit
primary-hr: Min is 1, Init to 1, Increment by 1, Stop at limit
primary-misc: Min is 1, Init to 1, Increment by 1, Stop at limit
primary-payroll: Min is 1, Init to 1, Increment by 1, Stop at limit
replicate-seq: Min is 0, Init to 0, Increment by 1, Cycle at limit
Created on 12/28/2020 by DBHTML V1.2