Home

HROffice Database Schema

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