| Data element |
Definition |
AGENCY_CODE
Indexed - no
Format - char (4)
May be null? yes |
The 4-character code that identifies an agency to which a proposal has
been sent. Example: 1043 (Peace Corps). Agency codes that are made up
of numerals are BEN Financials fund sponsor codes. Agency codes that begin
with letters are translations of the 5-character agency codes used before
November 24, 1997 for Sponsored Projects data in the Warehouse. Agency
codes that begin with a letter ('X', 'Y', or 'Z') refer only to agencies
that sponsored projects before July 1, 1996 and that are not included
in the BEN Financials Fund Sponsor Codes table because the agencies no
longer exist.
Values:
Refer to the AGENCY Table for values.
|
AGENCY_REF_NUMBER
Indexed - no
Format - char (27)
May be null? yes |
The identification number that is assigned to the award by the sponsoring
agency. (For proposals that are not awarded, the value may be null, or
an educated guess based on the AGENCY_REF_NUMBER for earlier awards for
the project.) For example: 1-N01-HV-020002-000 is an agency reference
number that is assigned by NIH (National Institutes of Health).
Values:
Maximum 27 characters
|
ANIMALS_FLAG
Indexed - no
Format - char (1)
May be null? yes |
Indicates whether the project involves the use of animals. If animals
are used for the project, an animal protocol must be approved by Regulatory
Affairs. (See also the Animals_Protocol_Id in the PROPOSAL table.) Examples:
Y (animals are used for the project), [Null] (animals are not used for
the project)
Values:
[Null] No animals are used for the project
Y Animals are used for the project
|
ANIMALS_PROTOCOL_ID
Indexed - no
Format - char (8)
May be null? yes |
The 8-character code assigned by Regulatory Affairs to identify
the protocol for the use of animals in the project. See also ANIMALS_FLAG.
Values:
List of values not available.
|
CARCINOGENIC_MATERIALS_FLAG
Indexed - no
Format - char (1)
May be null? yes |
Indicates whether the project involves the use of carcinogenic
agents. Examples: Y (the project involves the use of carcinogenic agents),
[Null] (the project does not involve the use of carcinogenic agents)
Values:
[Null] No carcinogenic agents are used in the project
Y Carcinogenic agents are used in the project
|
CLINICAL_TRIAL_FLAG
Indexed - no
Format - char (1)
May be null? yes |
Indicates whether the project is a clinical trial. See also
the Clinical_Trial_Protocol_Id in the PROPOSAL table. Examples: Y (the project
is a clinical trial), [Null} (the project is not a clinical trial)
Values:
[Null] Not a clinical trial
Y Clinical trial
|
CLINICAL_TRIAL_PROTOCOL_ID
Indexed - no
Format - char (20)
May be null? yes |
The 20-character code assigned by the sponsoring agency to
identify the protocol for conducting clinical trials for the project. See
also CLINICAL_TRIAL_FLAG.
Values:
List of values not available.
|
CO_PI_HOME_ORG
Indexed - yes
Format - char (4)
May be null? yes |
The 4-character code that identifies the Co-Principal Investigator's
home Organization as of the time of the proposal. (If the proposal has an
associated award or advance account record in the AWARD table, once the
end date for the associated AWARD record has passed, CO_PI_HOME_ORG is no
longer updated. For other proposals, once the end date for the proposal
has passed, CO_PI_HOME_ORG is no longer updated.) The home Organization
is the one that owns the Co-Principal Investigator's employee record and
is responsible for its maintenance. The code set comes from the present
General Ledger accounting structure (in use at Penn since July 1, 1996).
If there is no record of the Co-Principal Investigator's home Organization
as of the time of the proposal, the value of CO_PI_HOME_ORG will be set
to '.' (rather than null) to facilitate Organization-based security in the
Warehouse.
Values:
Refer to the ORG_CODES Table for values.
|
CO_PI_HOME_SCHOOL
Indexed - yes
Format - char (2)
May be null? yes |
The 2-character code that identifies the Co-Principal Investigator's
home school or center as of the time of the proposal. (If the proposal
has an associated award or advance account record in the AWARD table,
once the end date for the associated AWARD record has passed, CO_PI_HOME_SCHOOL
is no longer updated. For other proposals, once the end date for the proposal
has passed, CO_PI_HOME_SCHOOL is no longer updated.) The home school or
center is the one that owns the Co-Principal Investigator's employee record
and is responsible for its maintenance . The code set comes from the present
General Ledger accounting structure (in use at Penn since July 1, 1996).
If there is no record of the Co-Principal Investigator's home school or
center as of the time of the proposal, the value of CO_PI_HOME_SCHOOL
will be null.
Values:
Refer to the CNAC_CODES Table for values. The code
for a school or center is the same as the first 2
characters of the CNAC.
|
COMMITTED_YEARS
Indexed - no
Format - char (2)
May be null? yes |
The number of years beyond the current funding period for which the sponsor
has committed funding for the entire project. The value will be 0 for
proposal records.
Values:
List of values not available.
|
|
CREATE_DATE
Indexed - no
Format - date
May be null? yes
|
The date when the source record was created. The source record is the
record in the Research Services system that is the source of the data
in this Proposal record.
Create_Date is stored in the Warehouse in date format. In Business Objects,
it is displayed as specified in the desktop operating system settings.
It is recommended that users specify a date format that includes 4 digits
for the year. (To specify the date format in Windows 95, choose the Regional
Settings of the Control Panel, select the Date tab and specify the Short
date style. In Windows, use the International option of the Control Panel.
On the Macintosh, use the Date & Time Control Panel.) Example: 06/29/1994.
Values:
List of values not available.
|
|
DIRECT_COST_AMOUNT
Indexed - no
Format - number (9)
May be null? yes
|
Total dollar amount proposed for direct costs for the grant/contract
period. This is equal to the TOTAL_AGENCY_AMOUNT minus the INDIRECT_COST_AMOUNT.
Values:
0 to 999999999
|
DNA_SUBJECT_FLAG
Indexed - no
Format - char (1)
May be null? yes |
Indicates whether the project involves recombinant DNA activity. Examples:
Y (the project involves recombinant DNA activity), [Null] (the project
does not involve recombinant DNA activity)
Values:
[Null] No recombinant DNA activity is involved in
the project
Y Recombinant DNA activity is involved in the
project
|
DOMESTIC_TRAVEL_AMOUNT
Indexed - no
Format - number (9)
May be null? yes |
Total amount proposed for domestic travel for the grant/contract period.
Note that for records dating from November 24, 1997 and thereafter, DOMESTIC_TRAVEL_AMOUNT
will not populated.
Values:
0 to 999999999
|
END_DATE
Indexed - yes
Format - date
May be null? yes |
The award end date as proposed to the project's sponsoring agency. This
information is stored in the Warehouse in date format. In Business Objects,
it is displayed as specified in the desktop operating system settings.
It is recommended that users specify a date format that includes 4 digits
for the year. (To specify the date format in Windows 95, choose the Regional
Settings of the Control Panel, select the Date tab and specify the Short
date style. In Windows, use the International option of the Control Panel.
On the Macintosh, use the Date & Time Control Panel.) Example: 8/31/1998.
Values:
List of values not available.
|
EQUIPMENT_AMOUNT
Indexed - no
Format - number (9)
May be null? yes |
Total amount proposed for equipment for the grant/contract period. Note
that for records dating from November 24, 1997 and thereafter, EQUIPMENT_AMOUNT
will not populated.
Values:
0 to 999999999
|
EXTENSION_CODE
Indexed - no
Format - char (1)
May be null? yes |
The 1-character code indicating whether the proposal is new, an extension,
or a renewal.
Values:
G Grant change (change of grantee institution)
N New
P Pre-proposal
R Renewal/Competing Continuation (Used primarily
with PHS grants to show competing continuation for
a new project period.)
S Supplement
V Revision
X Extension, amendment or non-competing continuation
|
FISCAL_YR_END
Indexed - yes
Format - char (4)
May be null? yes |
The fiscal year in which the award ends, as proposed to the sponsoring
agency.. Penn's fiscal year begins July 1 of one calendar year and ends
June 30 of the next calendar year. Example: 1998 (for a proposal whose
END_DATE is 12/31/1997)
Values:
List of values not available.
|
FISCAL_YR_START
Indexed - yes
Format - char (4)
May be null? yes |
The fiscal year in which the award begins, as proposed to the sponsoring
agency. Penn's fiscal year begins July 1 of one calendar year and ends
June 30 of the next calendar year. Example: 1997 (for a proposal whose
START_DATE is 01/01/1997)
Values:
List of values not available.
|
FISCAL_YR_STATUS
Indexed - yes
Format - char (4)
May be null? yes |
The fiscal year in which the proposal was submitted to the sponsoring
agency. See also AWARD / FISCAL_YR_STATUS. (Note: for rejected or withdrawn
proposals, the fiscal year of the rejection or withdrawal is not stored.)
Penn's fiscal year begins July 1 of one calendar year and ends June 30
of the next calendar year. Example: 1997 (for a proposal whose STATUS_DATE
is 11/15/1996)
Values:
List of values not available.
|
FOREIGN_TRAVEL_AMOUNT
Indexed - no
Format - number (9)
May be null? yes |
Total amount proposed for foreign travel for the grant/contract period.
Note that for records dating from November 24, 1997 and thereafter, FOREIGN_TRAVEL_AMOUNT
will not populated.
Values:
0 to 999999999
|
GRANT_CONTRACT_CODE
Indexed - no
Format - char (1)
May be null? yes |
The 1-character code indicating the proposed type of award. Examples:
G (government grant); I (industry/corporation) ???
Values:
G Government Grant (Federal/State/Local)
C Government Contract (Federal/State/Local)
N Non-Government, Foundations, Associations
I Industry/Corporation
|
HUMAN_PROTOCOL_ID
Indexed - no
Format - char (8)
May be null? yes |
The 4- to 7-character code assigned by Regulatory Affairs to identify
the protocol for the use of human subjects in the project. See also HUMAN_SUBJECTS_FLAG.
Values:
List of values not available.
|
HUMAN_SUBJECTS_FLAG
Indexed - no
Format - char (1)
May be null? yes |
Indicates whether the project involves human subjects, as noted in the
Human Subjects certification. See also the Human_Protocol_Id in the PROPOSAL
table. Examples: Y (the project involves human subjects), [Null] (the
project does not involve human subjects)
Values:
[Null] No human subjects are involved in the project
Y Human subjects are involved in the project
|
INDIRECT_COST_AMOUNT
Indexed - no
Format - number (9)
May be null? yes |
Total dollar amount proposed for indirect costs for the grant/contract
period.
Values:
0 to 999999999
|
INDIRECT_COST_RATE
Indexed - no
Format - number (5,2)
May be null? yes |
A 5-digit number (with 2 decimal places) indicating the proposed rate
of indirect cost recovery. The INDIRECT_COST_RATE multiplied by the portion
of the direct costs subject to indirect cost recovery equals the INDIRECT_COST_AMOUNT.
Values:
0 to 100.00
|
INFECTIOUS_AGENTS_FLAG
Indexed - no
Format - char (1)
May be null? yes |
Indicates whether the project involves the use of infectious agents.
Examples: Y (the project involves the use of infectious agents), [Null]
(the project does not involve the use of infectious agents)
Values:
[Null] No infectious agents are used in the project
Y Infectious agents are used in the project
|
LAST_EXTRACT_DATE
Indexed - no
Format - date
May be null? yes |
The date this proposal record was extracted from the Research Services
system and loaded into the Warehouse. This information is stored in the
Warehouse in date format. In Business Objects, it is displayed as specified
in the desktop operating system settings. It is recommended that users
specify a date format that includes 4 digits for the year. (To specify
the date format in Windows 95, choose the Regional Settings of the Control
Panel, select the Date tab and specify the Short date style. In Windows,
use the International option of the Control Panel. On the Macintosh, use
the Date & Time Control Panel.) Example: 9/22/1997.
Values:
List of values not available.
|
MODIFY_DATE
Indexed - no
Format - date
May be null? yes |
The date when the source record was last updated. The source record is
the record in the Research Services system that is the source of the data
in this Proposal record.
Modify_Date is stored in the Warehouse in date format. In Business Objects,
it is displayed as specified in the desktop operating system settings.
It is recommended that users specify a date format that includes 4 digits
for the year. (To specify the date format in Windows 95, choose the Regional
Settings of the Control Panel, select the Date tab and specify the Short
date style. In Windows, use the International option of the Control Panel.
On the Macintosh, use the Date & Time Control Panel.) Example: 9/10/1997.
Values:
List of values not available.
|
NIH_GRANT_ACTIVITY_CODE
Indexed - no
Format - char (3)
May be null? yes |
A 3-character code used by NIH to identify a specific category of extramural
activity. For example: N01 (Research and Development Contracts) is the
activity code in the NIH reference number 1-N01-HV-020002-000. Only populated
if agency is NIH and this is a federal grant. (For proposals that are
not awarded, the value may be null, or an educated guess based on the
AGENCY_REF_NUMBER for earlier awards for the project.)
Values:
Refer to IMPAC handbook for the list of NIH
administrative organizations.
|
NIH_GRANT_ADMIN_ORG
Indexed - no
Format - char (2)
May be null? yes |
A 2-letter code that identifies the first major level subdivision within
an NIH organization. For example: in the NIH reference number 1-N01-HV-020002-000,
HV (Division of Heart and Vascular Diseases) is an administrative organization
within NIH. Only populated if agency is NIH and this is a federal grant.
(For proposals that are not awarded, the value may be null, or an educated
guess based on the AGENCY_REF_NUMBER for earlier awards for the project.)
Values:
Refer to IMPAC handbook for the list of NIH
administrative organizations.
|
NIH_GRANT_APPLICATION_TYPE
Indexed - no
Format - char (1)
May be null? yes |
A single-digit code that identifies the type of grant application
received and processed by NIH. For example: 1 (New) is the application type
in the NIH reference number 1-N01-HV-020002-000. Only populated if agency
is NIH and this is a federal grant. (For proposals that are not awarded,
the value may be null, or an educated guess based on the AGENCY_REF_NUMBER
for earlier awards for the project.)
Values:
Refer to IMPAC handbook for the list of NIH codes and
application types.
|
NIH_GRANT_SERIAL_NUMBER
Indexed - no
Format - char (6)
May be null? yes |
A 6-digit number generally assigned sequentially by NIH to number awards.
For example: 020002 is the serial number in the NIH reference number 1-N01-HV-020002-000.
Only populated if agency is NIH and this is a federal grant. (For proposals
that are not awarded, the value may be null, or an educated guess based
on the AGENCY_REF_NUMBER for earlier awards for the project.) Note: prior
to June, 2002, this was a 5-digit number. Existing NIH grants had a leading
zero added to their NIH Grant Serial Numbers in June, 2002.
Values:
Refer to IMPAC handbook for additional information
on NIH serial numbers.
|
NIH_GRANT_SUPPLEMENT
Indexed - no
Format - char (4)
May be null? yes |
A 4-character code identifying a supplement, amendment, or allowance
awarded by NIH. For example: in the NIH reference number 3-R01-CA-012921-04-S1A1,
the letter S and the related number identifies each supplement, for example,
S1, S2 (Supplement 1, Supplement 2) and the letter A and the related number
identifies each amendment, for example A1, A2 (Amendment 1, Amendment
2). NIH_Grant_Supplements containing an X are allowances. In the example
1-N01-HV-020002-0000, there is no supplement, amendment or allowance.
Only populated if agency is NIH and this is a federal grant. (For proposals
that are not awarded, the value may be null, or an educated guess based
on the AGENCY_REF_NUMBER for earlier awards for the project.)
Values:
Refer to IMPAC handbook for additional information
on NIH supplements, amendments, and allowances.
|
NIH_GRANT_YEAR
Indexed - no
Format - char (2)
May be null? yes |
A 2-digit number that indicates the actual segment or budget period of
an NIH award. The grant year number is increased by one for each succeeding
renewal year. For example: in the NIH reference number 3-R01-CA-012921-04,
04 is the grant year--meaning that the grant is in its fourth year. Only
populated if agency is NIH and this is a federal grant. (For proposals
that are not awarded, the value may be null, or an educated guess based
on the AGENCY_REF_NUMBER for earlier awards for the project.)
Values:
Refer to IMPAC handbook for additional information
on NIH grant years.
|
ORA_CONTACT_INITIALS
Indexed - no
Format - char (3)
May be null? yes |
The 3 initials of the Research Services staff member who is the contact
person for this proposal. See also ORA_CONTACT.
Values:
List of values not available.
|
ORA_CONTACT
Indexed - no
Format - char (35)
May be null? yes |
The name of the Research Services staff member who is the contact person
for this proposal. The value may be up to 25 characters long. See also
ORA_CONTACT_INITIALS.
Values:
List of values not available.
|
ORA_PURPOSE_CODE
Indexed - no
Format - char (2)
May be null? yes |
The 2-character code assigned by the ORA (Office of Research Administration)
to designate the purpose of the project. Examples: 01 (Research), 05 (Student
Aid)
Values:
Refer to the ORA_PURPOSE Table for values.
|
ORG_LOG_NUMBER
Indexed - yes
Format - char (8)
May be null? yes |
The identification number that is assigned to the proposal by the Organization
at Penn responsible for administering the project. Example: 93-0418 is
an identification number assigned by the Medical School.
Values:
List of values not available.
|
ORIGINAL_PROPOSAL_DATE
Indexed - no
Format - date
May be null? yes |
The date on which the original proposal for the funding cycle was submitted
to the sponsoring agency. Note: in cases where the funding cycle is composed
of more than one funding increment (Project Segment ID), Original Proposal
Date is the submission date for the proposal for the first funding increment
within the funding cycle, even when the proposal record that is being
queried is for a later funding increment within the funding cycle. Note
also: in cases where the project period is composed of more than one funding
cycle, the Original Proposal Date refers to the first proposal for the
funding cycle, not the first proposal for the project period. See also
PROPOSAL / STATUS_DATE and AWARD / DATE_AWARDED.
The funding cycle is the total period of time for which the sponsor is
being asked to make an award for a project (usually 1 to 5 years). The
funding cycle can be composed of one or more funding increments. (Each
time the sponsor is asked to pay an installment of the award (or to guarantee
payment), that installment is a funding increment.) The project period
is the time from the date the sponsor first authorized an award for a
project through the end of the last funding cycle. The project period
can be composed of one or more funding cycles.
Original Proposal Date is stored in the Warehouse in date format. In
Business Objects, it is displayed as specified in the desktop operating
system settings. It is recommended that users specify a date format that
includes 4 digits for the year. (To specify the date format in Windows
95, choose the Regional Settings of the Control Panel, select the Date
tab and specify the Short date style. In Windows, use the International
option of the Control Panel. On the Macintosh, use the Date & Time
Control Panel.) Example: 06/30/1994.
Values:
List of values not available.
|
OTHER_EXPENSES_AMOUNT
Indexed - no
Format - number (9)
May be null? yes |
Total amount proposed for miscellaneous expenses for the grant/contract
period. Note that for records dating from November 24, 1997 and thereafter,
OTHER_EXPENSES_AMOUNT will not populated.
Values:
0 to 999999999
|
PI_HOME_ORG
Indexed - yes
Format - char (4)
May be null? yes |
The 4-character code that identifies the Principal Investigator's home
Organization as of the time of the proposal. (If the proposal has an associated
award or advance account record in the AWARD table, once the end date
for the associated AWARD record has passed, PI_HOME_ORG is no longer updated.
For other proposals, once the end date for the proposal has passed, PI_HOME_ORG
is no longer updated.) The home Organization is the one that owns the
Principal Investigator's employee record and is responsible for its maintenance.
The code set comes from the present General Ledger accounting structure
(in use at Penn since July 1, 1996). If there is no record of the Principal
Investigator's home Organization as of the time of the proposal, the value
of PI_HOME_ORG will be set to '.' (rather than null) to facilitate Organization-based
security in the Warehouse.
Values:
Refer to the ORG_CODES Table for values.
|
PI_HOME_SCHOOL
Indexed - yes
Format - char (2)
May be null? yes |
The 2-character code that identifies the Principal Investigator's home
school or center as of the time of the proposal. (If the proposal has
an associated award or advance account record in the AWARD table, once
the end date for the associated AWARD record has passed, PI_HOME_SCHOOL
is no longer updated. For other proposals, once the end date for the proposal
has passed, PI_HOME_SCHOOL is no longer updated.) The home school or center
is the one that owns the Principal Investigator's employee record and
is responsible for its maintenance . The code set comes from the present
General Ledger accounting structure (in use at Penn since July 1, 1996).
If there is no record of the Principal Investigator's home school or center
as of the time of the proposal, the value of PI_HOME_SCHOOL will be null.
Values:
Refer to the CNAC_CODES Table for values. The code
for a school or center is the same as the first 2
characters of the CNAC.
|
PI_PRI_APPT_ORG
Indexed - yes
Format - char (4)
May be null? yes |
The 4-character code that identifies the Organization for the Principal
Investigator's primary job appointment as of the time of the proposal.
(If the proposal has an associated award or advance account record in
the AWARD table, once the end date for the associated AWARD record has
passed, PI_PRI_APPT_ORG is no longer updated. For other proposals, once
the end date for the proposal has passed, PI_PRI_APPT_ORG is no longer
updated.) The code set comes from the present General Ledger accounting
structure (in use at Penn since July 1, 1996). If there is no record of
the Organization for the Principal Investigator's primary job appointment
as of the time of the proposal, the value of PI_PRI_APPT_ORG will be set
to '.' (rather than null) to facilitate Organization-based security in
the Warehouse.
Values:
Refer to the ORG_CODES Table for values.
|
PI_PRI_APPT_SCHOOL
Indexed - yes
Format - char (2)
May be null? yes |
The 2-character code that identifies the school or center for the Principal
Investigator's primary job appointment as of the time of the proposal.
(If the proposal has an associated award or advance account record in
the AWARD table, once the end date for the associated AWARD record has
passed, PI_PRI_APPT_SCHOOL is no longer updated. For other proposals,
once the end date for the proposal has passed, PI_PRI_APPT_SCHOOL is no
longer updated.) The code set comes from the present General Ledger accounting
structure (in use at Penn since July 1, 1996). If there is no record of
the school or center for the Principal Investigator's primary job appointment
as of the time of the proposal, the value of PI_PRI_APPT_SCHOOL will be
null.
Values:
Refer to the CNAC_CODES Table for values. The code
for a school or center is the same as the first 2
characters of the CNAC.
|
PROJECT_COST_SHARING_AMOUNT
Indexed - no
Format - number (9)
May be null? yes |
The total dollar amount proposed to be supplied by the University of
Pennsylvania as part of a cost sharing agreement with the sponsor. (For
some research projects, the sponsor agrees to fund the project only if
the receiving institution supplies an agreed upon amount of money to supplement
the sponsor-supplied amount.) Note that for records dating from before
November 24, 1997, PROJECT_COST_SHARING_AMOUNT will not be populated.
See also PROJECT_COST_SHARING_SOURCE.
Values:
0 to 999999999
|
PROJECT_COST_SHARING_SOURCE
Indexed - no
Format - char (50)
May be null? yes |
The proposed source of the cost sharing funds. (For some research projects,
the sponsor agrees to fund the project only if the receiving institution
supplies an agreed upon amount of money to supplement the sponsor-supplied
amount.) Note that for records dating from before November 24, 1997, PROJECT_COST_SHARING_SOURCE
will not be populated. See also PROJECT_COST_SHARING_AMOUNT.
Values:
List of values not available.
|
PROJECT_ID
Indexed - yes
Format - char (5)
May be null? no |
The 5-digit code that uniquely identifies a project. (This is the same
as the first five digits of the PROPOSAL_ID.) Example: 27036.
Values:
00000 to 99999
|
PROJECT_SEGMENT_ID
Indexed - yes
Format - char (7)
May be null? yes |
The 7-digit code that identifies a sponsored research project and its
funding increment. (This is the same as the first 7 digits of the PROPOSAL_ID.)
The first 5 digits identify the sponsored project. (See also PROJECT_ID.)
The last 2 digits identify the funding increment. (Each time the sponsor
is asked to pay an installment of the award (or to guarantee payment),
that installment is a funding increment.) Example: 2703600
Values:
0000000 to 9999999
|
PROP_RESP_ORG
Indexed - yes
Format - char (4)
May be null? yes |
The 4-character code that identifies the Organization responsible for
the proposal at the time of the proposal. The code set comes from the
present General Ledger accounting structure (in use at Penn since July
1, 1996). If it cannot be determined which Organization was responsible
for the proposal at the time of the proposal, the value of PROP_RESP_ORG
will be set to '.' (rather than null) to facilitate Organization-based
security in the Warehouse.
Values:
Refer to the ORG_CODES Table for values.
|
PROP_RESP_SCHOOL
Indexed - yes
Format - char (2)
May be null? yes |
The 2-character code that identifies the school or center for the Organization
responsible for the proposal at the time of the proposal. The code set
comes from the present General Ledger accounting structure (in use at
Penn since July 1, 1996).
Values:
Refer to the CNAC_CODES Table for values. The code
for a school or center is the same as the first 2
characters of the CNAC.
|
PROPOSAL_ID
Indexed - yes
Format - char (9)
May be null? no |
The 9-digit number identifying the proposal for a funding increment to
a sponsored research project. The first 5 digits identify the project.
The next two digits identify the funding increment (which may be 00 for
proposals). (Each time the sponsor is asked to pay an installment of the
award (or to guarantee payment), that installment is a funding increment.)
The last two digits are meaningless for proposals. (See also PROJECT_ID
and PROJECT_SEGMENT_ID in the PROPOSAL table, and AWARD_ID in the AWARD
table.) (Note that in the Research Services transaction processing system,
the last two digits of Proposal_Id will always be 00 for records dating
from November 24, 1997 and thereafter.)
Values:
000000000 to 999999999
|
RADIOACTIVE_MATERIAL_FLAG
Indexed - no
Format - char (1)
May be null? yes |
Indicates whether the project involves the use of radioactive materials
or radiation-producing machines. See also the Radioactive_Protocol_Id
in the PROPOSAL table. Examples: Y (radioactive materials or radiation-producing
machines are used for the project), [Null] (radioactive materials or radiation-producing
machines are not used for the project)
Values:
[Null] No radioactive materials or radiation-
producing machines are used for the project
Y Radioactive materials or radiation-producing
machines are used for the project
|
RADIOACTIVE_PROTOCOL_ID
Indexed - no
Format - char (8)
May be null? yes |
The 8-character code assigned by the Radiation Safety Office to identify
the protocol for the use of radioactive materials in the project. See
also RADIOACTIVE_MATERIAL_FLAG.
Values:
List of values not available.
|
START_DATE
Indexed - yes
Format - date
May be null? yes |
The award start date as proposed to the project's sponsoring agency.
This information is stored in the Warehouse in date format. In Business
Objects, it is displayed as specified in the desktop operating system
settings. It is recommended that users specify a date format that includes
4 digits for the year. (To specify the date format in Windows 95, choose
the Regional Settings of the Control Panel, select the Date tab and specify
the Short date style. In Windows, use the International option of the
Control Panel. On the Macintosh, use the Date & Time Control Panel.)
Example: 9/22/1997.
Values:
List of values not available.
|
STATUS_DATE
Indexed - no
Format - date
May be null? yes |
The date on which the original proposal for the funding cycle was submitted
to the sponsoring agency. Note: in cases where the funding cycle is composed
of more than one funding increment (Project Segment ID), Status Date is
the submission date for the proposal for the first funding increment within
the funding cycle, even when the proposal record that is being queried
is for a later funding increment within the funding cycle. Note also:
in cases where the project period is composed of more than one funding
cycle, the Status Date refers to the first proposal for the funding cycle,
not the first proposal for the project period. See also PROPOSAL / ORIGINAL_PROPOSAL_DATE
and AWARD / DATE_AWARDED.
The funding cycle is the total period of time for which the sponsor is
being asked to make an award for a project (usually 1 to 5 years). The
funding cycle can be composed of one or more funding increments. (Each
time the sponsor is asked to pay an installment of the award (or to guarantee
payment), that installment is a funding increment.) The project period
is the time from the date the sponsor first authorized an award for a
project through the end of the last funding cycle. The project period
can be composed of one or more funding cycles.
Status Date is stored in the Warehouse in date format. In Business Objects,
it is displayed as specified in the desktop operating system settings.
It is recommended that users specify a date format that includes 4 digits
for the year. (To specify the date format in Windows 95, choose the Regional
Settings of the Control Panel, select the Date tab and specify the Short
date style. In Windows, use the International option of the Control Panel.
On the Macintosh, use the Date & Time Control Panel.) Example: 06/30/1994.
Values:
List of values not available.
|
STATUS
Indexed - no
Format - char (1)
May be null? yes |
The one-character code indicating the status of a proposal. Examples:
P (proposed), A (awarded)
Values:
A Awarded
P Proposed
R Rejected
V Advance Account
W Withdrawn
|
SUB_CONTRACTOR_AMOUNT
Indexed - no
Format - number (9)
May be null? yes |
Total amount proposed for subcontracts by the University to other institutions,
companies, etc. for the grant/contract period. For records dating from
November 24, 1997 and thereafter, the Research Services system will not
store subcontract amounts for proposals. For those records, SUB_CONTRACTOR_AMOUNT
will be 0 ???.
Values:
0 to 999999999
|
TITLE
Indexed - no
Format - char (100)
May be null? yes |
The first 100 characters of the title of the project.
Values:
List of values not available.
|
TOTAL_AGENCY_AMOUNT
Indexed - no
Format - number (9)
May be null? yes |
Total dollar amount proposed for the grant/contract period.
Values:
1 to 999999999
|
TOTAL_COMPENSATION_AMOUNT
Indexed - no
Format - number (9)
May be null? yes |
Total amount proposed for salary and benefits for the grant/contract
period. Note that for records dating from November 24, 1997 and thereafter,
TOTAL_COMPENSATION_AMOUNT will not populated.
Values:
0 to 999999999
|
TUITION_AMOUNT
Indexed - no
Format - number (9)
May be null? yes |
Total amount proposed for tuition and fees for trainees for the grant/contract
period. Note that for records dating from November 24, 1997 and thereafter,
TUITION_AMOUNT will not populated.
Values:
0 to 999999999
|
UNIVERSITY_EXPENSES_AMOUNT
Indexed - no
Format - number (9)
May be null? yes |
Total amount proposed for University charges (i.e. mail, service centers)
for the grant/contract period. Note that for records dating from November
24, 1997 and thereafter, UNIVERSITY_EXPENSES_AMOUNT will not populated.
Values:
0 to 999999999
|
