You are browsing the archive for Oracle Public Sector Payroll.

PenServer Control Totals Process

 

NAME: PenServer Control Totals Process
SHORT CODE: PQPPENTTL
MODULE: Oracle Public Sector Payroll

Description: PenServer Control Totals Process
Navigation: Oracle Public Sector Payroll Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_extract_type : Extract Type
  • p_parent_request_id : PenServer Interface Process Request ID
  • parent_selected :
  • p_ext_bdi_rslt_id : Basic Data Interface Request ID
  • p_ext_adi_rslt_id : Address Data Interface Request ID
  • p_ext_sehi_rslt_id : Service History Interface Request ID
  • p_ext_sahi_rslt_id : Salary History Interface Request ID
  • p_ext_ehi_rslt_id : Earnings History Interface Request ID
  • p_ext_ahi_rslt_id : Allowance History Interface Request ID
  • p_ext_bhi_rslt_id : Bonus History Interface Request ID
  • p_ext_wps_rslt_id : WPS Contribution Rate History Interface Request ID
  • p_ext_pthi_rslt_id : Part-time Hours History Interface Request ID
  • p_ext_sthi_rslt_id : Short-time Hours History (Single Records) Interface Request ID
  • p_ext_sthai_rslt_id : Short-time Hours History (Accumulated Records) Interface Request ID
  • p_business_group_id :
  • p_year_end_close : Year End Clos

 

Federal HR Element Mapping

 

NAME: Federal HR Element Mapping
SHORT CODE: PQPPCVUPD
MODULE: Oracle Public Sector Payroll

Description: Mapping Federal HR Elements to Agency Elements
Navigation: Oracle Public Sector Payroll Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_business_group_id : Business Group Id in which the Program is being run
  • p_old_ele_name : Federal Element
  • p_new_ele_name : Agency Element
  • p_pb_enabled : Field which helps enable Pay Basis for Basic Salary Rate
  • p_pay_basis : Pay Basis for example Annual, Monthly, Hourly

 

PGGM Pension Extracts (Electronic Notification)

 

NAME: PGGM Pension Extracts (Electronic Notification)
SHORT CODE: PQPNLPGEFN
MODULE: Oracle Public Sector Payroll

Description: PGGM Pension Extracts (Electronic Notification)
Navigation: Oracle Public Sector Payroll 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_ext_dfn_id : Extract Name
  • p_org_id : Organization Name
  • p_payroll_id : Payroll Name
  • p_start_date : Date From
  • p_end_date : Date To
  • p_extract_type : Extract Type
  • p_business_group_id : Business Group
  • p_consolidation_set : Consolidation Set