Samuel Hale
Samuel Hale provides comprehensive insurance, employment and technology services including worker’s comp, staffing, payroll, HR and benefits.
Samuel Hale
Samuel Hale provides comprehensive insurance, employment and technology services including worker’s comp, staffing, payroll, HR and benefits.
Menu
Data & Metrics
Client Account
-
clientAccountId
-
clientAccountName
-
clientAccountCity
-
clientAccountDescription
-
clientAccountState
-
modifiedDate
-
payrollInvoiceId
-
payrollFrequencyId
-
invoicetypeInvoiceType
-
clientAccountStatusid
-
accountStatus
-
originalEffectiveDate
-
productLine
Claim Details
-
claimid
-
claimNumber
-
clientAccountId
-
client
-
foreign keys
-
clientAccountName
-
classCodeId
-
class code
-
incurred
-
paid
-
currentReserve
-
claimStatus
-
claimType
-
trueIndemnity
-
bodyPartDetail
-
lossCauseDetail
-
lossTypeDetail
-
litigated
-
litigationState
-
claimDenied
-
claimDeniedDate
-
tags
-
litigatcumulativeTramaionState
-
postTerm
-
multiBodyPart
-
modifiedDate
-
deleted
-
dateofLoss
-
dateReportedtoSamuelHale
-
claimOpenedDate
-
claimClosedDate
-
billedOccurrenceFee
-
dateReportedtoClient
-
policyNumber
-
masterPolicyId
-
master policy
Class Code
Entity
-
classCodeId
-
classCodeDescription
-
preferred
-
createdDate
-
createdById
-
createdByName
-
modifiedDate
-
modifiedById
-
modifiedByName
-
excluded
Pay Details Codes
-
payCheckCodeId
-
payCheckCode
-
clientAccountId
-
client
-
description
-
codeType
-
classification
-
createdDate
-
createdById
-
createdByName
-
modifiedDate
-
modifiedById
-
modifiedByName
-
category
Claim Paid By Class
-
uuid
-
exp
-
med
-
leg
-
ind
-
voc
-
paymentMonth
-
classCodeId
-
masterPolicyId
-
master policy claim paid by class
Client Claims Paid By Class
-
uuid
-
clientAccountId
-
client
-
clientAccountName
-
classCodeId
-
claimNumber
-
exp
-
med
-
leg
-
ind
-
voc
-
masterPolicyId
-
master policy client claim paid by class
Client Claims Paid By Class And Subclass
-
uuid
-
unique
-
default
-
index
-
clientAccountId
-
clientAccountName
-
classCodeId
-
claimNumber
-
tags
-
class
-
subclass
-
paid
-
masterPolicyId
-
master policy claim paid by class and subclass
Subject Wages By Week End And Class Code
-
uuid
-
unique
-
default
-
index
-
classCodeId
-
subjectWages
-
weekEnd
-
elr
-
purePremium
-
masterPolicyId
-
master policy subject wages by weekend and class code
Subject Wages By Check Date And Class Code
-
uuid
-
unique
-
default
-
index
-
clientAccountId
-
clientAccountName
-
classCodeId
-
claimNumber
-
tags
-
class
-
subclass
-
paid
-
masterPolicyId
-
master policy claim paid by class and subclass
Employee
-
employeeid
-
ethnicity
-
firstName
-
lastName
-
veteranDescription
-
gender
-
externalEmployeeid
-
clientAccountId
-
client
-
birthYear
-
status
-
terminationDate
-
hireDate
Weekly Client Pay And Deductions Summary
-
uuid
-
weekEnd
-
clientAccountId
-
client
-
payrollCompanyId
-
department
-
payCheckCode
-
codeType
-
description
-
category
-
hours
-
amount
-
masterPolicyId
-
master policy weekly client pay and deductions summary
Client Policy
-
uuid
-
clientAccountName
-
broker
-
producer
-
producerEmail
-
policyId
-
clientAccountId
-
client
-
effectiveDate
-
policyNumber
-
occurranceFee
-
deductible
-
pactRate
-
agencyId
-
producerId
-
termDate
-
adminRate
-
waiverOfSubrogation
-
alternateEmployerEndoresment
-
failureToComplyLevel1
-
failureToComplyLevel2
-
failureToComplyLevel3
-
failureToComplyLevel4
-
stopPaymentPerCheck
-
deliveryFeePerLocation
-
W2cAdjustments
-
amendedTaxReturnPerHour
-
failureToProveNotice
-
createdDate
-
createdById
-
createdByName
-
modifiedDate
-
modifiedById
-
modifiedByName
-
currentEffective
-
commission
-
masterPolicyId
-
master policy
-
billTaxesAndFees
-
ccmsiId
Master Policy
-
masterPolicyId
-
policyNumber
-
policyStartDate
-
policyEndDate
-
carrierId
-
carrierName
-
fixedPremium
-
lossFund
-
currentInforce
-
createdDate
-
createdById
-
createdByName
-
modifiedDate
-
modifiedById
-
modifiedByName
-
manualDiscount
-
taxesFees
-
currentPaid
-
currentIncurred
-
currentReserve
-
terrorismCatastrophyFee
Claim Tag
-
claimTagId
-
claimTag
-
createdDate
-
createdById
-
createdByName
-
modifiedDate
-
modifiedById
-
modifiedByName
Claim Tag M2M
-
claimTagM2mId
-
claimTagId
-
claim tag
-
claimId
-
claim details
-
createdDate
-
createdById
-
createdByName
-
modifiedDate
-
modifiedById
-
modifiedByName
Claim Transaction Detail
-
claimTransactionDetailId
-
transactionId
-
transactionDate
-
transactionAmount
-
code
-
class
-
status
-
workflowStatus
-
subclass
-
detailAmountCharged
-
detailAmountDiscount
-
detailAmountNet
-
claimNumber
-
claimant
-
dateCheckPrinted
-
checkRefNumber
-
checkAmount
-
payeeName
-
payeeFedId
-
checkPrinted
-
transactionComment
-
detailComment
-
void
-
locationName
-
controlnumber
-
lossDate
-
lossYear
-
claimId
-
claim details
-
indemnityBilled
Claim Reserve Transaction Detail
-
claimTransactionDetailId
-
reserveId
-
reserveDate
-
class
-
subclass
-
reserveAmount
-
reserveDetailAmount
-
reserveComment
-
reserveDetailText
-
claimNumber
-
claimant
-
locationName
-
claimId
-
claim details
X Mod History
-
xmodHistoryId
-
clientAccountId
-
client
-
clientAccountClientAccountName
-
xmodYear
-
xmod
-
createdDate
-
createdById
-
createdByName
-
modifiedDate
-
modifiedById
-
modifiedByName
Client Frequency
-
id
-
modifiedDate
-
anchorDate
-
originalEffectiveDate
-
countClaimsReported
-
sumHours
-
clientAccountId
-
client
Premium By Client And Invoice Date
-
clientAccountId
-
invoiceDate
-
premium
-
client
Carrier Claims Summary
-
carrierSummaryId
-
monthEnd
-
carrierId
-
carrier id
-
claimsByDol
-
claimByOpenDate
-
closedClaimsByMonth
-
newIncurred
-
development
-
salvage
-
paid
-
subjectWages
-
purePremium
-
lossFundActual
-
billedPremiumAndDeductibles
Master Policy Claims Summary
-
masterPolicySummaryId
-
masterPolicyId
-
master policy
-
masterPolicyNumber
-
masterPolicyStartDate
-
masterPolicyEndDate
-
masterPolicyCarrierName
-
monthEnd
-
carrierId
-
carrier id
-
claimsByDol
-
claimByOpenDate
-
closedClaimsByMonth
-
newIncurred
-
development
-
salvage
-
paid
-
subjectWages
-
purePremium
-
lossFundActual
-
billedPremiumAndDeductibles
Carrier
-
carrierId
-
carrierName
-
wcirbId
-
createdDate
-
createdById
-
createdByName
-
modifiedDate
-
modifiedById
-
modifiedByName
