You are browsing the archive for Oracle Advanced Benefits.

Temporal Communications (Action Item Reminder)

 

NAME: Temporal Communications (Action Item Reminder)
SHORT CODE: BENTCMAR
MODULE: Oracle Advanced Benefits

Description: Temporal Communications (Action Item Reminder)
Navigation: Oracle Advanced Benefits Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_benefit_action_id : Benefit Action
  • p_validate : Validate
  • p_effective_date : Effective Date
  • p_business_group_id : Business Group
  • p_mode : Mode
  • p_cm_trgr_typ_cd : Communication Trigger Type
  • p_cm_typ_id : Communication Type
  • p_person_id : Person to process
  • p_person_type_id : Type of persons to process
  • p_person_selection_rule_id : Person selection rule
  • p_organization_id : Organization
  • p_location_id : Location
  • p_ler_id : Life Event
  • p_pgm_id : Program Name
  • p_pl_nip_id : Plan Name
  • p_plan_in_pgm_flag : Is plan in a program?
  • p_actn_typ_id : Action Type
  • p_elig_enrol_cd : Eligible for or Enrolled In
  • p_age_fctr_id : Age Factor
  • p_min_age : Minimum Age
  • p_max_age : Maximum Age
  • p_los_fctr_id : Length of Service Factor
  • p_min_los : Minimum Length of Service
  • p_max_los : Maximum Length of Service<

 

Benefits Confirmation and Summary

 

NAME: Benefits Confirmation and Summary
SHORT CODE: BENSMREP
MODULE: Oracle Advanced Benefits

Description: Benefits Confirmation and Summary Report
Navigation: Oracle Advanced Benefits Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_effective_date :
  • p_benefit_action_id :
  • p_pgm_id :
  • p_pl_nip_id :
  • p_organization_id :
  • p_location_id :
  • p_person_id :
  • p_ler_id :
  • p_lf_evt_ocrd_dt :
  • p_person_selection_rule_id :
  • p_comp_selection_rule_id :
  • p_business_group_id :
  • p_plan_in_pgm_flag :
  • p_person_type_id :
  • p_reporting_group_id :
  • p_svc_area_id :
  • p_assignment_type :
  • p_cvg_strt_dt :
  • p_cvg_end_dt :
  • p_ben_sel_flag :
  • p_flx_sum_flag :
  • p_cov_dpnt_flag :
  • p_prmy_care_flag :
  • p_beneficiaries_flag :
  • p_certifications_flag :
  • p_actn_items_flag :

 

Participation Process: Selection

 

NAME: Participation Process: Selection
SHORT CODE: BENSEMOD
MODULE: Oracle Advanced Benefits

Description: Manage Life Events.
Navigation: Oracle Advanced Benefits Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_benefit_action_id : Benefit Action
  • p_effective_date : Effective Date
  • p_mode : Mode of operation
  • p_derivable_factors : Derivable Factors
  • p_validate : Validate
  • p_person_id : Person to process
  • p_person_type_id : Type of persons to process
  • p_pgm_id : Program name
  • p_business_group_id : Business Group
  • p_pl_id : Plan name
  • p_popl_enrt_typ_cycl_id : Enrollment type cycle
  • p_lf_evt_ocrd_dt : Life Event Occured Date
  • p_no_programs : Plans not in Programs
  • p_no_plans : Only Programs
  • p_comp_selection_rule_id : Comp selection rule
  • p_person_selection_rule_id : Person selection rule
  • p_ler_id : Life Event
  • p_organization_id : Organization
  • p_benfts_grp_id : Benefits Group
  • p_location_id : Location
  • p_pstl_zip_rng_id : Postal Zip Range
  • p_rptg_grp_id : Reporting group
  • p_pl_typ_id : Plan type
  • p_opt_id :