ESIS_PROPOSALS

This view displays all Research Administration proposal information from the ESIS system.

The information in this view is updated every weeknight, Monday - Friday.

Research and Sponsored Programs;
Robert Andresen

No approval signature is required by the Data Custodian to receive
authorization to access this data view.

For information about how to get authorized for InfoAccess data views, connect to the Infoaccess home page.

NOTE: Data on proposal records that were created between 1971 and 1981 may have values in fields that do not conform to today’s definitions due to different standards and definitions used during that time period.

Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)

A computer assigned sequential number that identifies the proposal.

A unique number assigned to proposals from PALS, the internal RSP tracking
system.

This describes the status of the proposal.  Valid codes are:

	Status Code	Definition
	P	pending
	W	withdrawn
	R	rejected by Agency
	A	approved by Agency
	N	approved, but not funded
	I	inactive

The fund that has been assigned to this award.  A fund is an independent fiscal and accounting entity with a self-balancing set of accounts and a stated purpose or set of objectives.

The State fiscal year of this project. 
Valid values are:
   Blank
   0-9

The account number assigned to this award.  This is used for records that are organized by project rather than by organizational entity.  This is normally used for gift and grant funds.

This represents the date of the next Regent meeting if the proposal is awarded, or the current date if the project is rejected or withdrawn.
Format: YYMMDD.

This identifies the date that the proposal was processed by research administration. 
Format: YYMMDD.

The beginning date of the project. 
Format: YYMMDD.

The ending date of the project. 
Format: MMYYDD.

The abbreviation of an agency providing funding.

The abbreviation of an agency providing funding.

The abbreviation of an agency providing funding.

The abbreviation of an agency providing funding.

Identifies Federal funds awards to the UW through a Non-federal agency acting as prime contractor.  If 'ND' entered then Federal Agency is the AGENCY_CODE field, and prime contractor is in DONOR_DESCRIPTION.

The description of the donor.  This could be the donor's name or an agency translation.  This is just the first 50 characters of the title.  The title length is actually 200 characters long.

The full 200 character description of the donor.  This could be the donor's name or an agency translation. 

A classification of the donor or granting agency. 
Valid values are:

	Donor Type	Definition
	Blank	Not known
	A	Corporation
	B	Corporate foundations
	C	Alumni
	D	Health related organization
	E	Other individuals or families
	F	Foundations
	G	Other organizations, societies, etc.
	H	Ggovernmental units other than federal
	I	Wisconsin Alumni Research Foundation (WARF)
	J	Government-Federal (All 144 145 146 147 148 Accts)
	K	Multiple donors
	L	Government - State - WI
	M	Government - County - WI
	N	Government - City - WI
	O	Government - Domestic  (Other State, County, City)
	P	Government - Foreign (United Nations World Bank)
	Q	University, School, Hospital - Public
	R	University, School, Hospital - Private
	S	Public Broadcasting (The Friends of WHA & others)
	T	Public Broadcasting (CPB, PBS, NPR, public radio and TV stations)
	U	Individuals, Trusts & Estates (not-alumni/Brittingham)
	V	Non-business Associations, Clubs, Committees, Societies, Councils, Guilds, Leagues (social and professional)
	W	Alumni including trusts and estates (Vilas)
	X	Other UW System Foundations
	Z	Overhead, Suspense, Revolving

Address of the donor of the award.

This code is used to identify types of projects.  Not all projects will have a value in this field.

	Project Code	Description
	01	suspense
	02	overhead
	03	faculty-staff salary support
	04	student salary support
	05	employee-interchange agreement
	06	named professorships
	07	research-health related (non-federal)
	08	research-industrial (non-federal)
	09	research-other (non-federal)
	10	research (federal)
	11	doctoral dissertation research
	12	research career awards
	20	research training program educational research training program traineeships
	21	Research participation
	22	institutes (academic, summer, advanced study etc.)
	23	preparation of personnel in the education of handicapped
	24	educational personnel development program
	25	instruction-training-general
	26	instruction-training-women
	27	instruction-training-minority
	28	instruction-training-in service
	29	faculty developmen
	30	fellowship-predoctoral
	31	fellowship-postdoctoral
	32	fellowship-special
	33	fellowship-international
	34	"NDEA Title IV"
	35	"NDEA Title VI"
	36	fellowship-graduate
		G1 assigned G2 disadvantaged G3 campus fellowships G4 E.B. Fred G5 grad special G6 supplement G7 travel
	37	fellowship-science faculty
	38	fellowship supply allowance
	39	fellowship-miscellaneous
	40	construction-remodeling-renovations
	41	landscaping-planting
	44	exhibits
	45	miscellaneous
	49	patient care
	50	equipment
	51	computer usage
	52	radio-television production
	53	lecture programs
	60	scholarships
	61	short course programs
	62	prizes, awards
	63	graduate student support
	66	loans
	68	work-study
	69	tuition and fees only
	70	curriculum improvement and development
	71	libraries
	72	books, journals
	73	language and area centers
	74	travel
	75	Title I of Higher Education Act of 1965
	76	Title II of Higher Education Act of 1965
	77	Title III of Higher Education Act of 1965
	85	headstart program
	86	upward bound program
	90	conference, workshop, symposium
	91	publications
	92	editorial-secretarial expenses
	95	institutional programs
	97	international programs
	98	discretionary-unrestricted

The UDDS charged with administering the project for the principal investigator.  It may or may not be the UDDS where the principal investigator resides.

The title of the project or proposal.  This is just the first of 50 characters of the title.  The title length is actually 250-characters long.

Indicate the number of times the proposal budget has been revised.
     (1 to 9)
     Defaults to "N" = NO.

The revised amount of direct costs the extramural sponsor is asked to provide.  Must be entered if the REVISED BUDGET field is changed.

The name of the principal investigator for the project.  A principal investigator is the person who administers the grant or submitted the proposal.

The social security number of the principal investigator.

The UDDS (unit, division, department, sub-department) of the principal investigator.

The name of a second person working on the project.

The social security number of the second person working on the project.

The UDDS (unit, division, department, sub-department) of the second person working on the project.

The account number that identified the project during the previous year.

The type of proposal request. 
Valid values are:

	Type Codes	Description
	N	new
	R	renewal
	C	continuation
	S	supplement

The date of the most recent data load. 
Format: YYYYMMDD HH24:MI:SS.

The amount of direct costs the extramural sponsor is asked to provide.

This is the full 250-character description of the project description.