prx_systems_of_record

Owned by Benn Oshrin
Last updated: Mar 28, 2014
1 min read
Titleprx_systems_of_record
TypeSupporting
DescriptionList of Systems of Records (SORs) known to the Registry
ColumnFormatNullableDescriptionDefinitionComments
idinteger, primary key(error)Row identifierautoincrement 
sor_keyvarchar(24)(error)Alphanumeric internal identifier of this SOR Correlates to prr_src_SORKEY
descriptionvarchar(100)(error)Description of this SOR  
status_tinteger, foreign key(error)Status of this SOR

ctx_data_types:id

data_type=STATUS

Only SORs of status=Active are processed

 

Migration Notes From OR 1

  • Table renamed from prd_system_of_record (
    Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
    )
  • sor_id renamed to sor_key ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • Added description ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • Added status_t ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )