CFAL/NetCIL Online
Dropdown List Table Sources
Applies to: CFAL Version 5.2,
NetCIL Desktop 1.2, and NetCIL Online
Updated: 1/16/2012
The following
is a list of all NetCIL Client forms, combo box controls, and their associated
table sources. In many cases, these lists can be customized to meet your
agency's specific needs.
Appointments
Outcome: Outcome
Scores
Assistance Equipment
Assistance:
Assistance Codes
Inventory: inventory
Staff: Database
Users
Attendant
Attendant: Attendant Codes
Grant: Grant Codes
Staff: Database
Users
Case Notes Group Entry
BFS Service:
BFS Services
Contact Type:
Contact Type Codes
Grant: Grant Codes
History Code:
History Codes
Hours: (non-editable
list)
Inactive: Inactive
Codes
Keyword: Keywords
Priority Area:
Contact Type Codes
Services: Services
Staff: Database
Users
Community Activities
Activity: Community
Activity Codes
AT Outreach:
AT Targeted Outreach
Goal Search:
Community Goal History
Goal Type:
Community Goal Codes
Issue: Community
Issue Codes
Outcome: Outcome
Scores
Staff: Database
Users
Consumer Goals
Access Category:
Goal Standard:
Consumer Goal Standards
Goal Type:
Achievement Codes
Outcome: Outcome
Scores
Staff: Database
Users
Consumer History
AT Outcome: (non-editable list)
BFS Service:
BFS Services
Contact Type:
Contact Type Codes
CS Outcome: (non-editable list)
DL Outcome: (non-editable list)
Funding Type:
Funding Codes
Goal: Consumer Goal
History
Grant: Grant Codes
History Code:
History Codes (Do not delete records
from this table – Records can be added).
Hours: (non-editable
list)
Inactive: Inactive
Codes
LS Outcome: (non-editable list)
OM Outcome: (non-editable list)
Org Name:
Organizations
Outcome: Outcome
Scores
Services: Services
Staff: Database
Users
Disabilities
Disability:
Disability Codes
Staff: Database
Users
Documents
Staff: Database
Users
Domestic Status History
Staff: Database
Users
Status: Domestic
Status Codes
Education History
Education:
Education Levels
Staff: Database
Users
Employment History
Ant: Employment
Status Ant Codes
Dislocated:
Dislocation Criteria
Employment:
Employment Codes
Grant: Grant Codes
Staff: Database
Users
State: States
Events
Events Name Search: Events
Event Type:
Event Types
Key Search: Keywords
Events-Goals Sub
Associated Goals:
Community Goal History
Events-Projects Sub
People: Projects
Goals-Events Sub
Associated Events:
Events
Goals-Projects Sub
Associated
Projects: Projects
Housing History
Access Code:
Accessibility Codes
County: Counties
Housing: Housing
Codes
Staff: Database
Users
State: States
ILP Checklist
History Code:
History Codes
Hours:
Staff: Database
Users
Income History
Income: Benefits
Source Codes
Staff: Database
Users
Info
Type: Letters
Insurance History
Insurance:
Insurance Codes
Staff: Database
Users
Intake
Grant: Grant Codes
Reason: Inactive
Codes
Staff: Database
Users
Inventory
Category:
Assistance Codes
Grant: Grant Codes
Individual: People
Keyword: Keywords
Org: Organizations
Keyword-Event Sub
Keywords: Keywords
Keyword-Org sub
Keywords: Keywords
Keyword-People Sub
Keywords: Keywords
Keyword-Project sub
Keywords: Keywords
Keywords
Type: Program Codes
Letters
Letters Box: Letters
Mailing List:
Mailing List Codes
Queries: (non-editable
list)
Send:
Letters Queue
Comm Format: Comm
Format Codes
Letter Cat:
Letters
PersonID: People
Login
User: Database Users (Do not delete records from this table – uncheck the “Active” field
instead).
Main
Button Style: (non-editable list)
Org Search
Keyword: Keywords
Name Search:
Organizations
Query: (non-editable
list)
Organizations
Key Search: Keywords
State: States
Type: Org Types
Org-Mailing Sub
Mailing Lists:
Mailing List Codes
Org-Outreach Sub
Organizations:
Organizations
Org-People sub
Organizations:
Organizations
Org-People-Referrals Sub
Organizations:
Organizations
Outreach
AT Outreach:
AT Targeted Outreach
Community Service:
Community Goal History
Hours: (non-editable
list)
Org Name Search: Organizations
Outreach Name Search:
Outreach
Projects: Projects
Staff: Database
Users
People
Comm Format: Comm
Format Codes
Contact: Contact
Codes
County:
Disability:
Disability Codes
Ethnic: Ethnic Codes
Org: Organizations
Prefix: Title Codes
Special Lang:
Special Language Codes
Staff: Database
Users
State: States
People Search
Keyword: Keywords
Name Search: People
Query: (non-editable list)
People Search Phone Form
Keyword: Keywords
Name Search: People
Query: (non-editable list)
People Sub
People: People
People-Mailing Sub
Mailing Lists:
Mailing List Codes
People-Org sub
People: People
People-People sub
People: People
People-Phone
Contact: Contact
Codes
County:
Disability:
Disability Codes
Disability Search:
Disability Codes
Domestic: Domestic
Status Codes
Ethnic: Ethnic Codes
Org: Organizations
Second Dis:
Disability Codes
Staff: Database
Users
State: States
People-Referral-Sub
Disability:
Disability Codes
How Did:
Referral Source Codes
Person2: People
PWSN:
Ref from Org:
Organizations
Ref Person:
Database Users
Ref To Org:
Organizations
Service: Services
Staff: Database
Users
Project Tasks
Event: Events
Project-GTE-Users Sub
Staff: Database
Users
Project-GTE-Vols Sub
Volunteers: People
Projects
AT Outreach:
AT Targeted Outreach
Key Search: Keywords
Project Name
Search: Projects
Projects-Goals Sub
Associated Goals:
Community Goal History
Queries
Queries: (non-editable list)
Server Queries: (non-editable list)
Referrals
Access Code:
From Organization:
Organizations
Grant: Grant Codes
Hours: (non-editable
list)
Incentives: Service Incentives
Outcome: Outcome
Scores
Provisions: Service
Provisions
Reason: Service
Reason
Referral: Database
Users
Referral Source:
Referral Source Codes
Service: Services
Staff: Database
Users
Referrals Sub
Outcome: Outcome
Scores
Reports Form
Grant Name:
Grant Codes
Graph: (non-editable list)
Keyword: Keywords
Reports: (non-editable list)
Service: Services
Staff: Database
Users
Tables
Tables: (non-editable list)
Transportation
Grant: Grant Codes
Staff: Database
Users
Transport ID:
Transport Codes
Update Message
Users-Outreach Sub
Staff Participants:
Database Users
VR/DFB History
Staff: Database
Users
VR Status:
VR Status Codes
Week Log
Break: 0;0:00;0
Community Activity:
Community Goal History
Hours: (non-editable
list)
Project Goal Task:
Project GTE
Projects: Projects
Staff: Database
Users
Start: (non-editable
list)
Stop: (non-editable
list)
Work Log
AT Outreach:
AT Targeted Outreach
Community Activity:
Community Goal History
Entry Search:
WorkLogCodes
Events: Events
Grant: Grant Codes
Hours: (non-editable
list)
Org: Organizations
Org Name Search:
Organizations
Project Search:
Projects
Project Goal Task:
Project GTE
Projects: Projects
Service: CommunityServices
Sites: Work Sites
Staff: Database
Users
Type: WorkLogCodes