| Field Name | Field Description | Data Type | FK Join | |
|---|---|---|---|---|
| vr_AreaInvestigators | Id | Area Investigators Id | int | |
| vr_AreaInvestigators | RequestorId | Requestor Id | int | vr_Requestor |
| vr_AreaInvestigators | Name | Requestor Name | nvarchar | |
| vr_AreaInvestigators | InvestigatorName | Investigator Name (Requestor Name) | nvarchar | |
| vr_AreaInvestigators | Title | Title | nvarchar | |
| vr_AreaInvestigators | nvarchar | |||
| vr_AreaInvestigators | WorkPhone | Work Phone | nvarchar | |
| vr_AreaInvestigators | DepartmentName | Department Name | nvarchar | |
| vr_AreaInvestigators | InvestigatorDepartmentName | Investigator Department Name | nvarchar | |
| vr_AreaInvestigators | Organization | Organization | nvarchar | |
| vr_AreaInvestigators | InvestigatorOrganization | Investigator Department | nvarchar | |
| vr_AreaInvestigators | AreaId | Area Id | int | vr_area |
| vr_AreaInvestigators | Percentage | Percentage | decimal | |
| vr_AreaInvestigators | InvestigatorPercentage | Investigator Percentage | decimal | |
| vr_AreaInvestigators | CreatedDate | Created Date | datetime | |
| vr_AreaInvestigators | CreatorId | User Id (Record Creator) | int | vr_users |
| vr_AreaInvestigators | ModifiedDate | Modified Date | datetime | |
| vr_AreaInvestigators | ModifierId | User Id (Record Modifier) | int | vr_users |