SoN Logo Office for Nursing Research

Admin Panel

Grant Information System

Links below can be used to update the short descriptions for projects, add and remove personnel to grants and edit their involvement on specific projects using Calendar Months. All edits are logged by username and datestamp. Edits are live, please be careful.

    Sorry, but your account () is not authorized to edit projects in the GIS database, please contact Seth Wolpin (swolpin@u.washington.edu) to request access

Seminar and Software Pages

Please select a resource to manage, note that your account may not allow access to these tools. If you would like access please contact the Office for Nursing Research.

Sorry, it doesn't look like you have administrative rights for any application

Other Reports

Documentation

Currently being updated. SW 11-16-2007

Reports using live tables

Misc Notes

In December, 2007, a full copy of the 2004 research review was placed within the restricted admin directory for reference purposes. The public version continues to exist, however links to the abstracts have been removed.

Functions in BackendShared.asp (all use live tables unless otherwise noted).

Generic

Function LastUpdate()
this is shared by Research/Grants and Research/Internal/GIS
this DOES NOT hit the live db and will someday be deprecated

Function EscapeForDB(FieldName)
' Use when accepting any form input

Function RenderForScreen(FieldName)
' Use when outputting anything that may have an apostrophe in it

Personnel

Function ReturnPersonnelName(PersonID,Format)
' Format argument must be passed w/double quotes, accepts LNameFName, FNameLName, and LName

Function ReturnRoleLookupText(RoleID)

Function ReturnCurrentPIID(ProjectID)
'Business Rule: People can have multiple entries in the Grant Personnel Table for a single grant. Choose the one with the latest Personnel End Date.

Function ReturnPersonIDByEmail(Email)
'Used on /faculty/faculty_bio.asp page because there is no PersonID to call OutputPersonnelCurrentProjects(PersonID,CallerLocation,HeadingLevel)

Function ReturnCountPersonnelProj(PersonID,GrantStatusID,SoNFaculty)
'Returns the number of projects a person is participating in
'GrantStatusID can be 1=Active, 2=Pending, 3=Closed
'SoNFaculty is usually = "true" because that is what we are usally counting for.
'Should be able to get count out of SQL statement but I could not get anything to group correctly - complicated by duplicate proj/pers entries in personnel table for different time periods.

Function ReturnMaxEndDateGPDetails(PersonID,ProjectID)
'Current Personnel Details on Any Grant
'Business Rule: People can have multiple entries in the Grant Personnel Table for a single grant. Choose the one with the latest Personnel End Date.
'Caution: This returns a numerical array. Always add new fields in the SQL statement after the previous fields so as to not change the field placement in the array for pages that are using this function.
'Used on Other Support Report.
'rsMaxEndDateGPDetails = ReturnMaxEndDateGPDetails(rs("PersonID"),rs("ProjectID"))

Function ReturnCalMonthsForActiveGrant(ProjectID,PersonID)
'Current calendar Months on Any Active Grant AS OF TODAY
'Business Rule: People can have multiple entries in the Grant Personnel Table for a single grant. Choose the Calendar Months for a GP row where the P start end End Date are between now (per late Oct '2006 conversation w/Mark S.
'Used on Other Support Report.


Function ReturnCalMonthsForPendingGrant(ProjectID,PersonID)
'Current calendar Month on Pending Active Grant
'NEEDS VERFIFICATION
'Business Rule: People can only have one GP entry for a pending grant ????
'Used on Center Report.

Sub OutputPossibleExternalPersonnelDetails(PersonID)
'Displays Photo and Faculty details from SonWebFaculty Database via a linked table if they exist
'Used by Show Abstract and ListPersonnelProjects on public ONR pages.

Sub OutputPersonnelCurrentProjects(PersonID,CallerLocation,HeadingLevel)
'This lists all of their Active Projects in bullet format along with a link to the abstract
'CallerLocation can be "Faculty Pages" If it is called from the faculty_bio_pages we want the linked abstract to be on the ONR public pages so we need to alter the path
'If it is "Normal" then it is from within the ONR public pages or the Intranet Pages.
'Heading Level should be 1-8 and is used to display the header tags that wrap "Current Projects"

Projects

Function ReturnGrantStatusLookupText(GrantStatusID)

Function ReturnProjectDetail(ProjectID,FieldName)
'Currently Unused as of 8/14 SHOULD Buld more flexible numerical array approach like ReturnMaxEndDateGPDetails(PersonID,ProjectID)
'Response.Write(ReturnProjectDetail(rs("ProjectID"),"GrantProjectTitleID")) & vbcrlf 'Returns Title

Sub ShowAbstract(ProjectID,ShowFooterLinks,ShowOtherProjectLinks)
'Displays Abstract Title, then the PI with personnel details, then everyone on the projects with optional links to their ListPersonnelProjects page, and finally the abstract
'Show footer links is usually set to "No" except on the CWHGR page where it should be "Yes"
'ShowOtherProjectLinks produces a count of other active projects for any SoN faculty that are associated with the project and a link to their ListPersonnel Projects Page, it is usuall
'set to "Yes" except on the CWHGR page where it should be set to "No"


Sub ListProjectsByAgency(AgencyID,GrantStatusID)
'Displays a bulleted list of Active (1), Pending (2), and Closed (3) grants for any AgencyID along with links to ShowAbstract.asp
'Currently used by CWHGR to display Active and Closed grants.

Fiscal

Function ReturnFundingAgency(AgencyID,FundingLevel)
'Returns the full text name for the funding agency listed in the Projects Table
'FundingLevel should be passed as 1,2,3,4

Function ReturnHasFiscalInfo(ProjectID)
'Does the grant have any fiscal information?
'this is used by the OS Report as a safety check before calling ReturnMaxEndDateFiscalDetails.
'External Grants don't usually have fiscal details tracked by Toni. ReturnMaxEndDateFiscalDetails
'should be able to return false but that isn't working well.

Function ReturnMaxAwardDateFiscalDetails(ProjectID)
'What are the latest fiscal details for a grant?
'Business Rule: Grants can have multiple entries in the fiscal table - one for each year. For the OS Report's Grant 'Number and Direct 'Awarded select the one with the greatest end date. This returns a numerical array
'need to be cautious this is not (?) being called by pending grants.

Function ReturnMaxEndDateFiscalDetails(ProjectID)
'What are the latest fiscal details for a grant?
'Business Rule: Grants can have multiple entries in the fiscal table - one for each year. For the OS Report's Grant 'Number and Direct Awarded select the one with the greatest end date. This returns a numerical array
'DEPRECATED for all but Pending Reports (which have no award date) and replaced with ReturnMaxAwardDate(ProjectID)

Seminars

Function ListSeminars(TimePeriod,Audience,SO,SF,FileStem)
'used by internal/Admin/Seminars and by ONR non-intranet Seminars page
'Past/Upcoming and Public/Admin, index (or the stem of whatever file is calling this - used in reload for sorting
'content below must be on page before calling this function
'SO = Request.QueryString("SO") 'sort order
'SF = Request.QueryString("SF") 'sort order

Function SeminarBullets(Audience)
'Upcoming Seminars on ONR Home page
Office for Nursing Research :: Phone: 206-685-1525 :: Contact Us