v_DIM_PROSPECTPLANSTATUS
Contains information about prospect plant status codes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PROSPECTPLANSTATUSDIMID | int | BBDW.[DIM_PROSPECTPLANSTATUS].[PROSPECTPLANSTATUSDIMID] | |
| PROSPECTPLANSTATUSSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROSPECTPLANSTATUS].[PROSPECTPLANSTATUSSYSTEMID] |
| PROSPECTPLANSTATUS | nvarchar(100) | yes | BBDW.[DIM_PROSPECTPLANSTATUS].[PROSPECTPLANSTATUS] |
| PROSPECTPLANISACTIVE | bit | yes | BBDW.[DIM_PROSPECTPLANSTATUS].[PROSPECTPLANISACTIVE] |
| PROSPECTPLANSTATUSSEQUENCE | int | yes | BBDW.[DIM_PROSPECTPLANSTATUS].[PROSPECTPLANSTATUSSEQUENCE] |
Definition
Copy
CREATE view [BBDW].[v_DIM_PROSPECTPLANSTATUS] as
select
[PROSPECTPLANSTATUSDIMID],
[PROSPECTPLANSTATUSSYSTEMID],
[PROSPECTPLANSTATUS],
[PROSPECTPLANISACTIVE],
[PROSPECTPLANSTATUSSEQUENCE]
from [BBDW].[DIM_PROSPECTPLANSTATUS];