NAME: Extract Thread
SHORT CODE: BENXTHRD
MODULE: Oracle Advanced Benefits

Description: Benefits Extract Thread
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_ext_dfn_id : Extract Name
• p_thread_id : Thread
• p_effective_date : Effective Date
• p_business_group_id : Business Group
• p_data_typ_cd : Data Type
• p_ext_typ_cd : Extract Type
• p_ext_crit_prfl_id : Criteria Profile
• p_ext_rslt_id : Result
• p_ext_file_id : File
• p_ext_strt_dt : Start Date
• p_ext_end_dt : End Date
• p_prmy_sort_cd : Primary Sort
• p_scnd_sort_cd : Secondary Sort
• p_output_name : Output File
• p_apnd_rqst_id_flag : Append Request
• p_request_id : Request Id
• p_use_eff_dt_for_chgs_flag : Change Flag
• p_master_process_flag : Master Process Flag
• p_eff_start_date : Effective Start Date
• p_eff_end_date : Effective End Date
• p_act_start_date : Actual Start Date
• p_act_end_date : Actual End Date
• p_penserv_mode : Penserver Mode