Table |
cm_history |
---|---|
Description |
Transaction history (human readable) |
Column |
Format |
Description |
Definition |
Comments |
---|---|---|---|---|
id |
integer, primary key |
Row identifier |
autoincrement |
|
co_person_id |
integer, foreign key |
CO Person Record ID change applied to |
cm_co_people:id |
|
co_person_role_id |
integer, foreign key |
CO Person Role Record ID change applied to |
|
|
org_identity_id |
integer, foreign key |
Organizational Identity Record ID change applied to |
|
|
actor_co_person_id |
integer, foreign key |
CO Person who executed or requested this change |
cm_co_people:id |
|
action |
varchar(4) |
Machine readable transaction code |
As defined in ActionEnum |
Local history should be identified with an action code beginning with the letter 'X'. |
comment |
varchar(160) |
Human readable transaction description |
|
|