| Field Name |
Length |
Type |
Description |
Comments |
| us_name |
30 |
char |
User Name |
|
| us_id |
9 |
char |
User Id |
|
| us_chid |
15 |
char |
Child ID |
Key Field - links to child file |
| us_passwd |
8 |
char |
User Password |
|
| us_webpw |
8 |
char |
IMS Password |
|
| us_level |
2 |
smallint |
User Access Level |
|
| us_lasttm |
8 |
char |
User Logged on Last - Time |
|
| us_lastdt |
8 |
datetime |
User Logged on Last - Date |
|
| us_uid |
9 |
char |
Record Updated (User ID) |
|
| us_utime |
8 |
char |
Record Updated (Time) |
|
| us_udate |
8 |
datetime |
Record Updated (Date) |
|
| us_ext |
5 |
char |
Telephone Extension |
|
| us_phone |
10 |
char |
Primary Phone Number |
|
| us_timeout |
4 |
int |
Timeout (in seconds) |
|
| us_chf |
2 |
smallint |
Security: Child Screen |
|
| us_imf |
2 |
smallint |
Security: Services Screen |
|
| us_dif |
2 |
smallint |
Security: Disability Screen |
|
| us_svf |
2 |
smallint |
Security:Severity Screen |
|
| us_ref |
2 |
smallint |
Security: Intervention or Referral Screen |
|
| us_evf |
2 |
smallint |
Security: Activity Screen |
|
| us_mef |
2 |
smallint |
Security:Review or Meeting Screen |
|
| us_plf |
2 |
smallint |
Security: Planning Screen |
|
| us_med1 |
2 |
smallint |
Security: Enter Medicaid Claims |
|
| us_med2 |
2 |
smallint |
Security: View Eligilble For Medicaid |
In db as Enter Claims |
| us_med3 |
2 |
smallint |
Secuirty: Build Headers |
|
| us_med4 |
2 |
smallint |
Security: Medicaid Enter Claims and Detail Report |
On User Profile, this is FoxPro |
| us_med5 |
2 |
smallint |
Security: Medicaid Transmit |
|
| us_lookup |
2 |
smallint |
Edit Lookup Tables - FoxPro |
|
| us_util |
2 |
smallint |
Access Custom Utilities y/n |
|
| us_report |
2 |
smallint |
Modify Reports y/n - FoxPro |
|
| us_tdf |
2 |
smallint |
Security: Staff Demographic Screen |
|
| us_tlf |
2 |
smallint |
Security: Staff Licences Screen |
|
| us_tef |
2 |
smallint |
Security: Staff Endorsements Screen |
|
| us_srf |
2 |
smallint |
Security: Staff Departments Screen |
|
| us_aef |
2 |
smallint |
Security: AEA Profile |
|
| us_rzf |
2 |
smallint |
Security: Region Profile |
|
| us_dpf |
2 |
smallint |
Security: District Profile |
|
| us_blf |
2 |
smallint |
Security: Building Profile |
|
| us_agf |
2 |
smallint |
Security: Agency Profile |
|
| us_icf |
2 |
smallint |
Security: Service Locations |
|
| us_aif |
2 |
smallint |
Security: Staff Building Assignments - tdf and Assigned Staff |
|
| us_pof |
2 |
smallint |
Security: Services Eligibility |
|
| us_ipf |
2 |
smallint |
Security: Services Profile |
|
| us_acf |
2 |
smallint |
Security: Associated Adult/Adult Demo Screen |
|
| us_omf |
2 |
smallint |
Security: IEP Results or Results Screen |
|
| us_x1 |
2 |
smallint |
|
|
| us_x2 |
2 |
smallint |
|
|
| us_x3 |
2 |
smallint |
|
|
| us_hears |
2 |
smallint |
Security: Hearing Loss Screen |
|
| us_zipdist |
1 |
bit |
|
|
| us_defprg |
1 |
bit |
|
|
| us_expdays |
2 |
smallint |
|
|
| us_expire |
8 |
datetime |
|
|
| us_eyse |
1 |
bit |
|
|
| us_defmef |
1 |
bit |
|
|
| us_defimf |
1 |
bit |
|
|
| us_bkupmed |
1 |
bit |
|
|
| us_bell |
100 |
char |
|
|
| us_heard |
2 |
smallint |
Security: Hearing Screening Screen |
|
| us_defsvf |
2 |
smallint |
|
|
| us_exit1 |
1 |
bit |
|
|
| us_exit2 |
1 |
bit |
Exit all severities flag |
Preferences |
| us_exit3 |
1 |
bit |
Required: Exit all other services |
Preferences |
| us_invtry |
2 |
smallint |
Security: Inventory Custom Module |
|
| us_ddata |
2 |
smallint |
Security: Date Information Custom Module |
|
| us_atf |
2 |
smallint |
Security:Assistive Technology |
|
| us_email |
250 |
char |
Email Address |
|
| us_eyse2 |
2 |
smallint |
Security:Extended Year School Service |
|
| us_defisee |
2 |
smallint |
|
|
| us_tra |
2 |
smallint |
Security: Course Enroll Custom Module |
|
| us_crs |
2 |
smallint |
Security: Course Info Custom Module |
|
| us_cec |
2 |
smallint |
Security: Custom Modules CEC FollowUp |
|
| us_rdata |
2 |
smallint |
Security: Review Data Custom Module |
|
| us_pject |
2 |
smallint |
Security: Projection Custom Module |
|
| us_wstudy |
2 |
smallint |
Security: Work Study Custom Module |
|
| us_minute |
2 |
smallint |
Security: Student Minutes Custom Module |
|
| us_x4 |
2 |
smallint |
|
|
| us_x5 |
2 |
smallint |
|
|
| us_x6 |
2 |
smallint |
|
|
| us_x7 |
2 |
smallint |
|
|
| us_x8 |
2 |
smallint |
|
|
| us_x9 |
2 |
smallint |
|
|
| us_menu |
2 |
smallint |
|
|
| us_ip |
16 |
char |
|
|
| us_puf |
2 |
smallint |
Security: Pooling Custom Module |
|
| us_apf |
2 |
smallint |
|
|
| us_mailim1 |
2 |
smallint |
Automatic Email: To Resident AEA when changes to a student attending my AEA |
|
| us_mailim2 |
2 |
smallint |
Preferences: Receive Email from Attending when change Resident student of my AEA |
|
| us_mailim3 |
2 |
smallint |
Preferences: Send Copy of us_mailim1 to yourself |
|
| us_mailim4 |
2 |
smallint |
Preferences: Send copy of email to Attending if different than Resident & not me |
|
| us_aea |
2 |
char |
AEA Number |
|
| us_dist |
16 |
text |
Districts |
|
| us_addr1 |
100 |
char |
Address line 1 |
|
| us_addr2 |
100 |
char |
Address line 2 |
|
| us_city |
30 |
char |
User Profile: City |
|
| us_state |
2 |
char |
State |
|
| us_zip |
5 |
char |
|
|
| us_fax |
10 |
char |
|
|
| us_med |
1 |
bit |
Medicaid Mailing List |
|
| us_mail |
1 |
bit |
Project Easier Mailing List |
|
| us_auth1 |
1 |
bit |
|
|
| us_auth2 |
1 |
bit |
|
|
| us_supp |
1 |
bit |
Primary AEA Mailing List |
|
| us_loc |
1 |
bit |
Primary Location Mailing List |
|
| us_p1 |
1 |
bit |
OGC Mailing List |
|
| us_p2 |
1 |
bit |
Director Mailing List |
|
| us_p3 |
1 |
bit |
Tech Staff Mailing List |
|
| us_p4 |
1 |
bit |
Data Entry Mailing List |
|
| us_other |
1 |
bit |
|
|
| us_iep1 |
1 |
bit |
Web IEP Administration Mailing List |
Main Menu: Access to Admin and User List |
| us_iep2 |
1 |
bit |
|
Main Menu: Access to Review IEPs |
| us_heare |
2 |
smallint |
Security: Hearing Equipment Screen |
|
| us_key |
10 |
char |
|
|
| us_clist |
1 |
bit |
Show on Contact List Flag |
|
| us_bldg |
2 |
smallint |
Building List |
Used for Output Reports |
| us_cef |
2 |
smallint |
|
|
| us_cty |
2 |
smallint |
|
|
| us_olf |
2 |
smallint |
|
|
| us_enroll |
1 |
bit |
|
|
| us_disRpt |
1 |
bit |
|
|