Home

HROffice Database Schema

AdjustPR Adjustments
AdminFor AdminFor
AgeRedct AgeReduction
AgeSalCI AgeSalaryChange
AuditItem AuditItem
AuditPkg AuditPkg
BCustom BCustom
BE401K 401K
BE401KMatch 401KMatch
BEELife EmployeeLife
Beneficiary Beneficiary
BenNotes BenefitNotes
BenRateD RateDetail
BenRateM RateMaster
BESLife SuppLife
BEStdLtd StdLtd
BLOB BLOB
BMedical Medical
BookMark BookMark
BPMaster Benefit
CalHoliday CalHoliday
CalWeekend CalWeekend
Carrier Carrier
Category Category
CatList CatList
CContact Contact
CmpnyDep Department
CmpnyDiv Division
CmpnyJob JobTitle
CmpnyLoc Location
CobraElc CobraElection
CobraInt CobraINotice
CobraLog CobraLog
CobraNot CobraNotes
CobraPay CobraPayments
Company Company
CompPlan CompPlan
ComRates CommonRates
ContbInfo Contribution
CstFldDt CustomFieldDetail
CstFldHd CustomFieldMaster
DDeposit DDeposit
DDepositCode DDepositCode
EContact EContact
ECWBatch ECWBatch
ECWField ECWFields
EEEnroll Enrollment
EligbDpn EligibleDepend
EligCodes EligCodes
EligOverride EligOverride
EligRule EligRule
EmpBenfic EmpBenfic
EmpBonH BonusHist
EmpChang EmpLastChange
EmpCOB EmpCOB
EmpCstFV EmployeeCustomData
EmpDepnd Dependent
EmpEligb EligibleEmp
EmpEnrlStatus EmpEnrlStatus
EmpJobH JobHist
EmpLeave EmpLeave
Employee Employee
EmpNotes EmpNotes
EmpProvider EmpProvider
EmpRevH ReviewHist
EmpSalH SalaryHist
EmpStatH EmpStatusHist
EnrBenef Beneficiaries
EnrDepnd EnrollDepend
EnrFunds EnrollFunds
EnrHist EnrollHist
EnrNotes EnrollNotes
EnumCode EnumCode
EnumType EnumType
EssAlwdChRsn EssAlwdChRsn
EssApprPolicy EssApprPolicy
EssApps EssApps
EssCustInstruct EssCustInstruct
EssDialog EssDialog
EssField EssField
EssFldChgLog EssFldChgLog
EssLinks EssLinks
EssMainConfig EssMainConfig
EssPlanCompCat EssPlanCompCat
EssPlanCompDesc EssPlanCompDesc
EssPlanFields EssPlanFields
EssPlanLinks EssPlanLinks
EssPlanType EssPlanType
EssRowChgLog EssRowChgLog
EssSections EssSections
EssSessionLog EssSessionLog
FilingStatus FilingStatus
FMLA FMLA
FMLAPolicy FMLAPolicy
Fund401K 401KFund
GenCodes GenCodes
GenNotes GenNotes
GlobalSettings GlobalSettings
HpConnect HpConnect
HpConnectCust HpConnectCust
HpConnectJob HpConnectJob
HpConnectOptFld HpConnectOptFld
HpConnectPlan HpConnectPlan
HpRespPersons HpRespPersons
HpTransmitLog HpTransmitLog
HRLocations RHRLocations
IntErrorLog IntErrorLog
JobEligb EligibleJob
LeaveLOSAward LeaveLOSAward
LeavePolicy LeavePolicy
LeaveRequest LeaveRequest
LeaveType LeaveType
LocEligb EligibleLoc
Map RMap
MapSetup RMapSetup
MedRates MedicalRates
MigrateGen MigrateGen
OpenEnrl OpenEnroll
OpenEnrollPer OpenEnrollmentPeriod
OpenEnrollPlan OpenEnrollPlan
OSHACase OSHACase
OSHAProvider OSHAProvider
PayGrade PayGrade
PayrollSystem RPayrollSystem
PayStub PayStub
PayStubItem PayStubItem
PayStubItemCat PayStubItemCat
PayStubItemType PayStubItemType
PhoneNbs EmpPhoneNbrs
PLAmbgRes PLAmbgRes
PlanElig PlanElig
PlanTypePlan PlanTypePlan
PPOInfo PPOInfo
Profile Profile
ProfileItem ProfileItem
Provider Provider
ReviewMt ReviewMaster
Role Role
RoleOrg RoleOrg
RoleRight RoleRight
S125Elig S125Expenses
S125PCpn PremConvPlans
SchemaAudit SchemaAudit
Sect125 S125Info
SeqNbrs SysSeqNbrs
ShiftTab Shift
SpidUserPID SpidUserPID
StdBuyUp StdLtdBuyUp
StopLoss StopLoss
StopLsPl StopLossPlans
SupDpnRD LifeRateDetail
SupDpnRM LifeRateMaster
SupVolum Volume5
SyCstFld SysCustomFields
SyLicens SysLicense
SyRole SysRoles
SyUsers SysUsers
TaxType TaxType
TaxWithhold TaxWithhold
TPACarrier TPACarrier
TPAFee TPAFee
TPAInfo TPAInfo
TransferItem RTransferItem
TransferLog RTransferLog
UserRole UserRole
Vest401K 401KVesting
Volume1 Volume1
Volume2 Volume2
Volume3 Volume3
Volume4 Volume4
Wizard RWizard
WizOption RWizOption
WizOptionEntry RWizOptionEntry