Description:
Details of a unit. This is an organizational unit such as an om field, department, local cost center, etc.
|
| PRIMARY KEY |
|
p_partner_key_n
bigint NOT NULL |
This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number.
| p_partner |
|
|
p_unit_name_c
varchar (160) |
| |
|
p_description_c
varchar (1000) |
| |
|
u_unit_type_code_c
varchar (24) |
| u_unit_type |
|
um_minimum_i
integer default: 0 |
Indicates the minimum number of staff required. (Computed from um_jobs.)
| |
|
um_maximum_i
integer default: 0 |
Indicates the maximum number of staff required. (Computed from um_jobs.)
| |
|
um_present_i
integer default: 0 |
Indicates the present number on staff. (Computed from um_jobs.)
| |
|
um_part_timers_i
integer default: 0 |
Number of part-timers acceptable. (Computed from um_jobs.)
| |
|
p_outreach_code_c
varchar (26) |
todo
| |
|
p_outreach_cost_n
numeric (24, 10) default: 0 NOT NULL |
This is the cost of the outreach/Event
| |
|
p_outreach_cost_currency_code_c
varchar (16) |
This is the currency that is used for the outreach cost.
| a_currency |
|
p_country_code_c
varchar (8) default: '99' |
This is a code which identifies a country. It is the ISO code
| p_country |
|
p_primary_office_n
bigint default: 0 NOT NULL |
The partner key of the office that will be this field's primary office..
| p_partner |
|
s_date_created_d
date default: CURRENT_DATE |
The date the record was created.
| |
|
s_created_by_c
varchar (20) |
User ID of who created this record.
| s_user |
|
s_date_modified_d
date |
The date the record was modified.
| |
|
s_modified_by_c
varchar (20) |
User ID of who last modified this record.
| s_user |
|
s_modification_id_t
timestamp |
This identifies the current version of the record.
| |
FOREIGN KEY
p_unit_fk1: p_partner_key_n => p_partner
p_unit_fk2: u_unit_type_code_c => u_unit_type
p_unit_fk3: p_country_code_c => p_country
p_unit_fk4: p_outreach_cost_currency_code_c => a_currency
p_unit_fk7: p_primary_office_n => p_partner
p_unit_fkcr: s_created_by_c => s_user
p_unit_fkmd: s_modified_by_c => s_user
|
REFERENCED BY
um_unit_structure,
um_unit_structure,
p_family,
p_person,
a_ep_match,
p_partner_ledger,
a_transaction,
pm_general_application,
pm_general_application,
pm_short_term_application,
pm_short_term_application,
pm_short_term_application,
pm_staff_data,
pm_staff_data,
pm_staff_data,
pm_staff_data,
um_job,
um_unit_ability,
um_unit_language,
um_unit_cost,
um_unit_evaluation,
pc_conference,
pc_attendee,
pc_extra_cost,
p_partner_interest,
p_partner_field_of_service,
p_partner_set,
p_foundation_proposal_detail,
p_foundation_proposal_detail,
p_foundation_proposal_detail |
|