...
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 |
| |
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 |
|
enrollee_co_person_role_id | integer, foreign key | CO Person Role Record ID |
| |
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. | |
authenticated_identifier | varchar(256) | Authenticated identifier received as part of user authentication |
| Basically the contents of $REMOTE_USER |
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. | |
status | varchar(2) |
|
| Tentative |