Table p_partner_status
Diagram PartnerEdit 
Description:
List of statuses for partners
PRIMARY KEY
p_status_code_c
varchar (16) NOT NULL
This code describes the status of a partner. Eg, Active, Deceased etc

p_partner_status_description_c
varchar (120) NOT NULL
p_partner_is_active_l
boolean default: '1'
If set to yes, then Partners with this status are considered as active Partners
p_include_partner_on_report_l
boolean default: '0'
p_deletable_l
boolean default: '1' NOT NULL
This defines if the partner status code can be deleted. This can only be updated by the system manager. At the risk of serious operational integrity. Default to Yes
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_partner_status_fkcr: s_created_by_c => s_user
p_partner_status_fkmd: s_modified_by_c => s_user


REFERENCED BY
p_partner