| Routine Summary, by layer | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fact | GeneralType | GeneralSchema | GeneralObject | create_date | modify_date | Columns | Parameters | KBs_SQL | ReferenceBy | ReferenceOf | Estimate | Layer |
| 29 | V | HumanResources | vEmployee | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 18 | 0 | 2 | 9 | 0 | 77 | 0 |
| 29 | V | HumanResources | vEmployeeDepartment | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 10 | 0 | 1 | 4 | 0 | 37 | 0 |
| 29 | V | HumanResources | vEmployeeDepartmentHistory | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 11 | 0 | 1 | 5 | 0 | 43 | 0 |
| 29 | V | HumanResources | vJobCandidate | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 16 | 0 | 4 | 1 | 0 | 49 | 0 |
| 29 | V | HumanResources | vJobCandidateEducation | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 13 | 0 | 3 | 1 | 0 | 39 | 0 |
| 29 | V | HumanResources | vJobCandidateEmployment | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 11 | 0 | 3 | 1 | 0 | 37 | 0 |
| 29 | V | Person | vAdditionalContactInfo | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 17 | 0 | 5 | 1 | 0 | 57 | 0 |
| 29 | V | Person | vStateProvinceCountryRegion | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 7 | 0 | 1 | 2 | 0 | 24 | 0 |
| 29 | V | Production | vProductAndDescription | 2017-10-27 14:33:14 | 2017-10-27 14:33:15 | 5 | 0 | 1 | 4 | 0 | 32 | 0 |
| 29 | V | Production | vProductModelCatalogDescription | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 25 | 0 | 7 | 1 | 0 | 79 | 0 |
| 29 | V | Production | vProductModelInstructions | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 11 | 0 | 2 | 1 | 0 | 30 | 0 |
| 29 | V | Purchasing | vVendorWithAddresses | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 9 | 0 | 1 | 6 | 0 | 46 | 0 |
| 29 | V | Purchasing | vVendorWithContacts | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 12 | 0 | 1 | 7 | 0 | 54 | 0 |
| 29 | V | Sales | vIndividualCustomer | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 18 | 0 | 2 | 10 | 0 | 82 | 0 |
| 29 | V | Sales | vPersonDemographics | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 13 | 0 | 4 | 1 | 0 | 46 | 0 |
| 29 | V | Sales | vSalesPerson | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 22 | 0 | 2 | 11 | 0 | 91 | 0 |
| 29 | V | Sales | vSalesPersonSalesByFiscalYears | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 7 | 0 | 2 | 5 | 0 | 46 | 0 |
| 29 | V | Sales | vStoreWithAddresses | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 9 | 0 | 1 | 6 | 0 | 46 | 0 |
| 29 | V | Sales | vStoreWithContacts | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 12 | 0 | 1 | 7 | 0 | 54 | 0 |
| 29 | V | Sales | vStoreWithDemographics | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 12 | 0 | 3 | 1 | 0 | 38 | 0 |
| 29 | P | dbo | uspGetBillOfMaterials | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 0 | 2 | 3 | 2 | 0 | 36 | 0 |
| 29 | P | dbo | uspGetEmployeeManagers | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 0 | 1 | 2 | 2 | 0 | 26 | 0 |
| 29 | P | dbo | uspGetManagerEmployees | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 0 | 1 | 2 | 2 | 0 | 26 | 0 |
| 29 | P | dbo | uspGetWhereUsedProductID | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 0 | 2 | 3 | 2 | 0 | 36 | 0 |
| 29 | P | dbo | uspSearchCandidateResumes | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 0 | 4 | 3 | 1 | 0 | 37 | 0 |
| 29 | P | HumanResources | uspUpdateEmployeeHireInfo | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 0 | 7 | 2 | 3 | 0 | 49 | 0 |
| 29 | P | HumanResources | uspUpdateEmployeeLogin | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 0 | 6 | 1 | 2 | 0 | 34 | 0 |
| 29 | P | HumanResources | uspUpdateEmployeePersonalInfo | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 0 | 5 | 1 | 2 | 0 | 31 | 0 |
| 29 | FN | dbo | ufnGetDocumentStatusText | 2017-10-27 14:33:15 | 2020-06-15 10:36:59 | 0 | 1 | 1 | 0 | 0 | 9 | 0 |
| 29 | FN | dbo | ufnGetProductDealerPrice | 2017-10-27 14:33:15 | 2020-06-15 10:36:59 | 0 | 2 | 1 | 2 | 0 | 22 | 0 |
| 29 | FN | dbo | ufnGetProductListPrice | 2017-10-27 14:33:15 | 2020-06-15 10:36:59 | 0 | 2 | 1 | 2 | 0 | 22 | 0 |
| 29 | FN | dbo | ufnGetProductStandardCost | 2017-10-27 14:33:15 | 2020-06-15 10:36:59 | 0 | 2 | 1 | 2 | 0 | 22 | 0 |
| 29 | FN | dbo | ufnGetPurchaseOrderStatusText | 2017-10-27 14:33:15 | 2020-06-15 10:36:59 | 0 | 1 | 1 | 0 | 0 | 9 | 0 |
| 29 | FN | dbo | ufnGetSalesOrderStatusText | 2017-10-27 14:33:15 | 2020-06-15 10:36:59 | 0 | 1 | 1 | 0 | 0 | 9 | 0 |
| 29 | FN | dbo | ufnGetStock | 2017-10-27 14:33:15 | 2020-06-15 10:36:59 | 0 | 1 | 1 | 1 | 0 | 14 | 0 |
| 29 | TF | dbo | ufnGetContactInformation | 2017-10-27 14:33:15 | 2017-10-27 14:33:15 | 5 | 1 | 3 | 7 | 0 | 64 | 0 |
| 29 | TR | HumanResources | dEmployee | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 0 | 0 | 1 | 0 | 0 | 6 | 0 |
| 29 | TR | Person | iuPerson | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 0 | 0 | 2 | 1 | 0 | 18 | 0 |
| 29 | TR | Production | iWorkOrder | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 0 | 0 | 1 | 3 | 0 | 21 | 0 |
| 29 | TR | Production | uWorkOrder | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 0 | 0 | 2 | 3 | 0 | 28 | 0 |
| 29 | TR | Purchasing | dVendor | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 0 | 0 | 2 | 2 | 0 | 23 | 0 |
| 29 | TR | Purchasing | iPurchaseOrderDetail | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 0 | 0 | 2 | 5 | 0 | 38 | 0 |
| 29 | TR | Purchasing | uPurchaseOrderDetail | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 0 | 0 | 3 | 5 | 0 | 45 | 0 |
| 29 | TR | Purchasing | uPurchaseOrderHeader | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 0 | 0 | 2 | 3 | 0 | 28 | 0 |
| 29 | TR | Sales | iduSalesOrderDetail | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 0 | 0 | 4 | 7 | 0 | 62 | 0 |
| 29 | TR | Sales | uSalesOrderHeader | 2017-10-27 14:33:14 | 2017-10-27 14:33:14 | 0 | 0 | 3 | 7 | 0 | 55 | 0 |
| 29 | P | dbo | uspLogError | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | 0 | 1 | 3 | 2 | 11 | 132 | 1 |
| 29 | FN | dbo | ufnGetAccountingEndDate | 2017-10-27 14:33:15 | 2020-06-15 10:36:59 | 0 | 0 | 1 | 0 | 1 | 15 | 1 |
| 29 | FN | dbo | ufnGetAccountingStartDate | 2017-10-27 14:33:15 | 2020-06-15 10:36:59 | 0 | 0 | 1 | 0 | 1 | 15 | 1 |
| 29 | FN | dbo | ufnLeadingZeros | 2017-10-27 14:33:01 | 2020-06-15 10:36:59 | 0 | 1 | 1 | 0 | 0 | 9 | 1 |
| 29 | P | dbo | uspPrintError | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | 0 | 0 | 1 | 0 | 9 | 87 | 2 |