{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Person Profile","Degree LOV","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Person Profile","index":0,"n_rows":124,"n_cols":4,"rows_kept":124,"cut":false,"hidden":false,"merged":[[123,0,123,2]],"flags":["formulas_cached_only"]}
["Attachment 7 - eRA Commons Person Profile Data"]
["Currently Collected on OMB Cleard Forms"]
["OMB Clearance # 0925-0001"]
["Field Name","Req\nOpt","Type of Field","LOV"]
[]
["Personal Information"]
[]
["Name Prefix","O","Text"]
["First Name","R","Text"]
["Middle Name","O","Text"]
["Last Name","R","Text"]
["Name Suffix","O","Text"]
["SSN (full or last 4)","O","Text"]
["Gender","R","LOV","DNWTP\nFemale\nMale"]
["DOB\n(Include DNWTP option)","R","Date"]
["Citizenship","O","LOV","US Citizen or Non-citizen National\nPermanent Resident\nNon Resident"]
["Citizenship Country","O","LOV","Country List"]
[]
["Disability"]
["Do you have?","O","Y/N"]
["Type of Disability","O","Checkboxes","Hearing\nVisual\nMobility/Orthopedic Impairment\nOther"]
[]
["Race/Ethnicity"]
["Race","R","Checkboxes","American Indian or Alaska Native\nAsian\nBlack or African American\nWhite\nNative Hawaiian or Pacific Islander\nDNWTP"]
["Ethnicity","R","LOV","Hispanic/Latino\nIntentionally Withheld\nNon-Hispanic"]
[]
["Employments"]
["Employer:  Select one:","R"]
["  NIH Recognized Institution",null,"Text"]
["  NIH Institute or Center",null,"LOV","NIH ICs"]
[]
["Employment Info"]
["Start Date","R","Date"]
["End Date","O","Date"]
["Title","O","Text"]
["Employment Status","R","LOV","Full-Time\nPart-Time"]
["Academic Rank","O","LOV","Assistant Professor\nAssociate Professor\nInstructor\nOther\nProfessor"]
["Position","O","LOV","Assistant or Associate Dean\nChairperson of Dept (or Director)\nDean\nOther\nPresident\nVice President"]
["Employment Type","R","LOV","Federal\nNon-Federal"]
["Primary Employment?","N","Checkbox"]
[]
["Employment Address"]
["Line 1","R","Text"]
["Line 2","O","Text"]
["Line 3","O","Text"]
["Line 4","O","Text"]
["City","R","Text"]
["State","R","Text"]
["ZipCode","R","Text"]
["Country","R","LOV","Country List"]
["Phone","R","Text"]
["Fax","O","Text"]
["E-mail","R","Text"]
["Preferred Employment Address?",null,"Checkbox"]
[]
["Reviewer Address"]
["Line 1","R","Text"]
["Line 2","O","Text"]
["Line 3","O","Text"]
["Line 4","O","Text"]
["City","R","Text"]
["State","R","Text"]
["ZipCode","R","Text"]
["Country","R","LOV","Country List"]
["Phone","R","Text"]
["Fax","O","Text"]
["E-mail","R","Text"]
[]
["Residential Address"]
["Line 1","R","Text"]
["Line 2","O","Text"]
["Line 3","O","Text"]
["Line 4","O","Text"]
["City","R","Text"]
["State","R","Text"]
["ZipCode","R","Text"]
["Country","R","LOV","Country List"]
["Phone","R","Text"]
["Fax","O","Text"]
["E-mail","R","Text"]
[]
["Degrees"]
["Degree Name","R","LOV","See separate Tab for LOV"]
["Degree Text (for Other)","O","Text"]
["Degree Completed?","R","Radio Buttons","Yes\nNo/Inprogress"]
["Major","O","Text"]
["Minor","O","Text"]
["Institution","R","Text"]
["Location (if not in US, indicate city & country)","O","Text"]
["Date (or expected Date) of Degree","R","Date"]
["Length of Program (# of Yrs)","O","Text"]
["Area of Residency\n(Adding 1/2009)","O","Text"]
["Residency End Date\n(Adding 1/2009)","O","Date"]
[]
["Publications"]
["Citation ID","O","Text"]
["Citation Text","R","Text"]
[]
["Reference Ltrs"]
["Referee Name"]
["Grant Number"]
["FOA Number"]
["Project Title"]
["Organziation/Affliation"]
["Department"]
["eMail"]
["Submitted Date"]
[]
["Trainee-Specific"]
["Non-Deliquency on US Federal Debt?","R","Radio Buttons","Yes\nNo"]
["Text Entry field if Yes",null,"Text"]
[]
["Disadvantaged Background?","R","LOV","Yes\nNo\nDNWTP"]
[]
[]
["System Generated Fields\nAdding 1/2009"]
["Fields being added to aid in NI/ESI efforts.  All will be system-generated but part of the Person Profile"]
[]
["ESI Eligibility",null,"Yes/No"]
["End of Eligibility Date",null,"Date"]
["New Investigator Eligibility",null,"Yes/No"]
["Appeal Date",null,"Date"]
["Appeal Outcome",null,"Text"]
["Standard NI/ESI Eligibility will be system calculated.  However an exception policy will be implemented.  These exceptions will be handled via an appeal process."]

{"sheet":"Degree LOV","index":1,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Degrees LOV in Person Profile"]
[]
["AB  ","BACHELOR OF ARTS"]
["BA  ","BACHELOR OF ARTS"]
["BS  ","BACHELOR OF SCIENCE"]
["DDS ","DOCTOR OF DENTAL SURGERY"]
["DMD ","DOCTOR OF MEDICAL DENTISTRY"]
["DPH ","DOCTOR OF PUBLIC HEALTH"]
["DSC ","DOCTOR OF SCIENCE"]
["DVM ","DOCTOR OF VETERINARY MEDICINE"]
["EDD ","DOCTOR  OF EDUCATION"]
["MA  ","MASTER OF ARTS"]
["MBBS","FOREIGN - BACHELOR OF MEDICINE AND SURGERY"]
["MD  ","DOCTOR OF MEDICINE"]
["MPH ","MASTER OF PUBLIC HEALTH"]
["MS  ","MASTER OF SCIENCE"]
["PHD ","DOCTOR OF PHILOSOPHY"]
["RN  ","REGISTERED NURSE"]
["SCD ","DOCTOR OF SCIENCE"]
["VMD ","DOCTOR OF VETERINARY MEDICINE"]
["OTH ","OTHER"]
["DRPH","DOCTOR OF PUBLIC HEALTH"]
["BSN ","BACHELOR OF SCIENCE IN NURSING"]
["DC  ","DOCTOR OF CHIROPRACTIC"]
["DNSC","DOCTOR OF NURSING SCIENCE"]
["DO  ","DOCTOR OF OSTEOPATHY"]
["FAAN","FELLOW  OF THE AMERICAN ACADEMY OF NURSING"]
["JD  ","DOCTOR OF JURIS PRUDENCE"]
["MB  ","FOREIGN - BACHELOR OF MEDICINE"]
["MBA ","MASTER OF BUSINESS ADMINISTRATION"]
["MLS ","MASTER OF LIBRARY SCIENCE"]
["MPA ","MASTER OF PUBLIC ADMINISTRATION"]
["MSN ","MASTER OF  SCIENCE IN NURSING"]
["OD  ","DOCTOR OF OPTOMETRY"]
["BOTH","OTHER BACCALAUREATE"]
["MOTH","OTHER MASTERS"]
["DOTH","OTHER DOCTORATE"]
["MDOT","OTHER DOCTOR OF MEDICINE"]
["VDOT","OTHER DOCTOR OF VETERINARY MEDICINE"]
["DDOT","OTHER DOCTOR OF MEDICAL DENTISTRY"]
["ENGD","FOREIGN - DOCTOR OF ENGINEERING"]
["PHMD","DOCTOR OF PHARMACY"]
["ND  ","DOCTOR OF NATUROPATHY"]
["DSW ","DOCTOR OF SOCIAL WORK"]
["PSYD","DOCTOR OF PSYCHOLOGY"]
["DPM ","DOCTOR OF PODIATRIC MEDICINE"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}