Sample
of Manual Adjustment Process (EGI)
-------------------------------------------------------------------------------
From: Shipley, Kathi
Sent: Friday, October 01, 2004 2:12 PM
To: 'Robin Jarman'; Morman, Scott; Jancha, Kimberly
Cc: Morman, Scott; Jancha, Kimberly
Subject: EMPLOYEE (721) Term
Updated to 3/31/04
Robin:
I
updated SGELIG to reflect a 3/31/04 termination date for all coverages for EMPLOYEE.
To follow are the manual premium billing
adjustments
for Medical and Dental for April 2004:
|
DOC
SEQ
|
VENDOR
|
ID
|
ID
|
STATUS
|
CVG
TYPE
|
PLAN
|
CVG
LEVEL
|
CVG
PERIOD
|
COMM CODE
|
NET
AMOUNT
|
|
|
0000004
|
DEL
|
SSN
|
SSN
|
RET
|
DN
|
DD
|
SPO
|
200404
|
BAC
|
-23.73
|
LOAD
|
|
0000005
|
BLU
|
SSN
|
SSN
|
RET
|
MD
|
AL
|
SPO
|
200404
|
BAC
|
-275.30
|
LOAD
|
In
addition, here are the manual entries to recapture the vendor ASO fees
paid
during April and May:
|
DOC
SEQ
|
ID
|
ID
|
SAC
|
STATUS
|
CVG
PERIOD
|
PLAN
|
CVG
LEVEL
|
CVG
TYPE
|
COMM
CODE
|
|
NET
AMOUNT
|
|
|
0000227
|
SSN
|
SSN
|
721
|
RET
|
200404
|
AL
|
SPO
|
MD
|
BAC
|
|
-20.16
|
LOAD
|
|
0000228
|
SSN
|
SSN
|
721
|
RET
|
200405
|
AL
|
SPO
|
MD
|
BAC
|
|
-20.16
|
LOAD
|
|
DOC
SEQ
|
ID
|
ID
|
SAC
|
STATUS
|
CVG
PERIOD
|
PLAN
|
CVG
LEVEL
|
CVG
TYPE
|
COMM
CODE
|
|
NET
AMOUNT
|
|
|
0000037
|
SSN
|
SSN
|
721
|
RET
|
200404
|
DD
|
SPO
|
DN
|
BAC
|
|
-2.10
|
LOAD
|
|
0000038
|
SSN
|
SSN
|
721
|
RET
|
200405
|
DD
|
SPO
|
DN
|
BAC
|
|
-2.10
|
LOAD
|
Kathi
C. Shipley, CPA
The University of Texas System
Employee
Group Insurance
(512)
499-4273
-----Original Message-----
From: Robin Jarman [mailto:rjarman@mail.utexas.edu]
Sent: Saturday, September 04, 2004 6:15 PM
To: Morman, Scott; Jancha, Kimberly
Subject: EMPLOYEE
Hi Scott and Kim,
Could we change her term date back to 3/31? It looks like I made
corrections to
her record 0052/0053 on the same day that the drop off sweep ran. I
guess the
timing wasn't quite right.
Thanks,
Robin
Robin Jarman
Human Resource Services
Benefit Services (J5600)
p 512/475-8056
f 512/471-5034