prc_phones

Owned by Benn Oshrin
Last updated: Mar 30, 2014
Titleprc_phones
TypeCalculated
DescriptionCalculated telephone numbers
ColumnFormatNullableDescriptionDefinitionComments
idinteger, primary key(error)Row identifierautoincrement 
role_record_idinteger, foreign key(error)Calculated role record this phone is attached toprs_role_records:id 
standardized_phone_idinteger, foreign key(tick)SOR phone that generated this calculated phoneprs_phones:id 
country_codevarchar(5)(tick)Country code (question) Should address lines 1-3 be consolidated?
area_codevarchar(5)(tick)Area code  
phone_numbervarchar(10)(error)Phone number  
extensionvarchar(5)(tick)Extension  
address_tinteger, foreign key(error)Address type of this phone number

ctx_data_types:id

data_type=ADDRESS

phone_tinteger, foreign key(error)Type of this phone numberctx_data_types:iddata_type=PHONE
verifiedboolean(tick)Whether this phone has been verified by the IdMS Verification via (eg) activation key delivery
primaryboolean(error)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. )