prs_sor_persons

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 Personprx_systems_of_record:id 
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 (
    Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
    )
  • id dropped (XXX unclear what this was) ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • ssn dropped (XXX migrate to identifiers? TBD) ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • gender replaced with gender_t ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • source_sor_id is now a foreign key ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • (question) Where is SORID (eg: emplid) stored? ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )