| Column | Format | Nullable? | Description | Definition | Comments |
|---|
| record_id | integer, primary key | No | Â | Â |  This should really be id |
| id | varchar(255) | No | Â | Â | Â |
| system_of_record_id | integer, foreign key | No | System of record asserting this role record | prd_system_of_record:id | Â |
| sor_person_id | integer, foreign key | No | SOR Person this role record is attached to | prs_sor_persons:id | Â |
| title | varchar(100) | No | Title for this role record | Â | Â |
| percent_time | integer | No | Percent time for this role record (100 = full time) | Â | Â |
| organizational_unit_id | integer, foreign key | No | Organizational unit this role record belongs to | drd_organizational_units:id | Â |
| sponsor_id | integer, should be foreign key | No | Sponsor for this role record | If sponsor_t is Person: XXX | Â |
| sponsor_t | integer, foreign key | No | Type of sponsor | ctx_data_types:id | data_type=SPONSOR |
| person_status_t | integer, foreign key | No | Status of this role record | ctx_data_types:id | data_type=STATUS |
| affiliation_date | date | No | Effective date of affiliation of this role record | Â | Need not be same as validity but validity is not implemented |
| affiliation_t | integer, foreign key | No | 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=? |