prs_role_records
- Benn Oshrin
Owned by Benn Oshrin
| Title | prs_role_records |
|---|---|
| Type | Standardized |
| Description | SOR Role Records (1 per person per role per SOR) |
| Column | Format | Nullable | Description | Definition | Comments |
|---|---|---|---|---|---|
| id | integer, primary key |  | Row identifier | autoincrement | |
| sor_person_id | integer, foreign key | | SOR Person this role record is attached to | prs_sor_persons: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
record_idrenamed toid(Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.)iddropped (XXX unclear what this was) ( )system_of_record_iddropped (inferable viaprs_sor_persons:source_sor_id) ( )person_status_trenamedrole_status_t( )