Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

AIPLog

Data source: AIPLogQuery

select
[AIP Status Original] as APIStatusOriginal,
[AIP Status Graph] as AIPStatusGraph,
Area,
[Case ID] as CaseID,
[Case Name] as  CaseName,
[Created Date] as CreatedDate,
[Created Month] as  CreatedMonth,
[Data Source] as DataSource,
[Date Key] as DateKey,
[$ Invested] as Invested,
[$ Invested Date] as InvestedDate,
[$ Committed] as Committed,
[Investment Usage %] as InvestmentUsage,
[End Date] as EndDate,
[End Month] as EndMonth,
[AIP Status] as AIPStatus,
[Fiscal Year Rollover] as FiscalYearRollover,
[IO Created Date] as IOCreatedDate,
[Opportunity ID] as OpportunityID,
[Opportunity Name] as OpportunityName,
[Partner ID] as PartnerID,
[Partner Name] as PartnerName,
[PartnerOne ID] as PartnerOneID,
[PartnerOne Name] as PartnerOneName,
[PO Approved Date] as POApprovedDate,
[PO Submitted Date] as POSubmittedDate,
[Offer],
[Offer Details] as OfferDetails,
[Snapshot Date] as SnapshotDate,
[Source],
[Start Date] as StartDate,
[Project Status] as ProjectStatus,
[Project Status Details] as ProjectStatusDetails,
[TP Name] as  TPName,
[TPID],
[Case Requester] as CaseRequester,
[Case Request Created By] as CaseRequestCreatedBy,
[$ Invested Summarized] as InvestedSummarized,
[ValidTPID],
[ECIF Program ID] as ECIFProgramID,
[NAR Program ID] AS NARProgramID,
[FastTrackFlag]
from [dbo].[AIPLog]