V_QUERY_RE7_PROPOSAL
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| LOCALID | int | ||
| PROSPECT_LOCALID | int | ||
| PRIMARYCONTACTCONSTITUENT_LOCALID | int | yes | |
| CAMPAIGN_LOCALID | int | yes | |
| FUND_LOCALID | int | yes | |
| INSTRUMENT | nvarchar(100) | yes | |
| AMOUNTASKED | numeric(30, 6) | yes | |
| AMOUNTEXPECTED | numeric(30, 6) | yes | |
| AMOUNTFUNDED | numeric(30, 6) | yes | |
| PURPOSE | nvarchar(100) | yes | |
| DATEASKED | datetime | yes | |
| DATEASKED_DATEID | int | yes | |
| DATEEXPECTED | datetime | yes | |
| DATEEXPECTED_DATEID | int | yes | |
| DATEFUNDED | datetime | yes | |
| DATEFUNDED_DATEID | int | yes | |
| DATERATED | datetime | yes | |
| DATERATED_DATEID | int | yes | |
| DATEDEADLINE | datetime | yes | |
| DATEDEADLINE_DATEID | int | yes | |
| RATING | nvarchar(100) | yes | |
| STATUS | nvarchar(100) | yes | |
| NAME | nvarchar(255) | ||
| ISACTIVE | bit | ||
| REASON | nvarchar(100) | yes | |
| ORIGINALAMOUNTASKED | numeric(30, 6) | yes | |
| ORIGINALDATEASKED | datetime | yes | |
| ORIGINALDATEASKED_DATEID | int | yes | |
| REVENUETYPECODE_LOCALID | int | yes | |
| REVENUETYPE | nvarchar(100) | yes | |
| AMOUNTFROMGIFTS | numeric(20, 4) | ||
| IMPORTID | nvarchar(20) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:50:37 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7_PROPOSAL AS
select
[P].[LOCALID],
[P].[PROSPECT_LOCALID],
[P].[PRIMARYCONTACTCONSTITUENT_LOCALID],
[P].[CAMPAIGN_LOCALID],
[P].[FUND_LOCALID],
[IC].[DESCRIPTION] [INSTRUMENT],
[P].[AMOUNTASKED],
[P].[AMOUNTEXPECTED],
[P].[AMOUNTFUNDED],
[PC].[DESCRIPTION] [PURPOSE],
[P].[DATEASKED],
[P].[DATEASKED_DATEID],
[P].[DATEEXPECTED],
[P].[DATEEXPECTED_DATEID],
[P].[DATEFUNDED],
[P].[DATEFUNDED_DATEID],
[P].[DATERATED],
[P].[DATERATED_DATEID],
[P].[DATEDEADLINE],
[P].[DATEDEADLINE_DATEID],
[RC].[DESCRIPTION] [RATING],
[SC].[DESCRIPTION] [STATUS],
[P].[NAME],
[P].[ISACTIVE],
[REC].[DESCRIPTION] [REASON],
[P].[ORIGINALAMOUNTASKED],
[P].[ORIGINALDATEASKED],
[P].[ORIGINALDATEASKED_DATEID],
[P].[REVENUETYPECODE_LOCALID],
[RTC].[DESCRIPTION] [REVENUETYPE],
[P].[AMOUNTFROMGIFTS],
[P].[IMPORTID]
from [dbo].[RE7_PROPOSAL] [P]
left outer join [dbo].[RE7_PROPOSALSTATUSCODE] [SC] on [P].[STATUSCODE_LOCALID] = [SC].[LOCALID]
left outer join [dbo].[RE7_PROPOSALINSTRUMENTCODE] [IC] on [P].[INSTRUMENTCODE_LOCALID] = [IC].[LOCALID]
left outer join [dbo].[RE7_PURPOSECODE] [PC] on [P].[PURPOSECODE_LOCALID] = [PC].[LOCALID]
left outer join [dbo].[RE7_RATINGCODE] [RC] on [P].[RATINGCODE_LOCALID] = [RC].[LOCALID]
left outer join [dbo].[RE7_PROPOSALREASONCODE] [REC] on [P].[REASONCODE_LOCALID] = [REC].[LOCALID]
left outer join dbo.[RE7_PROPOSALREVENUETYPECODE] [RTC] on [P].[REVENUETYPECODE_LOCALID] = [RTC].[LOCALID];