Description:
This table is used to describe how a partner first came into contact with the organisation. Which department entered them.

PRIMARY KEY
p_acquisition_code_c varchar (16) NOT NULL	This code identifies the method of aquisition.

p_acquisition_description_c varchar (160) NOT NULL	This describes the method of aquisition.
p_valid_acquisition_l boolean default: '1'	Defines if the acquisition code is still for use
p_deletable_l boolean default: '1' NOT NULL	This defines if the acquisition code can be deleted. This can only be updated by the system manager. At the risk of serious operational integrity. Default to Yes
p_recruiting_effort_l boolean default: '0'	This defines if the acquisition code listed represents a recruiting effort.
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_acquisition_fkcr: s_created_by_c => s_user p_acquisition_fkmd: s_modified_by_c => s_user
REFERENCED BY p_partner