ESIS PROP GEN

DATA VIEW NAME: ESIS_PROP_GEN
OVERVIEW: This view displays Research Administration proposal information from the ESIS system. All information is displayed except for the social security numbers of the principal and corresponding principal investigators.
LOAD FREQUENCY: The information in this view is no longer being refreshed and is current only to February 2008.
DATA CUSTODIAN: Research and Sponsored Programs
Contact: Mark Sweet
AUTHORIZATION: You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
SPECIAL CONSIDERATIONS: 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.
QUESTIONS: Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)
LAST UPDATED: 04/01/94   Project to standardize the data view documentation.
04/24/96   Added Direct Costs and Indirect Cost (rzs)
09/18/96   Added PROJECT_DESC250 – full project description
10/97   Removed fields INDIRECT_COSTS and REVISED_IC_AMOUNT
12/02/03   Added Routing_Number.
05/04   Added Expand Proposal Number to 6 Chars
(displayed as 40).; 2/08 c4j View is no longer being updated.
DATA FORMATS: Primary Key Columns are identified with an asterisk(*)
Alphanumeric Data: VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’
Numeric Data: NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12
Date: DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)

Column Name

Format

Description

*PROPOSAL_NUMBER

Varchar2(40)

A computer assigned sequential number that identifies the proposal.

ROUTING_NUMBER

Varchar2(6)

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

STATUS

Char(1)

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

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

FUND

Char(3)

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.

YEAR

Char(1)

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

ACCT

Char(4)

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.

STATUS_DATE

Char(6)

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.

REQUEST_DATE

Char(6)

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

BEGIN_DATE

Char(6)

The beginning date of the project.
Format: YYMMDD.

END_DATE

Char(6)

The ending date of the project.
Format: MMYYDD.

AGENCY

Char(13)

The abbreviation of an agency providing funding.

AGENCY1

Varchar2(5)

The abbreviation of an agency providing funding.

AGENCY2

Varchar2(4)

The abbreviation of an agency providing funding.

AGENCY3

Varchar2(4)

The abbreviation of an agency providing funding.

NONDIRECT

Char(2)

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.

DONOR_DESC

Char(50)

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.

DONOR_DESC200

Varchar2(200)

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

DONOR_TYPE

Char(1)

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

	Donor Type	Definition
	Blank	Not known
	A	Corporation-Domestic
	B	Companies-Domestic-Nonmanufacturing (American Family etc)
	C	Business Cooperatives, Associations, Commissions, Institutes
	D	Health related organization
	E	University of Wisconsin Foundation
	F	Foundations-Corporate
	G	Foundations-Philanthropic, Other
	H	Foreign Corporations, Universities, Hospitals, & Other Business Ventures
	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

DONOR_ADDRESS

Char(100)

Address of the donor of the award.

PROJECT_TYPE

Char(2)

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

Project Code

Description

suspense

overhead

faculty-staff salary support

student salary support

employee-interchange agreement

named professorships

research-health related (non-federal)

research-industrial (non-federal)

research-other (non-federal)

research (federal)

doctoral dissertation research

research career awards

research training program educational research training program traineeships

Research participation

institutes (academic, summer, advanced study etc.)

preparation of personnel in the education of handicapped

educational personnel development program

instruction-training-general

instruction-training-women

instruction-training-minority

instruction-training-in service

faculty developmen

fellowship-predoctoral

fellowship-postdoctoral

fellowship-special

fellowship-international

“NDEA Title IV”

“NDEA Title VI”

fellowship-graduate

G1	assigned
G2	disadvantaged
G3	campus fellowships
G4	E.B. Fred
G5	grad special
G6	supplement
G7	travel

fellowship-science faculty

fellowship supply allowance

fellowship-miscellaneous

construction-remodeling-renovations

landscaping-planting

exhibits

miscellaneous

patient care

equipment

computer usage

radio-television production

lecture programs

scholarships

short course programs

prizes, awards

graduate student support

loans

work-study

tuition and fees only

curriculum improvement and development

libraries

books, journals

language and area centers

travel

Title I of Higher Education Act of 1965

Title II of Higher Education Act of 1965

Title III of Higher Education Act of 1965

headstart program

upward bound program

conference, workshop, symposium

publications

editorial-secretarial expenses

institutional programs

international programs

discretionary-unrestricted

PROJECT_UDDS

Char(7)

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

PROJECT_DESC

Char(50)

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.

REVISED_BUDGET

Char(1)

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

REVISED_AMT_REQ

Number(11,2)

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

PI_NAME

Char(30)

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

PI_UDDS

Char(7)

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

CO_PI_NAME

Char(30)

The name of a second person working on the project.

CO_UDDS

Char(7)

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

PREDECESSOR_ACCT

Char(4)

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

REQUEST_TYPE

Char(1)

The type of proposal request.
Valid values are:

Request Codes	Description
N	new
R	renewal
C	continuation
S	supplement

LOADDATE

Date

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

ORIG_AMT_REQUESTED

Number(11,2)

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

PROJECT_DESC250

Char(250)

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