Page Comparison

...

Column	Format	Nullable	Description	Definition	Comments
id	integer, primary key		Row identifier	autoincrement
personrole_record_id	integer, foreign key		Person Calculated role record this email address is attached to	prc_sorrole_personsrecords:id
prsstandardized_address_id	integer, foreign key		SOR address that generated this calculated address	prs_addresses:id
line1	varchar(100)		Address line 1		Should address lines 1-3 be consolidated?
line2	varchar(100)		Address line 2
line3	varchar(100)		Address line 3
building_id	integer, foreign key		Building	drd_buildings:id
room	varchar(20)		Room
city	varchar(100)		City
region_id	integer, foreign key		State / Region	ctd_regions:id
country_id	integer, foreign key		Country	ctd_countries:id
postal_code	varchar(20)		Postal / ZIP Code
address_t	integer, foreign key		Type of this address	ctx_data_types:id	data_type=ADDRESS
verified	boolean		Whether this address has been verified by the IdMS		Verification via (eg) activation key delivery
primary	boolean		Whether this is the primary address for this person
language	varchar(16)		Language encoding of this nameaddress	RFC 5646

Migration Notes From OR 1

• bldg_no renamed building_id and made a foreign key (

  Jira Legacy
  server JASIG Issue TrackerSystem JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 76221f40d8d429a7-4501dc92-3df13696-857885f0-6c87908cbdf71de5d4e9bcf6 key ORII-66

  )
• room_no renamed room (

  Jira Legacy
  server JASIG Issue TrackerSystem JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 76221f40d8d429a7-4501dc92-3df13696-857885f0-6c87908cbdf71de5d4e9bcf6 key ORII-67

  )
• postal_code resized (

  Jira Legacy
  server JASIG Issue TrackerSystem JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 76221f40d8d429a7-4501dc92-3df13696-857885f0-6c87908cbdf71de5d4e9bcf6 key ORII-68

  )
• Most fields no longer required (

  Jira Legacy
  server JASIG Issue TrackerSystem JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 76221f40d8d429a7-4501dc92-3df13696-857885f0-6c87908cbdf71de5d4e9bcf6 key ORII-65

  )
• Added verified (

  Jira Legacy
  server JASIG Issue TrackerSystem JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 76221f40d8d429a7-4501dc92-3df13696-857885f0-6c87908cbdf71de5d4e9bcf6 key ORII-69

  )
• Added primary (

  Jira Legacy
  server JASIG Issue TrackerSystem JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 76221f40d8d429a7-4501dc92-3df13696-857885f0-6c87908cbdf71de5d4e9bcf6 key ORII-70

  )
• language added (

  Jira Legacy
  server JASIG Issue TrackerSystem JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 76221f40d8d429a7-4501dc92-3df13696-857885f0-6c87908cbdf71de5d4e9bcf6 key ORII-83

  )
• Added standardized_address_id (

  Jira Legacy
  server System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId d8d429a7-dc92-3696-85f0-1de5d4e9bcf6 key ORII-90

  )