Benefits Administration Reports: A to Z

This table lists the Benefits Administration reports, sorted alphanumerical by report ID. The reports listed are all Structured Query Reports (SQRs). If you need more information about a report, refer to the report details at the end. For samples of these reports, see the Portable Document Format (PDF) files that are published with your online documentation.

For more information about running these reports, refer to:

  • The corresponding topic in this product documentation.

  • PeopleTools: Process Scheduler

  • PeopleTools: BI Publisher for PeopleSoft.

  • PeopleTools: SQR Language Reference for PeopleSoft

Report ID and Report Name

Description

Run Control Page

BAS001

Eligible Participants

Lists, by schedule and benefit program, employees who are eligible to participate in company benefit programs with details on plan and option eligibility.

RUNCTL_BAS001

BAS002

Benefit Program Mailing Labels

Prints a set of 4-across mailing labels for employees participating in benefit programs. Compiles the list from the BAS Participant tables created during open enrollment or event maintenance processing.

RUNCTL_BAS002

BAS003

Invalid Benefit Elections

Lists, by schedule and event, participants and their dependents, showing any errors such as coverage over the maximum or under the minimum, invalid choices, failure to meet eligibility requirements, and so on.

RUNCTL_BAS_SCHED

BAS004

Benefit Enrollment Form

Prints a generic enrollment statement for each eligible benefit program participant in the BAS Participation table.

Includes the name and address of each participant, with options for which the participant is eligible and the associated price tags and credits (if applicable) for the options.

RUNCTL_BAS004

BAS005

Confirmation Statement

Prints a generic confirmation statement for each valid benefit program participant. Includes coverage and per pay period costs.

RUNCTL_BAS005

BAS006

Missing Elections

Lists and provides location information for participants who did not return enrollment statements.

RUNCTL_BAS_SCHED

BAS007

Dependent/Beneficiary Election

Lists all dependents with current or new elections.

RUNCTL_BAS_SCHED

BAS008

Flagged Participant Report

Lists events that have had job, address, or union eligibility information changed, events that have been processed out of sequence, and events that have been disconnected during processing.

RUNCTL_BAS008

BAS010

Ineligible Participants

Lists all participants who are ineligible for any benefit program (events processed to AN status) and their eligibility parameters, such as birth date and status.

RUNCTL_BAS_SCHED

BAS027

Employee Processing Status

Lists all participants in a particular process status or set of status levels.

RUNCTL_BAS027

BAS701

Geographic Location Eligibilit

Prints location IDs, effective dates, and from and to ranges for the U.S. and Canadian postal code ranges that you've defined to determine benefit eligibility.

RUNCTL_BEN_LANG

BAS702A

Benefit Program/Plan/Options

For a specified benefit program, prints program-level information (effective date and status, program type, COBRA, FMLA, and FSA parameters and self-service configuration) along with the plan-level and option-level structure (event rules, dependent rules, eligibility rules, coverage levels, and deduction codes).

RUNCTL_BAS_PGM

BAS702B

Benefit Program Costs

For a specified benefit program, prints the program description along with the cost and credit structure for all of the offered options (deduction and earnings codes, rate information, and calculation rules).

RUNCTL_BAS_PGM

BAS703A

Eligibility Rules Table

For each plan type in a benefit program, prints the rules for minimum standard hours, maximum standard hours, minimum service, maximum service, minimum age, maximum age, service and age as of information, employee class, employee status, employee type, full/part, reg/temp, officer code, union code, company, location, state, and eligibility configuration.

For each eligibility rule definition, prints the minimum/maximum criteria (standard hours, service months and age) and the membership criteria (such as employee class, full or part time, company and paygroup, union code, state, and so on) along with the applicable grouping methods and evaluation rules.

RUNCTL_BAS703A

BAS703B

Event Rules Table

Prints event rules for benefit plan types. For an event rule definition, prints each event class with its basic change restrictions (type of changes allowed and option-level movement), date rules (coverage and deduction dates with waiting periods), and other event controls (defaulting, editing, and exceptions).

RUNCTL_BAS703B

BAS703C

Event Rules Table (Billing)

Lists the parameters in which billing enrollments are created or updated during the Benefits Administration process. Displays the event rules, event class, billing action, billing action date, and rate qualifier.

RUNCTL_BAS703B

BAS714

Benefits Admin Scheduling

Lists the criteria that make up a schedule.

Use to review schedules that have been entered into the system and to ensure that no employee overlaps exist.

RUNCTL_BAS_SCHED

FSA001

FSA Claim Payment Process (flexible spending account claim payment process)

Process all claim data with the following statuses: Submitted, Pending, and Ready To Pay.

PRCSRUNCNTL

FSA002

FSA Account Closure

Initiate an SQR that updates the account status to Closed for FSA participants who had an active FSA at the end of the calendar year.

RUNCTL_FSA002(CN)

FSA003

FSA Check Printing

Print FSA claim checks for records flagged in FSA001. Run this process for each type of check stock that you use. Set up the FSA Claims Processing Run Ctl page, and then run Processing Claim Payments.

RUNCTL_FORM_ID

FSA004

FSA Check Register

Print a list of checks printed by the FSA Check Print Report. Set up the FSA Claims Processing Run Ctl page, and then run Processing Claim Payments.

RUNCTL_FSA004(CN)

FSA005

FSA Quarterly Statement

Create and print quarterly statements for FSA participants who had activity in one of their spending accounts during the current quarter.

PRCSRUNCNTL

FSA006

FSA Check Reversal (flexible spending account check reversal)

Reverse FSA payment checks that were created in error.

RUNCTL_FSA006

FSA007

FSA Claim Reversal (flexible spending account claim reversal)

Enter the parameters for the check reversal process.

RUNCTL_FSA007