PENNERA_PERIOD_STAT_HIST Table - Data Element Index
As of April 28, 2005, this table is no longer
populated in the Data Warehouse.
-
Status is no longer stored at the
period ("budget
period" or "grant year") level in PennERA, but is stored
for each request and for each increment. See the PENNERA_REQ_STAT_HIST
and PENNERA_INCR_STAT_HIST tables.
-
The status of a period cannot be
determined from its request and increment statuses. For example, a
period could have
a "Budget Period" request that is "Awarded," a "Supplement" request
that is " Pending," an increment that is "Awarded," and
an increment in "Advance Account" status.
-
For those doing longitudinal studies, DWSP.SPFY_PENNERA_PERIOD_STAT_HIST
is available. It contains only the snapshot of PENNERA_PERIOD_STAT_HIST
that was taken for fiscal year 2004 (SNAPSHOT_FY = '2004'). See also
DWSP.SPFY_PENNERA_PERIOD.PERIOD_STATUS (populated only in the snapshot
that was taken for fiscal year 2004).
Select a data element to view its definition and its indexed, format, and
null values.
| Data element |
Definition |
HISTORY_STATUS
Indexed - yes
Format - char (1)
May be null? yes |
A one-character code indicating whether the record stores the latest
(current) status for the budget period for the proposal, or an earlier
(historical) status for the budget period for the proposal.
Values:
C The record stores the current (latest) status
for the budget period for the proposal
H The record stores a historical (past) status
for the budget period for the proposal
|
INSTITUTION_NO
Indexed - yes
Format - char (8)
May be null? no |
The eight-digit sequence number used by the University to uniquely identify
the proposal whose budget period status history is tracked by this PENNERA_PERIOD_STAT_HIST
record. Note that the value for INSTITUTION_NO includes leading zeroes.
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.
There are two different unique identifiers for a proposal: INSTITUTION_NO
and PROP_NO. INSTITUTION_NO is used by the University. PROP_NO is used
internally by the PennERA system. For a given record, INSTITUTION_NO
does 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.
There is one PENNERA_PERIOD_STAT_HIST record per proposal (INSTITUTION_NO
or PROP_NO), per PERIOD_NUMBER, per PER_STAT_SEQUENCE_NO
Example: 00216424
Values:
List of values not available
PennERA source: Proposal Tracking module; Summary screen; summary box
in the upper right corner of the screen; Proposal |
LAST_EXTRACT_DATE
Indexed - no
Format - date
May be null? yes |
The date this period status record was extracted from the
PennERA Proposal Tracking system and loaded into the Warehouse.
Example: 10/28/2003
Values:
List of values not available. |
MODIFIED_BY
Indexed - no
Format - char (8)
May be null? yes |
The PennID of the person who entered (or last modified) the period
status record by hand. The name of the person can be found in the PENNERA_PEOPLE
table. If MODIFIED_BY is null, the period status record was entered via
a program, rather than by hand.
Example: ‘10022206’
Values:
List of values not available.
PennERA source: Proposal Tracking module; Requested screen; Status link;
ID
|
PER_STAT_SEQUENCE_NO
Indexed - yes
Format - number (20)
May be null? no |
A sequence number uniquely identifying the status history record within
the proposal and budget period to which it applies. Each proposal and period
(INSTITUTION_NO and PERIOD_NUMBER) has a PER_STAT_SEQUENCE_NO ‘1’.
The maximum PER_STAT_SEQUENCE_NO for a proposal and budget period is the
number of status history records for that budget period for that proposal.
There is one PENNERA_PERIOD_STAT_HIST record per proposal (INSTITUTION_NO
or PROP_NO), per PERIOD_NUMBER, per PER_STAT_SEQUENCE_NO
Examples: 1, 5
Values:
List of values not available
PennERA source: though PennERA does not display the period status sequence
number, it can be found in the Proposal Tracking module; Requested screen;
Status link; the group number for the Status |
PERIOD_NUMBER
Indexed - no
Format - number (10)
May be null? no |
A sequence number uniquely identifying the budget period within the proposal.
Each proposal (INSTITUTION_NO) has a PERIOD_NUMBER ‘1’.
The maximum PERIOD_NUMBER for a proposal is the number of budget periods
for that proposal.
There is one PENNERA_PERIOD record per proposal (INSTITUTION_NO or PROP_NO)
per PERIOD_NUMBER
Examples: 3, 11
Values:
List of values not available
PennERA source: Proposal Tracking module; Requested screen; Requested
Period Costs tab; Period column |
PERIOD_STATUS
Indexed - no
Format - varchar2 (24)
May be null? yes |
The status of the budget period for the proposal, per the sponsor’s
response to the latest request associated with the budget period, as entered
on the PERIOD_STATUS_DATE
Values:
Advance Account—one or more accounts have
been created to track an advance paid by the
department in expectation of an award for the
period
Awarded--the sponsor has awarded funding for the
period, which is current or past
Closed--the accounts for the period have been
closed in BEN
Future--the sponsor has notified the University
of its intent to award funding for the future
period (“out year”)
Future Pending— the sponsor has notified
the University of its intent to award funding
for the future period, and a request for a
non-competing continuation has been submitted
for the period (“out year”)
Pending—the request for the period has
been submitted to the sponsor, and is
pending a decision by the sponsor
Revised Budget Requested—the sponsor has
requested a revised budget for the period
Under Development—not currently used; the
request for the period has not yet been
submitted for University approval
Under Review—not currently used; the
request for the period has been submitted
for University approval (required before
the request can be submitted to the sponsor)
PennERA source: Proposal Tracking module; Requested screen; Status link;
Status |
PERIOD_STATUS_DATE
Indexed - no
Format - date
May be null? yes |
The date the period status record was entered.
Some records that were
converted from the Research Services System (RSS, the system used to
track proposals and awards before October 14, 2003), have a null value
for PERIOD_STATUS_DATE.
Example: 10/30/2003
Values:
List of values not available
PennERA source: Proposal Tracking module; Requested screen; Status link;
Date |
PERIOD_STATUS_FY
Indexed - no
Format - char (4)
May be null? yes |
The fiscal year at Penn in which the PERIOD_STATUS_DATE falls. Penn's
fiscal year begins July 1 of one calendar year and ends June 30 of the
next calendar year.
Some records that were converted from the Research Services System (RSS,
the system used to track proposals and awards before October 14, 2003),
have a null value for PERIOD_STATUS_FY.
Example: 2004 (for an proposal status history record whose
PERIOD_STATUS_DATE is 10/30/2003)
Values:
List of values not available |
PROP_NO
Indexed - no
Format - varchar2 (20)
May be null? no |
The 10-digit sequence number used internally by the PennERA system to
uniquely identify the proposal whose budget period status history is tracked
by this PENNERA_PERIOD_STAT_HIST record. Note that the value for PROP_NO
includes leading zeroes.
There are two different unique identifiers for a proposal: INSTITUTION_NO
and PROP_NO. INSTITUTION_NO is used by the University. PROP_NO is used
internally by the PennERA system. For a given record, INSTITUTION_NO
does 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.
There is one PENNERA_PERIOD_STAT_HIST record per proposal (INSTITUTION_NO
or PROP_NO), per PERIOD_NUMBER, per PER_STAT_SEQUENCE_NO
Example: ‘0000000217’
Values:
List of values not available
PennERA source: Proposal Tracking module; Summary screen; summary box
in the upper right corner of the screen; the prop_no for the Proposal
(the INSTITUTION_NO). PROP_NO itself is not displayed. |
