Table definitions

Table definitions

This page provides an overview of the standard tables

 

The following information outlines only the standard tables that are pre-configured within your instance of the Brevity Product. Each table includes a general description of its purpose to help you determine the appropriate access rights when setting up new user roles.

 

Table Display Name

Table Name

Table Purpose

Table Display Name

Table Name

Table Purpose

Accident/Complaint

incident

Repository table for client and employee related incidents.

Allowed IP Address

organizationipaddress

Repository table for organisation whitlelist ip addresses.

Appraisal

appraisal

Repository table for employee appraisals.

Availability

availability

Repository table for employee periods of service availability or non availablity.

Bank

bankcode

Repository table for bank names.

Booking Resource

bookingresource

Repository table for vehicle, property, telecommunications and tools of trade resources.

Branch

branch

Repository table for organisation branches.

Brokerage Number

brokeragenumber

Repository table for brokerage details, relevance only for HCP processes.

Bulk Communication Group

bulkcommunicationgroup

Repository table for bulk communication groups used for bulk email/SMS communications, newsfeeds and incident severity notifications.

Cancellation Policy

cancellationpolicy

Repository table for service cancellation policies.

Cancellation Reason

cancellationreason

Repository table for service cancellation reasons.

Chart of Accounts

coa

Repository table for charts of accounts.

Chat Message

chatmessage

Repository table for chat messages.

Checklist Item

checklistitem

Repository table for checklist items that are associated to the Client Checklist.

Classification

classification

Repository table for employee classifications.

Client

client

Repository table for client profiles.

Client Checklist

clientchecklist

Repository table for client checklists.

Client Contact

clientcontact

Repository table for client contacts.

Classification

classification

Repository table for employee classifications.

Client Funding

clientfunding

Repository table for client funding profiles.

Client Funding Code

clientfundingcode

Repository table for client funding service lines.

Client Funding Pricelist

clientfundingpricelist

Repository table for client funding pricelists.

Client Goal Progress

clientgoalprogress

Repository table for client goal progress.

Client Goals

clientgoals

Repository table for client goals.

Client Leave Periods

clientleaveperiods

Repository table for HCP client leave periods.

Client Medication

clientmedication

Repository table for client medications.

Client Ongoing Note

clientongoingnote

Repository table for ongoing internal client notes.

Client Profile

clientprofile

Repository table for client profiles.

Client Profile Detail

clientprofiledetail

table Repository table for client profile details.

Client Profile Template

clientprofiletemplate

Repository table for client profile templates.

Client Profile Template Question

clientprofiletemplatequestion

Repository table for client profile template questions.

Client Risk Management

clientriskmanagement

Repository table for client risk management.

Client Service Provider

clientserviceprovider

Repository table for client and provider linkage records.

Communication

communication

Repository table for outbound email and SMS communications.

Communication Template

communicationtemplate

Repository table for Email / SMS communication templates.

Community

community

Repository table for communication communities.

Condition

healthcondition

Repository table for health conditions.

Contractor Invoice

contractorinvoice

Repository table for contractor invoices.

Cost

cost

Repository table for employee costs.

Country

country

Repository table for country reference records.

Eat Drink Plan

eatdrinkplan

Repository table for nutrition/hydration plan.

Employee Position

employeeposition

Repository table for employee positions.

Employment Type

employmenttype

Repository table for employment types.

Expense Type

expensetype

Repository table for service related expense types.

Export Table

exporttable

Repository table for record exports.

External Provider

account

Repository table for external providers

extsync

extsync

Repository table for ext sync records

Forms

form

used for my forms ADD ON feature

Funding Authorised User

fundingauthoriseduser

Repository table for authorisation by funding employee & funding source.

Funding Claim

fundingclaim

Repository table for funding claims.

Funding Claim Item

fundingclaimitem

Repository table for funding claim items.

Funding Source

fundingsource

Repository table for funding sources.

Funding Source Breakdown

fundingsourcebreakdown

Repository table for HCP funding source contributions, subsidies and fee breakdown records.

Funding Source Code

fundingsourcecode

Repository table for funding source records.

Funding Source Provider

fundingsourceprovider

Repository table for funding source provider (ie : NDIA).

Goal

goal

Repository table for goals.

Goal Task

goaltask

Repository table for goal tasks.

GPS locality

gpslocality

Repository table for service gps localites.

Group

clientgroup

Repository table for service groups.

Group Client

clientgroupclient

Repository table for client service groups

HCP Imnvoice Import

hcpimnvoiceimport

Repository table for imported HCP invoice files, available if the HCP function has been enabled.

HCP Invoice Batch

hcpinvoicebatch

Repository table for HCP invoice batches for claiming, available if the HCP function has been enabled.

HCP Invoice Import Batch

hcpinvoiceimportbatch

Repository table for HCP invoices batches, available if the HCP function has been enabled.

Home Risk

homerisk

Repository table for home risk records.

Home Risk Summary

homerisksummary

Repository table for home risk summary records.

Interest

interest

Repository table for employee and client interests.

Invoice

invoice

Repository table for service invoices.

Invoice Batch

invoicebatch

Repository table for service invoices batches.

Invoice Detail

invoicedetail

Repository table for invoices service details.

Language

language

Repository table for languages reference records.

Lead

lead

Repository table for quotation records.

Leave Periods

leaveperiods

Repository table for employee leave periods.

Medical History

medicalhistory

Repository table for client medical history records.

Medication

medication

Repository table for medication reference records.

myobcredential

myobcredential

Repository table for MYOB credentials.

NDIS Care Plan

ndiscareplan

Repository table for NDIS Care plans.

ndis number

ndisnumber

Repository table for ndis numbers changes.

Needs Assessment

needsassessment

Repository table for client CoS needs assessment records.

News Feed

newsfeed

Repository table for news feeds.

News Feed Comments

newsfeedcomments

Repository table for news feed comments.

newsfeedlike

newsfeedlike

Repository table for news feeds likes.

News Feed Read

newsfeedread

Repository table for news feeds reads.

Note

note

Repository table for note records.

Note Employees

noteemployees

Repository table for employee notes.

Note Tags

notetags

Repository table for note tags assigned to CoS services.

Nutrition CheckList

nutritionchecklist

Repository table for nutrition checlist records.

Organisation

organisation

Repository table for organisation profiles.

Participant Alert

clientalert

Repository table for client alerts.

Pay Items

payitems

Repository table for pay rate loading pay items.

Pay Rate Loading

payrateloading

Repository table for pay rate loading records.

Plan Management Claim Batch

pmclaimbatch

Repository table for plan management claim batche records

Plan Management Invoice

pminvoice

Repository table for plan management invoices.

Plan Management Invoice Import Batch

pminvoiceimportbatch

Repository table for plan management invoice import batches.

Plan Management Invoice Item

pminvoiceitem

Repository table for plan management invoice items.

Plan Management Plan

pmplan

Repository table for plan management plan records

Plan Management Plan Budget

pmplanbudget

Repository table for plan management budget records.

Plan Management Plan Provider

pmplanprovider

Repository table for plan management provider budget records.

Plan Review

planreview

Repository table for client plan reviews.

Copyright © 2019 Brevity. All Rights Reserved