Table

cm_co_petition_history_records

Description

Per-CO enrollment petition history records

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement

 

co_petition_id

integer, foreign key

CO Petition Record ID

cm_co_petitions:id

 

actor_co_person_id

integer, foreign key

CO Person Record ID

cm_co_people:id

Person who triggered the action

action

varchar(4)

Machine readable transaction code

  • PY: Petition approved
  • PC: Petition created
  • PX: Petition declined
  • PN: Petition denied

 

comment

varchar(160)

Human readable comment

 

 

  • No labels