Google Search Results
WebAPI Field Names
Note: All Dates are 01/01/1900 if invalid or null
- ID
- Unique ID for QB
- ClientEmployer_ID
- ID of parent client/employer
- BillingQBID
- ID of This QB's Billing Contact (same if this is the billing contact)
- Status
- Current Status
- FirstName
- First Name
- LastName
- Last Name
- SSN
- SSN
- QBID
- QBID
- PremiumsPaidTo
- Date QB is Paid To
- TotalMonthlyPremium
- QB's total current monthly premium (no fees)
- TotalMonthlyAdminFee
- QB's total admin fees
- TotalMonthlyDue
- Premium plus fees
- AccountBalance
- QB's current Account Balance
- MinimumMonthlyDue
- QB's minimum amount to pay each month
- EnrollmentEndDate
- When the QB's enrollment end
- TotalDueToCompleteEnrollment
- Amount that will pay QB through the end of their payment window
- ExpectedPremiumsPaidThrough
- If the QB has paid into the future, this is the date it will pay through (based on current rates)
- ContinuationCoverageType
- Federal, State, or Both
- EmployeeID
- Employee ID
- HireDate
- Date of Hire
- Age
- QB's Current Age
- DateOfBirth
- QB's DOB
- AddressLine1
- Address Line 1
- AddressLine2
- Address Line 2
- City
- City
- State
- State
- ZipCode
- ZipCode
- DepartmentName
- Department Name
- DepartmentCode
- Department Code
- Gender
- Gender
- TerminationDate
- Termination Date
- TerminationReason
- Termination Reason
- Relationship
- QB Relationship (Spouse, Former Employee, Son, Domestic Partner, etc)
- Title
- QB's title or salutation (Mr, Mrs, Ms)
- EntryDate
- Date QB was added into WebCOBRA
- SocialSecurityEndDate
- Date 11 month Social Security Disability will end. (1900 date if N/A)
- EventType
- Qualifying event type: Termination, Reduction in Hours, etc
- EventDate
- Date of qualifying event
QB: Qualified Beneficiary
- QB_ID
- ID of QB
- PaymentAmount
- Amount of Payment
- Date Entered
- Entered in the System
- Check Date
- Date of the Check
- Payment Method
- Check, ACH, etc
- Memo
- Comments or description
- TransactionIdent
- Check Number
- Void
- Has this payment been voided?
- VoidedOn
- If voided, when was it voided?
QB_Payment: QB's payments
- BenefitPlan_ID
- ID of Benefit Plan
- QB_ID
- ID of QB
- Current Premium
- This Month's Premium (no fee)
- Current Free
- This Month's Fee
- CoverageLevelDescription
- Coverage Level Description
- FirstDayAfterLossOfCoverage
- Start of Continuing Coverage
- LifePlanCoverage
- Amount of Life Insurance Coverage (in dollars)
- SubsidyEndDate
- End date of the Subsidy Assignment
- SubsidyDollarAmount
- If the subsidy given to the QB was dollars (rather than percentage), will appear here
- SubsidyPercentage
- Percentage of the Premium that is subsidized (either dollar or pecentage may be chosen, but not both)
QB_BenefitPlan: QB's benefit assignments
- Name
- Client/Employer's Name
- Code
- Client/Employer's Code
- AddressLine1
- Address Line 1
- AddressLine2
- Address Line 2
- City
- City
- State
- State
- ZipCode
- ZipCode
ClientEmployer: Employer object
- ClientEmployer_ID
- ID of parent client/employer
- Name
- CarrierSponsor's Name
- Code
- CarrierSponsor's Code
- AddressLine1
- Address Line 1
- AddressLine2
- Address Line 2
- City
- City
- State
- State
- ZipCode
- ZipCode
CarrierSponsor: Parent of Benefit Plan - either the Insurance Carrier or the Plan Sponsor
- CarrierSponsor_ID
- ID of parent carrier/sponsor
- Name
- BenefitPlan's Name
- Code
- BenefitPlan's Code
- Start Date
- Plan's Original Start Date
- End Date
- BenefitPlan's End Date (12/31/9999 is not-ending)
BenefitPlan
- Correspondence _ID
- ID of parent QB
- LetterTemplateTypeID
- ID of Letter printed
- LetterTemplateType
- Description of Letter printed (Premium Bill, Cobra Election Notice, etc)
- PrintedDate
- Date and Time letter was accepted by user
QB_Correspondence : Letters accepted and printed to the QB
You can take advantage of these with Sample Code; Return to Web Services.
