Table p_foundation_proposal

Description:
Proposals submitted to a Foundation

PRIMARY KEY
p_foundation_partner_key_n bigint NOT NULL		p_foundation
p_foundation_proposal_key_i integer NOT NULL

p_proposal_status_c varchar (30)		p_foundation_proposal_status
p_proposal_notes_c varchar (700)
p_submitted_date_d date
p_amount_requested_n numeric (19, 2)
p_amount_approved_n numeric (19, 2)
p_amount_granted_n numeric (19, 2)
p_date_granted_d date
p_partner_submitted_by_n bigint	The F.D. person who sent the proposal	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_foundation_proposal_fkcr: s_created_by_c => s_user p_foundation_proposal_fkmd: s_modified_by_c => s_user p_proposal_status_fk1: p_foundation_partner_key_n => p_foundation p_proposal_status_fk2: p_proposal_status_c => p_foundation_proposal_status p_proposal_submitted_fk3: p_partner_submitted_by_n => p_partner
REFERENCED BY p_foundation_proposal_detail