XY-ADMIN Roundtable

1
XY-ADMIN Roundtable

• Session 401

2
Set up Monthly Billing Products

• HSBC has set up several new products
• Review products
• Set up issues encountered
• Set up issue resolution
• Other clients with similar experiences

3
Review of Various Bill Mode Set Up issues

• Set up Considerations - Table 89, Table 9J
• Billing Frequency
• What is Monthly Charge
• Discount if paid annually
• Discount for other pay frequencies

4
Options File Table 89 (page 1)
09-02-05 FORMATTED OPTION FILE
DISPLAY XSP120 /4.003
89 BILLING/CALC MODES


TABLE KEY AN

.......10.......20.......30.......40
DESCRIPTION ANNUAL
DIRECT ltMUSTFILLgt
CALC FLAG _
CALC METHOD
_
ltABEgt CALC TIMES A MONTH _
lt1234gt CALC
PERIOD - MONTHS 012
ltNUMERICgt CALC PERIOD - DAYS
___
ltNUMERICgt CALC ON DAY OF MONTH 1 __
ltNUMERICgt CALC
ON DAY OF MONTH 2 __
ltNUMERICgt CALC ON DAY OF MONTH 3
__
ltNUMERICgt CALC ON DAY OF MONTH 4 __
ltNUMERICgt BILL
FLAG _
BILL METHOD
E
ltABCDEgt BILL TIMES A MONTH _
lt1234gt BILL
PERIOD - MONTHS 012
ltNUMERICgt
LAST UPDATED 06-20-03 BY KLA PAGE 1 OF
3 PF1 BROWSE FWD PF2 BROWSE BACK
PF5
INQUIRE PF7 NEXT PAGE
PF8 PREV PAGE PF10
SEARCH PF11 RETURN PF12 HELP
007 - THIS IS THE FIRST PAGE
5
Options File Table 89 (page 2)
09-02-05 FORMATTED OPTION FILE
DISPLAY XSP120 /4.003
89 BILLING/CALC MODES


TABLE KEY AN

.......10.......20.......30.......40
BILL PERIOD - DAYS ___
ltNUMERICgt BILL ON
DAY OF MONTH 1 __
ltNUMERICgt BILL ON DAY OF MONTH 2
__
ltNUMERICgt BILL ON DAY OF MONTH 3 __
ltNUMERICgt BILL
ON DAY OF MONTH 4 __
ltNUMERICgt BILL DATE BASIS
F ltFTgt
BILL BEFORE/AFTER DATE B
ltBAgt BILL DIFF -
MONTHS ___
ltNUMERICgt BILL DIFF - DAYS 020
ltNUMERICgt
NEW QUARTERLY BILL MODE __
ltTABLE 89gt NEW SEMI-ANNUAL
BILL MODE __
ltTABLE 89gt NEW ANNUAL BILL MODE __
ltTABLE 89gt
CHANGE MODE LETTER ________
INTERMITTENT
BILLING _
ltY OR Ngt LAST
UPDATED 06-20-03 BY KLA PAGE 2 OF 3
PF1 BROWSE FWD PF2 BROWSE BACK
PF5 INQUIRE
PF7 NEXT PAGE PF8
PREV PAGE PF10 SEARCH
PF11 RETURN PF12 HELP
6
Options File Table 89 (page 3)
09-02-05 FORMATTED OPTION FILE
DISPLAY XSP120 /4.003
89 BILLING/CALC MODES


TABLE KEY AN

.......10.......20.......30.......40
EXPIRY LIMIT _
ltY OR Ngt AGE
RECALC PERIOD __
ltNUMERICgt
Setup the same with other frequencies, except
CALC PERIOD MONTHS Quarterly 004 Semi-Annual
006
7
Options File Table 9J
09-02-05 FORMATTED OPTION FILE
DISPLAY XSP120 /4.003
9J BILL MODE FORMULA


TABLE KEY ADAN

.......10.......20.......30.......40
BILL FORMULA (KEY) AD
ORIG
ISSUE STATE (KEY)
PAYMENT METHOD (KEY)

BILL MODE (KEY) AN
PCNT (83
1/30000833333) 0119677410
ltNUMERICgt ROUND DIRECTION
N ltNUgt
ROUND AROUND (DIME 010) 020
ltNUMERICgt EXTRA PREM CHG
(1 - 100) 000
ltNUMERICgt

• Table to adjust monthly charge to annual for
  monthly billing mode, i.e. Monthly premium of
  6.20 x 11.9677410 74.20 annually
• Table accessed by referencing AD bill formula
  on rate table, and Bill Mode AN entered on new
  business screen
• Rounding Feature to adjust charge as needed

8
Joint Coverage Considerations
09-02-05 PRODUCER - RATES
XPP530 /4.022 BROWSE CURR Y

PRODUCER CS000009 ABC SERVICES
INSURER
04 XYZ LIFE INSURANCE CO
COVERAGE ADDJ AD W/DISMEM RIDER - JT
FROM
08-01-03 THRU CURRENT TERMINATION DATE
DELETE FLAG REASON

ELIG STATE UPGRADE COV RENEW
COV AUTO FORCE
MIN BILL 0.00
ISSUE FEE 0.00 CANCEL FEE
0.00
TOLERANCE ISSUE HIGH 0 ISSUE LOW 0
METHOD D (PPCT, DDOLLAR)
CANCEL HIGH 0 CANCEL LOW 0 METHOD D
(PPCT, DDOLLAR) --RATE STRUCTURE--------------
-----------------------------------------------
LOCATION 99 ALL STATES
CLASS
80
RATE ID CS02
ACCID.DEATH W/DISMEMB RIDER-JNT
QUALIFICATIONS SEX SMOKER
RATE METHOD
03 BOR1 100 BOR2 NO CHARGE
PERCENTAGE BILL
MODE FORMULA

PF1 INQUIRE
PF2 ADD COVERAGE PF3 NEW DATE RANGE PF4
CHANGE PF5 BROWSE FWD PF6 BROWSE
BACK PF7 LIMITS PF8 RATES PF9
PROD RATE XREF PF11
PRODUCER MENU
9
Joint Coverage Considerations

• Producer rate screen
• Rate Method
• 01 Borrower 1 premium calculated, Borrower 2
  entered (Percentage) of that amount
• 02 Senior borrower premium 100 of calculated
  premium for borrower, Junior borrower premium is
  entered of junior borrowers calculated premium
• 03 Senior borrowers premium 100 of
  calculated, no premium borrower 2
• 04 Borrower 1 premium is entered of
  calculated, borrower 2 premium remaining of
  premium
• 05 Senior borrower premium calculated, junior
  borrower of that amount