Projects — phases and tasks Pro
Project team, dates, estimated progress, stored billing-currency fees and site; phases/tasks on demand.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. Select a project status, search by project number, name, organization or manager, then inspect its project dossier. Open Phases and then Tasks on demand, with actual child-list contents and grouped Details at every level. Keep the team, key dates, stored estimated progress, billing-currency compensation, site and notes together on your phone.
Why Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.
Pro: one SQL Server source, three lists and two relations; 31 project values, 21 phase values and 22 task values. Business WBS numbers remain visible; technical full-row and parent keys are hidden. The complete WBS1 + WBS2 + WBS3 identity is preserved. Repeated phase/task numbers under different parents do not merge. Phases and tasks are scoped by bound parent parameters before the row limit, not searched across the whole project tree. Orphan levels without the matching project/phase are not included. A phase with no tasks may legitimately show an empty task list.
Stored amounts are labor/direct-expense fees, reimbursable allowances and consultant fees in the top-level project billing currency. They are NOT invoices, billed revenue, actual costs, profit, balances or cash. Depending on ERP setup they may be entered at lower levels or rolled up; never add project, phase and task values together. Cifru performs no roll-up or currency conversion. Amounts for non-Regular charge types are left blank, not displayed as invented zero budgets. Unknown/blank currency must be checked in a real preview before interpreting an amount. PctComp, LabPctComp and ExpPctComp are stored ESTIMATED percentages, not a calculation of actual hours. Unknown status/charge codes remain Code plus their stored value; NULL stays blank. Organization and state/country remain native codes, not invented lookup descriptions. Manager, supervisor and principal names use the documented EMMain.Employee key, without payroll, private home contact or HR identifiers.
SQL names, types and keys come from the official 2025.1 physical dictionary; supplementary WBS/billing semantics use vendor help 7.2. This is NOT a same-edition compatibility certificate. The full SQL key permits 30-character WBS values; the conflicting seven-character overview is not used to truncate them. StartDate/EndDate have conflicting or discouraged meanings across these sources and are not exposed. Estimated start uses EstStartDate, explicitly described in supplementary 7.2 help, and must be confirmed in the installed edition. ProjectCurrencyCode has conflicting functional/project currency descriptions and is not paired with amounts here. Lower levels use the root BillingCurrencyCode according to the supplementary vendor WBS currency rule; verify it in your edition. The 7.2 import format does not replace 2025.1 physical column lengths or infer missing SQL columns.
Live on-demand reads; no scheduled refresh. Each list is bounded to 2,000 rows and may be incomplete. Local search and opening filters act on loaded rows; status is not a source predicate or an access control. A row limit is not a performance guarantee. Use an administrator-approved on-premises SQL Server database and a dedicated least-privilege SELECT account. Verify database, default schema, selected objects/columns, full keys, authorized company/project scope and query timings. No dbo owner is assumed; mismatched default-schema object resolution refuses results. An empty result can indicate missing metadata or an incorrect scope. Direct SQL does NOT inherit Vantagepoint roles or confidential-project/client controls. No automatic client-name join is added. Complete the Cifru read/compatibility test and inspect a real preview at import. No direct Deltek Cloud/ODBC access is promised. Do not use sa/sysadmin, writes, DDL, administration or migration examples.
Not tested on a real ERP or SQL Server. Synthetic query-adapter tests and native DEMO screenshots do not prove installed compatibility. No credentials, connection address, cached source row, executable code or vendor HTML is included in the package. Unofficial and not affiliated with Deltek.
Primary physical dictionary: https://help.deltek.com/product/Vantagepoint/2025.1/DataDictionary/index.htm
Supplementary project format: https://help.deltek.com/Product/Vantagepoint/7.2/ut_tf_projects.html
WBS meanings: https://help.deltek.com/product/Vantagepoint/7.2/wbs_wbs_components_overview.html
Billing currency: https://help.deltek.com/Product/Vantagepoint/7.2/hist_Contents_Proj_Invoice_Receipt.html
Stored contract amounts: https://help.deltek.com/product/Vantagepoint/7.2/project_create_new_contract_record_on_contract_mgt_tab.html
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Projects dossier
- Details: Phases
- Details: Tasks
- Sub-button: Project phases
- Sub-button: Phase tasks
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CONCAT(LEN(p.WBS1),N':',p.WBS1,N':',LEN(p.WBS2),N':',p.WBS2,N':',LEN(p.WBS3),N':',p.WBS3,N':') AS RecordKey, LTRIM(RTRIM(p.Name)) AS Name, p.WBS1 AS WBS1, CASE p.Status WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'D' THEN N'Dormant' ELSE CASE WHEN p.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Status)) END END AS Status, CASE p.ChargeType WHEN N'R' THEN N'Regular' WHEN N'H' THEN N'Overhead' WHEN N'P' THEN N'Promotional' ELSE CASE WHEN p.ChargeType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.ChargeType)) END END AS ChargeType, LTRIM(RTRIM(p.Org)) AS Org, NULLIF(LTRIM(RTRIM(CONCAT(pm.FirstName,N' ',pm.LastName))),N'') AS ProjMgrName, NULLIF(LTRIM(RTRIM(CONCAT(su.FirstName,N' ',su.LastName))),N'') AS SupervisorName, p.EstStartDate AS EstStartDate, p.EstCompletionDate AS EstCompletionDate, p.ActCompletionDate AS ActCompletionDate, p.PctComp AS PctComp, p.LabPctComp AS LabPctComp, p.ExpPctComp AS ExpPctComp, LTRIM(RTRIM(p.BillingCurrencyCode)) AS BillingCurrencyCode, CASE WHEN p.ChargeType=N'R' THEN p.FeeBillingCurrency ELSE NULL END AS FeeBillingCurrency, CASE WHEN p.ChargeType=N'R' THEN p.ReimbAllowBillingCurrency ELSE NULL END AS ReimbAllowBillingCurrency, CASE WHEN p.ChargeType=N'R' THEN p.ConsultFeeBillingCurrency ELSE NULL END AS ConsultFeeBillingCurrency, LTRIM(RTRIM(p.LongName)) AS LongName, LTRIM(RTRIM(p.Description)) AS Description, LTRIM(RTRIM(p.Memo)) AS Memo, NULLIF(LTRIM(RTRIM(CONCAT(pi.FirstName,N' ',pi.LastName))),N'') AS PrincipalName, p.ContractDate AS ContractDate, LTRIM(RTRIM(p.Address1)) AS Address1, LTRIM(RTRIM(p.Address2)) AS Address2, LTRIM(RTRIM(p.Address3)) AS Address3, LTRIM(RTRIM(p.City)) AS City, LTRIM(RTRIM(p.State)) AS State, LTRIM(RTRIM(p.Zip)) AS Zip, LTRIM(RTRIM(p.Country)) AS Country, LTRIM(RTRIM(p.Phone)) AS Phone, LTRIM(RTRIM(p.EMail)) AS EMail FROM PR p LEFT JOIN EMMain pm ON pm.Employee=p.ProjMgr LEFT JOIN EMMain su ON su.Employee=p.Supervisor LEFT JOIN EMMain pi ON pi.Employee=p.Principal WHERE LTRIM(RTRIM(p.WBS2))=N'' AND LTRIM(RTRIM(p.WBS3))=N'' AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(LEN(p.WBS1),N':',p.WBS1,N':',LEN(p.WBS2),N':',p.WBS2,N':',LEN(p.WBS3),N':',p.WBS3,N':') AS RecordKey, CONCAT(LEN(r.WBS1),N':',r.WBS1,N':',LEN(r.WBS2),N':',r.WBS2,N':',LEN(r.WBS3),N':',r.WBS3,N':') AS ParentKey, LTRIM(RTRIM(p.Name)) AS Name, p.WBS1 AS WBS1, CASE p.Status WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'D' THEN N'Dormant' ELSE CASE WHEN p.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Status)) END END AS Status, CASE p.ChargeType WHEN N'R' THEN N'Regular' WHEN N'H' THEN N'Overhead' WHEN N'P' THEN N'Promotional' ELSE CASE WHEN p.ChargeType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.ChargeType)) END END AS ChargeType, LTRIM(RTRIM(p.Org)) AS Org, NULLIF(LTRIM(RTRIM(CONCAT(pm.FirstName,N' ',pm.LastName))),N'') AS ProjMgrName, NULLIF(LTRIM(RTRIM(CONCAT(su.FirstName,N' ',su.LastName))),N'') AS SupervisorName, p.EstStartDate AS EstStartDate, p.EstCompletionDate AS EstCompletionDate, p.ActCompletionDate AS ActCompletionDate, p.PctComp AS PctComp, p.LabPctComp AS LabPctComp, p.ExpPctComp AS ExpPctComp, LTRIM(RTRIM(r.BillingCurrencyCode)) AS BillingCurrencyCode, CASE WHEN p.ChargeType=N'R' THEN p.FeeBillingCurrency ELSE NULL END AS FeeBillingCurrency, CASE WHEN p.ChargeType=N'R' THEN p.ReimbAllowBillingCurrency ELSE NULL END AS ReimbAllowBillingCurrency, CASE WHEN p.ChargeType=N'R' THEN p.ConsultFeeBillingCurrency ELSE NULL END AS ConsultFeeBillingCurrency, LTRIM(RTRIM(p.LongName)) AS LongName, LTRIM(RTRIM(p.Description)) AS Description, LTRIM(RTRIM(p.Memo)) AS Memo, p.WBS2 AS WBS2 FROM PR p INNER JOIN PR r ON r.WBS1=p.WBS1 AND LTRIM(RTRIM(r.WBS2))=N'' AND LTRIM(RTRIM(r.WBS3))=N'' LEFT JOIN EMMain pm ON pm.Employee=p.ProjMgr LEFT JOIN EMMain su ON su.Employee=p.Supervisor WHERE LTRIM(RTRIM(p.WBS2))<>N'' AND LTRIM(RTRIM(p.WBS3))=N'' AND p.WBS1=:project AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(LEN(p.WBS1),N':',p.WBS1,N':',LEN(p.WBS2),N':',p.WBS2,N':',LEN(p.WBS3),N':',p.WBS3,N':') AS RecordKey, CONCAT(LEN(m.WBS1),N':',m.WBS1,N':',LEN(m.WBS2),N':',m.WBS2,N':',LEN(m.WBS3),N':',m.WBS3,N':') AS ParentKey, LTRIM(RTRIM(p.Name)) AS Name, p.WBS1 AS WBS1, CASE p.Status WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'D' THEN N'Dormant' ELSE CASE WHEN p.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Status)) END END AS Status, CASE p.ChargeType WHEN N'R' THEN N'Regular' WHEN N'H' THEN N'Overhead' WHEN N'P' THEN N'Promotional' ELSE CASE WHEN p.ChargeType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.ChargeType)) END END AS ChargeType, LTRIM(RTRIM(p.Org)) AS Org, NULLIF(LTRIM(RTRIM(CONCAT(pm.FirstName,N' ',pm.LastName))),N'') AS ProjMgrName, NULLIF(LTRIM(RTRIM(CONCAT(su.FirstName,N' ',su.LastName))),N'') AS SupervisorName, p.EstStartDate AS EstStartDate, p.EstCompletionDate AS EstCompletionDate, p.ActCompletionDate AS ActCompletionDate, p.PctComp AS PctComp, p.LabPctComp AS LabPctComp, p.ExpPctComp AS ExpPctComp, LTRIM(RTRIM(r.BillingCurrencyCode)) AS BillingCurrencyCode, CASE WHEN p.ChargeType=N'R' THEN p.FeeBillingCurrency ELSE NULL END AS FeeBillingCurrency, CASE WHEN p.ChargeType=N'R' THEN p.ReimbAllowBillingCurrency ELSE NULL END AS ReimbAllowBillingCurrency, CASE WHEN p.ChargeType=N'R' THEN p.ConsultFeeBillingCurrency ELSE NULL END AS ConsultFeeBillingCurrency, LTRIM(RTRIM(p.LongName)) AS LongName, LTRIM(RTRIM(p.Description)) AS Description, LTRIM(RTRIM(p.Memo)) AS Memo, p.WBS2 AS WBS2, p.WBS3 AS WBS3 FROM PR p INNER JOIN PR r ON r.WBS1=p.WBS1 AND LTRIM(RTRIM(r.WBS2))=N'' AND LTRIM(RTRIM(r.WBS3))=N'' INNER JOIN PR m ON m.WBS1=p.WBS1 AND m.WBS2=p.WBS2 AND LTRIM(RTRIM(m.WBS3))=N'' AND LTRIM(RTRIM(m.WBS2))<>N'' LEFT JOIN EMMain pm ON pm.Employee=p.ProjMgr LEFT JOIN EMMain su ON su.Employee=p.Supervisor WHERE LTRIM(RTRIM(p.WBS2))<>N'' AND LTRIM(RTRIM(p.WBS3))<>N'' AND p.WBS1=:project AND p.WBS2=:phase AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Vantagepoint — authorised SQL Server database",
"id": "7BA42CF1-8E6E-5747-B57E-591F46696A7D",
"kind": "sqlServer",
"requiredObjects": [
"PR",
"EMMain"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "814B5F4F-8852-5004-ABFE-7E292FE58EF4",
"key": "WBS1",
"type": "text"
},
{
"direction": "ascending",
"id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
"key": "RecordKey",
"type": "text"
}
],
"id": "302359E4-1A93-51CA-917F-08A9408CD89D",
"mappings": [
{
"commonFieldKey": "",
"key": "RecordKey",
"label": "Internal RecordKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RecordKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Name",
"label": "Name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Name",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WBS1",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WBS1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Status",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ChargeType",
"label": "Charge type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ChargeType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Org",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Org",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProjMgrName",
"label": "Project manager",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProjMgrName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SupervisorName",
"label": "Supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SupervisorName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EstStartDate",
"label": "Estimated start",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EstStartDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EstCompletionDate",
"label": "Estimated completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EstCompletionDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ActCompletionDate",
"label": "Actual completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ActCompletionDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PctComp",
"label": "Estimated complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PctComp",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LabPctComp",
"label": "Estimated labor complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LabPctComp",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ExpPctComp",
"label": "Estimated expense complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ExpPctComp",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BillingCurrencyCode",
"label": "Billing currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BillingCurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FeeBillingCurrency",
"label": "Stored labor / expense fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FeeBillingCurrency",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ReimbAllowBillingCurrency",
"label": "Stored reimbursable allowance",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReimbAllowBillingCurrency",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ConsultFeeBillingCurrency",
"label": "Stored consultant fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ConsultFeeBillingCurrency",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LongName",
"label": "Long name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LongName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Description",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Memo",
"label": "Notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Memo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PrincipalName",
"label": "Principal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PrincipalName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ContractDate",
"label": "Contract award date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ContractDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Address1",
"label": "Site address 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Address1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Address2",
"label": "Site address 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Address2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Address3",
"label": "Site address 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Address3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "City",
"label": "Site city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "City",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "State",
"label": "Site state code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "State",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Zip",
"label": "Site postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Zip",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Country",
"label": "Site country code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Country",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Phone",
"label": "Site phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Phone",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EMail",
"label": "Site email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EMail",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Projects dossier",
"primaryKey": "RecordKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Name",
"WBS1",
"Status",
"ChargeType",
"Org",
"ProjMgrName",
"SupervisorName",
"EstStartDate",
"EstCompletionDate",
"ActCompletionDate",
"PctComp",
"LabPctComp",
"ExpPctComp",
"BillingCurrencyCode",
"FeeBillingCurrency",
"ReimbAllowBillingCurrency",
"ConsultFeeBillingCurrency",
"LongName",
"Description",
"Memo",
"PrincipalName",
"ContractDate",
"Address1",
"Address2",
"Address3",
"City",
"State",
"Zip",
"Country",
"Phone",
"EMail"
],
"sourceID": "7BA42CF1-8E6E-5747-B57E-591F46696A7D",
"sqlQuery": "SELECT CONCAT(LEN(p.WBS1),N':',p.WBS1,N':',LEN(p.WBS2),N':',p.WBS2,N':',LEN(p.WBS3),N':',p.WBS3,N':') AS RecordKey, LTRIM(RTRIM(p.Name)) AS Name, p.WBS1 AS WBS1, CASE p.Status WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'D' THEN N'Dormant' ELSE CASE WHEN p.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Status)) END END AS Status, CASE p.ChargeType WHEN N'R' THEN N'Regular' WHEN N'H' THEN N'Overhead' WHEN N'P' THEN N'Promotional' ELSE CASE WHEN p.ChargeType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.ChargeType)) END END AS ChargeType, LTRIM(RTRIM(p.Org)) AS Org, NULLIF(LTRIM(RTRIM(CONCAT(pm.FirstName,N' ',pm.LastName))),N'') AS ProjMgrName, NULLIF(LTRIM(RTRIM(CONCAT(su.FirstName,N' ',su.LastName))),N'') AS SupervisorName, p.EstStartDate AS EstStartDate, p.EstCompletionDate AS EstCompletionDate, p.ActCompletionDate AS ActCompletionDate, p.PctComp AS PctComp, p.LabPctComp AS LabPctComp, p.ExpPctComp AS ExpPctComp, LTRIM(RTRIM(p.BillingCurrencyCode)) AS BillingCurrencyCode, CASE WHEN p.ChargeType=N'R' THEN p.FeeBillingCurrency ELSE NULL END AS FeeBillingCurrency, CASE WHEN p.ChargeType=N'R' THEN p.ReimbAllowBillingCurrency ELSE NULL END AS ReimbAllowBillingCurrency, CASE WHEN p.ChargeType=N'R' THEN p.ConsultFeeBillingCurrency ELSE NULL END AS ConsultFeeBillingCurrency, LTRIM(RTRIM(p.LongName)) AS LongName, LTRIM(RTRIM(p.Description)) AS Description, LTRIM(RTRIM(p.Memo)) AS Memo, NULLIF(LTRIM(RTRIM(CONCAT(pi.FirstName,N' ',pi.LastName))),N'') AS PrincipalName, p.ContractDate AS ContractDate, LTRIM(RTRIM(p.Address1)) AS Address1, LTRIM(RTRIM(p.Address2)) AS Address2, LTRIM(RTRIM(p.Address3)) AS Address3, LTRIM(RTRIM(p.City)) AS City, LTRIM(RTRIM(p.State)) AS State, LTRIM(RTRIM(p.Zip)) AS Zip, LTRIM(RTRIM(p.Country)) AS Country, LTRIM(RTRIM(p.Phone)) AS Phone, LTRIM(RTRIM(p.EMail)) AS EMail FROM PR p LEFT JOIN EMMain pm ON pm.Employee=p.ProjMgr LEFT JOIN EMMain su ON su.Employee=p.Supervisor LEFT JOIN EMMain pi ON pi.Employee=p.Principal WHERE LTRIM(RTRIM(p.WBS2))=N'' AND LTRIM(RTRIM(p.WBS3))=N'' AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "AACACCD3-0B45-58C3-A22F-72AD6938163E",
"key": "WBS2",
"type": "text"
},
{
"direction": "ascending",
"id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
"key": "RecordKey",
"type": "text"
}
],
"id": "67FDA52D-2962-5833-9123-9474929DA02E",
"mappings": [
{
"commonFieldKey": "",
"key": "RecordKey",
"label": "Internal RecordKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RecordKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentKey",
"label": "Internal ParentKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Name",
"label": "Name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Name",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WBS1",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WBS1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Status",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ChargeType",
"label": "Charge type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ChargeType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Org",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Org",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProjMgrName",
"label": "Project manager",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProjMgrName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SupervisorName",
"label": "Supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SupervisorName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EstStartDate",
"label": "Estimated start",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EstStartDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EstCompletionDate",
"label": "Estimated completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EstCompletionDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ActCompletionDate",
"label": "Actual completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ActCompletionDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PctComp",
"label": "Estimated complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PctComp",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LabPctComp",
"label": "Estimated labor complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LabPctComp",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ExpPctComp",
"label": "Estimated expense complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ExpPctComp",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BillingCurrencyCode",
"label": "Billing currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BillingCurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FeeBillingCurrency",
"label": "Stored labor / expense fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FeeBillingCurrency",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ReimbAllowBillingCurrency",
"label": "Stored reimbursable allowance",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReimbAllowBillingCurrency",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ConsultFeeBillingCurrency",
"label": "Stored consultant fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ConsultFeeBillingCurrency",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LongName",
"label": "Long name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LongName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Description",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Memo",
"label": "Notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Memo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WBS2",
"label": "Phase number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WBS2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Project phases",
"primaryKey": "RecordKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "WBS1",
"id": "1C7F5132-6870-5E80-8075-DAF151B08703",
"name": "project",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Name",
"WBS1",
"Status",
"ChargeType",
"Org",
"ProjMgrName",
"SupervisorName",
"EstStartDate",
"EstCompletionDate",
"ActCompletionDate",
"PctComp",
"LabPctComp",
"ExpPctComp",
"BillingCurrencyCode",
"FeeBillingCurrency",
"ReimbAllowBillingCurrency",
"ConsultFeeBillingCurrency",
"LongName",
"Description",
"Memo",
"WBS2"
],
"sourceID": "7BA42CF1-8E6E-5747-B57E-591F46696A7D",
"sqlQuery": "SELECT CONCAT(LEN(p.WBS1),N':',p.WBS1,N':',LEN(p.WBS2),N':',p.WBS2,N':',LEN(p.WBS3),N':',p.WBS3,N':') AS RecordKey, CONCAT(LEN(r.WBS1),N':',r.WBS1,N':',LEN(r.WBS2),N':',r.WBS2,N':',LEN(r.WBS3),N':',r.WBS3,N':') AS ParentKey, LTRIM(RTRIM(p.Name)) AS Name, p.WBS1 AS WBS1, CASE p.Status WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'D' THEN N'Dormant' ELSE CASE WHEN p.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Status)) END END AS Status, CASE p.ChargeType WHEN N'R' THEN N'Regular' WHEN N'H' THEN N'Overhead' WHEN N'P' THEN N'Promotional' ELSE CASE WHEN p.ChargeType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.ChargeType)) END END AS ChargeType, LTRIM(RTRIM(p.Org)) AS Org, NULLIF(LTRIM(RTRIM(CONCAT(pm.FirstName,N' ',pm.LastName))),N'') AS ProjMgrName, NULLIF(LTRIM(RTRIM(CONCAT(su.FirstName,N' ',su.LastName))),N'') AS SupervisorName, p.EstStartDate AS EstStartDate, p.EstCompletionDate AS EstCompletionDate, p.ActCompletionDate AS ActCompletionDate, p.PctComp AS PctComp, p.LabPctComp AS LabPctComp, p.ExpPctComp AS ExpPctComp, LTRIM(RTRIM(r.BillingCurrencyCode)) AS BillingCurrencyCode, CASE WHEN p.ChargeType=N'R' THEN p.FeeBillingCurrency ELSE NULL END AS FeeBillingCurrency, CASE WHEN p.ChargeType=N'R' THEN p.ReimbAllowBillingCurrency ELSE NULL END AS ReimbAllowBillingCurrency, CASE WHEN p.ChargeType=N'R' THEN p.ConsultFeeBillingCurrency ELSE NULL END AS ConsultFeeBillingCurrency, LTRIM(RTRIM(p.LongName)) AS LongName, LTRIM(RTRIM(p.Description)) AS Description, LTRIM(RTRIM(p.Memo)) AS Memo, p.WBS2 AS WBS2 FROM PR p INNER JOIN PR r ON r.WBS1=p.WBS1 AND LTRIM(RTRIM(r.WBS2))=N'' AND LTRIM(RTRIM(r.WBS3))=N'' LEFT JOIN EMMain pm ON pm.Employee=p.ProjMgr LEFT JOIN EMMain su ON su.Employee=p.Supervisor WHERE LTRIM(RTRIM(p.WBS2))<>N'' AND LTRIM(RTRIM(p.WBS3))=N'' AND p.WBS1=:project AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "1D54279B-76CC-5A48-ABE0-16BD72803411",
"key": "WBS3",
"type": "text"
},
{
"direction": "ascending",
"id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
"key": "RecordKey",
"type": "text"
}
],
"id": "5860245E-EB8F-55D3-B9EA-0F89A7396545",
"mappings": [
{
"commonFieldKey": "",
"key": "RecordKey",
"label": "Internal RecordKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RecordKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentKey",
"label": "Internal ParentKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Name",
"label": "Name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Name",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WBS1",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WBS1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Status",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ChargeType",
"label": "Charge type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ChargeType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Org",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Org",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProjMgrName",
"label": "Project manager",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProjMgrName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SupervisorName",
"label": "Supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SupervisorName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EstStartDate",
"label": "Estimated start",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EstStartDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EstCompletionDate",
"label": "Estimated completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EstCompletionDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ActCompletionDate",
"label": "Actual completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ActCompletionDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PctComp",
"label": "Estimated complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PctComp",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LabPctComp",
"label": "Estimated labor complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LabPctComp",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ExpPctComp",
"label": "Estimated expense complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ExpPctComp",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BillingCurrencyCode",
"label": "Billing currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BillingCurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FeeBillingCurrency",
"label": "Stored labor / expense fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FeeBillingCurrency",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ReimbAllowBillingCurrency",
"label": "Stored reimbursable allowance",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReimbAllowBillingCurrency",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ConsultFeeBillingCurrency",
"label": "Stored consultant fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ConsultFeeBillingCurrency",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LongName",
"label": "Long name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LongName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Description",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Memo",
"label": "Notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Memo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WBS2",
"label": "Phase number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WBS2",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "WBS3",
"label": "Task number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WBS3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Phase tasks",
"primaryKey": "RecordKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "WBS1",
"id": "1C7F5132-6870-5E80-8075-DAF151B08703",
"name": "project",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "WBS2",
"id": "E80483AB-625D-567A-85D7-5F7EF8D8055E",
"name": "phase",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Name",
"WBS1",
"Status",
"ChargeType",
"Org",
"ProjMgrName",
"SupervisorName",
"EstStartDate",
"EstCompletionDate",
"ActCompletionDate",
"PctComp",
"LabPctComp",
"ExpPctComp",
"BillingCurrencyCode",
"FeeBillingCurrency",
"ReimbAllowBillingCurrency",
"ConsultFeeBillingCurrency",
"LongName",
"Description",
"Memo",
"WBS2",
"WBS3"
],
"sourceID": "7BA42CF1-8E6E-5747-B57E-591F46696A7D",
"sqlQuery": "SELECT CONCAT(LEN(p.WBS1),N':',p.WBS1,N':',LEN(p.WBS2),N':',p.WBS2,N':',LEN(p.WBS3),N':',p.WBS3,N':') AS RecordKey, CONCAT(LEN(m.WBS1),N':',m.WBS1,N':',LEN(m.WBS2),N':',m.WBS2,N':',LEN(m.WBS3),N':',m.WBS3,N':') AS ParentKey, LTRIM(RTRIM(p.Name)) AS Name, p.WBS1 AS WBS1, CASE p.Status WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'D' THEN N'Dormant' ELSE CASE WHEN p.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.Status)) END END AS Status, CASE p.ChargeType WHEN N'R' THEN N'Regular' WHEN N'H' THEN N'Overhead' WHEN N'P' THEN N'Promotional' ELSE CASE WHEN p.ChargeType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(p.ChargeType)) END END AS ChargeType, LTRIM(RTRIM(p.Org)) AS Org, NULLIF(LTRIM(RTRIM(CONCAT(pm.FirstName,N' ',pm.LastName))),N'') AS ProjMgrName, NULLIF(LTRIM(RTRIM(CONCAT(su.FirstName,N' ',su.LastName))),N'') AS SupervisorName, p.EstStartDate AS EstStartDate, p.EstCompletionDate AS EstCompletionDate, p.ActCompletionDate AS ActCompletionDate, p.PctComp AS PctComp, p.LabPctComp AS LabPctComp, p.ExpPctComp AS ExpPctComp, LTRIM(RTRIM(r.BillingCurrencyCode)) AS BillingCurrencyCode, CASE WHEN p.ChargeType=N'R' THEN p.FeeBillingCurrency ELSE NULL END AS FeeBillingCurrency, CASE WHEN p.ChargeType=N'R' THEN p.ReimbAllowBillingCurrency ELSE NULL END AS ReimbAllowBillingCurrency, CASE WHEN p.ChargeType=N'R' THEN p.ConsultFeeBillingCurrency ELSE NULL END AS ConsultFeeBillingCurrency, LTRIM(RTRIM(p.LongName)) AS LongName, LTRIM(RTRIM(p.Description)) AS Description, LTRIM(RTRIM(p.Memo)) AS Memo, p.WBS2 AS WBS2, p.WBS3 AS WBS3 FROM PR p INNER JOIN PR r ON r.WBS1=p.WBS1 AND LTRIM(RTRIM(r.WBS2))=N'' AND LTRIM(RTRIM(r.WBS3))=N'' INNER JOIN PR m ON m.WBS1=p.WBS1 AND m.WBS2=p.WBS2 AND LTRIM(RTRIM(m.WBS3))=N'' AND LTRIM(RTRIM(m.WBS2))<>N'' LEFT JOIN EMMain pm ON pm.Employee=p.ProjMgr LEFT JOIN EMMain su ON su.Employee=p.Supervisor WHERE LTRIM(RTRIM(p.WBS2))<>N'' AND LTRIM(RTRIM(p.WBS3))<>N'' AND p.WBS1=:project AND p.WBS2=:phase AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'PR',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PR',N'U') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "63210DB8-7367-58C5-9896-A0EAD1E36F0C",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "01D33DAB-3847-5AA2-9C10-CF6B96B05116",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "67FDA52D-2962-5833-9123-9474929DA02E",
"title": "Phases",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ChargeType",
"label": "Charge type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Org",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ProjMgrName",
"label": "Project manager",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EstCompletionDate",
"label": "Estimated completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PctComp",
"label": "Estimated complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BillingCurrencyCode",
"label": "Billing currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FeeBillingCurrency",
"label": "Stored labor / expense fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "302359E4-1A93-51CA-917F-08A9408CD89D",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "Name",
"label": "Name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "WBS1",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "ChargeType",
"label": "Charge type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "Org",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "ProjMgrName",
"label": "Project manager",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "SupervisorName",
"label": "Supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "PrincipalName",
"label": "Principal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "EstStartDate",
"label": "Estimated start",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "EstCompletionDate",
"label": "Estimated completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "ActCompletionDate",
"label": "Actual completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "ContractDate",
"label": "Contract award date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "PctComp",
"label": "Estimated complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "LabPctComp",
"label": "Estimated labor complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "ExpPctComp",
"label": "Estimated expense complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored amounts in billing currency",
"detailRole": "information",
"isVisible": true,
"key": "BillingCurrencyCode",
"label": "Billing currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored amounts in billing currency",
"detailRole": "information",
"isVisible": true,
"key": "FeeBillingCurrency",
"label": "Stored labor / expense fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored amounts in billing currency",
"detailRole": "information",
"isVisible": true,
"key": "ReimbAllowBillingCurrency",
"label": "Stored reimbursable allowance",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored amounts in billing currency",
"detailRole": "information",
"isVisible": true,
"key": "ConsultFeeBillingCurrency",
"label": "Stored consultant fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Project site",
"detailRole": "information",
"isVisible": true,
"key": "Address1",
"label": "Site address 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project site",
"detailRole": "information",
"isVisible": true,
"key": "Address2",
"label": "Site address 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project site",
"detailRole": "information",
"isVisible": true,
"key": "Address3",
"label": "Site address 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project site",
"detailRole": "information",
"isVisible": true,
"key": "City",
"label": "Site city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project site",
"detailRole": "information",
"isVisible": true,
"key": "State",
"label": "Site state code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project site",
"detailRole": "information",
"isVisible": true,
"key": "Zip",
"label": "Site postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project site",
"detailRole": "information",
"isVisible": true,
"key": "Country",
"label": "Site country code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project site",
"detailRole": "information",
"isVisible": true,
"key": "Phone",
"label": "Site phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Project site",
"detailRole": "information",
"isVisible": true,
"key": "EMail",
"label": "Site email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Context",
"detailRole": "information",
"isVisible": true,
"key": "LongName",
"label": "Long name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Context",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Context",
"detailRole": "information",
"isVisible": true,
"key": "Memo",
"label": "Notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "FC093EF6-EF83-5811-BAA0-56558131FBE9",
"openFilters": [
{
"id": "7429D7BB-F296-5DB6-8AFA-13EEED9B527A",
"includeAllOption": true,
"key": "Status",
"title": "Project status",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "814B5F4F-8852-5004-ABFE-7E292FE58EF4",
"key": "WBS1",
"type": "text"
},
{
"direction": "ascending",
"id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
"key": "RecordKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "WBS1",
"systemImage": "list.bullet.rectangle",
"title": "Projects dossier",
"titleKey": "Name"
},
{
"actions": [
{
"id": "6581EB40-31B3-55D5-B143-4071BC69222D",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "1CA4865F-B4BC-542D-A475-EC871D5E930E",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "5860245E-EB8F-55D3-B9EA-0F89A7396545",
"title": "Tasks",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WBS1",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ChargeType",
"label": "Charge type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Org",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ProjMgrName",
"label": "Project manager",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SupervisorName",
"label": "Supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EstCompletionDate",
"label": "Estimated completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PctComp",
"label": "Estimated complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BillingCurrencyCode",
"label": "Billing currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FeeBillingCurrency",
"label": "Stored labor / expense fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "67FDA52D-2962-5833-9123-9474929DA02E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "Name",
"label": "Name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "WBS1",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "WBS2",
"label": "Phase number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "ChargeType",
"label": "Charge type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "Org",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "ProjMgrName",
"label": "Project manager",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "SupervisorName",
"label": "Supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "EstStartDate",
"label": "Estimated start",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "EstCompletionDate",
"label": "Estimated completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "ActCompletionDate",
"label": "Actual completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "PctComp",
"label": "Estimated complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "LabPctComp",
"label": "Estimated labor complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "ExpPctComp",
"label": "Estimated expense complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored amounts in billing currency",
"detailRole": "information",
"isVisible": true,
"key": "BillingCurrencyCode",
"label": "Billing currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored amounts in billing currency",
"detailRole": "information",
"isVisible": true,
"key": "FeeBillingCurrency",
"label": "Stored labor / expense fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored amounts in billing currency",
"detailRole": "information",
"isVisible": true,
"key": "ReimbAllowBillingCurrency",
"label": "Stored reimbursable allowance",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored amounts in billing currency",
"detailRole": "information",
"isVisible": true,
"key": "ConsultFeeBillingCurrency",
"label": "Stored consultant fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Context",
"detailRole": "information",
"isVisible": true,
"key": "LongName",
"label": "Long name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Context",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Context",
"detailRole": "information",
"isVisible": true,
"key": "Memo",
"label": "Notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "223C7932-69A7-5CA7-9ED8-4C6178584886",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "AACACCD3-0B45-58C3-A22F-72AD6938163E",
"key": "WBS2",
"type": "text"
},
{
"direction": "ascending",
"id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
"key": "RecordKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "WBS2",
"systemImage": "list.bullet.rectangle",
"title": "Project phases",
"titleKey": "Name"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WBS1",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WBS2",
"label": "Phase number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ChargeType",
"label": "Charge type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Org",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ProjMgrName",
"label": "Project manager",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SupervisorName",
"label": "Supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EstCompletionDate",
"label": "Estimated completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PctComp",
"label": "Estimated complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BillingCurrencyCode",
"label": "Billing currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FeeBillingCurrency",
"label": "Stored labor / expense fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "5860245E-EB8F-55D3-B9EA-0F89A7396545",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "Name",
"label": "Name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "WBS1",
"label": "Project number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "WBS2",
"label": "Phase number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "WBS3",
"label": "Task number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "ChargeType",
"label": "Charge type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "Org",
"label": "Organization code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "ProjMgrName",
"label": "Project manager",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identity and team",
"detailRole": "information",
"isVisible": true,
"key": "SupervisorName",
"label": "Supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "EstStartDate",
"label": "Estimated start",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "EstCompletionDate",
"label": "Estimated completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "ActCompletionDate",
"label": "Actual completion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "PctComp",
"label": "Estimated complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "LabPctComp",
"label": "Estimated labor complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and estimated progress",
"detailRole": "information",
"isVisible": true,
"key": "ExpPctComp",
"label": "Estimated expense complete (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored amounts in billing currency",
"detailRole": "information",
"isVisible": true,
"key": "BillingCurrencyCode",
"label": "Billing currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored amounts in billing currency",
"detailRole": "information",
"isVisible": true,
"key": "FeeBillingCurrency",
"label": "Stored labor / expense fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored amounts in billing currency",
"detailRole": "information",
"isVisible": true,
"key": "ReimbAllowBillingCurrency",
"label": "Stored reimbursable allowance",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored amounts in billing currency",
"detailRole": "information",
"isVisible": true,
"key": "ConsultFeeBillingCurrency",
"label": "Stored consultant fee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Context",
"detailRole": "information",
"isVisible": true,
"key": "LongName",
"label": "Long name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Context",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Context",
"detailRole": "information",
"isVisible": true,
"key": "Memo",
"label": "Notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "10996F71-AE54-50AC-A00C-0659B72873A0",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "1D54279B-76CC-5A48-ABE0-16BD72803411",
"key": "WBS3",
"type": "text"
},
{
"direction": "ascending",
"id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
"key": "RecordKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "WBS3",
"systemImage": "list.bullet.rectangle",
"title": "Phase tasks",
"titleKey": "Name"
}
],
"relations": [
{
"childDatasetID": "67FDA52D-2962-5833-9123-9474929DA02E",
"childKey": "ParentKey",
"id": "01D33DAB-3847-5AA2-9C10-CF6B96B05116",
"name": "Phases",
"parentDatasetID": "302359E4-1A93-51CA-917F-08A9408CD89D",
"parentKey": "RecordKey"
},
{
"childDatasetID": "5860245E-EB8F-55D3-B9EA-0F89A7396545",
"childKey": "ParentKey",
"id": "1CA4865F-B4BC-542D-A475-EC871D5E930E",
"name": "Tasks",
"parentDatasetID": "67FDA52D-2962-5833-9123-9474929DA02E",
"parentKey": "RecordKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Deltek Vantagepoint",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-08T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. Select a project status, search by project number, name, organization or manager, then inspect its project dossier. Open Phases and then Tasks on demand, with actual child-list contents and grouped Details at every level. Keep the team, key dates, stored estimated progress, billing-currency compensation, site and notes together on your phone. \n\nWhy Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.\n\nPro: one SQL Server source, three lists and two relations; 31 project values, 21 phase values and 22 task values. Business WBS numbers remain visible; technical full-row and parent keys are hidden. The complete WBS1 + WBS2 + WBS3 identity is preserved. Repeated phase/task numbers under different parents do not merge. Phases and tasks are scoped by bound parent parameters before the row limit, not searched across the whole project tree. Orphan levels without the matching project/phase are not included. A phase with no tasks may legitimately show an empty task list.\n\nStored amounts are labor/direct-expense fees, reimbursable allowances and consultant fees in the top-level project billing currency. They are NOT invoices, billed revenue, actual costs, profit, balances or cash. Depending on ERP setup they may be entered at lower levels or rolled up; never add project, phase and task values together. Cifru performs no roll-up or currency conversion. Amounts for non-Regular charge types are left blank, not displayed as invented zero budgets. Unknown/blank currency must be checked in a real preview before interpreting an amount. PctComp, LabPctComp and ExpPctComp are stored ESTIMATED percentages, not a calculation of actual hours. Unknown status/charge codes remain Code plus their stored value; NULL stays blank. Organization and state/country remain native codes, not invented lookup descriptions. Manager, supervisor and principal names use the documented EMMain.Employee key, without payroll, private home contact or HR identifiers.\n\nSQL names, types and keys come from the official 2025.1 physical dictionary; supplementary WBS/billing semantics use vendor help 7.2. This is NOT a same-edition compatibility certificate. The full SQL key permits 30-character WBS values; the conflicting seven-character overview is not used to truncate them. StartDate/EndDate have conflicting or discouraged meanings across these sources and are not exposed. Estimated start uses EstStartDate, explicitly described in supplementary 7.2 help, and must be confirmed in the installed edition. ProjectCurrencyCode has conflicting functional/project currency descriptions and is not paired with amounts here. Lower levels use the root BillingCurrencyCode according to the supplementary vendor WBS currency rule; verify it in your edition. The 7.2 import format does not replace 2025.1 physical column lengths or infer missing SQL columns.\n\nLive on-demand reads; no scheduled refresh. Each list is bounded to 2,000 rows and may be incomplete. Local search and opening filters act on loaded rows; status is not a source predicate or an access control. A row limit is not a performance guarantee. Use an administrator-approved on-premises SQL Server database and a dedicated least-privilege SELECT account. Verify database, default schema, selected objects/columns, full keys, authorized company/project scope and query timings. No dbo owner is assumed; mismatched default-schema object resolution refuses results. An empty result can indicate missing metadata or an incorrect scope. Direct SQL does NOT inherit Vantagepoint roles or confidential-project/client controls. No automatic client-name join is added. Complete the Cifru read/compatibility test and inspect a real preview at import. No direct Deltek Cloud/ODBC access is promised. Do not use sa/sysadmin, writes, DDL, administration or migration examples.\n\nNot tested on a real ERP or SQL Server. Synthetic query-adapter tests and native DEMO screenshots do not prove installed compatibility. No credentials, connection address, cached source row, executable code or vendor HTML is included in the package. Unofficial and not affiliated with Deltek.\n\nPrimary physical dictionary: https://help.deltek.com/product/Vantagepoint/2025.1/DataDictionary/index.htm\nSupplementary project format: https://help.deltek.com/Product/Vantagepoint/7.2/ut_tf_projects.html\nWBS meanings: https://help.deltek.com/product/Vantagepoint/7.2/wbs_wbs_components_overview.html\nBilling currency: https://help.deltek.com/Product/Vantagepoint/7.2/hist_Contents_Proj_Invoice_Receipt.html\nStored contract amounts: https://help.deltek.com/product/Vantagepoint/7.2/project_create_new_contract_record_on_contract_mgt_tab.html",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "5D6A3DB0-A40A-523A-8BC1-9A175DCA6A3B",
"rootButtonCount": 1,
"summary": "Project team, dates, estimated progress, stored billing-currency fees and site; phases/tasks on demand.",
"tags": [
"Deltek Vantagepoint",
"SQL Server",
"Projects",
"Phases",
"Tasks",
"Pro"
],
"title": "Projects — phases and tasks Pro"
}
}