DOC PREVIEW
Terms_Concepts

This preview shows page 1 out of 2 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 2 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 2 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

Terminology & Concepts Relevant to SIS-SIG TopicsPrepared by Carol Boyer 7/20/2006FAIC = Financial & Administrative Information Council From their website <http://www.musc.edu/ocio/imc/working_groups/faic/index.shtm>:"The FAIC serves as a subcommittee of the Information Management Committee(IMC).... the FAIC provides input to the IMC regarding business processes as well as theuse of technologies to improve financial and administrative activities across the MUSCenterprise. The FAIC also works ... with ... Special Interest Groups (SIGs). ...[helpingto]... develop and apply policy and strategy, and assists with operational oversight for allfinancial and administrative activities performed across the MUSC enterprise.."The bottom line for us: Any project that requires manpower or money must have abusiness plan presented to the FAIC for approval before proceeding.Members of the FAIC are non-OCIO-IS (OCIO-IS has only unofficial representation).http://www.musc.edu/ocio/imc/working_groups/faic/members.shtml Colleague R18 Upgrade Standard Colleague workflows are not affected, so end-users do not require re-training onColleague’s forms or their business processing.The biggest impact for end-users: a) the requirement to use UI b) the loss of the colon promptThe colon prompt is where super-users currently write and run reports (queries).In R18, reports that are already written can be added to a menu and run from within Colleague. (The super-users are primarily Carol, George, Sandra, & Billy)New queries can be written in R18 using "Query Builder", but it doesn't have all the features and functions available at the colon prompt.Computed Column – new term for what was previously known as a virtual field or I-descriptor. These are calculated values, as opposed to data values that are entered into the database. A data field would be something like LAST_NAME,where "Smith" is a value that was typed in or imported from a file. A computed column would be a field like AGE, which subtracts the person's birthdate (which is stored in a data field) from the current date, resulting in a calculated value of (for example) 25. It's like a cell in an excel spreadsheet that contains a formula, so the value in that cell is (for example) the calculated sum of a column instead of an actual number that was typed in.A more complex example is the computed column that determines Life Scholarship eligibility by evaluating a student's course load, the cumulative number of credits and gpa from all schools the student attended, etc.Something as simple as printing a student's MNA on a report requires a computed column, because Colleague can store multiple email addresses. So to print only the MNA, the computed column XM25.MNA.EMAIL is created with the following code: SUBR('AR.LOCATE','MNA',SUBR('S.MIO.TRANS','PERSON',STUDENTS.ID, 'PERSON.EMAIL.TYPES','X'));IF @1 THEN EXTRACT(SUBR('S.MIO.TRANS','PERSON',STUDENTS.ID, 'PERSON.EMAIL.ADDRESSES','X'),@VM,@1,1)ELSE ''In R18, the computed column syntax (code) is different, so the current ones will have to be converted or re-written. This is a big deal because we have created 2,665 computed columns! The "Behind The Scenes" Impact Of R18Datatel has re-vamped the technical architecture framework of Colleague to make it database-independent, which lets institutions choose from three databases (Microsoft’s SQL Server, Oracle, and IBM’s UniData). It will also help Datatel adapt to future technologies like web services more quickly. But there are many changes to the way things are set up and done, and involves a large learning curve for the programmers.Another major change is that Release 18 will require that all custom code be converted toEnvision. Colleague has been around for 20 years and was originally written in UniBasic language. Over the years, Datatel created a development tool called Envision. Many of MUSC's customizations are written in UniBasic and need to be


Terms_Concepts

Download Terms_Concepts
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Terms_Concepts and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Terms_Concepts 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?