Table | cm_co_petitions |
|---|---|
Description | Per-CO enrollment petitions |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | |
co_enrollment_flow_id | integer, foreign key | CO Enrollment Flow Record ID | Enrollment Flow controlling this Petition | |
co_id | integer, foreign key | CO Record ID | cm_cos:id | Same as co_enrollment_flow:co_id, repeated here to make retrieval by CO easier |
cou_id | integer, foreign key | COU Record ID | cm_cous:id | |
enrollee_org_identity_id | integer, foreign key | Org Identity Record ID | Populated if an Org Identity is created by form-based attribute collection during the flow. See also cm_org_identity_source_records:co_petition_id | |
| archived_org_identity_id | integer, foreign key | Archived Org Identity Record ID | cm_org_identities:id | If an org identity is replaced during execution of an enrollment flow, this will hold the original org identity |
enrollee_co_person_id | integer, foreign key | CO Person Record ID | cm_co_people:id | Populated if a CO Person is created by form-based attribute collection during the flow |
enrollee_co_person_role_id | integer, foreign key | CO Person Role Record ID | Populated if a CO Person Role is created by form-based attribute collection during the flow | |
petitioner_co_person_id | integer, foreign key | CO Person Record ID of person initiating request | cm_co_people:id | |
sponsor_co_person_id | integer, foreign key | CO Person Record ID of person sponsoring request | cm_co_people:id | |
approver_co_person_id | integer, foreign key | CO Person Record ID of person approving request | cm_co_people:id | |
co_invite_id | integer, foreign key | CO Invite ID created as part of this Petition | This field is not persistant, and is only non-NULL when an invite is pending. | |
| vetting_request_id | integer, foreign key | Vetting Request triggered as part of this Partition | cm_vetting_requests:id | Added in Registry v4.1.0 |
authenticated_identifier | varchar(256) | Authenticated identifier received as part of user authentication | Basically the contents of $REMOTE_USER | |
| reference_identifier | varchar(40) | Reference Identifier returned from an ID Match service, when Match Type is External | TAP ID Match API | Added in Registry v4.1.0 |
| petitioner_token | char(48) | For unauthenticated enrollments, token used to verify petitioner requests | ||
| enrollee_token | char(48) | For unauthenticated enrollments, token used to verify enrollee requests | ||
| return_url | varchar(256) | Upon completion of enrollment, URL to redirect to (superseding redirect_on_finalize) | Must match a whitelisted value in the associated Enrollment Flow configuration. | |
| approver_comment | varchar(256) | Comment from approver upon reviewing petition | Added v3.3.0, intended to be suitable for display to enrollee. | |
status | varchar(2) |
| Tentative |