Deltek generates this information using a live connection to the development database. Tables and columns related to features in a future release may appear in the data dictionary without descriptions, or with the phrase reserved for future use. You may also see tables and columns for features that you have not purchased or enabled.
|
Table Name |
| CFGIntegrationCompany |
| CFGIntegrationWSEmployeeTypes |
| CFGTalentIntegrationMapping |
| CustomDashpartCache |
| CustomIntegration |
| CustomIntegrationTask |
| CustomIntegrationTaskAudit |
| DataSource |
| DataSourceExport |
| DataSourceExportAudit |
| DataSourceTarget |
| FW_CFGDataPackData |
| FW_CFGDataPackDesc |
| FW_CFGEnabledLanguages |
| JEDocuments |
| JEDocumentsDetail |
| PNBaselineRevenueLabor |
| PNPlannedRevenueLabor |
| RPBaselineRevenueLabor |
| RPPlannedRevenueLabor |
| SEDataPack |
| SEDataSource |
|
Table Name |
| CFGBPEmployeeClassData |
| CFGBPEmployeeClassDescriptions |
|
Table Name |
| None |
|
Table Name |
Column Name |
DataType |
| BT | SupportDocumentsJE | varchar(1) NOT NULL default ('N') |
| BTDefaults | SupportDocumentsJE | varchar(1) NOT NULL default ('N') |
| CFGEKCategoryTaxCodes | PKey | varchar(32) NOT NULL default (left(replace(newid(),'-',''),(32)) |
| CFGEKCategoryTaxCodes | TaxLocation | nvarchar(50) |
| CFGIntegrationWS | LimitByEmployeeType | varchar(1) NOT NULL default ('N') |
| CFGIntegrationWS | OnlySendOrganizationsWithEmployees | varchar(1) NOT NULL default ('N') |
| CFGIntegrationWS | PIMAllowFullAccess | varchar(1) NOT NULL default ('Y') |
| CFGIntegrationWS | SyncContactsPreferredName | varchar(1) NOT NULL default ('N') |
| CFGIntegrationWS | SyncEmployeesPreferredName | varchar(1) NOT NULL default ('N') |
| CFGIntegrationWS | SyncProjectsOverhead | varchar(1) NOT NULL default ('Y') |
| CFGIntegrationWS | SyncProjectsPromotional | varchar(1) NOT NULL default ('Y') |
| CFGIntegrationWS | SyncProjectsRegular | varchar(1) NOT NULL default ('Y') |
| CFGResourcePlanning | LCLevel1Enabled | varchar(1) NOT NULL default ('Y') |
| CFGResourcePlanning | LCLevel2Enabled | varchar(1) NOT NULL default ('Y') |
| CFGResourcePlanning | LCLevel3Enabled | varchar(1) NOT NULL default ('Y') |
| CFGResourcePlanning | LCLevel4Enabled | varchar(1) NOT NULL default ('Y') |
| CFGResourcePlanning | LCLevel5Enabled | varchar(1) NOT NULL default ('Y') |
| CFGRMSettings | RevenueCalculationsOption | smallint NOT NULL default (0) |
| CFGScreenDesignerData | PropertyBag | varchar(max) |
| CFGScreenDesignerLabels | AlternateLabel | nvarchar(max) |
| ekDetail | DetailPKey | varchar(32) NOT NULL default (left(replace(newid(),'-',''),(32)) |
| ekDetail | MasterPKey | varchar(32) NOT NULL default (left(replace(newid(),'-',''),(32)) |
| ekDetail | TaxLocation | nvarchar(50) |
| ekDetailTax | DetailPKey | varchar(32) NOT NULL default (left(replace(newid(),'-',''),(32)) |
| ekDetailTax | MasterPKey | varchar(32) NOT NULL default (left(replace(newid(),'-',''),(32)) |
| EKDocuments | MasterPKey | varchar(32) NOT NULL default (left(replace(newid(),'-',''),(32)) |
| EKDocumentsDetail | DetailPKey | varchar(32) NOT NULL default (left(replace(newid(),'-',''),(32)) |
| EKDocumentsDetail | MasterPKey | varchar(32) NOT NULL default (left(replace(newid(),'-',''),(32)) |
| ekMaster | DefaultTaxLocation | nvarchar(50) |
| ekMaster | MasterPKey | varchar(32) NOT NULL default (left(replace(newid(),'-',''),(32)) |
| EMCompany | DefaultTaxLocation | nvarchar(50) |
| EMCompany | Terminated | varchar(1) NOT NULL default ('N') |
| FW_CFGSystem | EmRestrictTerminated | varchar(1) NOT NULL default ('N') |
| FW_PerfManagement | Pkey | nvarchar(4) NOT NULL default ('Dltk') |
| FW_Workbook | ContentURL | nvarchar(200) |
| FW_Workbook | ViewID | nvarchar(50) NOT NULL |
| FW_Workbook | WorkbookID | nvarchar(50) NOT NULL |
| FW_Workbook | WorkbookName | nvarchar(200) |
| FW_WorkbookFilters | WorkbookID | nvarchar(50) NOT NULL |
| PNPlan | LCLevel1Enabled | varchar(1) NOT NULL default ('Y') |
| PNPlan | LCLevel2Enabled | varchar(1) NOT NULL default ('Y') |
| PNPlan | LCLevel3Enabled | varchar(1) NOT NULL default ('Y') |
| PNPlan | LCLevel4Enabled | varchar(1) NOT NULL default ('Y') |
| PNPlan | LCLevel5Enabled | varchar(1) NOT NULL default ('Y') |
| RPPlan | LCLevel1Enabled | varchar(1) NOT NULL default ('Y') |
| RPPlan | LCLevel2Enabled | varchar(1) NOT NULL default ('Y') |
| RPPlan | LCLevel3Enabled | varchar(1) NOT NULL default ('Y') |
| RPPlan | LCLevel4Enabled | varchar(1) NOT NULL default ('Y') |
| RPPlan | LCLevel5Enabled | varchar(1) NOT NULL default ('Y') |
| SE | AccessAllDataPacks | varchar(1) NOT NULL default ('N') |
| SE | AccessAllDataSources | varchar(1) NOT NULL default ('N') |
| SE | AllowAccessToVIDashpart | varchar(1) NOT NULL default ('N') |
| SE | DataPackAdmin | varchar(1) NOT NULL default ('N') |
| SE | DataSourceAdmin | varchar(1) NOT NULL default ('N') |
| SE | InteractiveBillingAllowEditsAccept | varchar(1) NOT NULL default ('N') |
| SEUser | DisplayUsername | nvarchar(120) NOT NULL |
| SEUser | Status | varchar(1) NOT NULL default ('A') |
|
Table Name |
Column Name |
New DataType |
Old DataType |
| AbsenceRequests | CreateUser | nvarchar(32) | nvarchar(20) |
| AbsenceRequests | ModUser | nvarchar(32) | nvarchar(20) |
| AccountCustomTabFields | CreateUser | nvarchar(32) | nvarchar(20) |
| AccountCustomTabFields | ModUser | nvarchar(32) | nvarchar(20) |
| Activity | CreateUser | nvarchar(32) | nvarchar(20) |
| Activity | ModUser | nvarchar(32) | nvarchar(20) |
| ActivityCustomTabFields | CreateUser | nvarchar(32) | nvarchar(20) |
| ActivityCustomTabFields | ModUser | nvarchar(32) | nvarchar(20) |
| ActivityFileLinks | CreateUser | nvarchar(32) | nvarchar(20) |
| ActivityFileLinks | ModUser | nvarchar(32) | nvarchar(20) |
| ActivitySubscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| APApprovalMaster | CreateUser | nvarchar(32) | nvarchar(20) |
| APApprovalMaster | ModUser | nvarchar(32) | nvarchar(20) |
| apControl | Creator | nvarchar(32) | nvarchar(20) |
| apMaster | ModUser | nvarchar(32) | nvarchar(20) |
| ApprovalItem | CreateUser | nvarchar(32) | nvarchar(20) |
| ApprovalItem | ModUser | nvarchar(32) | nvarchar(20) |
| ApprovalItemHistory | Responsibility | nvarchar(255) | nvarchar(50) |
| ARC | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| BankRecImport | CreateUser | nvarchar(32) | nvarchar(20) |
| BankRecTransaction | CreateUser | nvarchar(32) | nvarchar(20) |
| BIED | ModUser | nvarchar(32) | nvarchar(20) |
| BILD | ModUser | nvarchar(32) | nvarchar(20) |
| BillingXferAudit | CreateUser | nvarchar(32) | nvarchar(20) |
| BT | CreateUser | nvarchar(32) | nvarchar(20) |
| BT | ModUser | nvarchar(32) | nvarchar(20) |
| BTA | CreateUser | nvarchar(32) | nvarchar(20) |
| BTA | ModUser | nvarchar(32) | nvarchar(20) |
| BTF | CreateUser | nvarchar(32) | nvarchar(20) |
| BTF | ModUser | nvarchar(32) | nvarchar(20) |
| BTTaxCodes | CreateUser | nvarchar(32) | nvarchar(20) |
| BTTaxCodes | ModUser | nvarchar(32) | nvarchar(20) |
| BulkUpdate | CreateUser | nvarchar(32) | nvarchar(20) |
| BulkUpdateHistory | CreateUser | nvarchar(32) | nvarchar(20) |
| BulkUpdateHistory | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| CA | CreateUser | nvarchar(32) | nvarchar(20) |
| CA | ModUser | nvarchar(32) | nvarchar(20) |
| CAB | CreateUser | nvarchar(32) | nvarchar(20) |
| CAB | ModUser | nvarchar(32) | nvarchar(20) |
| CACompanyMapping | CreateUser | nvarchar(32) | nvarchar(20) |
| CACompanyMapping | ModUser | nvarchar(32) | nvarchar(20) |
| cdControl | Creator | nvarchar(32) | nvarchar(20) |
| cdMaster | ModUser | nvarchar(32) | nvarchar(20) |
| CFGBillMainData | InvoiceAddressee | varchar(1) NOT NULL default ('1') | varchar(1) NOT NULL default ('0') |
| CFGCurrencyExchange | CreateUser | nvarchar(32) | nvarchar(20) |
| CFGCurrencyExchange | ModUser | nvarchar(32) | nvarchar(20) |
| CFGCurrencyExchangePeriod | CreateUser | nvarchar(32) | nvarchar(20) |
| CFGCurrencyExchangePeriod | ModUser | nvarchar(32) | nvarchar(20) |
| CFGDatesStatus | CreateUser | nvarchar(32) | nvarchar(20) |
| CFGDatesStatus | ModUser | nvarchar(32) | nvarchar(20) |
| CFGPostControl | UserName | nvarchar(32) | nvarchar(20) |
| CFGSalesforceMapping | CreateUser | nvarchar(32) | nvarchar(20) |
| CFGSalesforceMapping | ModUser | nvarchar(32) | nvarchar(20) |
| CFGScreenDesignerData | CreateUser | nvarchar(32) | nvarchar(20) |
| CFGScreenDesignerData | ModUser | nvarchar(32) | nvarchar(20) |
| CFGWSSFolders | CreateUser | nvarchar(32) | nvarchar(20) |
| CFGWSSFolders | ModUser | nvarchar(32) | nvarchar(20) |
| CFGWSSLists | CreateUser | nvarchar(32) | nvarchar(20) |
| CFGWSSLists | ModUser | nvarchar(32) | nvarchar(20) |
| CFGWSSSites | CreateUser | nvarchar(32) | nvarchar(20) |
| CFGWSSSites | ModUser | nvarchar(32) | nvarchar(20) |
| CLActivity | CreateUser | nvarchar(32) | nvarchar(20) |
| CLActivity | ModUser | nvarchar(32) | nvarchar(20) |
| CLAddress | CreateUser | nvarchar(32) | nvarchar(20) |
| CLAddress | ModUser | nvarchar(32) | nvarchar(20) |
| Clendor | CreateUser | nvarchar(32) | nvarchar(20) |
| Clendor | ModUser | nvarchar(32) | nvarchar(20) |
| ClendorProjectAssoc | CreateUser | nvarchar(32) | nvarchar(20) |
| ClendorProjectAssoc | ModUser | nvarchar(32) | nvarchar(20) |
| ClendorProjectAssocTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| ClendorProjectAssocTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| ClientAlias | CreateUser | nvarchar(32) | nvarchar(20) |
| ClientAlias | ModUser | nvarchar(32) | nvarchar(20) |
| ClientCustomTabFields | CreateUser | nvarchar(32) | nvarchar(20) |
| ClientCustomTabFields | ModUser | nvarchar(32) | nvarchar(20) |
| ClientFileLinks | CreateUser | nvarchar(32) | nvarchar(20) |
| ClientFileLinks | ModUser | nvarchar(32) | nvarchar(20) |
| ClientFromContacts | CreateUser | nvarchar(32) | nvarchar(20) |
| ClientFromContacts | ModUser | nvarchar(32) | nvarchar(20) |
| ClientPhoto | CreateUser | nvarchar(32) | nvarchar(20) |
| ClientPhoto | ModUser | nvarchar(32) | nvarchar(20) |
| ClientsideSettings | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| ClientToClientAssoc | CreateUser | nvarchar(32) | nvarchar(20) |
| ClientToClientAssoc | ModUser | nvarchar(32) | nvarchar(20) |
| CLSubscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| ContactActivity | CreateUser | nvarchar(32) | nvarchar(20) |
| ContactActivity | ModUser | nvarchar(32) | nvarchar(20) |
| ContactCustomTabFields | CreateUser | nvarchar(32) | nvarchar(20) |
| ContactCustomTabFields | ModUser | nvarchar(32) | nvarchar(20) |
| ContactFileLinks | CreateUser | nvarchar(32) | nvarchar(20) |
| ContactFileLinks | ModUser | nvarchar(32) | nvarchar(20) |
| ContactMoreInfo | CreateUser | nvarchar(32) | nvarchar(20) |
| ContactMoreInfo | ModUser | nvarchar(32) | nvarchar(20) |
| ContactPhoto | CreateUser | nvarchar(32) | nvarchar(20) |
| ContactPhoto | ModUser | nvarchar(32) | nvarchar(20) |
| Contacts | CreateUser | nvarchar(32) | nvarchar(20) |
| Contacts | ModUser | nvarchar(32) | nvarchar(20) |
| ContactsFromLeads | CreateUser | nvarchar(32) | nvarchar(20) |
| ContactsFromLeads | ModUser | nvarchar(32) | nvarchar(20) |
| ContactSubscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| ContactToContactAssoc | CreateUser | nvarchar(32) | nvarchar(20) |
| ContactToContactAssoc | ModUser | nvarchar(32) | nvarchar(20) |
| ContractCredit | CreateUser | nvarchar(32) | nvarchar(20) |
| ContractCredit | ModUser | nvarchar(32) | nvarchar(20) |
| ContractCreditTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| ContractCreditTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| ContractDetails | CreateUser | nvarchar(32) | nvarchar(20) |
| ContractDetails | ModUser | nvarchar(32) | nvarchar(20) |
| ContractDetailsTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| ContractDetailsTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| Contracts | CreateUser | nvarchar(32) | nvarchar(20) |
| Contracts | ModUser | nvarchar(32) | nvarchar(20) |
| ContractsTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| ContractsTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| crControl | Creator | nvarchar(32) | nvarchar(20) |
| CreditCardImport | CreateUser | nvarchar(32) | nvarchar(20) |
| CreditCardTransaction | CreateUser | nvarchar(32) | nvarchar(20) |
| crMaster | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposal | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposal | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalClient | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalClient | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalClientGraphics | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalClientGraphics | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalContact | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalContact | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalElements | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalElements | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalEmployee | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalEmployee | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalEmployeeGraphics | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalEmployeeGraphics | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalFiles | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalFiles | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalImages | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalImages | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalMktCampaign | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalMktCampaign | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalMktCampaignGraphics | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalMktCampaignGraphics | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalOrder | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalOrder | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalProject | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalProject | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalProjectGraphics | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalProjectGraphics | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalProjTeam | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalProjTeam | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalSubscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| CustomProposalTextLibGraphics | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalTextLibGraphics | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalTextLibGraphics | Name | varchar(32) NOT NULL | nvarchar(50) NOT NULL |
| CustomProposalTextLibrary | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalTextLibrary | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalTextLibrary | Name | varchar(32) NOT NULL | nvarchar(50) NOT NULL |
| CustomProposalVendor | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalVendor | ModUser | nvarchar(32) | nvarchar(20) |
| CustomProposalVendorGraphics | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomProposalVendorGraphics | ModUser | nvarchar(32) | nvarchar(20) |
| CustomRepLookupData | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomRepLookupData | ModUser | nvarchar(32) | nvarchar(20) |
| CustomRepOptsData | CreateUser | nvarchar(32) | nvarchar(20) |
| CustomRepOptsData | ModUser | nvarchar(32) | nvarchar(20) |
| cvControl | Creator | nvarchar(32) | nvarchar(20) |
| cvMaster | ModUser | nvarchar(32) | nvarchar(20) |
| DashboardLookupOptions | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| DashboardURLParts | CreateUser | nvarchar(32) | nvarchar(20) |
| DashboardURLParts | ModUser | nvarchar(32) | nvarchar(20) |
| DashboardURLParts | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| DashboardUser | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| DocumentsCL | CreateUser | nvarchar(32) | nvarchar(20) |
| DocumentsCL | ModUser | nvarchar(32) | nvarchar(20) |
| DocumentsContacts | CreateUser | nvarchar(32) | nvarchar(20) |
| DocumentsContacts | ModUser | nvarchar(32) | nvarchar(20) |
| DocumentsEM | CreateUser | nvarchar(32) | nvarchar(20) |
| DocumentsEM | ModUser | nvarchar(32) | nvarchar(20) |
| DocumentsMktCampaign | CreateUser | nvarchar(32) | nvarchar(20) |
| DocumentsMktCampaign | ModUser | nvarchar(32) | nvarchar(20) |
| DocumentsPR | CreateUser | nvarchar(32) | nvarchar(20) |
| DocumentsPR | ModUser | nvarchar(32) | nvarchar(20) |
| DocumentsTextLibrary | CreateUser | nvarchar(32) | nvarchar(20) |
| DocumentsTextLibrary | ModUser | nvarchar(32) | nvarchar(20) |
| DocumentsTextLibrary | Name | varchar(32) NOT NULL | nvarchar(50) NOT NULL |
| DocumentsVE | CreateUser | nvarchar(32) | nvarchar(20) |
| DocumentsVE | ModUser | nvarchar(32) | nvarchar(20) |
| ekMaster | CreateUser | nvarchar(32) | nvarchar(20) |
| ekMaster | ModUser | nvarchar(32) | nvarchar(20) |
| EMAccrual | CreateUser | nvarchar(32) | nvarchar(20) |
| EMAccrual | ModUser | nvarchar(32) | nvarchar(20) |
| EMAccrualDetail | CreateUser | nvarchar(32) | nvarchar(20) |
| EMAccrualDetail | ModUser | nvarchar(32) | nvarchar(20) |
| EMActivity | CreateUser | nvarchar(32) | nvarchar(20) |
| EMActivity | ModUser | nvarchar(32) | nvarchar(20) |
| EmailTemplates | CreateUser | nvarchar(32) | nvarchar(20) |
| EmailTemplates | ModUser | nvarchar(32) | nvarchar(20) |
| EmailTemplates | Username | nvarchar(32) NOT NULL default (' ') | nvarchar(20) NOT NULL default (' ') |
| EMCitizenship | CreateUser | nvarchar(32) | nvarchar(20) |
| EMCitizenship | ModUser | nvarchar(32) | nvarchar(20) |
| EMClientAssoc | CreateUser | nvarchar(32) | nvarchar(20) |
| EMClientAssoc | ModUser | nvarchar(32) | nvarchar(20) |
| EMCompany | CreateUser | nvarchar(32) | nvarchar(20) |
| EMCompany | ModUser | nvarchar(32) | nvarchar(20) |
| EMContactAssoc | CreateUser | nvarchar(32) | nvarchar(20) |
| EMContactAssoc | ModUser | nvarchar(32) | nvarchar(20) |
| EMDegree | CreateUser | nvarchar(32) | nvarchar(20) |
| EMDegree | ModUser | nvarchar(32) | nvarchar(20) |
| EMDirectDeposit | CreateUser | nvarchar(32) | nvarchar(20) |
| EMDirectDeposit | ModUser | nvarchar(32) | nvarchar(20) |
| EMEKGroups | CreateUser | nvarchar(32) | nvarchar(20) |
| EMEKGroups | ModUser | nvarchar(32) | nvarchar(20) |
| EMLocale | CreateUser | nvarchar(32) | nvarchar(20) |
| EMLocale | ModUser | nvarchar(32) | nvarchar(20) |
| EMMain | CreateUser | nvarchar(32) | nvarchar(20) |
| EMMain | ModUser | nvarchar(32) | nvarchar(20) |
| EMPayroll | CreateUser | nvarchar(32) | nvarchar(20) |
| EMPayroll | ModUser | nvarchar(32) | nvarchar(20) |
| EMPayrollContribution | CreateUser | nvarchar(32) | nvarchar(20) |
| EMPayrollContribution | ModUser | nvarchar(32) | nvarchar(20) |
| EMPayrollWithholding | CreateUser | nvarchar(32) | nvarchar(20) |
| EMPayrollWithholding | ModUser | nvarchar(32) | nvarchar(20) |
| EMPhoto | CreateUser | nvarchar(32) | nvarchar(20) |
| EMPhoto | ModUser | nvarchar(32) | nvarchar(20) |
| EmployeeCustomTabFields | CreateUser | nvarchar(32) | nvarchar(20) |
| EmployeeCustomTabFields | ModUser | nvarchar(32) | nvarchar(20) |
| EmployeeFileLinks | CreateUser | nvarchar(32) | nvarchar(20) |
| EmployeeFileLinks | ModUser | nvarchar(32) | nvarchar(20) |
| EMProjectAssoc | CreateUser | nvarchar(32) | nvarchar(20) |
| EMProjectAssoc | ModUser | nvarchar(32) | nvarchar(20) |
| EMProjectAssocTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| EMProjectAssocTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| EMRegistration | CreateUser | nvarchar(32) | nvarchar(20) |
| EMRegistration | ModUser | nvarchar(32) | nvarchar(20) |
| EMResume | CreateUser | nvarchar(32) | nvarchar(20) |
| EMResume | ModUser | nvarchar(32) | nvarchar(20) |
| EMSkills | CreateUser | nvarchar(32) | nvarchar(20) |
| EMSkills | ModUser | nvarchar(32) | nvarchar(20) |
| EMSubscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| EMTKGroups | CreateUser | nvarchar(32) | nvarchar(20) |
| EMTKGroups | ModUser | nvarchar(32) | nvarchar(20) |
| EQICBooks | CreateUser | nvarchar(32) | nvarchar(20) |
| EQICBooks | ModUser | nvarchar(32) | nvarchar(20) |
| EQICCost | CreateUser | nvarchar(32) | nvarchar(20) |
| EQICCost | ModUser | nvarchar(32) | nvarchar(20) |
| EQICEMAssoc | CreateUser | nvarchar(32) | nvarchar(20) |
| EQICEMAssoc | ModUser | nvarchar(32) | nvarchar(20) |
| Equipment | CreateUser | nvarchar(32) | nvarchar(20) |
| Equipment | ModUser | nvarchar(32) | nvarchar(20) |
| EquipmentCustomTabFields | CreateUser | nvarchar(32) | nvarchar(20) |
| EquipmentCustomTabFields | ModUser | nvarchar(32) | nvarchar(20) |
| EquipmentFileLinks | CreateUser | nvarchar(32) | nvarchar(20) |
| EquipmentFileLinks | ModUser | nvarchar(32) | nvarchar(20) |
| EquipmentSubscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| erControl | Creator | nvarchar(32) | nvarchar(20) |
| erMaster | ModUser | nvarchar(32) | nvarchar(20) |
| exControl | Creator | nvarchar(32) | nvarchar(20) |
| exMaster | ModUser | nvarchar(32) | nvarchar(20) |
| ExportFiles | CreateUser | nvarchar(32) | nvarchar(20) |
| Firm | CreateUser | nvarchar(32) | nvarchar(20) |
| Firm | ModUser | nvarchar(32) | nvarchar(20) |
| FirmDisciplinesSF330 | CreateUser | nvarchar(32) | nvarchar(20) |
| FirmDisciplinesSF330 | ModUser | nvarchar(32) | nvarchar(20) |
| FirmFormerParent | CreateUser | nvarchar(32) | nvarchar(20) |
| FirmFormerParent | ModUser | nvarchar(32) | nvarchar(20) |
| FirmOrgAssociations | CreateUser | nvarchar(32) | nvarchar(20) |
| FirmOrgAssociations | ModUser | nvarchar(32) | nvarchar(20) |
| FirmProjectCodesSF330 | CreateUser | nvarchar(32) | nvarchar(20) |
| FirmProjectCodesSF330 | ModUser | nvarchar(32) | nvarchar(20) |
| FirmServiceFees | CreateUser | nvarchar(32) | nvarchar(20) |
| FirmServiceFees | ModUser | nvarchar(32) | nvarchar(20) |
| FW_Attachments | CreateUser | nvarchar(32) | nvarchar(20) |
| FW_Attachments | ModUser | nvarchar(32) | nvarchar(20) |
| FW_CFGProcessQueue | CreateUser | nvarchar(32) | nvarchar(20) |
| FW_CFGProcessQueue | ModUser | nvarchar(32) | nvarchar(20) |
| FW_CFGProcessQueueSetup | CreateUser | nvarchar(32) | nvarchar(20) |
| FW_CFGProcessQueueSetup | ModUser | nvarchar(32) | nvarchar(20) |
| FW_CFGUserSettingsData | CreateUser | nvarchar(32) | nvarchar(20) |
| FW_CFGUserSettingsData | ModUser | nvarchar(32) | nvarchar(20) |
| FW_CustomColumnValuesData | CreateUser | nvarchar(32) | nvarchar(20) |
| FW_CustomColumnValuesData | ModUser | nvarchar(32) | nvarchar(20) |
| FW_Dashboard | CreateUser | nvarchar(32) | nvarchar(20) |
| FW_Dashboard | ModUser | nvarchar(32) | nvarchar(20) |
| FW_DashPart | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| FW_DashPartAppLinks | Username | nvarchar(32) | nvarchar(20) |
| FW_DashPartLinks | Username | nvarchar(32) | nvarchar(20) |
| FW_DashPartLookupOptions | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| FW_DetailProfiles | CreateUser | nvarchar(32) | nvarchar(20) |
| FW_DetailProfiles | ModUser | nvarchar(32) | nvarchar(20) |
| FW_Dictionary | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| FW_Files | CreateUser | nvarchar(32) | nvarchar(20) |
| FW_Files | ModUser | nvarchar(32) | nvarchar(20) |
| FW_LookupOptions | CreateUser | nvarchar(32) | nvarchar(20) |
| FW_LookupOptions | ModUser | nvarchar(32) | nvarchar(20) |
| FW_LookupOptions | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| FW_MasterJobs | Submitter | nvarchar(32) | nvarchar(20) |
| FW_MasterProfiles | CreateUser | nvarchar(32) | nvarchar(20) |
| FW_MasterProfiles | ModUser | nvarchar(32) | nvarchar(20) |
| FW_MasterProfiles | Submitter | nvarchar(32) | nvarchar(20) |
| FW_ReportCustomColumns | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| FW_ReportFavorites | CreateUser | nvarchar(32) | nvarchar(20) |
| FW_ReportFavorites | ModUser | nvarchar(32) | nvarchar(20) |
| FW_ReportFavorites | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| FW_ReportOptions | CreateUser | nvarchar(32) | nvarchar(20) |
| FW_ReportOptions | ModUser | nvarchar(32) | nvarchar(20) |
| FW_ReportOptions | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| FW_ReportSubscr | DashUserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| FW_ReportSubscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| FW_SEUserOptions | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| FW_UserActivity | UserID | nvarchar(32) | nvarchar(20) |
| FW_Workbook | ViewName | nvarchar(200) | nvarchar(200) NOT NULL |
| GRSkills | CreateUser | nvarchar(32) | nvarchar(20) |
| GRSkills | ModUser | nvarchar(32) | nvarchar(20) |
| ImportDetail | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| ImportMaster | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| inControl | Creator | nvarchar(32) | nvarchar(20) |
| inMaster | ModUser | nvarchar(32) | nvarchar(20) |
| IntegrationLog | CallUser | nvarchar(32) | nvarchar(20) |
| IntegrationWSLog | Submitter | nvarchar(32) | nvarchar(20) |
| InvMaster | CreateUser | nvarchar(32) | nvarchar(20) |
| InvMaster | PerformedBy | nvarchar(32) | nvarchar(20) |
| ItemRequestMaster | CreateUser | nvarchar(32) | nvarchar(20) |
| ItemRequestMaster | ModUser | nvarchar(32) | nvarchar(20) |
| jeControl | Creator | nvarchar(32) | nvarchar(20) |
| jeMaster | ModUser | nvarchar(32) | nvarchar(20) |
| laControl | Creator | nvarchar(32) | nvarchar(20) |
| laMaster | ModUser | nvarchar(32) | nvarchar(20) |
| LD | ModUser | nvarchar(32) | nvarchar(20) |
| LedgerAP | ModUser | nvarchar(32) | nvarchar(20) |
| LedgerAR | ModUser | nvarchar(32) | nvarchar(20) |
| LedgerEX | ModUser | nvarchar(32) | nvarchar(20) |
| LedgerMisc | ModUser | nvarchar(32) | nvarchar(20) |
| MergeFavorites | CreateUser | nvarchar(32) | nvarchar(20) |
| MergeFavorites | ModUser | nvarchar(32) | nvarchar(20) |
| MergeFavorites | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| MergeTemplates | CreateUser | nvarchar(32) | nvarchar(20) |
| MergeTemplates | ModUser | nvarchar(32) | nvarchar(20) |
| miControl | Creator | nvarchar(32) | nvarchar(20) |
| miMaster | ModUser | nvarchar(32) | nvarchar(20) |
| MktCampaign | CreateUser | nvarchar(32) | nvarchar(20) |
| MktCampaign | ModUser | nvarchar(32) | nvarchar(20) |
| MktCampaignClientAssoc | CreateUser | nvarchar(32) | nvarchar(20) |
| MktCampaignClientAssoc | ModUser | nvarchar(32) | nvarchar(20) |
| MktCampaignContactAssoc | CreateUser | nvarchar(32) | nvarchar(20) |
| MktCampaignContactAssoc | ModUser | nvarchar(32) | nvarchar(20) |
| MktCampaignCustomTabFields | CreateUser | nvarchar(32) | nvarchar(20) |
| MktCampaignCustomTabFields | ModUser | nvarchar(32) | nvarchar(20) |
| MktCampaignFileLinks | CreateUser | nvarchar(32) | nvarchar(20) |
| MktCampaignFileLinks | ModUser | nvarchar(32) | nvarchar(20) |
| MktCampaignLeads | CreateUser | nvarchar(32) | nvarchar(20) |
| MktCampaignLeads | ModUser | nvarchar(32) | nvarchar(20) |
| MktCampaignPhoto | CreateUser | nvarchar(32) | nvarchar(20) |
| MktCampaignPhoto | ModUser | nvarchar(32) | nvarchar(20) |
| MktCampaignProjectAssoc | CreateUser | nvarchar(32) | nvarchar(20) |
| MktCampaignProjectAssoc | ModUser | nvarchar(32) | nvarchar(20) |
| MktCampaignProjectAssocTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| MktCampaignProjectAssocTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| MktCampaignSubscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| NavigatorSearchCriteria | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| NavigatorUserSettings | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| Organization | CreateUser | nvarchar(32) | nvarchar(20) |
| Organization | ModUser | nvarchar(32) | nvarchar(20) |
| PlanningCustomTabFields | CreateUser | nvarchar(32) | nvarchar(20) |
| PlanningCustomTabFields | ModUser | nvarchar(32) | nvarchar(20) |
| PNAccordionFormat | CreateUser | nvarchar(42) | nvarchar(30) |
| PNAccordionFormat | ModUser | nvarchar(42) | nvarchar(30) |
| PNAssignment | CreateUser | nvarchar(42) | nvarchar(30) |
| PNAssignment | ModUser | nvarchar(42) | nvarchar(30) |
| PNBaselineConsultant | CreateUser | nvarchar(42) | nvarchar(30) |
| PNBaselineConsultant | ModUser | nvarchar(42) | nvarchar(30) |
| PNBaselineExpenses | CreateUser | nvarchar(42) | nvarchar(30) |
| PNBaselineExpenses | ModUser | nvarchar(42) | nvarchar(30) |
| PNBaselineLabor | CreateUser | nvarchar(42) | nvarchar(30) |
| PNBaselineLabor | ModUser | nvarchar(42) | nvarchar(30) |
| PNCalendarInterval | CreateUser | nvarchar(42) | nvarchar(30) |
| PNCalendarInterval | ModUser | nvarchar(42) | nvarchar(30) |
| PNConsultant | CreateUser | nvarchar(42) | nvarchar(30) |
| PNConsultant | ModUser | nvarchar(42) | nvarchar(30) |
| PNExpense | CreateUser | nvarchar(42) | nvarchar(30) |
| PNExpense | ModUser | nvarchar(42) | nvarchar(30) |
| PNPlan | CheckedOutUser | nvarchar(32) | nvarchar(20) |
| PNPlan | CreateUser | nvarchar(42) | nvarchar(30) |
| PNPlan | ModUser | nvarchar(42) | nvarchar(30) |
| PNPlannedConsultant | CreateUser | nvarchar(42) | nvarchar(30) |
| PNPlannedConsultant | ModUser | nvarchar(42) | nvarchar(30) |
| PNPlannedExpenses | CreateUser | nvarchar(42) | nvarchar(30) |
| PNPlannedExpenses | ModUser | nvarchar(42) | nvarchar(30) |
| PNPlannedLabor | CreateUser | nvarchar(42) | nvarchar(30) |
| PNPlannedLabor | ModUser | nvarchar(42) | nvarchar(30) |
| PNTask | CreateUser | nvarchar(42) | nvarchar(30) |
| PNTask | ModUser | nvarchar(42) | nvarchar(30) |
| PNWBSLevelFormat | CreateUser | nvarchar(42) | nvarchar(30) |
| PNWBSLevelFormat | ModUser | nvarchar(42) | nvarchar(30) |
| POCOMaster | CreateUser | nvarchar(32) | nvarchar(20) |
| POCOMaster | ModUser | nvarchar(32) | nvarchar(20) |
| POFinalPrint | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| POMaster | CreateUser | nvarchar(32) | nvarchar(20) |
| POMaster | ModUser | nvarchar(32) | nvarchar(20) |
| POPQMaster | CreateUser | nvarchar(32) | nvarchar(20) |
| POPQMaster | ModUser | nvarchar(32) | nvarchar(20) |
| POPQVendorDetail | Response01ModUser | nvarchar(32) | nvarchar(20) |
| POPQVendorDetail | Response02ModUser | nvarchar(32) | nvarchar(20) |
| POPQVendorDetail | Response03ModUser | nvarchar(32) | nvarchar(20) |
| POPQVendorDetail | Response04ModUser | nvarchar(32) | nvarchar(20) |
| POPQVendorDetail | Response05ModUser | nvarchar(32) | nvarchar(20) |
| POPQVendorDetail | Response06ModUser | nvarchar(32) | nvarchar(20) |
| POPQVendorDetail | Response07ModUser | nvarchar(32) | nvarchar(20) |
| POPQVendorDetail | Response08ModUser | nvarchar(32) | nvarchar(20) |
| POPQVendorDetail | Response09ModUser | nvarchar(32) | nvarchar(20) |
| POPQVendorDetail | Response10ModUser | nvarchar(32) | nvarchar(20) |
| POPRMaster | CreateUser | nvarchar(32) | nvarchar(20) |
| POPRMaster | ModUser | nvarchar(32) | nvarchar(20) |
| POPRVendorDetail | Response01ModUser | nvarchar(32) | nvarchar(20) |
| POPRVendorDetail | Response02ModUser | nvarchar(32) | nvarchar(20) |
| POPRVendorDetail | Response03ModUser | nvarchar(32) | nvarchar(20) |
| POPRVendorDetail | Response04ModUser | nvarchar(32) | nvarchar(20) |
| POPRVendorDetail | Response05ModUser | nvarchar(32) | nvarchar(20) |
| POPRVendorDetail | Response06ModUser | nvarchar(32) | nvarchar(20) |
| POPRVendorDetail | Response07ModUser | nvarchar(32) | nvarchar(20) |
| POPRVendorDetail | Response08ModUser | nvarchar(32) | nvarchar(20) |
| POPRVendorDetail | Response09ModUser | nvarchar(32) | nvarchar(20) |
| POPRVendorDetail | Response10ModUser | nvarchar(32) | nvarchar(20) |
| PR | CreateUser | nvarchar(32) | nvarchar(20) |
| PR | ModUser | nvarchar(32) | nvarchar(20) |
| PRAdditionalData | CreateUser | nvarchar(32) | nvarchar(20) |
| PRAdditionalData | ModUser | nvarchar(32) | nvarchar(20) |
| PRAwards | CreateUser | nvarchar(32) | nvarchar(20) |
| PRAwards | ModUser | nvarchar(32) | nvarchar(20) |
| PRAwardsTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| PRAwardsTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| PRChargeCompanies | CreateUser | nvarchar(32) | nvarchar(20) |
| PRChargeCompanies | ModUser | nvarchar(32) | nvarchar(20) |
| PRChargeCompaniesTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| PRChargeCompaniesTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| PRConsultant | CreateUser | nvarchar(32) | nvarchar(20) |
| PRConsultant | ModUser | nvarchar(32) | nvarchar(20) |
| PRConsultantTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| PRConsultantTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| PRContactAssoc | CreateUser | nvarchar(32) | nvarchar(20) |
| PRContactAssoc | ModUser | nvarchar(32) | nvarchar(20) |
| PRContactAssocTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| PRContactAssocTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| prControl | Creator | nvarchar(32) | nvarchar(20) |
| PRDefaults | CreateUser | nvarchar(32) | nvarchar(20) |
| PRDefaults | ModUser | nvarchar(32) | nvarchar(20) |
| PRDescriptions | CreateUser | nvarchar(32) | nvarchar(20) |
| PRDescriptions | ModUser | nvarchar(32) | nvarchar(20) |
| PRDescriptionsTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| PRDescriptionsTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| PRExpense | CreateUser | nvarchar(32) | nvarchar(20) |
| PRExpense | ModUser | nvarchar(32) | nvarchar(20) |
| PRExpenseTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| PRExpenseTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| PRFileLinks | CreateUser | nvarchar(32) | nvarchar(20) |
| PRFileLinks | ModUser | nvarchar(32) | nvarchar(20) |
| PRLabor | CreateUser | nvarchar(32) | nvarchar(20) |
| PRLabor | ModUser | nvarchar(32) | nvarchar(20) |
| PRLaborTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| PRLaborTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| prMaster | ModUser | nvarchar(32) | nvarchar(20) |
| PRMilestone | CreateUser | nvarchar(32) | nvarchar(20) |
| PRMilestone | ModUser | nvarchar(32) | nvarchar(20) |
| PRMilestoneTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| PRMilestoneTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| ProjectCustomTabFields | CreateUser | nvarchar(32) | nvarchar(20) |
| ProjectCustomTabFields | ModUser | nvarchar(32) | nvarchar(20) |
| ProjectCustomTabFieldsTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| ProjectCustomTabFieldsTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| ProjectFromContacts | CreateUser | nvarchar(32) | nvarchar(20) |
| ProjectFromContacts | ModUser | nvarchar(32) | nvarchar(20) |
| PRProjectCodes | CreateUser | nvarchar(32) | nvarchar(20) |
| PRProjectCodes | ModUser | nvarchar(32) | nvarchar(20) |
| PRProjectCodesTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| PRProjectCodesTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| PRProposals | CreateUser | nvarchar(32) | nvarchar(20) |
| PRProposals | ModUser | nvarchar(32) | nvarchar(20) |
| PRProposalsTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| PRProposalsTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| PRRevenue | CreateUser | nvarchar(32) | nvarchar(20) |
| PRRevenue | ModUser | nvarchar(32) | nvarchar(20) |
| PRRevenue | PercentRevenue | decimal(19,4) NOT NULL default (0) | smallint NOT NULL default (0) |
| PRRevenueTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| PRRevenueTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| PRRevenueTemplate | PercentRevenue | decimal(19,4) NOT NULL default (0) | smallint NOT NULL default (0) |
| PRSubscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| PRSummaryMain | ModUser | nvarchar(32) | nvarchar(20) |
| PRSummarySub | ModUser | nvarchar(32) | nvarchar(20) |
| PRTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| PRTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| PRUnit | CreateUser | nvarchar(32) | nvarchar(20) |
| PRUnit | ModUser | nvarchar(32) | nvarchar(20) |
| PRUnitTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| PRUnitTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| ReceiveMaster | CreateUser | nvarchar(32) | nvarchar(20) |
| ReceiveMaster | ModUser | nvarchar(32) | nvarchar(20) |
| RecurrActivityException | CreateUser | nvarchar(32) | nvarchar(20) |
| RecurrActivityException | ModUser | nvarchar(32) | nvarchar(20) |
| ReportEmpty | UserName | nvarchar(32) | nvarchar(20) |
| ReportSubscr | DashUserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| ReportSubscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| ResumeByQueryDefaultFormatSetting | UserID | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| ResumeByQueryFormatting | CreateUser | nvarchar(32) | nvarchar(20) |
| ResumeByQueryFormatting | ModUser | nvarchar(32) | nvarchar(20) |
| RPAccordionFormat | CreateUser | nvarchar(42) | nvarchar(30) |
| RPAccordionFormat | ModUser | nvarchar(42) | nvarchar(30) |
| RPAssignment | CreateUser | nvarchar(42) | nvarchar(30) |
| RPAssignment | ModUser | nvarchar(42) | nvarchar(30) |
| RPBaselineConsultant | CreateUser | nvarchar(42) | nvarchar(30) |
| RPBaselineConsultant | ModUser | nvarchar(42) | nvarchar(30) |
| RPBaselineExpenses | CreateUser | nvarchar(42) | nvarchar(30) |
| RPBaselineExpenses | ModUser | nvarchar(42) | nvarchar(30) |
| RPBaselineLabor | CreateUser | nvarchar(42) | nvarchar(30) |
| RPBaselineLabor | ModUser | nvarchar(42) | nvarchar(30) |
| RPBaselineRevenue | CreateUser | nvarchar(42) | nvarchar(30) |
| RPBaselineRevenue | ModUser | nvarchar(42) | nvarchar(30) |
| RPBaselineUnit | CreateUser | nvarchar(42) | nvarchar(30) |
| RPBaselineUnit | ModUser | nvarchar(42) | nvarchar(30) |
| RPCalendarInterval | CreateUser | nvarchar(42) | nvarchar(30) |
| RPCalendarInterval | ModUser | nvarchar(42) | nvarchar(30) |
| RPCompensationFee | CreateUser | nvarchar(42) | nvarchar(30) |
| RPCompensationFee | ModUser | nvarchar(42) | nvarchar(30) |
| RPConsultant | CreateUser | nvarchar(42) | nvarchar(30) |
| RPConsultant | ModUser | nvarchar(42) | nvarchar(30) |
| RPConsultantFee | CreateUser | nvarchar(42) | nvarchar(30) |
| RPConsultantFee | ModUser | nvarchar(42) | nvarchar(30) |
| RPDependency | CreateUser | nvarchar(42) | nvarchar(30) |
| RPDependency | ModUser | nvarchar(42) | nvarchar(30) |
| RPEVT | CreateUser | nvarchar(42) | nvarchar(30) |
| RPEVT | ModUser | nvarchar(42) | nvarchar(30) |
| RPExpense | CreateUser | nvarchar(42) | nvarchar(30) |
| RPExpense | ModUser | nvarchar(42) | nvarchar(30) |
| RPGrd | CreateUser | nvarchar(42) | nvarchar(30) |
| RPGrd | ModUser | nvarchar(42) | nvarchar(30) |
| RPGrd | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| RPGrdCol | CreateUser | nvarchar(42) | nvarchar(30) |
| RPGrdCol | ModUser | nvarchar(42) | nvarchar(30) |
| RPGrdCol | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| RPGrdRow | CreateUser | nvarchar(42) | nvarchar(30) |
| RPGrdRow | ModUser | nvarchar(42) | nvarchar(30) |
| RPGrdRow | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| RPGridCell | CreateUser | nvarchar(42) | nvarchar(30) |
| RPGridCell | ModUser | nvarchar(42) | nvarchar(30) |
| RPGridCfg | CreateUser | nvarchar(42) | nvarchar(30) |
| RPGridCfg | ModUser | nvarchar(42) | nvarchar(30) |
| RPJTDConsultant | CreateUser | nvarchar(42) | nvarchar(30) |
| RPJTDConsultant | ModUser | nvarchar(42) | nvarchar(30) |
| RPJTDExpenses | CreateUser | nvarchar(42) | nvarchar(30) |
| RPJTDExpenses | ModUser | nvarchar(42) | nvarchar(30) |
| RPJTDLabor | CreateUser | nvarchar(42) | nvarchar(30) |
| RPJTDLabor | ModUser | nvarchar(42) | nvarchar(30) |
| RPJTDUnit | CreateUser | nvarchar(42) | nvarchar(30) |
| RPJTDUnit | ModUser | nvarchar(42) | nvarchar(30) |
| RPPlan | CheckedOutUser | nvarchar(32) | nvarchar(20) |
| RPPlan | CreateUser | nvarchar(42) | nvarchar(30) |
| RPPlan | ModUser | nvarchar(42) | nvarchar(30) |
| RPPlannedConsultant | CreateUser | nvarchar(42) | nvarchar(30) |
| RPPlannedConsultant | ModUser | nvarchar(42) | nvarchar(30) |
| RPPlannedExpenses | CreateUser | nvarchar(42) | nvarchar(30) |
| RPPlannedExpenses | ModUser | nvarchar(42) | nvarchar(30) |
| RPPlannedLabor | CreateUser | nvarchar(42) | nvarchar(30) |
| RPPlannedLabor | ModUser | nvarchar(42) | nvarchar(30) |
| RPPlannedUnit | CreateUser | nvarchar(42) | nvarchar(30) |
| RPPlannedUnit | ModUser | nvarchar(42) | nvarchar(30) |
| RPPlanSubscr | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| RPReimbAllowance | CreateUser | nvarchar(42) | nvarchar(30) |
| RPReimbAllowance | ModUser | nvarchar(42) | nvarchar(30) |
| RPTask | CreateUser | nvarchar(42) | nvarchar(30) |
| RPTask | ModUser | nvarchar(42) | nvarchar(30) |
| RPUnit | CreateUser | nvarchar(42) | nvarchar(30) |
| RPUnit | ModUser | nvarchar(42) | nvarchar(30) |
| RPWBSLevelFormat | CreateUser | nvarchar(42) | nvarchar(30) |
| RPWBSLevelFormat | ModUser | nvarchar(42) | nvarchar(30) |
| SavedOptionsDetail | CreateUser | nvarchar(32) | nvarchar(20) |
| SavedOptionsDetail | ModUser | nvarchar(32) | nvarchar(20) |
| SavedReportsMain | CreateUser | nvarchar(32) | nvarchar(20) |
| SavedReportsMain | ModUser | nvarchar(32) | nvarchar(20) |
| SavedReportsMain | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| SavedSelectionsMain | CreateUser | nvarchar(32) | nvarchar(20) |
| SavedSelectionsMain | ModUser | nvarchar(32) | nvarchar(20) |
| SavedSelectionsMain | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| savedVisualizations | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| SE | CreateUser | nvarchar(32) | nvarchar(20) |
| SE | ModUser | nvarchar(32) | nvarchar(20) |
| SECalendar | AccessUser | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| SECalendar | PrimaryUser | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| SECompany | CreateUser | nvarchar(32) | nvarchar(20) |
| SECompany | ModUser | nvarchar(32) | nvarchar(20) |
| SEDashParts | CreateUser | nvarchar(32) | nvarchar(20) |
| SEDashParts | ModUser | nvarchar(32) | nvarchar(20) |
| SEEmailTemplates | CreateUser | nvarchar(32) | nvarchar(20) |
| SEEmailTemplates | ModUser | nvarchar(32) | nvarchar(20) |
| SEFavorite | CreateUser | nvarchar(32) | nvarchar(20) |
| SEFavorite | ModUser | nvarchar(32) | nvarchar(20) |
| SEField | CreateUser | nvarchar(32) | nvarchar(20) |
| SEField | ModUser | nvarchar(32) | nvarchar(20) |
| SEInfoCenter | CreateUser | nvarchar(32) | nvarchar(20) |
| SEInfoCenter | ModUser | nvarchar(32) | nvarchar(20) |
| SELookupFields | CreateUser | nvarchar(32) | nvarchar(20) |
| SELookupFields | ModUser | nvarchar(32) | nvarchar(20) |
| SEMergeTemplate | CreateUser | nvarchar(32) | nvarchar(20) |
| SEMergeTemplate | ModUser | nvarchar(32) | nvarchar(20) |
| SENavTree | CreateUser | nvarchar(32) | nvarchar(20) |
| SENavTree | ModUser | nvarchar(32) | nvarchar(20) |
| SEPrinters | CreateUser | nvarchar(32) | nvarchar(20) |
| SEPrinters | ModUser | nvarchar(32) | nvarchar(20) |
| SEReport | CreateUser | nvarchar(32) | nvarchar(20) |
| SEReport | ModUser | nvarchar(32) | nvarchar(20) |
| SEReportColumns | CreateUser | nvarchar(32) | nvarchar(20) |
| SEReportColumns | ModUser | nvarchar(32) | nvarchar(20) |
| SEReportGroups | CreateUser | nvarchar(32) | nvarchar(20) |
| SEReportGroups | ModUser | nvarchar(32) | nvarchar(20) |
| SEReportOptions | CreateUser | nvarchar(32) | nvarchar(20) |
| SEReportOptions | ModUser | nvarchar(32) | nvarchar(20) |
| SESearches | CreateUser | nvarchar(32) | nvarchar(20) |
| SESearches | ModUser | nvarchar(32) | nvarchar(20) |
| SESystemDashParts | CreateUser | nvarchar(32) | nvarchar(20) |
| SESystemDashParts | ModUser | nvarchar(32) | nvarchar(20) |
| SETab | CreateUser | nvarchar(32) | nvarchar(20) |
| SETab | ModUser | nvarchar(32) | nvarchar(20) |
| SETransTypes | CreateUser | nvarchar(32) | nvarchar(20) |
| SETransTypes | ModUser | nvarchar(32) | nvarchar(20) |
| SEURLDashParts | CreateUser | nvarchar(32) | nvarchar(20) |
| SEURLDashParts | ModUser | nvarchar(32) | nvarchar(20) |
| SEUser | CreateUser | nvarchar(32) | nvarchar(20) |
| SEUser | ModUser | nvarchar(32) | nvarchar(20) |
| SEUser | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| SEUserMyFavs | Username | nvarchar(32) | nvarchar(20) |
| SEUserMyLinks | Username | nvarchar(32) | nvarchar(20) |
| SEUserPasswordHistory | Username | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| SEWSSLists | CreateUser | nvarchar(32) | nvarchar(20) |
| SEWSSLists | ModUser | nvarchar(32) | nvarchar(20) |
| SEWSSSiteDefault | CreateUser | nvarchar(32) | nvarchar(20) |
| SEWSSSiteDefault | ModUser | nvarchar(32) | nvarchar(20) |
| SF254 | CreateUser | nvarchar(32) | nvarchar(20) |
| SF254 | ModUser | nvarchar(32) | nvarchar(20) |
| SF254Subscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| SF254Template | CreateUser | nvarchar(32) | nvarchar(20) |
| SF254Template | ModUser | nvarchar(32) | nvarchar(20) |
| SF254TemplateFiles | CreateUser | nvarchar(32) | nvarchar(20) |
| SF254TemplateFiles | ModUser | nvarchar(32) | nvarchar(20) |
| SF255 | CreateUser | nvarchar(32) | nvarchar(20) |
| SF255 | ModUser | nvarchar(32) | nvarchar(20) |
| SF255Consultant | CreateUser | nvarchar(32) | nvarchar(20) |
| SF255Consultant | ModUser | nvarchar(32) | nvarchar(20) |
| SF255EmployeeGraphics | CreateUser | nvarchar(32) | nvarchar(20) |
| SF255EmployeeGraphics | ModUser | nvarchar(32) | nvarchar(20) |
| SF255Employees | CreateUser | nvarchar(32) | nvarchar(20) |
| SF255Employees | ModUser | nvarchar(32) | nvarchar(20) |
| SF255ProjectGraphics | CreateUser | nvarchar(32) | nvarchar(20) |
| SF255ProjectGraphics | ModUser | nvarchar(32) | nvarchar(20) |
| SF255Subscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| SF255Template | CreateUser | nvarchar(32) | nvarchar(20) |
| SF255Template | ModUser | nvarchar(32) | nvarchar(20) |
| SF255TemplateFiles | CreateUser | nvarchar(32) | nvarchar(20) |
| SF255TemplateFiles | ModUser | nvarchar(32) | nvarchar(20) |
| SF330 | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330 | ModUser | nvarchar(32) | nvarchar(20) |
| SF330FirmEmployeeDiscipline | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330FirmEmployeeDiscipline | ModUser | nvarchar(32) | nvarchar(20) |
| SF330FirmProfile | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330FirmProfile | ModUser | nvarchar(32) | nvarchar(20) |
| SF330FirmsPart2 | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330FirmsPart2 | ModUser | nvarchar(32) | nvarchar(20) |
| SF330Personnel | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330Personnel | ModUser | nvarchar(32) | nvarchar(20) |
| SF330PersonnelMatrix | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330PersonnelMatrix | ModUser | nvarchar(32) | nvarchar(20) |
| SF330PersonnelProjectMatrix | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330PersonnelProjectMatrix | ModUser | nvarchar(32) | nvarchar(20) |
| SF330PersonnelProjects | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330PersonnelProjects | ModUser | nvarchar(32) | nvarchar(20) |
| SF330Preferences | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330Preferences | ModUser | nvarchar(32) | nvarchar(20) |
| SF330Preferences | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| SF330ProjectFirms | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330ProjectFirms | ModUser | nvarchar(32) | nvarchar(20) |
| SF330ProjectGraphics | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330ProjectGraphics | ModUser | nvarchar(32) | nvarchar(20) |
| SF330Projects | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330Projects | ModUser | nvarchar(32) | nvarchar(20) |
| SF330ProposedFirms | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330ProposedFirms | ModUser | nvarchar(32) | nvarchar(20) |
| SF330Subscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| SF330Template | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330Template | ModUser | nvarchar(32) | nvarchar(20) |
| SF330TemplateFiles | CreateUser | nvarchar(32) | nvarchar(20) |
| SF330TemplateFiles | ModUser | nvarchar(32) | nvarchar(20) |
| SyncLog | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| TextLibFileLinks | CreateUser | nvarchar(32) | nvarchar(20) |
| TextLibFileLinks | ModUser | nvarchar(32) | nvarchar(20) |
| TextLibFileLinks | Name | varchar(32) NOT NULL | nvarchar(50) NOT NULL |
| TextLibrary | CreateUser | nvarchar(32) | nvarchar(20) |
| TextLibrary | ModUser | nvarchar(32) | nvarchar(20) |
| TextLibrary | Name | varchar(32) NOT NULL | nvarchar(50) NOT NULL |
| TextLibraryCustomTabFields | CreateUser | nvarchar(32) | nvarchar(20) |
| TextLibraryCustomTabFields | ModUser | nvarchar(32) | nvarchar(20) |
| TextLibraryCustomTabFields | Name | varchar(32) NOT NULL | nvarchar(50) NOT NULL |
| tkMaster | CreateUser | nvarchar(32) | nvarchar(20) |
| tkMaster | ModUser | nvarchar(32) | nvarchar(20) |
| tkRevisionMaster | ModUser | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| tsControl | Creator | nvarchar(32) | nvarchar(20) |
| tsMaster | ModUser | nvarchar(32) | nvarchar(20) |
| UDICSubscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| unControl | Creator | nvarchar(32) | nvarchar(20) |
| UnitCustomTabFields | CreateUser | nvarchar(32) | nvarchar(20) |
| UnitCustomTabFields | ModUser | nvarchar(32) | nvarchar(20) |
| unMaster | ModUser | nvarchar(32) | nvarchar(20) |
| UNTable | CreateUser | nvarchar(32) | nvarchar(20) |
| UNTable | ModUser | nvarchar(32) | nvarchar(20) |
| UNUnit | CreateUser | nvarchar(32) | nvarchar(20) |
| UNUnit | ModUser | nvarchar(32) | nvarchar(20) |
| upControl | Creator | nvarchar(32) | nvarchar(20) |
| upMaster | ModUser | nvarchar(32) | nvarchar(20) |
| VEAccounting | CreateUser | nvarchar(32) | nvarchar(20) |
| VEAccounting | ModUser | nvarchar(32) | nvarchar(20) |
| VESubscr | UserName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| visualizationSavedSettings | userName | nvarchar(32) NOT NULL | nvarchar(20) NOT NULL |
| VO | PaymentCurrencyCodeModUser | nvarchar(32) | nvarchar(20) |
| WorkflowActivity | CreateUser | nvarchar(32) | nvarchar(20) |
| WorkflowActivity | ModUser | nvarchar(32) | nvarchar(20) |
| WorkflowActivityCustomTabFields | CreateUser | nvarchar(32) | nvarchar(20) |
| WorkflowActivityCustomTabFields | ModUser | nvarchar(32) | nvarchar(20) |
| WorkflowLog | WorkflowUser | nvarchar(32) | nvarchar(20) |
|
Table Name |
Column Name |
DataType |
| EMCompany | Class | nvarchar(20) |
| EMCompany | Class | nvarchar(20) |
| EMCompany | ExitInterviewer | nvarchar(20) |
| EMCompany | FLSAStatus | nvarchar(100) |
| EMCompany | JobLevel | nvarchar(10) |
| EMCompany | LastDayPaid | datetime |
| EMCompany | LastDayWorked | datetime |
| EMCompany | RehireDate | datetime |
| EMCompany | RehireEligible | varchar(1) |
| EMCompany | SeniorityDate | datetime |
| EMCompany | SOCCode | nvarchar(10) |
| EMCompany | TaxRegistrationCountry | nvarchar(2) |
| EMCompany | TerminationReason | nvarchar(255) |
| EMCompany | TerminationType | nvarchar(100) |
| EMCompany | WorkSchedule | nvarchar(100) |
| EMMain | ADA | varchar(1) NOT NULL default ('N') |
| EMMain | AlienNumber | nvarchar(40) |
| EMMain | BirthDate | datetime |
| EMMain | Disabled | varchar(1) NOT NULL default ('N') |
| EMMain | Ethnicity | nvarchar(10) |
| EMMain | Gender | varchar(1) |
| EMMain | HomeEmail | nvarchar(100) |
| EMMain | I9Verification | varchar(1) |
| EMMain | MailAddress1 | nvarchar(50) |
| EMMain | MailAddress2 | nvarchar(50) |
| EMMain | MailAddress3 | nvarchar(50) |
| EMMain | MailAddressSameAsHome | varchar(1) NOT NULL default ('N') |
| EMMain | MailCity | nvarchar(30) |
| EMMain | MailCountry | nvarchar(2) |
| EMMain | MailState | nvarchar(10) |
| EMMain | MailZIP | nvarchar(10) |
| EMMain | MaritalStatus | varchar(1) |
| EMMain | PassportCountry | nvarchar(2) |
| EMMain | PassportExpDate | datetime |
| EMMain | PassportNumber | nvarchar(40) |
| EMMain | PrimaryContact | nvarchar(100) |
| EMMain | PrimaryContactPhone | nvarchar(24) |
| EMMain | PrimaryContactPhoneFormat | nvarchar(24) |
| EMMain | PrimaryContactRelationship | nvarchar(10) |
| EMMain | SecondaryContact | nvarchar(100) |
| EMMain | SecondaryContactPhone | nvarchar(24) |
| EMMain | SecondaryContactPhoneFormat | nvarchar(24) |
| EMMain | SecondaryContactRelationship | nvarchar(10) |
| EMMain | SeparationDate | datetime |
| EMMain | VetStatus | varchar(1) NOT NULL default ('N') |
| EMMain | VetType | nvarchar(10) |
| EMMain | VisaCountry | nvarchar(2) |
| EMMain | VisaExpDate | datetime |
| EMMain | VisaNumber | nvarchar(40) |
| EMMain | VisaType | nvarchar(10) |
| FW_CFGSystem | WebAPIEnableWorkflow | varchar(1) NOT NULL default ('N') |
| FW_PerfManagement | UseSSL | varchar(1) NOT NULL |
| FW_Workbook | URLName | varchar(200) NOT NULL |
| FW_Workbook | Workbook | varchar(200) NOT NULL |
| FW_WorkbookFilters | Workbook | varchar(200) NOT NULL |
| SE | AllowSOAPAPIAccess | varchar(1) NOT NULL default ('N') |
|
Table Name |
New Column Name |
Old Column Name |
| None | ||
|
Object Name |
Object Type |
| RF$tabFiscalPeriodValidate | Function |
| stRP$CalculateEndDate | Function |
| stRP$tabCalendarStartEndDate | Function |
| stRP$tabGantt | Function |
| stRP$tabHasMissingJTDAssignments | Function |
| stRP$tabLaborCode | Function |
| stRP$tabNeedUpgradeLaborCode | Function |
| stRP$tabPlanningTaskInfo | Function |
| stRP$tabResourceJTDPlans | Function |
| stRP$tabRevenue | Function |
| ClendorClientIDNameParentIDIDX | Index |
| ClendorProjectAssocWBSIDX | Index |
| EKDetailPKeyIDX | Index |
| EKDetailTaxPKeyIDX | Index |
| EKDocumentsDetailPKeyIDX | Index |
| EKDocumentsPKeyIDX | Index |
| EKMasterPKeyIDX | Index |
| FW_UserActivityUserIDIDX | Index |
| PNPlannedRevenueLaborAllIDX | Index |
| PNPlannedRevenuLaborAll2IDX | Index |
| PRBillingClientIDCLBillingAddrBillingContactIDIDX | Index |
| PRClientIDCLAddressContactIDIDX | Index |
| PRNameIDX | Index |
| PRSiblingWBS1IDX | Index |
| RPPlannedRevenueLaborAllIDX | Index |
| RPPlannedRevenuLaborAll2IDX | Index |
| SEUserDisplayUsernameIDX | Index |
| stRPAddMissingJTDAssignments2Plans | Stored Proc |
| stRPMoveAssignment | Stored Proc |
| stRPSpreadPlannedRevenueAmt | Stored Proc |
| UpdateContractDetailSubTotals | Stored Proc |
| FW_CFGDataPack | View |
|
Object Name |
Object Type |
| PROrgRestrictChargeCompaniesIDX | Index |
| PRWBS1IDX | Index |
| AddDefaultFilter | Stored Proc |
| CFGBPEmployeeClass | View |
| CFGHRRelationship | View |
| CFGRace | View |
| CFGVeteran | View |
|
Object Name |
| None |