prc_role_records

Column	Format	Nullable	Description	Definition	Comments
id	integer, primary key		Row identifier	autoincrement
person_id	integer, foreign key		Person this role record is attached to	prc_persons:id
standardized_role_record_id	integer, foreign key		SOR role record that generated this role record	prs_role_records:id
title	varchar(100)		Title for this role record
percent_time	integer		Percent time for this role record (100 = full time)
organizational_unit_id	integer, foreign key		Organizational unit this role record belongs to	drd_organizational_units:id
sponsor_id	integer, foreign key		Sponsor for this role record	prc_persons:id
sponsor_t	integer, foreign key		Type of sponsor	ctx_data_types:id	data_type=SPONSOR
role_status_t	integer, foreign key		Status of this role record	ctx_data_types:id	data_type=STATUS
affiliation_date	date		Effective date of affiliation of this role record		Need not be same as validity but  validity is not implemented
affiliation_t	integer, foreign key		Affiliation type of this role record	ctx_data_types:id	data_type=AFFILIATION
termination_date	date		Effective date of termination of this role		Need not be same as validity but  validity is not implemented
termination_t	integer, foreign key		Type of termination	ctx_data_types:id	data_type=?

Migration Notes From OR 1

• person_status_t renamed role_status_t (
  Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
  )
• prs_role_id renamed standardized_role_record_id ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )