Table p_unit
Diagram PartnerClasses 
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 default: CURRENT_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_partner_ledger,
a_ep_match, 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_gift_destination,
p_partner_set, p_foundation_proposal_detail, p_foundation_proposal_detail,
p_foundation_proposal_detail