prc_phones

Column	Format	Nullable	Description	Definition	Comments
id	integer, primary key		Row identifier	autoincrement
role_record_id	integer, foreign key		Calculated role record this phone is attached to	prs_role_records:id
standardized_phone_id	integer, foreign key		SOR phone that generated this calculated phone	prs_phones:id
country_code	varchar(5)		Country code		Should address lines 1-3 be consolidated?
area_code	varchar(5)		Area code
phone_number	varchar(10)		Phone number
extension	varchar(5)		Extension
address_t	integer, foreign key		Address type of this phone number	ctx_data_types:id	data_type=ADDRESS
phone_t	integer, foreign key		Type of this phone number	ctx_data_types:id	data_type=PHONE
verified	boolean		Whether this phone has been verified by the IdMS		Verification via (eg) activation key delivery
primary	boolean		Whether this is the primary phone for this person

Migration Notes From OR 1

• Added verified (
  Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
  )
• Added primary ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
• Added standardized_phone_id ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )