Database schema: PracticeCS

DBMS: mssql

Version: 3014.0.125

Tables
Accruable_Benefit
Accruable_Benefit_Allowance_By_Month Accruable benefit allowances based on months employed.
Accruable_Benefit_Allowance_By_Staff_Level
Active_Filter This table keeps track of filters used in CommonDropDownList controls.
Activity
Activity_Category
Additional_Contact
Address
Attachment Associates attachments to an item.
Attachment_Content
Bank_Account
Benefit
Benefit_Factor
Billing_Decision
Billing_Decision_Collection This table would be more properly named [Billing_Decision_Application] and "collected" in column names could be replaced with "applied". This table stores rows that indicate how much of a [Billing_Decision] has been closed and what closed it. The main purpose of this is to track payments all the way down to [Sheet_Entry] so we can compute how much was produced, billed and collected for each sheet entry row. Not all rows in this table are really collections, as collections are only the amounts of billing decision rows that are closed by payments. Other sources can close billings, including credit memos, billing adjustments and negative WIP.

([ledger_entry_KEY], [sheet_entry_KEY]) identifies the [Billing_Decision] row this application is closing.

([from__ledger_entry_KEY], [collection_source__ledger_entry_KEY]) identifies the [Ledger_Entry_Application] row by ([from__ledger_entry_KEY], [to__ledger_entry_KEY]) that caused these applications for "Standard" type applications (see below). This can't directly be a relation to [Ledger_Entry_Application] because only standard type applications would have a record in LEA. This may change in the future to always be able to reference a LEA row (the LEA row would be for a zero amount except for standard type records).

([from__ledger_entry_KEY]) identifies the invoice that had applications to Progress Billings that tricked down to applications against progress relief on the invoice [ledger_entry_KEY] represents.

There are three types of Billing_Decision_Collection records:
Standard (user-created):
... from__ledger_entry_KEY == ledger_entry_KEY and from__ledger_entry_KEY <> collection_source__ledger_entry_KEY
Zero Invoice Closing Adjustment:
... from__ledger_entry_KEY == ledger_entry_KEY and from__ledger_entry_KEY == collection_source__ledger_entry_KEY
Progress Relief applications:
... from__ledger_entry_KEY <> ledger_entry_KEY

Standard type applications don't have to track the progress relief to a different invoice so [from__ledger_entry_KEY] == [ledger_entry_KEY].
Billing_Decision_Tax_Collection This table stores the same thing that [Billing_Decision_Collection] does, but for [Billing_Decision_Taxing_Authority] instead of [Billing_Decision].
Billing_Decision_Taxing_Authority
Billing_Rate_Type
COMMON_Metadata_About_Columns
COMMON_Metadata_About_Foreign_Keys
COMMON_Metadata_About_Keys
COMMON_Metadata_About_Sprocs
COMMON_Unique_Identifier_Counter
Calendar_Category Storage for a description and color which is assigned to a schedule entry.
Changeset A changeset is a way to associate a set of record changes with each other and with who, when and where the changes were made. Changeset records should only be inserted or updated by calling the procedures up_Changeset_begin and up_Changeset_end. After insert, records can only be updated while they are active, and only to specify a value for end_date_utc as they are being ended/becoming inactive.
Changeset_Active Between the time that a Changeset has been begun by up_Changeset_begin and ended by up_Changeset_end it is marked as active and associated with a SQL Server transaction by having a record in this table. When Changesets are used as designed there will never be records for them in this table visible outside of the transaction. If the database is changed outside of the application or without properly beginning and ending a changeset, a changeset may be automatically created and will not be ended, so records will be visible in this table for those changesets. It is safe to delete these stranded records from Changeset_Active.
Changeset_Modified_Table When history records are created the changeset that created the history and which table history was created for are recorded in Changeset_Modified_Table.
Client
Client_Date_Cache A denormalized cache of Production, Billing, Invoicing, Collection and Accounts Receivable numbers by Client, Client Family (principal) and date. During normal operation, records are only inserted into this table which results in more than one record with the same client_KEY, principal__client_KEY and entry_date value. This table is maintained entirely by the triggers that contain maintain_client_date_cache in their name.
Client_Financial_Data
Client_Financial_Data_Description Descriptions for Client_Financial_Data values
Client_Shortcut This table is a data store for the Solutions portlets. It contains information about user-configurable solutions (which are paths to files, folders, or web pages).
Client_Shortcut_Group This table is a data store for the Solutions portlets. It contains information about user-configurable groups of solutions (which are paths to files, folders, or web pages).
Client_Staff_Grouping
Client_Status_Event
Contact
Contact_Address
Contact_Category
Contact_Contact_Category
Contact_Email
Contact_Phone
Credit_Card
Credit_Card_Type Tags: read-only

Content:
0NONENoneNONE
1MCMaster CardMC
2VISAVisaVISA
3AMEXAmerican ExpressAMEX
4DISCDiscoverDISC
Custom_Chart
Custom_Field
Custom_Fieldview
Custom_Fieldview_Type
Custom_Formula
Custom_Grouping
Custom_Portlet
Custom_Portlet_Type Tags: read-only

Content:
1Web_Page
2External_News_Feed
3Internal_News_Feed
100Report Based
Custom_Value
Dashboard_Layout
Database_Property
Datasharing_Group
Datasharing_Path
Department Department is a grouping that Staff can be assigned to.
Department_Grouping_Type Tags: read-only

Content:
9981000<ProjectResponsible>'s <Department>Project[KEY(Staff department(Project responsible staff(Project)))]
9992000<ProjectAssigned>'s <Department>Project[KEY(Staff department(Project assigned staff(Project)))]
10003000Specified <Department>
Digit The Digit table holds the values 0 to 9 which makes it convenient to join against for generating ranges.
Tags: read-only

Content:
0
1
2
3
4
5
6
7
8
9
Digita_Vat_Period Digita VAT reporting periods used to associate with VAT Ledger entries.
Education_Accountancy
Education_Accountancy_Category
Education_Accountancy_Type
Education_Credit
Education_Sponsor
Email_Address Holds e-mail addresses to save space and aid in indexing. Each e-mail address must be unique and stored as lower case. It is expected that the e-mail address is a SMTP address and looks similar to "user.name@place.net"
Engagement
Engagement_Template
Engagement_Type
Entity
Event_Class_Type Tags: read-only

Content:
1<Client>
2<Engagement>
3Invoice
4<Project>
5<ProjectTask>
6Timer
7<Interaction>
8<Benefit>
9<Meeting>
10<ToDo>
11<ScheduledPhoneCall>
12<ScheduledBenefit>
13<ScheduleItem>
14<CPECourse>
15LedgerEntry
16SheetEntry
Feed_Channel
Feed_Channel_Item
Feed_Channel_Item_Enclosure
Feed_Channel_Item_Staff_Read
Feed_Portlet
File_Transfer Contains records of File Transfers that have been created on the Portal server
File_Transfer_Event Events that occured during the life cycle of a File Transfer. These can originate from Practice CS or from the Portal web user interface
File_Transfer_File Contains files that are part of a File Transfer
Filter
Filter_Base_Type
Filter_Line
Filter_Line_Type Tags: read-only

Content of first 30 of 190 rows:
1<Staff>Staffstaff_KEY1
2<Staff> TypeStaff_Levelstaff_level_KEY
3<Office>Officeoffice_KEY7
4<Department>Departmentdepartment_KEY
6<Activity>Activityactivity_KEY2
7<Activity> TypeActivity_Methodactivity_method_KEY
8Referral TypeReferral_Typereferral_type_KEY
9Referral SourceReferral_Sourcereferral_source_KEY
10<Client>Clientclient_KEY4
12Industry CodeClientindustry_code
14EntityEntityentity_KEY
15<Engagement>Engagementengagement_KEY5
16DateSheet_Entryentry_date
17<Activity> CategoryActivity_Categoryactivity_category_KEY
18<Activity> ClassActivity_Classactivity_class_KEY
19<Client> TypeClient_Classclient_class_KEY
20<Engagement> TemplateEngagement_Templateengagement_template_KEY
21<Engagement> TypeEngagement_Typeengagement_type_KEY
22Bank AccountBank_Accountbank_account_KEY
23Ledger Entry TypeLedger_Entry_Typeledger_entry_type_KEY
24Recurring BillRecurring_Billrecurring_bill_KEY
25DateSheet_Entrysheet_date
26DateInvoiceinvoice_date
27DateInvoicedue_date
28DateLedger_Entrycontrol_date
29DateLedger_Entryentry_date
30<Project>Projectproject_KEY6
31<Project> TemplateProject_Templateproject_template_KEY
32DateProjectcurrent_due_date
33PriorityPrioritypriority_KEY
Filter_Range_Type Tags: read-only

Content of first 30 of 184 rows:
11IDstaff_id
21Namedescription
33IDoffice_id
43Namedescription
52IDstaff_level_id
62Namedescription
74IDdepartment_id
84Namedescription
96IDactivity_id
106Namedescription
139Descriptiondescription
1410IDclient_id
1510Namedescription
177Namedescription
1817IDactivity_category_id
1917Namedescription
2018Namedescription
2119Namedescription
2516Dateentry_date
2612<IndustryCode>industry_code
2725Datesheet_date
2826Dateinvoice_date
2927Datedue_date
3028Datecontrol_date
3129Dateentry_date
3220IDengagement_template_id
3320Namedescription
3424Namedescription
3514Namedescription
3614IDentity_id
Filter_Select
Filter_Type Tags: read-only

Content of first 30 of 36 rows:
1Staff<Staff>
2Activity<Activity>
3Expense<Expense>
4Client<Client>
5Engagement<Engagement>
6Project<Project>
7Office<Office>
8Sheet_EntryTime & <Expense> Entry
12InvoiceInvoice
13Ledger_EntryReceipt & Adjustment Entry
14Engagement_List<Engagement>
15Statement_SelectionStatement Selection
19Ledger_EntryA/R Entry
20Billing_Decision
22Billing_Worksheet
23Task<ProjectTask>
24Project_Template<Project> Template
25Production_And_Billing_Posted
26Interaction<Interaction>
27Contact<Contact>
29Project_Template_Definition<Project> Template
30Interaction<Interaction>
31Payroll_CheckPayroll Check
32Employee<Employee>
33Billing_Decision_Taxing_Authority
34Integration_Sheet_EntryIntegrated Sheet Entry
35Schedule_Item<ScheduleItem>
37Staff_Benefit<Staff> <Benefit>
38Billing_Decision_CollectionBilling Decision Collection
39Staff_Education_Credit<CPECourse>
Firm
Firm_Dashboard_Layout
Firm_Date
Firm_Date_Type Tags: read-only

Content:
110000Year
210000Period
310000Benefit Year
Firm_Shortcut This table is a data store for the Solutions portlets. It contains information about user-configurable solutions (which are paths to files, folders, or web pages).
Firm_Shortcut_Group This table is a data store for the Solutions portlets. It contains information about user-configurable groups of solutions (which are paths to files, folders, or web pages).
GL_Entry_Export_Option
GL_Entry_Export_Type Tags: read-only

Content:
1Receipts1
2Accounts Receivable1
3Credit Memos1
4Debit Memos-1
5<ServiceCharges>-1
6Write Offs1
7Revenue-1
8<SalesTaxes>-1
9<ServiceTaxes>-1
10Progress Billings-1
11Unapplied Receipts1
Gofileroom_Workflow Stores information about GoFileRoom Workflows. Field lengths match the field lengths defined in GoFileRoom Workflow.
History_Action Tags: read-only

Content:
1Created
2Modified
5Created, Deleted
6Modified, Deleted
8Current
History_Of_Additional_Contact
History_Of_Attachment
History_Of_Attachment_Content
History_Of_Calendar_Category
History_Of_Client
History_Of_Client_Financial_Data
History_Of_Client_Financial_Data_Description
History_Of_Client_Staff_Grouping
History_Of_Contact
History_Of_Contact_Address
History_Of_Contact_Category
History_Of_Contact_Contact_Category
History_Of_Contact_Email
History_Of_Contact_Phone
History_Of_Custom_Chart
History_Of_Custom_Field
History_Of_Custom_Value
History_Of_Digita_Vat_Period
History_Of_Engagement
History_Of_File_Transfer
History_Of_File_Transfer_Event
History_Of_File_Transfer_File
History_Of_Link
History_Of_Link_Group
History_Of_Portal_User
History_Of_Project
History_Of_Project_Extension
History_Of_Schedule_Entry
History_Of_Schedule_Item
History_Of_Schedule_Item_Assignment
History_Of_Schedule_Item_Budget_Remaining_Entry
History_Of_Schedule_Item_Series
History_Of_Sheet_Entry
History_Of_Tag
History_Of_Tagged_Item
History_Of_Task
History_Of_Time_Zone
History_Of_Timer
Integration_Application
Integration_Custom_Value
Integration_Invoice
Integration_Invoice_Prior_Payment
Integration_Sheet_Entry This table is a holding area for Sheet Entry rows that are imported from a Disconnected Database, before they are verified by a user. There is intentionally no foreign keys to this table, so that rows can still be accepted into the database should the related rows not exist.
Interaction Holds all of the interactions regardless of type and what they are associated with.
Interaction_Association SYSTEM TABLE: Defines types of association that a Contact can have to an Interaction.
Tags: read-only

Content:
0Contact10
1Staff01
2Originator01
3Of01
Interaction_Contact Links an Interaction to zero or more Contacts. Each combination of Interaction and Contact must be unique.
Interaction_Email_Address Holds the list of e-mail address and which e-mail address fields they came from for a particular interaction.
Interaction_Link Contains additional information about links to Interaction items.
Interaction_Phone_Number Links a Phone Call or Phone Message type Interaction to zero or one phone number. Even if other phone numbers change this phone number remains unchanged for historical information.
Interaction_Subtype SYSTEM TABLE: Defines the subtypes of interactions that can be stored in the Interaction table.
Tags: read-only

Content:
00E-mail
11Note
22Incoming
32Outgoing
43Please Call Back
53Will Call Back
63Returned Your Call
74Created
84File Uploaded
94File Deleted
104Waiting for Files
114Ready for Download
124Email Notification Sent
134File Downloaded
144File Signed
154File Rejected
164Completed
174Expired
184Canceled
194All Files Purged
Invoice
Invoice_Office
Last_Table_Modification
Ledger_Entry
Ledger_Entry_Application
Ledger_Entry_Service_Charge
Ledger_Entry_Submittal
Ledger_Entry_Submittal_Result
Ledger_Entry_Subtype SYSTEM TABLE: Defines the subtypes of ledger_entrys that can be stored in the Ledger_Entry table.
Ledger_Entry_Type Tags: read-only

Content:
1INVInvoice1INV
2SCService Charge1SC
3DMDebit Memo1DM
4CHKCheck-1CHK
5CMCredit Memo-1CM
6NSFNon-Sufficient Funds1NSF
7WOWrite Off-1WO
8CACash-1CA
9CCCredit Card-1CC
10CCRCredit Card Return1CCR
11ACHElectronic Funds Transfer-1ACH
12PWOProforma Write Off-1Proforma Write Off
13CNAReversal (Application)-1CNA
Legacy_Contact_Portal_Mapping Contains the legacy mappings for contacts to portals that need to be converted.
Link This table stores information about links to external documents.
Link_Group This table stores information about groups of links to external documents.
Login_Ticket Single-use login tickets which can be used in lieu of a password for authentication.
Lost_Reason
Lost_To
Monitored_Event
Monitored_Event_Action
Month_Info Basic information about calendar months (in English.) This information is useful for drop down lists, etc and is used mostly in Filtering.
Tags: read-only

Content:
11000000000001 jJanuary
22000000000002 jFebruary
33000000000003 jMarch
44000000000004 jApril
55000000000005 jMay
66000000000006 jJune
77000000000007 jJuly
88000000000008 jAugust
99000000000009 jSeptember
1010000000000010 iOctober
1111000000000011 iNovember
1212000000000012 iDecember
Observed_Holiday
Office
Online_Invoice Information about Invoices that have been sent to the online bill pay service.
Online_Payment Information about Payments that have been received from the online bill pay service.
Option_List
Outlook_Contact_Synchronization_Folder A list of Outlook? folders to synchronize contacts with for a particular Staff's contact synchronization profile. The combination of (outlook_contact_synchronization_profile_KEY, outlook_store_KEY, entry_id) is unique.

"For the Exchange message entrys, entry id includes the full distinguished name of the mailbox, which is not limited in length AFAIK. Since MAPI starts barking when a property size goes above about 4k (you need to open the property as IStream, not with IMAPIProp::GetProps(...), etc), it would be relatively safe to alllocate 8192 chars for the entry ids - if your code breaks, so would Outlook? itself."
-- Dmitry Streblechenko (MVP)
http://www.dimastr.com/, http://groups.google.com/group/microsoft.public.outlook.program_vba/browse_frm/thread/f768d385c8dd4a27/1df02bd5c153c6bd%231df02bd5c153c6bd
Outlook_Contact_Synchronization_Profile Stores a Contact Synchronization Profile, a staff-specific set of Outlook? folders and database contact filters to configure contact syncronization.
Outlook_Index_Folder_Firm A list of Outlook(R) folders to index for firm-specific email. The combination of (firm_KEY, outlook_store_KEY, entry_id) is unique.

"For the Exchange message entrys, entry id includes the full distinguished name of the mailbox, which is not limited in length AFAIK. Since MAPI starts barking when a property size goes above about 4k (you need to open the property as IStream, not with IMAPIProp::GetProps(...), etc), it would be relatively safe to alllocate 8192 chars for the entry ids - if your code breaks, so would Outlook itself."
-- Dmitry Streblechenko (MVP)
http://www.dimastr.com/, http://groups.google.com/group/microsoft.public.outlook.program_vba/browse_frm/thread/f768d385c8dd4a27/1df02bd5c153c6bd%231df02bd5c153c6bd
Outlook_Item Holds cached Outlook(R) items.

"For the Exchange message entrys, entry id includes the full distinguished name of the mailbox, which is not limited in length AFAIK. Since MAPI starts barking when a property size goes above about 4k (you need to open the property as IStream, not with IMAPIProp::GetProps(...), etc), it would be relatively safe to alllocate 8192 chars for the entry ids - if your code breaks, so would Outlook itself."
-- Dmitry Streblechenko (MVP)
http://www.dimastr.com/, http://groups.google.com/group/microsoft.public.outlook.program_vba/browse_frm/thread/f768d385c8dd4a27/1df02bd5c153c6bd%231df02bd5c153c6bd
Outlook_Store Holds Outlook(R) StoreID values to save space and aid in indexing. Each store_id must be unique. This table does not support updates, only inserts and deletes. Once a record exists it is read-only.

"For the Exchange message stores, entry id includes the full distinguished name of the mailbox, which is not limited in length AFAIK. Since MAPI starts barking when a property size goes above about 4k (you need to open the property as IStream, not with IMAPIProp::GetProps(...), etc), it would be relatively safe to alllocate 8192 chars for the entry ids - if your code breaks, so would Outlook itself."
-- Dmitry Streblechenko (MVP)
http://www.dimastr.com/, http://groups.google.com/group/microsoft.public.outlook.program_vba/browse_frm/thread/f768d385c8dd4a27/1df02bd5c153c6bd%231df02bd5c153c6bd
Portal_User Cached portal web service data.
Practice_User
Print_Option
Priority Tags: read-only

Content:
9981000Low
9992000Normal
10003000High
Privilege Tags: read-only

Content of first 30 of 613 rows:
00CSP<Product_Name>1001CSP0010
1404SetupSetup Menu134003CSP_Menu_Setup0010_0020_1340
21Firm<Firm>135014CSP_Menu_Setup_Firm0010_0020_1340_1350
31Validation-- Validation Lists Deprecated173014CSP_Menu_Setup_Validation0010_0020_1340_1730
4449BillingBilling Data213004CSP_Data_Client_Billing0010_1750_1820_2130
51TemplatesTemplates143004CSP_Menu_Setup_Templates0010_0020_1340_1430
61SecuritySecurity Groups140014CSP_Menu_Setup_Security0010_0020_1340_1400
71RecurBillRecurring Bill Descriptions151014CSP_Menu_Setup_RecurBill0010_0020_1340_1510
81Clients<Clients>139014CSP_Menu_Setup_Clients0010_0020_1340_1390
91Staff<Staffs>137014CSP_Menu_Setup_Staff0010_0020_1340_1370
10469MainMain Data387004CSP_Data_Staff_Main0010_1750_3700_3870
1110ViewView388015CSP_Data_Staff_Main_View0010_1750_3700_3870_3880
1210EditEdit389015CSP_Data_Staff_Main_Edit0010_1750_3700_3870_3890
13585Staff<Staff> <Contacts>243504CSP_Data_Contact_Staff0010_1750_2325_2435
1413ViewView244505CSP_Data_Contact_Staff_View0010_1750_2325_2435_2445
1513EditEdit249505CSP_Data_Contact_Staff_Edit0010_1750_2325_2435_2495
16469Rates<Staff> Rates Data421004CSP_Data_Staff_Rates0010_1750_3700_4210
1716ViewView422015CSP_Data_Staff_Rates_View0010_1750_3700_4210_4220
1816EditEdit423015CSP_Data_Staff_Rates_Edit0010_1750_3700_4210_4230
19469SecuritySecurity Data427004CSP_Data_Staff_Security0010_1750_3700_4270
2019ViewView428015CSP_Data_Staff_Security_View0010_1750_3700_4270_4280
2119EditEdit429015CSP_Data_Staff_Security_Edit0010_1750_3700_4270_4290
22469MemoNotes436004CSP_Data_Staff_Memo0010_1750_3700_4360
2322ViewView437015CSP_Data_Staff_Memo_View0010_1750_3700_4360_4370
2422EditEdit438015CSP_Data_Staff_Memo_Edit0010_1750_3700_4360_4380
2526MOSSFor <Staffs> in Same <Office>374016CSP_Data_Staff_View_Others_MOSS0010_1750_3700_3710_3730_3740
26340OthersFor Other <Staffs>373005CSP_Data_Staff_View_Others0010_1750_3700_3710_3730
27345OthersFor Other <Staffs>381005CSP_Data_Staff_Edit_Others0010_1750_3700_3790_3810
28343MOSSFor <Staffs> in Same <Office>377015CSP_Data_Staff_Add_MOSS0010_1750_3700_3760_3770
29344MOSSFor <Staffs> in Same <Office>385015CSP_Data_Staff_Delete_MOSS0010_1750_3700_3840_3850
Privilege_Dependency Lists dependencies of Privileges in addition to the normal parent-child relationship.
Tags: read-only

Content of first 30 of 317 rows:
1305306
2307308
3196444
4309310
54699
68790
787412
994164
1087164
11409258
13313314
16315316
179596
1831897
1931898
20319320
21321322
22325326
25328329
27198199
28102103
295556
305557
315558
3234125
332531
342528
353133
362833
37341346
Project
Project_Extension
Project_Template
Project_Template_Assignment
Project_Template_Definition
Project_Template_Definition_Extension
Project_Template_Definition_Imported
Project_Template_Entity
Project_Template_Extension
Recorded_Event
Recorded_Event_Notification
Recurrence_Expiration_Method The recurrence expiration methods.
Tags: read-only

Content:
9981000No end date
9992000End after count
10003000End by date
Recurrence_Generation_Method The recurrence generation methods.
Tags: read-only

Content:
9974000Generate all
9981000When the current <ScheduleItem> is complete
9992000Specified days before next date
10003000When I manually create it
Recurrence_Method The recurrence methods.
Tags: read-only

Content:
9981000None
9992000Use Specific Rule
10003000Use <Project> Template
Recurring_Bill
Referral_Source
Report_Based_Portlet Information about report-based custom portlets.
Report_Category Tags: read-only

Content:
1Lists1
2Production2
3Collection4
4Billing3
5Reconciliation5
6<Project> Management6
9<Client> Management7
10Address Labels1
11File Folder Labels2
12Letters3
13<Staff> Management8
Report_Definition
Report_Definition_Privilege_Dependency
Report_Definition_Product Links standard report definitions to a product.
Tags: read-only

Content of first 30 of 53 rows:
PRCM925B4133-9BD6-4780-BF28-623B55D668CD
PRCM80573483-ABA0-475B-8BD6-F2EAE1AE0C5B
PRCM74ACBFBD-8813-48E9-A19E-FEF1EF881827
PRCS47003526-FF42-4F86-A38C-00099AE2ADF9
PRCSE9DBF8C0-2FF8-49AE-82CD-05794376218B
PRCS6672DFEB-32D5-4543-9D94-0704C3C30D31
PRCS603D0651-6A90-41F9-9E1D-1550BC71FD71
PRCSCE717878-243E-4A1E-90F9-1C9BF08AE067
PRCS4404FEAA-FB8D-46BE-AC40-225DA51F8F0E
PRCSC5367657-D997-4893-A7AF-26EA902006B5
PRCSDB8065B1-A562-4E7D-9B9A-2E6C4C97BB25
PRCSD2D1052E-BC46-47DF-98C0-319F824E39EB
PRCSD2839D86-2CAD-44AA-BED1-37AD2EDEBB6D
PRCSEB7899CA-32CC-448E-B536-37D771DDF40F
PRCS522386F5-18B2-40C4-A616-3B70F595EC52
PRCS344B13F3-EFD4-4095-A5A8-3F8E4548723B
PRCSEB081650-23CE-4E64-9F41-43C096DEE592
PRCSA42705C3-C9ED-4EF5-9403-4B71E6646BA9
PRCS7552442B-E566-4C4F-B2FD-6313B4CE471E
PRCS4983C7F8-AC59-458E-826F-6E3A4584D647
PRCS6991CF01-A7DB-4BCB-BF91-75ABF773A75B
PRCSD185A6E7-5670-4478-8567-79D42F181511
PRCS98FA797E-FAEE-4D01-9627-7E81645E6582
PRCS9E8FB2D9-1559-4D5B-B33B-86AE6874CC9A
PRCS29CDE26C-E93F-489C-B766-97DA2822C42D
PRCS56356A89-F806-4434-B6F3-B8879DA2C0B8
PRCS935C4965-B953-4446-89F6-BF78EA298847
PRCS86AD4F28-4020-457C-A117-C080C032A6D5
PRCS38FFCCF1-E86A-4DD2-AA69-C7BE87B88DE1
PRCS1F831DAA-BDF0-4739-94EC-D55057EB8956
Report_Definition_Security_Group
Report_Definition_Update_List
Report_Image
Report_Profile
Report_Profile_Report_Definition
Restricted_Clearance_Staff List of staff that have clearance to the database when it is in restricted access.
Schedule_Entry Represents all or some of a scheduled assignment. Each block can be scheduled by day or for a particular time. There is nothing unique about a [Schedule_Entry] and it is up to the user interface to reduce the number of overlaps and adjacent entries, but it is possible for such entries to be created due to concurrency.
Schedule_Item Each item that can be scheduled has a row in this table.
Schedule_Item_Assignment
Schedule_Item_Assignment_List_Cache Cache of the staff assignment lists.

Assignments are primarily stored in [Schedule_Item_Assignment] and are affected by the content of [Schedule_Item].[staff_assignment_method_KEY], [Staff].[description], [Filter].[description] and [Schedule_Item_Pool] and [Schedule_Item_Assignment].

This cache is maintained by triggers and Schedule_Item_Assignment_List_Cache_Calculation_View.
Schedule_Item_Budget_Remaining_Entry This table stores the user adjustments to the remaining hours value for Projects/Tasks
Schedule_Item_Date_Index This table is an index used for fast queries looking up the [Schedule_Item] rows that intersect with a date range.
Schedule_Item_Generation_Date This table holds the next generation date for a given schedule item series.
Schedule_Item_Last_In_Series Table that caches the last schedule item key for each series
Schedule_Item_Pending_Reminder Reminders that have not yet been recorded, indexed by [reminder_date] so that lookups are fast. When a reminder is recorded this record is deleted.
Schedule_Item_Reminder_Recorded_Event Keeps track of what [Recorded_Event] is the reminder for a [Schedule_Item].
Schedule_Item_Series Schedule Item Series
Security_Group
Service_Charge
Sheet_Entry
Sheet_Entry_Open_Value_Cache
Staff
Staff_Area_Rating
Staff_Benefit
Staff_Benefit_Entry
Staff_Billing_Rate
Staff_Grouping_Type Tags: read-only

Content:
9941000<Client>'s <Partner>Clientpartner__staff_KEY
9952000<Client>'s <Manager>Clientmanager__staff_KEY
9963000<Client>'s <Associate>Clientassociate__staff_KEY
9974000<Engagement>'s BillerEngagementbiller__staff_KEY
9985000<Engagement>'s ReviewerEngagementreviewer__staff_KEY
9996000<Engagement>'s <Manager>Engagementmanager__staff_KEY
10007000Specified <Staff>
Staff_Level
Staff_Locator
Staff_Rate_Table
Staff_Report_Definition
Staff_Security_Group
Staff_Shortcut This table is a data store for the Solutions portlets. It contains information about user-configurable solutions (which are paths to files, folders, or web pages).
Staff_Shortcut_Group This table is a data store for the Solutions portlets. It contains information about user-configurable groups of solutions (which are paths to files, folders, or web pages).
Staff_Skill_Area
Staff_Skill_Area_Rating
Staff_Skill_Rating
Staff_Target_Range The Staff_Target_Range table holds ranges of dates where different Staff targets (budgets) are effective. This table defines the date range and the target hours for each day of the week within this range. These ranges are specific to a staff and are coupled to a firm year.
Unlike tables defined in the past which would only store either [ending_date] or [upper_date_exclusive] this table redundantly stores both of these as well as [lower_date_inclusive] for the performance benefits and defines [upper_date_exclusive] as the value the other two are validated against.
Standard_Text
Status_Event
Status_Event_Type
Table_Information Assigns an integer key to a table in the database.
Tags: read-only

Content of first 30 of 208 rows:
3Billing_Rate_TypeBRT
5dtpropertiesdtproperties
6PrivilegeP
7Privilege_DependencyPD
8Security_GroupSG
13StaffS
14Staff_Billing_RateSBR
16Staff_LevelSL
17Staff_Rate_TableSRT
18Staff_Security_GroupSSG
19Table_InformationTI
21DepartmentD
23FirmFirm
24OfficeO
25Practice_UserPU
32Staff_StatusSS
36User_SessionUS
38ActivityA
39Activity_ClassAC
40Activity_StatusAST
41Activity_CategoryAG
46FilterF
48Filter_LineFL
49Filter_Line_TypeFLT
53Filter_SelectFS
54Filter_TypeFT
56Tax_AreaTA
57Tax_Area_Taxing_AuthorityTATA
58Taxing_AuthorityTAU
59Taxing_Authority_TypeTAT
Tag A tag is a non-hierarchical keyword or term assigned to a piece of information. This kind of metadata helps describe an item and allows it to be found again by browsing or searching. Tags are generally chosen informally and personally by the item's creator or by its viewer.
Tagged_Item Associates Tags to an item.
Target_Date_Method Tags: read-only

Content:
9991000Before due date
10002000After received date
Task
Task_Template
Task_Template_Assignment
Tax_Area A Tax Area is a collection of Taxing Authorites. This holds the list of Tax Areas the Firm has setup.
Tax_Area_Taxing_Authority Maps the relationship that Tax Areas are made up of a collection of Tax Authorities.
Taxing_Authority Taxing authorities are governmental bodies empowered to collect tax on goods, services or both. If both goods and services are taxed at different rates then two taxing authorities would be created.
Term Information about customizable terms.
Time_Zone Just enough information about Windows Time Zones to be able to record the time zone a user was in when they last edited a datetime field.
Timer
Tracking_Description
Update_Data_Change_Log
Update_Data_Version_History
User_Preference
User_Preference_Custom_Field_Column Contains records for the User Preference settings for Custom Fields
User_Session
User_Session_Pattern
Valid_Date The Valid_Date table holds all of the dates between 1900-01-01 and 2079-01-01 inclusive. Having these dates makes it convenient to join against for generating ranges.
Tags: read-only

Content of first 30 of 65380 rows:
1900-01-01T00:00:001
1900-01-02T00:00:002
1900-01-03T00:00:003
1900-01-04T00:00:004
1900-01-05T00:00:005
1900-01-06T00:00:006
1900-01-07T00:00:007
1900-01-08T00:00:008
1900-01-09T00:00:009
1900-01-10T00:00:0010
1900-01-11T00:00:0011
1900-01-12T00:00:0012
1900-01-13T00:00:0013
1900-01-14T00:00:0014
1900-01-15T00:00:0015
1900-01-16T00:00:0016
1900-01-17T00:00:0017
1900-01-18T00:00:0018
1900-01-19T00:00:0019
1900-01-20T00:00:0020
1900-01-21T00:00:0021
1900-01-22T00:00:0022
1900-01-23T00:00:0023
1900-01-24T00:00:0024
1900-01-25T00:00:0025
1900-01-26T00:00:0026
1900-01-27T00:00:0027
1900-01-28T00:00:0028
1900-01-29T00:00:0029
1900-01-30T00:00:0030
Web_Page_Portlet
Won_Reason