Table

person_roles

Description

Roles for a Person


Column

Format

Description

Definition

Required

Comments

id

integer, primary key

Row identifier

autoincrement

(tick)


person_idinteger, foreign keyPerson IDpeople:id(tick)
cou_idinteger, foreign keyCOU IDcous:id

status

varchar(2)

Person's Role status within the CO

  • A: Active
  • C: Confirmed
  • D: Deleted
  • D2: Duplicate
  • GP: Grace Period
  • I: Invited
  • N: Denied
  • P: Pending
  • PA: Pending Approval
  • PC: Pending Confirmation
  • S: Suspended
  • X: Declined
  • XP: Expired
  • Y: Approved
(tick)


affiliation_type_idinteger, foreign keyBroad affiliation to the COtypes:id(tick)
titlevarchar(128)Title


organizationvarchar(128)Organization

Field was named o prior to v5.0.0

departmentvarchar(128)Department

Field was named ou prior to v5.0.0
valid_fromdatetimePerson Role is valid member from this time


valid_throughdatetimePerson Role is valid member of CO through this time


manager_person_idinteger, foreign keyPerson ID of Managerpeople:id

sponsor_person_idinteger, foreign keyPerson ID of Sponsor for continued membershippeople:id

ordrintegerOrder/Rank/Priority of this Person Role (for all Roles for this Person)


source_external_identity_role_idinteger, foreign keyExternal Identity Role that was the source for this Person Roleexternal_identity_roles:id

frozenbooleanWhether or not Pipeline processing and validity date status recalculation will update this record
  • true: No updates
  • false: Updates


  • No labels