PENNERA_INCR_STAT_HIST Table
DWSP Schema
Explanation
Records information on how the status of an increment (within a funding
cycle (proposal) for a sponsored project) has changed over time. An increment
is the portion of an award payment (or of an advance paid in expectation
of an award) that applies to a given budget period within the proposal, and
that has been (or will be) assigned to a General Ledger account. The PENNERA_INCR_STAT_HIST
table
includes
the
proposal's
ID (INSTITUTION_NO),
the increment number, the status, the
effective date of that status,
and information on when and by whom the status data was entered. There is one
PENNERA_INCR_STAT_HIST record per proposal per increment for each change
in the request's status.
Common Uses
- Reporting on increments based on how their status has changed over
time. ("How much time passed between when the increment was placed in
Advance Account status and when it became Awarded?")
Primary Key |
Indexed Data Elements |
Related Tables |
PROP_NO
INCREMENT_NUMBER
INCR_STAT_SEQUENCE_NO
|
HISTORY_STATUS
INCREMENT_NUMBER
INCREMENT_STATUS
INSTITUTION_NO
|
PENNERA_PEOPLE
PENNERA_PERIOD
PENNERA_PROPOSAL
PENNERA_PROPOSAL_ACTIVITY
PENNERA_INCREMENT
PENNERA_PROPOSAL_INVESTIGATOR
PENNERA_PROPOSAL_PARENT
PENNERA_PROP_REGULATORY_APPR
PENNERA_PROP_STAT_HIST
|
Cautions
- There are two different unique identifiers for a proposal (funding
cycle): INSTITUTION_NO and PROP_NO. INSTITUTION_NO is the identification
number assigned by the University. PROP_NO is the identification number used
internally by the PennERA system. For a given record, INSTITUTION_NO will not have
the same value as PROP_NO. While either one may be used when joining PennERA
Proposals tables, INSTITUTION_NO is the one recommended for display in reports.
- Records with an INSTITUTION_NO less than or equal to 05017400 were converted
from the Research Services System (RSS, the system used to track proposals
and awards before October 14, 2003). Other records are for proposals created
in PennERA.
- The INCREMENT_NUMBER uniquely identifies an increment within a proposal.
Each increment applies to one and only one budget period within the
proposal; a
budget period may include zero or more increments. For information
on the budget period to which an increment applies, see the record
in the PENNERA_INCREMENT table for the INSTITUTION_NO (or PROP_NO) and the
INCREMENT_NUMBER.
- The PENNERA_INCR_STAT_HIST table stores information on how the status
of an increment has changed over time. The
current status of the increment is also stored in the PENNERA_INCREMENT
table. For
the current
status
for
the proposal
(funding
cycle), see the PENNERA_PROPOSAL
table. For more details on how the proposal's status has changed over time,
use the PENNERA_PROP_STAT_HIST table.
- PennERA stores two dates in the increment status history record: the INCREMENT_STATUS_DATE
(the date the status went into effect), and the RECORDED_DATE (the date the
increment status history record was created).
- When an increment status history record is being created by a PennERA
user, the values for the INCREMENT_STATUS_DATE and the RECORDED_DATE
have the system date as their default value. Before the record is saved,
the INCREMENT_STATUS_DATE is edited (if necessary) to reflect the date
when the INCREMENT_STATUS went into effect. The value of the RECORDED_DATE,
however, is always the date when the increment status history record
was created. For example, if an increment was Awarded as of 10/30/2003,
and that change in status was recorded in PennERA on 11/13/2003, the
increment status history record's INCREMENT_STATUS_DATE is 10/30/2003,
and its RECORDED_DATE is 11/13/2003.
- The INCREMENT_STATUS_DATE always has a non-null value, but some increment
status history records have a null value for the RECORDED_DATE.
- The Research Services System, or RSS, was used before October 14, 2003
to track information on sponsored projects. Records converted from this legacy
system
might have minimal information available
in the PENNERA_INCR_STAT_HIST table.
- Before April 27, 2005, the PennERA system stored status information at
the period level rather than at the request and increment levels. A status
history
record for a given period was converted
to a status history record for each and every increment within that period
as follows:
Period status |
Increment status |
Advance Account |
Advance Account |
Awarded |
Awarded |
Future |
Future |
Future Pending |
Future |
Pending |
not converted; not a valid increment status |
Revised Budget Requested |
not converted; not a valid increment status |
Unfunded |
not converted; not a valid increment status |
Withdrawn |
Awarded |
- Note that some increments (whose status history was converted from
the period status history) may have multiple status history records
for the 'Future' status. In such cases, the record with the earlier
INCREMENT_STATUS_DATE is probably the one derived from the period status
history
record for the 'Future' status. The record with the later INCREMENT_STATUS_DATE
is probably the one derived from the period status history record for
the
'Future Pending' status.
- In most cases, PERIOD_STATUS_DATE and MODIFIED_BY in
a given period status history record were converted to INCREMENT_STATUS_DATE
and MODIFIED_BY in the corresponding increment
status history record for each increment within the period.
- If the current period status as of April 15, 2005 was 'Withdrawn',
regardless of how many history records there were for the period
status, each increment within that period was given only one status
history record, with a status
of 'Awarded'. Its status date was taken from the
award
date for
the increment (PENNERA_INCREMENT.AWARD_DATE). Its value for MODIFIED_BY
was set to null.
- For each increment,
the
INCREMENT_STATUS_DATE for the current status (the status as of
April 15, 2005)
was taken from the award date for
the increment (PENNERA_INCREMENT.AWARD_DATE).
Source
The Proposal Tracking module of PennERA, used at Penn since October 14, 2003
to track information on proposed and awarded
grants
and contracts. Increment status data has been available since April 27, 2005.
PennERA is the University's electronic research administration
system, providing support to faculty and research administrators
for all sponsored project activity at the University of Pennsylvania.
Questions about this page? Email us at da-staff@isc.upenn.edu
|