Code by wanghonghx

VIEWS: 4 PAGES: 79

									                                 9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls


                        Sup MS                                                                                          MSG MS
MSG_SCHEME              pres G_I Msg_text                                  Comments                                     _PRI G_

Contributor Msg Manuals Y     135 Error determining member's address       Addresses                                     999 SI
                                  Error occurred while calculating PSS     Lt Blue = Calc class: Some 160's have
Contributor Msg Manuals ?/n   160 transfer values                          been fixed                                    999 SM
                                  Option used for calculation is not
Contributor Msg Manuals N     200 available to member                     OK, removed message, calcs fine                999 SM
                                                                          calcs errors have 0 in fields eg joine
Contributor Msg Manuals Y     210 Information statement calculation error wrong scheme; no eq; date issue                999 SM
                                  Error in creating transaction summary may mean no date on trans summ
Contributor Msg Manuals Y     211 data                                    (mismatch) ? Accrued equity                    999 SM
                                  Error in retrieving calcs data. No data
Contributor Msg Manuals Y     215 found.                                  like 210                                       999 SM

Contributor Msg Manuals Y     240 General calcs error                                                                    999 SM

Contributor Msg Manuals Y     270 Calcs has timed out for this member      usually caused by a calcs error               999 SM

                                                                           Manual payment of any kind has
                                                                           occurred; not tracked through ComSAS;
                                                                           find data & details in Form 18 register FA
Contributor Msg Manuals ?/Y   290 Member exists on form 18 register        should fix - check with Bharma                999 SM
                                                                           Pre-suppression check. No conts paid in
                                                                           year - not really an error message;
                                                                           accrued cont. ? Baseline fix Member
                                                                           account to validate membership before
Contributor Msg Manuals ?/n   300 Total contributions paid is zero         member statement goes out.                    999 SM
                                  Reappointed invalidity pensioner/pip -
Contributor Msg Manuals Y     320 CSS member                               Always manual                                 999 SM
                                  Reappointed invalidity pensioner/pip -
Contributor Msg Manuals Y     321 PSS member                               Always manual                                 999 SM

Contributor Msg Manuals Y     325 CSS reappointed late election            Always manual                                 999 SM
                                  Prior service entry for reappointed
Contributor Msg Manuals Y     340 deferred benefit - CSS member            "125's" reappointed; not correctly linked.    999 SM
                                  Prior service entry for reappointed
Contributor Msg Manuals Y     341 deferred benefit - PSS member            "125's" reappointed; not correctly linked.    999 SM
                                 9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls


                                  Error occurred while calculating PSS     Lt Blue = Calc class: Some 160's have
Contributor Msg Manuals ?/n   160 transfer values                          been fixed                                   999 SM

Contributor Msg Manuals Y     350 Transfer value paid - CSS member                                                      999 SM
                                  Note: not able to calculate post 1990    Pre-suppression check. Interim prod -
Contributor Msg Manuals Y     400 productivity                             member account to follow up;                 999 SM
                                  Reappointed deferred benefit with
Contributor Msg Manuals Y     430 transfer value - CSS member              System doesn't calc tfr values               999 SM
                                  Reappointed deferred benefit with
Contributor Msg Manuals Y     431 transfer value - PSS member              System doesn't calc tfr values               999 SM
                                  Member has previous CSS
                                  membership(s) and has been linked to     Incorrect link; CSS transfer multiple calc
Contributor Msg Manuals Y     445 current PSS record                       to PSS                                       999 SM
                                  Manual calculation required by cms -
Contributor Msg Manuals Y     460 refer to suppression list                "AGS" number group of suppressions           999 SM
                                                                           Ceased conts in no man's land; still get a
                                                                           statement - not yet claimed a benefit; aka
                                                                           "fund reco" ones. Need to get these
                                                                           properly sorted; not automated yet; deals
                                                                           with LWOP date and ceased date -
                                  Member ceased before the end of          caused problems in 2006. Need to check
Contributor Msg Manuals ?/Y   491 financial year                           code.                                        999 SM
                                  Member's status is currently 'pens' or
Contributor Msg Manuals Y     492 'noeq'                                   Thi to investigate                           999 SI
                                  Error setting agency code, agency
Contributor Msg Manuals Y     523 name or paycentre code                   Agency:                                      999 SI

                                                                           Agency: Ros wants this checked. Issue
                                                                           (complaint) from Bruce Foldi about not
                                                                           receiving a statement; had home and
                                                                           agency in there (?!) need to investigate.
                                  Error determining agency address         Should have home address as default.
Contributor Msg Manuals Y     524 contact                                  Review requirements on this.                 999 SI

Contributor Msg Manuals ?/n   540 Error in surcharge details               Should be fixed; need to check.              999 SM
                                  Re-employed qualification found
Contributor Msg Manuals Y     630 against member                           "125's"                                      999 SM
                                  Unclaimed benefit qualification found    May have ceased date but with Cont
Contributor Msg Manuals Y     631 against members                          status. Need to check                        999 SM
                                 9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls


                                  Error occurred while calculating PSS      Lt Blue = Calc class: Some 160's have
Contributor Msg Manuals ?/n   160 transfer values                           been fixed                                   999 SM
                                  CSS transfer value in - basics/supps
Contributor Msg Manuals Y?    640 incorrect                                 May be fixed by baselines; need to check     999 SM
                                                                            Links related.Manually done, may be able
                                  PSS combined membership - refer to        to remove message. Ros to follow with
Contributor Msg Manuals Y     700 file                                      Matthew.                                     999 SM
                                                                            Mainly "pending" but suppression has to
Contributor Msg Manuals Y     701 Stp in problems - refer to file           stay                                         999 SM
                                  CSS member with resignation/ age          may be able to remove the message.
Contributor Msg Manuals Y?    710 lumpsum = zero                            Need to check                                999 SI
                                  PSS member with > 1yr service and         may be able to remove the message.
Contributor Msg Manuals Y?    711 preserved/age lumpsum = zero              Need to check                                999 SI

                                                                              Pre-suppression check. We usually
                                                                              ignore this message and these cases go
                                    Member classification process identified to Member accounts. If preserver need to
Contributor Msg Manuals Y     720   member as a preserved / deferred          change pres to cont; identify and fix      999 SM
                                                                              Pre-suppress. Manually fix contributor
                                    CSS part-timer with b/day 30-jun. Total service. Probably not fixed by baselines.
Contributor Msg Manuals Y     750   contributory service incorrect            Very few of these.                         999 SM
                                                                              Unsure: Taun (?) abnd Patrick said these
                                                                              may be fixed by 30/6 - contingency; best
                                    Cash option. Further manual calculation to have work-around and suppress unless
Contributor Msg Manuals Y     755   needed.                                   ready                                      999 SM
                                    Links 4 case restarted in financial year.
Contributor Msg Manuals Y     760   Check previous age benefits               Multi-envelope                             999 SM
                                    Link 4 pre april 2002 case suppressed -
Contributor Msg Manuals Y     805   waiting to be linked                      Multi-envelope                             999 SM
                                    Transaction summary total and years
Contributor Msg Manuals Y     860   contributions total mismatch              Data prob mismatch                         999 SM
                                    Transaction summary total and years
Contributor Msg Manuals Y     861   productivity total mismatch               Data prob mismatch                         999 SM
                                                                              Pre-suppression check.If dead ie date of
Contributor Msg                                                               death is populated then they are NOT
Suppressed from                     Member has a date of death recorded excluded from the run unless they have
Manuals                 Y     740   on their record                           PENS or No EQ status.                      999 SI
                                  9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls


                                   Error occurred while calculating PSS Lt Blue = Calc class: Some 160's have
Contributor Msg Manuals ?/n    160 transfer values                      been fixed                                         999 SM
                                                                        Pre-suppression. Family Law unit manage
Contributor Msg                                                         printing of these; uses same calc runs;
Suppressed from                                                         printed in separate batch to HPA and
Manuals                Y      780 Family law matters                    some in house                                      999 SI
Warning messages: Ros confirms ARIA are OK with max of 2 warning messages; same as for 2006

                                   Your opening balance is calculated at
Contributor Msg Warning n       50 date eligible of your latest membership Always print as warnings                         20 W
                                   Note: your last birthday salary is not
                                   known. Please contact your personnel
Contributor Msg Warning n      250 area                                    Always print as warnings                         40 W

                                     Note: your contributions are shortpaid.
Contributor Msg Warning n      280   Please contact your personnel area        Always print as warnings                     30 W
                                     Your member component is reported as
                                     zero as no contributions were deducted    Internal message only for ComSuper
Contributor Msg Warning n      302   from                                      staff; get generated in auto run            999 W
                                     Your salary on any payday during this     Internal message only for ComSuper
Contributor Msg Warning n      303   financial year                            staff; get generated in auto run            999 W
                                     Note: your pre 90 productivity is not
                                     known. Please contact your personnel      Internal message only for ComSuper
Contributor Msg Warning n      380   area                                      staff; get generated in auto run            999 W
                                     Transfer value calculations altered       Internal message only for ComSuper
Contributor Msg Warning n      470   during year                               staff; get generated in auto run            999 W
                                     Please note: the above figures include
Contributor Msg Warning n      480   your transfer value equity                Shows on statement                           10 W
                                     Comsuper has processed an exit for
                                     your record since the end of the          Internal message only for ComSuper
Contributor Msg Warning n      500   financial                                 staff; get generated in auto run            999 W
                                     Year. Figures presented here may not      Internal message only for ComSuper
Contributor Msg Warning n      501   represent your final benefit              staff; get generated in auto run            999 W
                                     Contributions for the last several        As above; analyse # and impact if we
                                     paydays of 1998/99 are not recorded in    remove these. May have related to interim
Contributor Msg Warning n      660   your                                      prod and may no longer be relevant          999 W
                                 9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls

                                                                            As above; analyse # and impact if we
                                  Error occurred while calculating PSS      remove these. May have related have
                                                                            Lt Blue = Calc class: Some 160'sto interim
Contributor Msg Manuals ?/n   160 transfer values                           prod fixed
                                                                            been and may no longer be relevant           999 SM

                                  Account. Centrelink expects to provide
Contributor Msg Warning n     661 this information in the next few weeks.                                                999 W
                                  Your employer hasn't provided up to       Internal message; eg missing meployer
                                  date superannuation details. Your         details - no % rate; no super salary, #
Contributor Msg Warning n     662 statement                                 pays etc. Check number of cases.             999 W
                                  Data may not be correct. Refer to the
Contributor Msg Warning n     663 annual report for an explanation.                                                      999 W
                                  Your pack has been sent to this
                                  address as your preferred details are
Contributor Msg Warning n     695 incomplete                                Shows on statement                            50 W
                                  No transactions summary records
Contributor Msg Warning n     850 found for member conts                    Pre-suppression check - to mbr accounts      999 W
                                  No transactions summary records
Contributor Msg Warning n     851 found for productivity                    Pre-suppression check - to mbr accounts      999 W

                                                                            Check numbers of these. Address issue -
                                                                            like catestrophic error on address. Eg 2
                                  Error in retrieving member's address      valid addresses - home plus agency
Preserver Msg Manuals   Y     130 details                                   ticked; can't default to agency if pres      999 SI
                                  A calcs protocol call failed. Check       Shouldn't keep happening; AION related
Preserver Msg Manuals   y     150 additional messages and dispatcher        thing. Check this.                           999 SM
                                  Option used for calculation not available 0's in fields eg age retirement but not
Preserver Msg Manuals   y     160 to member                                 valid, or cont calc for pres. Check this.    999 SM

                                  Calc benefit amount has failed. Check
Preserver Msg Manuals   y     170 member's record and dispatcher                                                         999 SM
                                  Info statements calculation has timed
Preserver Msg Manuals   y     180 out                                       These could still time out                   999 SM
                                                                            = 'super manual'; PLSQL may improve
Preserver Msg Manuals   y     190 Catastrophic error!                       this                                         999 SM
                                  Error in creating transaction summary
Preserver Msg Manuals   y     191 data                                                                                   999 SM
                                                                            Change text to 'Member suppressed by
                                                                            statements team'; same as 460 for conts;
Preserver Msg Manuals   y     200 Member suppressed on request              includes non-migration cases                 999 SM
                                 9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls


                                  Error occurred while calculating PSS   Lt Blue = Calc class: Some 160's have
Contributor Msg Manuals ?/n   160 transfer values                        been fixed                                           999 SM
                                                                         Means manual payment has been made -
                                                                         keep until all Form18 issues no longer
Preserver Msg Manuals   y     240 Member is on cstm's form18 list        relevant                                             999 SM
                                                                         Multiples: CSS deferred are treated
                                                                         differently; supps and basics - non
                                  Member started after 01/07/76 and pres refundable and refundable - refer to prior
Preserver Msg Manuals   y     250 code not 100,120,150,160,161 or 173 service page                                            999 SM
                                  Member started before 01/07/76.
                                  Comsas has no pre76 information        Multiples: Refer to Prior service page;
Preserver Msg Manuals   y     260 recorded                               similar to 250                                       999 SM

                                                                              System one; = "125's"; 2 CSS records
Preserver Msg Manuals   y     280 Reappointed deferred member                 unlinked; warning internal message only         999 SM

                                                                             Done by ComSAS staff; warning internal
                                  Member has a re-employed                   only; early one doesn't print - manually
Preserver Msg Manuals   y     302 qualification                              add info to later one; talk to Cat - flat file   999 SM
                                                                             presuppression calc check to mbr
                                  Member has a unclaimed benefit             accounts; they never claimed their (CSS)
Preserver Msg Manuals   y     304 qualification                              benefit                                          999 SI
                                  Error in determining benefit at exit using calc prob eg ZRR - check numbers of
Preserver Msg Manuals   y     320 interim rate                               these                                            999 SM

Preserver Msg Manuals   y     360 Error in surcharge details                  like the cont message                           999 SM

Preserver Msg Manuals   y     410 Dup/postponed case - refer to file          suppress                                        999 SM
                                                                              old "manbp" group; 99% sure these will
Preserver Msg Manuals   y     420 Post exit tv received                       work in 07                                      999 SM
                                  Member has previous CSS                     Reword to .. Linked incorectly to current
                                  membership(s) and has been linked to        PSS record. If link doesn't work you get
Preserver Msg Manuals   y     445 current PSS record                          this message.                                   999 SM
                                  Error has occurred calculating sis upper
Preserver Msg Manuals   y     450 limit 99                                 suppress                                           999 SM
                                  CSS transfer value in - basic/supps      same as cont/deferred sometimes can be
Preserver Msg Manuals   y     460 incorrect                                basics or supps, eg hardship                       999 SM

Preserver Msg Manuals   y     465 CSS member found with manbp                 = manuals                                       999 SM
                                 9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls


                                  Error occurred while calculating PSS       Lt Blue = Calc class: Some 160's have
Contributor Msg Manuals ?/n   160 transfer values                            been fixed                                    999 SM
                                                                             member ceases, additional cont paid after
Preserver Msg Manuals   y     470 Post exit conts received                   exit - manually added                         999 SM

Preserver Msg Manuals   y     475 Post exit co-conts received                Coming from ATO; like 470                     999 SM
                                  PSS combined membership - refer to         Perhaps remove ? Ros to check with
Preserver Msg Manuals   ??    480 file                                       Matthew C.                                    999 SM

Preserver Msg Manuals   y     490 Stp in problems                            Std termin payment - tfr in prob              999 SM
                                                                             When preserved benefit - some taken
Preserver Msg Manuals   y     500 Partial release                            out, up to SIS                                999 SM

                                                                             Invalidity; partial invalidity pensioner in
Preserver Msg Manuals   y     510 Reappointed invalidity pensioner/pip       PSS; hundred of PIP's - to invalidity team    999 SM
                                  Previous year's statement not found.
Preserver Msg Manuals   y     635 New smt cannot be processed                ie if manual last year keep; check with Thi   999 SM
                                  Negative accrual for member
Preserver Msg Manuals   y     642 contributions. Check all conts fields      pre-suppression check to mbr accounts;        999 SM
                                  Negative accrual for productivity. Check
Preserver Msg Manuals   y     644 all prod fields                            pre-suppression check to mbr accounts;        999 SM
                                  Negative accrual for employer. Check
Preserver Msg Manuals   y     646 all empr fields                            check after 642/644 looked at                 999 SM

                                  Member contributions < $200. Check if
Preserver Msg Manuals   y     652 correct or if member has withdrawn all yellow = balances checks                          999 SM

                                                                           all need to be checked - or we paid
                                  Productivity < $200. Check if correct or interes wrong and recalced, or last pay
Preserver Msg Manuals   y     654 if member has withdrawn all              they joined and only a small amount there       999 SM
                                  Employer < $200. Check if correct or if
Preserver Msg Manuals   y     656 member has withdrawn all                                                                 999 SM

                                  Unfunded prod < $200. Check if correct member account and benefits to look at
Preserver Msg Manuals   y     657 or if member has withdrawn all           these                                           999 SM
                                  Sgc topup < $200. Check if correct or if
Preserver Msg Manuals   y     658 member has withdrawn all                                                                 999 SM

Preserver Msg Manuals   y     660 Final salary incorrect                                                                   999 SM
                                 9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls


                                  Error occurred while calculating PSS       Lt Blue = Calc class: Some 160's have
Contributor Msg Manuals ?/n   160 transfer values                            been fixed                                    999 SM

Preserver Msg Manuals   y     670 Member has no equity left in the fund      safety message                                999 SI
                                  Conts balancing int.accrued =
                                  withdrawal. Check if prev stmt correct
Preserver Msg Manuals   y     672 or links4                                green = links4                                  999 SM
                                                                           previous membership isn't picked up in
                                  Large conts balancing int.accrual.       links record, statement should bring all
Preserver Msg Manuals   y     673 Check if previous stmt correct or links4 equity across                                   999 SM
                                  Prod balancing int.accrued =
                                  withdrawal. Check if prev stmt correct Internals: Thi to talk to Ros about large
Preserver Msg Manuals   y     674 or links4                                conts and interest.                             999 SM

                                  Large prod balancing int.accrual. Check
Preserver Msg Manuals   y     675 if previous stmt correct or links4                                                       999 SM
                                  Empr balancing int.accrued =
                                  withdrawal. Check if prev stmt correct
Preserver Msg Manuals   y     676 or links4                                                                                999 SM

                                  Large empr balancing int.accrual.
Preserver Msg Manuals   y     677 Check if previous stmt correct or links4                                                 999 SM

                                  Record indicates member is entitled to
Preserver Msg Manuals   y     690 sgc. However sgc is currently zero         haven't seen this; check numbers JR           999 SM

                                  Form18 found. Not known whether stp
Preserver Msg Manuals   y     712 paid out. Check all fields of member       Form 18 group                                 999 SM

                                  Form18 found. Not known whether stp
Preserver Msg Manuals   y     714 paid out. Check all fields of productivity Form 18 group                                 999 SM
                                                                             balance check - presuppress to member
Preserver Msg Manuals   y     720 Total member contributions is negative accounts                                          999 SM
                                                                             balance check - presuppress to member
Preserver Msg Manuals   y     722 Total employer component is negative accounts                                            999 SM
                                  On prev stmt member = 0. Check this
                                  stmt is correct and send with apology
Preserver Msg Manuals   ?     730 letter                                     Thi to check to see if code is calling this   999 SM
                                 9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls


                                  Error occurred while calculating PSS         Lt Blue = Calc class: Some 160's have
Contributor Msg Manuals ?/n   160 transfer values                              been fixed                                    999 SM

                                  On prev stmt prod = 0. Check this stmt
Preserver Msg Manuals   ?     731 is correct and send with apology letter Thi to check to see if code is calling this        999 SM

                                  On prev stmt empr = 0. Check this stmt
Preserver Msg Manuals   ?     732 is correct and send with apology letter      Thi to check to see if code is calling this   999 SM
                                  Retrenchment. Unable to determine
                                  original final salary used by benefits       Not seen. Check numbers; may be able
Preserver Msg Manuals   y     750 team.                                        to remove                                     999 SM
                                  Cash option. Further manual calculation
Preserver Msg Manuals   y     755 needed.                                      TBC - baseline likely to fix this             999 SM
                                  CSS xfer mult incorrect. Use last
                                  contributor stmt as guide and project
Preserver Msg Manuals   y     760 forward                                                                                    999 SM

                                  Member initially pres all, then claimed in
Preserver Msg Manuals   y     770 same fin year. Withd component wrong         suppress                                      999 SM
                                  Manbp withdrawal found . Investigate         old "manbp" group; 99% sure these will
Preserver Msg Manuals   y     784 for manual calc                              work in 07                                    999 SM
                                  Auto withdrawal found. Investigate for       old "manbp" group; 99% sure these will
Preserver Msg Manuals   y     786 manual calc                                  work in 07                                    999 SM
                                  Preserved member incorrectly receiving       pre-suppression check - to member
Preserver Msg Manuals   y     812 current contributions                        accounts                                      999 SM
                                  Transaction summary total and years
Preserver Msg Manuals   y     860 contributions total mismatch                                                               999 SM
                                  Transaction summary total and years          Remove; everyone will get this ? Only if
Preserver Msg Manuals         861 productivity total mismatch                  pres this year                                999 SM
                                  Temporary error for retrenchment calcs
Preserver Msg Manuals         865 for 03/04 exit                               JR to check #'s; may not be relevant          999 SM
                                  Temporary error for post 30/11/05
Preserver Msg Manuals   y     866 withdrawals                                  JR to check #'s; may not be relevant          999 SM
Preserver Msg
Suppressed from
Manuals                 y     140 Cannot locate address for member             =lost                                         999 SI
Preserver Msg
Suppressed from                   Member is on cstm's form18 list - no
Manuals                 y     241 equity                                       This was statements team's Form 18            999 SM
                                   9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls


                                    Error occurred while calculating PSS     Lt Blue = Calc class: Some 160's have
Contributor Msg Manuals   ?/n   160 transfer values                          been fixed                                999 SM
Preserver Msg
Suppressed from                                                              pre-suppression check - member benefits
Manuals                   y     270 Member is over 65                        team                                      999 SI
Preserver Msg
Suppressed from                     Member has a date of death recorded      pre-suppression check - member benefits
Manuals                   y     650 on their record                          team                                      999 SI
Preserver Msg
Suppressed from
Manuals                   y     780 Family law matters                       FLU do these                              999 SI
                                    Please note: the above figures include
Preserver Msg Warning     n      10 your transfer value equity               printable                                  20 W
                                    Super guarantee payment made during
Preserver Msg Warning     n      50 the financial year                       printable                                  30 W
                                    You are also entitled to a preserved
Preserver Msg Warning     n     310 superannuation guarantee amount          printable                                  10 W
                                    Your pack has been sent to this
                                    address as your preferred details are
Preserver Msg Warning     n     600 incomplete                               addresses                                  40 W
                                    No transactions summary records          pre-suppress check - member reporting
Preserver Msg Warning     n     850 found for member conts                   team (Ros); ? Remove                      999 W
                                    No transactions summary records          pre-suppress check - member reporting
Preserver Msg Warning     n     851 found for productivity                   team (Ros); ? Remove                      999 W
                                                                              9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls                                                                              Page 11 of 79




         MS                                                                                                                          Total                                                    # in                                        MS EQ
MSG_SCHE G_I                                                                                                                         Effort # x                                               dummy           # in May                    G_P UIT
ME       D   Msg_text                                 Comments                         Time     Difficulty     Action @ 20/6         time             Excel Spread   Comment                  15/6/07         Dummy          # in 2006    RIO Y_A

                                                                                                                                                                     May need some further
                                                                                                                                                                     investigation through
Preserver          Preserved member incorrectly       pre-suppression check - to                                                                                     member accounts or
Msg Manuals    812 receiving current contributions    member accounts                     0.1                1 AGS to MRT/MA                 0.1 no                  may be correct.                    189        189              534 999 Y

                                                      Pre-suppression check. No
                                                      conts paid in year - not
                                                      really an error message;
                                                      accrued cont. ? Baseline fix                                                                                   May need some further
                                                      Member account to validate                                                                                     investigation through
Contributor                                           membership before member                                                                                       member accounts or
Msg Manuals    300 Total contributions paid is zero   statement goes out.                 0.1                1 AGS to MRT/MA                 0.1 no                  may be correct.                    13          97              266 999 Y

Preserver
Msg
Suppressed                                            pre-suppression check -                                                                                        Must go to benefits to
from Manuals   270 Member is over 65                  member benefits team                0.1                1 AGS to MRT/MB                 0.1 no                  organise payment                   300        300              228 999 Y

                                                      Pre-suppression check. We
                                                      usually ignore this message
                                                      and these cases go to
                   Member classification process      Member accounts. If                                                                                            Needs some further
Contributor        identified member as a             preserver need to change                                 Zero numbers;                                         investigation through
Msg Manuals    720 preserved / deferred               pres to cont; identify and fix      0.1                1 monitor next run              0.1 no                  member accounts                                     0           63 999 Y

                                                                                                                                                                     May need some further
                   Negative accrual for member                                                                                                                       investigation through
Preserver          contributions. Check all conts     pre-suppression check to                                 IT to check then to                                   member accounts or
Msg Manuals    642 fields                             mbr accounts;                       0.1                1 MRT/MA                        0.1 no                  may be correct.                    263        236               27 999 Y

                                                                                                                                                                     May need some further
                   Negative accrual for                                                                                                                              investigation through
Preserver          productivity. Check all prod       pre-suppression check to                                 IT to check then to                                   member accounts or
Msg Manuals    644 fields                             mbr accounts;                       0.1                1 MRT/MA                        0.1 no                  may be correct.                    286         63               10 999 Y
                                                      Pre-suppression check.
Contributor        Note: not able to calculate post   Interim prod - member                                    Zero numbers;
Msg Manuals    400 1990 productivity                  account to follow up;                                    monitor next run                   0                  ags # needed                                        0               9 999 Y

                                                                                                                                                                     May need some further
                                                      balance check -                                                                                                investigation through
Preserver          Total employer component is        presuppress to member                                    Zero numbers;                                         member accounts or
Msg Manuals    722 negative                           accounts                            0.1                1 monitor next run              0.1 no                  may be correct.                                     8               9 999 Y
                                                      balance check -
Preserver          Total member contributions is      presuppress to member                                    IT to check then to                                   Is this the same as
Msg Manuals    720 negative                           accounts                                                 MRT/MA                             0                  642?                                4               3               2 999 Y
                                                                             9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls                                                                           Page 12 of 79




         MS                                                                                                                      Total                                                    # in                                           MS EQ
MSG_SCHE G_I                                                                                                                     Effort # x                                               dummy           # in May                       G_P UIT
ME       D   Msg_text                               Comments                        Time     Difficulty     Action @ 20/6        time             Excel Spread   Comment                  15/6/07         Dummy          # in 2006       RIO Y_A
                                                                                                            Zero numbers;
                  A calcs protocol call failed.   Shouldn't keep happening;                                 monitor next run;
Preserver         Check additional messages and AION related thing. Check                                   not using AION
Msg Manuals   150 dispatcher                      this.                                                     code                              0                                                                197            1158 999 Y
                                                  0's in fields eg age
                                                  retirement but not valid, or                              IT to check from
Preserver         Option used for calculation not cont calc for pres. Check                                 next dummy run;
Msg Manuals   160 available to member             this.                                                     then to MRT/MA                    0                  ags # needed                       531        119              866 999 Y

Contributor       CSS member with resignation/      may be able to remove the
Msg Manuals   710 age lumpsum = zero                message. Need to check                                  AGS to MRT/MA                     0                  ags # needed                       40          42              381         Y

                                                                                                            PRIORITY 2: IT to
                  Previous year's statement not                                                             check why this is                                    ags # needed,
Preserver         found. New smt cannot be          ie if manual last year keep;                            zero; done 21/7 by                                   depends if you can run
Msg Manuals   635 processed                         check with IT                                           Thi - removed                     0                  calcs in QWB                                   61              145 999 Y
                                                    May have ceased date but
Contributor       Unclaimed benefit qualification   with Cont status. Need to
Msg Manuals   631 found against members             check - PRESU                                           AGS to MRT/MA                     0                  Like pres 304                       9          11               54         Y

                                                    Manual payment of any kind
                                                    has occurred; not tracked
                                                    through ComSAS; find data
                                                    & details in Form 18 register
                                                    FA should fix - check with                                                               TV in Calc, CPI
                                                    Bharma                                                                                   Calc, Int Accum,
Contributor       Member exists on form 18          Move to Data - Form 18                                                                   due and paid     Depends if earlier
Msg Manuals   290 register                          later when more info known         0.3                3 AGS to MRT/MA                0.9 calc,            calcs have been done.                  8               8           48 999 Y
                  Retrenchment. Unable to
Preserver         determine original final salary   Not seen. Check numbers;                                Zero numbers;                    TV in Calc, CPI Baseline may have
Msg Manuals   750 used by benefits team.            may be able to remove              0.2                2 monitor next run             0.4 Calc, Int Accum fixed?                                             12               23         Y
                                                    Links related.Manually
                                                    done, may be able to                                                                     Comsas, cpi
Contributor       PSS combined membership -         remove message. Ros to                                                                   calc, 10 yr rule
Msg Manuals   700 refer to file                     follow with Matthew.               0.4                2 AGS to MRT/MA                0.8 calc                ags # needed                        5               5           16 999 Y
                  Prod balancing int.accrued =      Internals: IT to talk to Ros
Preserver         withdrawal. Check if prev stmt    about large conts and                                   Zero numbers;
Msg Manuals   674 correct or links4                 interest.                                               monitor next run                  0                  ags # needed                                   23                   9      Y

Preserver         PSS combined membership -         Perhaps remove ? Ros to
Msg Manuals   480 refer to file                     check with Matthew C.                                   AGS to MRT/MA                     0                                                      1               1               2 999 Y

Preserver         Error in determining benefit at   calc prob eg ZRR - check                                Zero numbers;
Msg Manuals   320 exit using interim rate           numbers of these                                        monitor next run                  0                                                                      0               1 999 Y
                                                                        9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls                                                                        Page 13 of 79




         MS                                                                                                               Total                                                   # in                                        MS EQ
MSG_SCHE G_I                                                                                                              Effort # x                                              dummy           # in May                    G_P UIT
ME       D   Msg_text                           Comments                       Time     Difficulty    Action @ 20/6       time             Excel Spread   Comment                 15/6/07         Dummy          # in 2006    RIO Y_A

                                                Unsure: Taun (?) abnd
                                                Patrick said these may be
                                                fixed by 30/6 - contingency;                           PRIORITY 1: code
Contributor       Cash option. Further manual   best to have work-around                               has not been
Msg Manuals   755 calculation needed.           and suppress unless ready         0.3                1 released yet               0.3 cash option calc                                      461        461 ?                   999 Y
                                                                                                       PRIORITY 1: code
Preserver         Cash option. Further manual   TBC - baseline likely to fix                           has not been
Msg Manuals   755 calculation needed.           this                              0.3                1 released yet               0.3 cash option calc                                      597        597            1839        Y

Preserver                                       old "manbp" group; 99%                                                                tv in calc, int QWB should calc right
Msg Manuals   420 Post exit tv received         sure these will work in 07        0.1                1 AGS to MRT/MA              0.1 accum, comsas if s'ment doesn't                       21          21            1056 999 Y
                                                member ceases, additional
                                                cont paid after exit -
                                                manually added. 90%
Preserver                                       SURE WILL WORK WITH                                                                                       QWB should calc right
Msg Manuals   470 Post exit conts received      NEW CODE                          0.1                1 AGS to MRT/MA              0.1 Comsas              if s'ment doesn't                  1               1          759 999 Y

Preserver                                       Coming from ATO; like 470;                            Zero numbers;
Msg Manuals   475 Post exit co-conts received   90% LIKELY TO BE FIXED                                monitor next run                 0                                                                     0               0 999 Y
                                                                             9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls                                                                           Page 14 of 79




         MS                                                                                                                         Total                                                 # in                                        MS EQ
MSG_SCHE G_I                                                                                                                        Effort # x                                            dummy           # in May                    G_P UIT
ME       D   Msg_text                               Comments                         Time       Difficulty     Action @ 20/6        time             Excel Spread    Comment              15/6/07         Dummy          # in 2006    RIO Y_A

                                                    like 210; most clearly
                                                    identified msg number for
                                                    PLSQL errors; if no results                                PRIORITY 1: must
                                                    from calcs happens proves                                  discuss with Chris                  ComSAS, due
Contributor       Error in retrieving calcs data.   it can't be retrieved and                                  T/Barmha and get                    and paid, 10 yr
Msg Manuals   215 No data found.                    calcs pkg invalid code                  1                4 AGS # to MRT                      4 rule calc         QWB may work                   589        482                   5 999 Y


                                                    OK, removed message,                                       PRIORITY 1: must
                                                    calcs fine                                                 discuss with Chris
Contributor       Option used for calculation is    Need dummy run on SQL to                                   T/Barmha and get
Msg Manuals   200 not available to member           confirm fix after testing                                  AGS # to MRT                      0                   ags # needed                   359        725            2,803       Y
                  Error occurred while
Contributor       calculating PSS transfer                                                                     Zero numbers;
Msg Manuals   160 values                            Some 160's have been fixed                                 monitor next run                  0 TV in calc        ags # needed                                    0          959 999 Y
                                                    may mean no date on trans
                                                    summ (mismatch) ?
                                                    Accrued equity. Full dummy
                                                    run on PLSQL needed to
Contributor       Error in creating transaction     confirm validity of ITs. IT to                             Zero numbers;
Msg Manuals   211 summary data                      check.                                                     monitor next run                  0                   Copy and paste job                              0          381 999 Y

                                                    Invalidity; partial invalidity                                                              TV in calc, int
Preserver         Reappointed invalidity            pensioner in PSS; hundred                                                                   accum, cpi calc,
Msg Manuals   510 pensioner/pip                     of PIP's - to invalidity team       0.4                  4 AGS to MRT/MA                1.6 comsas                                               5               5          168 999 Y
                                                                                                                                                Comsas, due
                  Calc benefit amount has failed.                                                                                               and paid, 10 yr
Preserver         Check member's record and                                                                    Zero numbers;                    rule calc, cpi
Msg Manuals   170 dispatcher                                                            0.4                  4 monitor next run             1.6 calc, int accum                                                      0           88 999 Y
                                                                                                                                                Comsas, due
                                                    calcs errors have 0 in fields                                                               and paid, 10 yr
Contributor       Information statement             eg joine wrong scheme; no                                  Zero numbers;                    rule calc, cpi
Msg Manuals   210 calculation error                 eq; date issue                      0.4                  4 monitor next run             1.6 calc, int accum                                                      0               9 999 Y

Preserver                                           When preserved benefit -                                                                    comsas, int
Msg Manuals   500 Partial release                   some taken out, up to SIS               1                5 AGS to MRT/MA                  5 accum, cpi calc                                      2               2               7 999 Y
                                                                                                                                                Comsas, due
                                                                                                                                                and paid, 10 yr
Preserver         Info statements calculation has   These could still time out;                                Zero numbers;                    rule calc, cpi
Msg Manuals   180 timed out                         AION DS based.                      0.4                  4 monitor next run             1.6 calc, int accum                                                      2               6 999 Y
                                                                          9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls                                                                             Page 15 of 79




         MS                                                                                                                      Total                                                       # in                                   MS    EQ
MSG_SCHE G_I                                                                                                                     Effort # x                                                  dummy           # in May               G_P   UIT
ME       D   Msg_text                               Comments                      Time       Difficulty     Action @ 20/6        time             Excel Spread       Comment                 15/6/07         Dummy       # in 2006 RIO    Y_A
MANUALS                                                                                                                                       0                                                                                   5 999   Y
                                                                                                                                                  TV in calc, int
Contributor       Reappointed invalidity                                                                                                          accum, cpi calc,
Msg Manuals   320 pensioner/pip - CSS member        Always manual                    0.4                  4 AGS to MRT/MA                1.6      comsas                                               18          18           37 999 Y
                                                                                                                                                  TV in calc, int
Contributor       Reappointed invalidity                                                                                                          accum, cpi calc,
Msg Manuals   321 pensioner/pip - PSS member        Always manual                    0.4                  4 AGS to MRT/MA                1.6      comsas                                               11          11           26 999 Y
                                                                                                                                                  comsas, int
Contributor                                                                                                                                       accum, TV in
Msg Manuals   325 CSS reappointed late election     Always manual                    0.3                  3 AGS to MRT/MA                0.9      calc                                                 21          21           37 999 Y
                                                                                                                                                  Comsas, due        Varies from simple to
                                                                                                            AGS to MRT/MA;                        and paid, 10 yr    very hard. Some due
Contributor       Manual calculation required by    "AGS" number group of                                   should match                          rule calc, cpi     to online suppression
Msg Manuals   460 cms - refer to suppression list   suppressions                         1                5 MRT's list                        5   calc, int accum    requests by member                137        132          230 999 Y

Contributor       CSS transfer value in -      May be fixed by baselines;
Msg Manuals   640 basics/supps incorrect       need to check                         0.3                  3 AGS to MRT/MA                0.9 TV in Calc                                                26          26            4 999 Y
                                               = 'super manual'; PLSQL                                                                       Comsas, due
                                               may improve this; AION                                                                        and paid, 10 yr
Preserver                                      based code - PLSQ!L                                          Zero numbers;                    rule calc, cpi          Varies from simple to
Msg Manuals   190 Catastrophic error!          impact needs checking                     1                5 monitor next run               5 calc, int accum         very hard.                                   200         1176 999 Y
                                               Change text to 'Member
                                               suppressed by statements                                                                         Comsas, due
                                               team'; same as 460 for                                       AGS to MRT/MA;                      and paid, 10 yr
Preserver                                      conts; includes non-                                         should match                        rule calc, cpi       Varies from simple to
Msg Manuals   200 Member suppressed on request migration cases                           1                5 MRT's list                        5 calc, int accum      very hard.                        479        460          601 999 Y
                                               Done by ComSAS staff;
                                               warning internal only; early
                                               one doesn't print - manually
Preserver         Member has a re-employed     add info to later one; talk to
Msg Manuals   302 qualification                Cat - flat file                                              AGS to MRT/MA                     0                      were pres, now cont               479        482          866        Y

Preserver                                                                                                                                    ComSAS, TV in
Msg Manuals   465 CSS member found with manbp = manuals                              0.3                  3 AGS to MRT/MA                0.9 Calc, Int Accum                                           26          26           32 999 Y

                                                                                                                                                                     May need some further
                                                                                                                                                                     investigation through
Preserver         Negative accrual for employer.    check after 642/644 looked                              IT to look @ this;                                       member accounts or
Msg Manuals   646 Check all empr fields             at                               0.1                  1 priority 2-3                 0.1 no                      may be correct.                              224           11 999 Y

Contributor                                                                                                 Zero numbers;
Msg Manuals   240 General calcs error                                                                       monitor next run                  0                                                                         0?           999 Y

                                                    usually caused by a calcs
                                                    error; do dummy run and
Contributor       Calcs has timed out for this      check for this; may be able                             Zero numbers;
Msg Manuals   270 member                            to remove - AION DS based                               monitor next run                  0                                                                         0?           999 Y
                  Member initially pres all, then
Preserver         claimed in same fin year. Withd                                                           Zero numbers;
Msg Manuals   770 component wrong                 suppress                                                  monitor next run                  0                                                                         0?           999 Y
                                                                            9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls                                                                           Page 16 of 79




         MS                                                                                                                     Total                                                    # in                                        MS EQ
MSG_SCHE G_I                                                                                                                    Effort # x                                               dummy           # in May                    G_P UIT
ME       D   Msg_text                                Comments                      Time       Difficulty    Action @ 20/6       time        Excel Spread         Comment                 15/6/07         Dummy          # in 2006    RIO Y_A
                                                                                                                                            TV in Calc, CPI
                                                                                                                                            Calc, Int Accum,     Depends if earlier
Preserver                                                                                                                                   due and paid         calcs have been done.
Msg Manuals    240 Member is on cstm's form18 list                                    0.3                  3 AGS to MRT/MA              0.9 calc,                Like other form 18's              347        347              408 999 Y

                                                     Multiples: CSS deferred are
                                                     treated differently; supps
                   Member started after 01/07/76     and basics - non refundable                                                               TV in calc, Int   Calcs have generally
Preserver          and pres code not                 and refundable - refer to                                                                 accum,            already been done
Msg Manuals    250 100,120,150,160,161 or 173        prior service page                   1                5 AGS to MRT/MA                   5 ComSAS            saved in trim.                    149        149              226 999 Y

Contributor                                        Mainly "pending" but                                                                     ComSAS, TV in
Msg Manuals    701 Stp in problems - refer to file suppression has to stay            0.3                  4 AGS to MRT/MA              1.2 Calc, Int Accum                                        14          14               31 999 Y
                   Member started before                                                                                                    TV in calc, Int Calcs have generally
Preserver          01/07/76. Comsas has no pre76 Multiples: Refer to Prior                                                                  accum,          already been done
Msg Manuals    260 information recorded            service page; similar to 250           1                5 AGS to MRT/MA                5 ComSAS          saved in trim.                         19          20               27 999 Y

Preserver                                                                                                                                   TV in Calc, CPI
Msg                                                                                                                                         Calc, Int Accum, Depends if earlier
Suppressed         Member is on cstm's form18 list - This was statements team's                                                             due and paid     calcs have been done.
from Manuals   241 no equity                         Form 18                          0.3                  3 AGS to MRT/MA              0.9 calc,            Like other form 18's                   9               9           19 999 Y
                   Form18 found. Not known
Preserver          whether stp paid out. Check all                                                          Zero numbers;
Msg Manuals    712 fields of member                  Form 18 group                                          monitor next run                 0                                                                      0               0 999 Y
                   Form18 found. Not known
Preserver          whether stp paid out. Check all                                                          Zero numbers;
Msg Manuals    714 fields of productivity            Form 18 group                                          monitor next run                 0                                                                      0               0 999 Y
                   Prior service entry for
Contributor        reappointed deferred benefit -    "125's" reappointed; not                                                               ComSAS, TV in
Msg Manuals    340 CSS member                        correctly linked.                0.3                  3 AGS to MRT/MA              0.9 Calc, Int Accum                                        104        105              496 999 Y
                                                                                                             AGS to MRT/MA -
Preserver                                            System one; = "125's"; 2                                Teresa to look @               ComSAS, TV in
Msg Manuals    280 Reappointed deferred member       CSS records unlinked             0.3                  3 these then Cat             0.9 Calc, Int Accum                                        74          74              140 999 Y
                                                                                                                                                            There should be a
                   Prior service entry for                                                                                                                  correct calc of the CSS
Contributor        reappointed deferred benefit -    "125's" reappointed; not                                                               ComSAS, TV in TV multi but not
Msg Manuals    341 PSS member                        correctly linked.                0.4                  4 AGS to MRT/MA              1.6 Calc, Int Accum always.                                36          36               78 999 Y

Contributor        Re-employed qualification found                                                                                          ComSAS, TV in
Msg Manuals    630 against member                  "125's"                            0.3                  3 AGS to MRT/MA              0.9 Calc, Int Accum                                         3               5           31 999 Y
                                                                                9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls                                                                                  Page 17 of 79




         MS                                                                                                                           Total                                                        # in                                         MS EQ
MSG_SCHE G_I                                                                                                                          Effort # x                                                   dummy            # in May                    G_P UIT
ME       D   Msg_text                                 Comments                        Time       Difficulty     Action @ 20/6         time             Excel Spread      Comment                   15/6/07          Dummy          # in 2006    RIO Y_A

                                                                                                                                                     TV in calc, Int     Calcs have generally
Contributor       Transfer value paid - CSS                                                                                                          accum,              already been done
Msg Manuals   350 member                                                                     1                5 P2                                 5 ComSAS              saved in trim. Like 250             154         154              373 999 Y

                  Reappointed deferred benefit                                                                                                                    Calcs have generally
                                                                                                                                                     TV in calc, Int
Contributor       with transfer value - CSS           System doesn't calc tfr                                                                        accum,       already been done
Msg Manuals   430 member                              values                                 1                5 P2                                 5 ComSAS       saved in trim. Like 250                    51           51              132 999 Y
                                                                                                                                                                  There should be a
                  CSS xfer mult incorrect. Use                                                                                                                    correct calc of the CSS
Preserver         last contributor stmt as guide                                                                                                  ComSAS, TV in TV multi but not
Msg Manuals   760 and project forward                                                     0.4                 4 P2 -                          1.6 Calc, Int Accum always.                                    91           91               95 999 Y
                                                                                                                P2: IT to look @
                                                                                                                autoproject issue
                  Member has previous CSS             Reword to include                                         as well eg 760;
                  membership(s) and has been          "incorrectly" Incorrect link;                             autoprojection                         TV in calc, Int
Contributor       linked incorrectly to current PSS   CSS transfer multiple calc                                should fix a lot of                    accum,
Msg Manuals   445 record                              to PSS                                 1                5 issues                             5   ComSAS                                                             22               54 999 Y
                                                      same as cont/deferred                                                                            TV in calc, Int
Preserver         CSS transfer value in -             sometimes can be basics or                                                                       accum,
Msg Manuals   460 basic/supps incorrect               supps, eg hardship                     1                5 P2                                 5   ComSAS                                                11           11               13 999 Y
                  Reappointed deferred benefit                                                                                                         TV in calc, Int
Contributor       with transfer value - PSS           System doesn't calc tfr                                                                          accum,
Msg Manuals   431 member                              values                                 1                5 P2                                 5   ComSAS                                                   3              3               8 999 Y
                                                                                                                                                       TV in calc, Int
Preserver                                             Std termin payment - tfr in                                                                      accum,
Msg Manuals   490 Stp in problems                     prob                                0.3                 3 P2                            0.9      ComSAS                                                   3              3                 999 Y

Preserver         Error in creating transaction                                                                 Turn on for next                                                                   Was
Msg Manuals   191 summary data                                                                                  dummy run                          0                     Copy and paste job        turned off                  0               6 999 Y
                                                                          9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls                                                                  Page 18 of 79




         MS                                                                                                              Total                                                 # in                                       MS EQ
MSG_SCHE G_I                                                                                                             Effort # x                                            dummy          # in May                    G_P UIT
ME       D   Msg_text                              Comments                     Time      Difficulty    Action @ 20/6    time             Excel Spread   Comment               15/6/07        Dummy          # in 2006    RIO Y_A

Preserver                                                                                                                                                Member accounts
Msg Manuals   660 Final salary incorrect                                            0.2                1 AGS to MRT/MA           0.2 ComSAS              need to investigate             2               2               3 999 Y
                                                   previous membership isn't
                  Large conts balancing            picked up in links record,
Preserver         int.accrual. Check if previous   statement should bring all
Msg Manuals   673 stmt correct or links4           equity across                                        AGS to MRT/MA                 0                  ags # needed                    15        458               43 999 Y
                  Large prod balancing
Preserver         int.accrual. Check if previous
Msg Manuals   675 stmt correct or links4                                                                AGS to MRT/MA                                    ags # needed                    84         80               28 999 Y
                                                                         9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls                                                       Page 19 of 79




            MS                                                                                                         Total                                       # in                                       MS EQ
MSG_SCHE G_I                                                                                                           Effort # x                                  dummy          # in May                    G_P UIT
ME          D   Msg_text                         Comments                        Time   Difficulty   Action @ 20/6     time         Excel Spread    Comment        15/6/07        Dummy          # in 2006    RIO Y_A
                Large empr balancing
Preserver       int.accrual. Check if previous
Msg Manuals 677 stmt correct or links4                                                               AGS to MRT/MA                                  ags # needed                             7           26 999 Y
                Conts balancing int.accrued =
Preserver       withdrawal. Check if prev stmt
Msg Manuals 672 correct or links4                green = links4                                      AGS to MRT/MA                                  ags # needed                             7           17 999 Y
                Empr balancing int.accrued =
Preserver       withdrawal. Check if prev stmt
Msg Manuals 676 correct or links4                                                                    AGS to MRT/MA                                  ags # needed                        15                   3 999 Y
                                                 Reword to .. Linked
                    Member has previous CSS      incorectly to current PSS
Preserver           membership(s) and has been   record. If link doesn't work
Msg Manuals   445   linked to current PSS record you get this message.                               AGS to MRT/MA                                                           22              0               0 999 Y
                    CEASED CONTRIBUTOR
                    WITH OPEN LWOP TO
                    COUNT AS SERVICE.
                    SHOULD BE DONE
Cont          505   MANUALLY                     COMSAS                          N      SI                                                                                   9                                    Y
                    A MANUAL BENEFIT
                    PAYMENT HAS BEEN
                    PROCESSED FOR THIS
Cont          730   MEMBER                                                 999          SI                                                                                   1                                    Y
                    LINK 4 CASE SUPPRESSED -
Cont          806   WAITING TO BE LINKED                                   999 Y        SM                                                                              2,415                                     Y
       9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls   Page 20 of 79




 MSG
 _TY
 PE




? SM




 SM




 SI




 SM




 SM




 SM


 SM




 SM


 SM
      9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls   Page 21 of 79




MSG
_TY
PE



SM




SM


SI




SM


SM




SM


SM




SM



SM


SM


SM
      9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls   Page 22 of 79




MSG
_TY
PE




SM


SM


SM




SM


SM
      9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls   Page 23 of 79




MSG
_TY
PE




SM




SM



SM




SM



SM



SM



SM


SM



SM
      9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls   Page 24 of 79




MSG
_TY
PE
SM


SM


SM


SM




SM


SM




SM




SM




SM


SM




SM


SM




SM


SM
      9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls   Page 25 of 79




MSG
_TY
PE



SM




SM


SM


SM




SM


SM


SM


SM


SM



SM


SM
      9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls   Page 26 of 79




MSG
_TY
PE



SM



SM



SM




SM


SM


SM


SM


SM
      9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls   Page 27 of 79




MSG
_TY
PE


SM




SM


SM
      9/29/2011D:\Docstoc\Working\pdf\4f6d287b-d7da-43a0-8826-f8aae927f017.xls   Page 28 of 79




MSG
_TY
PE


SM


SM


SM




SM




SI



SM

SM
Type                      Code Current Text Message

Preserver Msg Manuals       200 Member suppressed on request
                                Manual calculation required by cms - refer to
Contributor Msg Manuals     460 suppression list

                                Member has previous CSS membership(s)
Contributor Msg Manuals     445 and has been linked to current PSS record
Text mesasge to change to:

Member suppressed by statements team

Member suppressed by statements team

Member has previous CSS membership(s) and has
been linked incorrectly to current PSS record
                      672 CONTS BALANCING INT.ACCRUED = WITHDRAWAL. CHECK IF PREV STMT CORRECT OR
means:       Accrued Conts Interest = Conts Withdrawn
            and Accrued Conts Interest is diff to 0

                         673 LARGE CONTS BALANCING INT.ACCRUAL. CHECK IF PREVIOUS STMT CORRECT OR LINK

Accured Conts Interest is greater than 7000
(I have no ideas who has set-up this limit and why)
AGSs: 02787441,71620143,53723894,54324289,77467856

                         675 LARGE PROD BALANCING INT.ACCRUAL. CHECK IF PREVIOUS STMT CORRECT OR LINK

Accured Productivity Interest is greater than 7000
AGSs: 54547052, 73070720, 50737967, 71905763


28/01/1900 4:00:00 AM         EMPR BALANCING INT.ACCRUED = WITHDRAWAL. CHECK IF PREV STMT CORRECT OR L

Accrued Employer Interest = Employer Withdrawn
and Accrued Employer Interest is diff to 0


28/01/1900 5:00:00 AM         LARGE EMPR BALANCING INT.ACCRUAL. CHECK IF PREVIOUS STMT CORRECT OR LINK

Accured Employer Interest is greater than 15000
AGSs: 02906973, 31361968, 53961526, 60854040

>Also, could we see numbers for cases that had message 805 in 2006?

I think last year we striped off the message.

cheers

Thi
F PREV STMT CORRECT OR LINKS4



US STMT CORRECT OR LINKS4




S STMT CORRECT OR LINKS4




PREV STMT CORRECT OR LINKS4




S STMT CORRECT OR LINKS4
       PD_EXCLUDE. TYPE                IS_EXCLUDE. TYPE
Code   Preserver - description         Contributor - description
A      MANUAL CALCULATION REQUIRED BY PARTIAL RELEASE
       CMS - REFER TO SUPPRESSION LIST

B      CSS TRANSFER VALUE IN -            EQUITY COMPONENT HASNT BEEN
       BASICS/SUPPS INCORRECT             RECORDED AS PAID DUE TO
                                          FEEDBACK PROBLEMS
C      REAPPOINTED INVALIDITY             --
       PENSIONER/PIP
D      DUP/POSTPONED CASE - REFER TO      FINAL SALARY INCORRECT
       FILE
E      --                                POST EXIT TV RECEIVED
F      --                                LINK 4 CASE SUPPRESSED -
                                         WAITING TO BE LINKED
H      FAMILY LAW MATTERS                FAMILY LAW MATTERS
I      --                                REAPPOINTED INVALIDITY
                                         PENSIONER/PIP
K      --                                PSS COMBINED MEMBERSHIP -
                                         REFER TO FILE
M      PSS COMBINED MEMBERSHIP - REFER MEMBER SUPPRESSED ON
       TO FILE                           REQUEST
N      CSS REAPPOINTED LATE ELECTION     PRESERVED MEMBER
                                         INCORRECTLY RECEIVING
                                         CURRENT CONTRIBUTIONS
O      LINK 4 CASE SUPPRESSED - WAITING POST EXIT CONTS RECEIVED
       TO BE LINKED
P      LINK 4 CONCURRENT POST APRIL 2002 PARTIAL PRODUCTIVITY RELEASE -
       CASE SUPPRESSED - WAITING TO BE REFER TO FILE
       LINKED
Q      NEGATIVE DIFFERENCE BETWEEN
       THIS YEAR AND LAST YEARS TV IN
       AMOUNTS
R      LINK 4 PRE APRIL 2002 CASE
       SUPPRESSED - WAITING TO BE
       LINKED
S      CSS MEMBER WITH RESIGNATION/      STP IN PROBLEMS
       AGE LUMPSUM = ZERO
U      --                                ERROR HAS OCCURED DURING THE
                                         MANUAL CALCULATION OF THE PSS
                                         BENEFIT
V      --                                CSS TRANSFER VALUE IN -
                                         BASIC/SUPPS INCORRECT
W      --                                PARTIAL WITHDRAWAL MADE -
                                         MANUAL CALCULATION REQUIRED

X      --                                 , PSS RETRENCHMENT EXIT AFTER
                                          1/7/99)
Z      CSS SUBS TO PSS CONT - LINK 3 TO
       LINK 8, 5, 11)
Calc Status   Description


              Complete


              Exclude

              Incomplete

              Cancelled




Calc Method   Description


              Batch          (=normal method)


              Manual         (=done by hand)

              ?Autotracker   (some other method)
select * from pd_msg_codes

to get full list of message codes; use is_msg_codes for conts and PD_ for pres
                           Exclu
                           de      MSG_I
MSG_SCHEME                 Code    D     Msg_text
PRE-SUPPRESSION CHECK



                                         Preserved member incorrectly
Preserver Msg Manuals                812 receiving current contributions


Contributor Msg
Suppressed from Manuals    H         780 Family law matters




Contributor Msg Manuals              300 Total contributions paid is zero

Preserver Msg Suppressed
from Manuals                         270 Member is over 65


Contributor Msg                          Member has a date of death
Suppressed from Manuals              740 recorded on their record


                                         Member has a unclaimed benefit
Preserver Msg Manuals                304 qualification


                                         Member classification process
                                         identified member as a preserved /
Contributor Msg Manuals              720 deferred

Preserver Msg Suppressed                 Member has a date of death
from Manuals                         650 recorded on their record


                                         Negative accrual for member
                                         contributions. Check all conts
Preserver Msg Manuals                642 fields
                              Negative accrual for productivity.
Preserver Msg Manuals     644 Check all prod fields
                              Note: not able to calculate post
Contributor Msg Manuals   400 1990 productivity

                              CSS part-timer with b/day 30-jun.
Contributor Msg Manuals   750 Total contributory service incorrect



                              Total employer component is
Preserver Msg Manuals     722 negative
                              Total member contributions is
Preserver Msg Manuals     720 negative



                              No transactions summary records
Contributor Msg Warning   850 found for member conts



                              No transactions summary records
Contributor Msg Warning   851 found for productivity



                              No transactions summary records
Preserver Msg Warning     850 found for member conts



                              No transactions summary records
Preserver Msg Warning     851 found for productivity
TO BE CHECKED
                                  Member ceased before the end of
Contributor Msg Manuals       491 financial year
                                  Member's status is currently 'pens'
Contributor Msg Manuals       492 or 'noeq'
                                  A calcs protocol call failed. Check
                                  additional messages and
Preserver Msg Manuals         150 dispatcher

                                    Member has a re-employed
Preserver Msg Manuals         302   qualification
                                    Option used for calculation not
Preserver Msg Manuals         160   available to member
                                    CSS member with resignation/ age
Contributor Msg Manuals       710   lumpsum = zero
                                    Transaction summary total and
Preserver Msg Manuals         861   years productivity total mismatch
                                    On prev stmt member = 0. Check
                                    this stmt is correct and send with
Preserver Msg Manuals         730   apology letter
                                    Previous year's statement not
                                    found. New smt cannot be
Preserver Msg Manuals         635   processed
                                    CSS transfer value in -
Contributor Msg Manuals   B   640   basics/supps incorrect
                                    On prev stmt prod = 0. Check this
                                    stmt is correct and send with
Preserver Msg Manuals         731   apology letter
                                    Unclaimed benefit qualification
Contributor Msg Manuals       631   found against members




Contributor Msg Manuals       290 Member exists on form 18 register
                                  Retrenchment. Unable to
                                  determine original final salary used
Preserver Msg Manuals         750 by benefits team.
                                     PSS combined membership - refer
Contributor Msg Manuals   M    700   to file
                                     On prev stmt empr = 0. Check this
                                     stmt is correct and send with
Preserver Msg Manuals          732   apology letter
                                     Prod balancing int.accrued =
                                     withdrawal. Check if prev stmt
Preserver Msg Manuals          674   correct or links4
                                     PSS member with > 1yr service
                                     and preserved/age lumpsum =
Contributor Msg Manuals        711   zero


                                     Error in retrieving member's
Preserver Msg Manuals          130   address details
                                     PSS combined membership - refer
Preserver Msg Manuals          480   to file
                                     Error in determining benefit at exit
Preserver Msg Manuals          320   using interim rate
                                     Record indicates member is
                                     entitled to sgc. However sgc is
Preserver Msg Manuals          690   currently zero
                                     Temporary error for retrenchment
Preserver Msg Manuals          865   calcs for 03/04 exit
                                     Temporary error for post 30/11/05
Preserver Msg Manuals          866   withdrawals




                                   Error determining agency address
Contributor Msg Manuals        524 contact

Contributor Msg Manuals        540 Error in surcharge details
LIKELY TO BE FIXED BY 1/7/07


                                   Cash option. Further manual
Contributor Msg Manuals        755 calculation needed.
                                   Cash option. Further manual
Preserver Msg Manuals          755 calculation needed.
Preserver Msg Manuals          420 Post exit tv received


Preserver Msg Manuals          470 Post exit conts received
                                   Manbp withdrawal found .
Preserver Msg Manuals          784 Investigate for manual calc
                                   Auto withdrawal found. Investigate
Preserver Msg Manuals          786 for manual calc

Preserver Msg Manuals          475 Post exit co-conts received
ADDRESSES and AGENCY




Preserver Msg Suppressed           Cannot locate address for
from Manuals                   140 member
                                   Error determining member's
Contributor Msg Manuals        135 address
                                   Error setting agency code, agency
Contributor Msg Manuals        523 name or paycentre code




                                   Error determining agency address
Contributor Msg Manuals        524 contact (copy)
CALC ERRORS


                                   Error in retrieving calcs data. No
Contributor Msg Manuals        215 data found.

                                   Option used for calculation is not
Contributor Msg Manuals        200 available to member
                                   Error occurred while calculating
Contributor Msg Manuals    B   160 PSS transfer values
                                   Error has occurred calculating sis
Preserver Msg Manuals          450 upper limit 99
                                  Error in creating transaction
Contributor Msg Manuals       211 summary data

Preserver Msg Manuals         360 Error in surcharge details

                                  Reappointed invalidity
Preserver Msg Manuals         510 pensioner/pip


                                  Calc benefit amount has failed.
                                  Check member's record and
Preserver Msg Manuals         170 dispatcher



                                  Information statement calculation
Contributor Msg Manuals       210 error


Preserver Msg Manuals         500 Partial release



                                  Info statements calculation has
Preserver Msg Manuals         180 timed out
MANUALS

                                  Reappointed invalidity
Contributor Msg Manuals   C   320 pensioner/pip - CSS member

                                  Reappointed invalidity
Contributor Msg Manuals   C   321 pensioner/pip - PSS member


Contributor Msg Manuals   N   325 CSS reappointed late election




                                  Manual calculation required by
Contributor Msg Manuals   A   460 cms - refer to suppression list
Preserver Msg Manuals        190 Catastrophic error!




Preserver Msg Manuals        200 Member suppressed on request


Preserver Msg Manuals        410 Dup/postponed case - refer to file


Preserver Msg Manuals        465 CSS member found with manbp



                                 Negative accrual for employer.
Preserver Msg Manuals        646 Check all empr fields
Preserver Msg Suppressed
from Manuals             H   780 Family law matters

Contributor Msg Manuals      240 General calcs error

                                 Calcs has timed out for this
Contributor Msg Manuals      270 member
                                 Member initially pres all, then
                                 claimed in same fin year. Withd
Preserver Msg Manuals        770 component wrong


DATA PROBLEMS INCL FORM 18 REGISTER



Preserver Msg Manuals        240 Member is on cstm's form18 list

                                 Member started after 01/07/76 and
                                 pres code not
Preserver Msg Manuals        250 100,120,150,160,161 or 173
Contributor Msg Manuals    S   701 Stp in problems - refer to file

                                   Member started before 01/07/76.
                                   Comsas has no pre76 information
Preserver Msg Manuals          260 recorded


Preserver Msg Suppressed           Member is on cstm's form18 list -
from Manuals                   241 no equity
                                   Form18 found. Not known whether
                                   stp paid out. Check all fields of
Preserver Msg Manuals          712 member
                                   Form18 found. Not known whether
                                   stp paid out. Check all fields of
Preserver Msg Manuals          714 productivity

REAPPOINTED '125'S'

                                   Prior service entry for reappointed
Contributor Msg Manuals    C   340 deferred benefit - CSS member


Preserver Msg Manuals          280 Reappointed deferred member


                                   Prior service entry for reappointed
Contributor Msg Manuals    C   341 deferred benefit - PSS member

                                   Re-employed qualification found
Contributor Msg Manuals C      630 against member
TRANSFER VALUE ISSUES



Contributor Msg Manuals    B   350 Transfer value paid - CSS member


                                   Reappointed deferred benefit with
Contributor Msg Manuals    B   430 transfer value - CSS member
                                  CSS xfer mult incorrect. Use last
                                  contributor stmt as guide and
Preserver Msg Manuals     V   760 project forward
                                  Member has previous CSS
                                  membership(s) and has been
                                  linked incorrectly to current PSS
Contributor Msg Manuals   B   445 record

                                  CSS transfer value in -
Preserver Msg Manuals     V   460 basic/supps incorrect

                                  Reappointed deferred benefit with
Contributor Msg Manuals   B   431 transfer value - PSS member


Preserver Msg Manuals S    490 Stp in problems
TRANSACTION SUMMARY ISSUES

                                  Transaction summary total and
Preserver Msg Manuals         860 years contributions total mismatch
                                  Transaction summary total and
Contributor Msg Manuals       861 years productivity total mismatch

                                  Transaction summary total and
Contributor Msg Manuals       860 years contributions total mismatch
                                  Error in creating transaction
Preserver Msg Manuals         191 summary data



BALANCE CHECKS

                                  Member has no equity left in the
Preserver Msg Manuals         670 fund
                                  Member contributions < $200.
                                  Check if correct or if member has
Preserver Msg Manuals         652 withdrawn all
                                  Productivity < $200. Check if
                                  correct or if member has
Preserver Msg Manuals         654 withdrawn all

                                  Employer < $200. Check if correct
Preserver Msg Manuals         656 or if member has withdrawn all
                                       Unfunded prod < $200. Check if
                                       correct or if member has
Preserver Msg Manuals              657 withdrawn all

Preserver Msg Manuals              660 Final salary incorrect

                                       Sgc topup < $200. Check if correct
Preserver Msg Manuals              658 or if member has withdrawn all
LINKS4 MESSAGES / links problems

                                       Link 4 pre April 2002 case
Contributor Msg Manuals   ?R       805 suppressed - waiting to be linked

                               Links 4 case restarted in financial
Contributor Msg Manuals ?R 760 year. Check previous age benefits
                               Large conts balancing int.accrual.
                               Check if previous stmt correct or
Preserver Msg Manuals   F  673 links4
                               Large prod balancing int.accrual.
                               Check if previous stmt correct or
Preserver Msg Manuals   F  675 links4
                               Large empr balancing int.accrual.
                               Check if previous stmt correct or
Preserver Msg Manuals   F  677 links4
                               Conts balancing int.accrued =
                               withdrawal. Check if prev stmt
Preserver Msg Manuals   F  672 correct or links4
                               Empr balancing int.accrued =
                               withdrawal. Check if prev stmt
Preserver Msg Manuals   F  676 correct or links4
                               Member has previous CSS
                               membership(s) and has been
Preserver Msg Manuals   F  445 linked to current PSS record
WARNING MESSAGES TO ALWAYS PRINT
                               Super guarantee payment made
Preserver Msg Warning       50 during the financial year
                               Your pack has been sent to this
                               address as your preferred details
Contributor Msg Warning    695 are incomplete
                               Note: your contributions are
                               shortpaid. Please contact your
Contributor Msg Warning    280 personnel area
                               Please note: the above figures
Preserver Msg Warning       10 include your transfer value equity
                                Note: your last birthday salary is
                                not known. Please contact your
Contributor Msg Warning     250 personnel area
                                You are also entitled to a
                                preserved superannuation
Preserver Msg Warning       310 guarantee amount
                                Your opening balance is calculated
                                at date eligible of your latest
Contributor Msg Warning      50 membership
                                Your pack has been sent to this
                                address as your preferred details
Preserver Msg Warning       600 are incomplete
                                Please note: the above figures
Contributor Msg Warning     480 include your transfer value equity
WARNING MESSAGES - DON'T PRINT - DISPLAY FOR COMSAS STAFF

                                      Your member component is
                                      reported as zero as no
Contributor Msg Warning         302   contributions were deducted from
                                      Your salary on any payday during
Contributor Msg Warning         303   this financial year
                                      Note: your pre 90 productivity is
                                      not known. Please contact your
Contributor Msg Warning         380   personnel area
                                      Transfer value calculations altered
Contributor Msg Warning         470   during year
                                      Comsuper has processed an exit
                                      for your record since the end of the
Contributor Msg Warning         500   financial

                                    Year. Figures presented here may
Contributor Msg Warning         501 not represent your final benefit
                                    Contributions for the last several
                                    paydays of 1998/99 are not
Contributor Msg Warning         660 recorded in your
                                    Account. Centrelink expects to
                                    provide this information in the next
Contributor Msg Warning         661 few weeks.
                                    Your employer hasn't provided up
                                    to date superannuation details.
Contributor Msg Warning         662 Your statement
                              Data may not be correct. Refer to
                              the annual report for an
Contributor Msg Warning   663 explanation.
                                                                 Total
                                                                 Effort # x
Comments                                   Time Difficulty       time       Excel Spread




pre-suppression check - to member
accounts                                      0.1            1         0.1 no
Pre-suppression. Family Law unit manage
printing of these; uses same calc runs;
printed in separate batch to HPA and
some in house                                                            0
Pre-suppression check. No conts paid in
year - not really an error message;
accrued cont. ? Baseline fix Member
account to validate membership before
member statement goes out.                    0.1            1         0.1 no

pre-suppression check - member benefits
team                                          0.1            1         0.1 no
Pre-suppression check.If dead ie date of
death is populated then they are NOT
excluded from the run unless they have
PENS or No EQ status.                         0.2            1         0.2 no

presuppression calc check to mbr
accounts; they never claimed their (CSS)
benefit                                       0.2            1         0.2 no

Pre-suppression check. We usually ignore
this message and these cases go to
Member accounts. If preserver need to
change pres to cont; identify and fix         0.1            1         0.1 no

pre-suppression check - member benefits
team                                                                     0




pre-suppression check to mbr accounts;        0.1            1         0.1 no
pre-suppression check to mbr accounts;      0.1   1   0.1 no
Pre-suppression check. Interim prod -
member account to follow up;                           0
Pre-suppress. Manually fix contributor
service. Probably not fixed by baselines.
Very few of these.                           1    3    3 Maybe



balance check - presuppress to member
accounts                                    0.1   1   0.1 no
balance check - presuppress to member
accounts                                               0




Pre-suppression check - to mbr accounts     0.1   1   0.1




Pre-suppression check - to mbr accounts     0.1   1   0.1



pre-suppress check - member reporting
team (Ros); ? Remove                        0.1   1   0.1



pre-suppress check - member reporting
team (Ros); ? Remove                        0.1   1   0.1
                                                        0
Ceased conts in no man's land; still get a
statement - not yet claimed a benefit; aka
"fund reco" ones. Need to get these
properly sorted; not automated yet; deals
with LWOP date and ceased date -
caused problems in 2006. Need to check
code.                                            0.1   0.05   0.005 no

Thi to investigate                                               0

Shouldn't keep happening; AION related
thing. Check this.                                               0
Done by ComSAS staff; warning internal
only; early one doesn't print - manually
add info to later one; talk to Cat - flat file                   0
0's in fields eg age retirement but not valid,
or cont calc for pres. Check this.                               0
may be able to remove the message.
Need to check                                                    0
Remove; everyone will get this ? Only if
pres this year                                                   0


Thi to check to see if code is calling this      0.2     2      0.4 no


ie if manual last year keep; check with Thi                      0

May be fixed by baselines; need to check         0.3     3      0.9 TV in Calc


Thi to check to see if code is calling this      0.2     2      0.4 no
May have ceased date but with Cont
status. Need to check - PRESU                                    0
Manual payment of any kind has occurred;
not tracked through ComSAS; find data &
details in Form 18 register FA should fix -                         TV in Calc,
check with Bharma                                                   CPI Calc, Int
Move to Data - Form 18 later when more                              Accum, due
info known                                       0.3     3      0.9 and paid calc,
                                                                    TV in Calc,
Not seen. Check numbers; may be able to                             CPI Calc, Int
remove                                           0.2     2      0.4 Accum
Links related.Manually done, may be able                      Comsas, cpi
to remove message. Ros to follow with                         calc, 10 yr rule
Matthew.                                       0.4   2    0.8 calc


Thi to check to see if code is calling this    0.2   2    0.4 no

Internals: Thi to talk to Ros about large
conts and interest.                                         0

may be able to remove the message.
Need to check                                               0
Check numbers of these. Address issue -
like catestrophic error on address. Eg 2
valid addresses - home plus agency
ticked; can't default to agency if pres       0.05   1   0.05 no
Perhaps remove ? Ros to check with
Matthew C.                                                  0
calc prob eg ZRR - check numbers of
these                                                       0


haven't seen this; check numbers JR                         0

JR to check #'s; may not be relevant                        0

JR to check #'s; may not be relevant                        0
Agency: Ros wants this checked. Issue
(complaint) from Bruce Foldi about not
receiving a statement; had home and
agency in there (?!) need to investigate.
Should have home address as default.
Review requirements on this.
CB: can't avoid this; unlikely to be
statemetns code causing it                                  0
Should be fixed; need to check.
CB: rare - tends to be 'all' or 'none'                      0
                                                            0
Unsure: Taun (?) abnd Patrick said these
may be fixed by 30/6 - contingency; best
to have work-around and suppress unless                       cash option
ready                                          0.3   1    0.3 calc
                                                              cash option
TBC - baseline likely to fix this              0.3   1    0.3 calc
                                                          tv in calc, int
old "manbp" group; 99% sure these will                    accum,
work in 07                                  0.1   1   0.1 comsas
member ceases, additional cont paid after
exit - manually added. 90% SURE WILL
WORK WITH NEW CODE                          0.1   1   0.1 Comsas
old "manbp" group; 99% sure these will
work in 07                                              0
old "manbp" group; 99% sure these will
work in 07                                              0
Coming from ATO; like 470; 90% LIKELY
TO BE FIXED                                             0
                                                        0
=lost or 2 returns so set to lost; for
online stmts - if 140is only error
message then show statement on line
(add this rule - also at moment has
'exclude' status - add code for T for
lost)                                                   0

Addresses                                               0

Agency:                                                 0
Agency: Ros wants this checked. Issue
(complaint) from Bruce Foldi about not
receiving a statement; had home and
agency in there (?!) need to investigate.
Should have home address as default.
Review requirements on this.                            0
                                                        0
like 210; most clearly identified msg
number for PLSQL errors; if no results                    ComSAS, due
from calcs happens proves it can't be                     and paid, 10 yr
retrieved and calcs pkg invalid code         1    4     4 rule calc
OK, removed message, calcs fine
Need dummy run on SQL to confirm fix
after testing                                           0

Some 160's have been fixed                              0 TV in calc

suppress                                                0
may mean no date on trans summ
(mismatch) ? Accrued equity. Full dummy
run on PLSQL needed to confirm validity
of this. Thi to check.                                     0

like the cont message                                      0
                                                             TV in calc, int
Invalidity; partial invalidity pensioner in                  accum, cpi
PSS; hundred of PIP's - to invalidity team     0.4   4   1.6 calc, comsas

                                                             Comsas, due
                                                             and paid, 10 yr
                                                             rule calc, cpi
                                               0.4   4   1.6 calc, int accum

                                                             Comsas, due
                                                             and paid, 10 yr
calcs errors have 0 in fields eg joine wrong                 rule calc, cpi
scheme; no eq; date issue                      0.4   4   1.6 calc, int accum
                                                             comsas, int
When preserved benefit - some taken out,                     accum, cpi
up to SIS                                       1    5     5 calc

                                                             Comsas, due
                                                             and paid, 10 yr
These could still time out; AION DS                          rule calc, cpi
based.                                         0.4   4   1.6 calc, int accum
                                                           0
                                                             TV in calc, int
                                                             accum, cpi
Always manual                                  0.4   4   1.6 calc, comsas
                                                             TV in calc, int
                                                             accum, cpi
Always manual                                  0.4   4   1.6 calc, comsas
                                                             comsas, int
                                                             accum, TV in
Always manual                                  0.3   3   0.9 calc


                                                             Comsas, due
                                                             and paid, 10 yr
                                                             rule calc, cpi
"AGS" number group of suppressions              1    5     5 calc, int accum
                                                          Comsas, due
= 'super manual'; PLSQL may improve                       and paid, 10 yr
this; AION based code - PLSQ!L impact                     rule calc, cpi
needs checking                                1    5    5 calc, int accum

                                                           Comsas, due
Change text to 'Member suppressed by                       and paid, 10 yr
statements team'; same as 460 for conts;                   rule calc, cpi
includes non-migration cases                  1    5     5 calc, int accum
                                                           Dup Sal calc,
                                                           Awote calc,
suppress                                     0.3   3   0.9 comsas
                                                           ComSAS, TV
                                                           in Calc, Int
= manuals                                    0.3   3   0.9 Accum




check after 642/644 looked at                0.1   1   0.1 no

FLU do these                                            0

                                                        0
usually caused by a calcs error; do dummy
run and check for this; may be able to
remove - AION DS based                                  0


suppress                                                0
Means manual payment has been made -
keep until all Form18 issues no longer
relevant                                                0
                                                           TV in Calc,
                                                           CPI Calc, Int
                                                           Accum, due
                                             0.3   3   0.9 and paid calc,
Multiples: CSS deferred are treated
differently; supps and basics - non                       TV in calc, Int
refundable and refundable - refer to prior                accum,
service page                                  1    5    5 ComSAS
                                                           ComSAS, TV
Mainly "pending" but suppression has to                    in Calc, Int
stay                                         0.3   4   1.2 Accum

                                                           TV in calc, Int
Multiples: Refer to Prior service page;                    accum,
similar to 250                                1    5     5 ComSAS
                                                           TV in Calc,
                                                           CPI Calc, Int
                                                           Accum, due
This was statements team's Form 18           0.3   3   0.9 and paid calc,


Form 18 group                                            0


Form 18 group                                            0
These come from pre-1976 members who
move to CSS scheme                                       0
                                                           ComSAS, TV
                                                           in Calc, Int
"125's" reappointed; not correctly linked.   0.3   3   0.9 Accum
                                                           ComSAS, TV
System one; = "125's"; 2 CSS records                       in Calc, Int
unlinked                                     0.3   3   0.9 Accum

                                                           ComSAS, TV
                                                           in Calc, Int
"125's" reappointed; not correctly linked.   0.4   4   1.6 Accum
                                                           ComSAS, TV
                                                           in Calc, Int
"125's"                                      0.3   3   0.9 Accum
                                                         0

                                                           TV in calc, Int
                                                           accum,
                                              1    5     5 ComSAS

                                                           TV in calc, Int
                                                           accum,
System doesn't calc tfr values                1    5     5 ComSAS
                                                            ComSAS, TV
                                                            in Calc, Int
                                              0.4   4   1.6 Accum

                                                              TV in calc, Int
Reword to include "incorrectly" Incorrect                     accum,
link; CSS transfer multiple calc to PSS        1    5    5    ComSAS
                                                              TV in calc, Int
same as cont/deferred sometimes can be                        accum,
basics or supps, eg hardship                   1    5    5    ComSAS
                                                              TV in calc, Int
                                                              accum,
System doesn't calc tfr values                 1    5    5    ComSAS
                                                              TV in calc, Int
                                                              accum,
Std termin payment - tfr in prob              0.3   3   0.9   ComSAS
                                                          0


                                              0.2   2   0.4 ComSAS

Data prob mismatch                            0.2   2   0.4 ComSAS


Data prob mismatch                            0.2   2   0.4 ComSAS

                                                         0

all need to be checked - we paid interest
wrong and recalced, or last pay they joined
and only a small amount there                            0
                                                              ComSAS, TV
                                                              in Calc, Int
safety message                                0.2   3   0.6   Accum
                                                              ComSAS, TV
                                                              in Calc, Int
                                              0.2   3   0.6   Accum
                                                              ComSAS, TV
                                                              in Calc, Int
                                              0.2   3   0.6   Accum
                                                              ComSAS, TV
                                                              in Calc, Int
                                              0.2   3   0.6   Accum
                                                           ComSAS, TV
member account and benefits to look at                     in Calc, Int
these                                        0.2   3   0.6 Accum

                                             0.2   1   0.2 ComSAS
                                                           ComSAS, TV
                                                           in Calc, Int
                                             0.2   3   0.6 Accum
                                                         0
No need for multi-envelope in 07; Remove
- code should not call this - Thi to check
and confirm                                             0


No need for multi-envelope in 07                        0
previous membership isn't picked up in
links record, statement should bring all
equity across                                           0


                                                        0


                                                        0


green = links4                                          0


                                                        0
Reword to .. Linked incorectly to current
PSS record. If link doesn't work you get
this message.                                           0
43794

printable


Shows on statement


Always print as warnings

printable
Always print as warnings
VERY large numbers of these in'06; need
to look into this


printable


Always print as warnings


printable: addresses

Shows on statement




Internal message only for ComSuper staff;
get generated in auto run
Internal message only for ComSuper staff;
get generated in auto run

Internal message only for ComSuper staff;
get generated in auto run
Internal message only for ComSuper staff;
get generated in auto run

Internal message only for ComSuper staff;
get generated in auto run

Internal message only for ComSuper staff;
get generated in auto run
As above; analyse # and impact if we
remove these. May have related to interim
prod and may no longer be relevant



Internal message; eg missing meployer
details - no % rate; no super salary, # pays
etc. Check number of cases.
Internal message; eg missing meployer
details - no % rate; no super salary, # pays
etc. Check number of cases.
                                       MS    EQ
                        # in           G_    UIT MS
                        05/07 # in     PRI   Y_A G_T
                        Dummy 2006     ORI   FFE YPE
                               1,775
May need some
further investigation
through member
accounts or may be
correct.                   189   534 999 Y      SM



FLU team do these          348   417 999 N      SI
May need some
further investigation
through member
accounts or may be
correct.                    97   266 999 Y      SM

Must go to benefits
to organise payment        300   228 999 Y      SI


Question
Roz/benefits                53   106 999 N      SI

Needs some further
investigation through
member accounts             46    64 999 N      SI


Needs some further
investigation through
member accounts              0    63 999 Y      SM

Must go to benefits
to organise payment         13    31 999 N      SI
May need some
further investigation
through member
accounts or may be
correct.                   236    27 999 Y
May need some
further investigation
through member
accounts or may be
correct.                 63     10 999 Y

ags # needed              0      9 999 Y   SM

MA may have a
spreadsheet               6      9 999 N   SM
May need some
further investigation
through member
accounts or may be
correct.                  8      9 999 Y   SM
Is this the same as
642?                      3      2 999 Y   SM
May need some
further investigation
through member
accounts or may be
correct.                  0 ?      999 N   W
May need some
further investigation
through member
accounts or may be
correct.                  0 ?      999 N   W
May need some
further investigation
through member
accounts or may be
correct.                  0 ?      999 N   W
May need some
further investigation
through member
accounts or may be
correct.                     ?     999 N   W
                        4996 15373
Put lwop on record at
exit date in 06.
Should be followed
up by benefits.         3782 10168 999 N   SM

                          0   1895 999 N   SI


                        197   1158 999 Y   SM


were pres, now cont     482    866 999 Y   SM

ags # needed            119    381

ags # needed             42    264 999 Y   SI

                          0    241 999 N   SM


                        210    145 999 N   SM
ags # needed,
depends if you can
run calcs in QWB         61     68 999 Y   SM

                         26     54


similar to 730           11     48 999 N   SM

Like pres 304            11     23



Depends if earlier
calcs have been
done.                     8     16 999 Y   SM

Baseline may have
fixed?                   12     16 999 Y   SM
ags # needed              5       9


                          4       9 999 N     SM


ags # needed             23       8 999 Y     SM


ags # needed              2       2 999 N     SI
May need some
further investigation
through member
accounts                  0       1 999 N     SI

                          1       1 999 Y     SM

                          0       0 999 Y     SM


                          0       0 999 N     SM

                          0       0 999 N     SM

                          0       0 999 N     SM




May need some
further investigation
through member
accounts                  1?          999 N   SI

                          0?          999 N   SM
                               1839



                        461    1056 999 Y     SM

                        597     759 999 Y     SM
QWB should calc
right if s'ment doesn't     21      22 999 Y     SM

QWB should calc
right if s'ment doesn't      1       2 999 Y     SM

                             0       0 999 N     SM

                             0       0 999 N     SM

                             0           999 Y   SM
                                 13436




                          18863 13422 999 N      SI

                             0       2 999 N     SI

                             0       7 999 N     SI




                             1       5 999 N     SI
                                 2,473



QWB may work               482     959 999 Y     SM


ags # needed               725     520 999 Y     SM

ags # needed                 0     381 999 Y     SM

ags # needed                51     326 999 N     SM
Copy and paste job        0    168 999 Y   SM

Copy and paste job       34     88 999 N   SM


                          5      9 999 Y   SM




                          0      7 999 Y   SM




                          0      6 999 Y   SM


                          2      5 999 Y   SM




                          2      4 999 Y   SM
                              2514


                         18     37 999 Y   SM


                         11     26 999 Y   SM


                         21     37 999 Y   SM


Varies from simple to
very hard. Some due
to online suppression
requests by member      132    230 999 Y   sm
Varies from simple to
very hard.               200    1176 999 Y     SM



Varies from simple to
very hard.               460     601 999 Y     SM


Completed by flat file   205     206 999 N     SM


                          26      32 999 Y     SM
May need some
further investigation
through member
accounts or may be
correct.                 224      11 999 Y     SM

                         127     158 999 N     SI

                           0?          999 Y   SM


                           0?          999 Y   SM


                           0?          999 Y   SM


                                 711
Depends if earlier
calcs have been
done. Like other form
18's                     347     408 999 Y     SM

Calcs have generally
already been done
saved in trim.           149     226 999 Y     SM
                         14    31 999 Y   SM

Calcs have generally
already been done
saved in trim.           20    27 999 Y   SM
Depends if earlier
calcs have been
done. Like other form
18's                      9    19 999 Y   SM


                          0     0 999 Y   SM


                          0     0 999 Y   SM

                              745


                        105   496 999 Y   SM


                         74   140 999 Y   SM
There should be a
correct calc of the
CSS TV multi but not
always.                  36    78 999 Y   SM


                          5    31 999 Y   SM
                              675
Calcs have generally
already been done
saved in trim. Like
250                     154   373 999 Y   SM
Calcs have generally
already been done
saved in trim. Like
250                      51   132 999 Y   SM
There should be a
correct calc of the
CSS TV multi but not
always.                 91    95 999 Y     SM



                        22    54 999 Y     SM


                        11    13 999 Y     SM


                         3     8 999 Y     SM


                         3         999 Y   SM
                             766

Taskforce were able
to complete.             0   587 999 N     SM

                         0   150 999 N     SM

Taskforce were able
to complete.             0    23 999 N     SM

Copy and paste job       0     6 999 Y     SM



                             389


                       100   334 999 N     SI


                        38    14 999 N     SM


                        19    14 999 N     SM


                         3    14 999 N     SM
                         3      10 999 N     SM
Member accounts
need to investigate      2       3 999 Y     SM


                         1       0 999 N     SM
                               229


                         0?          999 N   SM


sending separately      10     112 999 N     SM


ags # needed           458      43 999 Y     SM


ags # needed            80      28 999 Y     SM


ags # needed             7      26 999 Y     SM


ags # needed             7      17 999 Y     SM


ags # needed            15       3 999 Y     SM


                         0       0 999 Y     SM


                         0?           30 N   W


                      14138 15339     50 N   W


                      7440 14414      30 N   W

                      4693    5114    20 N   W
31908    3493     40 N   W


 2819    2951     10 N   W


   54    2483     20 N   W


   28      38     40 N   W

    0        7    10 N   W
         4,650




    0      77 999 N      W

    0      76 999 N      W


    1       2 999 N      W

    6       2 999 N      W


    0 2,247 999 N        W


    0 2,246 999 N        W
    0-

                 999 N   W
    0-

                 999 N   W
    0-

                 999 N   W
0-

     999 N   W
                    MS                                     # in
                    G_I                                    dummy      # in May
MSG_SCHEME          D     Msg_text                         15/6/07    Dummy # in 2006
PRE-SUPPRESSION CHECK                                            1496      1,362   1,775
TO BE CHECKED                                                    4489       4489  15373
LIKELY TO BE FIXED BY 1/7/07                                     1080       1080  39182
ADDRESSES and AGENCY                                            18861     18864   35504
CALC ERRORS                                                      1030       1301    8651
MANUALS                                                          1529       1932    3384

MANUALS (OF TYPE: DATA PROBLEMS INCL FORM 18
REGISTER)                                                        538       539         711

MANUALS (OF TYPE: REAPPOINTED '125'S')                           217       220         745
TRANSFER VALUE ISSUES                                            313       335         675
TRANSACTION SUMMARY ISSUES                                         0         0         766




BALANCE CHECKS                                                    93       166        389
LINKS4 MESSAGES / links ALWAYS
WARNING MESSAGES TOproblems PRINT                                124       577        229
Warning messages: Ros confirms ARIA are OK with max of 2       55753     61080      43839
WARNING MESSAGES - DON'T PRINT - DISPLAY FOR                  13,476         7       4,650

Totals:                                                       29,770    30,865     107,384
Lost:                                                         18,861    18,864      35,504
                                                              10,909    12,001      71,880
Warnings:                                                   69,229.00 61,087.00   48,489.00



Cont                                                             1.00
Cont                                                            40.00




Cont                                                           549.00
Pres                   806 ??                                4,680.00
Pres                                                            47.00
                                                             134,086

                                                           110,405.00
MS MSG
G_P _TY
RIO PE
version   0.4   added in columns for info on difficulty from discussions with Bridie and Exclude Code Type
version   0.5   added in data from Dummy Run concluded 15/6 ie numbers by error type
version   0.6   added action @ 20/6 column & updated text; relocated Pres 302 to Manual; Cont 290 to Manual; all 'Dat
version   0.7   added tab for 'Numbers 06 v 07 for totals of error message type; added rest of action @ 20/6 from Pres
and Exclude Code Type

Manual; Cont 290 to Manual; all 'Data problems' now Manual; all Reapponted 125 now Manual
ded rest of action @ 20/6 from Pres 646 to end
                 Action from Thi Ngo on 21/6
Removed:         email to Julie Rose
                 Msg ID: 662 - ERROR IN
                 PROCESSING MEMBER'S           Reason: PSLQL calc handles
Pres       662   TRANSFER VALUES               this.
                 Msg ID: 663 - ERROR IN SET    Reason: PLSQL calc doesn't
                 UP TRANSFER IN DETAILS        need to set up Transfer In
Pres       663   FOR MEMBER                    figures.
                 Msg ID: 682 - UNABLE TO
                 RETRIEVE MEMBER CONTS         Reason: PSLQL calc handles
Pres       682   AND PRODUCTIVITY              this.
                 Msg ID: 680 - ERROR: UNABLE
                 TO DETERMINE EMPLOYER         Reason: PSLQL calc handles
Pres       680   COMPONENT                     this.
                 Msg ID: 665 - ERROR IN
                 PROCESSING MEMBER'S
                 COMPONENTS FROM EXIT          Reason: PSLQL calc handles
Pres       665   DATE TO START DATE            this.
                 Msg ID: 690 - RECORD
                 INDICATES MEMBER IS
                 ENTITLED TO SGC.              Reason: Business Rules are
                 HOWEVER SGC IS                more complex now. Not everyone
Pres       690   CURRENTLY ZERO                is entitled to SGC easily now.
                 Msg ID: 730 - ON PREV STMT
                 MEMBER = 0. CHECK THIS
                 STMT IS CORRECT AND           Reason: PSLQL calc handles
                 SEND WITH APOLOGY             this. (Refer to Underpayment's
Pres       730   LETTER                        issue)

               Msg ID: 731 - ON PREV STMT
               PROD = 0. CHECK THIS STMT Reason: PSLQL calc handles
               IS CORRECT AND SEND WITH this. (Refer to Underpayment's
Pres       731 APOLOGY LETTER             issue)

               Msg ID: 732 - ON PREV STMT
               EMPR = 0. CHECK THIS STMT       Reason: PSLQL calc handles
               IS CORRECT AND SEND WITH        this. (Refer to Underpayment's
Pres       732 APOLOGY LETTER                  issue)
               Msg ID: 635 - PREVIOUS
               YEAR'S STATEMENT NOT
               FOUND. NEW SMT CANNOT           Case is either Manual Last Year
Pres       635 BE PROCESSED                    or Has ManBP
            Basic philoshopy is to take last
            year's statement as being
            correct and use its closing
            balance as this year's opening     Reason: BUT WE DO 2 CALCS
            balance                            FOR EVERYONE NOW !

             Msg ID: 666 - ERROR IN            Unpaid Benefit: Checks for
             PROCESSING CLAIMS                 withdrawals processed last year
             STARTED IN PREVIOUS YEAR          and paid in the current financial
         666 AND PAID IN CURRENT YEAR          year
             Msg ID: 450 - ERROR HAS
             OCCURRED CALCULATING              Reason: PSLQL calc handles
         450 SIS UPPER LIMIT 99                this.

             Msg ID : 787 - WITHDRAWAL         Reason: At the moment, PLSQL
             PRES TV IN FOUND. MANUAL          Calc doesn't break down the TV
             CALC REQUIRED FOR                 figures for True TV In, Co-
             COCONTS, TVPOST95,                Contributions and ATO-SG. It
Added:   787 ATOSG                             reports just 1 figure.




                                                         I went through the
             Msg ID : 788 - WITHDRAWAL         Member Statement's
             UNPRES TV IN FOUND.               requirements with Bhama on
             MANUAL CALC REQUIRED              Tuesday. She will write a new
             FOR COCONTS, TVPOST95,            function for this when she got
         788 ATOSG                             back, next Tuesday.
Not in this error codes list
anyway

Not in this error codes list
anyway

Not in this error codes list
anyway

Not in this error codes list
anyway


Not in this error codes list
anyway




noted in main page of s/s




noted in main page of s/s




noted in main page of s/s




noted in main page of s/s



noted in main page of s/s
Reason: New Withdrawals
packages from PLSQL Calc    Not in this error
will handle this.           codes list anyway


noted in main page of s/s




                                      I suggest
                            we should apply
                            the new function
                            (written by
                            Bhama); break
                            down the TV
                            figures for the PSS
                            Preservers Code
                            in Drop 2.

								
To top