130 likes | 259 Views
NCCCS Phase 2b Conversion Meeting. Conversions. What takes place during a conversion ? Create an extract data file on the IIPS system (SCP-2512) FTP the extract file to the Colleague box Create an intermediate file on Colleague box (STII) Intermediate file is imported into Colleague (ITCI).
E N D
Conversions What takes place during a conversion? • Create an extract data file on the IIPS system (SCP-2512) • FTP the extract file to the Colleague box • Create an intermediate file on Colleague box (STII) • Intermediate file is imported into Colleague (ITCI)
Colleague Accounts Colconv • Used to run a small data sample on each conversion • Main purpose of this account is to verify the conversion is setup correctly prior to running in Coltest or Collive
Colleague Accounts Coltest • Used to run a subset of data that will be used in testing and training • Errors identified during conversions will allow data cleanup in preparation for later conversion into Collive
Colleague Accounts Collive • All conversions will be run in their entirety • Additional errors corrected
STII (Source to Intermediate Import) • STII checks data (translate tables, Valcodes, Codefiles) to determine if it is clean and ready for converting and/or importing into Colleague • If clean, STII places the places data into an intermediate database (i.e. holding area) • STII can be run in non-update and update mode • Errors generated involving data are most often best corrected in legacy (IIPS)
ITCI (Intermediate to Colleague Import) • ITCI takes data from intermediate file, performs additional checks, and imports into Colleague • ITCI can be run in non-update and update mode • Additional errors could be generated in update mode that were not seen in non-update mode (as records are imported)
Custom Conversions • HST-POS (Historical Academic Programs) • XNCP (Additional Demographics) • HRD (Human Resource Development) • Hold (Student Holds/Restrictions) • LEIS(Literacy Education Information System) • SBC (Small Business Center)
17 Student Conversions (Includes Custom) • HST-POS – Historical Programs of Study • LCC – Local Courses • STU_DEM – Student Demographics • XNCP – Additional (NC) demographics • STU – Primary academic program • PGM – Additional academic programs • TST – Test scores • STA – Student’s advisors
17 Student Conversions (cont.) • IIA1 – High schools attended • IIA2 – Other colleges attended • IIA3 – Home institution credentials • SBC - Small Business Center • HRD – Human Resources Development • ARI – Student account balances • Hold – Student holds/restrictions • LEIS – Literacy Education Info. Sys. • STC – Student Transcripts
Coltest Timeline • April, 2005 – November, 2005 • Coltest conversions scheduled to benefit and enhance user training and testing requirements • Coltest conversions help identify data cleanup necessary on legacy system prior to converting into Collive account
Collive Timeline • December, 2005 – June, 2006 • Conversions scheduled to support go-live dates
Support • Weekly conversion calls • SO Help Desk • Extract creation for each conversion is menu driven on IIPS • Each Colleague conversion has separate documentation