Table p_partner_action
Description:
A particular action which has been or needs to be applied to a Partner
PRIMARY KEY
p_partner_key_n
bigint NOT NULL
Partner key of Partner to which action applies p_partner, p_partner_reminder
p_action_number_i
integer NOT NULL
Sequential identifier for this action for this partner

s_group_unit_key_n
bigint default: 0 NOT NULL
Field that the group belongs to s_group
p_process_code_c
varchar (60)
Process that the action is part of p_action
p_action_code_c
varchar (60)
Action to be applied to Partner p_action
p_action_freeform_c
varchar (400)
Action to be applied to Partner (freetext)
p_perform_by_date_d
date
Date by which action should be performed. Reminders could be set up based on this
p_action_complete_l
boolean
Has the action already been completed?
p_action_complete_date_d
date
When was the action completed?
p_user_to_perform_action_c
varchar (20)
Who should perform this action? s_user
p_group_to_perform_action_c
varchar (20)
Which group should perform this action? s_group
p_user_that_performed_action_c
varchar (20)
Who actually performed this action? s_user
p_contact_id_i
bigint
Part of FK link to p_partner_reminder so can link this action to a reminder p_partner_reminder
p_reminder_id_i
integer
Part of FK link to p_partner_reminder so can link this action to a reminder p_partner_reminder
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_partner_action_fk1: p_partner_key_n => p_partner
p_partner_action_fk2: p_process_code_c;p_action_code_c => p_action
p_partner_action_fk3: p_user_to_perform_action_c => s_user
p_partner_action_fk4: p_group_to_perform_action_c;s_group_unit_key_n => s_group
p_partner_action_fk5: p_user_that_performed_action_c => s_user
p_partner_action_fk6: p_partner_key_n;p_contact_id_i;p_reminder_id_i => p_partner_reminder
p_partner_action_fkcr: s_created_by_c => s_user
p_partner_action_fkmd: s_modified_by_c => s_user