CFAL/NetCIL Online
Dropdown List Table Sources
Applies to: CFAL Version 5.42,
NetCIL Desktop 1.42, and NetCIL Online
Updated: 9/18/2013
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