1: PACKAGE per_qh_summary_query as
2: /* $Header: peqhsumq.pkh 120.1 2005/12/29 05:39:09 rvarshne noship $ */
3:
4: type sumrec is RECORD
5: (person_id per_all_people_f.person_id%type
6: ,business_group_name per_business_groups.name%type
7: ,per_effective_start_date per_all_people_f.effective_start_date%type
8: ,per_effective_end_date per_all_people_f.effective_end_date%type
9: ,person_type varchar2(240)
3:
4: type sumrec is RECORD
5: (person_id per_all_people_f.person_id%type
6: ,business_group_name per_business_groups.name%type
7: ,per_effective_start_date per_all_people_f.effective_start_date%type
8: ,per_effective_end_date per_all_people_f.effective_end_date%type
9: ,person_type varchar2(240)
10: ,system_person_type per_person_types.system_person_type%type
11: ,last_name per_all_people_f.last_name%type
4: type sumrec is RECORD
5: (person_id per_all_people_f.person_id%type
6: ,business_group_name per_business_groups.name%type
7: ,per_effective_start_date per_all_people_f.effective_start_date%type
8: ,per_effective_end_date per_all_people_f.effective_end_date%type
9: ,person_type varchar2(240)
10: ,system_person_type per_person_types.system_person_type%type
11: ,last_name per_all_people_f.last_name%type
12: ,start_date per_all_people_f.start_date%type
7: ,per_effective_start_date per_all_people_f.effective_start_date%type
8: ,per_effective_end_date per_all_people_f.effective_end_date%type
9: ,person_type varchar2(240)
10: ,system_person_type per_person_types.system_person_type%type
11: ,last_name per_all_people_f.last_name%type
12: ,start_date per_all_people_f.start_date%type
13: ,applicant_number per_all_people_f.applicant_number%type
14: ,background_check_status per_all_people_f.background_check_status%type
15: ,background_date_check per_all_people_f.background_date_check%type
8: ,per_effective_end_date per_all_people_f.effective_end_date%type
9: ,person_type varchar2(240)
10: ,system_person_type per_person_types.system_person_type%type
11: ,last_name per_all_people_f.last_name%type
12: ,start_date per_all_people_f.start_date%type
13: ,applicant_number per_all_people_f.applicant_number%type
14: ,background_check_status per_all_people_f.background_check_status%type
15: ,background_date_check per_all_people_f.background_date_check%type
16: ,blood_type_meaning hr_lookups.meaning%type
9: ,person_type varchar2(240)
10: ,system_person_type per_person_types.system_person_type%type
11: ,last_name per_all_people_f.last_name%type
12: ,start_date per_all_people_f.start_date%type
13: ,applicant_number per_all_people_f.applicant_number%type
14: ,background_check_status per_all_people_f.background_check_status%type
15: ,background_date_check per_all_people_f.background_date_check%type
16: ,blood_type_meaning hr_lookups.meaning%type
17: ,corr_lang_meaning hr_lookups.meaning%type
10: ,system_person_type per_person_types.system_person_type%type
11: ,last_name per_all_people_f.last_name%type
12: ,start_date per_all_people_f.start_date%type
13: ,applicant_number per_all_people_f.applicant_number%type
14: ,background_check_status per_all_people_f.background_check_status%type
15: ,background_date_check per_all_people_f.background_date_check%type
16: ,blood_type_meaning hr_lookups.meaning%type
17: ,corr_lang_meaning hr_lookups.meaning%type
18: --CWK
11: ,last_name per_all_people_f.last_name%type
12: ,start_date per_all_people_f.start_date%type
13: ,applicant_number per_all_people_f.applicant_number%type
14: ,background_check_status per_all_people_f.background_check_status%type
15: ,background_date_check per_all_people_f.background_date_check%type
16: ,blood_type_meaning hr_lookups.meaning%type
17: ,corr_lang_meaning hr_lookups.meaning%type
18: --CWK
19: ,npw_number per_all_people_f.npw_number%type
15: ,background_date_check per_all_people_f.background_date_check%type
16: ,blood_type_meaning hr_lookups.meaning%type
17: ,corr_lang_meaning hr_lookups.meaning%type
18: --CWK
19: ,npw_number per_all_people_f.npw_number%type
20: ,period_of_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
21: ,projected_assignment_end per_all_assignments_f.projected_assignment_end%type
22: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type
23: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type
26: ,po_header_num po_headers_all.segment1%TYPE
27: ,po_line_num po_lines_all.line_num%TYPE
28: ,project_title per_all_assignments_f.project_title%type
29: --
30: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
31: ,date_of_birth per_all_people_f.date_of_birth%type
32: ,age number
33: ,email_address per_all_people_f.email_address%type
34: ,employee_number per_all_people_f.employee_number%type
27: ,po_line_num po_lines_all.line_num%TYPE
28: ,project_title per_all_assignments_f.project_title%type
29: --
30: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
31: ,date_of_birth per_all_people_f.date_of_birth%type
32: ,age number
33: ,email_address per_all_people_f.email_address%type
34: ,employee_number per_all_people_f.employee_number%type
35: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
29: --
30: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
31: ,date_of_birth per_all_people_f.date_of_birth%type
32: ,age number
33: ,email_address per_all_people_f.email_address%type
34: ,employee_number per_all_people_f.employee_number%type
35: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
36: ,first_name per_all_people_f.first_name%type
37: ,per_fte_capacity per_all_people_f.fte_capacity%type
30: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
31: ,date_of_birth per_all_people_f.date_of_birth%type
32: ,age number
33: ,email_address per_all_people_f.email_address%type
34: ,employee_number per_all_people_f.employee_number%type
35: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
36: ,first_name per_all_people_f.first_name%type
37: ,per_fte_capacity per_all_people_f.fte_capacity%type
38: ,full_name per_all_people_f.full_name%type
32: ,age number
33: ,email_address per_all_people_f.email_address%type
34: ,employee_number per_all_people_f.employee_number%type
35: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
36: ,first_name per_all_people_f.first_name%type
37: ,per_fte_capacity per_all_people_f.fte_capacity%type
38: ,full_name per_all_people_f.full_name%type
39: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
40: ,honors per_all_people_f.honors%type
33: ,email_address per_all_people_f.email_address%type
34: ,employee_number per_all_people_f.employee_number%type
35: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
36: ,first_name per_all_people_f.first_name%type
37: ,per_fte_capacity per_all_people_f.fte_capacity%type
38: ,full_name per_all_people_f.full_name%type
39: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
40: ,honors per_all_people_f.honors%type
41: ,internal_location per_all_people_f.internal_location%type
34: ,employee_number per_all_people_f.employee_number%type
35: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
36: ,first_name per_all_people_f.first_name%type
37: ,per_fte_capacity per_all_people_f.fte_capacity%type
38: ,full_name per_all_people_f.full_name%type
39: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
40: ,honors per_all_people_f.honors%type
41: ,internal_location per_all_people_f.internal_location%type
42: ,known_as per_all_people_f.known_as%type
35: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
36: ,first_name per_all_people_f.first_name%type
37: ,per_fte_capacity per_all_people_f.fte_capacity%type
38: ,full_name per_all_people_f.full_name%type
39: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
40: ,honors per_all_people_f.honors%type
41: ,internal_location per_all_people_f.internal_location%type
42: ,known_as per_all_people_f.known_as%type
43: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
36: ,first_name per_all_people_f.first_name%type
37: ,per_fte_capacity per_all_people_f.fte_capacity%type
38: ,full_name per_all_people_f.full_name%type
39: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
40: ,honors per_all_people_f.honors%type
41: ,internal_location per_all_people_f.internal_location%type
42: ,known_as per_all_people_f.known_as%type
43: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
44: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
37: ,per_fte_capacity per_all_people_f.fte_capacity%type
38: ,full_name per_all_people_f.full_name%type
39: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
40: ,honors per_all_people_f.honors%type
41: ,internal_location per_all_people_f.internal_location%type
42: ,known_as per_all_people_f.known_as%type
43: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
44: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
45: ,mailstop per_all_people_f.mailstop%type
38: ,full_name per_all_people_f.full_name%type
39: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
40: ,honors per_all_people_f.honors%type
41: ,internal_location per_all_people_f.internal_location%type
42: ,known_as per_all_people_f.known_as%type
43: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
44: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
45: ,mailstop per_all_people_f.mailstop%type
46: ,marital_status_meaning hr_lookups.meaning%type
39: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
40: ,honors per_all_people_f.honors%type
41: ,internal_location per_all_people_f.internal_location%type
42: ,known_as per_all_people_f.known_as%type
43: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
44: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
45: ,mailstop per_all_people_f.mailstop%type
46: ,marital_status_meaning hr_lookups.meaning%type
47: ,middle_names per_all_people_f.middle_names%type
40: ,honors per_all_people_f.honors%type
41: ,internal_location per_all_people_f.internal_location%type
42: ,known_as per_all_people_f.known_as%type
43: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
44: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
45: ,mailstop per_all_people_f.mailstop%type
46: ,marital_status_meaning hr_lookups.meaning%type
47: ,middle_names per_all_people_f.middle_names%type
48: ,nationality_meaning hr_lookups.meaning%type
41: ,internal_location per_all_people_f.internal_location%type
42: ,known_as per_all_people_f.known_as%type
43: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
44: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
45: ,mailstop per_all_people_f.mailstop%type
46: ,marital_status_meaning hr_lookups.meaning%type
47: ,middle_names per_all_people_f.middle_names%type
48: ,nationality_meaning hr_lookups.meaning%type
49: ,national_identifier per_all_people_f.national_identifier%type
43: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
44: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
45: ,mailstop per_all_people_f.mailstop%type
46: ,marital_status_meaning hr_lookups.meaning%type
47: ,middle_names per_all_people_f.middle_names%type
48: ,nationality_meaning hr_lookups.meaning%type
49: ,national_identifier per_all_people_f.national_identifier%type
50: ,office_number per_all_people_f.office_number%type
51: ,on_military_service per_all_people_f.on_military_service%type
45: ,mailstop per_all_people_f.mailstop%type
46: ,marital_status_meaning hr_lookups.meaning%type
47: ,middle_names per_all_people_f.middle_names%type
48: ,nationality_meaning hr_lookups.meaning%type
49: ,national_identifier per_all_people_f.national_identifier%type
50: ,office_number per_all_people_f.office_number%type
51: ,on_military_service per_all_people_f.on_military_service%type
52: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
53: ,previous_last_name per_all_people_f.previous_last_name%type
46: ,marital_status_meaning hr_lookups.meaning%type
47: ,middle_names per_all_people_f.middle_names%type
48: ,nationality_meaning hr_lookups.meaning%type
49: ,national_identifier per_all_people_f.national_identifier%type
50: ,office_number per_all_people_f.office_number%type
51: ,on_military_service per_all_people_f.on_military_service%type
52: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
53: ,previous_last_name per_all_people_f.previous_last_name%type
54: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
47: ,middle_names per_all_people_f.middle_names%type
48: ,nationality_meaning hr_lookups.meaning%type
49: ,national_identifier per_all_people_f.national_identifier%type
50: ,office_number per_all_people_f.office_number%type
51: ,on_military_service per_all_people_f.on_military_service%type
52: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
53: ,previous_last_name per_all_people_f.previous_last_name%type
54: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
55: ,rehire_reason per_all_people_f.rehire_reason%type
48: ,nationality_meaning hr_lookups.meaning%type
49: ,national_identifier per_all_people_f.national_identifier%type
50: ,office_number per_all_people_f.office_number%type
51: ,on_military_service per_all_people_f.on_military_service%type
52: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
53: ,previous_last_name per_all_people_f.previous_last_name%type
54: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
55: ,rehire_reason per_all_people_f.rehire_reason%type
56: ,resume_exists per_all_people_f.resume_exists%type
49: ,national_identifier per_all_people_f.national_identifier%type
50: ,office_number per_all_people_f.office_number%type
51: ,on_military_service per_all_people_f.on_military_service%type
52: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
53: ,previous_last_name per_all_people_f.previous_last_name%type
54: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
55: ,rehire_reason per_all_people_f.rehire_reason%type
56: ,resume_exists per_all_people_f.resume_exists%type
57: ,resume_last_updated per_all_people_f.resume_last_updated%type
50: ,office_number per_all_people_f.office_number%type
51: ,on_military_service per_all_people_f.on_military_service%type
52: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
53: ,previous_last_name per_all_people_f.previous_last_name%type
54: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
55: ,rehire_reason per_all_people_f.rehire_reason%type
56: ,resume_exists per_all_people_f.resume_exists%type
57: ,resume_last_updated per_all_people_f.resume_last_updated%type
58: -- Bug 3037019
51: ,on_military_service per_all_people_f.on_military_service%type
52: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
53: ,previous_last_name per_all_people_f.previous_last_name%type
54: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
55: ,rehire_reason per_all_people_f.rehire_reason%type
56: ,resume_exists per_all_people_f.resume_exists%type
57: ,resume_last_updated per_all_people_f.resume_last_updated%type
58: -- Bug 3037019
59: ,registered_disabled_flag hr_lookups.meaning%type
52: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
53: ,previous_last_name per_all_people_f.previous_last_name%type
54: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
55: ,rehire_reason per_all_people_f.rehire_reason%type
56: ,resume_exists per_all_people_f.resume_exists%type
57: ,resume_last_updated per_all_people_f.resume_last_updated%type
58: -- Bug 3037019
59: ,registered_disabled_flag hr_lookups.meaning%type
60: ,second_passport_exists per_all_people_f.second_passport_exists%type
53: ,previous_last_name per_all_people_f.previous_last_name%type
54: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
55: ,rehire_reason per_all_people_f.rehire_reason%type
56: ,resume_exists per_all_people_f.resume_exists%type
57: ,resume_last_updated per_all_people_f.resume_last_updated%type
58: -- Bug 3037019
59: ,registered_disabled_flag hr_lookups.meaning%type
60: ,second_passport_exists per_all_people_f.second_passport_exists%type
61: ,sex per_all_people_f.sex%type
56: ,resume_exists per_all_people_f.resume_exists%type
57: ,resume_last_updated per_all_people_f.resume_last_updated%type
58: -- Bug 3037019
59: ,registered_disabled_flag hr_lookups.meaning%type
60: ,second_passport_exists per_all_people_f.second_passport_exists%type
61: ,sex per_all_people_f.sex%type
62: ,sex_meaning hr_lookups.meaning%type
63: ,student_status_meaning hr_lookups.meaning%type
64: ,suffix per_all_people_f.suffix%type
57: ,resume_last_updated per_all_people_f.resume_last_updated%type
58: -- Bug 3037019
59: ,registered_disabled_flag hr_lookups.meaning%type
60: ,second_passport_exists per_all_people_f.second_passport_exists%type
61: ,sex per_all_people_f.sex%type
62: ,sex_meaning hr_lookups.meaning%type
63: ,student_status_meaning hr_lookups.meaning%type
64: ,suffix per_all_people_f.suffix%type
65: ,title_meaning hr_lookups.meaning%type
60: ,second_passport_exists per_all_people_f.second_passport_exists%type
61: ,sex per_all_people_f.sex%type
62: ,sex_meaning hr_lookups.meaning%type
63: ,student_status_meaning hr_lookups.meaning%type
64: ,suffix per_all_people_f.suffix%type
65: ,title_meaning hr_lookups.meaning%type
66: ,work_schedule_meaning hr_lookups.meaning%type
67: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
68: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
63: ,student_status_meaning hr_lookups.meaning%type
64: ,suffix per_all_people_f.suffix%type
65: ,title_meaning hr_lookups.meaning%type
66: ,work_schedule_meaning hr_lookups.meaning%type
67: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
68: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
69: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
70: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
71: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
64: ,suffix per_all_people_f.suffix%type
65: ,title_meaning hr_lookups.meaning%type
66: ,work_schedule_meaning hr_lookups.meaning%type
67: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
68: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
69: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
70: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
71: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
72: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
65: ,title_meaning hr_lookups.meaning%type
66: ,work_schedule_meaning hr_lookups.meaning%type
67: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
68: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
69: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
70: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
71: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
72: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
73: ,benefit_group ben_benfts_grp.name%type
66: ,work_schedule_meaning hr_lookups.meaning%type
67: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
68: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
69: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
70: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
71: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
72: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
73: ,benefit_group ben_benfts_grp.name%type
74: ,attribute_category per_all_people_f.attribute_category%type
67: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
68: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
69: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
70: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
71: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
72: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
73: ,benefit_group ben_benfts_grp.name%type
74: ,attribute_category per_all_people_f.attribute_category%type
75: ,attribute1 per_all_people_f.attribute1%type
68: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
69: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
70: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
71: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
72: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
73: ,benefit_group ben_benfts_grp.name%type
74: ,attribute_category per_all_people_f.attribute_category%type
75: ,attribute1 per_all_people_f.attribute1%type
76: ,attribute2 per_all_people_f.attribute2%type
70: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
71: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
72: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
73: ,benefit_group ben_benfts_grp.name%type
74: ,attribute_category per_all_people_f.attribute_category%type
75: ,attribute1 per_all_people_f.attribute1%type
76: ,attribute2 per_all_people_f.attribute2%type
77: ,attribute3 per_all_people_f.attribute3%type
78: ,attribute4 per_all_people_f.attribute4%type
71: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
72: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
73: ,benefit_group ben_benfts_grp.name%type
74: ,attribute_category per_all_people_f.attribute_category%type
75: ,attribute1 per_all_people_f.attribute1%type
76: ,attribute2 per_all_people_f.attribute2%type
77: ,attribute3 per_all_people_f.attribute3%type
78: ,attribute4 per_all_people_f.attribute4%type
79: ,attribute5 per_all_people_f.attribute5%type
72: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
73: ,benefit_group ben_benfts_grp.name%type
74: ,attribute_category per_all_people_f.attribute_category%type
75: ,attribute1 per_all_people_f.attribute1%type
76: ,attribute2 per_all_people_f.attribute2%type
77: ,attribute3 per_all_people_f.attribute3%type
78: ,attribute4 per_all_people_f.attribute4%type
79: ,attribute5 per_all_people_f.attribute5%type
80: ,attribute6 per_all_people_f.attribute6%type
73: ,benefit_group ben_benfts_grp.name%type
74: ,attribute_category per_all_people_f.attribute_category%type
75: ,attribute1 per_all_people_f.attribute1%type
76: ,attribute2 per_all_people_f.attribute2%type
77: ,attribute3 per_all_people_f.attribute3%type
78: ,attribute4 per_all_people_f.attribute4%type
79: ,attribute5 per_all_people_f.attribute5%type
80: ,attribute6 per_all_people_f.attribute6%type
81: ,attribute7 per_all_people_f.attribute7%type
74: ,attribute_category per_all_people_f.attribute_category%type
75: ,attribute1 per_all_people_f.attribute1%type
76: ,attribute2 per_all_people_f.attribute2%type
77: ,attribute3 per_all_people_f.attribute3%type
78: ,attribute4 per_all_people_f.attribute4%type
79: ,attribute5 per_all_people_f.attribute5%type
80: ,attribute6 per_all_people_f.attribute6%type
81: ,attribute7 per_all_people_f.attribute7%type
82: ,attribute8 per_all_people_f.attribute8%type
75: ,attribute1 per_all_people_f.attribute1%type
76: ,attribute2 per_all_people_f.attribute2%type
77: ,attribute3 per_all_people_f.attribute3%type
78: ,attribute4 per_all_people_f.attribute4%type
79: ,attribute5 per_all_people_f.attribute5%type
80: ,attribute6 per_all_people_f.attribute6%type
81: ,attribute7 per_all_people_f.attribute7%type
82: ,attribute8 per_all_people_f.attribute8%type
83: ,attribute9 per_all_people_f.attribute9%type
76: ,attribute2 per_all_people_f.attribute2%type
77: ,attribute3 per_all_people_f.attribute3%type
78: ,attribute4 per_all_people_f.attribute4%type
79: ,attribute5 per_all_people_f.attribute5%type
80: ,attribute6 per_all_people_f.attribute6%type
81: ,attribute7 per_all_people_f.attribute7%type
82: ,attribute8 per_all_people_f.attribute8%type
83: ,attribute9 per_all_people_f.attribute9%type
84: ,attribute10 per_all_people_f.attribute10%type
77: ,attribute3 per_all_people_f.attribute3%type
78: ,attribute4 per_all_people_f.attribute4%type
79: ,attribute5 per_all_people_f.attribute5%type
80: ,attribute6 per_all_people_f.attribute6%type
81: ,attribute7 per_all_people_f.attribute7%type
82: ,attribute8 per_all_people_f.attribute8%type
83: ,attribute9 per_all_people_f.attribute9%type
84: ,attribute10 per_all_people_f.attribute10%type
85: ,attribute11 per_all_people_f.attribute11%type
78: ,attribute4 per_all_people_f.attribute4%type
79: ,attribute5 per_all_people_f.attribute5%type
80: ,attribute6 per_all_people_f.attribute6%type
81: ,attribute7 per_all_people_f.attribute7%type
82: ,attribute8 per_all_people_f.attribute8%type
83: ,attribute9 per_all_people_f.attribute9%type
84: ,attribute10 per_all_people_f.attribute10%type
85: ,attribute11 per_all_people_f.attribute11%type
86: ,attribute12 per_all_people_f.attribute12%type
79: ,attribute5 per_all_people_f.attribute5%type
80: ,attribute6 per_all_people_f.attribute6%type
81: ,attribute7 per_all_people_f.attribute7%type
82: ,attribute8 per_all_people_f.attribute8%type
83: ,attribute9 per_all_people_f.attribute9%type
84: ,attribute10 per_all_people_f.attribute10%type
85: ,attribute11 per_all_people_f.attribute11%type
86: ,attribute12 per_all_people_f.attribute12%type
87: ,attribute13 per_all_people_f.attribute13%type
80: ,attribute6 per_all_people_f.attribute6%type
81: ,attribute7 per_all_people_f.attribute7%type
82: ,attribute8 per_all_people_f.attribute8%type
83: ,attribute9 per_all_people_f.attribute9%type
84: ,attribute10 per_all_people_f.attribute10%type
85: ,attribute11 per_all_people_f.attribute11%type
86: ,attribute12 per_all_people_f.attribute12%type
87: ,attribute13 per_all_people_f.attribute13%type
88: ,attribute14 per_all_people_f.attribute14%type
81: ,attribute7 per_all_people_f.attribute7%type
82: ,attribute8 per_all_people_f.attribute8%type
83: ,attribute9 per_all_people_f.attribute9%type
84: ,attribute10 per_all_people_f.attribute10%type
85: ,attribute11 per_all_people_f.attribute11%type
86: ,attribute12 per_all_people_f.attribute12%type
87: ,attribute13 per_all_people_f.attribute13%type
88: ,attribute14 per_all_people_f.attribute14%type
89: ,attribute15 per_all_people_f.attribute15%type
82: ,attribute8 per_all_people_f.attribute8%type
83: ,attribute9 per_all_people_f.attribute9%type
84: ,attribute10 per_all_people_f.attribute10%type
85: ,attribute11 per_all_people_f.attribute11%type
86: ,attribute12 per_all_people_f.attribute12%type
87: ,attribute13 per_all_people_f.attribute13%type
88: ,attribute14 per_all_people_f.attribute14%type
89: ,attribute15 per_all_people_f.attribute15%type
90: ,attribute16 per_all_people_f.attribute16%type
83: ,attribute9 per_all_people_f.attribute9%type
84: ,attribute10 per_all_people_f.attribute10%type
85: ,attribute11 per_all_people_f.attribute11%type
86: ,attribute12 per_all_people_f.attribute12%type
87: ,attribute13 per_all_people_f.attribute13%type
88: ,attribute14 per_all_people_f.attribute14%type
89: ,attribute15 per_all_people_f.attribute15%type
90: ,attribute16 per_all_people_f.attribute16%type
91: ,attribute17 per_all_people_f.attribute17%type
84: ,attribute10 per_all_people_f.attribute10%type
85: ,attribute11 per_all_people_f.attribute11%type
86: ,attribute12 per_all_people_f.attribute12%type
87: ,attribute13 per_all_people_f.attribute13%type
88: ,attribute14 per_all_people_f.attribute14%type
89: ,attribute15 per_all_people_f.attribute15%type
90: ,attribute16 per_all_people_f.attribute16%type
91: ,attribute17 per_all_people_f.attribute17%type
92: ,attribute18 per_all_people_f.attribute18%type
85: ,attribute11 per_all_people_f.attribute11%type
86: ,attribute12 per_all_people_f.attribute12%type
87: ,attribute13 per_all_people_f.attribute13%type
88: ,attribute14 per_all_people_f.attribute14%type
89: ,attribute15 per_all_people_f.attribute15%type
90: ,attribute16 per_all_people_f.attribute16%type
91: ,attribute17 per_all_people_f.attribute17%type
92: ,attribute18 per_all_people_f.attribute18%type
93: ,attribute19 per_all_people_f.attribute19%type
86: ,attribute12 per_all_people_f.attribute12%type
87: ,attribute13 per_all_people_f.attribute13%type
88: ,attribute14 per_all_people_f.attribute14%type
89: ,attribute15 per_all_people_f.attribute15%type
90: ,attribute16 per_all_people_f.attribute16%type
91: ,attribute17 per_all_people_f.attribute17%type
92: ,attribute18 per_all_people_f.attribute18%type
93: ,attribute19 per_all_people_f.attribute19%type
94: ,attribute20 per_all_people_f.attribute20%type
87: ,attribute13 per_all_people_f.attribute13%type
88: ,attribute14 per_all_people_f.attribute14%type
89: ,attribute15 per_all_people_f.attribute15%type
90: ,attribute16 per_all_people_f.attribute16%type
91: ,attribute17 per_all_people_f.attribute17%type
92: ,attribute18 per_all_people_f.attribute18%type
93: ,attribute19 per_all_people_f.attribute19%type
94: ,attribute20 per_all_people_f.attribute20%type
95: ,attribute21 per_all_people_f.attribute21%type
88: ,attribute14 per_all_people_f.attribute14%type
89: ,attribute15 per_all_people_f.attribute15%type
90: ,attribute16 per_all_people_f.attribute16%type
91: ,attribute17 per_all_people_f.attribute17%type
92: ,attribute18 per_all_people_f.attribute18%type
93: ,attribute19 per_all_people_f.attribute19%type
94: ,attribute20 per_all_people_f.attribute20%type
95: ,attribute21 per_all_people_f.attribute21%type
96: ,attribute22 per_all_people_f.attribute22%type
89: ,attribute15 per_all_people_f.attribute15%type
90: ,attribute16 per_all_people_f.attribute16%type
91: ,attribute17 per_all_people_f.attribute17%type
92: ,attribute18 per_all_people_f.attribute18%type
93: ,attribute19 per_all_people_f.attribute19%type
94: ,attribute20 per_all_people_f.attribute20%type
95: ,attribute21 per_all_people_f.attribute21%type
96: ,attribute22 per_all_people_f.attribute22%type
97: ,attribute23 per_all_people_f.attribute23%type
90: ,attribute16 per_all_people_f.attribute16%type
91: ,attribute17 per_all_people_f.attribute17%type
92: ,attribute18 per_all_people_f.attribute18%type
93: ,attribute19 per_all_people_f.attribute19%type
94: ,attribute20 per_all_people_f.attribute20%type
95: ,attribute21 per_all_people_f.attribute21%type
96: ,attribute22 per_all_people_f.attribute22%type
97: ,attribute23 per_all_people_f.attribute23%type
98: ,attribute24 per_all_people_f.attribute24%type
91: ,attribute17 per_all_people_f.attribute17%type
92: ,attribute18 per_all_people_f.attribute18%type
93: ,attribute19 per_all_people_f.attribute19%type
94: ,attribute20 per_all_people_f.attribute20%type
95: ,attribute21 per_all_people_f.attribute21%type
96: ,attribute22 per_all_people_f.attribute22%type
97: ,attribute23 per_all_people_f.attribute23%type
98: ,attribute24 per_all_people_f.attribute24%type
99: ,attribute25 per_all_people_f.attribute25%type
92: ,attribute18 per_all_people_f.attribute18%type
93: ,attribute19 per_all_people_f.attribute19%type
94: ,attribute20 per_all_people_f.attribute20%type
95: ,attribute21 per_all_people_f.attribute21%type
96: ,attribute22 per_all_people_f.attribute22%type
97: ,attribute23 per_all_people_f.attribute23%type
98: ,attribute24 per_all_people_f.attribute24%type
99: ,attribute25 per_all_people_f.attribute25%type
100: ,attribute26 per_all_people_f.attribute26%type
93: ,attribute19 per_all_people_f.attribute19%type
94: ,attribute20 per_all_people_f.attribute20%type
95: ,attribute21 per_all_people_f.attribute21%type
96: ,attribute22 per_all_people_f.attribute22%type
97: ,attribute23 per_all_people_f.attribute23%type
98: ,attribute24 per_all_people_f.attribute24%type
99: ,attribute25 per_all_people_f.attribute25%type
100: ,attribute26 per_all_people_f.attribute26%type
101: ,attribute27 per_all_people_f.attribute27%type
94: ,attribute20 per_all_people_f.attribute20%type
95: ,attribute21 per_all_people_f.attribute21%type
96: ,attribute22 per_all_people_f.attribute22%type
97: ,attribute23 per_all_people_f.attribute23%type
98: ,attribute24 per_all_people_f.attribute24%type
99: ,attribute25 per_all_people_f.attribute25%type
100: ,attribute26 per_all_people_f.attribute26%type
101: ,attribute27 per_all_people_f.attribute27%type
102: ,attribute28 per_all_people_f.attribute28%type
95: ,attribute21 per_all_people_f.attribute21%type
96: ,attribute22 per_all_people_f.attribute22%type
97: ,attribute23 per_all_people_f.attribute23%type
98: ,attribute24 per_all_people_f.attribute24%type
99: ,attribute25 per_all_people_f.attribute25%type
100: ,attribute26 per_all_people_f.attribute26%type
101: ,attribute27 per_all_people_f.attribute27%type
102: ,attribute28 per_all_people_f.attribute28%type
103: ,attribute29 per_all_people_f.attribute29%type
96: ,attribute22 per_all_people_f.attribute22%type
97: ,attribute23 per_all_people_f.attribute23%type
98: ,attribute24 per_all_people_f.attribute24%type
99: ,attribute25 per_all_people_f.attribute25%type
100: ,attribute26 per_all_people_f.attribute26%type
101: ,attribute27 per_all_people_f.attribute27%type
102: ,attribute28 per_all_people_f.attribute28%type
103: ,attribute29 per_all_people_f.attribute29%type
104: ,attribute30 per_all_people_f.attribute30%type
97: ,attribute23 per_all_people_f.attribute23%type
98: ,attribute24 per_all_people_f.attribute24%type
99: ,attribute25 per_all_people_f.attribute25%type
100: ,attribute26 per_all_people_f.attribute26%type
101: ,attribute27 per_all_people_f.attribute27%type
102: ,attribute28 per_all_people_f.attribute28%type
103: ,attribute29 per_all_people_f.attribute29%type
104: ,attribute30 per_all_people_f.attribute30%type
105: ,per_information_category per_all_people_f.per_information_category%type
98: ,attribute24 per_all_people_f.attribute24%type
99: ,attribute25 per_all_people_f.attribute25%type
100: ,attribute26 per_all_people_f.attribute26%type
101: ,attribute27 per_all_people_f.attribute27%type
102: ,attribute28 per_all_people_f.attribute28%type
103: ,attribute29 per_all_people_f.attribute29%type
104: ,attribute30 per_all_people_f.attribute30%type
105: ,per_information_category per_all_people_f.per_information_category%type
106: ,per_information1 per_all_people_f.attribute1%type
99: ,attribute25 per_all_people_f.attribute25%type
100: ,attribute26 per_all_people_f.attribute26%type
101: ,attribute27 per_all_people_f.attribute27%type
102: ,attribute28 per_all_people_f.attribute28%type
103: ,attribute29 per_all_people_f.attribute29%type
104: ,attribute30 per_all_people_f.attribute30%type
105: ,per_information_category per_all_people_f.per_information_category%type
106: ,per_information1 per_all_people_f.attribute1%type
107: ,per_information2 per_all_people_f.attribute2%type
100: ,attribute26 per_all_people_f.attribute26%type
101: ,attribute27 per_all_people_f.attribute27%type
102: ,attribute28 per_all_people_f.attribute28%type
103: ,attribute29 per_all_people_f.attribute29%type
104: ,attribute30 per_all_people_f.attribute30%type
105: ,per_information_category per_all_people_f.per_information_category%type
106: ,per_information1 per_all_people_f.attribute1%type
107: ,per_information2 per_all_people_f.attribute2%type
108: ,per_information3 per_all_people_f.attribute3%type
101: ,attribute27 per_all_people_f.attribute27%type
102: ,attribute28 per_all_people_f.attribute28%type
103: ,attribute29 per_all_people_f.attribute29%type
104: ,attribute30 per_all_people_f.attribute30%type
105: ,per_information_category per_all_people_f.per_information_category%type
106: ,per_information1 per_all_people_f.attribute1%type
107: ,per_information2 per_all_people_f.attribute2%type
108: ,per_information3 per_all_people_f.attribute3%type
109: ,per_information4 per_all_people_f.attribute4%type
102: ,attribute28 per_all_people_f.attribute28%type
103: ,attribute29 per_all_people_f.attribute29%type
104: ,attribute30 per_all_people_f.attribute30%type
105: ,per_information_category per_all_people_f.per_information_category%type
106: ,per_information1 per_all_people_f.attribute1%type
107: ,per_information2 per_all_people_f.attribute2%type
108: ,per_information3 per_all_people_f.attribute3%type
109: ,per_information4 per_all_people_f.attribute4%type
110: ,per_information5 per_all_people_f.attribute5%type
103: ,attribute29 per_all_people_f.attribute29%type
104: ,attribute30 per_all_people_f.attribute30%type
105: ,per_information_category per_all_people_f.per_information_category%type
106: ,per_information1 per_all_people_f.attribute1%type
107: ,per_information2 per_all_people_f.attribute2%type
108: ,per_information3 per_all_people_f.attribute3%type
109: ,per_information4 per_all_people_f.attribute4%type
110: ,per_information5 per_all_people_f.attribute5%type
111: ,per_information6 per_all_people_f.attribute6%type
104: ,attribute30 per_all_people_f.attribute30%type
105: ,per_information_category per_all_people_f.per_information_category%type
106: ,per_information1 per_all_people_f.attribute1%type
107: ,per_information2 per_all_people_f.attribute2%type
108: ,per_information3 per_all_people_f.attribute3%type
109: ,per_information4 per_all_people_f.attribute4%type
110: ,per_information5 per_all_people_f.attribute5%type
111: ,per_information6 per_all_people_f.attribute6%type
112: ,per_information7 per_all_people_f.attribute7%type
105: ,per_information_category per_all_people_f.per_information_category%type
106: ,per_information1 per_all_people_f.attribute1%type
107: ,per_information2 per_all_people_f.attribute2%type
108: ,per_information3 per_all_people_f.attribute3%type
109: ,per_information4 per_all_people_f.attribute4%type
110: ,per_information5 per_all_people_f.attribute5%type
111: ,per_information6 per_all_people_f.attribute6%type
112: ,per_information7 per_all_people_f.attribute7%type
113: ,per_information8 per_all_people_f.attribute8%type
106: ,per_information1 per_all_people_f.attribute1%type
107: ,per_information2 per_all_people_f.attribute2%type
108: ,per_information3 per_all_people_f.attribute3%type
109: ,per_information4 per_all_people_f.attribute4%type
110: ,per_information5 per_all_people_f.attribute5%type
111: ,per_information6 per_all_people_f.attribute6%type
112: ,per_information7 per_all_people_f.attribute7%type
113: ,per_information8 per_all_people_f.attribute8%type
114: ,per_information9 per_all_people_f.attribute9%type
107: ,per_information2 per_all_people_f.attribute2%type
108: ,per_information3 per_all_people_f.attribute3%type
109: ,per_information4 per_all_people_f.attribute4%type
110: ,per_information5 per_all_people_f.attribute5%type
111: ,per_information6 per_all_people_f.attribute6%type
112: ,per_information7 per_all_people_f.attribute7%type
113: ,per_information8 per_all_people_f.attribute8%type
114: ,per_information9 per_all_people_f.attribute9%type
115: ,per_information10 per_all_people_f.attribute10%type
108: ,per_information3 per_all_people_f.attribute3%type
109: ,per_information4 per_all_people_f.attribute4%type
110: ,per_information5 per_all_people_f.attribute5%type
111: ,per_information6 per_all_people_f.attribute6%type
112: ,per_information7 per_all_people_f.attribute7%type
113: ,per_information8 per_all_people_f.attribute8%type
114: ,per_information9 per_all_people_f.attribute9%type
115: ,per_information10 per_all_people_f.attribute10%type
116: ,per_information11 per_all_people_f.attribute11%type
109: ,per_information4 per_all_people_f.attribute4%type
110: ,per_information5 per_all_people_f.attribute5%type
111: ,per_information6 per_all_people_f.attribute6%type
112: ,per_information7 per_all_people_f.attribute7%type
113: ,per_information8 per_all_people_f.attribute8%type
114: ,per_information9 per_all_people_f.attribute9%type
115: ,per_information10 per_all_people_f.attribute10%type
116: ,per_information11 per_all_people_f.attribute11%type
117: ,per_information12 per_all_people_f.attribute12%type
110: ,per_information5 per_all_people_f.attribute5%type
111: ,per_information6 per_all_people_f.attribute6%type
112: ,per_information7 per_all_people_f.attribute7%type
113: ,per_information8 per_all_people_f.attribute8%type
114: ,per_information9 per_all_people_f.attribute9%type
115: ,per_information10 per_all_people_f.attribute10%type
116: ,per_information11 per_all_people_f.attribute11%type
117: ,per_information12 per_all_people_f.attribute12%type
118: ,per_information13 per_all_people_f.attribute13%type
111: ,per_information6 per_all_people_f.attribute6%type
112: ,per_information7 per_all_people_f.attribute7%type
113: ,per_information8 per_all_people_f.attribute8%type
114: ,per_information9 per_all_people_f.attribute9%type
115: ,per_information10 per_all_people_f.attribute10%type
116: ,per_information11 per_all_people_f.attribute11%type
117: ,per_information12 per_all_people_f.attribute12%type
118: ,per_information13 per_all_people_f.attribute13%type
119: ,per_information14 per_all_people_f.attribute14%type
112: ,per_information7 per_all_people_f.attribute7%type
113: ,per_information8 per_all_people_f.attribute8%type
114: ,per_information9 per_all_people_f.attribute9%type
115: ,per_information10 per_all_people_f.attribute10%type
116: ,per_information11 per_all_people_f.attribute11%type
117: ,per_information12 per_all_people_f.attribute12%type
118: ,per_information13 per_all_people_f.attribute13%type
119: ,per_information14 per_all_people_f.attribute14%type
120: ,per_information15 per_all_people_f.attribute15%type
113: ,per_information8 per_all_people_f.attribute8%type
114: ,per_information9 per_all_people_f.attribute9%type
115: ,per_information10 per_all_people_f.attribute10%type
116: ,per_information11 per_all_people_f.attribute11%type
117: ,per_information12 per_all_people_f.attribute12%type
118: ,per_information13 per_all_people_f.attribute13%type
119: ,per_information14 per_all_people_f.attribute14%type
120: ,per_information15 per_all_people_f.attribute15%type
121: ,per_information16 per_all_people_f.attribute16%type
114: ,per_information9 per_all_people_f.attribute9%type
115: ,per_information10 per_all_people_f.attribute10%type
116: ,per_information11 per_all_people_f.attribute11%type
117: ,per_information12 per_all_people_f.attribute12%type
118: ,per_information13 per_all_people_f.attribute13%type
119: ,per_information14 per_all_people_f.attribute14%type
120: ,per_information15 per_all_people_f.attribute15%type
121: ,per_information16 per_all_people_f.attribute16%type
122: ,per_information17 per_all_people_f.attribute17%type
115: ,per_information10 per_all_people_f.attribute10%type
116: ,per_information11 per_all_people_f.attribute11%type
117: ,per_information12 per_all_people_f.attribute12%type
118: ,per_information13 per_all_people_f.attribute13%type
119: ,per_information14 per_all_people_f.attribute14%type
120: ,per_information15 per_all_people_f.attribute15%type
121: ,per_information16 per_all_people_f.attribute16%type
122: ,per_information17 per_all_people_f.attribute17%type
123: ,per_information18 per_all_people_f.attribute18%type
116: ,per_information11 per_all_people_f.attribute11%type
117: ,per_information12 per_all_people_f.attribute12%type
118: ,per_information13 per_all_people_f.attribute13%type
119: ,per_information14 per_all_people_f.attribute14%type
120: ,per_information15 per_all_people_f.attribute15%type
121: ,per_information16 per_all_people_f.attribute16%type
122: ,per_information17 per_all_people_f.attribute17%type
123: ,per_information18 per_all_people_f.attribute18%type
124: ,per_information19 per_all_people_f.attribute19%type
117: ,per_information12 per_all_people_f.attribute12%type
118: ,per_information13 per_all_people_f.attribute13%type
119: ,per_information14 per_all_people_f.attribute14%type
120: ,per_information15 per_all_people_f.attribute15%type
121: ,per_information16 per_all_people_f.attribute16%type
122: ,per_information17 per_all_people_f.attribute17%type
123: ,per_information18 per_all_people_f.attribute18%type
124: ,per_information19 per_all_people_f.attribute19%type
125: ,per_information20 per_all_people_f.attribute20%type
118: ,per_information13 per_all_people_f.attribute13%type
119: ,per_information14 per_all_people_f.attribute14%type
120: ,per_information15 per_all_people_f.attribute15%type
121: ,per_information16 per_all_people_f.attribute16%type
122: ,per_information17 per_all_people_f.attribute17%type
123: ,per_information18 per_all_people_f.attribute18%type
124: ,per_information19 per_all_people_f.attribute19%type
125: ,per_information20 per_all_people_f.attribute20%type
126: ,per_information21 per_all_people_f.attribute21%type
119: ,per_information14 per_all_people_f.attribute14%type
120: ,per_information15 per_all_people_f.attribute15%type
121: ,per_information16 per_all_people_f.attribute16%type
122: ,per_information17 per_all_people_f.attribute17%type
123: ,per_information18 per_all_people_f.attribute18%type
124: ,per_information19 per_all_people_f.attribute19%type
125: ,per_information20 per_all_people_f.attribute20%type
126: ,per_information21 per_all_people_f.attribute21%type
127: ,per_information22 per_all_people_f.attribute22%type
120: ,per_information15 per_all_people_f.attribute15%type
121: ,per_information16 per_all_people_f.attribute16%type
122: ,per_information17 per_all_people_f.attribute17%type
123: ,per_information18 per_all_people_f.attribute18%type
124: ,per_information19 per_all_people_f.attribute19%type
125: ,per_information20 per_all_people_f.attribute20%type
126: ,per_information21 per_all_people_f.attribute21%type
127: ,per_information22 per_all_people_f.attribute22%type
128: ,per_information23 per_all_people_f.attribute23%type
121: ,per_information16 per_all_people_f.attribute16%type
122: ,per_information17 per_all_people_f.attribute17%type
123: ,per_information18 per_all_people_f.attribute18%type
124: ,per_information19 per_all_people_f.attribute19%type
125: ,per_information20 per_all_people_f.attribute20%type
126: ,per_information21 per_all_people_f.attribute21%type
127: ,per_information22 per_all_people_f.attribute22%type
128: ,per_information23 per_all_people_f.attribute23%type
129: ,per_information24 per_all_people_f.attribute24%type
122: ,per_information17 per_all_people_f.attribute17%type
123: ,per_information18 per_all_people_f.attribute18%type
124: ,per_information19 per_all_people_f.attribute19%type
125: ,per_information20 per_all_people_f.attribute20%type
126: ,per_information21 per_all_people_f.attribute21%type
127: ,per_information22 per_all_people_f.attribute22%type
128: ,per_information23 per_all_people_f.attribute23%type
129: ,per_information24 per_all_people_f.attribute24%type
130: ,per_information25 per_all_people_f.attribute25%type
123: ,per_information18 per_all_people_f.attribute18%type
124: ,per_information19 per_all_people_f.attribute19%type
125: ,per_information20 per_all_people_f.attribute20%type
126: ,per_information21 per_all_people_f.attribute21%type
127: ,per_information22 per_all_people_f.attribute22%type
128: ,per_information23 per_all_people_f.attribute23%type
129: ,per_information24 per_all_people_f.attribute24%type
130: ,per_information25 per_all_people_f.attribute25%type
131: ,per_information26 per_all_people_f.attribute26%type
124: ,per_information19 per_all_people_f.attribute19%type
125: ,per_information20 per_all_people_f.attribute20%type
126: ,per_information21 per_all_people_f.attribute21%type
127: ,per_information22 per_all_people_f.attribute22%type
128: ,per_information23 per_all_people_f.attribute23%type
129: ,per_information24 per_all_people_f.attribute24%type
130: ,per_information25 per_all_people_f.attribute25%type
131: ,per_information26 per_all_people_f.attribute26%type
132: ,per_information27 per_all_people_f.attribute27%type
125: ,per_information20 per_all_people_f.attribute20%type
126: ,per_information21 per_all_people_f.attribute21%type
127: ,per_information22 per_all_people_f.attribute22%type
128: ,per_information23 per_all_people_f.attribute23%type
129: ,per_information24 per_all_people_f.attribute24%type
130: ,per_information25 per_all_people_f.attribute25%type
131: ,per_information26 per_all_people_f.attribute26%type
132: ,per_information27 per_all_people_f.attribute27%type
133: ,per_information28 per_all_people_f.attribute28%type
126: ,per_information21 per_all_people_f.attribute21%type
127: ,per_information22 per_all_people_f.attribute22%type
128: ,per_information23 per_all_people_f.attribute23%type
129: ,per_information24 per_all_people_f.attribute24%type
130: ,per_information25 per_all_people_f.attribute25%type
131: ,per_information26 per_all_people_f.attribute26%type
132: ,per_information27 per_all_people_f.attribute27%type
133: ,per_information28 per_all_people_f.attribute28%type
134: ,per_information29 per_all_people_f.attribute29%type
127: ,per_information22 per_all_people_f.attribute22%type
128: ,per_information23 per_all_people_f.attribute23%type
129: ,per_information24 per_all_people_f.attribute24%type
130: ,per_information25 per_all_people_f.attribute25%type
131: ,per_information26 per_all_people_f.attribute26%type
132: ,per_information27 per_all_people_f.attribute27%type
133: ,per_information28 per_all_people_f.attribute28%type
134: ,per_information29 per_all_people_f.attribute29%type
135: ,per_information30 per_all_people_f.attribute30%type
128: ,per_information23 per_all_people_f.attribute23%type
129: ,per_information24 per_all_people_f.attribute24%type
130: ,per_information25 per_all_people_f.attribute25%type
131: ,per_information26 per_all_people_f.attribute26%type
132: ,per_information27 per_all_people_f.attribute27%type
133: ,per_information28 per_all_people_f.attribute28%type
134: ,per_information29 per_all_people_f.attribute29%type
135: ,per_information30 per_all_people_f.attribute30%type
136: ,date_of_death per_all_people_f.date_of_death%type
129: ,per_information24 per_all_people_f.attribute24%type
130: ,per_information25 per_all_people_f.attribute25%type
131: ,per_information26 per_all_people_f.attribute26%type
132: ,per_information27 per_all_people_f.attribute27%type
133: ,per_information28 per_all_people_f.attribute28%type
134: ,per_information29 per_all_people_f.attribute29%type
135: ,per_information30 per_all_people_f.attribute30%type
136: ,date_of_death per_all_people_f.date_of_death%type
137: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
130: ,per_information25 per_all_people_f.attribute25%type
131: ,per_information26 per_all_people_f.attribute26%type
132: ,per_information27 per_all_people_f.attribute27%type
133: ,per_information28 per_all_people_f.attribute28%type
134: ,per_information29 per_all_people_f.attribute29%type
135: ,per_information30 per_all_people_f.attribute30%type
136: ,date_of_death per_all_people_f.date_of_death%type
137: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
138: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
131: ,per_information26 per_all_people_f.attribute26%type
132: ,per_information27 per_all_people_f.attribute27%type
133: ,per_information28 per_all_people_f.attribute28%type
134: ,per_information29 per_all_people_f.attribute29%type
135: ,per_information30 per_all_people_f.attribute30%type
136: ,date_of_death per_all_people_f.date_of_death%type
137: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
138: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
139: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
132: ,per_information27 per_all_people_f.attribute27%type
133: ,per_information28 per_all_people_f.attribute28%type
134: ,per_information29 per_all_people_f.attribute29%type
135: ,per_information30 per_all_people_f.attribute30%type
136: ,date_of_death per_all_people_f.date_of_death%type
137: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
138: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
139: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
140: ,country_of_birth_meaning per_all_people_f.country_of_birth%type
133: ,per_information28 per_all_people_f.attribute28%type
134: ,per_information29 per_all_people_f.attribute29%type
135: ,per_information30 per_all_people_f.attribute30%type
136: ,date_of_death per_all_people_f.date_of_death%type
137: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
138: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
139: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
140: ,country_of_birth_meaning per_all_people_f.country_of_birth%type
141: ,per_object_version_number number
134: ,per_information29 per_all_people_f.attribute29%type
135: ,per_information30 per_all_people_f.attribute30%type
136: ,date_of_death per_all_people_f.date_of_death%type
137: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
138: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
139: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
140: ,country_of_birth_meaning per_all_people_f.country_of_birth%type
141: ,per_object_version_number number
142: ,person_update_allowed varchar2(5)
135: ,per_information30 per_all_people_f.attribute30%type
136: ,date_of_death per_all_people_f.date_of_death%type
137: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
138: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
139: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
140: ,country_of_birth_meaning per_all_people_f.country_of_birth%type
141: ,per_object_version_number number
142: ,person_update_allowed varchar2(5)
143: ,assignment_id per_all_assignments_f.assignment_id%type
136: ,date_of_death per_all_people_f.date_of_death%type
137: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
138: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
139: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
140: ,country_of_birth_meaning per_all_people_f.country_of_birth%type
141: ,per_object_version_number number
142: ,person_update_allowed varchar2(5)
143: ,assignment_id per_all_assignments_f.assignment_id%type
144: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
142: ,person_update_allowed varchar2(5)
143: ,assignment_id per_all_assignments_f.assignment_id%type
144: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
145: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type
146: ,recruiter per_all_people_f.full_name%type
147: ,grade per_grades.name%type
148: ,grade_ladder ben_pgm_f.name%type
149: ,position hr_all_positions_f.name%type
150: ,job per_jobs.name%type
151: ,assignment_status_type per_assignment_status_types.user_status%type
152: ,system_status per_assignment_status_types.per_system_status%type
153: ,payroll pay_all_payrolls_f.payroll_name%type
154: ,location hr_locations.location_code%type
155: ,person_referred_by per_all_people_f.full_name%type
156: ,supervisor per_all_people_f.full_name%type
157: ,recruitment_activity per_recruitment_activities.name%type
158: ,source_organization hr_all_organization_units.name%type
159: ,organization hr_all_organization_units.name%type
152: ,system_status per_assignment_status_types.per_system_status%type
153: ,payroll pay_all_payrolls_f.payroll_name%type
154: ,location hr_locations.location_code%type
155: ,person_referred_by per_all_people_f.full_name%type
156: ,supervisor per_all_people_f.full_name%type
157: ,recruitment_activity per_recruitment_activities.name%type
158: ,source_organization hr_all_organization_units.name%type
159: ,organization hr_all_organization_units.name%type
160: ,pgp_segment1 pay_people_groups.segment1%type