Data Views and Standard Log Reports - Journals

Data Views - Primary

• vw_LeadInfo
• vw_LeadInfoSimple
• vw_ProjectInfo
• vw_ProjectInfoSimple
• vw_JournalInfo
• vw_JournalRespondents

Data Views - Optional

• vw_CompanyInfo
• vw_CompanyInfoSimple
• vw_ContactInfo
• vw_PrimeContractInfo
• vw_PrimeContractInfoSimple

Standard Log Reports - Individual Lead - Journals

Report Name	Filter Parameters
Journals Grouped by Status	ProjectLeadId, JournalStatus, JournalType, ResponseStatus, ReminderDateFrom, ReminderDateTo, DueDateFrom, DueDateTo
Journals Grouped by Status and Reference Field	ProjectLeadId, JournalStatus, Reference, ResponseStatus, ReminderDateFrom, ReminderDateTo, DueDateFrom, DueDateTo
Journals Grouped by Status and Reference Field with Respondents	ProjectLeadId, JournalStatus, Reference, ResponseStatus, DueDateFrom, DueDateTo, IncludeMessage
Journals Grouped by Status and Type	ProjectLeadId, JournalStatus, JournalType, ResponseStatus, ReminderDateFrom, ReminderDateTo, DueDateFrom, DueDateTo
Journals Grouped by Status and Type with Respondents	ProjectLeadId, JournalStatus, JournalType, ResponseStatus, DueDateFrom, DueDateTo, IncludeMessage
Journals Grouped by Status with Respondents	ProjectLeadId, JournalStatus, JournalType, ResponseStatus, DueDateFrom, DueDateTo, IncludeMessage

Standard Log Reports - Individual Project - Journals

Report Name	Filter Parameters
Journals Grouped by Status	ProjectId, JournalStatus, JournalType, ResponseStatus, ReminderDateFrom, ReminderDateTo, DueDateFrom, DueDateTo
Journals Grouped by Status and Reference Field	ProjectId, JournalStatus, Reference, ResponseStatus, ReminderDateFrom, ReminderDateTo, DueDateFrom, DueDateTo
Journals Grouped by Status and Reference Field with Respondents	ProjectId, JournalStatus, Reference, ResponseStatus, DueDateFrom, DueDateTo, IncludeMessage
Journals Grouped by Status and Type	ProjectId, JournalStatus, JournalType, ResponseStatus, ReminderDateFrom, ReminderDateTo, DueDateFrom, DueDateTo
Journals Grouped by Status and Type with Respondents	ProjectId, JournalStatus, JournalType, ResponseStatus, DueDateFrom, DueDateTo, IncludeMessage
Journals Grouped by Status with Respondents	ProjectId, JournalStatus, JournalType, ResponseStatus, DueDateFrom, DueDateTo, IncludeMessage