1: PACKAGE per_qh_maintain_query as
2: /* $Header: peqhmntq.pkh 120.2 2006/08/22 11:26:59 rvarshne noship $ */
3:
4: type mainrec is RECORD
5: (person_id per_all_people_f.person_id%type
6: ,business_group_id per_all_people_f.business_group_id%type
7: ,business_group_name per_business_groups.name%type
8: ,per_effective_start_date per_all_people_f.effective_start_date%type
9: ,per_effective_end_date per_all_people_f.effective_end_date%type
2: /* $Header: peqhmntq.pkh 120.2 2006/08/22 11:26:59 rvarshne noship $ */
3:
4: type mainrec is RECORD
5: (person_id per_all_people_f.person_id%type
6: ,business_group_id per_all_people_f.business_group_id%type
7: ,business_group_name per_business_groups.name%type
8: ,per_effective_start_date per_all_people_f.effective_start_date%type
9: ,per_effective_end_date per_all_people_f.effective_end_date%type
10: ,per_validation_start_date date
4: type mainrec is RECORD
5: (person_id per_all_people_f.person_id%type
6: ,business_group_id per_all_people_f.business_group_id%type
7: ,business_group_name per_business_groups.name%type
8: ,per_effective_start_date per_all_people_f.effective_start_date%type
9: ,per_effective_end_date per_all_people_f.effective_end_date%type
10: ,per_validation_start_date date
11: ,per_validation_end_date date
12: ,person_type varchar2(240)
5: (person_id per_all_people_f.person_id%type
6: ,business_group_id per_all_people_f.business_group_id%type
7: ,business_group_name per_business_groups.name%type
8: ,per_effective_start_date per_all_people_f.effective_start_date%type
9: ,per_effective_end_date per_all_people_f.effective_end_date%type
10: ,per_validation_start_date date
11: ,per_validation_end_date date
12: ,person_type varchar2(240)
13: ,system_person_type per_person_types.system_person_type%type
10: ,per_validation_start_date date
11: ,per_validation_end_date date
12: ,person_type varchar2(240)
13: ,system_person_type per_person_types.system_person_type%type
14: ,person_type_id per_all_people_f.person_type_id%type
15: ,last_name per_all_people_f.last_name%type
16: ,start_date per_all_people_f.start_date%type
17: ,applicant_number per_all_people_f.applicant_number%type
18: --added below for PMxBG
11: ,per_validation_end_date date
12: ,person_type varchar2(240)
13: ,system_person_type per_person_types.system_person_type%type
14: ,person_type_id per_all_people_f.person_type_id%type
15: ,last_name per_all_people_f.last_name%type
16: ,start_date per_all_people_f.start_date%type
17: ,applicant_number per_all_people_f.applicant_number%type
18: --added below for PMxBG
19: ,legislation per_business_groups.legislation_code%type
12: ,person_type varchar2(240)
13: ,system_person_type per_person_types.system_person_type%type
14: ,person_type_id per_all_people_f.person_type_id%type
15: ,last_name per_all_people_f.last_name%type
16: ,start_date per_all_people_f.start_date%type
17: ,applicant_number per_all_people_f.applicant_number%type
18: --added below for PMxBG
19: ,legislation per_business_groups.legislation_code%type
20: ,background_check_status per_all_people_f.background_check_status%type
13: ,system_person_type per_person_types.system_person_type%type
14: ,person_type_id per_all_people_f.person_type_id%type
15: ,last_name per_all_people_f.last_name%type
16: ,start_date per_all_people_f.start_date%type
17: ,applicant_number per_all_people_f.applicant_number%type
18: --added below for PMxBG
19: ,legislation per_business_groups.legislation_code%type
20: ,background_check_status per_all_people_f.background_check_status%type
21: ,background_date_check per_all_people_f.background_date_check%type
16: ,start_date per_all_people_f.start_date%type
17: ,applicant_number per_all_people_f.applicant_number%type
18: --added below for PMxBG
19: ,legislation per_business_groups.legislation_code%type
20: ,background_check_status per_all_people_f.background_check_status%type
21: ,background_date_check per_all_people_f.background_date_check%type
22: ,blood_type_meaning hr_lookups.meaning%type
23: ,blood_type per_all_people_f.blood_type%type
24: ,corr_lang_meaning hr_lookups.meaning%type
17: ,applicant_number per_all_people_f.applicant_number%type
18: --added below for PMxBG
19: ,legislation per_business_groups.legislation_code%type
20: ,background_check_status per_all_people_f.background_check_status%type
21: ,background_date_check per_all_people_f.background_date_check%type
22: ,blood_type_meaning hr_lookups.meaning%type
23: ,blood_type per_all_people_f.blood_type%type
24: ,corr_lang_meaning hr_lookups.meaning%type
25: ,correspondence_language per_all_people_f.correspondence_language%type
19: ,legislation per_business_groups.legislation_code%type
20: ,background_check_status per_all_people_f.background_check_status%type
21: ,background_date_check per_all_people_f.background_date_check%type
22: ,blood_type_meaning hr_lookups.meaning%type
23: ,blood_type per_all_people_f.blood_type%type
24: ,corr_lang_meaning hr_lookups.meaning%type
25: ,correspondence_language per_all_people_f.correspondence_language%type
26: ,current_applicant_flag per_all_people_f.current_applicant_flag%type
27: ,current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type
21: ,background_date_check per_all_people_f.background_date_check%type
22: ,blood_type_meaning hr_lookups.meaning%type
23: ,blood_type per_all_people_f.blood_type%type
24: ,corr_lang_meaning hr_lookups.meaning%type
25: ,correspondence_language per_all_people_f.correspondence_language%type
26: ,current_applicant_flag per_all_people_f.current_applicant_flag%type
27: ,current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type
28: ,current_employee_flag per_all_people_f.current_employee_flag%type
29: --CWK
22: ,blood_type_meaning hr_lookups.meaning%type
23: ,blood_type per_all_people_f.blood_type%type
24: ,corr_lang_meaning hr_lookups.meaning%type
25: ,correspondence_language per_all_people_f.correspondence_language%type
26: ,current_applicant_flag per_all_people_f.current_applicant_flag%type
27: ,current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type
28: ,current_employee_flag per_all_people_f.current_employee_flag%type
29: --CWK
30: ,current_npw_flag per_all_people_f.current_npw_flag%type
23: ,blood_type per_all_people_f.blood_type%type
24: ,corr_lang_meaning hr_lookups.meaning%type
25: ,correspondence_language per_all_people_f.correspondence_language%type
26: ,current_applicant_flag per_all_people_f.current_applicant_flag%type
27: ,current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type
28: ,current_employee_flag per_all_people_f.current_employee_flag%type
29: --CWK
30: ,current_npw_flag per_all_people_f.current_npw_flag%type
31: ,npw_number per_all_people_f.npw_number%type
24: ,corr_lang_meaning hr_lookups.meaning%type
25: ,correspondence_language per_all_people_f.correspondence_language%type
26: ,current_applicant_flag per_all_people_f.current_applicant_flag%type
27: ,current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type
28: ,current_employee_flag per_all_people_f.current_employee_flag%type
29: --CWK
30: ,current_npw_flag per_all_people_f.current_npw_flag%type
31: ,npw_number per_all_people_f.npw_number%type
32: ,period_of_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
26: ,current_applicant_flag per_all_people_f.current_applicant_flag%type
27: ,current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type
28: ,current_employee_flag per_all_people_f.current_employee_flag%type
29: --CWK
30: ,current_npw_flag per_all_people_f.current_npw_flag%type
31: ,npw_number per_all_people_f.npw_number%type
32: ,period_of_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
33: ,projected_assignment_end per_all_assignments_f.projected_assignment_end%type
34: ,pdp_object_version_number per_periods_of_placement.object_version_number%type
27: ,current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type
28: ,current_employee_flag per_all_people_f.current_employee_flag%type
29: --CWK
30: ,current_npw_flag per_all_people_f.current_npw_flag%type
31: ,npw_number per_all_people_f.npw_number%type
32: ,period_of_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
33: ,projected_assignment_end per_all_assignments_f.projected_assignment_end%type
34: ,pdp_object_version_number per_periods_of_placement.object_version_number%type
35: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type
54: ,rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
55: ,rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
56: ,rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
57: --
58: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
59: ,date_of_birth per_all_people_f.date_of_birth%type
60: ,age number
61: ,email_address per_all_people_f.email_address%type
62: ,employee_number per_all_people_f.employee_number%type
55: ,rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
56: ,rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
57: --
58: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
59: ,date_of_birth per_all_people_f.date_of_birth%type
60: ,age number
61: ,email_address per_all_people_f.email_address%type
62: ,employee_number per_all_people_f.employee_number%type
63: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
57: --
58: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
59: ,date_of_birth per_all_people_f.date_of_birth%type
60: ,age number
61: ,email_address per_all_people_f.email_address%type
62: ,employee_number per_all_people_f.employee_number%type
63: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
64: ,expnse_check_send_to_address per_all_people_f.expense_check_send_to_address%type
65: ,first_name per_all_people_f.first_name%type
58: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
59: ,date_of_birth per_all_people_f.date_of_birth%type
60: ,age number
61: ,email_address per_all_people_f.email_address%type
62: ,employee_number per_all_people_f.employee_number%type
63: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
64: ,expnse_check_send_to_address per_all_people_f.expense_check_send_to_address%type
65: ,first_name per_all_people_f.first_name%type
66: ,per_fte_capacity per_all_people_f.fte_capacity%type
60: ,age number
61: ,email_address per_all_people_f.email_address%type
62: ,employee_number per_all_people_f.employee_number%type
63: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
64: ,expnse_check_send_to_address per_all_people_f.expense_check_send_to_address%type
65: ,first_name per_all_people_f.first_name%type
66: ,per_fte_capacity per_all_people_f.fte_capacity%type
67: ,full_name per_all_people_f.full_name%type
68: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
61: ,email_address per_all_people_f.email_address%type
62: ,employee_number per_all_people_f.employee_number%type
63: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
64: ,expnse_check_send_to_address per_all_people_f.expense_check_send_to_address%type
65: ,first_name per_all_people_f.first_name%type
66: ,per_fte_capacity per_all_people_f.fte_capacity%type
67: ,full_name per_all_people_f.full_name%type
68: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
69: ,honors per_all_people_f.honors%type
62: ,employee_number per_all_people_f.employee_number%type
63: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
64: ,expnse_check_send_to_address per_all_people_f.expense_check_send_to_address%type
65: ,first_name per_all_people_f.first_name%type
66: ,per_fte_capacity per_all_people_f.fte_capacity%type
67: ,full_name per_all_people_f.full_name%type
68: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
69: ,honors per_all_people_f.honors%type
70: ,internal_location per_all_people_f.internal_location%type
63: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
64: ,expnse_check_send_to_address per_all_people_f.expense_check_send_to_address%type
65: ,first_name per_all_people_f.first_name%type
66: ,per_fte_capacity per_all_people_f.fte_capacity%type
67: ,full_name per_all_people_f.full_name%type
68: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
69: ,honors per_all_people_f.honors%type
70: ,internal_location per_all_people_f.internal_location%type
71: ,known_as per_all_people_f.known_as%type
64: ,expnse_check_send_to_address per_all_people_f.expense_check_send_to_address%type
65: ,first_name per_all_people_f.first_name%type
66: ,per_fte_capacity per_all_people_f.fte_capacity%type
67: ,full_name per_all_people_f.full_name%type
68: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
69: ,honors per_all_people_f.honors%type
70: ,internal_location per_all_people_f.internal_location%type
71: ,known_as per_all_people_f.known_as%type
72: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
65: ,first_name per_all_people_f.first_name%type
66: ,per_fte_capacity per_all_people_f.fte_capacity%type
67: ,full_name per_all_people_f.full_name%type
68: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
69: ,honors per_all_people_f.honors%type
70: ,internal_location per_all_people_f.internal_location%type
71: ,known_as per_all_people_f.known_as%type
72: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
73: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
66: ,per_fte_capacity per_all_people_f.fte_capacity%type
67: ,full_name per_all_people_f.full_name%type
68: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
69: ,honors per_all_people_f.honors%type
70: ,internal_location per_all_people_f.internal_location%type
71: ,known_as per_all_people_f.known_as%type
72: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
73: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
74: ,mailstop per_all_people_f.mailstop%type
67: ,full_name per_all_people_f.full_name%type
68: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
69: ,honors per_all_people_f.honors%type
70: ,internal_location per_all_people_f.internal_location%type
71: ,known_as per_all_people_f.known_as%type
72: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
73: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
74: ,mailstop per_all_people_f.mailstop%type
75: ,marital_status_meaning hr_lookups.meaning%type
68: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
69: ,honors per_all_people_f.honors%type
70: ,internal_location per_all_people_f.internal_location%type
71: ,known_as per_all_people_f.known_as%type
72: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
73: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
74: ,mailstop per_all_people_f.mailstop%type
75: ,marital_status_meaning hr_lookups.meaning%type
76: ,marital_status per_all_people_f.marital_status%type
69: ,honors per_all_people_f.honors%type
70: ,internal_location per_all_people_f.internal_location%type
71: ,known_as per_all_people_f.known_as%type
72: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
73: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
74: ,mailstop per_all_people_f.mailstop%type
75: ,marital_status_meaning hr_lookups.meaning%type
76: ,marital_status per_all_people_f.marital_status%type
77: ,middle_names per_all_people_f.middle_names%type
70: ,internal_location per_all_people_f.internal_location%type
71: ,known_as per_all_people_f.known_as%type
72: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
73: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
74: ,mailstop per_all_people_f.mailstop%type
75: ,marital_status_meaning hr_lookups.meaning%type
76: ,marital_status per_all_people_f.marital_status%type
77: ,middle_names per_all_people_f.middle_names%type
78: ,nationality_meaning hr_lookups.meaning%type
72: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
73: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
74: ,mailstop per_all_people_f.mailstop%type
75: ,marital_status_meaning hr_lookups.meaning%type
76: ,marital_status per_all_people_f.marital_status%type
77: ,middle_names per_all_people_f.middle_names%type
78: ,nationality_meaning hr_lookups.meaning%type
79: ,nationality per_all_people_f.nationality%type
80: ,national_identifier per_all_people_f.national_identifier%type
73: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
74: ,mailstop per_all_people_f.mailstop%type
75: ,marital_status_meaning hr_lookups.meaning%type
76: ,marital_status per_all_people_f.marital_status%type
77: ,middle_names per_all_people_f.middle_names%type
78: ,nationality_meaning hr_lookups.meaning%type
79: ,nationality per_all_people_f.nationality%type
80: ,national_identifier per_all_people_f.national_identifier%type
81: ,office_number per_all_people_f.office_number%type
75: ,marital_status_meaning hr_lookups.meaning%type
76: ,marital_status per_all_people_f.marital_status%type
77: ,middle_names per_all_people_f.middle_names%type
78: ,nationality_meaning hr_lookups.meaning%type
79: ,nationality per_all_people_f.nationality%type
80: ,national_identifier per_all_people_f.national_identifier%type
81: ,office_number per_all_people_f.office_number%type
82: ,on_military_service per_all_people_f.on_military_service%type
83: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
76: ,marital_status per_all_people_f.marital_status%type
77: ,middle_names per_all_people_f.middle_names%type
78: ,nationality_meaning hr_lookups.meaning%type
79: ,nationality per_all_people_f.nationality%type
80: ,national_identifier per_all_people_f.national_identifier%type
81: ,office_number per_all_people_f.office_number%type
82: ,on_military_service per_all_people_f.on_military_service%type
83: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
84: ,previous_last_name per_all_people_f.previous_last_name%type
77: ,middle_names per_all_people_f.middle_names%type
78: ,nationality_meaning hr_lookups.meaning%type
79: ,nationality per_all_people_f.nationality%type
80: ,national_identifier per_all_people_f.national_identifier%type
81: ,office_number per_all_people_f.office_number%type
82: ,on_military_service per_all_people_f.on_military_service%type
83: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
84: ,previous_last_name per_all_people_f.previous_last_name%type
85: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
78: ,nationality_meaning hr_lookups.meaning%type
79: ,nationality per_all_people_f.nationality%type
80: ,national_identifier per_all_people_f.national_identifier%type
81: ,office_number per_all_people_f.office_number%type
82: ,on_military_service per_all_people_f.on_military_service%type
83: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
84: ,previous_last_name per_all_people_f.previous_last_name%type
85: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
86: ,rehire_reason per_all_people_f.rehire_reason%type
79: ,nationality per_all_people_f.nationality%type
80: ,national_identifier per_all_people_f.national_identifier%type
81: ,office_number per_all_people_f.office_number%type
82: ,on_military_service per_all_people_f.on_military_service%type
83: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
84: ,previous_last_name per_all_people_f.previous_last_name%type
85: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
86: ,rehire_reason per_all_people_f.rehire_reason%type
87: ,resume_exists per_all_people_f.resume_exists%type
80: ,national_identifier per_all_people_f.national_identifier%type
81: ,office_number per_all_people_f.office_number%type
82: ,on_military_service per_all_people_f.on_military_service%type
83: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
84: ,previous_last_name per_all_people_f.previous_last_name%type
85: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
86: ,rehire_reason per_all_people_f.rehire_reason%type
87: ,resume_exists per_all_people_f.resume_exists%type
88: ,resume_last_updated per_all_people_f.resume_last_updated%type
81: ,office_number per_all_people_f.office_number%type
82: ,on_military_service per_all_people_f.on_military_service%type
83: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
84: ,previous_last_name per_all_people_f.previous_last_name%type
85: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
86: ,rehire_reason per_all_people_f.rehire_reason%type
87: ,resume_exists per_all_people_f.resume_exists%type
88: ,resume_last_updated per_all_people_f.resume_last_updated%type
89: -- Bug 3037019
82: ,on_military_service per_all_people_f.on_military_service%type
83: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
84: ,previous_last_name per_all_people_f.previous_last_name%type
85: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
86: ,rehire_reason per_all_people_f.rehire_reason%type
87: ,resume_exists per_all_people_f.resume_exists%type
88: ,resume_last_updated per_all_people_f.resume_last_updated%type
89: -- Bug 3037019
90: ,registered_disabled_flag hr_lookups.meaning%type
83: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
84: ,previous_last_name per_all_people_f.previous_last_name%type
85: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
86: ,rehire_reason per_all_people_f.rehire_reason%type
87: ,resume_exists per_all_people_f.resume_exists%type
88: ,resume_last_updated per_all_people_f.resume_last_updated%type
89: -- Bug 3037019
90: ,registered_disabled_flag hr_lookups.meaning%type
91: ,registered_disabled per_all_people_f.registered_disabled_flag%type
84: ,previous_last_name per_all_people_f.previous_last_name%type
85: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
86: ,rehire_reason per_all_people_f.rehire_reason%type
87: ,resume_exists per_all_people_f.resume_exists%type
88: ,resume_last_updated per_all_people_f.resume_last_updated%type
89: -- Bug 3037019
90: ,registered_disabled_flag hr_lookups.meaning%type
91: ,registered_disabled per_all_people_f.registered_disabled_flag%type
92: ,second_passport_exists per_all_people_f.second_passport_exists%type
87: ,resume_exists per_all_people_f.resume_exists%type
88: ,resume_last_updated per_all_people_f.resume_last_updated%type
89: -- Bug 3037019
90: ,registered_disabled_flag hr_lookups.meaning%type
91: ,registered_disabled per_all_people_f.registered_disabled_flag%type
92: ,second_passport_exists per_all_people_f.second_passport_exists%type
93: ,sex_meaning hr_lookups.meaning%type
94: ,sex per_all_people_f.sex%type
95: ,student_status_meaning hr_lookups.meaning%type
88: ,resume_last_updated per_all_people_f.resume_last_updated%type
89: -- Bug 3037019
90: ,registered_disabled_flag hr_lookups.meaning%type
91: ,registered_disabled per_all_people_f.registered_disabled_flag%type
92: ,second_passport_exists per_all_people_f.second_passport_exists%type
93: ,sex_meaning hr_lookups.meaning%type
94: ,sex per_all_people_f.sex%type
95: ,student_status_meaning hr_lookups.meaning%type
96: ,student_status per_all_people_f.student_status%type
90: ,registered_disabled_flag hr_lookups.meaning%type
91: ,registered_disabled per_all_people_f.registered_disabled_flag%type
92: ,second_passport_exists per_all_people_f.second_passport_exists%type
93: ,sex_meaning hr_lookups.meaning%type
94: ,sex per_all_people_f.sex%type
95: ,student_status_meaning hr_lookups.meaning%type
96: ,student_status per_all_people_f.student_status%type
97: ,suffix per_all_people_f.suffix%type
98: ,title_meaning hr_lookups.meaning%type
92: ,second_passport_exists per_all_people_f.second_passport_exists%type
93: ,sex_meaning hr_lookups.meaning%type
94: ,sex per_all_people_f.sex%type
95: ,student_status_meaning hr_lookups.meaning%type
96: ,student_status per_all_people_f.student_status%type
97: ,suffix per_all_people_f.suffix%type
98: ,title_meaning hr_lookups.meaning%type
99: ,title per_all_people_f.title%type
100: ,work_schedule_meaning hr_lookups.meaning%type
93: ,sex_meaning hr_lookups.meaning%type
94: ,sex per_all_people_f.sex%type
95: ,student_status_meaning hr_lookups.meaning%type
96: ,student_status per_all_people_f.student_status%type
97: ,suffix per_all_people_f.suffix%type
98: ,title_meaning hr_lookups.meaning%type
99: ,title per_all_people_f.title%type
100: ,work_schedule_meaning hr_lookups.meaning%type
101: ,work_schedule per_all_people_f.work_schedule%type
95: ,student_status_meaning hr_lookups.meaning%type
96: ,student_status per_all_people_f.student_status%type
97: ,suffix per_all_people_f.suffix%type
98: ,title_meaning hr_lookups.meaning%type
99: ,title per_all_people_f.title%type
100: ,work_schedule_meaning hr_lookups.meaning%type
101: ,work_schedule per_all_people_f.work_schedule%type
102: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
103: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
97: ,suffix per_all_people_f.suffix%type
98: ,title_meaning hr_lookups.meaning%type
99: ,title per_all_people_f.title%type
100: ,work_schedule_meaning hr_lookups.meaning%type
101: ,work_schedule per_all_people_f.work_schedule%type
102: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
103: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
104: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
105: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
98: ,title_meaning hr_lookups.meaning%type
99: ,title per_all_people_f.title%type
100: ,work_schedule_meaning hr_lookups.meaning%type
101: ,work_schedule per_all_people_f.work_schedule%type
102: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
103: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
104: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
105: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
106: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
99: ,title per_all_people_f.title%type
100: ,work_schedule_meaning hr_lookups.meaning%type
101: ,work_schedule per_all_people_f.work_schedule%type
102: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
103: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
104: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
105: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
106: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
107: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
100: ,work_schedule_meaning hr_lookups.meaning%type
101: ,work_schedule per_all_people_f.work_schedule%type
102: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
103: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
104: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
105: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
106: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
107: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
108: ,benefit_group ben_benfts_grp.name%type
101: ,work_schedule per_all_people_f.work_schedule%type
102: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
103: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
104: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
105: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
106: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
107: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
108: ,benefit_group ben_benfts_grp.name%type
109: ,benefit_group_id per_all_people_f.benefit_group_id%type
102: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
103: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
104: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
105: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
106: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
107: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
108: ,benefit_group ben_benfts_grp.name%type
109: ,benefit_group_id per_all_people_f.benefit_group_id%type
110: ,attribute_category per_all_people_f.attribute_category%type
103: ,coord_ben_no_cvg_flag per_all_people_f.coord_ben_no_cvg_flag%type
104: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
105: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
106: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
107: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
108: ,benefit_group ben_benfts_grp.name%type
109: ,benefit_group_id per_all_people_f.benefit_group_id%type
110: ,attribute_category per_all_people_f.attribute_category%type
111: ,attribute1 per_all_people_f.attribute1%type
105: ,dpdnt_vlntry_svce_flag per_all_people_f.dpdnt_vlntry_svce_flag%type
106: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
107: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
108: ,benefit_group ben_benfts_grp.name%type
109: ,benefit_group_id per_all_people_f.benefit_group_id%type
110: ,attribute_category per_all_people_f.attribute_category%type
111: ,attribute1 per_all_people_f.attribute1%type
112: ,attribute2 per_all_people_f.attribute2%type
113: ,attribute3 per_all_people_f.attribute3%type
106: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
107: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
108: ,benefit_group ben_benfts_grp.name%type
109: ,benefit_group_id per_all_people_f.benefit_group_id%type
110: ,attribute_category per_all_people_f.attribute_category%type
111: ,attribute1 per_all_people_f.attribute1%type
112: ,attribute2 per_all_people_f.attribute2%type
113: ,attribute3 per_all_people_f.attribute3%type
114: ,attribute4 per_all_people_f.attribute4%type
107: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
108: ,benefit_group ben_benfts_grp.name%type
109: ,benefit_group_id per_all_people_f.benefit_group_id%type
110: ,attribute_category per_all_people_f.attribute_category%type
111: ,attribute1 per_all_people_f.attribute1%type
112: ,attribute2 per_all_people_f.attribute2%type
113: ,attribute3 per_all_people_f.attribute3%type
114: ,attribute4 per_all_people_f.attribute4%type
115: ,attribute5 per_all_people_f.attribute5%type
108: ,benefit_group ben_benfts_grp.name%type
109: ,benefit_group_id per_all_people_f.benefit_group_id%type
110: ,attribute_category per_all_people_f.attribute_category%type
111: ,attribute1 per_all_people_f.attribute1%type
112: ,attribute2 per_all_people_f.attribute2%type
113: ,attribute3 per_all_people_f.attribute3%type
114: ,attribute4 per_all_people_f.attribute4%type
115: ,attribute5 per_all_people_f.attribute5%type
116: ,attribute6 per_all_people_f.attribute6%type
109: ,benefit_group_id per_all_people_f.benefit_group_id%type
110: ,attribute_category per_all_people_f.attribute_category%type
111: ,attribute1 per_all_people_f.attribute1%type
112: ,attribute2 per_all_people_f.attribute2%type
113: ,attribute3 per_all_people_f.attribute3%type
114: ,attribute4 per_all_people_f.attribute4%type
115: ,attribute5 per_all_people_f.attribute5%type
116: ,attribute6 per_all_people_f.attribute6%type
117: ,attribute7 per_all_people_f.attribute7%type
110: ,attribute_category per_all_people_f.attribute_category%type
111: ,attribute1 per_all_people_f.attribute1%type
112: ,attribute2 per_all_people_f.attribute2%type
113: ,attribute3 per_all_people_f.attribute3%type
114: ,attribute4 per_all_people_f.attribute4%type
115: ,attribute5 per_all_people_f.attribute5%type
116: ,attribute6 per_all_people_f.attribute6%type
117: ,attribute7 per_all_people_f.attribute7%type
118: ,attribute8 per_all_people_f.attribute8%type
111: ,attribute1 per_all_people_f.attribute1%type
112: ,attribute2 per_all_people_f.attribute2%type
113: ,attribute3 per_all_people_f.attribute3%type
114: ,attribute4 per_all_people_f.attribute4%type
115: ,attribute5 per_all_people_f.attribute5%type
116: ,attribute6 per_all_people_f.attribute6%type
117: ,attribute7 per_all_people_f.attribute7%type
118: ,attribute8 per_all_people_f.attribute8%type
119: ,attribute9 per_all_people_f.attribute9%type
112: ,attribute2 per_all_people_f.attribute2%type
113: ,attribute3 per_all_people_f.attribute3%type
114: ,attribute4 per_all_people_f.attribute4%type
115: ,attribute5 per_all_people_f.attribute5%type
116: ,attribute6 per_all_people_f.attribute6%type
117: ,attribute7 per_all_people_f.attribute7%type
118: ,attribute8 per_all_people_f.attribute8%type
119: ,attribute9 per_all_people_f.attribute9%type
120: ,attribute10 per_all_people_f.attribute10%type
113: ,attribute3 per_all_people_f.attribute3%type
114: ,attribute4 per_all_people_f.attribute4%type
115: ,attribute5 per_all_people_f.attribute5%type
116: ,attribute6 per_all_people_f.attribute6%type
117: ,attribute7 per_all_people_f.attribute7%type
118: ,attribute8 per_all_people_f.attribute8%type
119: ,attribute9 per_all_people_f.attribute9%type
120: ,attribute10 per_all_people_f.attribute10%type
121: ,attribute11 per_all_people_f.attribute11%type
114: ,attribute4 per_all_people_f.attribute4%type
115: ,attribute5 per_all_people_f.attribute5%type
116: ,attribute6 per_all_people_f.attribute6%type
117: ,attribute7 per_all_people_f.attribute7%type
118: ,attribute8 per_all_people_f.attribute8%type
119: ,attribute9 per_all_people_f.attribute9%type
120: ,attribute10 per_all_people_f.attribute10%type
121: ,attribute11 per_all_people_f.attribute11%type
122: ,attribute12 per_all_people_f.attribute12%type
115: ,attribute5 per_all_people_f.attribute5%type
116: ,attribute6 per_all_people_f.attribute6%type
117: ,attribute7 per_all_people_f.attribute7%type
118: ,attribute8 per_all_people_f.attribute8%type
119: ,attribute9 per_all_people_f.attribute9%type
120: ,attribute10 per_all_people_f.attribute10%type
121: ,attribute11 per_all_people_f.attribute11%type
122: ,attribute12 per_all_people_f.attribute12%type
123: ,attribute13 per_all_people_f.attribute13%type
116: ,attribute6 per_all_people_f.attribute6%type
117: ,attribute7 per_all_people_f.attribute7%type
118: ,attribute8 per_all_people_f.attribute8%type
119: ,attribute9 per_all_people_f.attribute9%type
120: ,attribute10 per_all_people_f.attribute10%type
121: ,attribute11 per_all_people_f.attribute11%type
122: ,attribute12 per_all_people_f.attribute12%type
123: ,attribute13 per_all_people_f.attribute13%type
124: ,attribute14 per_all_people_f.attribute14%type
117: ,attribute7 per_all_people_f.attribute7%type
118: ,attribute8 per_all_people_f.attribute8%type
119: ,attribute9 per_all_people_f.attribute9%type
120: ,attribute10 per_all_people_f.attribute10%type
121: ,attribute11 per_all_people_f.attribute11%type
122: ,attribute12 per_all_people_f.attribute12%type
123: ,attribute13 per_all_people_f.attribute13%type
124: ,attribute14 per_all_people_f.attribute14%type
125: ,attribute15 per_all_people_f.attribute15%type
118: ,attribute8 per_all_people_f.attribute8%type
119: ,attribute9 per_all_people_f.attribute9%type
120: ,attribute10 per_all_people_f.attribute10%type
121: ,attribute11 per_all_people_f.attribute11%type
122: ,attribute12 per_all_people_f.attribute12%type
123: ,attribute13 per_all_people_f.attribute13%type
124: ,attribute14 per_all_people_f.attribute14%type
125: ,attribute15 per_all_people_f.attribute15%type
126: ,attribute16 per_all_people_f.attribute16%type
119: ,attribute9 per_all_people_f.attribute9%type
120: ,attribute10 per_all_people_f.attribute10%type
121: ,attribute11 per_all_people_f.attribute11%type
122: ,attribute12 per_all_people_f.attribute12%type
123: ,attribute13 per_all_people_f.attribute13%type
124: ,attribute14 per_all_people_f.attribute14%type
125: ,attribute15 per_all_people_f.attribute15%type
126: ,attribute16 per_all_people_f.attribute16%type
127: ,attribute17 per_all_people_f.attribute17%type
120: ,attribute10 per_all_people_f.attribute10%type
121: ,attribute11 per_all_people_f.attribute11%type
122: ,attribute12 per_all_people_f.attribute12%type
123: ,attribute13 per_all_people_f.attribute13%type
124: ,attribute14 per_all_people_f.attribute14%type
125: ,attribute15 per_all_people_f.attribute15%type
126: ,attribute16 per_all_people_f.attribute16%type
127: ,attribute17 per_all_people_f.attribute17%type
128: ,attribute18 per_all_people_f.attribute18%type
121: ,attribute11 per_all_people_f.attribute11%type
122: ,attribute12 per_all_people_f.attribute12%type
123: ,attribute13 per_all_people_f.attribute13%type
124: ,attribute14 per_all_people_f.attribute14%type
125: ,attribute15 per_all_people_f.attribute15%type
126: ,attribute16 per_all_people_f.attribute16%type
127: ,attribute17 per_all_people_f.attribute17%type
128: ,attribute18 per_all_people_f.attribute18%type
129: ,attribute19 per_all_people_f.attribute19%type
122: ,attribute12 per_all_people_f.attribute12%type
123: ,attribute13 per_all_people_f.attribute13%type
124: ,attribute14 per_all_people_f.attribute14%type
125: ,attribute15 per_all_people_f.attribute15%type
126: ,attribute16 per_all_people_f.attribute16%type
127: ,attribute17 per_all_people_f.attribute17%type
128: ,attribute18 per_all_people_f.attribute18%type
129: ,attribute19 per_all_people_f.attribute19%type
130: ,attribute20 per_all_people_f.attribute20%type
123: ,attribute13 per_all_people_f.attribute13%type
124: ,attribute14 per_all_people_f.attribute14%type
125: ,attribute15 per_all_people_f.attribute15%type
126: ,attribute16 per_all_people_f.attribute16%type
127: ,attribute17 per_all_people_f.attribute17%type
128: ,attribute18 per_all_people_f.attribute18%type
129: ,attribute19 per_all_people_f.attribute19%type
130: ,attribute20 per_all_people_f.attribute20%type
131: ,attribute21 per_all_people_f.attribute21%type
124: ,attribute14 per_all_people_f.attribute14%type
125: ,attribute15 per_all_people_f.attribute15%type
126: ,attribute16 per_all_people_f.attribute16%type
127: ,attribute17 per_all_people_f.attribute17%type
128: ,attribute18 per_all_people_f.attribute18%type
129: ,attribute19 per_all_people_f.attribute19%type
130: ,attribute20 per_all_people_f.attribute20%type
131: ,attribute21 per_all_people_f.attribute21%type
132: ,attribute22 per_all_people_f.attribute22%type
125: ,attribute15 per_all_people_f.attribute15%type
126: ,attribute16 per_all_people_f.attribute16%type
127: ,attribute17 per_all_people_f.attribute17%type
128: ,attribute18 per_all_people_f.attribute18%type
129: ,attribute19 per_all_people_f.attribute19%type
130: ,attribute20 per_all_people_f.attribute20%type
131: ,attribute21 per_all_people_f.attribute21%type
132: ,attribute22 per_all_people_f.attribute22%type
133: ,attribute23 per_all_people_f.attribute23%type
126: ,attribute16 per_all_people_f.attribute16%type
127: ,attribute17 per_all_people_f.attribute17%type
128: ,attribute18 per_all_people_f.attribute18%type
129: ,attribute19 per_all_people_f.attribute19%type
130: ,attribute20 per_all_people_f.attribute20%type
131: ,attribute21 per_all_people_f.attribute21%type
132: ,attribute22 per_all_people_f.attribute22%type
133: ,attribute23 per_all_people_f.attribute23%type
134: ,attribute24 per_all_people_f.attribute24%type
127: ,attribute17 per_all_people_f.attribute17%type
128: ,attribute18 per_all_people_f.attribute18%type
129: ,attribute19 per_all_people_f.attribute19%type
130: ,attribute20 per_all_people_f.attribute20%type
131: ,attribute21 per_all_people_f.attribute21%type
132: ,attribute22 per_all_people_f.attribute22%type
133: ,attribute23 per_all_people_f.attribute23%type
134: ,attribute24 per_all_people_f.attribute24%type
135: ,attribute25 per_all_people_f.attribute25%type
128: ,attribute18 per_all_people_f.attribute18%type
129: ,attribute19 per_all_people_f.attribute19%type
130: ,attribute20 per_all_people_f.attribute20%type
131: ,attribute21 per_all_people_f.attribute21%type
132: ,attribute22 per_all_people_f.attribute22%type
133: ,attribute23 per_all_people_f.attribute23%type
134: ,attribute24 per_all_people_f.attribute24%type
135: ,attribute25 per_all_people_f.attribute25%type
136: ,attribute26 per_all_people_f.attribute26%type
129: ,attribute19 per_all_people_f.attribute19%type
130: ,attribute20 per_all_people_f.attribute20%type
131: ,attribute21 per_all_people_f.attribute21%type
132: ,attribute22 per_all_people_f.attribute22%type
133: ,attribute23 per_all_people_f.attribute23%type
134: ,attribute24 per_all_people_f.attribute24%type
135: ,attribute25 per_all_people_f.attribute25%type
136: ,attribute26 per_all_people_f.attribute26%type
137: ,attribute27 per_all_people_f.attribute27%type
130: ,attribute20 per_all_people_f.attribute20%type
131: ,attribute21 per_all_people_f.attribute21%type
132: ,attribute22 per_all_people_f.attribute22%type
133: ,attribute23 per_all_people_f.attribute23%type
134: ,attribute24 per_all_people_f.attribute24%type
135: ,attribute25 per_all_people_f.attribute25%type
136: ,attribute26 per_all_people_f.attribute26%type
137: ,attribute27 per_all_people_f.attribute27%type
138: ,attribute28 per_all_people_f.attribute28%type
131: ,attribute21 per_all_people_f.attribute21%type
132: ,attribute22 per_all_people_f.attribute22%type
133: ,attribute23 per_all_people_f.attribute23%type
134: ,attribute24 per_all_people_f.attribute24%type
135: ,attribute25 per_all_people_f.attribute25%type
136: ,attribute26 per_all_people_f.attribute26%type
137: ,attribute27 per_all_people_f.attribute27%type
138: ,attribute28 per_all_people_f.attribute28%type
139: ,attribute29 per_all_people_f.attribute29%type
132: ,attribute22 per_all_people_f.attribute22%type
133: ,attribute23 per_all_people_f.attribute23%type
134: ,attribute24 per_all_people_f.attribute24%type
135: ,attribute25 per_all_people_f.attribute25%type
136: ,attribute26 per_all_people_f.attribute26%type
137: ,attribute27 per_all_people_f.attribute27%type
138: ,attribute28 per_all_people_f.attribute28%type
139: ,attribute29 per_all_people_f.attribute29%type
140: ,attribute30 per_all_people_f.attribute30%type
133: ,attribute23 per_all_people_f.attribute23%type
134: ,attribute24 per_all_people_f.attribute24%type
135: ,attribute25 per_all_people_f.attribute25%type
136: ,attribute26 per_all_people_f.attribute26%type
137: ,attribute27 per_all_people_f.attribute27%type
138: ,attribute28 per_all_people_f.attribute28%type
139: ,attribute29 per_all_people_f.attribute29%type
140: ,attribute30 per_all_people_f.attribute30%type
141: ,per_information_category per_all_people_f.per_information_category%type
134: ,attribute24 per_all_people_f.attribute24%type
135: ,attribute25 per_all_people_f.attribute25%type
136: ,attribute26 per_all_people_f.attribute26%type
137: ,attribute27 per_all_people_f.attribute27%type
138: ,attribute28 per_all_people_f.attribute28%type
139: ,attribute29 per_all_people_f.attribute29%type
140: ,attribute30 per_all_people_f.attribute30%type
141: ,per_information_category per_all_people_f.per_information_category%type
142: ,per_information1 per_all_people_f.attribute1%type
135: ,attribute25 per_all_people_f.attribute25%type
136: ,attribute26 per_all_people_f.attribute26%type
137: ,attribute27 per_all_people_f.attribute27%type
138: ,attribute28 per_all_people_f.attribute28%type
139: ,attribute29 per_all_people_f.attribute29%type
140: ,attribute30 per_all_people_f.attribute30%type
141: ,per_information_category per_all_people_f.per_information_category%type
142: ,per_information1 per_all_people_f.attribute1%type
143: ,per_information2 per_all_people_f.attribute2%type
136: ,attribute26 per_all_people_f.attribute26%type
137: ,attribute27 per_all_people_f.attribute27%type
138: ,attribute28 per_all_people_f.attribute28%type
139: ,attribute29 per_all_people_f.attribute29%type
140: ,attribute30 per_all_people_f.attribute30%type
141: ,per_information_category per_all_people_f.per_information_category%type
142: ,per_information1 per_all_people_f.attribute1%type
143: ,per_information2 per_all_people_f.attribute2%type
144: ,per_information3 per_all_people_f.attribute3%type
137: ,attribute27 per_all_people_f.attribute27%type
138: ,attribute28 per_all_people_f.attribute28%type
139: ,attribute29 per_all_people_f.attribute29%type
140: ,attribute30 per_all_people_f.attribute30%type
141: ,per_information_category per_all_people_f.per_information_category%type
142: ,per_information1 per_all_people_f.attribute1%type
143: ,per_information2 per_all_people_f.attribute2%type
144: ,per_information3 per_all_people_f.attribute3%type
145: ,per_information4 per_all_people_f.attribute4%type
138: ,attribute28 per_all_people_f.attribute28%type
139: ,attribute29 per_all_people_f.attribute29%type
140: ,attribute30 per_all_people_f.attribute30%type
141: ,per_information_category per_all_people_f.per_information_category%type
142: ,per_information1 per_all_people_f.attribute1%type
143: ,per_information2 per_all_people_f.attribute2%type
144: ,per_information3 per_all_people_f.attribute3%type
145: ,per_information4 per_all_people_f.attribute4%type
146: ,per_information5 per_all_people_f.attribute5%type
139: ,attribute29 per_all_people_f.attribute29%type
140: ,attribute30 per_all_people_f.attribute30%type
141: ,per_information_category per_all_people_f.per_information_category%type
142: ,per_information1 per_all_people_f.attribute1%type
143: ,per_information2 per_all_people_f.attribute2%type
144: ,per_information3 per_all_people_f.attribute3%type
145: ,per_information4 per_all_people_f.attribute4%type
146: ,per_information5 per_all_people_f.attribute5%type
147: ,per_information6 per_all_people_f.attribute6%type
140: ,attribute30 per_all_people_f.attribute30%type
141: ,per_information_category per_all_people_f.per_information_category%type
142: ,per_information1 per_all_people_f.attribute1%type
143: ,per_information2 per_all_people_f.attribute2%type
144: ,per_information3 per_all_people_f.attribute3%type
145: ,per_information4 per_all_people_f.attribute4%type
146: ,per_information5 per_all_people_f.attribute5%type
147: ,per_information6 per_all_people_f.attribute6%type
148: ,per_information7 per_all_people_f.attribute7%type
141: ,per_information_category per_all_people_f.per_information_category%type
142: ,per_information1 per_all_people_f.attribute1%type
143: ,per_information2 per_all_people_f.attribute2%type
144: ,per_information3 per_all_people_f.attribute3%type
145: ,per_information4 per_all_people_f.attribute4%type
146: ,per_information5 per_all_people_f.attribute5%type
147: ,per_information6 per_all_people_f.attribute6%type
148: ,per_information7 per_all_people_f.attribute7%type
149: ,per_information8 per_all_people_f.attribute8%type
142: ,per_information1 per_all_people_f.attribute1%type
143: ,per_information2 per_all_people_f.attribute2%type
144: ,per_information3 per_all_people_f.attribute3%type
145: ,per_information4 per_all_people_f.attribute4%type
146: ,per_information5 per_all_people_f.attribute5%type
147: ,per_information6 per_all_people_f.attribute6%type
148: ,per_information7 per_all_people_f.attribute7%type
149: ,per_information8 per_all_people_f.attribute8%type
150: ,per_information9 per_all_people_f.attribute9%type
143: ,per_information2 per_all_people_f.attribute2%type
144: ,per_information3 per_all_people_f.attribute3%type
145: ,per_information4 per_all_people_f.attribute4%type
146: ,per_information5 per_all_people_f.attribute5%type
147: ,per_information6 per_all_people_f.attribute6%type
148: ,per_information7 per_all_people_f.attribute7%type
149: ,per_information8 per_all_people_f.attribute8%type
150: ,per_information9 per_all_people_f.attribute9%type
151: ,per_information10 per_all_people_f.attribute10%type
144: ,per_information3 per_all_people_f.attribute3%type
145: ,per_information4 per_all_people_f.attribute4%type
146: ,per_information5 per_all_people_f.attribute5%type
147: ,per_information6 per_all_people_f.attribute6%type
148: ,per_information7 per_all_people_f.attribute7%type
149: ,per_information8 per_all_people_f.attribute8%type
150: ,per_information9 per_all_people_f.attribute9%type
151: ,per_information10 per_all_people_f.attribute10%type
152: ,per_information11 per_all_people_f.attribute11%type
145: ,per_information4 per_all_people_f.attribute4%type
146: ,per_information5 per_all_people_f.attribute5%type
147: ,per_information6 per_all_people_f.attribute6%type
148: ,per_information7 per_all_people_f.attribute7%type
149: ,per_information8 per_all_people_f.attribute8%type
150: ,per_information9 per_all_people_f.attribute9%type
151: ,per_information10 per_all_people_f.attribute10%type
152: ,per_information11 per_all_people_f.attribute11%type
153: ,per_information12 per_all_people_f.attribute12%type
146: ,per_information5 per_all_people_f.attribute5%type
147: ,per_information6 per_all_people_f.attribute6%type
148: ,per_information7 per_all_people_f.attribute7%type
149: ,per_information8 per_all_people_f.attribute8%type
150: ,per_information9 per_all_people_f.attribute9%type
151: ,per_information10 per_all_people_f.attribute10%type
152: ,per_information11 per_all_people_f.attribute11%type
153: ,per_information12 per_all_people_f.attribute12%type
154: ,per_information13 per_all_people_f.attribute13%type
147: ,per_information6 per_all_people_f.attribute6%type
148: ,per_information7 per_all_people_f.attribute7%type
149: ,per_information8 per_all_people_f.attribute8%type
150: ,per_information9 per_all_people_f.attribute9%type
151: ,per_information10 per_all_people_f.attribute10%type
152: ,per_information11 per_all_people_f.attribute11%type
153: ,per_information12 per_all_people_f.attribute12%type
154: ,per_information13 per_all_people_f.attribute13%type
155: ,per_information14 per_all_people_f.attribute14%type
148: ,per_information7 per_all_people_f.attribute7%type
149: ,per_information8 per_all_people_f.attribute8%type
150: ,per_information9 per_all_people_f.attribute9%type
151: ,per_information10 per_all_people_f.attribute10%type
152: ,per_information11 per_all_people_f.attribute11%type
153: ,per_information12 per_all_people_f.attribute12%type
154: ,per_information13 per_all_people_f.attribute13%type
155: ,per_information14 per_all_people_f.attribute14%type
156: ,per_information15 per_all_people_f.attribute15%type
149: ,per_information8 per_all_people_f.attribute8%type
150: ,per_information9 per_all_people_f.attribute9%type
151: ,per_information10 per_all_people_f.attribute10%type
152: ,per_information11 per_all_people_f.attribute11%type
153: ,per_information12 per_all_people_f.attribute12%type
154: ,per_information13 per_all_people_f.attribute13%type
155: ,per_information14 per_all_people_f.attribute14%type
156: ,per_information15 per_all_people_f.attribute15%type
157: ,per_information16 per_all_people_f.attribute16%type
150: ,per_information9 per_all_people_f.attribute9%type
151: ,per_information10 per_all_people_f.attribute10%type
152: ,per_information11 per_all_people_f.attribute11%type
153: ,per_information12 per_all_people_f.attribute12%type
154: ,per_information13 per_all_people_f.attribute13%type
155: ,per_information14 per_all_people_f.attribute14%type
156: ,per_information15 per_all_people_f.attribute15%type
157: ,per_information16 per_all_people_f.attribute16%type
158: ,per_information17 per_all_people_f.attribute17%type
151: ,per_information10 per_all_people_f.attribute10%type
152: ,per_information11 per_all_people_f.attribute11%type
153: ,per_information12 per_all_people_f.attribute12%type
154: ,per_information13 per_all_people_f.attribute13%type
155: ,per_information14 per_all_people_f.attribute14%type
156: ,per_information15 per_all_people_f.attribute15%type
157: ,per_information16 per_all_people_f.attribute16%type
158: ,per_information17 per_all_people_f.attribute17%type
159: ,per_information18 per_all_people_f.attribute18%type
152: ,per_information11 per_all_people_f.attribute11%type
153: ,per_information12 per_all_people_f.attribute12%type
154: ,per_information13 per_all_people_f.attribute13%type
155: ,per_information14 per_all_people_f.attribute14%type
156: ,per_information15 per_all_people_f.attribute15%type
157: ,per_information16 per_all_people_f.attribute16%type
158: ,per_information17 per_all_people_f.attribute17%type
159: ,per_information18 per_all_people_f.attribute18%type
160: ,per_information19 per_all_people_f.attribute19%type
153: ,per_information12 per_all_people_f.attribute12%type
154: ,per_information13 per_all_people_f.attribute13%type
155: ,per_information14 per_all_people_f.attribute14%type
156: ,per_information15 per_all_people_f.attribute15%type
157: ,per_information16 per_all_people_f.attribute16%type
158: ,per_information17 per_all_people_f.attribute17%type
159: ,per_information18 per_all_people_f.attribute18%type
160: ,per_information19 per_all_people_f.attribute19%type
161: ,per_information20 per_all_people_f.attribute20%type
154: ,per_information13 per_all_people_f.attribute13%type
155: ,per_information14 per_all_people_f.attribute14%type
156: ,per_information15 per_all_people_f.attribute15%type
157: ,per_information16 per_all_people_f.attribute16%type
158: ,per_information17 per_all_people_f.attribute17%type
159: ,per_information18 per_all_people_f.attribute18%type
160: ,per_information19 per_all_people_f.attribute19%type
161: ,per_information20 per_all_people_f.attribute20%type
162: ,per_information21 per_all_people_f.attribute21%type
155: ,per_information14 per_all_people_f.attribute14%type
156: ,per_information15 per_all_people_f.attribute15%type
157: ,per_information16 per_all_people_f.attribute16%type
158: ,per_information17 per_all_people_f.attribute17%type
159: ,per_information18 per_all_people_f.attribute18%type
160: ,per_information19 per_all_people_f.attribute19%type
161: ,per_information20 per_all_people_f.attribute20%type
162: ,per_information21 per_all_people_f.attribute21%type
163: ,per_information22 per_all_people_f.attribute22%type
156: ,per_information15 per_all_people_f.attribute15%type
157: ,per_information16 per_all_people_f.attribute16%type
158: ,per_information17 per_all_people_f.attribute17%type
159: ,per_information18 per_all_people_f.attribute18%type
160: ,per_information19 per_all_people_f.attribute19%type
161: ,per_information20 per_all_people_f.attribute20%type
162: ,per_information21 per_all_people_f.attribute21%type
163: ,per_information22 per_all_people_f.attribute22%type
164: ,per_information23 per_all_people_f.attribute23%type
157: ,per_information16 per_all_people_f.attribute16%type
158: ,per_information17 per_all_people_f.attribute17%type
159: ,per_information18 per_all_people_f.attribute18%type
160: ,per_information19 per_all_people_f.attribute19%type
161: ,per_information20 per_all_people_f.attribute20%type
162: ,per_information21 per_all_people_f.attribute21%type
163: ,per_information22 per_all_people_f.attribute22%type
164: ,per_information23 per_all_people_f.attribute23%type
165: ,per_information24 per_all_people_f.attribute24%type
158: ,per_information17 per_all_people_f.attribute17%type
159: ,per_information18 per_all_people_f.attribute18%type
160: ,per_information19 per_all_people_f.attribute19%type
161: ,per_information20 per_all_people_f.attribute20%type
162: ,per_information21 per_all_people_f.attribute21%type
163: ,per_information22 per_all_people_f.attribute22%type
164: ,per_information23 per_all_people_f.attribute23%type
165: ,per_information24 per_all_people_f.attribute24%type
166: ,per_information25 per_all_people_f.attribute25%type
159: ,per_information18 per_all_people_f.attribute18%type
160: ,per_information19 per_all_people_f.attribute19%type
161: ,per_information20 per_all_people_f.attribute20%type
162: ,per_information21 per_all_people_f.attribute21%type
163: ,per_information22 per_all_people_f.attribute22%type
164: ,per_information23 per_all_people_f.attribute23%type
165: ,per_information24 per_all_people_f.attribute24%type
166: ,per_information25 per_all_people_f.attribute25%type
167: ,per_information26 per_all_people_f.attribute26%type
160: ,per_information19 per_all_people_f.attribute19%type
161: ,per_information20 per_all_people_f.attribute20%type
162: ,per_information21 per_all_people_f.attribute21%type
163: ,per_information22 per_all_people_f.attribute22%type
164: ,per_information23 per_all_people_f.attribute23%type
165: ,per_information24 per_all_people_f.attribute24%type
166: ,per_information25 per_all_people_f.attribute25%type
167: ,per_information26 per_all_people_f.attribute26%type
168: ,per_information27 per_all_people_f.attribute27%type
161: ,per_information20 per_all_people_f.attribute20%type
162: ,per_information21 per_all_people_f.attribute21%type
163: ,per_information22 per_all_people_f.attribute22%type
164: ,per_information23 per_all_people_f.attribute23%type
165: ,per_information24 per_all_people_f.attribute24%type
166: ,per_information25 per_all_people_f.attribute25%type
167: ,per_information26 per_all_people_f.attribute26%type
168: ,per_information27 per_all_people_f.attribute27%type
169: ,per_information28 per_all_people_f.attribute28%type
162: ,per_information21 per_all_people_f.attribute21%type
163: ,per_information22 per_all_people_f.attribute22%type
164: ,per_information23 per_all_people_f.attribute23%type
165: ,per_information24 per_all_people_f.attribute24%type
166: ,per_information25 per_all_people_f.attribute25%type
167: ,per_information26 per_all_people_f.attribute26%type
168: ,per_information27 per_all_people_f.attribute27%type
169: ,per_information28 per_all_people_f.attribute28%type
170: ,per_information29 per_all_people_f.attribute29%type
163: ,per_information22 per_all_people_f.attribute22%type
164: ,per_information23 per_all_people_f.attribute23%type
165: ,per_information24 per_all_people_f.attribute24%type
166: ,per_information25 per_all_people_f.attribute25%type
167: ,per_information26 per_all_people_f.attribute26%type
168: ,per_information27 per_all_people_f.attribute27%type
169: ,per_information28 per_all_people_f.attribute28%type
170: ,per_information29 per_all_people_f.attribute29%type
171: ,per_information30 per_all_people_f.attribute30%type
164: ,per_information23 per_all_people_f.attribute23%type
165: ,per_information24 per_all_people_f.attribute24%type
166: ,per_information25 per_all_people_f.attribute25%type
167: ,per_information26 per_all_people_f.attribute26%type
168: ,per_information27 per_all_people_f.attribute27%type
169: ,per_information28 per_all_people_f.attribute28%type
170: ,per_information29 per_all_people_f.attribute29%type
171: ,per_information30 per_all_people_f.attribute30%type
172: ,date_of_death per_all_people_f.date_of_death%type
165: ,per_information24 per_all_people_f.attribute24%type
166: ,per_information25 per_all_people_f.attribute25%type
167: ,per_information26 per_all_people_f.attribute26%type
168: ,per_information27 per_all_people_f.attribute27%type
169: ,per_information28 per_all_people_f.attribute28%type
170: ,per_information29 per_all_people_f.attribute29%type
171: ,per_information30 per_all_people_f.attribute30%type
172: ,date_of_death per_all_people_f.date_of_death%type
173: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
166: ,per_information25 per_all_people_f.attribute25%type
167: ,per_information26 per_all_people_f.attribute26%type
168: ,per_information27 per_all_people_f.attribute27%type
169: ,per_information28 per_all_people_f.attribute28%type
170: ,per_information29 per_all_people_f.attribute29%type
171: ,per_information30 per_all_people_f.attribute30%type
172: ,date_of_death per_all_people_f.date_of_death%type
173: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
174: ,town_of_birth per_all_people_f.town_of_birth%type
167: ,per_information26 per_all_people_f.attribute26%type
168: ,per_information27 per_all_people_f.attribute27%type
169: ,per_information28 per_all_people_f.attribute28%type
170: ,per_information29 per_all_people_f.attribute29%type
171: ,per_information30 per_all_people_f.attribute30%type
172: ,date_of_death per_all_people_f.date_of_death%type
173: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
174: ,town_of_birth per_all_people_f.town_of_birth%type
175: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
168: ,per_information27 per_all_people_f.attribute27%type
169: ,per_information28 per_all_people_f.attribute28%type
170: ,per_information29 per_all_people_f.attribute29%type
171: ,per_information30 per_all_people_f.attribute30%type
172: ,date_of_death per_all_people_f.date_of_death%type
173: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
174: ,town_of_birth per_all_people_f.town_of_birth%type
175: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
176: ,region_of_birth per_all_people_f.region_of_birth%type
169: ,per_information28 per_all_people_f.attribute28%type
170: ,per_information29 per_all_people_f.attribute29%type
171: ,per_information30 per_all_people_f.attribute30%type
172: ,date_of_death per_all_people_f.date_of_death%type
173: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
174: ,town_of_birth per_all_people_f.town_of_birth%type
175: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
176: ,region_of_birth per_all_people_f.region_of_birth%type
177: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
170: ,per_information29 per_all_people_f.attribute29%type
171: ,per_information30 per_all_people_f.attribute30%type
172: ,date_of_death per_all_people_f.date_of_death%type
173: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
174: ,town_of_birth per_all_people_f.town_of_birth%type
175: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
176: ,region_of_birth per_all_people_f.region_of_birth%type
177: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
178: ,country_of_birth per_all_people_f.country_of_birth%type
171: ,per_information30 per_all_people_f.attribute30%type
172: ,date_of_death per_all_people_f.date_of_death%type
173: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
174: ,town_of_birth per_all_people_f.town_of_birth%type
175: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
176: ,region_of_birth per_all_people_f.region_of_birth%type
177: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
178: ,country_of_birth per_all_people_f.country_of_birth%type
179: ,country_of_birth_meaning per_all_people_f.country_of_birth%type
172: ,date_of_death per_all_people_f.date_of_death%type
173: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
174: ,town_of_birth per_all_people_f.town_of_birth%type
175: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
176: ,region_of_birth per_all_people_f.region_of_birth%type
177: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
178: ,country_of_birth per_all_people_f.country_of_birth%type
179: ,country_of_birth_meaning per_all_people_f.country_of_birth%type
180: ,per_object_version_number per_all_people_f.object_version_number%type
173: ,original_date_of_hire per_all_people_f.original_date_of_hire%type
174: ,town_of_birth per_all_people_f.town_of_birth%type
175: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
176: ,region_of_birth per_all_people_f.region_of_birth%type
177: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
178: ,country_of_birth per_all_people_f.country_of_birth%type
179: ,country_of_birth_meaning per_all_people_f.country_of_birth%type
180: ,per_object_version_number per_all_people_f.object_version_number%type
181: ,person_update_allowed varchar2(5)
174: ,town_of_birth per_all_people_f.town_of_birth%type
175: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
176: ,region_of_birth per_all_people_f.region_of_birth%type
177: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
178: ,country_of_birth per_all_people_f.country_of_birth%type
179: ,country_of_birth_meaning per_all_people_f.country_of_birth%type
180: ,per_object_version_number per_all_people_f.object_version_number%type
181: ,person_update_allowed varchar2(5)
182: ,assignment_id per_all_assignments_f.assignment_id%type
175: ,town_of_birth_meaning per_all_people_f.town_of_birth%type
176: ,region_of_birth per_all_people_f.region_of_birth%type
177: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
178: ,country_of_birth per_all_people_f.country_of_birth%type
179: ,country_of_birth_meaning per_all_people_f.country_of_birth%type
180: ,per_object_version_number per_all_people_f.object_version_number%type
181: ,person_update_allowed varchar2(5)
182: ,assignment_id per_all_assignments_f.assignment_id%type
183: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
176: ,region_of_birth per_all_people_f.region_of_birth%type
177: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
178: ,country_of_birth per_all_people_f.country_of_birth%type
179: ,country_of_birth_meaning per_all_people_f.country_of_birth%type
180: ,per_object_version_number per_all_people_f.object_version_number%type
181: ,person_update_allowed varchar2(5)
182: ,assignment_id per_all_assignments_f.assignment_id%type
183: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
184: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type
183: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
184: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type
185: ,asg_validation_start_date date
186: ,asg_validation_end_date date
187: ,recruiter per_all_people_f.full_name%type
188: ,recruiter_id per_all_assignments_f.recruiter_id%type
189: ,grade per_grades.name%type
190: ,grade_id per_all_assignments_f.grade_id%type
191: ,position hr_all_positions_f.name%type
198: ,payroll pay_all_payrolls_f.payroll_name%type
199: ,payroll_id per_all_assignments_f.payroll_id%type
200: ,location hr_locations.location_code%type
201: ,location_id per_all_assignments_f.location_id%type
202: ,person_referred_by per_all_people_f.full_name%type
203: ,person_referred_by_id per_all_assignments_f.person_referred_by_id%type
204: ,supervisor per_all_people_f.full_name%type
205: ,supervisor_id per_all_assignments_f.supervisor_id%type
206: ,recruitment_activity per_recruitment_activities.name%type
200: ,location hr_locations.location_code%type
201: ,location_id per_all_assignments_f.location_id%type
202: ,person_referred_by per_all_people_f.full_name%type
203: ,person_referred_by_id per_all_assignments_f.person_referred_by_id%type
204: ,supervisor per_all_people_f.full_name%type
205: ,supervisor_id per_all_assignments_f.supervisor_id%type
206: ,recruitment_activity per_recruitment_activities.name%type
207: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type
208: ,source_organization hr_all_organization_units.name%type