Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Titleprs_sor_persons
TypeStandardized
DescriptionStandardized Person, the master record of an individual within a system of record
ColumnFormatNullableDescriptionDefinitionComments
idinteger, primary key(error)Row identifierautoincrement 
source_sor_id

integer, foreign key

(error)Source SOR for this SOR Personprd_system_of_record:id (question) rename table 
person_idinteger, foreign key(tick)Calculated Person this SOR Person has been reconciled toprc_persons:id 
date_of_birthdate(tick)Date of birth Date of birth, according to this SOR
gender_tvarchar(2)(tick)Gender

ctx_data_types:id

(warning) Additional values may be defined locally

Gender, according to this SOR

data_type=GENDER

 

Migration Notes From OR 1

  • record_id renamed to id (ORII-5)
  • id dropped (XXX unclear what this was) (ORII-5)
  • ssn dropped (XXX migrate to identifiers? TBD) (ORII-6)
  • gender replaced with gender_t (ORII-7)
  • source_sor_id is now a foreign key (ORII-8)
  • (question) Where is SORID (eg: emplid) stored? (ORII-9)
  • No labels