prs_addresses

Titleprs_addresses
TypeStandardized
DescriptionStandardized physical addresses
ColumnFormatNullableDescriptionDefinitionComments
idinteger, primary key(error)Row identifierautoincrement 
role_record_idinteger, foreign key(error)SOR Person this address is attached toprs_sor_persons:id 
line1varchar(100)(error)Address line 1 (question) Should address lines 1-3 be consolidated?
line2varchar(100)(tick)Address line 2  
line3varchar(100)(tick)Address line 3  
building_idinteger, foreign key(tick)Buildingdrd_buildings:id 
roomvarchar(20)(tick)Room  
cityvarchar(100)(tick)City  
region_idinteger, foreign key(tick)State / Regionctd_regions:id 
country_idinteger, foreign key(tick)Countryctd_countries:id 
postal_codevarchar(20)(tick)Postal / ZIP Code  
address_tinteger, foreign key(error)Type of this address

ctx_data_types:id

data_type=ADDRESS

verifiedboolean(tick)Whether this address has been verified by the SOR  
languagevarchar(16)(tick)Language encoding of this addressRFC 5646 

 

Migration Notes From OR 1

  • bldg_no renamed building_id and made a foreign key (
    Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
    )
  • room_no renamed room ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • postal_code resized ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • Most fields no longer required ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • Added verified ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • language added ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )