zushiba
09-27-2010, 01:23 PM
I work for a college and we use Vbulletin to run the research departments website which I administrate.
For some time I've been writing custom applications for various departments on campus to track various things. Course of Records, Student Learning Outcomes, Program information etc.
Lets say I've got a bunch of tables that look like this.
Programs
:ChancelorID VarChar 11
:Top Code VarChar 11
:Created Date DateStamp
:Date Apped for Curriculum DateStamp
:More stuff Whatever
Can this be used to house such information?
Can it keep historical records of changes? -I'm doing this right now by simply not allowing edited records and instead creating new records then grouping on ChancelorID (for instance), that way we can see who edited what by comparing ids.
Can it be organized by any one of the above fields?
We're using the CMPS right now and if the Dynamics addon can handle this stuff I can see the department head being rather interested in it.
For some time I've been writing custom applications for various departments on campus to track various things. Course of Records, Student Learning Outcomes, Program information etc.
Lets say I've got a bunch of tables that look like this.
Programs
:ChancelorID VarChar 11
:Top Code VarChar 11
:Created Date DateStamp
:Date Apped for Curriculum DateStamp
:More stuff Whatever
Can this be used to house such information?
Can it keep historical records of changes? -I'm doing this right now by simply not allowing edited records and instead creating new records then grouping on ChancelorID (for instance), that way we can see who edited what by comparing ids.
Can it be organized by any one of the above fields?
We're using the CMPS right now and if the Dynamics addon can handle this stuff I can see the department head being rather interested in it.