Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Peoplesoft Ben Admin-archive bas partic tbls/change ben admin start dt

Status
Not open for further replies.

kandre

Technical User
Jan 31, 2011
1
US
We have the PeopleSoft Benefits Administration module implemented and would like to archive the bas partic tables to improve Ben Admin run time and move the Ben Admin Start Date to reduce the retroactive period Ben Admin has to ‘look at’ for processing (currently 1/1/2006). When we originally implemented, we ran the snapshot process setting SNP events to validate the converted Base Benefits data against the new eligibility rules.

If we archive the history rows in the bas partic tables, we want to re-baseline the employees’ eligibility as of a certain date so Ben Admin has a least one row of Bas Partic data to hit against. We plan to run the snapshot process to set a new SNP event with the effective date equal to the new Ben Admin Start Date. Bas partic records prior to this new Ben Admin Start Date will be archived. All existing employees will have a new bas partic record effective on the new Ben Admin Start Date.

·Has anyone taken a similar approach when archiving bas partic data and/or moving the Ben Admin Start Date? I want to validate our approach makes sense.
·Is anyone aware of issues running another snapshot as of a more current date (using new Snapshot ID, etc.) aside from having to deal with ineligibility issues that show on new SNP event?
·If we archive the Bas Partic tables and leave all the data in the Base Benefits tables, has anyone experienced issues if the Base Benefit data is changed?

Any feedback is appreciated - concerns, potential issues, etc.

Thanks,

Kate

Proposed Bas Partic Tables to archive:
PS_BAS_PARTIC
PS_BAS_PARTIC_ELIG
PS_BAS_PARTIC_DPND
PS_BAS_PARTIC_PLAN
PS_BAS_PARTIC_COST
PS_BAS_PARTIC_OPTN

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top