Database schema: Schema

DBMS: mssql

Version: 3004.140.121

Tables
dbo.AP_Discount_Method Type table for AP Discount Methods. Currently the only discount method that can be selected is Discount after application. With this selected discounts are only recognized after being applied.
dbo.AP_Enter_Transaction_Description_Type This table contains the three possible fields for Description column in Enter AP Transactions.
dbo.AP_Enter_Transaction_List_View_Column This table contains the list of columns used in Enter AP Transactions screen and whether they can be hidden or not.
dbo.AP_Enter_Transaction_List_View_Column_Option This table contains the user preferences per client for settings and fields defaults for Enter AP Transactions screen.
dbo.AP_Enter_Transaction_Option This table contains user preferences per client for Data Entry Method and List View Filter in Enter AP Transactions.
dbo.AP_Payment_Type This table defines all of our payment types used in manage ap payments processing.
dbo.AR_Customer_Payment_List_View_Column Lists the column headers as they will appear in the AR Customer Payment view.
dbo.AR_Customer_Payment_List_View_Column_Option Saves user-specified ordering of how the columns will appear in the AR Customer Payments view.
dbo.AR_Customer_Payment_Option Saves user configuration of their settings for use in the AR Customer Payment view.
dbo.AR_Deposit_Cash_Back_Distribution This table is used to identify the Cash Back distribution, if any, for bank transactions of type AR Deposit.
dbo.AR_Enter_Invoice_List_View_Column Lists the column headers as they will appear in the AR Enter Invoices view.
dbo.AR_Enter_Invoice_List_View_Column_Option Saves user-specified ordering of how the columns will appear in the AR Enter Invoices view.
dbo.AR_Enter_Invoice_Option Saves user configuration of their settings for use in the AR Enter Invoices view.
dbo.AR_Invoice_Sort_By Table to identify which field to sort by in invoices for Accounts Receivable
dbo.AR_Item This table stores setup information for AR items.
dbo.AR_Item_Group This table stores member items for a group along with their quantity and sequence number. The group represents a package of items that can be selected to be placed on an invoice.
dbo.AR_Item_Tax_Status This table stores the different item tax statuses.
dbo.AR_Item_Type This table stores the AR item types.
dbo.AR_Payment Table which holds all the necessary information for each payment in Accounts Receivable.
dbo.AR_Payment_Application Each row in this table represents a payment being applied to a receivable. A payment is either a credit memo (an AR_Transaction of type Credit Memo) or an AR payment (an AR_Payment of any type). A receivable is a regular invoice or a finance charge invoice (an AR_Transaction of type Invoice or Finance Charge). The receivable and payment must belong to the same customer. A given receivable can have multiple payments applied to it until its open balance is zero. A given payment can be applied until its unused amount is zero.
dbo.AR_Payment_Application_Distribution This table contains a payment application's distribution across the receivable's items. Cash basis accounting requires knowing how much of each item on a receivable was paid by a given payment application. To this end, a payment application must be proportionally distributed across the items of the receivable it is applied to. More precisely, since each item can affect multiple GL accounts, the payment amount is distributed across the GL accounts associated with the receivable items.
dbo.AR_Payment_Type Table to identify the different payment classifications for an AR payment
dbo.AR_Statement_Sort_By Table to identify which field to sort by in statements for Accounts Receivable
dbo.AR_Transaction This table stores Invoices, Credit Memos, and Finance Charges for the Accounts Receivable service. Invoices and Finance Charges are transactions customers have to pay while Credit Memos are can be used to reduce open balance.
dbo.AR_Transaction_Item This table stores items for an AR Transaction. Items are usually created by selected an row from the AR Item table and copying all necessary information down to this table. This way changes made to the AR Item will not change existing payables.
dbo.AR_Transaction_Item_GL_Account This table stores GL Accounts for AR Transaction Items and the type for that account.
dbo.AR_Transaction_Item_GL_Account_Type This table stores types of GL Accounts for AR Transaction Items.
dbo.AR_Transaction_Item_N_AR_Item This table stores the connection between an AR Transaction Item and an AR Item. This connect is maintained so that the system knows where specific AR Items are being used. This is in a seperate table to allow either side to be deleted without changing the other side.
dbo.AR_Transaction_Template Contains templates that can be used to generate an AR transaction.
dbo.AR_Transaction_Template_Item Tracks items associated with an AR template.
dbo.AR_Transaction_Template_N_Customer Links AR templates to customers. An AR template can have multiple customers selected for it and a customer can be used for multiple templates.
dbo.AR_Transaction_Type This table stores the AR transaction types.
dbo.ATF_Payroll_Check_Entry_Option This table contains the data entry options to configure the After The Fact handwritten batch check entry grid.
dbo.ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition This table contains the selected pay and tax items in the After The Fact Handwritten Batch Check entry["BR"] options screen. A row in this table can represent either a pay or a tax item (but not both).
dbo.Account_Source_Selection Funding account reference source selection.
dbo.Accounting_Application The table enumerates the different types of accounting applications that may use the database.
dbo.Accrual_Date
dbo.Accrual_Method
dbo.Ach_Company_Batch_Header_Record
dbo.Ach_Entry_Addenda_Record
dbo.Ach_Entry_Detail_Record
dbo.Ach_File_Header_Record
dbo.Active_Filter
dbo.Active_Status This table stores the values to be used for showing the Status values for various entities.
dbo.Additional_Contact
dbo.Additional_Contact_Role This table allows user to assign defined firm level additional contact roles to additional contact for a client.
dbo.Address
dbo.Affordable_Care_Act_Employee_Status This table stores the employee status allowed for selection with regard to affordable care act information
dbo.Alert_Level
dbo.Apply_Customer_Payment_Option This table holds user options, per client per staff, for apply customer payments.
dbo.Apply_Customer_Payment_Transaction This table exists to provide a data source for the apply customer payments view grid. This table will exist only for the purpose of feeding the datasource to the grid, and to facilitate filtering in our system. Such a table is sometimes called a “temporary” table. It is permanently in the database, but holds data only temporarily, while the Apply Customer Payments view is displayed. This table holds a combination of ar payments (cash, check, credit card and write-offs) and ar transactions (invoices, credit memos, and finance charges) for a given client.
dbo.Ascii_Time_Clock_Client_Benefit_Id_Map This table is used for ASCII time clock import. It maps a client benefit to a (user-provided) id. The format of the id is specified by a legacy file format.
dbo.Ascii_Time_Clock_Client_Payroll_Item_Id_Map This table is used for ASCII time clock import. It maps a client payroll item to a (user-provided) id. The format of the id is specified by a legacy file format.
dbo.Ascii_Time_Clock_Employee_Id_Map This table is used for ASCII time clock import. It maps an employee to a (user-provided) id. The format of the id is specified by a legacy file format.
dbo.Ascii_Time_Clock_Payroll_Department_Id_Map This table is used for ASCII time clock import. It maps a payroll department to a (user-provided) id. The format of the id is specified by a legacy file format.
dbo.Automatic_Journal_Entry_Period_Option Type table which defines the period options for automatic journal entry calculation.
dbo.Automatic_Payment_Application_Method Accounts Payable Automatic Payment Application Method table
dbo.Autopay_Session Contains info about Autopay sessions. In an Autopay session the system automatically creates checks from a pay schedule detail record.
dbo.Autopay_Session_Status The available status values for an Autopay session (completed, failed, etc.).
dbo.BS_Bank_Reconciliation_Statement_Import__Ach_File_Header_Record Used only in client backup databases, to hold summary information about references to ACH_File_Header_Record rows by Bank_Reconciliation_Statement_Import rows which cannot be directly represented in incomplete backup databases.
dbo.BS_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source This table will only have rows in a CDMU Backup Database. Tracks an outgoing reference to bank transaction data from Bank_Transaction_Reconciliation_Detail. If there is a reconciled firm client transaction from a funded paper net check with source__bank_transaction_KEY pointing to a standard client and it is then reversed we get into a state where a standard client row is referencing firm data through source__bank_transaction_KEY. Backup and restore uses this to link a restored client to data in the firm.
dbo.BS_Billing_Item__GL_Account__delivery Tracks an outgoing reference to other client data in FK_Billing_Item__GL_Account__delivery__gl_account_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Billing_Item__GL_Account__discount Tracks an outgoing reference to other client data in FK_Billing_Item__GL_Account__discount__gl_account_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Billing_Item__GL_Account__fees Tracks an outgoing reference to other client data in FK_Billing_Item__GL_Account__fees__gl_account_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Billing_Item__GL_Account__receivable Tracks an outgoing reference to other client data in FK_Billing_Item__GL_Account__receivable__gl_account_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Billing_Item__GL_Account__sales_tax Tracks an outgoing reference to other client data in FK_Billing_Item__GL_Account__sales_tax__gl_account_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Client_Billing__Client__bill_to_other_client Tracks an outgoing reference to other client data in FK_Client_Billing__Client__bill_to_other_client__client_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Client_Payroll_Information__Checkbook__firm_vendor_impound_deposit Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__firm_vendor_impound_deposit__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Client_Payroll_Information__Checkbook__firm_vendor_impound_withdrawal Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__firm_vendor_impound_withdrawal__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Client_Payroll_Information__Checkbook__payroll_agent_impound_deposit Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__payroll_agent_impound_deposit__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Client_Payroll_Information__Checkbook__payroll_agent_impound_withdrawal Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__payroll_agent_impound_withdrawal__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Client_Payroll_Information__Checkbook__payroll_impound_deposit Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__payroll_impound_deposit__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Client_Payroll_Information__Checkbook__payroll_impound_withdrawal Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__payroll_impound_withdrawal__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Client_Payroll_Information__Checkbook__tax_agent_impound_deposit Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__tax_agent_impound_deposit__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Client_Payroll_Information__Checkbook__tax_agent_impound_withdrawal Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__tax_agent_impound_withdrawal__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client.
dbo.BS_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Record Tracks an outgoing reference to ACH data in FK_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Record__ach_company_batch_header_record_KEY. Backup and restore uses this to link a restored client to ACH data.
dbo.BS_Workpaper__Staff__assigned_to_staff Tracks an outgoing reference to staff data in FK_Workpaper__Staff__assigned_to__staff_KEY. Backup and restore uses this to link a restored client to data in the staff.
dbo.Backup_Withholding_Rate The table used to store backup withholding rates and their effective dates.
dbo.Balance_Definition Balance Definition Table - Defines what journal entry types make up a balance for a client
dbo.Balance_Definition_Journal_Entry_Type_Component Connects a client balance to the journal entry types that are it's components.
dbo.Balance_Type ACS Balance Types - enumerates the supported calculation basis of journal entry balances
dbo.Bank Data about banks is stored here. Bank_View exists and, as of 3004.75.120 limits the columns returned, so columns which should surface on the entity should be added there.
dbo.Bank_Account_Direct_Deposit_Status
dbo.Bank_Account_Type
dbo.Bank_Feeds_Assignment_Column This table hold the information of Assign value in Create Rules dialog. Assign value should allow the user to select either description, reference, vendor, or account to bank statement transactions.
dbo.Bank_Feeds_Assignment_Rule This table hold the information of Create Rules dialog. The dialog should allow the user to create rules for assigning a description, reference, vendor, and account to bank statement transactions. The user may use the reference, description, amount, vendor, or account fields to apply the rules.
dbo.Bank_Feeds_Assignment_Rule_Action This table holds the information for Create Rules dialog Action part. The dialog should allow the user to create rules for assigning a description, reference, vendor, and account to bank statement transactions. The user may use the reference, description, amount, vendor, or account fields to apply the rules.
dbo.Bank_Feeds_Assignment_Rule_Action_Distribution This table holds the information about multiple distributions to be assigned via rules.
dbo.Bank_Feeds_Bank_Transaction This table keeps track of which bank transactions were imported from a yodlee transaction or matched to a yodlee transaction.
dbo.Bank_Feeds_Import this table will store off the start date and the end date of the last retrieve. Also there will be data for the date and time of the last successful retrieve.["BR"]
dbo.Bank_Feeds_License_Agreement this table tells records the staff id and staff name of the staff member that accepted a version of the bank feeds license agreement. Firms that use bank feeds will need a record in this table for the current license agreement and the primary key constant that matches the current license agreement. Firms that do not use bank feeds will not have a record in this table. Updates to the license agreement would result in new records being added to this table with a new primary key constant for the firms using bank feeds, once a staff member accepts the new version of the license agreement.
dbo.Bank_Feeds_Refused_Transaction This table holds the information about bank feeds transactions that were deleted by the user so that they do not show up on future retrievals
dbo.Bank_Feeds_Retrieved_Financial_Account This table provides records from a bank feeds bank account or other financial account.
dbo.Bank_Feeds_Retrieved_Transaction This table provides transaction records from a bank feeds bank account or other financial account.
dbo.Bank_Feeds_Retrieved_Transaction_Distribution This table provides transaction distribution records related to a bank feeds transaction.
dbo.Bank_Feeds_Retrieved_Transaction_Rule_Applied This table holds the information about bank feeds retrieve transactions on which bank feeds rules has been applied.
dbo.Bank_Feeds_Transaction_Description_Type Table for options for the description for Bank Feeds Retrieved Transactions. These options indicate on what the description value["BR"] of a transaction retrieved from Yodlee needs to be based
dbo.Bank_Feeds_Transaction_Import_Status This table stores values for the transaction import status. These are values used in the import process to determine how to process each transaction retrieved from bank feeds.
dbo.Bank_Feeds_Transaction_Option Table for options for the Bank Feeds Retrieved Transactions
dbo.Bank_Feeds_Transaction_Source_Type This table hold the information of bank feeds retrieved transaction source either yodlee, or digital file like bank statement.
dbo.Bank_Reconciliation_Adjustment_Order
dbo.Bank_Reconciliation_Adjustment_Type
dbo.Bank_Reconciliation_Aggregate_Clear_Status This is a type table of bank reconciliation clear status values that apply to a given bank transaction as a whole. This value is an aggregate of the bank transaction's associated bank reconciliation detail's clear status (cleared or uncleared).
dbo.Bank_Reconciliation_Clear_Status
dbo.Bank_Reconciliation_Client_Adjustment This table stores adjustments that show adjustments that the user wants one of their clients to make in their own bank account records. Adjustments in this table do not impact the general ledger, they are used for report purposes only. They do not impact any bank reconciliation statement totals, they are just intended as a means for a user to convey information to one of their clients about adjustments the client has to make to their own records.
dbo.Bank_Reconciliation_Frequency_Type
dbo.Bank_Reconciliation_Rapid_Clear_Unmatched_Transaction This table will hold all the pending unmatched keyed-in data in the Rapid Clear dialog for a given bank reconciliation. This data will be deleted for finalized bank reconciliations.
dbo.Bank_Reconciliation_Recurring_Adjustment_Template
dbo.Bank_Reconciliation_Recurring_Adjustment_Template_Distribution This table holds the distributions of a bank reconciliation recurring adjustment template.
dbo.Bank_Reconciliation_Statement
dbo.Bank_Reconciliation_Statement_Detail
dbo.Bank_Reconciliation_Statement_Import This table will hold the list of bank statement transactions imported from the bank via a file. These transactions will be used by bank reconciliation to clear bank transactions. It will hold on to these transactions when the user chooses to finish the bank rec later and once the user finalizes, it will lose all its data for the given Bank Statement.
dbo.Bank_Reconciliation_Statement_Imported_File_Name This table will hold the list of locations and names of bank statement files imported from the bank.
dbo.Bank_Reconciliation_Statement_Summary This table will store bank reconciliation statement summary data entered by the user. The statement summary dialog is an optional feature in bank reconciliation and allows users to enter statement deposits/other credits and check/other debits amounts for multiple statements, amounts which are totaled and carry into one bank reconciliation.
dbo.Bank_Reconciliation_Status
dbo.Bank_Transaction
dbo.Bank_Transaction_Accounting_Source_Override_Bank_Transaction_Distribution Entries in this dictionary table link a bank transaction distribution that uses a checkbook's GL account number with the bank transaction created to affect that checkbook's balance. The bank transaction is ignored as far as account balances go; the associated distribution carries all the accounting effect.
dbo.Bank_Transaction_Accounting_Source_Override_Journal_Entry_Distribution Entries in this dictionary table link a journal entry distribution that uses a checkbook's GL account number with the bank transaction created to affect that checkbook's balance. The bank transaction is ignored as far as account balances go; the associated distribution carries all the accounting effect.
dbo.Bank_Transaction_Address
dbo.Bank_Transaction_Displayable_Status This type table contains values that represent a bank transaction's status determined by analyzing all pertinent attributes of the transaction (its type, record status, handwritten flag, etc.). This value can be displayed by data entry screens, used when filtering bank transactions on status, etc.
dbo.Bank_Transaction_Distribution Distributions of Bank_Transaction records are stored here unless it is a Payroll Check. In that case see Payroll_Check_Payroll_THING_Distribution. Bank_Transaction_Distribution_View exists with an explicit column list, so columns which should surface on the entity should be added there.
dbo.Bank_Transaction_Event Table to store bank transactions events
dbo.Bank_Transaction_Event_Type Table to store the event type for bank transactions
dbo.Bank_Transaction_Reconciliation_Detail This table is primarily for Bank Rec use. Its purpose is for partial clearing of a bank transaction. The records in this table define the smallest granularity at which a bank transaction can be cleared. For some types of transactions, the system defines the contents of this table; for others, the user is allowed to enter what they wish.
dbo.Bank_Transaction_Reversal
dbo.Bank_Transaction_Template This table stores information about the bank transaction portion of a transaction template.
dbo.Bank_Transaction_Template_Distribution This table contains the distributions associated with a bank transaction template.
dbo.Bank_Transaction_Template_Reconciliation_Detail This table contains records that denote if the user wishes to clear the whole transaction amount in bank reconciliation, or whether it wants the option of partially clearing the bank transaction.
dbo.Bank_Transaction_Transfer_Type The table enumerates the different types of bank transaction transfers supported by the system.
dbo.Bank_Transaction_Type
dbo.Benefit_Accrual_Balance_Reset_Type
dbo.Benefit_Accrual_Exclusion_Detail Table used to store selected accruable benefit exclusions.
dbo.Benefit_Allowance
dbo.Benefit_Eligibility_Duration_Type This table stores the time duration types available for accruable benefit eligibility items.
dbo.Benefit_Item_Worker_Compensation_Exemption
dbo.Benefit_Item_Worker_Compensation_Exemption_Detail
dbo.Benefit_Period_Usage_Type The type table used to store accruable benefit period usage types.
dbo.Benefit_Transaction
dbo.Benefit_Transaction_Type The table defines benefit transaction types.
dbo.Billable_Item
dbo.Billable_Item_N_Check_Print_Run
dbo.Billable_Item_N_Form_Processing_Run This table holds the connection between each billable item and the form processing run that it is associated with.
dbo.Billing_Calculation_Method
dbo.Billing_Calculation_Type
dbo.Billing_Fee_Frequency
dbo.Billing_Fee_Method
dbo.Billing_Fee_Month
dbo.Billing_Fee_Schedule
dbo.Billing_Fee_Type
dbo.Billing_Item
dbo.Billing_Item_1099_Type This table is used to hold the differnt types of 1099 forms.
dbo.Billing_Item_Form This table holds the different forms for each form type used for creating form fees.
dbo.Billing_Item_Form_Rate This table is used to hold the different fee amounts for each form of a form fee.
dbo.Billing_Item_Form_Type This table is used to hold the differnt form types used for creating form fees.
dbo.Billing_Item_Schedule The table used to store default schedule settings associated with a global schedule.
dbo.CSA_1099_Item_Map_To_W2_1099_Box_Pair Table that stores the CSA 1099 description and associates that with ACS 1099 items
dbo.Cch_Tax_Code_Map_To_Acs_Tax_Code Lists the different types of Cch codes.
dbo.Check_Date_Adjustment_Method
dbo.Check_Output_Type
dbo.Check_Print_Run
dbo.Check_Print_Run_N_Bank_Transaction Dictionary table which links a print run and related bank transactions.
dbo.Check_Template_Usage_Preference_Setting This table stores the usage settings used for payroll check templates, for when possibly initializing a payroll check based on a template, and for when possibly updating a payroll check template based on edits to a payroll check.
dbo.Checkbook Table which holds data related to clients bank accounts.
dbo.Child_Employee_Payroll_Item_N_Parent_Employee_Payroll_Item Linker from child employee payroll item to parent employee payroll item. Child employee payroll items get the values for calculation type and rates from the parent employee payroll item. The child and parent values cannot be the same. Parent items cannot also be children. Only pay type payroll items can be represented in this table. The employee payroll items in this table must be for the same employee. Parent items cannot be of special type weighted average overtime. The calculation types and rates must match between employee payroll items in the table as well as their distributions.
dbo.Child_Support_Order
dbo.Client
dbo.Client_1095 This table stores the client 1095 information.
dbo.Client_1095_Override This table stores the overrides for client 1095 information.
dbo.Client_1099_Override The table used to store Client overrides for the 1099s.
dbo.Client_1099_State_Override The table used to store the overrides for a Client's state id numbers.
dbo.Client_1099_State_Override_Type The table used to various types of Client 1099 state overrides.
dbo.Client_1099_Tax_Form_Information This table stores per-client selections regarding point-of-contact, signator, and some miscellaneous selections for the 1099 suite of forms.
dbo.Client_1099_Tax_Form_Selection This table stores selections by client, 1099 Type, and tax form collation (as a proxy for federal/state copies of 1099s) as to the filing method, the do-not-file selection, and the filing threshold.
dbo.Client_AP_Setup Client Accounts Payable Setup information table
dbo.Client_AR_Setup Table used to set up a client for use in accounts receivable
dbo.Client_Access_Notification This table stores the notifications created when certain types of actions are completed by the client in ACS Client Access.
dbo.Client_Access_Notification_Event_Type The table stores the actions completed by the client staff in ACS Client Access that will create notifications in the Client Access Notification Portlet
dbo.Client_Access_Notification_Review_Status This table stores the review status types of the Client Access Processing Notification.
dbo.Client_Bank_Reconciliation_Option
dbo.Client_Benefit
dbo.Client_Billing
dbo.Client_Billing_Item
dbo.Client_Billing_Item_Rate_Adjustment The table used to store rate adjustments related to a client billing item.
dbo.Client_Billing_Item_Schedule
dbo.Client_Billing_Sales_Tax
dbo.Client_Class
dbo.Client_Consolidation_Grouping_Type This table will hold values for the client consolidating grouping type
dbo.Client_Consolidation_Option This table will hold all the options for the consolidating master client
dbo.Client_Contact_Payroll_Administrator This table contains the details of Payroll Administrator checkbox selected in Additional Contacts.
dbo.Client_Contact_Payroll_Tax_Information The prescence of a record in this table for a given client contact indicates that the contact is the client payroll tax form signer.
dbo.Client_Delay_Direct_Deposit_Status_Type This table contains types of client delay direct deposit status
dbo.Client_Direct_Deposit
dbo.Client_File_Exchange_Portal_Ems_User This table says which NetClient users are associated with ACS Clients for File Exchange purposes. It lists which users will have their data available when accessing File Exchange data for an ACS client. An ACS Client may have many NetClient users associated with it.
dbo.Client_GL_Setup
dbo.Client_Inactive_Reason
dbo.Client_N_Client_Service_Type Table to subscribe services that the client belongs to
dbo.Client_N_Report_Folder Linker/Dictionary table that associates Client records with Report_Folder records.
dbo.Client_N_Staff List which firm staff are allowed access to each client.
dbo.Client_N_Subsidiary_Client This table will hold all the master client and their subsidiary client linked to them
dbo.Client_Onboarding_Property Contains information required to support communication with the MyPay Onboarding product. The Onboarding product is a wizard, hosted in Onvio, that collects data to be imported and create an SBPR client.
dbo.Client_Onvio_Payroll_Integration_Status Status types specifically for a Client that are used to signify the stages of operations related to Onvio Payroll.
dbo.Client_Pay_Schedule
dbo.Client_Pay_Schedule_Batch_Session This table holds identifiers for client pay schedules currently being processed in batch check entry to prevent multiple processing instances.
dbo.Client_Pay_Schedule_Detail
dbo.Client_Pay_Schedule_Displayable_Status The types in this table correspond to those in Client_Pay_Schedule_Status, but are used to display to the user.
dbo.Client_Pay_Schedule_Status
dbo.Client_Pay_Schedule_Type The type of Client Pay Schedule. Such as On Demand, Regular, or Handwritten.
dbo.Client_Payroll_Information
dbo.Client_Payroll_Information_Swipe_Clock_Details This table contains login/configuration["BR"] information related to Swipe Clock. This table has a 0..1 to 1 relationship with Client.
dbo.Client_Payroll_Information_Swipe_Clock_Partner_Login_Credentials This table contains login/configuration["BR"] information related to Swipe Clock. This table has a 0..1 to 1 relationship with Client.
dbo.Client_Payroll_Item
dbo.Client_Primary_Location
dbo.Client_Remote_Payroll_Setup
dbo.Client_Service_Type Table to name the services that the client can subscribe to
dbo.Client_Shortcut
dbo.Client_Staff_Intercept_Credentials Table for InterceptEFT credentials for client staff.
dbo.Client_Staff_Next_Id_Number Contains next ID number to use for auto-ID creation for client staff. Only has one record. Used only by SBPR.
dbo.Client_Synchronization This tables stores the last synchronization time per client.
dbo.Client_Synchronization_Type This table defines all of the client synchronization types used in the Client_Synchronization table.
dbo.Client_Tax_Item
dbo.Client_Tax_Item_Type Table containing Client Tax item types.
dbo.Client_Type
dbo.Client_Undistributed_GL_Account
dbo.Client_W2_Override The table used to store Client W-2 overrides.
dbo.Client_W2_Rendered_Document Table used to store pre-rendered documents which are included in the client W2 package; the federal transmittal documents (W3) and state/local client transmittals (names vary by locality)
dbo.Client_W2_Rendering_Queue This table acts as a queue of clients which require W2 document rendering.
dbo.Client_W2_State_Override The table used to store the overrides for a Client's state id numbers.
dbo.Client_W2_State_Override_Type The table used to various types of Client 1099 state overrides.
dbo.Code_Subcode_Type This table stores type definition for the account grouping.
dbo.Compare_Date_Type
dbo.Complete_Forms_Output_Session This table stores the information associated with a complete forms output session.
dbo.Complete_Forms_Output_Session_Client_Detail This table stores the client detail associated with a complete forms output session.
dbo.Complete_Forms_Output_Session_Status This table stores the complete forms output session status item types.
dbo.Complete_Payroll_Output_Liability_Payment_Method This tables describes methods for making liability payments.
dbo.Complete_Payroll_Output_Session Complete Payroll Output sessions that are currently in progress.
dbo.Complete_Payroll_Output_Session_Client_Detail This table stores the client detail associated with a complete payroll output session.
dbo.Complete_Payroll_Output_Session_Status This table stores the complete payroll output session status item types.
dbo.Connect_Alert This table stores alerts from CS Connect
dbo.Connect_Alert_Type The type of Connect Alert
dbo.Contact
dbo.Contact_Address
dbo.Contact_Address_N_Address This table links a contact address record to an address record.
dbo.Contact_Address_Payroll_Information
dbo.Contact_Address_Ste_Location_Code_History Table which holds residency history for employees - the lack of a record in this table indicates the current employee address is the only one.
dbo.Contact_Address_Type
dbo.Contact_Email
dbo.Contact_Email_Type
dbo.Contact_Phone
dbo.Contact_Phone_Type
dbo.Contact_Type
dbo.Conversion_Wizard_Client_Payroll_Information The conversion wizard has different screens where users select various options that affect the conversion of data from CSA. This table holds options concerning certain data that is held in the Client_Payroll_Information table.
dbo.Conversion_Wizard_Local_Withholding Stores local withholding conversion settings, both the source information and what it will be mapped to in SBPR.
dbo.Conversion_Wizard_Segment_Choice The conversion wizard has different screens where users select various options that affect the conversion of data from CSA. This table holds the options pertaining to what segments of the CSA date should be converted, such as employees, payroll items or conversions.
dbo.Copy_From_VO_Destination_Path This table will hold the destination paths selected by each user for each file type when using Copy Files.
dbo.Copy_From_VO_Source_Type Copy From VO Source Type table.
dbo.Country_Code Type table for ISO 3166-1 country codes.
dbo.Creditor_Garnishment_Order Contains creditor garnishment orders for employee payroll items.
dbo.Csa_Account_Group_Map_To_Classification_Code This table stores the classification code/subcode mappings for CSA account groups.
dbo.Csa_Staff_Map_To_Acs_Staff This table stores the staff Id/staff name mappings for CSA staff.
dbo.Custom_Excel_Grid This table will hold data for custom excel grid
dbo.Custom_Excel_Template Templates saved in this table are at firm level i.e. available for all clients.
dbo.Custom_Excel_Template_Amount_Data This table provides additional data about entries in table Custom_Excel_Template_Data which shall exist EXACTLY when the trial_balance_grid_column_type_KEY column of that table is 3 (Amount)
dbo.Custom_Excel_Template_Data A row in this table corresponds to a mapped column in the Custom Excel Template
dbo.Custom_Field ["BR"]Defines custom fields, allowing users to attach custom data to various business objects["BR"]without altering schema. The kind of business object being extended is identified by["BR"]the "owner_table_name".
dbo.Custom_Field_Type
dbo.Custom_Fieldview
dbo.Custom_Fieldview_Type
dbo.Custom_Grouping
dbo.Custom_Office_Account_Grouping This table will store all the grouping and grouping codes for the custom excel grid if the grid is grouped by account grouping
dbo.Custom_Office_Grid_Column_Relation_Operator_Type This table stores column operation operator types. This table is used for custom Excel workpapers only and does not apply to trial balance.
dbo.Custom_Office_Grid_Column_Relation_Option This table stores custom Office workpaper relation option for columns that are relation type. This table is used for custom Excel workpapers only and does not apply to trial balance.
dbo.Custom_Office_Grid_Column_Segment This table stores gl account segment and gl account segment code keys for a custom office grid column. This table is used for custom Excel workpapers only and does not apply to trial balance.
dbo.Custom_Portlet
dbo.Custom_Portlet_Type
dbo.Custom_Value
dbo.Custom_Value_Client This table links a client to one of the custom values associated with it.
dbo.Custom_Value_Client_Staff This table links a client staff (ACS or CSS) to one of the custom values associated with it.
dbo.Custom_Value_Customer This table links a customer to one of the custom values associated with it.
dbo.Custom_Value_Employee This table links a employee to one of the custom values associated with it.
dbo.Custom_Value_Firm This table links a employee to one of the custom values associated with it.
dbo.Custom_Value_Staff This table links a vendor to one of the custom values associated with it.
dbo.Custom_Value_Vendor This table links a vendor to one of the custom values associated with it.
dbo.Customer A client specific table that stores the setup information defining a customer.
dbo.Customer_Historical_AR_Transaction This table stores the link to any AR Transactions that are considered historical transactions for a customer.
dbo.Data_Entry_Confirmation Lists the types of data for which Data Entry Confirmation is supported and on which ones it is enabled.
dbo.Data_Entry_Method This table contains the possible tabs for a screen.
dbo.Data_Location_Profile Definitions of the Net Client Data Location Profiles.
dbo.Data_Origin This table enumerates possible origins of certain data (for example, bank transactions or journal entries) in the database.
dbo.Database_Property
dbo.Date_Filter_Value_Type This table defines all of our date filter types for use in the date filter dropdown.
dbo.Date_Format
dbo.Deduction_Item Client payroll item properties applicable only to a deduction payroll item.
dbo.Deduction_Type
dbo.Default_Date_Option Options for default date settings.
dbo.Deposit_Due_Within This table stores information on whether deposits are due within three or five banking days.
dbo.Direct_Deposit_Bank_Transaction
dbo.Direct_Deposit_Bank_Transaction_Allocation
dbo.Direct_Deposit_Bank_Transaction_Allocation_Distribution This table stores off location/department portions of the values in the Direct_Deposit_Bank_Transaction_Allocation table. These values are distributed based on the payroll item portion per location/department of the net check amount.
dbo.Direct_Deposit_Distribution_Method Type table for direct deposit distribution method..
dbo.Direct_Deposit_Fileheader
dbo.Direct_Deposit_Fundable_Transaction This table's purpose is to allow the direct deposit funding UI to use the standard filtering mechanism.["BR"] WARNING - if this table is modified, use-defined table type dbo.Direct_Deposit_Fundable_Transactions and stored procedure["BR"] dbo.pb_Insert_Direct_Deposit_Fundable_Transactions also needs to be updated to maintain identical structure.
dbo.Direct_Deposit_Method
dbo.Direct_Deposit_Processable_Transaction This table's purpose is to allow the direct deposit processing UI to use the standard filtering mechanism.["BR"] WARNING - if this table is modified, use-defined table type dbo.Direct_Deposit_Processable_Transactions and stored procedure["BR"] dbo.pb_Insert_Direct_Deposit_Processable_Transactions also needs to be updated to maintain identical structure.
dbo.Direct_Deposit_Processing_Locked_Transaction This table holds transaction identifiers for direct deposit transactions currently being processed to prevent multiple processing instances.
dbo.Direct_Deposit_Processing_Locked_Transaction_Type This table holds keys for direct deposit processing locked transaction types
dbo.Direct_Deposit_Status
dbo.Do_Not_Pay_Reason This table stores various types of DNP(do not pay) reasons.
dbo.Document_Management_System_Print_Category This table defines all of our print categories supported for outputting to various Document Management Systems.
dbo.Document_Management_System_Value_Type This table defines all supported value types when outputting to various Document Management Systems.
dbo.Duplicate_Treatment Duplicate Treatment types table
dbo.Eftps_Transaction
dbo.Elf_File Holds Electronic file records. These records are stored outside the database and also transmitted to the Connect server.
dbo.Elf_Transmission
dbo.Elf_Transmission_Status
dbo.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"
dbo.Employee
dbo.Employee_1095 This table stores the employee 1095 information.. The schema for this table must be kept synchronized with Employee_1095_Override for year/month specific fields. A null in one of these year/month specific fields in this table means that it is not set for the employee. A particular year/month group can be all null if is does not apply. Alternatively, the year field can be null with at least some of the months filled in. Lastly, the year field can be non-null and the corresponding month fields are null.
dbo.Employee_1095_Covered_Individual This table stores the employee 1095 Part 3 covered individual information. The form has a single field for name. But the electronic filing requires first name and last name. Suffix is there to distinguish between people with same first and last names.
dbo.Employee_1095_Override This table stores the overrides for employee 1095 information. The schema for this table must be kept synchronized with Employee_1095 for year/month specific fields. A null in one of these year/month specific fields means thatit is not overridden.
dbo.Employee_Benefit
dbo.Employee_Direct_Deposit_Allocation
dbo.Employee_Earning_Type The table used to store the employee earning type options.
dbo.Employee_Event
dbo.Employee_Event_Type
dbo.Employee_Federal_Levy_Information This table is required for employee payroll items that are of garnishment type Federal levy. It holds information about the federal levy
dbo.Employee_Independent_Contractor_Reported The table used to store when an employee has been reported to be an independent contractor.
dbo.Employee_Multi_State_Income_Tax_Calculation_Method This is a type table of options for how an employee's multi-state income tax will be calculated. Each record maps to an available option in the Symmetry calculation engine to configure it to calculate as desired.
dbo.Employee_Other_State_Setting
dbo.Employee_Other_State_Setting_Type
dbo.Employee_Other_State_Setting_Type_Group
dbo.Employee_Payroll_Item
dbo.Employee_Payroll_Item_Direct_Deposit_Allocation Holds direct deposit allocation data for an employee payroll item.
dbo.Employee_Payroll_Item_Distribution Table that supports multiple rates/amount/percents as well as GL accounts for work location/payroll department combinations (for Employee_Payroll_Item).
dbo.Employee_Payroll_Item_Garnishment_Order Contains each garnishment order amount per employee payroll item.
dbo.Employee_Payroll_Item_N_Payroll_Item_Special_Timing This dictionary table associates a employee payroll item record with a payroll item special timing record. All employee payroll items will have a special timing row associated with it except payroll items of type garnishment.
dbo.Employee_Political_Subdivision_Code_Override This table stores override values for employee political subdivision codes. The employee can have at most one override for each client tax item.
dbo.Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override Track employee reconciliation form overrides from the employee detail view grid
dbo.Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount Provide employee reconciliation form override monthly overrride amounts from the employee detail view grid
dbo.Employee_Self_Service_1095_Queue Table which persists employee 1095 pdf forms until they are transmitted to the Employee Self-Service portal
dbo.Employee_Self_Service_1099_Queue Table which persists employee 1099 pdf forms until they are transmitted to the Employee Self-Service portal
dbo.Employee_Self_Service_W2_Queue Table to track employee w2 forms pending transmission to ESS
dbo.Employee_Service_Level_Type
dbo.Employee_Sort_By_Type
dbo.Employee_Tax_Form_Locality_Amount_Override Track employee reconciliation form local overrides from the employee detail view grid
dbo.Employee_Tax_Form_Locality_Amount_Type The table used to store the employee local amount types.
dbo.Employee_Tax_Item
dbo.Employee_Tax_Item_Distribution Table that supports multiple GL accounts for work location/payroll department combinations (for Employee_Tax_Item).
dbo.Employee_Tax_Jurisdiction
dbo.Employee_Taxable_Wage_Adjustment This table will hold an employee's adjustments to ytd gross taxable wages and ytd taxable wages.
dbo.Employee_Taxable_Wage_Adjustment_Tax_Selection This table holds the tax item (federal/state/local) selection that the user wants the adjustments applied to.
dbo.Employee_Tip_Allocation The table used to store employee-level tip allocation data and overrides.
dbo.Employee_Tip_Total The table used to store client level information for employee tip allocations (employee tip allocation totals).
dbo.Employee_Type Table used to store the status of the an employee record.
dbo.Employee_W2_Box_12_Other_Item A table to hold Box 12 other items for employees. This allows Box 12 items without association to a pay item
dbo.Employee_W2_Box_12_Override The table used to store the overrides for an Employee's box 12 information.
dbo.Employee_W2_Box_14_Other_Item A table to hold Box 14 other items for employees. This allows Box 14 items without association to a pay item
dbo.Employee_W2_Box_14_Override The table used to store the overrides for an Employee's box 14 information.
dbo.Employee_W2_In_Process_Rendering_Queue This table acts as a queue of employees which are in the process W2 document rendering. It provides the ability to roll the employees back into the Employee_W2_Rendering_Queue table if the w2 rendering user session dies, or the cron task is cancelled.
dbo.Employee_W2_Override The table used to store the overrides for an Employee's W-2 information.
dbo.Employee_W2_Rendered_Datashare Table used to store pre-rendered employee datasharing xml that will be exported for import by other applications.
dbo.Employee_W2_Rendered_Document Table used to store pre-rendered employee W2 documents.
dbo.Employee_W2_Rendering_Queue This table acts as a queue of employees which require W2 document rendering.
dbo.Employee_W2_Tax_Jurisdiction_Override The table used to store the overrides for an Employee's state information.
dbo.Employee_W2_Verification_Dates This table stores the dates the employee information has been verified for w2s
dbo.Employee_W4_Setting
dbo.Employee_W4_Setting_Parameter
dbo.Employee_Work_Location_Payroll_Department
dbo.Employee_Worker_Compensation_Item
dbo.Employee_Worker_Compensation_Item_Distribution Holds the distribution of employee worker compensation items across multiple work locations
dbo.Employer_Contribution_Item table containing Insurepay, XactPay employer contribution type information .
dbo.Employer_Jurisdiction_Payroll_Tax_Information
dbo.Employer_Type
dbo.Ems_User Contains information on NetClient users that we mirror in ACS.
dbo.Engagement_Binder This table contains information needed for storing engagements and their data.
dbo.Engagement_Binder_N_Staff This table stores information about staff assigned to work on an Engagement and their assigned roles.
dbo.Engagement_Binder_Status This table contains information needed for describing the states of the Engagement_Binder.
dbo.Engagement_Binder_Tree_Item This will contain the data representing the tree structure for each client. It should never be written to in client code. All writes will happen through known SQL stored procedures.
dbo.Engagement_Folder_Type This table stores information about the possible roles a folder can play in an engagement binder.
dbo.Engagement_Item_Note This table stores the information about the association of notes with either the binder, the folder or the workpaper.
dbo.Engagement_Item_Note_Status This table contains information needed for describing the states a note can have.
dbo.Engagement_Tree_Column_Selector stores the order of columns as well as which columns will be displayed.
dbo.Engagement_Tree_Static_Column Stores the static column types that will always be available to users.
dbo.Engagement_Type This table contains information needed for describing the various states of an engagement binder.
dbo.Engagement_View_Classification This is a type table that describes the different types of views that will use the engagement tree column selector table.
dbo.Engagement_Workspace_Tab Stores foreign key to user preference table and description for each engagment workspace tab.
dbo.Enter_AR_Deposit_Option This table contains options used on the Enter AR Deposit screen.
dbo.Enter_Transaction_Data_Entry_Mode This table enumerates the different modes of data entry methods for Enter Transaction.
dbo.Enter_Transaction_Data_Entry_Session_Element This table keeps track of the gl transaction keys that make up a staff member's current data entry session.
dbo.Enter_Transaction_Default_Distribution_Description_Type This table enumerates the different types of descriptions for distributions to default to for Enter Transactions.
dbo.Enter_Transaction_User_Preference This table is used to hold options for the data entry of Enter Transaction.
Error_Log Surrogate Key, Primary Key, Clustering Key, Identity constraint. This column is maintenance for referential integrity and serves no exterial buisness constraint.
dbo.Event_Class_Type
dbo.Event_Type
dbo.Export_Destination This table enumerates the different types of export destinations that are available when we export data. Examples of export destinations: CS Professional Suite Accounting, and quickbooks.
dbo.Export_Journal_Entry_To_Csa_Format
dbo.Export_Journal_Entry_To_Csa_Information
dbo.Export_Journal_Entry_To_Csa_Status
dbo.Export_Text_File_Format This table contains file formats for text files. These text files are used to export data out of the database. For example, Positive Pay type text file formats are used to export bank transaction information to financial institutions that support it.
dbo.Export_Text_File_Format_Column_Definition This table contains column definitions for a given row in a text file format. Each text file format row definition can have one or more columns defined.
dbo.Export_Text_File_Format_Export_Data This table lists the data available to be exported from the database. The first entry in this table is special; it indicates that the desired information is not available in our database.
dbo.Export_Text_File_Format_Row_Definition This table contains row definitions for a given text file format. Each text file format can have one or more row definitions. For example, a definition that defines the format of rows in the header section of the file and a definition that defines the format of rows in the detail section of the file.
dbo.Export_Text_File_Format_Type This type table lists the kinds of text file formats supported by the system.
dbo.Export_User_Preference This table stores export user preferences.
dbo.Federal_Levy_Exemption_Amount This table stores federal levy exemption values that will be updated via schema update when tax laws change these values. These values determine how much of an employees pay is exempt from federal levies.
dbo.Federal_Levy_Exemption_Type Table for federal levy exemption type
dbo.Federal_Tax_Exemption
dbo.Federal_Tax_Exemption_Type
dbo.Federal_Unemployment_Tax_Exemption_Type
dbo.File_Location
dbo.File_Storage This table contains information needed for storing files.
dbo.File_Storage_Data This table holds the file data referenced in the File_Storage table.
dbo.Filter
dbo.Filter_Base_Type
dbo.Filter_Line
dbo.Filter_Line_Type
dbo.Filter_Range
dbo.Filter_Range_Cache
dbo.Filter_Range_Type
dbo.Filter_Select
dbo.Filter_Selection Table used to store information about filters in use during the last user session.
dbo.Filter_Selection_Type Table storing the different locations the user might use filters.
dbo.Filter_Type
dbo.Finance_Charge_Date_Basis This table stores the types of dates that finance charges can be calculated from.
dbo.Finance_Charge_Definition A client specific table that stores the setup information defining a finance charge, which is used to calculate fees on overdue balances.
dbo.Finance_Charge_Grace_Period_Basis This table stores the unit types of finance charge grace period.
dbo.Firm This table contains all the firm level information.
dbo.Firm_Additional_Contact_Role This table is used to save various roles to the Additional Contacts they set up on their clients
dbo.Firm_Contact_Payroll_Tax_Information
dbo.Firm_Electronic_Filing_Information
dbo.Firm_Notification_Additional_Contact_Role This table stores additional contact roles which are applicable to the notification type.
dbo.Firm_Notification_Hourly_Pay_Rate A table to store standard hourly pay rate used as a threshold in determining if an alert is needed.
dbo.Firm_Notification_Information This table stores firm level settings related to what types of alerts and notifications should be provided for various scenarios.
dbo.Firm_Notification_Other_Address This table stores information about the firm level other email addresses that notifications should be sent to.
dbo.Firm_Preferences_Swipe_Clock_Partner_Login_Credentials This table contains partner login["BR"] information/credentials associated with SwipeClock application, needed while establishing connection from ACS. This["BR"] table has a 0..1 to 1 relationship with Firm.
dbo.Firm_Preferences_Workforce_Hub_Login_Credentials This table contains login credentials used for WorkforceHUB.
dbo.Firm_Shortcut
dbo.Firm_Transitory_Information This table stores firm information that changes often. Updates to the firm table can cause blocking if other long running queries are ongoing.
dbo.Folder This table contains information needed for describing a folder in the engagement binder tree.
dbo.Folder_N_Source_Document_Processing_Sort_Order this table stores the linking information between Folder table and Source Document Processing Sort Order table.
dbo.Folder_N_Source_Document_Processing_Tax_Organizer_Sort_Order This table stores the linking information between Folder table and Source Document Processing Tax Organizer Sort Order table.
dbo.Form_1094_Section_4980H_Code This table stores the 1094 section 4980H code selections.
dbo.Form_1094c_Aggregate_Group An aggregate group is made up of related companies that have different EINs but must be considered one entity ["BR"] for determining if they are subject to the Affordable Care Act. ["BR"] Example: TRTA and myPay have their own EINs but are considered part of Thomson Reuters for purposes of the Affordable Care Act.
dbo.Form_1094c_Aggregate_Group_Member A client in the database that is associated with an aggregrate group for Affordable Care Act purposes.
dbo.Form_1094c_Aggregate_Group_Member_Outside_Database Aggregate group members who are not stored as a client in the database
dbo.Form_1095_Corrected_Type This table stores the valid values for corrected types of ACA 1095 forms.
dbo.Form_1095_Coverage_Code This table stores the 1095 coverage code selections.
dbo.Form_1095_Coverage_Code__Individual_Months This table stores the 1095 coverage codes that are valid for individual months.
dbo.Form_1095_Safe_Harbor_Code This table stores the 1095 safe harbor code selections.
dbo.Form_1095_User_Preference This table form 1095 user preferences.
dbo.Form_1096_Client_Copy_Type Table to identify the copy type used when printing the client copy for the 1096.
dbo.Form_1098_C_Option This table stores the detailed options for 1098 C form.
dbo.Form_1098_E_Option This table stores the detailed options for 1098 E form.
dbo.Form_1098_Option This table stores the detailed options for 1098 form.
dbo.Form_1098_T_Option Table for 1098-T form specific data
dbo.Form_1099 The parent table for the print options of all the myriad 1099 forms. Each of the forms have a unique set of options so this parent table provides a common foreign key that all schema referencing 1099 print options can use.
dbo.Form_1099_A_Option Detailed options for 1099-A form
dbo.Form_1099_B_Box_1F_Code Form 1099 B Box 1F codes.
dbo.Form_1099_B_Form_8949_Code Form 1099 B 8949 codes.
dbo.Form_1099_B_Option Detailed options for 1099-B form.
dbo.Form_1099_C_Event_Code Table for identifiable event code options for the 1099-C
dbo.Form_1099_C_Option Table for 1099-C form specific data
dbo.Form_1099_Copy_A_Client_Copy_Type Table to identify the copy type used when printing the client copy for the 1099 Copy A.
dbo.Form_1099_Correction_Type This table stores the 1099 correction types.
dbo.Form_1099_Div_Option Detailed options for 1099-Div form
dbo.Form_1099_G_Option Detailed options for 1099-G form
dbo.Form_1099_Int_Option Detailed options for 1099-INT form
dbo.Form_1099_Misc_Option The specific options for printing a 1099 MISC form.
dbo.Form_1099_Nec_Option The specific options related to a 1099 NEC form.
dbo.Form_1099_Oid_Option Detailed options for 1099-OID form
dbo.Form_1099_Original_Efile_Transmission_Information Table that holds the values of previous e-file transmission information for relevant 1099 recepients. In a chain of of three or more filings (for two or more rounds of correction) this holds data about the most recent version being corrected.
dbo.Form_1099_Override_Type This table stores the 1099 form override types.
dbo.Form_1099_Patr_Option Detailed options for 1099-PATR form
dbo.Form_1099_Print_Threshold_Override This table contains the valid 1099 box combinations available for use on bank transactions for a particular vendor.
dbo.Form_1099_R_Distribution_Code Distribution codes for the 1099-R form, box 7
dbo.Form_1099_R_Distribution_Code_Map Ties first distribution codes to the potential options for second distribution code
dbo.Form_1099_R_Option Detailed options for 1099-R form
dbo.Form_1099_S_Option Detailed options for 1099-S form
dbo.Form_1099_Sa_Distribution_Code Distribution codes for the 1099-Sa form, box 3
dbo.Form_1099_Sa_Option Detailed options for 1099-SA form
dbo.Form_5498_Fmv_Code Form 5498 fair market value (FMV) codes.
dbo.Form_5498_Option Detailed options for 5498 form
dbo.Form_5498_Other_Contribution_Code Table for the other contribution codes for the 5498
dbo.Form_5498_Repayment_Code Table for the repayment codes for the 5498
dbo.Form_5498_Sa_Option The specific options for printing a 5498 SA form.
dbo.Form_7200_Payment_Requested This table stores the payments requested (possibly multiple payments per quarter) by means of filing form 7200 during any valid period. Form 7200 was introduced related to the advance payment for COVID-19 relief.
dbo.Form_Processing_Run This table holds the data for each form processing run.
dbo.Form_Processing_Run_Form_Count This table holds the data needed for recreating, modifying, and creating new fees based on historical data.
dbo.Form_W2G_Option Table to set various options on the W-2G form.
dbo.Form_W2G_Wager_Type Table to identify the various types of wagers for use by the W-2G.
dbo.Fund_Payroll_Transaction_Type The type of payroll transaction funding to be performed. Payroll funding can be done on the entire transaction, or the direct deposit or net check portion only.
dbo.Funded_Transaction_Type Table holds values for the types of transactions that can be funded.
dbo.Funding_Processed_Status Type table for funding processed status.
dbo.Funding_Processed_Status_Filter_Type
dbo.Funding_Withdrawal_Bank_Transaction_Detail
dbo.Funding_Withdrawal_Liability_Detail
dbo.GL_Account
dbo.GL_Account_Budget This table records the budget and its amount for a gl_account in a gl_period
dbo.GL_Account_Budget_Category This table stores type definition to Budget Buckets
dbo.GL_Account_Budget_Category_Name_Override This table records the override name for client budget buckets
dbo.GL_Account_Classification_N_GL_Account_Grouping_Code Dictionary table for connecting GL_Account_Grouping_Subcode to GL account grouping code for mapping.
dbo.GL_Account_Classification_N_GL_Account_Grouping_Code_Subcode Dictionary table for connecting GL account to GL account grouping subcode through the code dictionary table for subcodes that are not Account Classification subcodes.
dbo.GL_Account_Classification_N_Tax_Code Connects a gl account grouping subcode to the tax code
dbo.GL_Account_Classification_N_Tax_Code_M3 Connects a gl account classification subcode to an M3-A tax code.
dbo.GL_Account_Csa_Account_Number This table stores the csa account number for a gl account.
dbo.GL_Account_Grouping Complete set of Account Groupings for a client and global
dbo.GL_Account_Grouping_Category This table is used To allow categories to be assigned to account grouping codes
dbo.GL_Account_Grouping_Code Complete set of Account Groupings Codes/Classes for a client and global
dbo.GL_Account_Grouping_Code_Type Extension of the GL_Account_Grouping_Code table to hold the Type for the standard classification codes and the default codes for each Type
dbo.GL_Account_Grouping_Csa_Description This table stores the csa description for a gl account grouping.
dbo.GL_Account_Grouping_Subcode Complete set of Account Groupings Subcodes/subclasses for a client and global
dbo.GL_Account_Hierarchy_Type The type table used to differentiate the different GL account hierarchies supported via the GL_Account_Parent table. Currently there are two types: Core account and User defined. The Core Account hierarchy will associate a core account number with its posting account numbers. This information will be system maintained based on the user's selected core account segment and the account numbers entered into the Chart. The User-defined hierarchy will be maintained by the user and will represent whatever concept they wish it too (thus the name user-defined!). Both hierarchies are limited to one generation. That is, a parent can't be a child and a child can't be a parent.
dbo.GL_Account_N_GL_Account_Grouping_Code Dictionary table for connecting GL account to GL account grouping code for codes that are not Account Classification codes.
dbo.GL_Account_N_GL_Account_Grouping_Code_Subcode Dictionary table for connecting GL account to GL account grouping subcode through the code dictionary table for subcodes that are not Account Classification subcodes.
dbo.GL_Account_N_GL_Account_Segment_Code
dbo.GL_Account_Parent The parent child relationships of the GL Account table.
dbo.GL_Account_Segment
dbo.GL_Account_Segment_Code
dbo.GL_Account_Segment_Code_N_Quick_Books_Class This table shows the export mapping of gl account segment codes to quick books classes. A gl account segment code key is used only once in the mapping per client, so this can be the primary key. The quick books class key can be used one or more times in the mapping.
dbo.GL_Account_Segment_Code_Rounding_Account Table to hold different type of account keys we will use for rounding on the financial statement, Report and Trial balance grid.
dbo.GL_Account_Segment_Csa_Description This table stores the csa description for a gl account segment.
dbo.GL_Account_Standard_Segment
dbo.GL_Account_Tickmark This table contains the connection between a GL account and a tickmark.
dbo.GL_Account_Type
dbo.GL_Account_Workpaper_Reference This table contains the connection between a GL account and workpaper reference.
dbo.GL_Accounting_Method
dbo.GL_Balance_Calculation_Method Journal Entry Template Source Account Calculation Types - enumerates the supported summation methods for calculating the source amount
dbo.GL_Balance_Effect This table stores type definition for the balances.
dbo.GL_Balancing_Entry This table stores the balancing entry for one or more bank transactions. In the land of GL, bank transactions are created as unbalanced journal entries until such time as the user chooses to balance them. Balancing entails creating a GL balancing entry row that sums to the total of the selected bank transactions. These bank transaction must always belong to the same checkbook and said checkbook's GL account number is used to create a journal entry that balances the selected unbalanced bank transactions.
dbo.GL_Balancing_Entry_N_Bank_Transaction This dictionary table links a GL balancing entry with the one or more bank transactions that the entry balances.
dbo.GL_Balancing_Entry_Type This table enumerates the different types of balancing journal entries that can be created in the system.
dbo.GL_Fiscal_Year
dbo.GL_Period
dbo.GL_Period_Key_Old_To_New_Map This is a staging table used only for remapping GL period foreign keys for a particular client. After the foreign keys are remapped, the rows in this map table are removed.
dbo.GL_Period_Type
dbo.GL_Transaction This table contains all additional GL transaction specific details that the originating source transaction (bank transaction, payable transaction, journal entry transaction, etc) does not contain.
dbo.GL_Transaction_N_Bank_Transaction This dictionary table associates a bank transaction with its associated GL transaction specific detail.
dbo.GL_Transaction_N_GL_Balancing_Entry This dictionary table associates a balancing entry transaction with its associated GL transaction specific detail..
dbo.GL_Transaction_N_Journal_Entry This dictionary table associates a jouranl entry transaction with its associated GL transaction.
dbo.GL_Transaction_N_Payable_Transaction Table for linking the gl transaction table to payable transaction table.
dbo.GL_Transaction_Note
dbo.GL_Transaction_Type This table gathers together all the transaction types supported by the application. These type values are also stored in several separate type tables (Bank_Transaction_Type, Journal_Entry_Type, etc).
dbo.Garnishment_Order Contains the garnishment information order(s) for each valid garnishment type employee payroll item.
dbo.Garnishment_Type
dbo.Gender_Type
dbo.Global_Report_Profile This table holds the primary key, description and report profile type of every global report profile.
dbo.Global_Report_Profile_Element This table will contain an entry for each report contained within a report profile. Each entry will have a key to link to a report definition, and a report option xml file. Together, the report definition xml and the report option xml describe how to print a report.
dbo.Global_Report_Profile_N_Report_Profile This table will have an entry for every report profile which has been overridden for a particular client. If there are not cient-specific overrides for a profile, then that profile will have no entries in this table.
dbo.Graduated_Payroll_Item_Tier
dbo.Grid_Account_Selection_Type This table will hold values for the custom excel grid account selection type
dbo.Health_Plan_Type Types of health plans available for payroll items.
dbo.Holiday_Definition
dbo.Holiday_Definition_Default
dbo.Hot_Key This table will be used to keep track of the hot keys for the system
dbo.Import_Method This table enumerates the different types of import methods that may be available when we import data. The import method tells us more about from where we are physically retrieving the data.
dbo.Import_Source This table enumerates the different types of import sources that are available when we import data. Examples of import sources: Client Bookkeeping Solution, and QuickBooks.
dbo.Import_Template Parent record for user-defined Import Templates.
dbo.Import_Template_Column Parent record for user-defined Import Templates.
dbo.Import_Template_Column_1095C_Data
dbo.Import_Template_Column_AR_Item_Data Specifies information about user defined template columns for spreadsheet import of invoice items. Only import template column rows of type Discount, Other Charge, Shipping, Sales Tax will have an associated rows in this table.
dbo.Import_Template_Column_AR_Transaction_Item_Data Specifies information about user defined template columns for spreadsheet import of AR Transactions invoice items. Only import template column rows of type Item, Shipping will have an associated rows in this table.
dbo.Import_Template_Column_Check_Number_Data This table stores information about the user-defined template coulumns that are imported for each check
dbo.Import_Template_Column_Customer_Data This table stores information of user defined template columns for spreadsheet import of customer.
dbo.Import_Template_Column_Employee_Data This table stores info for employees excel import grid headers
dbo.Import_Template_Column_GL_Account_Data This table stores info for chart of accounts excel import grid headers
dbo.Import_Template_Column_Payroll_Item_Data List of payroll items(deductions and pay item) and their types associated with a template column.
dbo.Import_Template_Column_Tax_Item_Data List of tax items and their types associated with a template column.
dbo.Import_Template_Column_Type Lists the types of column data available for importing.
dbo.Import_Template_Column_Vendor_Data This table stores information of user defined template columns for spreadsheet import of Vendor.
dbo.Import_Template_Type Lists the types of data available for importing.
dbo.Import_User_Preference This table stores the import user preferences on a per staff member basis.
dbo.Impound_Payment_Client_Bank_Transaction_Detail
dbo.Impound_Profile Firm level profiles assignable to clients that enforce how early payroll processes need to be run.
dbo.Initial_Open_Item_Bank_Transaction This table holds additional information needed only by an Initial Open Item bank transaction.
dbo.Insurepay_Accruable_Benefit_Type Table containing InsurePay accruable benefit types.
dbo.Insurepay_Client Table containing client specific InsurePay consent information.
dbo.Insurepay_Client_Class_Code Table containing InsurePay client specific class code.
dbo.Insurepay_Client_Class_Code_N_Client_Benefit Table is a dictionary table for insurepay_client_class_code_KEY and client_benefit_KEY.
dbo.Insurepay_Client_Class_Code_N_Client_Payroll_Item Table is a dictionary table for insurepay_client_class_code_KEY and client_payroll_item_KEY.
dbo.Insurepay_Client_Class_Code_N_Employee_Payroll_Item Table is a dictionary table for insurepay_client_class_code_KEY and employee_payroll_item_KEY
dbo.Insurepay_Employer_Contribution_Type Table containing InsurePay employer contribution types.
dbo.Insurepay_N_Payroll_Bank_Transaction A dictionary table to map Insurepay_Payroll_Transmission and Payroll_Bank_Transaction, so that each check item in the payroll file will have an entry here.
dbo.Insurepay_Pay_Item_Type Table containing Insurepay pay item types.
dbo.Insurepay_Payroll_Transmission Table containing client specific InsurePay payroll file information.
dbo.Insurepay_Payroll_Transmission_Result Table containing client specific InsurePay payroll transmission result information.
dbo.Insurepay_Setup_Transmission Table containing client specific InsurePay setup information.
dbo.Insurepay_Setup_Transmission_Result Table containing client specific InsurePay setup transmission result information.
dbo.Invoice_Printing_Default_Option
dbo.Journal
dbo.Journal_Entry Table for journal entries
dbo.Journal_Entry_Distribution Table for journal entry distributions
dbo.Journal_Entry_Event Table for journal entry events.
dbo.Journal_Entry_Event_Type Table containing journal entry event types.
dbo.Journal_Entry_Misstatement_Type Journal Entry Misstatement Types - enumerates the supported types of misstatments for journal entries
dbo.Journal_Entry_Reversal This table stores links between an journal entry that has been reversed and its journal entry reversal.
dbo.Journal_Entry_Template Contains Journal Entry specific template information.
dbo.Journal_Entry_Template_Automatic_Percentage_Distribution Journal_Entry_Template_Automatic_Percentage_Distribution - allocates a percentage of the source amount to a gl account.
dbo.Journal_Entry_Template_Automatic_Percentage_Source_Account Journal_Entry_Template_Automatic_Percentage_Source_Account - source account information used in the calculation for automatic percentage journal entries.
dbo.Journal_Entry_Type Journal Entry type table.
dbo.Journal_Filter_Value_Type This table defines all of our journal filter types for use in the journal filter dropdown.
dbo.Journal_N_Checkbook Table linking the Journal and Checkbook tables
dbo.Known_Application_Extension This table contains the known application extensions (i.e. excel has xls and xlsx, word as doc and docx, etc...).
dbo.Known_Application_Type This table contains the known application types (i.e. excel, word, etc...).
dbo.Lacerte_Tax_Code_Map_To_Acs_Tax_Code Lists the different types of Lacerte codes.
dbo.Ledger_Entry
dbo.Ledger_Entry_Type
dbo.Length_Of_Service_Selection
dbo.License Contains information about the firm's current licenses. Client Access products can't see license files but sometimes need to know which licenses exist. This was created to support ACS Client Acces PR Only.
dbo.Limit_Calculation_Type
dbo.Limit_Period_Type This tables holds the limit periods.
dbo.Local_Tax_Exemption
dbo.Local_Tax_Exemption_Type This table contains the list of local taxes defined in the Tax_Code_Type table. Is it used to determine tax exemptions.
dbo.Location
dbo.Location_Search_Accuracy_Type This table holds the values specifying a location search accuracy.
dbo.Login_Ticket Single-use login tickets which can be used in lieu of a password for authentication.
dbo.Magnetic_Media_Client_Record
dbo.Magnetic_Media_File
dbo.Magnetic_Media_File_Client
dbo.Magnetic_Media_File_Client_Type Table to store the various types of Magnetic Media Clients that can exist in a magnetic media file
dbo.Magnetic_Media_File_N_Tax_Agent Table a link between magnetic media files and tax agents.
dbo.Magnetic_Media_File_Record
dbo.Magnetic_Media_File_Status
dbo.Manage_AP_Payment_Grid_Column This tables records are only added during schema updates. It contains records that corresponds to columns in the Mange AP Payment Options.
dbo.Manage_AP_Payment_Grid_User_Option This table holds preferences, per user, per client, on which columns are shown in the Manage AP Payment grid.
dbo.Manage_AP_Payment_Option This table holds preferences per client for Manage AP Payments.
dbo.Manage_AP_Payment_Processable_Transaction reasons for the Manage_AP_Payment_Processable_Transaction table It has been recommended that the best way to provide a data source for the Manage AP Payments rapid tab grid is with a special database table which will exist only for the purpose of feeding the datasource to the grid, and to facilitate filtering in our system. Such a table is sometimes called a ?temporary? table. It is permanently in the database, but holds data only temporarily, while the Manage Payments view is displayed. This table holds a combination of payment and payable transactions for a given client. The payment and payable transactions will each have a gross open balance amount that has not yet been reduced to zero. These transactions will be paired together so that they can be applied, that is, the payable gross amount will be reduced and the payment gross amount will be reduced in tandem.
dbo.Manage_AP_Payment_User_Preference This table holds preferences per user per client for Manage AP Payments.
dbo.Manage_Customer_Payment This table holds temporary data that only exists as long as the current user session exists. This table also has a DAL bypass to aid in the performance of high row count inserts. No DAL constraints should be added to this table. WARNING - if this table is modified, use-defined table type dbo.Manage_Customer_Payment_Rows and stored procedure dbo.pb_Insert_Manage_Customer_Payment_Rows also need to be updated to maintain identical structure
dbo.Manual_Funding_Bank_Transaction Holds manual funding transaction data - used to created bank transactions when manual funding is processed.
dbo.Manual_Funding_Bank_Transaction_N_Ach_Entry_Detail_Record Maps manual funding bank transaction records to the ACH entry detail record associated with that transaction - for firm vendor funding
dbo.Marital_Status_Type
dbo.Micr_Line_Format The table used to store the different types of MICR line format options.
dbo.Minimum_Wage
dbo.Minimum_Wage_Payroll_Check_Treatment Type table which defines the actions to take if minimum wage is not met when saving a check.
dbo.Month_Information Table to identify Month information
dbo.Multiple_Garnishment_Calculation_Method
dbo.Negative_Payroll_Check_Treatment Type table which defines the actions to take if a negative check is found when saving a check.
dbo.Netclient_File_Log
dbo.Netclient_Time_Entry_Option This tables purpose is to store client-level options used by the NetClient portal.
dbo.Non_Posting_Payroll_Transaction_GL_Period Payroll transactions will not post for periods stored in this table. When the client selects an effective period, if the post_payroll_transactions is set to true, every gl period from the effective period and beyond will be removed from this table. When the flag is set to false, every period from the effective period through the latest fiscal year will be added to this table. When new fiscal years are created the post_payroll_transactions flag will be used to determine whether or not to add the gl periods of the new fiscal year to this table. Payroll transactions with posting periods that are present in this table will not post to the general ledger.
dbo.Notification_Category_Type This table stores identifiers for the different scenario categories.
dbo.Notification_Generalized_Type This table stores identifiers for the different types of general scenarios that result in notifications. This combined with a notification category identifies a specific scenario. e.g Check SSN validation vs. Employee SSN validation
dbo.Notification_Queue This table stores data for notifications that need to be processed by Cron tasks.
dbo.Notification_Queue_Record_Lock This table locks records in parent table Notification_Queue, where a lock record indicates a queue record is being processed by a Cron task.
dbo.Notification_Status This table stores status options to indicate whether a Cron task has handled a record yet.
dbo.Notification_Type This table stores identifiers for the different types of specific scenarios that result in notifications. e.g Check SSN validation vs. Employee SSN validation.
dbo.Numeric_GL_Account_Number_Metrics This table contains metrics calculated across a client's Chart of Accounts. It's used by the GL_Account_Sort_View to build a padded string that can be used to sort the chart such that numeric account numbers (all digits with at most one decimal point) will appear to sort numerically (ex. 10, 20, 100) instead of alphanumerically (10, 100, 20).
dbo.Office
dbo.Ohio_Jedd_Tax A table used to store an Ohio JEDD Tax code and description to be applied in place of local taxes.["BR"] JEDD stands for Joint Economic Development District. Multiple townships, cities or villages can enter["BR"] into a JEDD agreement to jointly collect income tax.
dbo.OnBalance_Bank_Account Table to store the mapping data information of bank accounts for OnBalance
dbo.OnBalance_GL_Account Table to store the mapping data information of chart of accounts for OnBalance.
dbo.OnBalance_Import_Option This table contains the data entry import options to configure the OnBalance Import feature.
dbo.Online_Bill_Pay_Bank_Transaction This table holds Online Bill Pay specific data for a given Bank Transaction.
dbo.Online_Bill_Pay_Transmission_Status This table holds the values specifying the transmission statuses for Online Bill Pay.
dbo.Onvio_Client_List This ephemeral table exists to satisfy a quirk of the SearchTextBox, which is that it insists on having the ability to query the database to handle how it does things like type-ahead, etc.
dbo.Onvio_Documents_Display_Dialog This table pairs a Document_Management_System_Print_Category (as defined by the DMS_Print_Category table) to a boolean value["BR"] for displaying a dialog when printing that category and to a boolean value["BR"] for including document date year property on parent level folder when printing that category. Not changing the historical name of table, just added the required column.
dbo.Onvio_Documents_Mapping This table pairs a Document_Management_System_Print_Category (as defined by the DMS_Print_Category table) and Folder Level to values for["BR"] value type, and actual folder value
dbo.Onvio_Payroll_Integration_Action This table stores action type to indicate which action should run.
dbo.Onvio_Payroll_Integration_Data_Type The data type the operations is run for (client, employee, etc).
dbo.Onvio_Payroll_Integration_Queue This table stores data for Onvio Payroll Integration that need to be processed by Cron tasks.
dbo.Onvio_Payroll_Integration_Status This is the union of all statuses (for client, employee, pay schedule, contact, etc.) that an operation may have with regard to Onvio. Each such table using these statuses should both foreign key into this table as well as check constraint to ensure they only record status for which they are prepared to handle.
dbo.Overpayment_Handling_Option
dbo.PPC_Smart_Engagement This table is used for PPC SMART integration. A binder that is linked with SMART engagement will store the linking information in this table.
dbo.PPC_Workpaper This table stores document information of a PPC Checkpoint Tools documents. WorkpaperCS can integration with PPCs Checkpoint Tools by allowing users to add PPC Checkpoint Tools document into WorkpaperCS. Information stored in this table come from Custom Properties of PPC Checkpoint tools Excel or Word documents.
dbo.Pay_Frequency
dbo.Pay_Item Client payroll item properties applicable only to a pay payroll item.
dbo.Pay_Item_Exclusion_Detail Table used to store selected payroll items exclusions.
dbo.Payable_Payment_Application This table holds records that are Applications of Payments to Payables.
dbo.Payable_Payment_Application_Payable_Distribution This table holds distributions for Payable_Payment_Application records.
dbo.Payable_Payment_Application_Payment_Distribution This table holds distributions for Payable_Payment_Application records.
dbo.Payable_Transaction
dbo.Payable_Transaction_Distribution A Payables amount is distributed among one or more liablity accounts. This collection of liabilities is called distributions which is what this table contains.
dbo.Payable_Transaction_N_Ach_Entry_Detail_Record Maps payable transactions to the ACH entry detail record associated with that transaction - for firm vendor funding
dbo.Payable_Transaction_N_Elf_File Maps the payable transaction to the electronic filing (ELF) file that paid it.
dbo.Payable_Transaction_N_Magnetic_Media_File_Client Maps the payable transaction to the magnetic media file client that paid it.
dbo.Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item This dictionary table associates payable transaction worker compensation items with the liabilities created from them.
dbo.Payable_Transaction_N_Payroll_Check_Payroll_Item This dictionary table associates payroll check payroll items with the liabilities created from them.
dbo.Payable_Transaction_N_Payroll_Check_Tax_Item This dictionary table associates payroll check tax items with the liabilities created from them.
dbo.Payable_Transaction_N_Receivable_Transaction This dictionary table links related payables and receivables. The payables and receivables don not necessaryily have to belong to the same client. For example, in SBPR, the fees and billing cycle will generate receivables for the firm and related payables for the client which are linked together via an entry in this table.
dbo.Payable_Transaction_N_Shortfall_Transaction This dictionary table associates a payable transaction with the shortfall transaction for which it was created.
dbo.Payable_Transaction_Template This table is used to store information about a transaction template that can be used to generate a payable transaction.
dbo.Payable_Transaction_Template_Distribution A table used to describe one of the possibly multiple distributions that make up a payable transaction template.
dbo.Payable_Transaction_Type The table enumerates the different types of payable transactions.
dbo.Payment_Term This table contains the fields required for the Payment Term screen.
dbo.Payment_Term_Basis Type table that will have payment bases that will determine the payment discount date or due date.
dbo.Payment_Term_Discount_Method Type table which will have discount types that determine how payments will be discounted.
dbo.Payroll_Agent_Payment_Method_Lead_Days This table is used by the manage impound payments workitem for use with payroll agents. It contains information used in conjunction with a filter to select processing days for payments based on payment method, the due date and the number of lead days. The filter system will calculate the processing date by due date minus the number of lead days for the payment method type. This table is at the firm level and is shared by all clients. There are a fixed number of rows as the payment method types are static, but the table is not read only since the number of lead days can be modified.
dbo.Payroll_Bank_Transaction Bank_Transaction records that correspond to Payroll Checks have a record here to link to the Employee and record the Pay Period. Payroll_Bank_Transaction_View exists to limit the columns returned by a read which fails to specify a DropAllBut().
dbo.Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail This dictionary table associates a payroll bank transaction record with a client pay schedule detail record.
dbo.Payroll_Bank_Transaction_Worker_Compensation_Item
dbo.Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution Holds the distribution of payroll bank transaction worker compensation items across multiple work locations
dbo.Payroll_Check_Benefit_Item_Import Table used to import employee benefits related to a single check.
dbo.Payroll_Check_Entry_Option This table contains the data entry options to configure the batch check entry grid.
dbo.Payroll_Check_Entry_Option_Payroll_Item_Definition This table contains the data entry column definitions to configure the batch check entry grid.
dbo.Payroll_Check_Entry_Option_Payroll_Item_Exclusion Specifies the client payroll items to be excluded from a pay schedule. This table contains rows for excluded payroll items for which the selection scope set to "Selected"
dbo.Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment This table contains the client deduction items used to reduce a negative check.
dbo.Payroll_Check_Entry_Option_Shortfall_Tax_Treatment This table contains the client tax items used to reduce a negative check.
dbo.Payroll_Check_Number_Import List of check numbers associated with a template column. This table will hold check numbers for imported payroll checks prior to check creation
dbo.Payroll_Check_Payroll_Item
dbo.Payroll_Check_Payroll_Item_Distribution
dbo.Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail
dbo.Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail Details of creditor garnishment orders for payroll check payroll item distributions
dbo.Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail Contains garnishment detail information for each payroll check distribution record.
dbo.Payroll_Check_Payroll_Item_Import
dbo.Payroll_Check_Printing_Primary_Sort_By_Type
dbo.Payroll_Check_Sales_Amount_Distribution Table to hold sales amount distributions for payroll checks.
dbo.Payroll_Check_Sales_Amount_Import This table will hold imported sales amounts prior to check creation.
dbo.Payroll_Check_Tax_Item
dbo.Payroll_Check_Tax_Item_Distribution
dbo.Payroll_Check_Tax_Item_Import List of imported tax items associated with a template column.
dbo.Payroll_Consolidation_Group Payroll consolidation involves selecting a set of clients whose data will be combined["BR"] in order to produce a single tax form with the combined amounts. Each consolidated group has a primary client["BR"] and any number of secondary clients. Tax processing calculations combine data across multiple clients when["BR"] producing tax forms.
dbo.Payroll_Consolidation_Group_Member Defines which payroll consolidation group a client might belong to as well as["BR"] the client's sequence number in the group. These are all secondary clients in the group.
dbo.Payroll_Department
dbo.Payroll_Item_Calculation_Type
dbo.Payroll_Item_Calculation_Type_Qualifier Type table which defines the payroll item calculation type for payroll check entry options.
dbo.Payroll_Item_Special_Timing Table that holds how a payroll items special timing is handled.
dbo.Payroll_Item_Special_Timing_Date_Basis Table to identify which date to base the payroll special timing on.
dbo.Payroll_Item_Special_Timing_Frequency Table to identify the frequency for a special timing payroll item.
dbo.Payroll_Item_Special_Timing_Selected_Payroll_Period_Basis Table to identify the period basis for a payroll special timing frequency of selected payrolls.
dbo.Payroll_Item_Special_Type Table used to store payroll item special types.
dbo.Payroll_Item_Type
dbo.Payroll_Item_Worker_Compensation_Exemption
dbo.Payroll_Item_Worker_Compensation_Exemption_Detail
dbo.Payroll_Journal_Entry_Option Table to hold information specified in the Payroll Journal Entry Options Dialog
dbo.Payroll_Journal_Entry_Option_Date_Type Type table describing the date types of the Payroll_Journal_Entry_Option table
dbo.Payroll_Tax_Forms_Filed_By_Type The table used to store the payroll tax forms filed by type options.
dbo.Payroll_Tracking_Portlet_Column_Screen_Option This table holds the customized order and visibility of columns on payroll tracking tab grid and links to the user interface grid columns and client custom fields.
dbo.Pending_AP_Payment This table holds pending payments. A pending payment can be paired with an existing payable, so that the payable can be paid. What this means here is that the pending payment would be turned into a real payment, and then applied against a payable.
dbo.Pending_AP_Payment_Application This table holds pending applications. A pending application is the pairing of one existing payable and one existing payment, or one existing payable and one pending payment. It can be used to create a real (no longer pending) application of payment to payable.
dbo.Pod_Service_W2_Queue A row in this table corresponds to a UT W2 pod file queued for transmission
dbo.Portlet_Type
dbo.Positive_Pay_File This table tracks each positive pay export file created by our program.
dbo.Positive_Pay_File_Detail This table associates a given positive pay file with all the bank transactions that exported in the file.
dbo.Practice_User
dbo.Preloaded_Payroll_Check_Entry_Batch This table stores preloaded payroll check entry batches. Batched will be calculated overnight and removed when the batch is submitted or a change in the system invalidates the stored data.
dbo.Print_1095 This table holds information for a form 1095 print run.
dbo.Print_1095_Selection This table holds selection information for a form 1095 print run.
dbo.Print_1096_Selection This table is used by tax processing code to drive 1096 form printing.
dbo.Print_1099 This table is used by tax processing code to drive 1099 and 1096 form printing. It determines which user is printing, what year they are printing for, and which 1099 type they are printing.
dbo.Print_1099_Selection This ephemeral table is used by tax processing code to drive 1099 and 1096 form printing. It determines each form's account number. Updates to schema for this table typically must be paralleled in table Recipient_1099_Override but accept NULL there.
dbo.Print_AR_Transaction_Selection This is a locking table that ensures an AR Transaction added to it is not being printed by more than one user at a time.
dbo.Print_Check_Selection
dbo.Print_Customer_Statement_Selection This table is used drive AR Statement printing. It determines which user is printing, which customers are being printed and the dates required by the report variables.
dbo.Print_Destination_User_Preference Store user preferences for print destinations and use them to populate various Print Options views.
dbo.Print_Filing_Instruction Stores the filing instruction for a particular federal/state/local collation item for a particular processing period.
dbo.Print_Job This table contains an entry for each job submitted to the check/invoice/form printing engine. This table's primary key is used to uniquely identify a given print job.
dbo.Print_Job_Subtype Table to store the sub output types for printers
dbo.Print_Job_Type Table to store the output types for printers
dbo.Print_Payable_Transaction_Selection Lock payable transactions during printing (similar to table Print_Check_Selection, which locks bank transactions during printing).
dbo.Print_Receivable_Transaction_Detail_Selection This table stores locks for receivable transaction detail records (aka fees) tied to invoices that are printing so that other users may not print them.
dbo.Print_Report_Selection
dbo.Print_W2 This table is used by tax processing code to drive W2 and W3 form printing. It determines which user is printing and what year they are printing for.
dbo.Print_W2_Selection This table is used by tax processing code to drive W2 and W3 form printing. It determines each form's control number as well as which box 12 codes, which states, and which localities ton include on a form.
dbo.Print_W3_Selection This table is used by tax processing code to drive W3 form printing. It determines each form's control number as well as which box 12 codes, which states, and which localities ton include on a form.
dbo.Printer_User_Preference Table to store the users preferences for printers
dbo.Printer_User_Preference_By_Subtype Table to store the user preferences for printers of print job subtypes. The user preferences for printers of main types like W-2s, Reports, Checks, Invoices, and 1099s are still stored in the Printer_User_Preference table, but any subtypes to these main types, like the W-2 Preprinted W-3, can have a printer that overrides the main printer, and that is what we store in this table.
dbo.Priority This table contains levels of priority.
dbo.Privilege
dbo.Privilege_Dependency
dbo.Privilege_Description This table holds description for Privileges with a database prefix specified in database_prefix.
dbo.Privilege_Forbidden This table contains privileges that will always be denied (even members of the Administrator group). Maintenance of this table is not the responsibility of the applications and changes made won't appear until the next time the application runs.
dbo.Processed_Direct_Deposit_Fileheader Table to hold file header data for processed ACH files.
dbo.Processed_Tax_Form Any tax forms in this table have been processed. Tax forms are considered processed when they have been printed or magnetic media/internet files have been created for them.
dbo.Processed_Tax_Form_Liability Any tax forms in this table have had their liability adjustments processed. Liability adjustments are considered processed when the associated form has been processed and no adjustment is required, or the liability adjustment has been written off.
dbo.Processing_Note
dbo.Processing_Note_Category The category of a processing note. Users can add to this list.
dbo.Processing_Note_Sort_Order Determines how processing notes should be sorted in the Client Processing Notes and Process Payroll Tax Forms Notes dialogs.
dbo.Processing_Note_Type The type of processing note. This determines which notes should be shown in different areas of the program.
dbo.Product_Id
dbo.Quarter This table holds the description of quarters. It is used by the user interface and as a foreign key constraint.
dbo.Quick_Books_Account This table stores a quick book account
dbo.Quick_Books_Account_GL_Account This table stores a quick book account gl account data
dbo.Quick_Books_Account_Integration_Direction This table contains what type of data transfer QBO supports.
dbo.Quick_Books_Account_N_Checkbook This table will have an entry for every quickbooks gl account of type Bank that is mapped to an acs checking account.
dbo.Quick_Books_Class This table stores a quick books class and connects it to a gl account code
dbo.Quick_Books_Export_Option This table contains export options used when exporting data to QuickBooks.
dbo.Quick_Books_Import_Option This table contains import options used when importing data from QuickBooks.
dbo.Quick_Books_Online_Export_Option This table is for the Client Quickbooks Online Export Options.
dbo.Quick_Books_Online_Exported_Journal_Entry This table contains returned data for journal entry exported to Quick Books Online.
dbo.Quick_Books_Online_Import_Option This table contains the data entry import options to configure the Quickbooks Online Import feature.
dbo.Quick_Books_Online_Integration_Client A table to store tokens needed to access a client's QuickBooks Online account. The QuickBooks Online ACS identifiers stored in table Quick_Books_Online_Integration are used to get access tokens (Access Token, Access Token Secret) and an identifier (Company ID) for an individual client QBO accounts. These access tokens allow ACS to grab information from a client's QBO account. The Access Token and Access Token Secret expire periodically and need to be refreshed.
dbo.Quick_Books_Online_Integration_License_Agreement this table tells records the staff id and staff name of the staff member that accepted a version of the quickbooks online integration license agreement. Firms that use quickbooks online integration will need a record in this table for the current license agreement and the primary key constant that matches the current license agreement. Firms that do not use quickbooks online integration will not have a record in this table. Updates to the license agreement would result in new records being added to this table with a new primary key constant for the firms using quickbooks online integration, once a staff member accepts the new version of the license agreement.
dbo.Quick_Books_Payee Quick Books Payee
dbo.Quick_Books_Payee_N_Employee This table will have an entry for every quickbooks payee of type employee that is mapped to an acs employee.
dbo.Quick_Books_Payee_N_Vendor This table will have an entry for every quickbooks payee of type vendor that is mapped to an acs vendor.
dbo.Quick_Books_Payee_Type This table stores the valid Quick Books payee types
dbo.Quick_Books_Payroll_Item This table contains information about payroll items that we have imported from quickbooks.
dbo.Quick_Books_Payroll_Item_N_Client_Payroll_Item This dictionary table associates quickbooks payroll items with an associated client payroll item.
dbo.Quick_Books_Payroll_Item_N_Client_Tax_Item This dictionary table associates quickbooks payroll items of type tax with an associated client tax item.
dbo.Quick_Books_Payroll_Item_Type This table stores the valid Quick Books payroll item types
dbo.Quick_Books_Retrieved_Account this table contains information on gl accounts retrieved from quickbooks for a given ACS client, where the gl accounts have not yet been imported into the permanent ACS tables for that client. For quickbooks online, the process of importing data has two steps. First, we retrieve the data from a quickbooks online company, and then we import the retrieved data into the permanent ACS tables. We need a means to store off the information after that first step has completed, but before that second step. This table provides the means for us to store information on accounts that have been retrieved from a quickbooks online company, but not yet imported into the permanent tables in ACS for the client. Once the import completes for one client, the records in this table for that one client will be removed.
dbo.Quick_Books_Retrieved_Transaction This table contains information on transactions retrieved from quickbooks for a given ACS client, where the transactions have not yet been imported into ACS for that client. For quickbooks online, the process of importing data has two steps. First, we retrieve the data from a quickbooks online company, and then we import the retrieved data into the permanent ACS tables. We need a means to store off the information after that first step has completed, but before that second step. This table provides the means for us to store information on transactions that have been retrieved from a quickbooks online company, but not yet imported into the permanent tables in ACS for the client. Once the import completes for one client, the records in this table for that one client will be removed.
dbo.Quick_Books_Retrieved_Transaction_Distribution this table contains information on transaction distributions retrieved from quickbooks for a given ACS client, where the transactions have not yet been imported into the permanent ACS tables for that client. For quickbooks online, the process of importing data has two steps. First, we retrieve the data from a quickbooks online company, and then we import the retrieved data into the permanent ACS tables. We need a means to store off the information after that first step has completed, but before that second step. This table provides the means for us to store information on transaction distributions that have been retrieved from a quickbooks online company, but not yet imported into the permanent tables in ACS for the client. Once the import completes for one client, the records in this table for that one client will be removed.
dbo.Quick_Books_Retrieved_Vendor this table contains information on vendors retrieved from quickbooks for a given ACS client, where the vendors have not yet been imported into the permanent ACS tables for that client. For quickbooks online, the process of importing data has two steps. First, we retrieve the data from a quickbooks online company, and then we import the retrieved data into the permanent ACS tables. We need a means to store off the information after that first step has completed, but before that second step. This table provides the means for us to store information on vendors that have been retrieved from a quickbooks online company, but not yet imported into the permanent tables in ACS for the client. Once the import completes for one client, the records in this table for that one client will be removed.
dbo.Quick_Books_Transaction This table contains information about transactions that we have imported from quickbooks.
dbo.Quick_Books_Transaction_Distribution This table will store the transaction distributions of transactions imported from QuickBooks.
dbo.Quick_Books_Transaction_N_GL_Transaction This dictionary table associates a gl transaction with an associated quickbooks transaction.
dbo.Quick_Books_Transaction_Type This table stores transaction types used in quickbooks.
dbo.Race_Type
dbo.Rapid_Tab_List_View_Filter This table contains the four possible filters for the Rapid tab in the Enter AP Transactions screen.
dbo.Receivable_Detail_Type
dbo.Receivable_Transaction
dbo.Receivable_Transaction_Detail
dbo.Receivable_Transaction_Fee
dbo.Receivable_Transaction_Fee_Detail
dbo.Receivable_Transaction_Fee_Detail_Type
dbo.Receivable_Transaction_Print_Option Holds the most recent print options used when this receivable transaction was last printed.
dbo.Receivable_Transaction_Print_Override The table used to store overrides for unprinted Receivable Transaction during the printing process.
dbo.Receivable_Transaction_Sales_Tax_Taxable_Item The table used to link a sales tax to the related taxable fee.
dbo.Receivable_Transaction_Type
dbo.Recipient_1099_Override The table used to store Recipient 1099 overrides for all 1099 types. The schema for this table should closely match that in Print_1099_Selection but accept NULL to indicate a field that is not overridden and the calculated value should be used.
dbo.Reconciliation_Tax_Form_Override_Type Provide valid employee reconciliation form override monthly overrride amount types from the employee detail view grid
dbo.Record_Status Generic status table that houses the types that define if a given record is active, inactive or virtually deleted.
dbo.Recorded_Event
dbo.Recorded_Event_Client_Recorded_Event_Object Table that links a recorded event with a recorded event object for a client.
dbo.Recorded_Event_N_Recorded_Event_Object Table that links a recorded event with a recorded event object.
dbo.Recorded_Event_N_Secondary_Recorded_Event_Object Links objects to an event that are not the primary event object (meaning the one the event happened to), but were otherwise involved - like employees in a batch of payroll checks.
dbo.Recorded_Event_Notification
dbo.Recorded_Event_Object Table that represents an object tracked by the recorded event system.
dbo.Recorded_Event_Object_N_Balance_Definition Table that links a recorded event object record with an Balance_Definition record.
dbo.Recorded_Event_Object_N_Bank Table that links a recorded event object record with an bank record.
dbo.Recorded_Event_Object_N_Checkbook Table that links a recorded event object record with a checkbook.
dbo.Recorded_Event_Object_N_Client Table that links a recorded event object record with an client record.
dbo.Recorded_Event_Object_N_Client_Access_Notification A link table that links dbo. Recorded_Event_Object table and dbo. Client_Access_Notification table.
dbo.Recorded_Event_Object_N_Client_Pay_Schedule Table used to store references of the event object with the client pay schedule key on which the action is performed.
dbo.Recorded_Event_Object_N_Employee Table that links a recorded event object record with an employee record.
dbo.Recorded_Event_Object_N_Engagement_Binder Table used to store references of the event object with the engagement key on which the action is performed.
dbo.Recorded_Event_Object_N_GL_Account Table that links a recorded event object record with a GL_Account record.
dbo.Recorded_Event_Object_N_Impound_Profile This table stores information that links the recoded event object with the impound profile
dbo.Recorded_Event_Object_N_Payroll_Department Table that links a recorded event object record with a Payroll_Department.
dbo.Recorded_Event_Object_N_Staff Table that links a recorded event object record with an staff record.
dbo.Recorded_Event_Object_N_Workpaper Table used to store references of the event object with the workpaper key on which the action is performed.
dbo.Recorded_Event_Searchable_Attribute Collection of attribute values associated with a Recorded_Event that can be searched on. One event can have many attribute values
dbo.Recorded_Event_Searchable_Attribute_Type Defines the type of data that can be searched on.
dbo.Recorded_Event_Staff_Recorded_Event_Object Table that links a recorded event with a recorded event object for a staff.
dbo.Report_Definition
dbo.Report_Definition_Application_License_Requirement Lists application/license combinations that make CS defined reports available.
dbo.Report_Definition_Security_Group Each record indicates that the report is available to staff who are in the specified security group
dbo.Report_Definition_Source Report layout definition source information. Indicates the origin/status of a layout.
dbo.Report_Designer_Page_Setup_Default This table contains all properties of Page Setup Default dialog box.
dbo.Report_Folder Table that holds system and user-defined folders that house reports/financial statements/letters.["BR"]The last record has 999 for the PK value so we have a reserve int padding for future system defined folders.
dbo.Report_Folder_Type Table that houses the different system folder types that will be used.
dbo.Report_Image
dbo.Report_Profile This table holds the primary key, description and report type of every client report profile. Client report profiles are overrides on a per-client basis of a global report profile. Therefore, this table also holds a client key to tell us for which client this client profile is intended.
dbo.Report_Profile_Element This table will contain an entry for each report contained within a client specific override of a global report profile. Each entry will have a key to link to a report definition, and a report option xml file. Together, the report definition xml and the report option xml describe how to print a report.
dbo.Report_Profile_Type This table contains the different types of report profiles. Profiles of type firm can only hold firm level reports. Profiles of type client can only hold client level reports.
dbo.Report_Type
dbo.Report_User_Preference
dbo.Reprintable_Bank_Transaction This table is the master list of all bank transactions that may be reprinted because they were stored for reprinting during their initial printing.
dbo.Reprintable_Print_Job This table stores data needed to reprint all checks in a print job.
dbo.STE_Filing_Status_State Reverse engineered from no doc 2019-11-01: This table drives the list of allowed values for states.
dbo.STE_State_Misc_Parameter
dbo.STE_State_Misc_Parameter_Allowed_Value Reverse engineered from no doc 2019-11-01: This table drives the list of allowed values for parameters. It did not need a version added as that was driven a layer up.
dbo.STE_State_Misc_Parameter_Usage Reverse engineered from no doc 2019-11-01: This table helps data-driven UI for the Withholding in Employee Self Service, and possibly in ACS.
dbo.STE_Tax_Dictionary This table contains a list of taxes defined by Symmetry. It is used to build items for tax exemptions.
dbo.Schedule_M3_Tax_Code_Attribute This table enumerates an attribute Tax journal entries require for Schedule M-3 Code mapping.
dbo.Scheduled_Payroll_Change_Initiator This table stores various types of Payroll Change Initiators.
dbo.Scheduled_Payroll_Tracking_Detail This table allows the processor(staff) to know which payrolls need to be processed and find the status of a particular client. It also includes the information needed for management reporting.
dbo.Scheduled_Statistics_Update Table containing information about statistics that need recurring updates.
dbo.Scheduled_Transaction_Instance This table stores the information we need to track transactions scheduled to be created from a template. It stores information for transactions already created and for transactions not created yet.
dbo.Scheduled_Transaction_Interval This table stores the time intervals defined by the frequency of the associated template. The intervals are a means to organize scheduled transactions (both those created from the template, and those scheduled but not yet created), and efficiently alter a schedule when a user changes scheduling options after we begin to generate transactions from the template.
dbo.Schema_Update_Alert Schema updates can place alerts in this table that will be displayed to the user when they next log into the database. The alerts will continue to be displayed until the user removes them from the queue. At a minumum, the alert must have a title; the description is optional.
dbo.Security_Group
dbo.Selection_Scope
dbo.Semimonthly_Period This table contains the semimonthly period descriptions.
dbo.Shortfall_Balance_Payroll_Check_Treatment Type table which defines the actions to take to apply gains to a prior shortfall.
dbo.Shortfall_Deduction_Treatment_Selection Table that defines which client deduction items are applicable for shortfall processing
dbo.Shortfall_Tax_Treatment_Selection Table that defines which client tax items are applicable for shortfall processing
dbo.Shortfall_Tax_Treatment_Type Type table which defines the selectable tax types
dbo.Shortfall_Transaction Transactions to track tax and deduction shortfalls from checks and restitution payments.
dbo.Shortfall_Transaction_N_Client_Payroll_Item Dictionary to associate a shortfall transaction to a client payroll item
dbo.Shortfall_Transaction_N_Client_Tax_Item Dictionary to associate a shortfall transaction to a client tax item
dbo.Shortfall_Transaction_N_Payroll_Check_Payroll_Item Dictionary to associate a shortfall transaction to a payroll check payroll item
dbo.Shortfall_Transaction_N_Payroll_Check_Tax_Item Dictionary to associate a shortfall transaction to a payroll check tax item
dbo.Shortfall_Transaction_Type Type table which defines the source of the shortfall transaction
dbo.Signoff_Role This table will be used to keep track of the different roles for a signoff
dbo.Signoff_Type This table will be contain the data representing a signoff type
dbo.Skipped_Check_Number Each record lists a number that we tried to use but for some reason were not able to, and we choose not to return to the pool of available numbers.
dbo.Skipped_Direct_Deposit_Voucher_Id Each record lists a voucher id that we tried to use but for some reason were not able to, and we choose not to return to the pool of available voucher ids.
dbo.Sort_Order_Type
dbo.Source_Document_Processing_Sort_Order this table stores the sort order in the engagement tree for documents that have been through source document processing
dbo.Source_Document_Processing_Tax_Organizer_Sort_Order This table stores the sort order in the engagement tree for tax organizer documents that have been through source document processing.
dbo.Spreadsheet_Import_1095C_Covered_Individual_Detail An enumeration of the 1095-C Part 3 covered individual detail names used for spreadsheet import.
dbo.Spreadsheet_Import_1095C_Offer_And_Coverage_Box_Name An enumeration of the 1095-C Part 2 box names used for spreadsheet import.
dbo.Spreadsheet_Import_1095C_Offer_And_Coverage_Col_Header_Name An enumeration of the 1095-C Part 2 column headers used for spreadsheet import.
dbo.Spreadsheet_Import_1099_Box_Combination Table to store the mapping data information of 1099 forms for spreadsheet import.
dbo.Spreadsheet_Import_AR_Item The purpose of this table is to map shipping items or sales tax items imported via the spreadsheet import process to shipping items or sales tax item already existing in the database.
dbo.Spreadsheet_Import_AR_Transaction_Item_Selection Specifies column options for AR transaction invoice items of type Item.
dbo.Spreadsheet_Import_AR_Transaction_Shipping_Item_Selection Specifies column options for AR transaction invoice items of type Shipping.
dbo.Spreadsheet_Import_Account Table to store the mapping data information of chart of accounts for spreadsheet import.
dbo.Spreadsheet_Import_Accruable_Benefit_Type Table to identify the accruable benefit type used when importing employees
dbo.Spreadsheet_Import_Bank_Account Table to store the mapping data information of bank accounts for spreadsheet import
dbo.Spreadsheet_Import_Bank_Routing_Number Table to store the mapping data information of payment terms for spreadsheet import.
dbo.Spreadsheet_Import_Customer The purpose of this table is to map customers imported via the spreadsheet import process to AR customer�s already existing in the database.
dbo.Spreadsheet_Import_Deduction_Item_Type Table to identify the deduction item type used when importing employees
dbo.Spreadsheet_Import_Direct_Deposit_Allocation_Type Table to identify the direct deposit allocation type used when importing employees
dbo.Spreadsheet_Import_Discount_Other_Charge_Shipping_Selection Specifies column options for invoice item of type "Discount" or "Other Charge" or "Shipping"
dbo.Spreadsheet_Import_Finance_Charge_Definition The purpose of this table is to map finance charge definitions imported via the spreadsheet import process to finance charge definitions already existing in the database.
dbo.Spreadsheet_Import_Payment_Term Table to store the mapping data information of payment terms for spreadsheet import.
dbo.Spreadsheet_Import_Payroll_Item_Type Table to identify the pay item type used when importing employees
dbo.Spreadsheet_Import_Sales_Tax_Selection Specifies column options for invoice item of type "Sales Tax"
dbo.Spreadsheet_Import_Tax_Info_Type Table to identify the tax informatio type(tax codes,tax codes unit or m3 tax codes) used when importing data from spreadsheet.
dbo.Spreadsheet_Import_Tax_Item_Type Table to identify the Tax item type used when importing employees
dbo.Spreadsheet_Import_Taxing_Authority Specifies mapping data for sales tax descriptions.
dbo.Spreadsheet_Import_Vendor Table to store the mapping data information of vendors for spreadsheet import
dbo.Staff
dbo.Staff_Create_Ems_User_Requested Track staff members for which we've asked Web Services to create an EMS user.
dbo.Staff_Default_Report_Option
dbo.Staff_Ems_User_Id Maps Staff to the EMS User ID, if needed. (EMS being the CSi interal user license management system.)
dbo.Staff_Locator
dbo.Staff_Locator_Status
dbo.Staff_Security_Group
dbo.Staff_Shortcut
dbo.Staff_Status
dbo.Staff_Type The table used to store system Staff types. These values are not expected to be surfaced to the user.
dbo.Staff_With_Access_To_Checkbook This table lists the staff allowed to access a checkbook. If there are no records in this table for a checkbook, then, all["BR"] staff with access to the checkbook's client will have access to the checkbook. If there are records in this table, then only those["BR"] staff will have access to the checkbook.
dbo.State_Definition
dbo.State_Local_Amount_Code_Type
dbo.State_Tax_Exemption
dbo.State_Tax_Exemption_Detail
dbo.State_Tax_Exemption_Type This table contains the list of state taxes defined in the Tax_Code_Type table. Is it used to determine tax exemptions.
dbo.Static__Valid_Address_Type_Usage_Rule This table defines which contact types can be associated with which contact address types.
dbo.Ste_County
dbo.Ste_Feature_Code The Symmetry Tax Engine code for a tax region other than a state or county. This is a sub-type table of Ste_Location_Code. Rows are added to this table as needed, using data retrieved from the STE.
dbo.Ste_Feature_Code_By_County Table that holds a list of feature codes contained in a county.
dbo.Ste_Location_Code Table which holds the super-type STE location codes. STE location codes are defined by the Symmetry Tax Engine (ste). This super type holds the complete location code for any location needed by the system.
dbo.Ste_State_Code The Symmetry Tax Engine code to designate a county. This is a sub-type table of Ste_Location_Code. The contents of this table are pre-populated with all defined codes.
dbo.Ste_State_Misc_Parameter_Droplist_Item
dbo.Subsidiary_Client_Collection_Type The table enumerates the two different types of subsidiary client collections a master consolidated client can have associated with it. The first collection of subsidiary clients is called the User Selected to Consolidate collection and has a key value of 1. This type indicates those subsidiary clients that the user has selected to be consolidated. The second collection is called the Currently Consolidated collection and has a key value of 2. This type indicates those subsidiary clients that have been consolidated and are currently part of the master client's consolidated data.
dbo.Suta_Supplemental_Type
dbo.Swipe_Clock_Options_Type This table holds the description of Swipe Clock Option Type available. It is used to provide options in combo box.
dbo.Synchronized_Privilege Identifies groups of privilege keys that must always have the same value in the array of privilege data.
dbo.Synchronized_Privilege_Group Each row identifies a privilege that is logically the same across modules but is implemented with multiple privilege keys that must always have the same value privilege data array.
dbo.Table_Information
dbo.Tax_Agent
dbo.Tax_Agent_Direct_Deposit_Allocation Table for tax agent direct deposit allocations
dbo.Tax_Agent_Direct_Deposit_Tax_Payment_Information Table for tax agent direct deposit tax payment information.
dbo.Tax_Agent_Form_Filing_Address Table for all the current form filing address for the tax agents.
dbo.Tax_Agent_Form_Filing_Address_Scenario Table for all the various types of form filing address scenarios for the tax agents.
dbo.Tax_Agent_Locality_Tax_Uid
dbo.Tax_Agent_N_Vendor_Agent
dbo.Tax_Agent_N_Vendor_Agent_Payment_Schedule Table to store all selected payment schedules for a particular tax agent along with a set of options for each payment schedule
dbo.Tax_Agent_Payment_Address Holds payment addresses for tax agents and their payment types
dbo.Tax_Agent_Payment_Address_Type Holds types of payment addresses for tax agents
dbo.Tax_Agent_Payment_Method_Lead_Days This table is used by the manage impound payments workitem for use with tax agents. It contains information used in conjunction with a filter to select processing days for payments based on payment method, the due date and the number of lead days. The filter system will calculate the processing date by due date minus the number of lead days for the payment method type. This table is at the firm level and is shared by all clients. There are a fixed number of rows as the payment method types are static, but the table is not read only since the number of lead days can be modified.
dbo.Tax_Agent_State_Local_Tax_Type_Code Table for tax agent direct deposit state/local tax type codes.
dbo.Tax_Agent_Ste_Location_Code
dbo.Tax_Calculation_Status
dbo.Tax_Code Complete set of Ultra Tax and Custom Tax codes for a client
dbo.Tax_Code_M3_N_GL_Account Connects an M3-A tax code to the gl account for a specific year.
dbo.Tax_Code_N_GL_Account Connects a tax code to the gl account for a specific year and unit.
dbo.Tax_Code_N_Ultra_Tax_Tax_Code Connects a client's tax code to the Ultra Tax tax code info for a specific year and entity type.
dbo.Tax_Code_Type This table stores the various tax code types in the system that serve as tax categories. This table also stores the FAKE tax code types. Those FAKEs are added in to serve as placeholders that signify multiple tax code types and the multiple types are defined in the code. Local_Tax_Exemption_Type basically has a one to one relationship with Tax_Code_Type in the database and for certain exemption selections this needs to be one-to-many and the FAKEs allow the many to be specified in the code.
dbo.Tax_Deferral_Reason This type table enables us to know the exact reason for which the tax has been deferred.
dbo.Tax_Export_Program Lists the different types of tax export programs.
dbo.Tax_Form This poorly named table actually describes all tax form COLLATIONS currently in the system
dbo.Tax_Form_Filing This table represents an instance of a Tax Form Collation for a particular client.It is possible that instance was never processed nor filed.While it is the case that this deals with Tax Forms one Collation at a time,this table-level documentation is the only place that will be acknowledged, except where the distinction is critical.
dbo.Tax_Form_Filing_Method
dbo.Tax_Form_Filing_Override Entries in this table each represent a single overriden field on a Tax Form.When the option to Save overrides by period end date for the relevant form type is off,the system will maintain only one set of overrides for the given tax form collation / client combination by dynamically reassigning them from one period_end_date to another.
dbo.Tax_Form_Grouping Table to identify how tax forms should be grouped together.
dbo.Tax_Form_Liability_Processing_Lock This table is used to implement a locking mechanism for tax form liability processing. When a tax form's liabilities are being processed an entry is first made into this table to indicate that other users are prevented from processing identical liabilities.
dbo.Tax_Form_Override This table stores data about override present on the most-recently edited version of a tax form. Each separate field that is overridden has its own entry in this table. Historical data is not preserved. As each form gets re-filed, the system makes the assumption that the same set of overrides as last time shall be applied, unless a service pack deletes overrides due to form updates. It is not possible to retrieve the set of overrides that existed at an arbitrary point in the history of form filing, as only the most recently edited version of the form has its overrides stored.
dbo.Tax_Form_Selection This table contains all the tax forms selected.
dbo.Tax_Form_Selection_Filing_Instruction_Type This table defines all of the tax form slection filing instruction types used in the Tax_Form_Selection table.
dbo.Tax_Form_Type The types of tax forms that can be processed
dbo.Tax_Jurisdiction
dbo.Tax_Jurisdiction_State_Setting
dbo.Tax_Jurisdiction_Suta_Base_Rate
dbo.Tax_Jurisdiction_Suta_Supplemental_Rate
dbo.Tax_Jurisdiction_Type
dbo.Tax_Period_Frequency
dbo.Tax_Reconciliation_N_Journal_Entry_Distribution This table links journal entry distributons of Tax Journal Entries to their tax reconciliation schedule line
dbo.Tax_Reconciliation_Schedule_Line This table will hold predefined values of tax reconcilation lines for some ultra tax entity type
dbo.Tax_System_Bridged_Carry_Over_Source Tax systems that generate carryovers to other systems. Example: 941-X. Also it is tax systems that carryover amounts within the same tax system. Example: 941 Line 10 amounts
dbo.Tax_System_Bridged_Federal_Carry_Over The carryover amounts from one system to another. Example: 941-X credit amount carryovers to 941 for the quarter/year the error was discovered. Also tracks carryover amounts within the same tax systems. Example: 941 Line 10 amounts
dbo.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.
dbo.Taxing_Authority_Type A list of possible tax types, such as Service Tax and Sales Tax.
dbo.Taxpayer_Id_Number_Selection_Type Type table for taxpayer id number selection.
dbo.Term
dbo.Thirdparty_Worker_Compensation_Transmission_Status_Type Table containing third party worker compensation transmission status types.
dbo.Tickmark The table contains contains the tickmarks for the firm. It can store one of two types of tickmarks. Images or text.
dbo.Time_Entry_Method
dbo.Time_Entry_Method_Classification Define classifications for time entry methods.
dbo.Timerack_Client_Update_Queue This table stores updated clients that are queued for TimeRack export.
dbo.Timerack_Client_Update_Queue_Graveyard Holds records of Timerack_Client_Update_Queue which couldn't be transmitted.
dbo.Timerack_Employee_Update_Queue This table stores updated employees that are queued for TimeRack export.
dbo.Timerack_Employee_Update_Queue_Graveyard Holds records of Timerack_Employee_Update_Queue which couldn't be transmitted.
dbo.Timerack_Failure_Type Holds types of failures
dbo.Tip_Allocation_Method The table used to store the different types of Tip Allocation methods.
dbo.Transaction_Status
dbo.Transaction_Template Transaction Templates - Parent table for template information used to create OnDemand or recurring transactions.
dbo.Transaction_Template_Automatic_Type Transaction Template Automatic Types - enumerates the supported subtypes for automatic transaction templates
dbo.Transaction_Template_Calendar_Day This table stores options that denote how a user can specify the day of week on which we create a scheduled transaction (e.g., Monday, or weekday, or weekend day).
dbo.Transaction_Template_Calendar_Day_Occurrence This table stores options that denote how a user can specify the occurrence of a day of week on which we create a scheduled transaction (e.g., the first, or the third, or the last).
dbo.Transaction_Template_Creation_Day This table stores options that denote how a user specifies the day on which we should create a scheduled transaction (e.g., create on the Nth day of the month, where N is an integer).
dbo.Transaction_Template_Frequency Transaction Template Frequency - enumerates the supported types of frequencies for transaction templates
dbo.Transaction_Template_N_GL_Transaction This dictionary table associates a transaction template with a GL transaction that was created from it.
dbo.Transaction_Template_N_Journal_Entry This dictionary table associates a jouranl entry transaction with a transaction template.
dbo.Transaction_Template_Note This table is used to store a note associated with a transaction template. A transaction template may have multiple notes associated with it.
dbo.Transaction_Template_Recurrence_End This table stores the options we support for ending a scheduled transaction (e.g., end when we have created a specific number of transactions from a template).
dbo.Transaction_Template_Schedule_Option This table stores the options we support for scheduled transaction templates.
dbo.Transaction_Template_Scheduled_Recurrence This table stores recurrence frequencies we support for scheduled transactions (e.g., daily or weekly).
dbo.Transaction_Template_Type This table allows us to differentiate between potential transaction templates.
dbo.Transfer_Bank_Transaction
dbo.Transmit_Online_Bill_Pay_Selection This is a locking table assuring that no more than one bank transaction is ever being locked tying the transaction to the user who locked it.
dbo.Trial_Balance_Grid This table stores a number of Trial Balance Data Entry Grid for each client with write-up and/or trial balance functionality enabled
dbo.Trial_Balance_Grid_Column This table stores column information for trial balance data entry grid. Each entry in this table represents one column in grid. A grid can have variable number of columns
dbo.Trial_Balance_Grid_Column_Account_Grouping_Option This table stores more column defintion information for trial balance data entry grid columns. For Account_Grouping columns they need more specific informaiton
dbo.Trial_Balance_Grid_Column_Account_Number_Option This table stores more column defintion information for trial balance data entry grid columns. For Account Number columns they need more specifical informaiton
dbo.Trial_Balance_Grid_Column_Account_Tax_Code_Option This table stores more column definition information for trial balance data entry grid columns. For Tax Code columns they need more specific information
dbo.Trial_Balance_Grid_Column_Amount_Amount_Type This table stores type definition to Trial_Balance_Grid_Column_Amount. The Amount Type is more detaild information such as Beginning Balance, Adjusting JE and so so.
dbo.Trial_Balance_Grid_Column_Amount_Balance_Type This table will hold values for the trial balance grid column amount balance type.
dbo.Trial_Balance_Grid_Column_Amount_Option This table stores more column defintion information for trial balance data entry grid columns. For Amount columns they need more specifical informaiton
dbo.Trial_Balance_Grid_Column_Amount_Period_Basis This table stores type definition to Trial_Balance_Grid_Amount_Period_Base. User has flexibilty to define an amount column by specifiying an offset from a period Base. it could be Current Period, Current YTD or The Begining of the Year
dbo.Trial_Balance_Grid_Column_Tickmark_Option This table stores more column defintion information for trial balance data entry grid columns. For Amount columns they need more specifical informaiton
dbo.Trial_Balance_Grid_Column_Type This table stores type definition to Trial Balance Grid Column
dbo.Trial_Balance_Grid_Column_Workpaper_Reference_Option This table stores more column defintion information for trial balance data entry grid columns. For workpaper reference columns they need more specifical information
dbo.Trial_Balance_Grid_Type This table will hold values for the trial balance grid type.
dbo.Trial_Balance_Split_Screen_Grid_Option Table to store the options on a per client basis for the Journal Entry Split Screen View in the Trial Balance Grid.
dbo.Ultra_Tax_Category_Type Tax Code Category type table
dbo.Ultra_Tax_Entity_Type Ultra Tax Enity information
dbo.Ultra_Tax_Map_File Ultra Tax tax code map file information
dbo.Ultra_Tax_Staged_Tax_Code This table is used to stage incoming Ultra Tax tax codes before they are merged into the global and client Ultra Tax tax codes.
dbo.Ultra_Tax_Tax_Code Ultra Tax tax code map file contents
dbo.Undo_Manager_Entry This table stores the xml version of reports when a user is using the Undo Manager.
Unique_Identifier_Counter
dbo.Update_Data_Change_Log
dbo.Update_Data_Version_History
dbo.Updated_Ledger_Entry_Queue Table used to queue up gl transaction changes that will require the ledger entry ETL processes to run.
dbo.User_Client_Preference_Grid_Column_Screen_Option This table holds links to the customised columns and the grids they belong to (if the user customised order and visibility of columns in a given grid).
dbo.User_Interface_Grid This table holds the description of the grid that has the column with customised display settings and the link to the screen it belongs to.
dbo.User_Interface_Grid_Column This table holds the description of the columns and whether it is required and the link to the grid it belongs to.
dbo.User_Interface_Screen The table used to store the different types of UI screens in the system.
dbo.User_Preference
dbo.User_Preference_Grid_Column_Screen_Option This table holds links to the customised columns and the grids they belong to (if the user customised order and visibility of columns in a given grid).
dbo.User_Screen_Option The table used to store UI control states on system screens.
dbo.User_Session
dbo.User_Session_Override This table holds updates to rows in dbo.User_Session that would have otherwise been blocked. It is important to NOT have a relationship to dbo.User_Session so that we avoid any blocking on enforcing DRI.
dbo.User_Session_Pattern
dbo.User_Session_Status
dbo.Valid_7200_Period This table records the valid year/quarter combinations for form 7200, allowing future legislative changes to be handled via a simple insert.
dbo.Vendor
dbo.Vendor_1099_Box_Setup This table contains the valid 1099 box combinations available for use on bank transactions for a particular vendor.
dbo.Vendor_1099_Recipient_Filter_Type This table defines all of the types of filtering available for a vendor 1099 recipient.
dbo.Vendor_1099_Sort_Type Table used to store the ways to sort vendors on 1099s.
dbo.Vendor_AP_Beginning_Balance This table may hold a link between a vendor and a carry over payable transaction if they have one.
dbo.Vendor_Agent
dbo.Vendor_Agent_Due_Date_Adjustment
dbo.Vendor_Agent_Effective_Date This table will essentialy hold duplicate information from the Vendor_Agent table, and will be used as temp table while areas of the code are changed for the Effective Date for Deposit Schedules project.
dbo.Vendor_Agent_Liability_Source
dbo.Vendor_Agent_Payment_Schedule
dbo.Vendor_Amortization_Schedule Amortization schedules are used to display payments over time that have principal and interest amounts.
dbo.Vendor_Amortization_Schedule_Entry Individual payments scheduled as part of an amortization schedule.
dbo.Vendor_Bank_Transaction
dbo.Vendor_Direct_Deposit_Allocation
dbo.Vendor_Distribution This table contains the default distributions used when a payment is created for a vendor.
dbo.Vendor_Independent_Contractor_Reported The table used to store when a vendor has been reported to be an independent contractor.
dbo.Vendor_Payment_Method
dbo.Vendor_Payment_Primary_Sort_By_Type
dbo.Vendor_Payment_Secondary_Sort_By_Type This table contains the values for secondary sort in Print Checks screen.
dbo.Vendor_Type Table used to store the types of vendors.
dbo.W2_1099_Box_Type Lookup table of boxes available on 1099 forms
dbo.W2_1099_Ordering_Worksheet_Client_Option This table enumerates the different types of client options available when previewing the W-2 and 1099 ordering worksheets.
dbo.W2_1099_Type
dbo.W2_1099_User_Preference Table used to store user preferences for W-2s and 1099s
dbo.W2_Compensation_Code_Type The table defines compensation codes relevant for W2 processing.
dbo.W2_Copy_A_Client_Copy_Type Table to identify the copy type used when printing the client copy for the W-2 Copy A.
dbo.W2_Employee_Sort_Type Table used to store the ways to sort employees on W-2s.
dbo.W2_Form_Corrected_Type The entries in this type table specify the various types of W-2s that can be corrected.
dbo.W2_Kentucky_Tax_Credit_Type The table defines types of Kentucky tax credits, relevant for W2 processing.
dbo.W2_Nonqualified_Deferred_Compensation_Type The table defines types of nonqualified deferred compensation for W2 processing.
dbo.W2_Override_Type Type table for W-2 override type.
dbo.W2_Rendered_Template Table used to store pre-rendered form template documents used during W2 processing.
dbo.W2_Rendering_Client_Lock This table locks a particular client, where a lock record indicates the client is being processed by the W2 rendering Cron task.
dbo.W2_Special_Correction_Type The entries in this type table specify the various types of special corrections that can occur when correction a W-2.
dbo.W3_Client_Copy_Type Table to identify the copy type used when printing the client copy for the W-3.
dbo.W3_Kind_Of_Employer This table defines the possible kinds of W-3 employers.
dbo.W4_Additional_Amount_Type
dbo.Wage_Type
dbo.Web_Employee_Check_Stub_Queue Table to track check stubs data pending transmission to a web service
dbo.Web_Employee_Employee_Update_Queue Table to track employee data pending transmission to a web service
dbo.Web_Page_Portlet
dbo.Web_Services_Client_Deletion_Queue Table to track deleted clients pending transmission to Web Services
dbo.Web_Services_Employee_Deletion_Queue Table to track deleted employees pending transmission to Web Services
dbo.Web_Services_Transmit_Queue Top level table to track data that needs to be uploaded to a web service
dbo.Web_Services_Transmit_Queue_Graveyard Holds records of Web_Services_Transmit_Queue which couldn't be transmitted.
dbo.Withholding_Deposit_Frequency
dbo.Withholding_Deposit_Schedule
dbo.Work_Location
dbo.Work_Location_Tax_Jurisdiction
dbo.Worker_Compensation
dbo.Worker_Compensation_Class_Code
dbo.Worker_Compensation_Class_Code_Detail
dbo.Worker_Compensation_Limit
dbo.Worker_Compensation_Limit_Detail
dbo.Worker_Compensation_Rate
dbo.Workforce_Hub_Check_Stub_Queue This table contains all check stubs that have been queued to send to Workforce Hub
dbo.Workforce_Hub_Employee_Update_Queue This table contains employees and any additional data for those employees that needs to be sent to Workforce Hub.
dbo.Workforce_Hub_Form_Queue This table contains all forms that have been queued to send to Workforce Hub
dbo.Workforce_Hub_Form_Type This table contains all the types of forms that can be sent to Workforce Hub
dbo.Workforce_Hub_Pending_Acknowledgement_Queue This table contains list of updates that came from WFH but have not been acknowledged yet.
dbo.Workpaper This table contains the data that represents a document within an engagement binder.
dbo.Workpaper_File_Component This table contains the known types of files a workpaper may contain (i.e. preview, original, etc...).
dbo.Workpaper_List_Column This table contains the order (and presence) of the columns in the workpaper list portlet, chosen by the logged in staff.
dbo.Workpaper_List_Column_Type This table contains all the column types for workpapers list portlet grid.["BR"] Logged in Staff can modify the column order as per their requirement.
dbo.Workpaper_N_File_Storage This table contains links a workpaper to the many files it can be made up of.
dbo.Workpaper_Roll_Forward_Treatment This table is a type table used to keep track of which ways we allow the user to roll forward a workpaper.
dbo.Workpaper_Signoff This table will record all of the signoffs a particular workpaper contains.
dbo.Workpaper_Source_Document_Processing This table stores information about a workpaper as it is being sent to Source Document Processing. Entries in this table will tracking an automated process that uploads a file to be OCRd, waits for processing to be complted, downloads the file and then splits up documents. Each workpaper has only one entry in this table and the status gets updated as changes occur. Workpaper entries can be Added, processed and Uploaded/Downloaded to secure servers for OCR processing from Engagement Binder Window in Workpaper Dashboard. They can also be processed and Uploaded/Downloaded from Source Document Portlet (Firm Dashboard)
dbo.Workpaper_Source_Document_Processing_Status This table stores information about the states a workpaper goes through when it is sent to Source Document Processing.
dbo.Workpaper_Source_Ocr_Data This table stores information of Source Document (PDF) OCR data and page index where the OCR belongs to .
dbo.Workpaper_Status This table contains information needed for describing the various states of a workpaper.
dbo.XactPay_Accruable_Benefit_Type Table containing XactPay accruable benefit types.
dbo.XactPay_Client_EIN_History Table containing the EIN history for XactPay clients
dbo.XactPay_Consent Table containing XactPay consent file information
dbo.XactPay_Employee_SSN_History Table containing the SSN history for XactPay employees
dbo.XactPay_Employer_Contribution_Type Table containing XactPay employer contribution types.
dbo.XactPay_Multi_Class_Identifier_Type Table containing XactPay multi class identifier types.
dbo.XactPay_N_Payroll_Bank_Transaction A dictionary table to map XactPay_Payroll_Transmission and Payroll_Bank_Transaction, so that each check item in the payroll file will have an entry here.
dbo.XactPay_Pay_Item_Type Table containing XactPay pay item types.
dbo.XactPay_Payroll_Transmission Table containing XactPay payroll file information
dbo.XactPay_Payroll_Transmission_Result Table containing XactPay payroll file history
dbo.XactPay_Setup_Transmission Table containing XactPay setup file information
dbo.XactPay_Setup_Transmission_Result Table containing XactPay setup file history
dbo.Year_End_Close_Balance_Sheet_Account_Distribution The table contains the accounts that had ballance sheet account amounts distributed to them during a year end close event.
dbo.Year_End_Close_Budget_Amount_Treatment The table enumerates the different treatments available to the year end close process for initializing the budget amounts in the new fiscal year.
dbo.Year_End_Close_Net_Income_Distribution The table contains the accounts that had net income distributed to them during a year end close event.
dbo.Year_End_Close_Option The table contains the options a client has used to perform the year end close process for a fiscal year.
dbo.Yodlee_Financial_Account_Link_Status This table holds values for Yodlee financial account link statuses.
dbo.Zero_Hours_Code This table stores the zero hours codes and their descriptions. These are explanations of why an employee may have wages without having any hours.

Views
dbo.AP_Payable_Distribution_View
dbo.AP_Payable_View
dbo.AP_Payment_Distribution_View
dbo.AP_Payment_View
dbo.AR_Deposit_View
dbo.AR_Payment_Application_View
dbo.AR_Payment_Transaction_View
dbo.AR_Receivable_Transaction_View
dbo.AR_Transaction_Full_View
dbo.AR_Transaction_Item_Rollup_View
dbo.AR_Transaction_View
dbo.Active_Filter_View
dbo.Active_Status_View
dbo.Backup_History_View
dbo.Bank_Feeds_Bank_Transaction_View
dbo.Bank_Transaction_Account_List_View
dbo.Bank_Transaction_Denormalized_View
dbo.Bank_Transaction_Distribution_Detail_View
dbo.Bank_Transaction_Distribution_View
dbo.Bank_Transaction_Firm_Client_Uncleared_Combined_View
dbo.Bank_Transaction_Firm_Client_Uncleared_General_View
dbo.Bank_Transaction_List_View
dbo.Bank_Transaction_Running_Balance_View
dbo.Bank_Transaction_Sortable_Reference_Number_View
dbo.Bank_Transaction_View
dbo.Bank_View
dbo.Calculated_Numeric_GL_Account_Number_Metrics_View
dbo.Check_Bank_Transaction_View
dbo.Check_Layout_Report_Definition_Descriptions_Per_Client_View
dbo.Checkbook_Context_List_View
dbo.Checkbook_View
dbo.Client_Active_Employees_View
dbo.Client_Benefit_View
dbo.Client_Class_View
dbo.Client_GL_Setup_View
dbo.Client_N_Client_Payroll_Service_View
dbo.Client_N_Client_Service_Type_For_Filters_View
dbo.Client_Pay_Schedule_Detail_View
dbo.Client_Payroll_Item_View
dbo.Client_Payroll_Service_View
dbo.Client_Processing_Note_View
dbo.Client_Processor_Information_View
dbo.Client_Tax_Code_View
dbo.Client_View
dbo.Client_W2_Verification_Date_View
dbo.Client_Workplace_State_View
dbo.Consolidation_Deleted_Subsidiary_Client_View
dbo.Consolidation_Master_Client_Budget_View
dbo.Consolidation_Master_Client_Tax_Code_View
dbo.Consolidation_Subsidiary_Client_Account_Number_Detail_View
dbo.Consolidation_Subsidiary_Client_Account_Number_Detail_With_Leading_Zeroes_View
dbo.Consolidation_Subsidiary_Client_Account_Number_View
dbo.Consolidation_Subsidiary_Client_Account_Number_With_Leading_Zeroes_View
dbo.Consolidation_Subsidiary_Client_Budget_View
dbo.Consolidation_Subsidiary_Client_Tax_Code_View
dbo.Consolidation_Subsidiary_Client_Transaction_View
dbo.Consolidation_Subsidiary_Client_Transaction_Within_Period_Range_View
dbo.Contact_Address_View
dbo.Contact_Email_Type_View
dbo.Contact_Email_View
dbo.Contact_Phone_Type_View
dbo.Contact_Phone_View
dbo.Contact_Type_View
dbo.Contact_View
dbo.Custom_Field_Base_Type_Calculation_View
dbo.Custom_Field_Type_View
dbo.Custom_Fieldview_Type_View
dbo.Custom_Fieldview_View
dbo.Custom_Grouping_View
dbo.Custom_Value_Client_Staff_View
dbo.Custom_Value_Client_View
dbo.Custom_Value_Customer_View
dbo.Custom_Value_Employee_View
dbo.Custom_Value_Firm_View
dbo.Custom_Value_Staff_View
dbo.Custom_Value_Vendor_View
dbo.Custom_Value_View
dbo.Customer_Activity_Transaction_View
dbo.Customer_View
dbo.Database_Property_View
dbo.Direct_Deposit_Allocation_Performance_View
dbo.Elf_File_View
dbo.Employee_N_Employee_Reporting_Type_View
dbo.Employee_Other_State_Setting_View
dbo.Employee_Payroll_Item_Special_Timing_View
dbo.Employee_Payroll_Item_View
dbo.Employee_Primary_Work_Location_Payroll_Department_View
dbo.Employee_Reporting_Type_View
dbo.Employee_Taxable_Wage_Adjustment_Date_View
dbo.Employee_View
dbo.Employee_W4_Settings_Pivot_View
dbo.Employee_Work_Location_Payroll_Department_View
dbo.Enter_Transaction_Data_Entry_Session_View
dbo.Etl_Helper_Ledger_Entry_Ap_Payment_Application_Ap_Dr_View
dbo.Etl_Helper_Ledger_Entry_Ap_Payment_Application_Credit_Memo_Cr_View
dbo.Etl_Helper_Ledger_Entry_Ap_Payment_Application_Discount_Taken_Cr_View
dbo.Etl_Helper_Ledger_Entry_Ap_Payment_Application_Payable_Distribution_Dr_View
dbo.Etl_Helper_Ledger_Entry_Ap_Payment_Application_Payment_Distribution_Cr_View
dbo.Etl_Helper_Ledger_Entry_Ar_Payment_Application_Ar_Cr_View
dbo.Etl_Helper_Ledger_Entry_Ar_Payment_Application_Credit_Memo_Ar_Dr_View
dbo.Etl_Helper_Ledger_Entry_Ar_Payment_Application_Discount_Honored_Dr_View
dbo.Etl_Helper_Ledger_Entry_Ar_Payment_Application_Distribution_Cr_Dr_View
dbo.Etl_Helper_Ledger_Entry_Ar_Payment_Undeposited_Payment_Dr_View
dbo.Etl_Helper_Ledger_Entry_Ar_Payment_Unearned_Revenue_Cr_View
dbo.Etl_Helper_Ledger_Entry_Ar_Transaction_Ar_Dr_View
dbo.Etl_Helper_Ledger_Entry_Ar_Transaction_Item_Cr_Dr_View
dbo.Etl_Helper_Ledger_Entry_Bank_Transaction_Balancing_Cr_Dr_View
dbo.Etl_Helper_Ledger_Entry_Bank_Transaction_Balancing_Cr_Dr_With_Partial_Impound_Bugfix_View
dbo.Etl_Helper_Ledger_Entry_Bank_Transaction_Distribution_Cr_Dr_View
dbo.Etl_Helper_Ledger_Entry_Check_Summary_Memo_Cr_View
dbo.Etl_Helper_Ledger_Entry_Deposit_Summary_Memo_Dr_View
dbo.Etl_Helper_Ledger_Entry_Journal_Entry_Credits_Debits_View
dbo.Etl_Helper_Ledger_Entry_Payable_Transaction_Ap_Cr_Dr_View
dbo.Etl_Helper_Ledger_Entry_Payable_Transaction_Distribution_Cr_Dr_View
dbo.Etl_Helper_Ledger_Entry_Payroll_Check_Payroll_Item_Expense_Dr_View
dbo.Etl_Helper_Ledger_Entry_Payroll_Check_Payroll_Item_Liability_Cr_View
dbo.Etl_Helper_Ledger_Entry_Payroll_Check_Tax_Item_Expense_Dr_View
dbo.Etl_Helper_Ledger_Entry_Payroll_Check_Tax_Item_Liability_Cr_View
dbo.Etl_Helper_Ledger_Entry_Payroll_Check_Worker_Compensation_Expense_Dr_View
dbo.Etl_Helper_Ledger_Entry_Payroll_Check_Worker_Compensation_Liability_Cr_View
dbo.Filter_Base_Type_View
dbo.Filter_Line_Type_View
dbo.Filter_Line_View
dbo.Filter_Range_Cache_View
dbo.Filter_Range_Type_View
dbo.Filter_Range_View
dbo.Filter_Select_View
dbo.Filter_Type_View
dbo.Filter_View
dbo.Finance_Charge_Definition_View
dbo.Firm_Account_Tax_Codes_View
dbo.Firm_Additional_Contact_Role_View
dbo.Firm_GL_Account_Grouping_View
dbo.Form_1099_Type_View
dbo.Formula_Frozen_Status_View
dbo.Full_Tax_Code_M3_View
dbo.Full_Tax_Code_View
dbo.GL_Account_Class_View
dbo.GL_Account_Client_Grouping_Code_View
dbo.GL_Account_Client_Grouping_Subcode_View
dbo.GL_Account_Client_Segment_Code_View
dbo.GL_Account_Grouping_Code_View
dbo.GL_Account_Hash_View
dbo.GL_Account_Segment_Code_Sort_View
dbo.GL_Account_Tax_Code_M3_View
dbo.GL_Account_Tax_Code_View
dbo.GL_Account_View
dbo.GL_Balancing_Entry_Account_List_View
dbo.GL_Balancing_Entry_View
dbo.GL_Bank_Reconciliation_Clear_Status_View
dbo.GL_Transaction_Bank_Transaction_Shared_View
dbo.GL_Transaction_Detail_View
dbo.GL_Transaction_Detail__AR_Payment_Application_Distribution__View
dbo.GL_Transaction_Detail__AR_Payment_Application__View
dbo.GL_Transaction_Detail__AR_Payment__View
dbo.GL_Transaction_Detail__AR_Transaction__View
dbo.GL_Transaction_Detail__Bank_Transaction_Distribution__View
dbo.GL_Transaction_Detail__Bank_Transaction__View
dbo.GL_Transaction_Detail__Journal_Entry__View
dbo.GL_Transaction_Detail__Payable_Payment_Application__View
dbo.GL_Transaction_Detail__Payable_Transaction__View
dbo.GL_Transaction_Detail__Payroll_Check_Payroll_Item_Expense__View
dbo.GL_Transaction_Detail__Payroll_Check_Payroll_Item_Liability__View
dbo.GL_Transaction_Detail__Payroll_Check_Tax_Item_Expense__View
dbo.GL_Transaction_Detail__Payroll_Check_Tax_Item_Liability__View
dbo.GL_Transaction_Detail__Payroll_Check_Worker_Compensation_Expense__View
dbo.GL_Transaction_Detail__Payroll_Check_Worker_Compensation_Liability__View
dbo.GL_Transaction_Detail__Summary_Memo__View
dbo.GL_Transaction_Event_Date_View
dbo.GL_Transaction_For_Use_By_Enter_Transaction_Edit_Multiple_With_Created_Date_View
dbo.GL_Transaction_For_Use_By_Enter_Transaction_Via_Checkbook_With_Created_Date_View
dbo.GL_Transaction_For_Use_By_Enter_Transaction_Via_Journal_With_Created_Date_View
dbo.GL_Transaction_For_Use_By_Enter_Transaction_View
dbo.GL_Transaction_Hash_View
dbo.GL_Transaction_Type_View
dbo.GL_Transaction_View
dbo.Graduated_Payroll_Item_Tier_Full_View
dbo.Impound_Profile_Active_Profile_View
dbo.Index_Names
dbo.Insurepay_Payroll_Transmission_View
dbo.Insurepay_Setup_Transmission_View
dbo.Journal_Entry_Account_List_Detail_View
dbo.Journal_Entry_Account_List_View
dbo.Ledger_Entry_View
dbo.Liability_Item_View
dbo.Magnetic_Media_File_View
dbo.Office_View
dbo.Online_Bill_Pay_Bank_Transaction_Full_View
dbo.Pay_Direct_Deposit_Allocation_View
dbo.Pay_Direct_Deposit_Allocation_With_Partial_Impound_Bugfix_View
dbo.Payable_Payment_Application_Full_View
dbo.Payable_Payment_Application_View
dbo.Payable_Transaction_Distribution_View
dbo.Payable_Transaction_N_Payroll_Check_View
dbo.Payable_Transaction_Processing_Date_View
dbo.Payable_Transaction_Template_View
dbo.Payable_Transaction_View
dbo.Payroll_Bank_Transaction_Displayable_Status_View
dbo.Payroll_Bank_Transaction_Full_View
dbo.Payroll_Bank_Transaction_View
dbo.Payroll_Check_Payroll_Item_Distribution_Denormalized_View
dbo.Payroll_Check_Payroll_Item_Distribution_View
dbo.Payroll_Check_Payroll_Item_Distribution_With_Account_Range_View
dbo.Payroll_Check_Tax_Item_Distribution_Denormalized_View
dbo.Payroll_Consolidation_Group_Client_View
dbo.Payroll_Department_View
dbo.Payroll_Funding_Transaction_View
dbo.Payroll_Journal_Entry_Status_View
dbo.Payroll_Transaction_Employee_Reporting_Type_View
dbo.Practice_User_View
dbo.Privilege_Dependency_View
dbo.Privilege_For_Client_Access_View
dbo.Privilege_Impounded_View
dbo.Privilege_Not_Allowed_In_Virtual_Office_View
dbo.Privilege_Only_Allowed_In_Virtual_Office_View
dbo.Privilege_Requiring_Accounting_Or_Workpapers_View
dbo.Privilege_Requiring_Accounting_View
dbo.Privilege_Requiring_Compliance_View
dbo.Privilege_Requiring_Payroll_View
dbo.Privilege_Requiring_Workpapers_View
dbo.Privilege_View
dbo.Privileges_Acs_View
dbo.Privileges_ClientAccess_PayrollOnly_View
dbo.Privileges_ClientAccess_View
dbo.Privileges_SbprClientAccess_View
dbo.Privileges_Sbpr_View
dbo.Privileges_Workpapers_View
dbo.Recorded_Event_Notification_Staff_Portlet_View
dbo.Recorded_Event_Object_Client_View
dbo.Recorded_Event_Object_Staff_View
dbo.Recorded_Event_View
dbo.Report_Profile_View
dbo.Reports_With_Accounting_Without_Workpapers_View
dbo.STE_State_Misc_Parameter_Comprehensive_View
dbo.Scheduled_Payroll_Run_Enhanced_View
dbo.Scheduled_Payroll_Run_Invoice_Amount_View
dbo.Scheduled_Payroll_Run_Status_View
dbo.Scheduled_Payroll_Run_View
dbo.Security_Group_View
dbo.Shortfall_Transaction_View
dbo.Sql_Server_Information_View
dbo.Staff_Client_Permission_By_Type_View
dbo.Staff_Locator_Status_View
dbo.Staff_Locator_View
dbo.Staff_Security_Group_View
dbo.Staff_View
dbo.State_View
dbo.Subsidiary_Client_Balance_View
dbo.Sui_Items_List_By_Employee_Client_View
dbo.System_Event_View
dbo.Table_Information_View
dbo.Tax_Agent_View
dbo.Tax_Code_Full_View
dbo.Tax_Form_Used_By_Elf_File_View
dbo.Tax_Jurisdiction_Hierarchy_View
dbo.Tax_Processing_Note_View
dbo.Taxing_Authority_Type_View
dbo.Taxing_Authority_View
Temp_Column_Characteristics_View
Temp_Columns_View
dbo.Term_View
dbo.Transaction_Template_List_View
dbo.Transfer_Bank_Transaction_View
dbo.User_Preference_View
dbo.User_Session_Override_View
dbo.User_Session_Pattern_View
dbo.User_Session_View
dbo.Vendor_Activity_Transaction_View
dbo.Vendor_Bank_Transaction_Displayable_Status_View
dbo.Vendor_Bank_Transaction_View
dbo.Vendor_Check_Direct_Deposit_Allocation_View
dbo.Vendor_Context_List_View
dbo.Vendor_Payment_Funding_Transaction_View
dbo.Vendor_Payment_Method_Simple_View
dbo.Vendor_View
dbo.Vendors_That_Require_Zero_Payment_Effective_Date_View
dbo.Vendors_That_Require_Zero_Payment_View
dbo.Wage_Plan_Code_View
dbo.Wage_Plan_Exempt_Status_View
dbo.Withdrawal_Bank_Transaction_Full_View
dbo.Work_Location_View
dbo.Worker_Compensation_Class_Code_Detail_View
dbo.XactPay_Payroll_Transmission_View
dbo.XactPay_Setup_Transmission_View