Since faculty member’s positions and qualifications change over time, several fields in the FACULTY table are historised.
Fill-in or modify a historised field
Historised fields can be identified by a clock icon on the right of the field.
Click on the clock to follow the historic of changes to this field, in the Change History window.
ℹ️A change to a historised value can be duplicated (to repeat the same change on another date), edited (to change the date of the change) or deleted (to cancel the change) from the Change History window.
Historised values are always entered with an effective date.
These historised fields exist in faculty members profiles, in the Institution and Accreditation tabs.
The values and dates associated with historised fields are stored in the FACHISTODETAILS data table.
This data is then used for reports, which are exported with reference periods.
For an AACSB report, for example, we will take into account the actual status of fcaulty members on the last day of the reference period.
If a faculty has been active, then inactive for 2024/2025: he/she will be considered inactive for AACSB for the year 2024/2025.
List of historised fields
- fac_active: Active in the institution
- fac_type: Type of faculty member
- fac_typecontract: Type of contract
- fac_time: % of time for the mission
- fac_time_compute: % of time forced to the institution’s mission
When this field is filled in, it is taken into account as a priority for AACSB and EFMD reports. Otherwise, the fac_time field is taken into account. - fac_time_amba: % of time spent on the institution’s mission (according to AMBA)
- fac_schooltime: Contract time
- fac_gta: Teaching assistant
- fac_campus: Faculty’s main campus
- fac_cnu_section: CNU section
- fac_cqualaacsb2013: AACSB 2013 qualification
- fac_cqualaacsb2020: AACSB 2020 qualification
- fac_ccataacsb: AACSB Category
- fac_specialtyAACSB: AACSB Specialty
- fac_mt: Teaching at master level
- fac_ut: Teaching at “undergraduate” level
- fac_dt: Teaching/monitoring at doctoral level
- fac_res: Consistent research activities
- fac_ed: Consistent intervention in executive education
- fac_adm: Consistent administrative activity
- fac_ser: Consistent administrative activity in the service of the institution
- fac_typefacefmd: EFMD Population
- fac_cat1 / fac_cat2 / fac_cat3 / fac_cat4 / fac_cat5: Other categories
ℹ️All changes to historised values can be followed from the Historic tab on faculty member’s profiles: Faculty roster > Personal information > Historic
Use the FACHISTODETAILS data table
The FACHISTODETAILS table contains all historical data relating to faculty members. This data is used in accreditation reports to obtain the information requested on the period requested.
Only the fields in the FACULTY table – which contains all the data relating to fcaulty members – are historised. The list of historised fields is defined by default in ACADEM and cannot be modified.
The FACHISTODETAILS table can be exported/re-imported from the menu Data > Import > Data > Exportation.
➡️Read this article about importing mass data
This data table is filled in as changes are made to the faculty member’s profile in ACADEM.
It can also be completed or modified directly from the Excel file.
FACHISTODETAILS table fields
- FHIST_codunic: each new modification to a field historised results in the creation of a row in the FACHISTODETAILS table, with a unique code to identify it. The data associated with this modification can then be edited or deleted logically.
- FHIST_fac: this is the unique identifier of the faculty member in the FACULTY table. This field acts as a join between the two tables, to identify the faculty whose data is being modified.
- FHIST_effectdate: this is the date of the change in the historised field.
- FHIST_statusdate: this is the date on which the change takes effect.
Ex: A faculty’s AACSB qualification level has been PA since 1 January 2024. I change this value in the Accreditation tab in his profile to 20 April 2025.
The date recorded in FHIST_effectdate = 20 April 2025.
The date recorded in FHIST_statusdate = 1 January 2024.
- FHIST_value: these are the values entered in the mandatory fields. These values are text values or correspond to reference values.
- FHIST_category: indicates which field in the FACULTY table has been modified.
- FHIST_nvalue: these are numerical values entered in non-mandatory historised fields.
- FHIST_comment: comments entered in certain historised fields, which will then appear in certain reports.
- FHIST_cmaj: the values entered in this column are used to update the table data in the database.
The letter C = created > changes the value of the historised field
The letter M = modified > edits the change to the field in the historic
The letter S = deleted > logically deletes the change from the historic
