[Home] [Help]
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_chk_stat_meaning hr_lookups.meaning%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: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
12: ,start_date per_all_people_f.start_date%type
13: ,applicant_number per_all_people_f.applicant_number%type
14: ,background_chk_stat_meaning hr_lookups.meaning%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: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
19: ,date_of_birth per_all_people_f.date_of_birth%type
20: ,email_address per_all_people_f.email_address%type
13: ,applicant_number per_all_people_f.applicant_number%type
14: ,background_chk_stat_meaning hr_lookups.meaning%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: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
19: ,date_of_birth per_all_people_f.date_of_birth%type
20: ,email_address per_all_people_f.email_address%type
21: ,employee_number per_all_people_f.employee_number%type
18: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
19: ,date_of_birth per_all_people_f.date_of_birth%type
20: ,email_address per_all_people_f.email_address%type
21: ,employee_number per_all_people_f.employee_number%type
22: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
23: ,first_name per_all_people_f.first_name%type
24: ,per_fte_capacity per_all_people_f.fte_capacity%type
25: ,full_name per_all_people_f.full_name%type
26: --CWK
39: ,known_as per_all_people_f.known_as%type
40: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
41: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
42: ,mailstop per_all_people_f.mailstop%type
43: ,marital_status_meaning hr_lookups.meaning%type
44: ,middle_names per_all_people_f.middle_names%type
45: ,nationality_meaning hr_lookups.meaning%type
46: ,national_identifier per_all_people_f.national_identifier%type
47: ,office_number per_all_people_f.office_number%type
41: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
42: ,mailstop per_all_people_f.mailstop%type
43: ,marital_status_meaning hr_lookups.meaning%type
44: ,middle_names per_all_people_f.middle_names%type
45: ,nationality_meaning hr_lookups.meaning%type
46: ,national_identifier per_all_people_f.national_identifier%type
47: ,office_number per_all_people_f.office_number%type
48: ,on_military_service_meaning hr_lookups.meaning%type
49: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
44: ,middle_names per_all_people_f.middle_names%type
45: ,nationality_meaning hr_lookups.meaning%type
46: ,national_identifier per_all_people_f.national_identifier%type
47: ,office_number per_all_people_f.office_number%type
48: ,on_military_service_meaning hr_lookups.meaning%type
49: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
50: ,previous_last_name per_all_people_f.previous_last_name%type
51: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
52: ,resume_exists_meaning hr_lookups.meaning%type
48: ,on_military_service_meaning hr_lookups.meaning%type
49: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
50: ,previous_last_name per_all_people_f.previous_last_name%type
51: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
52: ,resume_exists_meaning hr_lookups.meaning%type
53: ,resume_last_updated per_all_people_f.resume_last_updated%type
54: -- Bug 3037019
55: ,registered_disabled_flag hr_lookups.meaning%type
56: ,secnd_passport_exsts_meaning hr_lookups.meaning%type
51: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
52: ,resume_exists_meaning hr_lookups.meaning%type
53: ,resume_last_updated per_all_people_f.resume_last_updated%type
54: -- Bug 3037019
55: ,registered_disabled_flag hr_lookups.meaning%type
56: ,secnd_passport_exsts_meaning hr_lookups.meaning%type
57: ,sex_meaning hr_lookups.meaning%type
58: ,student_status_meaning hr_lookups.meaning%type
59: ,suffix per_all_people_f.suffix%type
52: ,resume_exists_meaning hr_lookups.meaning%type
53: ,resume_last_updated per_all_people_f.resume_last_updated%type
54: -- Bug 3037019
55: ,registered_disabled_flag hr_lookups.meaning%type
56: ,secnd_passport_exsts_meaning hr_lookups.meaning%type
57: ,sex_meaning hr_lookups.meaning%type
58: ,student_status_meaning hr_lookups.meaning%type
59: ,suffix per_all_people_f.suffix%type
60: ,title_meaning hr_lookups.meaning%type
53: ,resume_last_updated per_all_people_f.resume_last_updated%type
54: -- Bug 3037019
55: ,registered_disabled_flag hr_lookups.meaning%type
56: ,secnd_passport_exsts_meaning hr_lookups.meaning%type
57: ,sex_meaning hr_lookups.meaning%type
58: ,student_status_meaning hr_lookups.meaning%type
59: ,suffix per_all_people_f.suffix%type
60: ,title_meaning hr_lookups.meaning%type
61: ,work_schedule_meaning hr_lookups.meaning%type
54: -- Bug 3037019
55: ,registered_disabled_flag hr_lookups.meaning%type
56: ,secnd_passport_exsts_meaning hr_lookups.meaning%type
57: ,sex_meaning hr_lookups.meaning%type
58: ,student_status_meaning hr_lookups.meaning%type
59: ,suffix per_all_people_f.suffix%type
60: ,title_meaning hr_lookups.meaning%type
61: ,work_schedule_meaning hr_lookups.meaning%type
62: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
56: ,secnd_passport_exsts_meaning hr_lookups.meaning%type
57: ,sex_meaning hr_lookups.meaning%type
58: ,student_status_meaning hr_lookups.meaning%type
59: ,suffix per_all_people_f.suffix%type
60: ,title_meaning hr_lookups.meaning%type
61: ,work_schedule_meaning hr_lookups.meaning%type
62: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
63: ,cord_ben_no_cvg_flag_meaning hr_lookups.meaning%type
64: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
57: ,sex_meaning hr_lookups.meaning%type
58: ,student_status_meaning hr_lookups.meaning%type
59: ,suffix per_all_people_f.suffix%type
60: ,title_meaning hr_lookups.meaning%type
61: ,work_schedule_meaning hr_lookups.meaning%type
62: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
63: ,cord_ben_no_cvg_flag_meaning hr_lookups.meaning%type
64: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
65: ,dpdnt_vlntry_svc_flg_meaning hr_lookups.meaning%type
59: ,suffix per_all_people_f.suffix%type
60: ,title_meaning hr_lookups.meaning%type
61: ,work_schedule_meaning hr_lookups.meaning%type
62: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
63: ,cord_ben_no_cvg_flag_meaning hr_lookups.meaning%type
64: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
65: ,dpdnt_vlntry_svc_flg_meaning hr_lookups.meaning%type
66: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
67: ,uses_tobacco_meaning hr_lookups.meaning%type
61: ,work_schedule_meaning hr_lookups.meaning%type
62: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
63: ,cord_ben_no_cvg_flag_meaning hr_lookups.meaning%type
64: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
65: ,dpdnt_vlntry_svc_flg_meaning hr_lookups.meaning%type
66: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
67: ,uses_tobacco_meaning hr_lookups.meaning%type
68: ,benefit_group ben_benfts_grp.name%type
69: /* These fields are no longer used because they may change
63: ,cord_ben_no_cvg_flag_meaning hr_lookups.meaning%type
64: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
65: ,dpdnt_vlntry_svc_flg_meaning hr_lookups.meaning%type
66: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
67: ,uses_tobacco_meaning hr_lookups.meaning%type
68: ,benefit_group ben_benfts_grp.name%type
69: /* These fields are no longer used because they may change
70: context on a row by row basis, making them meaningless in a table
71:
464: ,asg_primary_flag per_all_assignments_f.primary_flag%type
465: ,assignment_number per_all_assignments_f.assignment_number%type
466: ,date_probation_end per_all_assignments_f.date_probation_end%type
467: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
468: ,employment_category_meaning hr_lookups.meaning%type
469: ,frequency_meaning hr_lookups.meaning%type
470: ,normal_hours per_all_assignments_f.normal_hours%type
471: ,probation_period per_all_assignments_f.probation_period%type
472: ,probation_unit_meaning hr_lookups.meaning%type
465: ,assignment_number per_all_assignments_f.assignment_number%type
466: ,date_probation_end per_all_assignments_f.date_probation_end%type
467: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
468: ,employment_category_meaning hr_lookups.meaning%type
469: ,frequency_meaning hr_lookups.meaning%type
470: ,normal_hours per_all_assignments_f.normal_hours%type
471: ,probation_period per_all_assignments_f.probation_period%type
472: ,probation_unit_meaning hr_lookups.meaning%type
473: ,time_normal_finish per_all_assignments_f.time_normal_finish%type
468: ,employment_category_meaning hr_lookups.meaning%type
469: ,frequency_meaning hr_lookups.meaning%type
470: ,normal_hours per_all_assignments_f.normal_hours%type
471: ,probation_period per_all_assignments_f.probation_period%type
472: ,probation_unit_meaning hr_lookups.meaning%type
473: ,time_normal_finish per_all_assignments_f.time_normal_finish%type
474: ,time_normal_start per_all_assignments_f.time_normal_start%type
475: /* These fields are no longer used because they may change
476: context on a row by row basis, making them meaningless in a table
566: ,ass_attribute30 per_all_assignments_f.ass_attribute30%type
567: ,ass_attribute30_v varchar2(150)
568: ,ass_attribute30_m varchar2(150)
569: */
570: ,bargaining_unit_code_meaning hr_lookups.meaning%type
571: ,labour_union_member_flag per_all_assignments_f.labour_union_member_flag%type
572: ,hourly_salaried_meaning hr_lookups.meaning%type
573: ,special_ceiling_step number
574: ,special_ceiling_point per_spinal_points.spinal_point%type
568: ,ass_attribute30_m varchar2(150)
569: */
570: ,bargaining_unit_code_meaning hr_lookups.meaning%type
571: ,labour_union_member_flag per_all_assignments_f.labour_union_member_flag%type
572: ,hourly_salaried_meaning hr_lookups.meaning%type
573: ,special_ceiling_step number
574: ,special_ceiling_point per_spinal_points.spinal_point%type
575: ,change_reason_meaning hr_lookups.meaning%type
576: ,internal_address_line per_all_assignments_f.internal_address_line%type
571: ,labour_union_member_flag per_all_assignments_f.labour_union_member_flag%type
572: ,hourly_salaried_meaning hr_lookups.meaning%type
573: ,special_ceiling_step number
574: ,special_ceiling_point per_spinal_points.spinal_point%type
575: ,change_reason_meaning hr_lookups.meaning%type
576: ,internal_address_line per_all_assignments_f.internal_address_line%type
577: ,manager_flag per_all_assignments_f.manager_flag%type
578: ,perf_review_period per_all_assignments_f.perf_review_period%type
579: ,perf_rev_period_freq_meaning hr_lookups.meaning%type
575: ,change_reason_meaning hr_lookups.meaning%type
576: ,internal_address_line per_all_assignments_f.internal_address_line%type
577: ,manager_flag per_all_assignments_f.manager_flag%type
578: ,perf_review_period per_all_assignments_f.perf_review_period%type
579: ,perf_rev_period_freq_meaning hr_lookups.meaning%type
580: ,sal_review_period per_all_assignments_f.sal_review_period%type
581: ,sal_rev_period_freq_meaning hr_lookups.meaning%type
582: ,source_type_meaning hr_lookups.meaning%type
583: ,contract per_contracts_f.reference%type
577: ,manager_flag per_all_assignments_f.manager_flag%type
578: ,perf_review_period per_all_assignments_f.perf_review_period%type
579: ,perf_rev_period_freq_meaning hr_lookups.meaning%type
580: ,sal_review_period per_all_assignments_f.sal_review_period%type
581: ,sal_rev_period_freq_meaning hr_lookups.meaning%type
582: ,source_type_meaning hr_lookups.meaning%type
583: ,contract per_contracts_f.reference%type
584: ,collective_agreement per_collective_agreements.name%type
585: ,cagr_id_flex_name fnd_id_flex_structures_v.id_flex_structure_name%type
578: ,perf_review_period per_all_assignments_f.perf_review_period%type
579: ,perf_rev_period_freq_meaning hr_lookups.meaning%type
580: ,sal_review_period per_all_assignments_f.sal_review_period%type
581: ,sal_rev_period_freq_meaning hr_lookups.meaning%type
582: ,source_type_meaning hr_lookups.meaning%type
583: ,contract per_contracts_f.reference%type
584: ,collective_agreement per_collective_agreements.name%type
585: ,cagr_id_flex_name fnd_id_flex_structures_v.id_flex_structure_name%type
586: ,cagr_grade varchar2(1)
621: ,first_name per_all_people_f.first_name%type default null
622: ,full_name per_all_people_f.full_name%type default null
623: ,title per_all_people_f.title%type
624: ,middle_names per_all_people_f.middle_names%type
625: ,nationality_meaning hr_lookups.meaning%type default null
626: ,nationality per_all_people_f.nationality%type default null
627: ,national_identifier per_all_people_f.national_identifier%type default null
628: -- Bug 3037019
629: ,registered_disabled_flag hr_lookups.meaning%type default null
625: ,nationality_meaning hr_lookups.meaning%type default null
626: ,nationality per_all_people_f.nationality%type default null
627: ,national_identifier per_all_people_f.national_identifier%type default null
628: -- Bug 3037019
629: ,registered_disabled_flag hr_lookups.meaning%type default null
630: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
631: ,sex_meaning hr_lookups.meaning%type default null
632: ,sex per_all_people_f.sex%type default null
633: ,benefit_group ben_benfts_grp.name%type default null
627: ,national_identifier per_all_people_f.national_identifier%type default null
628: -- Bug 3037019
629: ,registered_disabled_flag hr_lookups.meaning%type default null
630: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
631: ,sex_meaning hr_lookups.meaning%type default null
632: ,sex per_all_people_f.sex%type default null
633: ,benefit_group ben_benfts_grp.name%type default null
634: ,benefit_group_id per_all_people_f.benefit_group_id%type default null
635: ,grade per_grades.name%type default null
661: ,requisition per_requisitions.name%type default null
662: ,requisition_id per_requisitions.requisition_id%type default null
663: ,salary_basis per_pay_bases.name%type default null
664: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
665: ,bargaining_unit_code_meaning hr_lookups.meaning%type default null
666: ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null
667: ,employment_category_meaning hr_lookups.meaning%type default null
668: ,employment_category per_all_assignments_f.employment_category%type default null
669: ,establishment hr_leg_establishments_v.name%type default null
663: ,salary_basis per_pay_bases.name%type default null
664: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
665: ,bargaining_unit_code_meaning hr_lookups.meaning%type default null
666: ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null
667: ,employment_category_meaning hr_lookups.meaning%type default null
668: ,employment_category per_all_assignments_f.employment_category%type default null
669: ,establishment hr_leg_establishments_v.name%type default null
670: ,establishment_id hr_leg_establishments_v.organization_id%type default null
671: ,projected_hire_date per_applications.projected_hire_date%type default null
725: ,first_name in per_all_people_f.first_name%type default null
726: ,full_name in per_all_people_f.full_name%type default null
727: ,title per_all_people_f.title%type
728: ,middle_names per_all_people_f.middle_names%type
729: ,nationality_meaning in hr_lookups.meaning%type default null
730: ,nationality in per_all_people_f.nationality%type default null
731: ,national_identifier in per_all_people_f.national_identifier%type default null
732: -- Bug 3037019
733: ,registered_disabled_flag in hr_lookups.meaning%type default null
729: ,nationality_meaning in hr_lookups.meaning%type default null
730: ,nationality in per_all_people_f.nationality%type default null
731: ,national_identifier in per_all_people_f.national_identifier%type default null
732: -- Bug 3037019
733: ,registered_disabled_flag in hr_lookups.meaning%type default null
734: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
735: ,sex_meaning in hr_lookups.meaning%type default null
736: ,sex in per_all_people_f.sex%type default null
737: ,benefit_group in ben_benfts_grp.name%type default null
731: ,national_identifier in per_all_people_f.national_identifier%type default null
732: -- Bug 3037019
733: ,registered_disabled_flag in hr_lookups.meaning%type default null
734: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
735: ,sex_meaning in hr_lookups.meaning%type default null
736: ,sex in per_all_people_f.sex%type default null
737: ,benefit_group in ben_benfts_grp.name%type default null
738: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
739: ,grade in per_grades.name%type default null
765: ,requisition in per_requisitions.name%type default null
766: ,requisition_id in per_requisitions.requisition_id%type default null
767: ,salary_basis in per_pay_bases.name%type default null
768: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
769: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
770: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
771: ,employment_category_meaning in hr_lookups.meaning%type default null
772: ,employment_category in per_all_assignments_f.employment_category%type default null
773: ,establishment in hr_leg_establishments_v.name%type default null
767: ,salary_basis in per_pay_bases.name%type default null
768: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
769: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
770: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
771: ,employment_category_meaning in hr_lookups.meaning%type default null
772: ,employment_category in per_all_assignments_f.employment_category%type default null
773: ,establishment in hr_leg_establishments_v.name%type default null
774: ,establishment_id in hr_leg_establishments_v.organization_id%type default null
775: ,projected_hire_date in per_applications.projected_hire_date%type default null