Employee Database

How It Works

The employee database and its API Plugin are tools that can be used in conjunction with one another to display information about employees in campus departments. This page will walk you through using the Employee Database block on your page to display employee information.

Instructions

  • Create the "Employee Database" block and add it to your site.
    • Go to "Add Content" > "Blocks" > "Row Blocks" and select the "Employee Database" Block.
  • Navigate to the Employee Database API Plugin  and retrieve the numerical codes to enter into the Block.
    • Select the "School" or "College" you are looking for.
    • Select the "Department" you are looking for.
    • Select the "Type" of employee you are looking for.
    • Select the "Tag" associated with that employee Note: Some departments don't use tags, the query will revert to "Type" if this is the case.
  • Take note of the numerical values of the School/College, Department, Type and Tag produced by the API.
  • Back in Cascade, edit the "Employee Database" block you created. Enter the information generated from the API into the appropriate fields.
  • Submit your changes.
  • Publish your changes. NB: the Employee Database block does not display fully in Cascade, but only on the live site. Cascade will only display the numerical values retrieved from the API. 

Breakdown of the API codes.

  • School ID: Each school within the database is referenced by a unique ID. 
  • Department ID: In combination with the school ID, this identifies your department within the Faculty Database. 
  • ID(s): Each person in the system is associated with a personnel "type" (Professor, Adjunct, Staff, etc.), and you can filter by these IDs.
  • Tag ID(s): Some departments choose to further categorize by research area or specialty with tags.

 apiv2crop.jpg

data-base-feilds.jpg

The section below is an example of what you should see after attaching the employee database block.

Faculty

Irene Appelbaum

Irene Appelbaum

Professor, Linguistics

Leora Bar-el

Leora Bar-el

Professor, Linguistics Program, Department of Anthropology

Gregory Campbell

Gregory Campbell

Professor

Kelly Dixon

Kelly Dixon

Professor

John Douglas

John Douglas

Professor

Ardi Kia

Ardi Kia

Professor, Director of the Central and Southwest Asian Studies Program

Cheyenne Laue

Cheyenne Laue

Instructor

Douglas MacDonald

Douglas MacDonald

Professor, Director of Graduate Studies

Mizuki Miyashita

Mizuki Miyashita

Professor, Director of Linguistics Program

Anna Prentiss

Anna Prentiss

Regents Professor of Anthropology

Randall Skelton

Randall Skelton

Professor

Meradeth Snow

Meradeth Snow

Associate Professor & Co-Chair of Anthropology

G.G. Weix

G.G. Weix

Professor