Re: Ben100A SQR

[Don Barclay <don.barclay@SRS.GOV>]

Matthew,

We run Ben100 to populate a delivered table with all current enrollments.
We then run a custom SQR to pull off the records we are interested in to
send to the vendor.  We do ours by creating a custom table that stores
enrollment history previously sent to the vendor.  We can then compare the
table populated by ben100 to our history table to find out if any
enrollment data has changed -- and then send that to the vendor.

There may be a better way, but that was the best we could come up with.
Let me know if you want any additional info.

Don Barclay
Westinghouse Savannah River Co.
Aiken, SC





"Shipquist, Matthew" <Matthew.Shipquist@STATE.MN.US>
Sent by: "Discussion of SQR, Brio Software's database reporting language"
<SQR-USERS@list.iex.net>


09/13/2002 03:03 PM
Please respond to sqr-users


        To:     SQR-USERS@list.iex.net
        cc:
        Subject:        Ben100A SQR


Anyone out there ever tried to Modify Ben100A SQR delivered PS to create
changes files? Or has anyone been involved in BenAdmin and developed a
changes file reporting for Vendor Interface? Talking about Version 8.3 PS
here ;) When I say changes files I'm talking picking up on a daily basis
only the enrollment changes - delivered code picks up all enrollment, not
just changes.
Thanks!