Employees — company, pay and time setup Pro
Company-filtered professional dossiers with scoped stored pay/cost references and time/expense defaults.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. For authorised HR, finance and team managers: choose an employee company and status, open a complete professional dossier, then inspect stored pay/cost reference terms or time/expense defaults on demand.
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 authorised SQL Server source, three lists and two separate children. 24 professional fields, 26 stored pay/cost fields and 14 time/expense fields. Professional identity, qualifications, organisation/supervisor, hire/termination dates, hours/day, useful work contact and notes. EmployeeCompany is mandatory before the first read; status/organisation are optional. Status is the COMPANY RECORD status, not proof of an active legal employment contract or the status in other companies. HomeCompany and association company are distinct. Native root predicates precede the bounded read; selector options may be a bounded source superset. Pay/time children keep BOTH Employee and EmployeeCompany before their limit; no other company is silently opened. Employee+EmployeeCompany identity uses original full text/lengths and stays hidden. Up to 2,000 displayed rows per list, live, no auto-refresh; no completeness/fast-query or SQL access-control promise.
PayRate and JobCostRate are STORED REFERENCE RATES, not net pay, actual pay received, annual/monthly salary, payroll totals or an effective-dated rate history. Hourly means per hour; Salary pay refers to the configured payroll period, while salaried job cost follows its configured job cost frequency. The two frequencies can differ. Rate methods/tables and effective dates can override the stored rates; inspect these references in your ERP before interpreting amounts. OtherPay1–5 are native stored supplement slots; their business headings and pay applicability depend on payroll configuration. No summing supplements, overtime, cost, billing and currencies into a computed salary. The next-raise date is not a raise amount/history. Company functional currency is current setup CONTEXT from CFGMainData, not certification of every override table currency or historical conversion. Confirm currency/basis/methods and enabled payroll/labour features in a real preview. Unknown currency stays blank, not default USD. Cost/pay method integers and table references remain native when their numeric coding is not documented. Provisional rates are references for unposted project reporting, not payslip amounts.
Time and expense setup shows expected hours, group/category and default labour code levels, permission to change defaults and transaction-processing approval. These are configuration values, not attendance history, balances of leave, expenses posted, rate-table enforcement or permissions implemented by Cifru. Ratios are displayed as stored without inventing a percent scaling. Current supervisor/name/contact/context is not a historical employment record. WorkPhone is selected; the employee email column is not certified to be a corporate-only address. Employee notes can contain confidential information: inspect before sharing.
Salary references require explicit HR-authorised access. Direct SQL does NOT inherit Deltek role/company/employee confidentiality or masking. The root does not project payroll amounts; separate children read them only on request, but this UI separation is not DB security. Use a dedicated least-privilege SELECT account and an administrator-approved on-premises database/scope. No SSN, national/tax identifiers, bank/IBAN/BIC, private home address/phone, family/medical/tax-return data, auth tokens, audit or obsolete fields are projected. Region and CheckHours conflicts, undocumented Terminated flag and unused BillingPool/photo are excluded, not guessed.
Physical 2025.1 EMMain/EMCompany/CFGMainData dictionary, with separate frozen 7.2 import/payroll/multicompany context. Import Employee-only PK and varchar lengths do not replace the physical composite key/nvarchar lengths. Documented A/I/T and P/E codes are decoded; other status/type/flag codes remain visible, NULL does not become Active/Yes/zero. Verify installed version, tables/default schema, HR scope, currency, rate basis, codes, query timing and real read/preview at import. No dbo assumption, sa/admin, writes, DDL, payroll action or direct Deltek Cloud access. Schema guard refuses ambiguous object resolution, not wrong DB or unauthorised scope. Not tested on real ERP/SQL Server/iOS; synthetic native DEMO does not prove installed compatibility. No credentials, private server address, cached source rows, executable code or vendor HTML in the download. Unofficial, not affiliated with Deltek.
Physical dictionary: https://help.deltek.com/product/Vantagepoint/2025.1/DataDictionary/index.htm
Employee context: https://help.deltek.com/Product/Vantagepoint/7.2/conc_employees_and_multicompany.html
Stored payroll context: https://help.deltek.com/Product/Vantagepoint/7.2/emp_Payroll_Tab_of_Employee_Info_Center.html
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Employees
- Details: Pay and costing
- Details: Time and expense setup
- Sub-button: Pay and costing
- Sub-button: Time and expense setup
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(DATALENGTH(c.Employee),N':',c.Employee,N':',DATALENGTH(c.EmployeeCompany),N':',c.EmployeeCompany) AS RecordKey, c.Employee AS Employee, NULLIF(LTRIM(RTRIM(CONCAT(e.FirstName,N' ',CASE WHEN NULLIF(e.MiddleName,N'') IS NOT NULL THEN CONCAT(e.MiddleName,N' ') ELSE N'' END,e.LastName))),N'') AS DisplayName, e.Title AS Title, c.EmployeeCompany AS EmployeeCompany, co.FirmName AS CompanyName, CASE c.Status WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'T' THEN N'Terminated' ELSE CASE WHEN c.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(c.Status)) END END AS Status, CASE c.Type WHEN N'P' THEN N'Principal' WHEN N'E' THEN N'Employee' ELSE CASE WHEN c.Type IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(c.Type)) END END AS Type, c.Org AS Org, c.HireDate AS HireDate, c.HoursPerDay AS HoursPerDay, NULLIF(LTRIM(RTRIM(CONCAT(sup.FirstName,N' ',CASE WHEN NULLIF(sup.MiddleName,N'') IS NOT NULL THEN CONCAT(sup.MiddleName,N' ') ELSE N'' END,sup.LastName))),N'') AS SupervisorName, e.HomeCompany AS HomeCompany, hc.FirmName AS HomeCompanyName, e.PreferredName AS PreferredName, e.ProfessionalSuffix AS ProfessionalSuffix, c.YearsOtherFirms AS YearsOtherFirms, c.PriorYearsFirm AS PriorYearsFirm, c.TerminationDate AS TerminationDate, e.WorkPhone AS WorkPhone, e.EMail AS EMail, e.Location AS Location, e.Language AS Language, e.TargetRatio AS TargetRatio, e.UtilizationRatio AS UtilizationRatio, e.Memo AS Memo FROM EMCompany c INNER JOIN EMMain e ON e.Employee=c.Employee LEFT JOIN CFGMainData co ON co.Company=c.EmployeeCompany LEFT JOIN CFGMainData hc ON hc.Company=e.HomeCompany LEFT JOIN EMMain sup ON sup.Employee=c.Supervisor WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'EMCompany',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMCompany',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(DATALENGTH(c.Employee),N':',c.Employee,N':',DATALENGTH(c.EmployeeCompany),N':',c.EmployeeCompany) AS RecordKey, c.Employee AS Employee, NULLIF(LTRIM(RTRIM(CONCAT(e.FirstName,N' ',CASE WHEN NULLIF(e.MiddleName,N'') IS NOT NULL THEN CONCAT(e.MiddleName,N' ') ELSE N'' END,e.LastName))),N'') AS DisplayName, co.FirmName AS CompanyName, c.EmployeeCompany AS EmployeeCompany, co.FunctionalCurrencyCode AS FunctionalCurrencyCode, CASE c.PayType WHEN N'H' THEN N'Hourly' WHEN N'S' THEN N'Salary' ELSE CASE WHEN c.PayType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(c.PayType)) END END AS PayType, CASE WHEN c.PayType=N'H' THEN N'Per hour' WHEN c.PayType=N'S' THEN N'Per configured payroll period' ELSE NULL END AS PayBasis, c.PayRate AS PayRate, c.PayOvtPct AS PayOvtPct, c.PaySpecialOvtPct AS PaySpecialOvtPct, c.OtherPay AS OtherPay, c.OtherPay2 AS OtherPay2, c.OtherPay3 AS OtherPay3, c.OtherPay4 AS OtherPay4, c.OtherPay5 AS OtherPay5, c.PayRateMeth AS PayRateMeth, c.PayRateTableNo AS PayRateTableNo, c.RaiseDate AS RaiseDate, CASE c.JobCostType WHEN N'H' THEN N'Hourly' WHEN N'S' THEN N'Salary' ELSE CASE WHEN c.JobCostType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(c.JobCostType)) END END AS JobCostType, CASE WHEN c.JobCostType=N'H' THEN N'Per hour' WHEN c.JobCostType=N'S' THEN N'Per configured job cost frequency' ELSE NULL END AS CostBasis, c.JobCostRate AS JobCostRate, c.JCOvtPct AS JCOvtPct, c.JCSpecialOvtPct AS JCSpecialOvtPct, c.CostRateMeth AS CostRateMeth, c.CostRateTableNo AS CostRateTableNo, c.ProvCostRate AS ProvCostRate, c.ProvBillRate AS ProvBillRate FROM EMCompany c INNER JOIN EMMain e ON e.Employee=c.Employee LEFT JOIN CFGMainData co ON co.Company=c.EmployeeCompany WHERE c.Employee=:employee AND c.EmployeeCompany=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'EMCompany',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMCompany',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(DATALENGTH(c.Employee),N':',c.Employee,N':',DATALENGTH(c.EmployeeCompany),N':',c.EmployeeCompany) AS RecordKey, c.Employee AS Employee, NULLIF(LTRIM(RTRIM(CONCAT(e.FirstName,N' ',CASE WHEN NULLIF(e.MiddleName,N'') IS NOT NULL THEN CONCAT(e.MiddleName,N' ') ELSE N'' END,e.LastName))),N'') AS DisplayName, co.FirmName AS CompanyName, c.EmployeeCompany AS EmployeeCompany, c.HoursPerDay AS HoursPerDay, c.TKGroup AS TKGroup, c.EKGroup AS EKGroup, c.BillingCategory AS BillingCategory, CASE c.ChangeDefaultLC WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN c.ChangeDefaultLC IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(c.ChangeDefaultLC)) END END AS ChangeDefaultLC, CASE c.ReadyForProcessing WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN c.ReadyForProcessing IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(c.ReadyForProcessing)) END END AS ReadyForProcessing, c.DefaultLC1 AS DefaultLC1, c.DefaultLC2 AS DefaultLC2, c.DefaultLC3 AS DefaultLC3, c.DefaultLC4 AS DefaultLC4, c.DefaultLC5 AS DefaultLC5 FROM EMCompany c INNER JOIN EMMain e ON e.Employee=c.Employee LEFT JOIN CFGMainData co ON co.Company=c.EmployeeCompany WHERE c.Employee=:employee AND c.EmployeeCompany=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'EMCompany',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMCompany',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Vantagepoint — HR-authorised SQL Server",
"id": "5BB7E512-C1D5-51F8-8551-BCF1E841729D",
"kind": "sqlServer",
"requiredObjects": [
"EMMain",
"EMCompany",
"CFGMainData"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "4DACB946-12B6-5992-947E-23CD22A5219D",
"key": "DisplayName",
"type": "text"
},
{
"direction": "ascending",
"id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
"key": "RecordKey",
"type": "text"
}
],
"id": "3F7A8D3F-25B6-56A4-9F03-3D80998AA3F7",
"mappings": [
{
"commonFieldKey": "",
"key": "Employee",
"label": "Internal Employee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Employee",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RecordKey",
"label": "Internal RecordKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RecordKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DisplayName",
"label": "Employee name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DisplayName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Title",
"label": "Job title",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Title",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EmployeeCompany",
"label": "Association company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EmployeeCompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CompanyName",
"label": "Association company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Status",
"label": "Company employee status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Status",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Type",
"label": "Employee type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Type",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Org",
"label": "Organisation code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Org",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HireDate",
"label": "Hire date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HireDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HoursPerDay",
"label": "Expected hours per day",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HoursPerDay",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SupervisorName",
"label": "Current supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SupervisorName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HomeCompany",
"label": "Home company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "HomeCompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HomeCompanyName",
"label": "Home company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "HomeCompanyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PreferredName",
"label": "Preferred name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PreferredName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProfessionalSuffix",
"label": "Professional qualifications",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProfessionalSuffix",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "YearsOtherFirms",
"label": "Years with other firms",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "YearsOtherFirms",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PriorYearsFirm",
"label": "Prior years with this firm",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PriorYearsFirm",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TerminationDate",
"label": "Termination date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TerminationDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WorkPhone",
"label": "Work phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WorkPhone",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EMail",
"label": "Employee email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EMail",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Location",
"label": "Location code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Location",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Language",
"label": "Communication language",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Language",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TargetRatio",
"label": "Target project-hours ratio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TargetRatio",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UtilizationRatio",
"label": "Utilisation ratio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UtilizationRatio",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Memo",
"label": "Employee notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Memo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Employees",
"primaryKey": "RecordKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"DisplayName",
"Title",
"EmployeeCompany",
"CompanyName",
"Status",
"Type",
"Org",
"HireDate",
"HoursPerDay",
"SupervisorName",
"HomeCompany",
"HomeCompanyName",
"PreferredName",
"ProfessionalSuffix",
"YearsOtherFirms",
"PriorYearsFirm",
"TerminationDate",
"WorkPhone",
"EMail",
"Location",
"Language",
"TargetRatio",
"UtilizationRatio",
"Memo"
],
"sourceID": "5BB7E512-C1D5-51F8-8551-BCF1E841729D",
"sqlQuery": "SELECT CONCAT(DATALENGTH(c.Employee),N':',c.Employee,N':',DATALENGTH(c.EmployeeCompany),N':',c.EmployeeCompany) AS RecordKey, c.Employee AS Employee, NULLIF(LTRIM(RTRIM(CONCAT(e.FirstName,N' ',CASE WHEN NULLIF(e.MiddleName,N'') IS NOT NULL THEN CONCAT(e.MiddleName,N' ') ELSE N'' END,e.LastName))),N'') AS DisplayName, e.Title AS Title, c.EmployeeCompany AS EmployeeCompany, co.FirmName AS CompanyName, CASE c.Status WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'T' THEN N'Terminated' ELSE CASE WHEN c.Status IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(c.Status)) END END AS Status, CASE c.Type WHEN N'P' THEN N'Principal' WHEN N'E' THEN N'Employee' ELSE CASE WHEN c.Type IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(c.Type)) END END AS Type, c.Org AS Org, c.HireDate AS HireDate, c.HoursPerDay AS HoursPerDay, NULLIF(LTRIM(RTRIM(CONCAT(sup.FirstName,N' ',CASE WHEN NULLIF(sup.MiddleName,N'') IS NOT NULL THEN CONCAT(sup.MiddleName,N' ') ELSE N'' END,sup.LastName))),N'') AS SupervisorName, e.HomeCompany AS HomeCompany, hc.FirmName AS HomeCompanyName, e.PreferredName AS PreferredName, e.ProfessionalSuffix AS ProfessionalSuffix, c.YearsOtherFirms AS YearsOtherFirms, c.PriorYearsFirm AS PriorYearsFirm, c.TerminationDate AS TerminationDate, e.WorkPhone AS WorkPhone, e.EMail AS EMail, e.Location AS Location, e.Language AS Language, e.TargetRatio AS TargetRatio, e.UtilizationRatio AS UtilizationRatio, e.Memo AS Memo FROM EMCompany c INNER JOIN EMMain e ON e.Employee=c.Employee LEFT JOIN CFGMainData co ON co.Company=c.EmployeeCompany LEFT JOIN CFGMainData hc ON hc.Company=e.HomeCompany LEFT JOIN EMMain sup ON sup.Employee=c.Supervisor WHERE SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'EMCompany',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMCompany',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "4DACB946-12B6-5992-947E-23CD22A5219D",
"key": "DisplayName",
"type": "text"
},
{
"direction": "ascending",
"id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
"key": "RecordKey",
"type": "text"
}
],
"id": "E1C65E81-6AD6-5FB6-A6DF-50136B5E54E1",
"mappings": [
{
"commonFieldKey": "",
"key": "Employee",
"label": "Internal Employee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Employee",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RecordKey",
"label": "Internal RecordKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RecordKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DisplayName",
"label": "Employee name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DisplayName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyName",
"label": "Association company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EmployeeCompany",
"label": "Association company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EmployeeCompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FunctionalCurrencyCode",
"label": "Company currency context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FunctionalCurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PayType",
"label": "Stored pay type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PayType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PayBasis",
"label": "Stored pay basis",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PayBasis",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PayRate",
"label": "Stored pay reference rate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PayRate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PayOvtPct",
"label": "Pay overtime percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PayOvtPct",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PaySpecialOvtPct",
"label": "Pay special overtime percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PaySpecialOvtPct",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OtherPay",
"label": "Stored other pay 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OtherPay",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OtherPay2",
"label": "Stored other pay 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OtherPay2",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OtherPay3",
"label": "Stored other pay 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OtherPay3",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OtherPay4",
"label": "Stored other pay 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OtherPay4",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OtherPay5",
"label": "Stored other pay 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OtherPay5",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PayRateMeth",
"label": "Pay rate method — native code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PayRateMeth",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PayRateTableNo",
"label": "Pay rate table reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PayRateTableNo",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RaiseDate",
"label": "Next raise date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RaiseDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JobCostType",
"label": "Stored job cost type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "JobCostType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CostBasis",
"label": "Stored job cost basis",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CostBasis",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JobCostRate",
"label": "Stored job cost reference rate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JobCostRate",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JCOvtPct",
"label": "Job cost overtime percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JCOvtPct",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JCSpecialOvtPct",
"label": "Job cost special overtime percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JCSpecialOvtPct",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CostRateMeth",
"label": "Cost rate method — native code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CostRateMeth",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CostRateTableNo",
"label": "Cost rate table reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CostRateTableNo",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProvCostRate",
"label": "Provisional cost reference rate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProvCostRate",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProvBillRate",
"label": "Provisional billing reference rate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProvBillRate",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Pay and costing",
"primaryKey": "RecordKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "Employee",
"id": "11E03282-FF48-507D-BA59-DA6F06C4C17B",
"name": "employee",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "EmployeeCompany",
"id": "AE0537A2-D4D7-5267-8DD2-AD71F4C01874",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"DisplayName",
"CompanyName",
"EmployeeCompany",
"FunctionalCurrencyCode",
"PayType",
"PayBasis",
"PayRate",
"PayOvtPct",
"PaySpecialOvtPct",
"OtherPay",
"OtherPay2",
"OtherPay3",
"OtherPay4",
"OtherPay5",
"PayRateMeth",
"PayRateTableNo",
"RaiseDate",
"JobCostType",
"CostBasis",
"JobCostRate",
"JCOvtPct",
"JCSpecialOvtPct",
"CostRateMeth",
"CostRateTableNo",
"ProvCostRate",
"ProvBillRate"
],
"sourceID": "5BB7E512-C1D5-51F8-8551-BCF1E841729D",
"sqlQuery": "SELECT CONCAT(DATALENGTH(c.Employee),N':',c.Employee,N':',DATALENGTH(c.EmployeeCompany),N':',c.EmployeeCompany) AS RecordKey, c.Employee AS Employee, NULLIF(LTRIM(RTRIM(CONCAT(e.FirstName,N' ',CASE WHEN NULLIF(e.MiddleName,N'') IS NOT NULL THEN CONCAT(e.MiddleName,N' ') ELSE N'' END,e.LastName))),N'') AS DisplayName, co.FirmName AS CompanyName, c.EmployeeCompany AS EmployeeCompany, co.FunctionalCurrencyCode AS FunctionalCurrencyCode, CASE c.PayType WHEN N'H' THEN N'Hourly' WHEN N'S' THEN N'Salary' ELSE CASE WHEN c.PayType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(c.PayType)) END END AS PayType, CASE WHEN c.PayType=N'H' THEN N'Per hour' WHEN c.PayType=N'S' THEN N'Per configured payroll period' ELSE NULL END AS PayBasis, c.PayRate AS PayRate, c.PayOvtPct AS PayOvtPct, c.PaySpecialOvtPct AS PaySpecialOvtPct, c.OtherPay AS OtherPay, c.OtherPay2 AS OtherPay2, c.OtherPay3 AS OtherPay3, c.OtherPay4 AS OtherPay4, c.OtherPay5 AS OtherPay5, c.PayRateMeth AS PayRateMeth, c.PayRateTableNo AS PayRateTableNo, c.RaiseDate AS RaiseDate, CASE c.JobCostType WHEN N'H' THEN N'Hourly' WHEN N'S' THEN N'Salary' ELSE CASE WHEN c.JobCostType IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(c.JobCostType)) END END AS JobCostType, CASE WHEN c.JobCostType=N'H' THEN N'Per hour' WHEN c.JobCostType=N'S' THEN N'Per configured job cost frequency' ELSE NULL END AS CostBasis, c.JobCostRate AS JobCostRate, c.JCOvtPct AS JCOvtPct, c.JCSpecialOvtPct AS JCSpecialOvtPct, c.CostRateMeth AS CostRateMeth, c.CostRateTableNo AS CostRateTableNo, c.ProvCostRate AS ProvCostRate, c.ProvBillRate AS ProvBillRate FROM EMCompany c INNER JOIN EMMain e ON e.Employee=c.Employee LEFT JOIN CFGMainData co ON co.Company=c.EmployeeCompany WHERE c.Employee=:employee AND c.EmployeeCompany=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'EMCompany',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMCompany',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "4DACB946-12B6-5992-947E-23CD22A5219D",
"key": "DisplayName",
"type": "text"
},
{
"direction": "ascending",
"id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
"key": "RecordKey",
"type": "text"
}
],
"id": "E912D49A-6B10-5010-B932-FBF85E30C863",
"mappings": [
{
"commonFieldKey": "",
"key": "Employee",
"label": "Internal Employee",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Employee",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RecordKey",
"label": "Internal RecordKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RecordKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DisplayName",
"label": "Employee name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DisplayName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyName",
"label": "Association company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CompanyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EmployeeCompany",
"label": "Association company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EmployeeCompany",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HoursPerDay",
"label": "Expected hours per day",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HoursPerDay",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TKGroup",
"label": "Timesheet group code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TKGroup",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EKGroup",
"label": "Expense group code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EKGroup",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BillingCategory",
"label": "Labour category code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BillingCategory",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ChangeDefaultLC",
"label": "May change labour codes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ChangeDefaultLC",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ReadyForProcessing",
"label": "Processing approved",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ReadyForProcessing",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DefaultLC1",
"label": "Default labour code level 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DefaultLC1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DefaultLC2",
"label": "Default labour code level 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DefaultLC2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DefaultLC3",
"label": "Default labour code level 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DefaultLC3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DefaultLC4",
"label": "Default labour code level 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DefaultLC4",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DefaultLC5",
"label": "Default labour code level 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DefaultLC5",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Time and expense setup",
"primaryKey": "RecordKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "Employee",
"id": "11E03282-FF48-507D-BA59-DA6F06C4C17B",
"name": "employee",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "EmployeeCompany",
"id": "AE0537A2-D4D7-5267-8DD2-AD71F4C01874",
"name": "company",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"DisplayName",
"CompanyName",
"EmployeeCompany",
"HoursPerDay",
"TKGroup",
"EKGroup",
"BillingCategory",
"ChangeDefaultLC",
"ReadyForProcessing",
"DefaultLC1",
"DefaultLC2",
"DefaultLC3",
"DefaultLC4",
"DefaultLC5"
],
"sourceID": "5BB7E512-C1D5-51F8-8551-BCF1E841729D",
"sqlQuery": "SELECT CONCAT(DATALENGTH(c.Employee),N':',c.Employee,N':',DATALENGTH(c.EmployeeCompany),N':',c.EmployeeCompany) AS RecordKey, c.Employee AS Employee, NULLIF(LTRIM(RTRIM(CONCAT(e.FirstName,N' ',CASE WHEN NULLIF(e.MiddleName,N'') IS NOT NULL THEN CONCAT(e.MiddleName,N' ') ELSE N'' END,e.LastName))),N'') AS DisplayName, co.FirmName AS CompanyName, c.EmployeeCompany AS EmployeeCompany, c.HoursPerDay AS HoursPerDay, c.TKGroup AS TKGroup, c.EKGroup AS EKGroup, c.BillingCategory AS BillingCategory, CASE c.ChangeDefaultLC WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN c.ChangeDefaultLC IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(c.ChangeDefaultLC)) END END AS ChangeDefaultLC, CASE c.ReadyForProcessing WHEN N'Y' THEN N'Yes' WHEN N'N' THEN N'No' ELSE CASE WHEN c.ReadyForProcessing IS NULL THEN N'' ELSE CONCAT(N'Code ',RTRIM(c.ReadyForProcessing)) END END AS ReadyForProcessing, c.DefaultLC1 AS DefaultLC1, c.DefaultLC2 AS DefaultLC2, c.DefaultLC3 AS DefaultLC3, c.DefaultLC4 AS DefaultLC4, c.DefaultLC5 AS DefaultLC5 FROM EMCompany c INNER JOIN EMMain e ON e.Employee=c.Employee LEFT JOIN CFGMainData co ON co.Company=c.EmployeeCompany WHERE c.Employee=:employee AND c.EmployeeCompany=:company AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'EMMain',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMMain',N'U') AND OBJECT_ID(N'EMCompany',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EMCompany',N'U') AND OBJECT_ID(N'CFGMainData',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CFGMainData',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "AF942D03-B118-54F1-BCEE-1AAFCB500488",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "08F1A975-B1BC-53D8-9F00-CC04BF288A97",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "E1C65E81-6AD6-5FB6-A6DF-50136B5E54E1",
"title": "Pay and costing",
"urlKey": ""
},
{
"id": "98E07441-7FE8-5C7C-82D3-EC3859E8D874",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "AA347B1F-D830-5E5E-A87F-D025A3A25578",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "E912D49A-6B10-5010-B932-FBF85E30C863",
"title": "Time and expense setup",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EmployeeCompany",
"label": "Association company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CompanyName",
"label": "Association company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Company employee status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Type",
"label": "Employee type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Org",
"label": "Organisation code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HireDate",
"label": "Hire date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HoursPerDay",
"label": "Expected hours per day",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SupervisorName",
"label": "Current supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HomeCompany",
"label": "Home company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HomeCompanyName",
"label": "Home company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "3F7A8D3F-25B6-56A4-9F03-3D80998AA3F7",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Employee and company",
"detailRole": "information",
"isVisible": true,
"key": "DisplayName",
"label": "Employee name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Employee and company",
"detailRole": "information",
"isVisible": true,
"key": "Title",
"label": "Job title",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Employee and company",
"detailRole": "information",
"isVisible": true,
"key": "EmployeeCompany",
"label": "Association company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Employee and company",
"detailRole": "information",
"isVisible": true,
"key": "CompanyName",
"label": "Association company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Employee and company",
"detailRole": "information",
"isVisible": true,
"key": "Status",
"label": "Company employee status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Employee and company",
"detailRole": "information",
"isVisible": true,
"key": "Type",
"label": "Employee type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Employee and company",
"detailRole": "information",
"isVisible": true,
"key": "Org",
"label": "Organisation code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Employee and company",
"detailRole": "information",
"isVisible": true,
"key": "HireDate",
"label": "Hire date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Employee and company",
"detailRole": "information",
"isVisible": true,
"key": "HoursPerDay",
"label": "Expected hours per day",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Employee and company",
"detailRole": "information",
"isVisible": true,
"key": "SupervisorName",
"label": "Current supervisor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Employee and company",
"detailRole": "information",
"isVisible": true,
"key": "HomeCompany",
"label": "Home company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Employee and company",
"detailRole": "information",
"isVisible": true,
"key": "HomeCompanyName",
"label": "Home company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Experience and contact",
"detailRole": "information",
"isVisible": true,
"key": "PreferredName",
"label": "Preferred name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Experience and contact",
"detailRole": "information",
"isVisible": true,
"key": "ProfessionalSuffix",
"label": "Professional qualifications",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Experience and contact",
"detailRole": "information",
"isVisible": true,
"key": "YearsOtherFirms",
"label": "Years with other firms",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Experience and contact",
"detailRole": "information",
"isVisible": true,
"key": "PriorYearsFirm",
"label": "Prior years with this firm",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Experience and contact",
"detailRole": "information",
"isVisible": true,
"key": "TerminationDate",
"label": "Termination date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Experience and contact",
"detailRole": "information",
"isVisible": true,
"key": "WorkPhone",
"label": "Work phone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Experience and contact",
"detailRole": "information",
"isVisible": true,
"key": "EMail",
"label": "Employee email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Professional context",
"detailRole": "information",
"isVisible": true,
"key": "Location",
"label": "Location code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Professional context",
"detailRole": "information",
"isVisible": true,
"key": "Language",
"label": "Communication language",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Professional context",
"detailRole": "information",
"isVisible": true,
"key": "TargetRatio",
"label": "Target project-hours ratio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Professional context",
"detailRole": "information",
"isVisible": true,
"key": "UtilizationRatio",
"label": "Utilisation ratio",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Professional context",
"detailRole": "information",
"isVisible": true,
"key": "Memo",
"label": "Employee notes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "394F2972-C4E8-52F7-8092-CE52E835FC37",
"openFilters": [
{
"id": "1C0BFACF-65B3-50F8-95C1-B3E1CE66AA01",
"includeAllOption": false,
"key": "EmployeeCompany",
"title": "Association company",
"type": "text"
},
{
"id": "65FD06CD-9950-52F4-9D2F-CE2BC029B23B",
"includeAllOption": true,
"key": "Status",
"title": "Company employee status",
"type": "text"
},
{
"id": "3D10FFE0-0129-57A7-923D-E56A5213DEF6",
"includeAllOption": true,
"key": "Org",
"title": "Organisation",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "4DACB946-12B6-5992-947E-23CD22A5219D",
"key": "DisplayName",
"type": "text"
},
{
"direction": "ascending",
"id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
"key": "RecordKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Title",
"systemImage": "person",
"title": "Employees",
"titleKey": "DisplayName"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EmployeeCompany",
"label": "Association company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FunctionalCurrencyCode",
"label": "Company currency context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PayType",
"label": "Stored pay type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PayBasis",
"label": "Stored pay basis",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PayRate",
"label": "Stored pay reference rate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PayOvtPct",
"label": "Pay overtime percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PaySpecialOvtPct",
"label": "Pay special overtime percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "E1C65E81-6AD6-5FB6-A6DF-50136B5E54E1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Stored pay reference",
"detailRole": "information",
"isVisible": true,
"key": "DisplayName",
"label": "Employee name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored pay reference",
"detailRole": "information",
"isVisible": true,
"key": "CompanyName",
"label": "Association company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored pay reference",
"detailRole": "information",
"isVisible": true,
"key": "EmployeeCompany",
"label": "Association company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored pay reference",
"detailRole": "information",
"isVisible": true,
"key": "FunctionalCurrencyCode",
"label": "Company currency context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored pay reference",
"detailRole": "information",
"isVisible": true,
"key": "PayType",
"label": "Stored pay type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored pay reference",
"detailRole": "information",
"isVisible": true,
"key": "PayBasis",
"label": "Stored pay basis",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored pay reference",
"detailRole": "information",
"isVisible": true,
"key": "PayRate",
"label": "Stored pay reference rate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored pay reference",
"detailRole": "information",
"isVisible": true,
"key": "PayOvtPct",
"label": "Pay overtime percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored pay reference",
"detailRole": "information",
"isVisible": true,
"key": "PaySpecialOvtPct",
"label": "Pay special overtime percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored pay supplements",
"detailRole": "information",
"isVisible": true,
"key": "OtherPay",
"label": "Stored other pay 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored pay supplements",
"detailRole": "information",
"isVisible": true,
"key": "OtherPay2",
"label": "Stored other pay 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored pay supplements",
"detailRole": "information",
"isVisible": true,
"key": "OtherPay3",
"label": "Stored other pay 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored pay supplements",
"detailRole": "information",
"isVisible": true,
"key": "OtherPay4",
"label": "Stored other pay 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored pay supplements",
"detailRole": "information",
"isVisible": true,
"key": "OtherPay5",
"label": "Stored other pay 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored pay supplements",
"detailRole": "information",
"isVisible": true,
"key": "PayRateMeth",
"label": "Pay rate method — native code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored pay supplements",
"detailRole": "information",
"isVisible": true,
"key": "PayRateTableNo",
"label": "Pay rate table reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored pay supplements",
"detailRole": "information",
"isVisible": true,
"key": "RaiseDate",
"label": "Next raise date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored costing references",
"detailRole": "information",
"isVisible": true,
"key": "JobCostType",
"label": "Stored job cost type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored costing references",
"detailRole": "information",
"isVisible": true,
"key": "CostBasis",
"label": "Stored job cost basis",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored costing references",
"detailRole": "information",
"isVisible": true,
"key": "JobCostRate",
"label": "Stored job cost reference rate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored costing references",
"detailRole": "information",
"isVisible": true,
"key": "JCOvtPct",
"label": "Job cost overtime percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored costing references",
"detailRole": "information",
"isVisible": true,
"key": "JCSpecialOvtPct",
"label": "Job cost special overtime percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored costing references",
"detailRole": "information",
"isVisible": true,
"key": "CostRateMeth",
"label": "Cost rate method — native code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored costing references",
"detailRole": "information",
"isVisible": true,
"key": "CostRateTableNo",
"label": "Cost rate table reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored costing references",
"detailRole": "information",
"isVisible": true,
"key": "ProvCostRate",
"label": "Provisional cost reference rate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored costing references",
"detailRole": "information",
"isVisible": true,
"key": "ProvBillRate",
"label": "Provisional billing reference rate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "7D01F901-3B73-5D8B-AD05-9231324F10C0",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "4DACB946-12B6-5992-947E-23CD22A5219D",
"key": "DisplayName",
"type": "text"
},
{
"direction": "ascending",
"id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
"key": "RecordKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "CompanyName",
"systemImage": "person",
"title": "Pay and costing",
"titleKey": "DisplayName"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EmployeeCompany",
"label": "Association company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HoursPerDay",
"label": "Expected hours per day",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TKGroup",
"label": "Timesheet group code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EKGroup",
"label": "Expense group code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BillingCategory",
"label": "Labour category code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ChangeDefaultLC",
"label": "May change labour codes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ReadyForProcessing",
"label": "Processing approved",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "E912D49A-6B10-5010-B932-FBF85E30C863",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Time and expense defaults",
"detailRole": "information",
"isVisible": true,
"key": "DisplayName",
"label": "Employee name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Time and expense defaults",
"detailRole": "information",
"isVisible": true,
"key": "CompanyName",
"label": "Association company",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Time and expense defaults",
"detailRole": "information",
"isVisible": true,
"key": "EmployeeCompany",
"label": "Association company code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Time and expense defaults",
"detailRole": "information",
"isVisible": true,
"key": "HoursPerDay",
"label": "Expected hours per day",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Time and expense defaults",
"detailRole": "information",
"isVisible": true,
"key": "TKGroup",
"label": "Timesheet group code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Time and expense defaults",
"detailRole": "information",
"isVisible": true,
"key": "EKGroup",
"label": "Expense group code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Time and expense defaults",
"detailRole": "information",
"isVisible": true,
"key": "BillingCategory",
"label": "Labour category code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Time and expense defaults",
"detailRole": "information",
"isVisible": true,
"key": "ChangeDefaultLC",
"label": "May change labour codes",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Time and expense defaults",
"detailRole": "information",
"isVisible": true,
"key": "ReadyForProcessing",
"label": "Processing approved",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Default labour codes",
"detailRole": "information",
"isVisible": true,
"key": "DefaultLC1",
"label": "Default labour code level 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Default labour codes",
"detailRole": "information",
"isVisible": true,
"key": "DefaultLC2",
"label": "Default labour code level 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Default labour codes",
"detailRole": "information",
"isVisible": true,
"key": "DefaultLC3",
"label": "Default labour code level 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Default labour codes",
"detailRole": "information",
"isVisible": true,
"key": "DefaultLC4",
"label": "Default labour code level 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Default labour codes",
"detailRole": "information",
"isVisible": true,
"key": "DefaultLC5",
"label": "Default labour code level 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "920E6827-D8F5-5EAE-8137-C921353F1A48",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "4DACB946-12B6-5992-947E-23CD22A5219D",
"key": "DisplayName",
"type": "text"
},
{
"direction": "ascending",
"id": "3F7E49B7-E357-59CD-A76D-C8C1BCEAEF33",
"key": "RecordKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "CompanyName",
"systemImage": "person",
"title": "Time and expense setup",
"titleKey": "DisplayName"
}
],
"relations": [
{
"childDatasetID": "E1C65E81-6AD6-5FB6-A6DF-50136B5E54E1",
"childKey": "RecordKey",
"id": "08F1A975-B1BC-53D8-9F00-CC04BF288A97",
"name": "Pay and costing",
"parentDatasetID": "3F7A8D3F-25B6-56A4-9F03-3D80998AA3F7",
"parentKey": "RecordKey"
},
{
"childDatasetID": "E912D49A-6B10-5010-B932-FBF85E30C863",
"childKey": "RecordKey",
"id": "AA347B1F-D830-5E5E-A87F-D025A3A25578",
"name": "Time and expense setup",
"parentDatasetID": "3F7A8D3F-25B6-56A4-9F03-3D80998AA3F7",
"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. For authorised HR, finance and team managers: choose an employee company and status, open a complete professional dossier, then inspect stored pay/cost reference terms or time/expense defaults on demand. \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 authorised SQL Server source, three lists and two separate children. 24 professional fields, 26 stored pay/cost fields and 14 time/expense fields. Professional identity, qualifications, organisation/supervisor, hire/termination dates, hours/day, useful work contact and notes. EmployeeCompany is mandatory before the first read; status/organisation are optional. Status is the COMPANY RECORD status, not proof of an active legal employment contract or the status in other companies. HomeCompany and association company are distinct. Native root predicates precede the bounded read; selector options may be a bounded source superset. Pay/time children keep BOTH Employee and EmployeeCompany before their limit; no other company is silently opened. Employee+EmployeeCompany identity uses original full text/lengths and stays hidden. Up to 2,000 displayed rows per list, live, no auto-refresh; no completeness/fast-query or SQL access-control promise.\n\nPayRate and JobCostRate are STORED REFERENCE RATES, not net pay, actual pay received, annual/monthly salary, payroll totals or an effective-dated rate history. Hourly means per hour; Salary pay refers to the configured payroll period, while salaried job cost follows its configured job cost frequency. The two frequencies can differ. Rate methods/tables and effective dates can override the stored rates; inspect these references in your ERP before interpreting amounts. OtherPay1–5 are native stored supplement slots; their business headings and pay applicability depend on payroll configuration. No summing supplements, overtime, cost, billing and currencies into a computed salary. The next-raise date is not a raise amount/history. Company functional currency is current setup CONTEXT from CFGMainData, not certification of every override table currency or historical conversion. Confirm currency/basis/methods and enabled payroll/labour features in a real preview. Unknown currency stays blank, not default USD. Cost/pay method integers and table references remain native when their numeric coding is not documented. Provisional rates are references for unposted project reporting, not payslip amounts.\n\nTime and expense setup shows expected hours, group/category and default labour code levels, permission to change defaults and transaction-processing approval. These are configuration values, not attendance history, balances of leave, expenses posted, rate-table enforcement or permissions implemented by Cifru. Ratios are displayed as stored without inventing a percent scaling. Current supervisor/name/contact/context is not a historical employment record. WorkPhone is selected; the employee email column is not certified to be a corporate-only address. Employee notes can contain confidential information: inspect before sharing.\n\nSalary references require explicit HR-authorised access. Direct SQL does NOT inherit Deltek role/company/employee confidentiality or masking. The root does not project payroll amounts; separate children read them only on request, but this UI separation is not DB security. Use a dedicated least-privilege SELECT account and an administrator-approved on-premises database/scope. No SSN, national/tax identifiers, bank/IBAN/BIC, private home address/phone, family/medical/tax-return data, auth tokens, audit or obsolete fields are projected. Region and CheckHours conflicts, undocumented Terminated flag and unused BillingPool/photo are excluded, not guessed.\n\nPhysical 2025.1 EMMain/EMCompany/CFGMainData dictionary, with separate frozen 7.2 import/payroll/multicompany context. Import Employee-only PK and varchar lengths do not replace the physical composite key/nvarchar lengths. Documented A/I/T and P/E codes are decoded; other status/type/flag codes remain visible, NULL does not become Active/Yes/zero. Verify installed version, tables/default schema, HR scope, currency, rate basis, codes, query timing and real read/preview at import. No dbo assumption, sa/admin, writes, DDL, payroll action or direct Deltek Cloud access. Schema guard refuses ambiguous object resolution, not wrong DB or unauthorised scope. Not tested on real ERP/SQL Server/iOS; synthetic native DEMO does not prove installed compatibility. No credentials, private server address, cached source rows, executable code or vendor HTML in the download. Unofficial, not affiliated with Deltek.\n\nPhysical dictionary: https://help.deltek.com/product/Vantagepoint/2025.1/DataDictionary/index.htm\nEmployee context: https://help.deltek.com/Product/Vantagepoint/7.2/conc_employees_and_multicompany.html\nStored payroll context: https://help.deltek.com/Product/Vantagepoint/7.2/emp_Payroll_Tab_of_Employee_Info_Center.html",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "EF511396-9332-5727-9E1B-BF2AD5F19B3B",
"rootButtonCount": 1,
"summary": "Company-filtered professional dossiers with scoped stored pay/cost references and time/expense defaults.",
"tags": [
"Deltek Vantagepoint",
"SQL Server",
"HR",
"Employees",
"Payroll",
"Pro"
],
"title": "Employees — company, pay and time setup Pro"
}
}