Page Comparison

...

Column	Format	Nullable	Description	Definition	Comments
id	integer, primary key		Row identifier	autoincrement
source_sor_id	integer, foreign key		Source SOR for this SOR Person	prdprx_systemsystems_of_record:id rename table
person_id	integer, foreign key		Calculated Person this SOR Person has been reconciled to	prc_persons:id
date_of_birth	date		Date of birth		Date of birth, according to this SOR
gender_t	varchar(2)		Gender	ctx_data_types:id Additional values may be defined locally	Gender, according to this SOR data_type=GENDER

...

Migration Notes From OR 1

• record_id renamed to id (

  Jira Legacy
  server JASIG Issue Tracker serverId 76221f40-4501-3df1-8578-6c87908cbdf7 key ORII-5

  )
• id dropped (XXX unclear what this was) (

  Jira Legacy
  server JASIG Issue Tracker serverId 76221f40-4501-3df1-8578-6c87908cbdf7 key ORII-5

  )
• ssn dropped (XXX migrate to identifiers? TBD) (

  Jira Legacy
  server JASIG Issue Tracker serverId 76221f40-4501-3df1-8578-6c87908cbdf7 key ORII-6

  )
• gender replaced with gender_t (

  Jira Legacy
  server JASIG Issue Tracker serverId 76221f40-4501-3df1-8578-6c87908cbdf7 key ORII-7

  )
• source_sor_id is now a foreign key (

  Jira Legacy
  server JASIG Issue Tracker serverId 76221f40-4501-3df1-8578-6c87908cbdf7 key ORII-8

  )
•  Where is SORID (eg: emplid) stored? (

  Jira Legacy
  server JASIG Issue Tracker serverId 76221f40-4501-3df1-8578-6c87908cbdf7 key ORII-9

  )