| Data element |
Definition |
ACAD_1_END_DT
Format DATE
Indexed? No
May be Null? Yes |
The end date of the recent academic appointment listed first in the Background section of the Case Summary Form. |
ACAD_1_INST
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The institution of the recent academic appointment listed first in the Background section of the Case Summary Form. |
ACAD_1_TITLE
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The rank/title of the recent academic appointment listed first in the Background section of the Case Summary Form. |
ACAD_2_END_DT
Format DATE
Indexed? No
May be Null? Yes |
The end date of the recent academic appointment listed second in the Background section of the Case Summary Form. |
ACAD_2_INST
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The institution of the recent academic appointment listed second in the Background section of the Case Summary Form. |
ACAD_2_TITLE
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The rank/title of the recent academic appointment listed second in the Background section of the Case Summary Form. |
ACAD_3_END_DT
Format DATE
Indexed? No
May be Null? Yes |
The end date of the recent academic appointment listed third in the Background section of the Case Summary Form. |
ACAD_3_INST
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The institution of the recent academic appointment listed third in the Background section of the Case Summary Form. |
ACAD_3_TITLE
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The rank/title of the recent academic appointment listed third in the Background section of the Case Summary Form. |
ADMIN_1_TITLE
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The title of the recent position listed first in the Administrative/Clinical section of the Case Summary Form. |
ADMIN_2_LOC
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The location of the recent position listed first in the Administrative/Clinical section of the Case Summary Form. |
ADMIN_2_TITLE
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The title of the recent position listed second in the Administrative/Clinical section of the Case Summary Form. |
ADMIN_3_LOC
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The location of the recent position listed second in the Administrative/Clinical section of the Case Summary Form. |
ADMIN_3_TITLE
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The title of the recent position listed third in the Administrative/Clinical section of the Case Summary Form. |
ADMIN_1_LOC
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The location of the recent position listed third in the Administrative/Clinical section of the Case Summary Form. |
ADMIN_1_TERM
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The duration of the recent position listed first in the Administrative/Clinical section of the Case Summary Form. |
ADMIN_2_TERM
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The duration of the recent position listed second in the Administrative/Clinical section of the Case Summary Form. |
ADMIN_3_TERM
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The duration of the recent position listed second in the Administrative/Clinical section of the Case Summary Form. |
AVG_TEACHING_SCORE
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The average teaching score rating noted in the Teaching and Mentoring section of the Case Summary Form. |
AWARD_1
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
Information about the award/honor/service activity listed first in the Impact and Service section of the Case Summary Form |
AWARD_2
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
Information about the award/honor/service activity listed second in the Impact and Service section of the Case Summary Form |
AWARD_3
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
Information about the award/honor/service activity listed third in the Impact and Service section of the Case Summary Form |
DECLINATION_NOTES
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
Notes about reviewers' or consultants' declination reasons for declining to comment, from the Consultants Summary section of the Case Summary Form. |
FIELD
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The candidates Field of Study, as described in the Expertise section of the Case Summary Form. |
GRANTS
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The current types of Grants for the candidate, as listed in the Grants section of the Case Summary Form. |
GRANTS_NOTES
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
Notes about significant grants activity since the last review cycle, as described in the Grants section of the Case Summary Form. |
MENTORING
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The candidate's Mentoring activities, as listed in the Teaching and Mentoring section of the Case Summary Form. |
NOTES
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
Additonal comments supplied by the Dean, as noted in the Dean's Comments section of the Case Summary Form. |
NUM_BOOKS
Format NUMBER
Indexed? No
May be Null? Yes |
The number of books the candidate has authored or edited, as noted in the Scholarly Productivity section of the Case Summary Form. |
NUM_ED_REV_CHAP
Format NUMBER
Indexed? No
May be Null? Yes |
The number of Editorials, Review, or Chapters the candidate has authored, as noted in the Scholarly Productivity section of the Case Summary Form. |
LECTURES
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
Indicates whether the candidate has been invited to lecture nationally or internationally, as displayed in the Scholarly Productivity section of the Case Summary Form. |
NUM_LETTERS_RECD
Format NUMBER
Indexed? No
May be Null? Yes |
The number of external reviewer or consultant letters received for the case, as displayed in the Consultants Summary section of the Case Summary Form. |
NUM_LETTERS_REQ
Format NUMBER
Indexed? No
May be Null? Yes |
The number of external reviewer or consultant letters requested for the case, as displayed in the Consultants Summary section of the Case Summary Form. |
NUM_PATENTS
Format NUMBER
Indexed? No
May be Null? Yes |
The number of patents held by the candidate, as noted in the Scholarly Productivity section of the Case Summary Form. |
NUM_PEER_REVIEWED
Format NUMBER
Indexed? No
May be Null? Yes |
The number of the candidate's peer-reviewed publications, as noted in the Scholarly Productivity section of the Case Summary Form. |
NUM_OTHER_PUBS
Format NUMBER
Indexed? No
May be Null? Yes |
The number of the candidate's other publication contributions, as noted in the Scholarly Productivity section of the Case Summary Form. |
OTHER_PUBS_DESC
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
Details about other publication contributions, as noted in the Scholarly Productivity section of the Case Summary Form. |
SERVICE
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The current types of Service activity for the candidate, as listed in the Impact and Service section of the Case Summary Form. |
TEACHING
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The candidate's Teaching activities, as listed in the Teaching and Mentoring section of the Case Summary Form. |
CASE_ID
Format NUMBER
Indexed? Yes
May be Null? No |
The system ID of the related case in the Interfolio system. |
CREATED_AT
Format DATE
Indexed? No
May be Null? Yes |
The date on which the case summary record was created in Interfolio. |
UPDATED_AT
Format DATE
Indexed? No
May be Null? Yes |
The date on which the case summary record was updated in Interfolio. |
CREATED_BY_FIRST_NAME
Format VARCHAR2(400)
Indexed? No
May be Null? Yes |
The first name of the person who created the case summary record. |
CREATED_BY_LAST_NAME
Format VARCHAR2(400)
Indexed? No
May be Null? Yes |
The last name of the person who created the case summary record. |
CREATED_BY_PENN_KEY
Format VARCHAR2(96)
Indexed? No
May be Null? Yes |
The PennKey of the person who created the case summary record |
CREATED_BY
Format NUMBER
Indexed? No
May be Null? Yes |
The unique Interfolio system identifier for the person who created the case summary record. |
UPDATED_BY
Format NUMBER
Indexed? No
May be Null? Yes |
The unique Interfolio system identifier for the person who updated the case summary record. |
