DataBridge File Keys







Previous Topic  Next Topic 

A "database key" is a column in one data table (file) whose value matches corresponding columns in other tables.  For example, "Program ID" is a key in the AWARDS DataBridge because it is found in multiple tables and can be used to link together the data in those tables.  Below is a list of keys found in the AWARDS DataBridge.

File

client id

program id

employee id

referral id

census id

household id

group id

bed id

Activities/Groups


X







Appointments History

X

X







Beds List


X






X

Client Demographics

X








Client / Member Identifiers

X








Diagnosis History

X








Direct Care Line Staff History

X

X

X






Employment History

X








Entitlement History

X



X





Funder Contracts


X







Hospitalization History

X








Household History

X





X



Housing History

X

X






X

In House Transactions


X






X

Incidents


X







Info Field Records

X

X

X

X





Legal Form

X



X





Maintenance History









Medical Form

X

X


X





Medication History

X








Outreach Census

X

X

X

X

X




Program Contact History

X

X

X




X


Program History

X

X


X





Program/Unit Division History

X

X







Programs


X







ReachOut Data

X

X







Reception Desk Records

X

X







Referral Source









Referrals

X



X





Service Plan History

X

X







Staff



X






Staff History



X






Substance Abuse Assessment

X

X


X





Toxicology

X








  NOTE: Not all data files listed above may be applicable for your agency, based on which AWARDS features you use. Additionally, only DataBridge files you specifically requested access to at the time the DataBridge was turned on will be available from within AWARDS. If, at any time, you need to change which files are accessible to your agency, please contact the Help Desk for assistance.

  https://demodb.footholdtechnology.com/help/?10793