CFAL/NetCIL Online Dropdown List Table Sources

Applies to: CFAL Version 5.42, NetCIL Desktop 1.42, and NetCIL Online

Updated: 9/18/2013

Return to Table of Contents


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. Almost all tables contain a field called “Active”; in most cases unchecking this field will prevent the record from being displayed in dropdown lists when new entries are created. Inactive records will still be displayed for existing entries. Deactivating records rather than deleting them is highly recommended, as it prevents the creation of “orphan” records for previously-entered information.

Appointments
Outcome: Outcome Scores

Assistance Equipment
Assistance: Assistance Codes
Inventory: inventory
Staff: Database Users
Type: (Value list; not editable)

Attendant
Attendant: People
AttendantCode: Attendant Codes
Grant: Grant Codes
Staff: Database Users

Attendant Sub
Proficiency: Attendant Proficiency Codes
Skill: Attendant Attribute Codes

Blind Field Services
ALTOutcome: (Value list; not editable)
ATOutcome:  (Value list; not editable)
Cause:  BFS Blindness Cause
Education: BFS Education Level
Living: BFS Living Arrangement
LSOutcome: (Value list; not editable)
NonVis: BFS Non-Visual Impairments
OMOutcome: (Value list; not editable)
Referral: BFS Referral Source
Setting: BFS Residence Setting

Bug Report
Form: (Value list; not editable)
Report: (Value list; not editable)

Case Notes Group Entry
BFSService: BFS Services
ContactType: Contact Type Codes
Grant: Grant Codes
HistoryCode: History Codes
Hours: (Value list; not editable)
Inactive: Inactive Codes

Keyword: Keywords
PriorityArea: Priority Areas
Services: Services
Staff: Database Users

Change User
Staff: Database Users

Colors
ButtonStyle: (Value list; not editable)

Community Activities
Activity: Community Activity Codes
ATOutreach: AT Targeted Outreach
GoalSearch: Community Goal History
GoalType: Community Goal Codes
Issue: Community Issue Codes
Outcome: Outcome Scores
OutComeMeasure: Community Outcome Measures
PriorityArea: Priority Areas
Staff: Database Users

Consumer Goals
AccessCategory: 
GoalStandard: Consumer Goal Standards
GoalType: Achievement Codes
Outcome: Outcome Scores
Priority: Priority Areas
Staff: Database Users

Consumer History
ATOutcome: 
BFSService: BFS Services
ContactType: Contact Type Codes
CSOutcome: 
DLOutcome: 
FundingType: Funding Codes
Goal: Consumer Goal History
Grant: Grant Codes
HistoryCode: History Codes
Hours: (Value list; not editable)
Inactive: Inactive Codes
LSOutcome: (Value list; not editable)
OMOutcome: (Value list; not editable)
OrgName: Organizations
Outcome: Outcome Scores
Priority: Priority Areas
Services: Services
Sites: Work Sites
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
EventType: 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
AccessCode: Accessibility Codes
County: Counties
Housing: Housing Codes
Staff: Database Users
State: States

ILP Checklist
HistoryCode: History Codes
Hours: (Value list; not editable)
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
LettersBox: Letters
MailingList: Mailing List Codes
Queries: MSysObjects  (not editable)
Send: (Value list; not editable)

Letters Queue
CommFormat: Comm Format Codes
LetterCat: Letters
PersonID: People

Login
User: Database Users

Org Search
Keyword: Keywords
NameSearch: Organizations
Query: MSysObjects  (not editable)

Organizations
County: 
CountyFilter: States
Key Search: Keywords
State: States
Type: Org Types

Org-County sub
Counties: Counties

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
ATOutreach: AT Targeted Outreach
CommunityService: Community Goal History
Hours: (Value list; not editable)
Org_Name_Search: Organizations

Outreach_Name_Search: Outreach
PriorityArea: Priority Areas
Projects: Projects
Staff: Database Users

ParentToParent
Contact: Contact Codes
County: Counties
DisabilitySearch: Disability Codes
Domestic: Domestic Status Codes
Ethnic: Ethnic Codes
Gender: (Value list; not editable)
Org: Organizations
Staff: Database Users
State: States

People
CommFormat: Comm Format Codes
Contact: Contact Codes
County: Counties
Disability: Disability Codes
Ethnic: Ethnic Codes
Gender: (Value list; not editable)
Org: Organizations
Prefix: Title Codes
SpecialLang: Special Language Codes
Staff: Database Users
State: States

People Inventory Loan
NameSearch: People

People Search
Keyword: Keyword
NameSearch: People
Query: MSysObjects  (not editable)

People Search Phone Form
Keyword: Keyword
NameSearch: People
Query: MSysObjects  (not editable)

People Sub
People: People

People-Mailing Sub
Mailing Lists: Mailing List Codes

People-Org sub
People: People

People-People sub
People: People

People-Referral-Sub
Disability: Disability Codes
Gender: (Value list; not editable)
HowDid: Referral Source Codes
Person2: People
PWSN: People
ReffromOrg: Organizations
RefPerson: Database Users
RefToOrg: Organizations
Service: Services
Staff: Database Users

Project Tasks
Event: Events

Project-GTE-Users Sub
Staff: Database Users

Project-GTE-Vols Sub
Volunteers: People

Projects
ATOutreach: AT Targeted Outreach
FundingType: Funding Codes
Grant: Grant Codes
Key Search: Keywords
Project Name Search: Projects

Projects-Goals Sub
Associated Goals: Community Goal History

PWSN
Disability: Disability Codes
Gender: (Value list; not editable)
SecondDis: Disability Codes

Queries
Queries: MSysObjects  (not editable)
ServerQueries: MSysObjects  (not editable)

Referrals
AccessCode: 
FromOrganization: Organizations
Grant: Grant Codes
Hours: (Value list; not editable)
Incentives: Service Incentives
Outcome: Outcome Scores
Priority: Priority Areas
Provisions: Service Provisions
Reason: Service Reason
Referral: Database Users
ReferralSource: Referral Source Codes
Service: Services
Staff: Database Users

Referrals Sub
Outcome: Outcome Scores

Reports Form
GrantName: Grant Codes
Graph: (Value list; not editable)
Keyword: Keywords
Reports: (Value list; not editable)
Service: Services
Staff: Database Users

Tables
Tables: MSysObjects (not editable)

Transportation
Grant: Grant Codes
Staff: Database Users
TransportID: Transport Codes

Users-Outreach Sub
Staff Participants: Database Users

VR/DFB History
Staff: Database Users
VRStatus: VR Status Codes

Week Log
Break: (Value list; not editable)
CommunityActivity: Community Goal History
FundingType: Funding Codes
Grant: Grant Codes
Hours: (Value list; not editable)
ProjectGoalTask: Project GTE

Projects: Projects
Staff: Database Users
Start: (Value list; not editable)
Stop: (Value list; not editable)

Work Log
ATOutreach: AT Targeted Outreach
CommunityActivity: Community Goal History
Entry_Search: WorkLogCodes
Events: Events
FundingType: Funding Codes
Grant: Grant Codes
Hours: (Value list; not editable)
Org: Organizations
Org_Name_Search: Organizations
Outcome: Community Outcome Measures
PriorityArea: Priority Areas
Project_Search: Projects
ProjectGoalTask: Project GTE
Projects: Projects
Service: CommunityServices
Sites: Work Sites
Staff: Database Users
Type: WorkLogCodes

 

Return to Table of Contents