v_DIM_PROSPECTPLANREQUESTASSIGNMENT
Contains information about prospect plan assignment requests
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PROSPECTPLANREQUESTASSIGNMENTDIMID | int | BBDW.[DIM_PROSPECTPLANREQUESTASSIGNMENT].[PROSPECTPLANREQUESTASSIGNMENTDIMID] | |
| PROSPECTPLANREQUESTASSIGNMENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROSPECTPLANREQUESTASSIGNMENT].[PROSPECTPLANREQUESTASSIGNMENTSYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[DIM_PROSPECTPLANREQUESTASSIGNMENT].[CONSTITUENTDIMID] |
| PROSPECTPLANDIMID | int | yes | BBDW.[DIM_PROSPECTPLANREQUESTASSIGNMENT].[PROSPECTPLANDIMID] |
| PROSPECTPLANSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROSPECTPLANREQUESTASSIGNMENT].[PROSPECTPLANSYSTEMID] |
| SECONDARYFUNDRAISERDIMID | int | yes | BBDW.[DIM_PROSPECTPLANREQUESTASSIGNMENT].[SECONDARYFUNDRAISERDIMID] |
| SECONDARYFUNDRAISERSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROSPECTPLANREQUESTASSIGNMENT].[SECONDARYFUNDRAISERSYSTEMID] |
| FUNDRAISERROLE | nvarchar(100) | yes | BBDW.[DIM_PROSPECTPLANREQUESTASSIGNMENT].[FUNDRAISERROLE] |
Definition
Copy
create view [BBDW].[v_DIM_PROSPECTPLANREQUESTASSIGNMENT] as
select
[PROSPECTPLANREQUESTASSIGNMENTDIMID],
[PROSPECTPLANREQUESTASSIGNMENTSYSTEMID],
[CONSTITUENTDIMID],
[PROSPECTPLANDIMID],
[PROSPECTPLANSYSTEMID],
[SECONDARYFUNDRAISERDIMID],
[SECONDARYFUNDRAISERSYSTEMID],
[FUNDRAISERROLE]
from [BBDW].[DIM_PROSPECTPLANREQUESTASSIGNMENT];