Data Feeds – Detailed Design
Using the conceputual design as a basis for further development, a dataflow diagram was developed for exchange of data between the Cascadia Community College and the University of Washington Seattle (Computing & Communications group. Please see the attached PDF – DataFeedsCascadia
Data Elements sent from Cascadia Community College to UW Seattle |
Name | Characteristics | Required to Create AVF Record |
Student ID/Employee ID | 9 characters, alpha | Yes |
Name | 22 characters, alpha | Yes |
Address | ? characters, alpha | No |
City | ? characters, alpha | No |
State | 2 characters, alpha (ST) | No |
Zipcode | 9 characters, numeric | No |
Birth Date | 10 characters, YYYY-MM-DD | No |
Phone (Daytime) | 12 characters, AAA-PPP-NNNN | No |
Phone (Evening) | 12 characters, AAA-PPP-NNNN | No |
Employee/Student Status | 3 characters, alpha (EMP or STU) | Yes |
Data Feed Characteristics
Pipe Delimited File, unix or DOS
ID, Name, and Status are required in order to create a AVF Record
A full feed data feed is required
Only active records should be included in the feed
Employees and Students records should be in one feed
Name provided by Cascadia is 22 characters maximum
Double Blanks will be used when there is no value
All feed processing should be completed and sent by 10pm daily
Data Feed Processing
A status update page will be created by Jon Pass that will include the latest date the feed was processed for use by C&CI and the Help Desks at Cascadia
In order to set up processing Jonathan will set up all the accounts for use by Cascadia. Each member should provide Jon Pass with the necessary information in order to create the accounts. Jonathan Pass will be the account owner and James McShane and Michael Klim will be designated as Registered Users.
Data Elements sent from UW Seattle to Cascadia Community College |
Name | Characteristics | Required |
Student ID/Employee ID | 9 characters, alpha | Yes |
UW AVF PAC | 6 characters, alphanumeric, case sensitive | Only if New |
Data Feed Characteristics
Delimited File
The feed includes all Student and Employee ID’s but only includes an UW AVF PAC if the ID is new Employees and Students records should be in one feed
Double Blanks will be used when there is no value
All feed processing should be completed and sent by 2am daily
Data Feed Processing
Cascadia Ccmmunity College (CCC) Status: for associate faculty (may be here Fall and Summer, but still need access in between). When they aren't on the payroll, they won't be in the feed. Our suggestion is to handle these exceptions with temp ids.
Staff records appear in feed the night of the day they went on payroll.
Student records appear in the feed when they're enrolled, changes a lot during first week or two of the quarter.
Initially, a discussion was held that required the UW to communicate directly with the CTC Office in Bellevue. However, after further discussion, the conceptual design was agreed upon as a more appropriate method. The design agreed upon would allow for a more seamless integration.