Table

petitions

Description

Petitions

Column

Format

Description

Definition

Required

Comments

id

integer, primary key

Row identifier

autoincrement

(tick)


enrollment_flow_id

integer, foreign key

Enrollment Flow ID

enrollment_flows:id

(tick)


statusvarchar(2)Enrollment Flow Step status
  • A: Active
  • C: Confirmed
  • CR: Created
  • D2: Duplicate
  • F: Finalized
  • N: Denied
  • PA: Pending Approval
  • PC: Pending Confirmation
  • PV: Pending Vetting
  • X: Declined
  • XX: Failed
  • Y: Approved
(tick)
cou_idinteger, foreign keyCOU IDcous:id

enrollee_emailvarchar(256)Email address to be used for handoff to the EnrolleeRFC 5321 Mailbox format
This address does not automatically get added to email_addresses
enrollee_identifiervarchar(256)Authenticated identifier for Enrollee received as part of user authentication


enrollee_person_idinteger, foreign keyEnrollee Person IDpeople:id

petitioner_identifiervarchar(256)Authenticated identifier for Petitioner received as part of user authentication


petitioner_person_idinteger, foreign keyPetitioner Person IDpeople:id

tokenvarchar(256)For unauthenticated enrollments, token used to verify Enrollee requests

Will also be used for Petitioner when the Enrollee is also the Petitioner
  • No labels