Penn Computing

University of Pennsylvania
Penn Computing << go backback
PENNERA_PERIOD_STAT_HIST Table   Tables and Data Elements   PennERA Proposals Home   Data Warehouse Home

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.

 

PENNERA_PERIOD_STAT_HIST Table   Tables and Data Elements  PennERA Proposals Home Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania