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
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
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.

 

Skip to content