Trainee Activities and Program Administration IRDB Redesign
Recommendations and Proposals

Version 1.1.3

Revision History

  ------------ ------------- ------------------------------------ ------------------
  **Date**     **Version**   **Description of Change**            **Author**

  11/28/2001   1.0           Original Document                    Johnnie Pearson

  01/10/2002   1.1           Updated for comments by Carol Martin Johnnie Pearson

  01/22/2002   1.1.1         Redefined IRGCOMB column definition  Johnnie Pearson

  02/13/2002   1.1.2         Incorporated changes per comments by Leena Dilawari
                             Carol Martin                         

  02/22/2002   1.1.3         Incorporated PA comments from Julian Johnnie Pearson
                             Smith (NCI)                          
  ------------ ------------- ------------------------------------ ------------------

Table of Contents

# [1. Introduction 4](#introduction) {#introduction-4 .TOC-2}

## [1.1 Background 4](#background) {#background-4 .TOC-3}

## [1.2 Document Organization 4](#document-organization) {#document-organization-4 .TOC-3}

# [2. Suggested Improvements 4](#suggested-improvements) {#suggested-improvements-4 .TOC-2}

# [3. Proposed Views 6](#proposed-views) {#proposed-views-6 .TOC-2}

## [3.1 PV_TRAINEE_ADMIN_MV 6](#pv_trainee_admin_mv) {#pv_trainee_admin_mv-6 .TOC-3}

#### [3.1.1 Logical Design 6](#logical-design) {#logical-design-6 .TOC-4}

#### [3.1.2 Outstanding Questions 10](#outstanding-questions) {#outstanding-questions-10 .TOC-4}

## [3.2 PV_PROGRAM_ADMIN_MV 10](#pv_program_admin_mv) {#pv_program_admin_mv-10 .TOC-3}

#### [3.2.1 Logical Design 10](#logical-design-1) {#logical-design-10 .TOC-4}

#### [3.2.2 Outstanding Questions 19](#outstanding-questions-1) {#outstanding-questions-19 .TOC-4}

# Introduction

## Background

An initial focus group session was held on 11/29/2001 to determine the
information needs of the training and program business areas. Attendees
at that meeting included:

  ----------------------- ---------------- -------------------------------------------------------------
  **Name**                **Role or IC**   **email**

  Carol Martin            RAE Group        [martinc@exchange.nih.gov](mailto:MartinC@exchange.nih.gov)
                          Advocate         

  Johnnie Pearson         OER Analyst      <jpearson@z-techcorp.com>

  Leena Dilawari          Data Analyst     <ldilawari@hq.row.com>

  Penny Colbert           NICHD            [pc33a@nih.gov](mailto:pc33a@NIH.GOV)

  Anne Heath              NCI              [ah43v@nih.gov](mailto:ah43v@NIH.GOV)

  Cheryl Fee              NCRR             [cf89b@nih.gov](mailto:cf89b@NIH.GOV)

  Tracy Soto              OD/OER           <sotot@od.nih.gov>

  Amir Venegas            OD/OER           <venegasa@od.nih.gov>

  Mike Loewe              NICHD            [ml358k@nih.gov](mailto:ml358k@NIH.GOV)

  Lester Gorelic          NCI              [lg2h@nih.gov](mailto:lg2h@NIH.GOV)

  MaryAnn Williamson      NIDR             [mw45z@nih.gov](mailto:mw45z@NIH.GOV)

  Maria Burkowski         OD/OER           <bukowskm@od.nih.gov>

  Cathy Walker            NIAID            [cw24f@nih.gov](mailto:Cw24f@nih.gov)

  Karen Bashir            NIA              [kb94t@nih.gov](mailto:Kb94t@nih.gov)

  Jeff Schloss            NHGRI            [js173g@nih.gov](mailto:Js173g@nih.gov)
  ----------------------- ---------------- -------------------------------------------------------------

This document presents the redesign recommendations and proposals
gathered at that meeting. This document will be updated as needed to
incorporate comments from other groups and individuals.

## Document Organization

Excluding this section, the remainder of this document is organized as
follows:

> **Section 2 - Suggested Improvements**. This section presents
> suggested improvements to various aspects of IRDB data and the data
> model. Some of these proposals will be implemented in the next
> generation of the Mviews; others, because of their potential impact on
> the IMPACII user community, require additional analysis and project
> management approval.
>
> **Section 3 - Proposed Views.** This section presents the logical
> design of the TA and PA materialized views proposed by focus group
> members.

# Suggested Improvements

This section lists the suggested improvements to the IMPACII Training
Activities (TA) Module and additional data elements requested for
inclusion in the Program Administration Mview. This information was
gathered during a focus group session held on 11/29/2001 and through
subsequent conversations between the Group Advocate and members of the
user community.

Trainee Activities (TA) Module

  -----------------------------------------------------------------------
  **[Additional Data                **[Comment]{.mark}**
  Needed]{.mark}**                  
  --------------------------------- -------------------------------------
  Need to see more than one degree  Because of data quality problems,
  in the TA Module                  representing degree information in an
                                    accurate and meaningful manner is
                                    problematic. For example, profile
                                    records do not necessarily contain
                                    all of a person's degree information
                                    and there is no way to rank or order
                                    degrees from highest to lowest. Users
                                    should link to PERSON_DEGS to
                                    retrieve degree information.

  Need to know where the trainee is Not currently in IMPACII
  going/has gone after training     
  (industry, academia, research,    
  etc.)                             

  Need to know the discipline in    Will FOT Coding suffice for this
  which they are training           requirement?

  Need to know minority trainees    This information is available in
                                    PERSONS_T, but is restricted, i.e.,
                                    protected data.

  Need to know the support after    Not currently in IMPACII
  training support has stopped      
  (text field)                      

  Need a description of the         Michael Cox says this can be gotten
  trainee\'s project                from IMPACII. I'm working on it.

  Need the department, program, and MAJOR_COMPONENT_CODE is in
  major component of each trainee   PERSON_INVOLVEMENTS, which points to
                                    the trainee. The question is, does
                                    this code apply to the trainee or to
                                    the project?

  Need prior non-NRSA support       Not currently in IMPACII
  (yes/no and comment field)        

  Need prior NRSA support (yes/no   This data should be available in
  and the number of years)          PERSON_INVOLVEMENTS_T

  Need the ability to track the     Not currently in IMPACII
  sponsoring institution and        
  training institution (the         
  training institution may be       
  different from the institution    
  that has received the grant).     
  -----------------------------------------------------------------------

Program Administration

  -----------------------------------------------------------------------
  **[Additional Data                **[Comment]{.mark}**
  Needed]{.mark}**                  
  --------------------------------- -------------------------------------
  Program Official Division         Not captured in IMPACII, unless it is
                                    part of a ICs PCC code definition.

  Program Official Program          Not captured in IMPACII, unless it is
                                    part of a ICs PCC code definition.

  Program Official Branch           Not captured in IMPACII, unless it is
                                    part of a ICs PCC code definition.
  -----------------------------------------------------------------------

# Proposed Views

This section describes the logical design for the Training Activities
and Program Administration materialized views. The primary key for each
view is shown in **bold**. (Note: Some comments for "obvious" data
elements were intentionally omitted and will be added in the final
version.)

## PV_TRAINEE_ADMIN_MV

This view contains National Research Service Award (NRSA) institutional
training grant applications and appointments and fellowship awards. This
view is designed primarily for grants management and program
administration staff.

### Logical Design

+-------------------------+--------------------------------------------+
| **Data Element Name**   | **Comment**                                |
+=========================+============================================+
| **APPL_ID**             | Primary key column                         |
+-------------------------+--------------------------------------------+
| **SOURCE_CODE_DC**      | Indicates the source of the data contained |
|                         | on the row during loading which also       |
|                         | provides for the versioning of data.       |
|                         | Examples:                                  |
|                         |                                            |
|                         | Code Description                           |
|                         |                                            |
|                         | \-\-\-\-\-\--                              |
|                         | \-\-\-\-\-\-\-\-\-\-\-\-\-\-\--            |
|                         |                                            |
|                         | CURRENT Current record                     |
|                         |                                            |
|                         | HISTORY History record                     |
+-------------------------+--------------------------------------------+
| **APPOINTMENT_NUM**     | A number assigned to each trainee for an   |
|                         | appointment or reappointment, and is       |
|                         | unique to its supporting training grant    |
+-------------------------+--------------------------------------------+
| ACTIVATION_DATE         | Activation date that is recorded for Type  |
|                         | 1 and 2 fellowship awards                  |
+-------------------------+--------------------------------------------+
| ACTIVITY_CODE           | A code that identifies the subcategory of  |
|                         | an extramural activity. Examples:          |
|                         |                                            |
|                         | Code Description                           |
|                         |                                            |
|                         | \-\-\-- \-\-\-\-\-\-\-\-\-\-\--            |
|                         |                                            |
|                         | R01 Research Project                       |
|                         |                                            |
|                         | T01 Graduate Training Program              |
|                         |                                            |
|                         | N01 Research and Development Contracts     |
|                         |                                            |
|                         | Y01 NIH Inter-Agency Agreements            |
+-------------------------+--------------------------------------------+
| ADMIN_PHS_ORG_CODE      | IC designation of the "administering"      |
|                         | organization                               |
+-------------------------+--------------------------------------------+
| APPL_TYPE_CODE          | A code assigned to identify new or         |
|                         | non-competing applications, etc., or       |
|                         | agreement action.                          |
+-------------------------+--------------------------------------------+
| APPOINTMENT_STATUS_CODE | Indicates status of electronic or          |
|                         | paper-based appointment information.       |
|                         | Examples:                                  |
|                         |                                            |
|                         | AA                                         |
|                         |                                            |
|                         | TA                                         |
|                         |                                            |
|                         | EU                                         |
|                         |                                            |
|                         | HU                                         |
+-------------------------+--------------------------------------------+
| APP                     | The description for                        |
| OINTMENT_STATUS_DESCRIP | APPOINTMENT_STATUS_CODE. Examples:         |
|                         |                                            |
|                         | Code Description                           |
|                         |                                            |
|                         | \-\-\-- \-\-\-\-\-\-\-\-\-\--              |
|                         |                                            |
|                         | AA Accepted Appointment                    |
|                         |                                            |
|                         | TA Terminated Appointment                  |
|                         |                                            |
|                         | EU Electronic Update Amendment             |
|                         |                                            |
|                         | HU Hold Update Amendment (Paper-based      |
|                         | appointment)                               |
+-------------------------+--------------------------------------------+
| APPOINTMENT_TYPE_CODE   | A code defining whether the appointment is |
|                         | a new appointment or reassignment.         |
|                         | Examples:                                  |
|                         |                                            |
|                         | Code Description                           |
|                         |                                            |
|                         | \-\-\-- \-\-\-\-\-\-\-\-\-\--              |
|                         |                                            |
|                         | N New                                      |
|                         |                                            |
|                         | R Reassignment                             |
+-------------------------+--------------------------------------------+
| DSF_CODE                | Discipline, specialty, and field code of   |
|                         | proposed training.                         |
+-------------------------+--------------------------------------------+
| EXTERNAL_ORG_ID         | A foreign key used to link to              |
|                         | PV_INSTITUTION_MV.                         |
+-------------------------+--------------------------------------------+
| FIRST_NAME              | First name of the trainee                  |
+-------------------------+--------------------------------------------+
| FOT_CODE                | Field of training codes. Examples:         |
|                         |                                            |
|                         | 1000                                       |
|                         |                                            |
|                         | 4110                                       |
|                         |                                            |
|                         | 4120                                       |
|                         |                                            |
|                         | 4130                                       |
|                         |                                            |
|                         | 4210                                       |
|                         |                                            |
|                         | 4220                                       |
|                         |                                            |
|                         | 4230                                       |
+-------------------------+--------------------------------------------+
| FOT_CODE_DESCRIP        | Descriptions for field of training codes.  |
|                         | Examples:                                  |
|                         |                                            |
|                         | Code Description                           |
|                         |                                            |
|                         | \-\-\-- \-\-\-\-\-\-\-\-\-\-\-\-\--        |
|                         |                                            |
|                         | 1000 Non-Clinical or Lab-Based Research    |
|                         | Training                                   |
|                         |                                            |
|                         | 4110 Nuclear Chemistry                     |
|                         |                                            |
|                         | 4120 Radiation Physics                     |
|                         |                                            |
|                         | 4130 Radiobiology                          |
|                         |                                            |
|                         | 4210 Anthropology                          |
|                         |                                            |
|                         | 4220 Bioethics                             |
|                         |                                            |
|                         | 4230 Demography and Population Studies     |
+-------------------------+--------------------------------------------+
| FULL_GRANT_NUM_DC       | Full grant number. APPL_TYPE_CODE +        |
|                         | ACTIVITY_CODE + ADMIN_PHS_ORG +            |
|                         | SERIAL_NUM + \'-\' + SUPPORT_YEAR +        |
|                         | SUFFIX_CODE.                               |
+-------------------------+--------------------------------------------+
| FY                      | Fiscal year appropriation from which grant |
|                         | funds were obligated. For un-funded        |
|                         | records, fiscal year is normally computed  |
|                         | based on requested start date or council   |
|                         | date, whichever is greater. For            |
|                         | applications assigned to the August        |
|                         | council, however, fiscal year is computed  |
|                         | as identical to review year, regardless of |
|                         | requested start date.                      |
+-------------------------+--------------------------------------------+
| INVOL_VERSION_CODE      | Indicates the \"version\" of a             |
|                         | PERSON_INVOLVEMENT row. An example usage   |
|                         | would be to distinguish work-in-progress   |
|                         | data (\'W\') from current accepted data    |
|                         | (\'A\').                                   |
|                         |                                            |
|                         | Valid Values:                              |
|                         |                                            |
|                         | For \"project person\" role types          |
|                         | (\'PI\',\'TA\',\'SUP\', etc.):             |
|                         |                                            |
|                         | A Accepted permanent operational record    |
|                         |                                            |
|                         | W Work In Progress                         |
+-------------------------+--------------------------------------------+
| LAST_NAME               | Last name of the trainee                   |
+-------------------------+--------------------------------------------+
| MAJOR_ACTIVITY_CODE     | A code that identifies the major           |
|                         | extramural activity. Examples:             |
|                         |                                            |
|                         | Code Description                           |
|                         |                                            |
|                         | \-\-\--                                    |
|                         | \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--        |
|                         |                                            |
|                         | F Fellowship Programs                      |
|                         |                                            |
|                         | G Resource Programs                        |
|                         |                                            |
|                         | T Training Programs                        |
+-------------------------+--------------------------------------------+
| MAJOR_COMPONENT_CODE    | This code functions as a group code        |
|                         | identifying major components (e.g. Schools |
|                         | of Medicine) within an institution of      |
|                         | higher education.                          |
+-------------------------+--------------------------------------------+
| MI_NAME                 | Middle name of the trainee                 |
+-------------------------+--------------------------------------------+
| ORG_NAME                | Grantee institution name                   |
+-------------------------+--------------------------------------------+
| PAYBACK_STATUS_CODE     | Code indicating the payback status. Valid  |
|                         | values:                                    |
|                         |                                            |
|                         | Code Status                                |
|                         |                                            |
|                         | \-\-\-- \-\-\-\-\-\-\-\-\--                |
|                         |                                            |
|                         | 1 N/A \-- Payback is not applicable        |
|                         |                                            |
|                         | 2 Hold \-- Pending Administrative Action   |
|                         | (delinquent)                               |
|                         |                                            |
|                         | 4 Hold \-- While extension date is in      |
|                         | effect                                     |
|                         |                                            |
|                         | 5 Hold \-- While currently under NIH       |
|                         | support                                    |
|                         |                                            |
|                         | 6 Hold \-- While waiting for termination   |
|                         | notice                                     |
|                         |                                            |
|                         | 7 Open \-- Trainee owes payback            |
|                         |                                            |
|                         | 8 Closed \-- Payback has been completed.   |
|                         |                                            |
|                         | 9 Unknown                                  |
|                         |                                            |
|                         | 101 Hold \-- Pending administrative action |
|                         |                                            |
|                         | 102 Hold \-- Turned over to OFM for        |
|                         | voluntary financial payback                |
|                         |                                            |
|                         | 103 Hold \-- Turned over to OFM for        |
|                         | involuntary financial collection           |
|                         |                                            |
|                         | 104 Hold \-- Address needs update          |
|                         |                                            |
|                         | 106 Closed \-- Administrative reasons      |
|                         |                                            |
|                         | 107 Closed \-- OFM has sent notification   |
|                         | that financial obligation has been         |
|                         | completed                                  |
|                         |                                            |
|                         | 108 Closed \-- Death                       |
|                         |                                            |
|                         | 109 Closed \-- Financial Hardship          |
|                         |                                            |
|                         | 110 Closed \-- Disability                  |
|                         |                                            |
|                         | 111 Closed \-- OFM has archived the        |
|                         | records                                    |
|                         |                                            |
|                         | 112 Closed \-- OFM has been notified by IC |
|                         | that service has been completed            |
|                         |                                            |
|                         | 113 Closed \-- Closed in IMPACI. Item 023  |
|                         | equaled 2 or 3                             |
|                         |                                            |
|                         | 999 Hold \-- Initial Conversion Code       |
+-------------------------+--------------------------------------------+
| PERSON_ID               | Foreign key column to the person role      |
|                         | record in PERSONS                          |
+-------------------------+--------------------------------------------+
| PERSON_INV_ID           | Foreign key column to PERSON_INVOLVEMENTS  |
+-------------------------+--------------------------------------------+
| PERSON_TYPE_CODE        | Discriminator column that identifies which |
|                         | type of person information a given row     |
|                         | contains. Valid values:                    |
|                         |                                            |
|                         | Code Description                           |
|                         |                                            |
|                         | \-\-\-- \-\-\-\-\-\-\-\-\-\--              |
|                         |                                            |
|                         | PPRF Person Profile                        |
|                         |                                            |
|                         | ALS Alias                                  |
|                         |                                            |
|                         | CMPR Committee Person                      |
|                         |                                            |
|                         | CPRS Consultant Person                     |
|                         |                                            |
|                         | ERA From the Commons                       |
|                         |                                            |
|                         | FEDP Federal Employee Person               |
|                         |                                            |
|                         | INIT Initial version of a Committee        |
|                         | Management role                            |
|                         |                                            |
|                         | OTHP Other Person                          |
|                         |                                            |
|                         | PRJP Project Person                        |
|                         |                                            |
|                         | RSPP Reserve Pool Person                   |
+-------------------------+--------------------------------------------+
| PROFILE_PERSON_ID       | Foreign key column to the person profile   |
|                         | record in PERSONS                          |
+-------------------------+--------------------------------------------+
| PROG_CLASS_CODE         | A code used by the ICDs for internal       |
|                         | program classification purposes. This is   |
|                         | the most current program class code for    |
|                         | the application.                           |
+-------------------------+--------------------------------------------+
| PROJECT_PERIOD_END_DATE | The start date of the period of project.   |
+-------------------------+--------------------------------------------+
| PR                      | The end date of the period of project.     |
| OJECT_PERIOD_START_DATE |                                            |
+-------------------------+--------------------------------------------+
| PROJECT_SUMMARY_ID      | Foreign key to                             |
|                         | PROJECT_SUMMARIES_INVOLVEMENTS_T, which    |
|                         | has rows representing Termination Notices  |
|                         | summarizing a trainee\'s appointments to a |
|                         | specific grant.                            |
+-------------------------+--------------------------------------------+
| PROJECT_TITLE           | Title of the project.                      |
+-------------------------+--------------------------------------------+
| PRSN_INV_SUB_TYPE_CODE  | Valid values: PRJP, FEDP. Code that        |
|                         | indicates whether a person is a project    |
|                         | person or a federal person.                |
+-------------------------+--------------------------------------------+
| ROLE_TYPE_CODE          | A code indicating a person's involvement   |
|                         | with the project. Valid values:            |
|                         |                                            |
|                         | Code Description                           |
|                         |                                            |
|                         | \-\-\-- \-\-\-\-\-\-\-\-\-\--              |
|                         |                                            |
|                         | AA Administrative Assistant                |
|                         |                                            |
|                         | AO Authorizing Official                    |
|                         |                                            |
|                         | AWD Awardee                                |
|                         |                                            |
|                         | CPI Co Principal Investigator              |
|                         |                                            |
|                         | FEL Fellow                                 |
|                         |                                            |
|                         | GMO Grants Management Officer              |
|                         |                                            |
|                         | GS Grants Specialist                       |
|                         |                                            |
|                         | KP Key Personnel                           |
|                         |                                            |
|                         | LT Lab Technician                          |
|                         |                                            |
|                         | NKP Non key personnel                      |
|                         |                                            |
|                         | PD Program Director                        |
|                         |                                            |
|                         | PI Principal Investigator                  |
|                         |                                            |
|                         | PO Program Official                        |
|                         |                                            |
|                         | RA Research Assistant                      |
|                         |                                            |
|                         | SO Signing Official                        |
|                         |                                            |
|                         | SS Staff Scientist                         |
|                         |                                            |
|                         | SUP Supportee                              |
|                         |                                            |
|                         | TA Trainee Appointment                     |
+-------------------------+--------------------------------------------+
| SERIAL_NUM              | Identification number assigned in serial   |
|                         | number order within each administering     |
|                         | organization.                              |
+-------------------------+--------------------------------------------+
| ST                      | Stipend levels are grouped as either       |
| IPEND_DEGREE_LEVEL_CODE | pre-doc related, or post-doc related. This |
|                         | code indicates pre-doc or post-doc.        |
+-------------------------+--------------------------------------------+
| STIPEND_LEVEL_DC        | For POST-DOC trainees only. This column is |
|                         | derived from the STIPEND_LEVEL_DESCRIP and |
|                         | shows the stipend level minus the stipend  |
|                         | amount. Examples:                          |
|                         |                                            |
|                         | STIPEND_LEVEL_DESCRIP STIPEND_LEVEL_DC     |
|                         |                                            |
|                         | 0 - 21,000 0                               |
|                         |                                            |
|                         | 1 - 22,176 1                               |
|                         |                                            |
|                         | 2 - 26,160 2                               |
|                         |                                            |
|                         | 3 - 27,492 3                               |
|                         |                                            |
|                         | . . .                                      |
+-------------------------+--------------------------------------------+
| STIPEND_LEVEL_AMOUNT    | STIPEND_LEVEL_AMOUNT is amount for 1 year. |
|                         | Trainees are paid at different levels      |
|                         | depending on there education, i.e., a PhD  |
|                         | who has had a degree for 5 years is paid   |
|                         | more than a degree of only 1 year. If a    |
|                         | trainee were paid for the entire year      |
|                         | TOTAL_STIPEND_AMT would equal              |
|                         | STIPEND_LEVEL_AMOUNT.                      |
+-------------------------+--------------------------------------------+
| STIPEND_LEVEL_DESCRIP   | This is a formatted description designed   |
|                         | to display in the Training Activities (TA) |
|                         | pop-up pick list. As an example, the       |
|                         | following are the descriptions for each    |
|                         | row that correspond to FY 1998.            |
|                         |                                            |
|                         | F/S - 6,420                                |
|                         |                                            |
|                         | J/S - 8,988                                |
|                         |                                            |
|                         | PRE - 11,748                               |
|                         |                                            |
|                         | 0 - 21,000                                 |
|                         |                                            |
|                         | 1 - 22,176                                 |
|                         |                                            |
|                         | 2 - 26,160                                 |
|                         |                                            |
|                         | 3 - 27,492                                 |
|                         |                                            |
|                         | 4 - 28,824                                 |
|                         |                                            |
|                         | 5 - 30,144                                 |
|                         |                                            |
|                         | 6 - 31,476                                 |
|                         |                                            |
|                         | 7 - 33,012                                 |
|                         |                                            |
|                         | NO-DEGREE IMPAC-1                          |
|                         |                                            |
|                         | PRE-DOC IMPAC-1                            |
|                         |                                            |
|                         | POST-DOC IMPAC-1                           |
|                         |                                            |
|                         | UNKNOWN                                    |
+-------------------------+--------------------------------------------+
| SUFFIX_CODE             | Identifies Amendments (An), Supplements    |
|                         | (Sn), and Institutional Allowance for      |
|                         | Fellowships (Xn).                          |
+-------------------------+--------------------------------------------+
| SU                      | Indicates whether a waiver to extend NRSA  |
| PPORT_LIMIT_WAIVER_CODE | support is not applicable (N/A), is        |
|                         | applicable but is waiting for approval, or |
|                         | has been approved.                         |
+-------------------------+--------------------------------------------+
| SU                      | The date that the waiver to extend support |
| PPORT_LIMIT_WAIVER_DATE | was approved.                              |
+-------------------------+--------------------------------------------+
| SUPPORT_YEAR            | Identifies specific year of support. The   |
|                         | code \"00\" indicates a new agreement.     |
+-------------------------+--------------------------------------------+
| TA_END_DATE             | For training grants, the end date of the   |
|                         | trainee appointment. Source table is       |
|                         | PERSON_INVOLVEMENTS_T, where               |
|                         | ROLE_TYPE_CODE='TA'                        |
+-------------------------+--------------------------------------------+
| TA_START_DATE           | For training grants, the start date of the |
|                         | trainee appointment. Source table is       |
|                         | PERSON_INVOLVEMENTS_T, where               |
|                         | ROLE_TYPE_CODE='TA'                        |
+-------------------------+--------------------------------------------+
| TERMINATION_DATE        | The date that the Termination Notice was   |
|                         | accepted and applied to all outstanding    |
|                         | active appointments.                       |
+-------------------------+--------------------------------------------+
| TERMINATION_STATUS_CODE | This code helps control Work-In-Progress   |
|                         | (WIP) Termination Notices (TN). If a TN is |
|                         | not under a WIP condition, this code will  |
|                         | be NULL. If a paper TN has been received   |
|                         | and the user records it as WIP, this code  |
|                         | is set to Hold Termination (HT). If an     |
|                         | electronic TN is received, this code is    |
|                         | automatically set to Electronic            |
|                         | Termination (ET).                          |
|                         |                                            |
|                         | Notice that electronic receipts are always |
|                         | classified as WIP until accepted by NIH.   |
+-------------------------+--------------------------------------------+
| TOTAL_PHS_AMT           | Since there can be multiple trainees       |
|                         | appointed to a grant, each trainee         |
|                         | appointment results in a TOTAL_PHS_AMT.    |
|                         | TOTAL_PHS_AMT is sum of                    |
|                         |                                            |
|                         | TOTAL_STIPEND_AMT + TRAVEL_AMT +           |
|                         | TUITION_FEE_AMT                            |
+-------------------------+--------------------------------------------+
| TOTAL_STIPEND_AMT       | If the trainee appointment is less than 1  |
|                         | year, the stipend amount is shown in this  |
|                         | column. This amount does not include       |
|                         | tuition, travel, or other support amount.  |
+-------------------------+--------------------------------------------+
| TRAVEL_AMT              | The amount awarded to the appointee for    |
|                         | travel purposes                            |
+-------------------------+--------------------------------------------+
| TUITION_FEE_AMT         | The amount of tuition and fees awarded to  |
|                         | the appointee                              |
+-------------------------+--------------------------------------------+
| WIP_STATUS_CODE         | A code that indicates whether a Grant is   |
|                         | or is not in Work-In-Progress status. If   |
|                         | the Grant is in Work-In-Progress status,   |
|                         | the column will have a value of \'Y\'. If  |
|                         | the WIP is discarded or posted, GM sets    |
|                         | the status code to \'N\'. If the column    |
|                         | value is NULL, the grant has never had an  |
|                         | award started or released in IMPAC-II.     |
+-------------------------+--------------------------------------------+

### Outstanding Questions

None.

## PV_PROGRAM_ADMIN_MV

This view is design for Program Directors. It combines elements from
PV_GRANT_PI_MV, PV_BUDGET_MV, PV_INSTITUTION_MV, and
PV_ICD_ASSIGNMENTS_MV.

### Logical Design

+-----------------------------+----------------------------------------+
| Data Element                | Comments                               |
+=============================+========================================+
| **APPL_ID**                 | Primary key column                     |
+-----------------------------+----------------------------------------+
| **SOURCE_CODE_DC**          | Indicates the source of the data       |
|                             | contained on the row during loading    |
|                             | which also provides for the versioning |
|                             | of data. Examples:                     |
|                             |                                        |
|                             | Code Description                       |
|                             |                                        |
|                             | \-\-\-\-\-\--                          |
|                             | \-\-\-\-\-\-\-\-\-\-\-\-\-\-\--        |
|                             |                                        |
|                             | CURRENT Current record                 |
|                             |                                        |
|                             | HISTORY History record                 |
+-----------------------------+----------------------------------------+
| ABSTRACT_EXISTS_CODE        | A Y/N flag to indicate whether or not  |
|                             | the abstract exist.                    |
+-----------------------------+----------------------------------------+
| A                           | An Y/N flag to indicate fellowships    |
| CTIVATED_FELLOWSHIP_FLAG_DC | (type Fs), which have been awarded but |
|                             | not activated. A NULL value is stored  |
|                             | for non-fellowship applications.       |
+-----------------------------+----------------------------------------+
| ACTIVE_GRANT_FLAG           | An Y/N flag to indicated an active     |
|                             | grant, i.e., the date falls between    |
|                             | the budget start/end dates and the     |
|                             | award has been encumbered.             |
+-----------------------------+----------------------------------------+
| ACTIVITY_CODE               | A code that identifies the subcategory |
|                             | of an extramural activity. Examples:   |
|                             |                                        |
|                             | Code Description                       |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\-\-\--        |
|                             |                                        |
|                             | R01 Research Project                   |
|                             |                                        |
|                             | T01 Graduate Training Program          |
|                             |                                        |
|                             | N01 Research and Development Contracts |
|                             |                                        |
|                             | Y01 NIH Inter-Agency Agreements        |
+-----------------------------+----------------------------------------+
| ADMIN_PHS_ORG_CODE          | IC designation of the "administering"  |
|                             | organization                           |
+-----------------------------+----------------------------------------+
| AIDS_RELATED_CODE           | Indicates whether AIDS or AIDS related |
|                             | research is involved.                  |
+-----------------------------+----------------------------------------+
| ANIMAL_SUBJECTS_CODE        | For tracking review of applications    |
|                             | involving animal subjects.             |
|                             |                                        |
|                             | When application is recorded, one of   |
|                             | the following codes is assigned:       |
|                             |                                        |
|                             | Code Definition                        |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | 10\* No live vertebrate animals        |
|                             | involved for competing applications    |
|                             |                                        |
|                             | 20 Live vertebrate animals involved    |
|                             |                                        |
|                             | 98\*\* Animal Subject Coding not       |
|                             | applicable for certain activity codes  |
|                             |                                        |
|                             | 99 Animal code invalid - correction    |
|                             | required                               |
|                             |                                        |
|                             | At IRG review, code \'20\' is changed  |
|                             | by IRG to one of the following:        |
|                             |                                        |
|                             | Code Definition                        |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | 30 Animals involved - no IRG comments  |
|                             | or concerns noted                      |
|                             |                                        |
|                             | 32 Animals involved - IRG comments     |
|                             |                                        |
|                             | 44 Animals involved - IRG concerns     |
|                             |                                        |
|                             | 45 Animals involved - No assurance -   |
|                             | no IRG concerns or comment             |
|                             |                                        |
|                             | 47 Animals involved - No assurance,    |
|                             | IRG comments                           |
|                             |                                        |
|                             | 49 Animals involved - No assurance,    |
|                             | IRG concerns                           |
|                             |                                        |
|                             | Upon receipt of appropriate            |
|                             | documents/action from program          |
|                             | personnel, only Office for Human       |
|                             | Research Protections can recode, as    |
|                             | follows:                               |
|                             |                                        |
|                             | Code Definition                        |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | 54 Animals involved - previously coded |
|                             | 44 - now resolved                      |
|                             |                                        |
|                             | 55 Animals involved - previously coded |
|                             | 45 - now resolved                      |
|                             |                                        |
|                             | 57 Animals involved - previously coded |
|                             | 47 - now resolved                      |
|                             |                                        |
|                             | 59 Animals involved - previously coded |
|                             | 49 - now resolved                      |
|                             |                                        |
|                             | Codes assigned by Office for Human     |
|                             | Research Protections                   |
|                             |                                        |
|                             | 41 Animals involved - special          |
|                             | administrative concerns                |
|                             |                                        |
|                             | 51 Animals involved - previously coded |
|                             | 41 - now resolved                      |
|                             |                                        |
|                             | \* During review, the IRG must verify  |
|                             | the accuracy of the PI\'s designation. |
|                             |                                        |
|                             | \* According to OHRP certain activity  |
|                             | codes will never involve animal        |
|                             | subjects.                              |
+-----------------------------+----------------------------------------+
| APPL_STATUS_CODE            | Application status code. Legal values: |
|                             |                                        |
|                             | Code Desctiption                       |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\-\--          |
|                             |                                        |
|                             | 01 Administratively Withdrawn by IC    |
|                             |                                        |
|                             | 02 Withdrawn                           |
|                             |                                        |
|                             | 03 Award terminated                    |
|                             |                                        |
|                             | 04 Application withdrawn for amendment |
|                             |                                        |
|                             | 05 Awarded. Non-fellowships only       |
|                             |                                        |
|                             | 06 Awarded. Fellowships only           |
|                             |                                        |
|                             | 07 Pending Award. Non-fellowships      |
|                             |                                        |
|                             | 08 Council - not recommended for       |
|                             | consideration                          |
|                             |                                        |
|                             | 09 Council deferred                    |
|                             |                                        |
|                             | 10 No Council Action                   |
|                             |                                        |
|                             | 11 Record Incomplete                   |
|                             |                                        |
|                             | 12 Pending Council Review              |
|                             |                                        |
|                             | 13 IRG NRFC - Not considered by        |
|                             | Council                                |
|                             |                                        |
|                             | 14 IRG Deferred                        |
|                             |                                        |
|                             | 15 No IRG Recommendation               |
|                             |                                        |
|                             | 16 Pending Award. Fellowships only     |
|                             |                                        |
|                             | 17 Pending IRG Review                  |
|                             |                                        |
|                             | 18 Pending Award (non-competing)       |
|                             |                                        |
|                             | 19 Award prepared, not funded          |
|                             |                                        |
|                             | 20 Fellowship Award Cancelled          |
|                             |                                        |
|                             | 21 Ineligible organization -           |
|                             | application return                     |
|                             |                                        |
|                             | 22 Returned due to ineligible          |
|                             | organization (R43 only)                |
|                             |                                        |
|                             | 23 Returned due to ineligible appl.    |
|                             | and org. (R43 only)                    |
|                             |                                        |
|                             | 24 Unscored - Application judged       |
|                             | competitive                            |
|                             |                                        |
|                             | 25 Unscored - Application judged       |
|                             | non-competitive                        |
|                             |                                        |
|                             | 26 Award not extended by council       |
|                             |                                        |
|                             | 28 Bottom Tier - Not considered by     |
|                             | Council                                |
|                             |                                        |
|                             | 29 Not considered-Appl. designated by  |
|                             | IC for excl. from review               |
|                             |                                        |
|                             | 30 Withdrawn by IC - Previous Record   |
|                             | Encumbered                             |
|                             |                                        |
|                             | 31 Administratively Withdrawn by CSR   |
|                             |                                        |
|                             | 32 IRG NRFC - Pending Dual Council     |
|                             |                                        |
|                             | 33 IRG NRFC - Pending Council Review   |
|                             |                                        |
|                             | 34 Administratively withdrawn by IC    |
|                             | prior to review or council             |
|                             |                                        |
|                             | 35 To be Paid                          |
|                             |                                        |
|                             | 51 Inter/Intra-Agency Agreement Funded |
|                             |                                        |
|                             | 52 Inter/Intra-Agency Agreement        |
|                             | Expired                                |
|                             |                                        |
|                             | 70 Application has been entered into   |
|                             | computer                               |
|                             |                                        |
|                             | 96 Ineligible                          |
|                             |                                        |
|                             | 97 Not Awarded                         |
|                             |                                        |
|                             | 98 Pending                             |
|                             |                                        |
|                             | 99 Not Applicable                      |
+-----------------------------+----------------------------------------+
| APPL_STATUS_DESCRIP         | The description of the                 |
|                             | APPL_STATUS_CODE                       |
+-----------------------------+----------------------------------------+
| APPL_WORKFLOW_STATE         | Legal values *requested* for the PA    |
|                             | business area are:                     |
|                             |                                        |
|                             | Pre-Submission                         |
|                             |                                        |
|                             | Pending SRG                            |
|                             |                                        |
|                             | Pending Council                        |
|                             |                                        |
|                             | Post-Council                           |
|                             |                                        |
|                             | Post Award                             |
|                             |                                        |
|                             | Note: These values were recommended by |
|                             | the Program Portal JAD and are not yet |
|                             | an official part of the IMPACII        |
|                             | lexicon. JAD participants have         |
|                             | requested that applications be grouped |
|                             | into these categories.                 |
+-----------------------------+----------------------------------------+
| APPL_TYPE_CODE              | A code assigned to identify new or     |
|                             | non-competing applications, etc., or   |
|                             | agreement action.                      |
+-----------------------------+----------------------------------------+
| APPLIED_RESEARCH_PCT        | Percent assigned for applied research. |
+-----------------------------+----------------------------------------+
| AWARDED_DIRECT_COST_AMT     | The amount of a grant\'s direct cost   |
|                             | allocated to a specific ICD and CAN.   |
+-----------------------------+----------------------------------------+
| AWARDED_INDIRECT_COST_AMT   | The amount of a grant\'s indirect cost |
|                             | allocated to a specific ICD and CAN.   |
+-----------------------------+----------------------------------------+
| AWD_NOTICE_ISSUED_DATE      | The Notice of Grant Award issue date.  |
+-----------------------------+----------------------------------------+
| BASIC_RESEARCH_PCT          | Percent assigned for basic research.   |
+-----------------------------+----------------------------------------+
| BUDGET_END_DATE             | End date of the current (budget)       |
|                             | support year.                          |
+-----------------------------+----------------------------------------+
| BUDGET_START_DATE           | Start date of the current (budget)     |
|                             | support year.                          |
+-----------------------------+----------------------------------------+
| CHILD_CLINICAL_STUDY_CODE   | To track NIH policy for including      |
|                             | minority in study population.          |
+-----------------------------+----------------------------------------+
| CNL_REC_CURRENT_FY_AMT      | Council recommendation for current     |
|                             | year                                   |
+-----------------------------+----------------------------------------+
| CNL_REC_FUTURE_YEAR_1_AMT   | Council recommendation for 1^st^       |
|                             | future year                            |
+-----------------------------+----------------------------------------+
| CNL_REC_FUTURE_YEAR_2_AMT   | Council recommendation for 2^nd^       |
|                             | future year                            |
+-----------------------------+----------------------------------------+
| CNL_REC_FUTURE_YEAR_3_AMT   | Council recommendation for 3^rd^       |
|                             | future year                            |
+-----------------------------+----------------------------------------+
| CNL_REC_FUTURE_YEAR_4_AMT   | Council recommendation for 4^th^       |
|                             | future year                            |
+-----------------------------+----------------------------------------+
| CNL_REC_FUTURE_YEAR_5_AMT   | Council recommendation for 5^th^       |
|                             | future year                            |
+-----------------------------+----------------------------------------+
| CNL_REC_FUTURE_YEAR_6_AMT   | Council recommendation for 6^th^       |
|                             | future year                            |
+-----------------------------+----------------------------------------+
| COFUNDING_INDICATOR_CODE    | If a jointly funded project, this      |
|                             | column will have a value of \"C." If   |
|                             | it is a competing application assigned |
|                             | to two advisory councils for review,   |
|                             | then this column will have a value of  |
|                             | \"S."                                  |
+-----------------------------+----------------------------------------+
| COUNCIL_MEETING_DATE        | This is the primary IC\'s council      |
|                             | meeting date. See                      |
|                             | PV_ICD_ASSIGNMENTS_MV for any the dual |
|                             | IC(s)                                  |
+-----------------------------+----------------------------------------+
| DEVELOPMENTAL_RESEARCH_PCT  | Percent assigned for development       |
|                             | research.                              |
+-----------------------------+----------------------------------------+
| DSF_CODE                    | Discipline, specialty, and field code  |
|                             | of proposed training                   |
+-----------------------------+----------------------------------------+
| EXPEDITED_REVIEW_CODE       | Indicates whether application is to    |
|                             | receive or has received expedited      |
|                             | review.                                |
|                             |                                        |
|                             | Code Definition                        |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | Y Application will or has received     |
|                             | expedited review                       |
|                             |                                        |
|                             | N Expedited review not involved        |
|                             |                                        |
|                             | Blank Status not determined            |
+-----------------------------+----------------------------------------+
| FE                          | Fellowship activation notice recorded  |
| LL_ACT_NOTICE_RECORDED_DATE | date?                                  |
+-----------------------------+----------------------------------------+
| FOREIGN_APPL_CODE           | Foreign designation determined by the  |
|                             | country code of the applicant          |
|                             | institution. Item is set to 1 if the   |
|                             | COUNTRY_SEQ_NUM of the corresponding   |
|                             | EXTERNAL_ORG_ADDRESSES_T entry for     |
|                             | ADDR_TYPE_CODE \'MLG\' is NOT NULL and |
|                             | not equal to 231 (United States).      |
+-----------------------------+----------------------------------------+
| FORMER_NUM                  | Former Grant Number                    |
+-----------------------------+----------------------------------------+
| FSR_ACCEPTED_CODE           | Determines whether an acceptable       |
|                             | Financial Status Report (FSR) was      |
|                             | accepted by OFM. A value of \'Y\'      |
|                             | indicates that an acceptable FSR has   |
|                             | been received.                         |
+-----------------------------+----------------------------------------+
| FULL_GRANT_NUM_DC           | Full grant number. APPL_TYPE_CODE +    |
|                             | ACTIVITY_CODE + ADMIN_PHS_ORG +        |
|                             | SERIAL_NUM + \'-\' + SUPPORT_YEAR +    |
|                             | SUFFIX_CODE                            |
+-----------------------------+----------------------------------------+
| FUTURE_YEAR_1_AMT           | Committed amount for 1^st^ future year |
+-----------------------------+----------------------------------------+
| FUTURE_YEAR_2_AMT           | Committed amount for 2^nd^ future year |
+-----------------------------+----------------------------------------+
| FUTURE_YEAR_3_AMT           | Committed amount for 3^rd^ future year |
+-----------------------------+----------------------------------------+
| FUTURE_YEAR_4_AMT           | Committed amount for 4^th^ future year |
+-----------------------------+----------------------------------------+
| FUTURE_YEAR_5_AMT           | Committed amount for 5^th^ future year |
+-----------------------------+----------------------------------------+
| FUTURE_YEAR_6_AMT           | Committed amount for 6^th^ future year |
+-----------------------------+----------------------------------------+
| FY                          | Fiscal year appropriation from which   |
|                             | grant funds were obligated. For        |
|                             | un-funded records, fiscal year is      |
|                             | normally computed based on requested   |
|                             | start date or council date, whichever  |
|                             | is greater. For applications assigned  |
|                             | to the August council, however, fiscal |
|                             | year is computed as identical to       |
|                             | review year, regardless of requested   |
|                             | start date.                            |
+-----------------------------+----------------------------------------+
| GENDER_CLINICAL_STUDY_CODE  | To track NIH policy for including      |
|                             | women in study population.             |
|                             |                                        |
|                             | First byte codes are as follows:       |
|                             |                                        |
|                             | CODE DEFINITION                        |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | 1 Includes both genders                |
|                             |                                        |
|                             | 2 Includes only women                  |
|                             |                                        |
|                             | 3 Includes only men                    |
|                             |                                        |
|                             | 4 Gender representation unknown        |
|                             |                                        |
|                             | Second byte codes are as follows:      |
|                             |                                        |
|                             | CODE DEFINITION                        |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | A Scientifically acceptable            |
|                             |                                        |
|                             | U Scientifically unacceptable          |
|                             |                                        |
|                             | R Resolved                             |
|                             |                                        |
|                             | When the above codes are shown on      |
|                             | reports or displayed on a screen, they |
|                             | will be prefixed as appropriate with a |
|                             | G for Gender.                          |
|                             |                                        |
|                             | For example, an application coded 1A   |
|                             | will appear \"G1A\" which includes     |
|                             | both genders, scientifically           |
|                             | acceptable.                            |
+-----------------------------+----------------------------------------+
| GMO_PERSON_ID               | Person ID of the Grants Management     |
|                             | Officer                                |
+-----------------------------+----------------------------------------+
| GMO_FIRST_NAME              | First name of the Grants Management    |
|                             | Officer                                |
+-----------------------------+----------------------------------------+
| GMO_LAST_NAME               | Last name of the Grants Management     |
|                             | Officer                                |
+-----------------------------+----------------------------------------+
| GMO_MIDDLE_NAME             | Middle name of the Grants Management   |
|                             | Officer                                |
+-----------------------------+----------------------------------------+
| GMO_EMAIL_ADDR              | Email address for the Grants           |
|                             | Management Officer                     |
+-----------------------------+----------------------------------------+
| GMO_WRK_PHONE_NUM           | Work phone number of the Grants        |
|                             | Management Officer                     |
+-----------------------------+----------------------------------------+
| GS_PERSON_ID                | Person ID of the Grant Specialist      |
+-----------------------------+----------------------------------------+
| GS_FIRST_NAME               | First name of the Grant Specialist     |
+-----------------------------+----------------------------------------+
| GS_LAST_NAME                | Last name of the Grant Specialist      |
+-----------------------------+----------------------------------------+
| GS_MIDDLE_NAME              | Middle name of the Grant Specialist    |
+-----------------------------+----------------------------------------+
| GS_EMAIL_ADDR               | Email address for the Grant Specialist |
+-----------------------------+----------------------------------------+
| GS_WRK_PHONE_NUM            | Work phone number of the Grant         |
|                             | Specialist                             |
+-----------------------------+----------------------------------------+
| HUMAN_SUBJECT_CODE          | Provides for tracking of review of     |
|                             | applications involving human subjects. |
|                             | At time application is recorded, one   |
|                             | of the following codes is assigned:    |
|                             |                                        |
|                             | CODE DEFINITION                        |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | \*10 No human subjects involved for    |
|                             | competing applications                 |
|                             |                                        |
|                             | E1 Human subjects involved - Exemption |
|                             | #1 designated                          |
|                             |                                        |
|                             | E2 Human subject s involved -          |
|                             | Exemption #2 designated                |
|                             |                                        |
|                             | E3 Human subjects involved - Exemption |
|                             | #3 designated                          |
|                             |                                        |
|                             | E4 Human subjects involved - Exemption |
|                             | #4 designated                          |
|                             |                                        |
|                             | E5 Human subjects involved - Exemption |
|                             | #5 designated                          |
|                             |                                        |
|                             | E6 Human subjects involved - Exemption |
|                             | #6 designated                          |
|                             |                                        |
|                             | E7 Human subjects involved - Multiple  |
|                             | exemptions designated                  |
|                             |                                        |
|                             | E8 Human subjects involved - HS        |
|                             | regulations waived                     |
|                             |                                        |
|                             | 20 Human subjects involved - No        |
|                             | exemption designated                   |
|                             |                                        |
|                             | \*\*98 Human subject coding not        |
|                             | applicable to certain activity codes   |
|                             |                                        |
|                             | 99 Human subject code invalid -        |
|                             | Correction required                    |
|                             |                                        |
|                             | At time of IRG review, code \"20\" is  |
|                             | changed by the IRG to one of the       |
|                             | following:                             |
|                             |                                        |
|                             | CODE DEFINITION                        |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | 30 Human subjects involved -           |
|                             | Certified, no IRG concerns/comments    |
|                             |                                        |
|                             | 32 Human subjects involved - IRG       |
|                             | comments                               |
|                             |                                        |
|                             | 44 Human subjects involved -           |
|                             | Certified, IRG concerns/comments       |
|                             |                                        |
|                             | 45 Human subjects involved - No        |
|                             | assurance, no IRG concerns/comments    |
|                             |                                        |
|                             | 47 Human subjects involved - No        |
|                             | assurance, IRG comments                |
|                             |                                        |
|                             | 49 Human subjects involved - No        |
|                             | assurance, IRG concerns                |
|                             |                                        |
|                             | After receipt of appropriate           |
|                             | documents/action from program          |
|                             | personnel, only the Office for         |
|                             | Protection from Research Risks can     |
|                             | recode codes in the 40\'s, as follows: |
|                             |                                        |
|                             | CODE DEFINITION                        |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | 54 Previously coded 44 - concerns      |
|                             | resolved                               |
|                             |                                        |
|                             | 55 Previously coded 45 - assurance &   |
|                             | certification approved                 |
|                             |                                        |
|                             | 57 Previously coded 47 - assurance &   |
|                             | certification approved                 |
|                             |                                        |
|                             | 59 Previously coded 49 - assurance &   |
|                             | certification approved                 |
+-----------------------------+----------------------------------------+
| ICD_DISP_CODE               | Indicates the ICD disposition of       |
|                             | applications to be considered for      |
|                             | funding. Codes are defined as follows: |
|                             |                                        |
|                             | CODE DEFINITION                        |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | 1 Notice of Award prepared through     |
|                             | system.                                |
|                             |                                        |
|                             | 2 Application has been                 |
|                             | administratively inactivated. When     |
|                             | this item is set, the date of          |
|                             | transaction is also recorded in Date   |
|                             | Withdrawn or Administratively          |
|                             |                                        |
|                             | Inactivated item.                      |
|                             |                                        |
|                             | 5 Application awarded under another    |
|                             | grant number. This code is supplied by |
|                             | the ICs.                               |
|                             |                                        |
|                             | 8 Notice of Grant Award prepared       |
|                             | manually.                              |
|                             |                                        |
|                             | 9 Subproject marked awarded            |
+-----------------------------+----------------------------------------+
| INITIATIVE_TYPE_CODE        | A code defining the initiative types:  |
|                             |                                        |
|                             | Code Description                       |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\-\--          |
|                             |                                        |
|                             | 1 Minority                             |
|                             |                                        |
|                             | 2 Disability                           |
|                             |                                        |
|                             | 3 Reentry                              |
|                             |                                        |
|                             | 4 Other                                |
+-----------------------------+----------------------------------------+
| IRG_CITY_STATE              | CITY_NAME\|\| \|\|STATE_ABBR           |
+-----------------------------+----------------------------------------+
| IRG_CODE                    | Identifies the peer review assigned by |
|                             | the Referral and Review Branch, CSR.   |
+-----------------------------+----------------------------------------+
| IRG_CODE\|\|\'              | A derived field composed of the data   |
| \'\|                        | elements indicated in the adjacent     |
| \|SRA_DESIGNATOR_CODE\|\|\' | column. Name the column: IRGCOMB       |
| \'\|\|SRA_FLEX_CODE\|\|\'   |                                        |
| \'\|\| IRG_FLEX_CODE\|\|\'  |                                        |
| \'\|\|GROUP_CODE            |                                        |
+-----------------------------+----------------------------------------+
| IRG_FLEX_CODE               | A code indicating groupings of         |
|                             | applications within designated IRGs    |
|                             | for purpose of producing separate work |
|                             | documents worksheets, resumes, summary |
|                             | statements, and summary statistics.    |
+-----------------------------+----------------------------------------+
| IRG_MEETING_END_DATE        | The end date of the meeting            |
+-----------------------------+----------------------------------------+
| IR                          | The end meridian code of the meeting   |
| G_MEETING_END_MERIDIAN_CODE |                                        |
+-----------------------------+----------------------------------------+
| IRG_MEETING_END_TIME        | The end time of the meeting            |
+-----------------------------+----------------------------------------+
| IRG_MEETING_GROUP_CODE      | A code to permit tracking of special   |
|                             | reviews.                               |
+-----------------------------+----------------------------------------+
| IRG_MEETING_GROUP_EXT_CODE  | Indicates the reason the application   |
|                             | is being reviewed by a SEP. CSR coding |
|                             | for this item:                         |
|                             |                                        |
|                             | Code Description                       |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\-\--          |
|                             |                                        |
|                             | A Area                                 |
|                             |                                        |
|                             | B SBIR                                 |
|                             |                                        |
|                             | F Overflow                             |
|                             |                                        |
|                             | M Member Conflict                      |
|                             |                                        |
|                             | S Special                              |
|                             |                                        |
|                             | Q Lack of Quorum                       |
|                             |                                        |
|                             | V AIDS, Virology                       |
|                             |                                        |
|                             | C Conflict other than member           |
|                             |                                        |
|                             | P Any P activity code                  |
|                             |                                        |
|                             | Coding of this item for the pilot test |
|                             | SEPs began with applications assigned  |
|                             | to the October 1992 Council review     |
|                             | cycle.                                 |
+-----------------------------+----------------------------------------+
| IRG_MEETING_LINE_1_ADDR     | The first line of the meeting address. |
+-----------------------------+----------------------------------------+
| IRG_MEETING_LINE_2_ADDR     | The second line of the meeting         |
|                             | address.                               |
+-----------------------------+----------------------------------------+
| IRG_MEETING_LINE_3_ADDR     | The third line of the meeting address. |
+-----------------------------+----------------------------------------+
| IRG_MEETING_LINE_4_ADDR     | The fourth line of the meeting         |
|                             | address.                               |
+-----------------------------+----------------------------------------+
| IRG_MEETING_LINE_5_ADDR     | The fifth line of the meeting address. |
+-----------------------------+----------------------------------------+
| IRG_MEETING_START_DATE      | The start date of the meeting          |
+-----------------------------+----------------------------------------+
| IRG_                        | The start meridian code of the meeting |
| MEETING_START_MERIDIAN_CODE |                                        |
+-----------------------------+----------------------------------------+
| IRG_MEETING_START_TIME      | The start time of the meeting          |
+-----------------------------+----------------------------------------+
| IRG_PERCENT_REF_CODE        | Reference code indicating how the      |
|                             | percentile was calculated              |
+-----------------------------+----------------------------------------+
| IRG_PERCENTILE_NUM          | Represents relative position or rank   |
|                             | of priority score among all            |
|                             | applications reviewed either by        |
|                             | Initial Review Group or by all         |
|                             | qualified CSR study sections combined. |
|                             | Percentiles are used to identify and   |
|                             | sort applications; i.e., applications  |
|                             | with priority scores ranking in the    |
|                             | highest (best) 20 percent receive      |
|                             | percentile numbers equal to or less    |
|                             | than 0200 (one decimal understood but  |
|                             | not recorded).                         |
+-----------------------------+----------------------------------------+
| IRG_RECOMMENDATION_CODE     | Recommendation of the initial review   |
|                             | group for competing applications       |
|                             |                                        |
|                             | Code Description                       |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\-\--          |
|                             |                                        |
|                             | 1 Scored (SC) or Positive              |
|                             | recommendation by ICD staff in the     |
|                             | absence of IRG review                  |
|                             |                                        |
|                             | 2 Not recommended for further          |
|                             | consideration (NRFC)                   |
|                             |                                        |
|                             | 3 Deferral                             |
|                             |                                        |
|                             | 4 No Recommendation (pending final     |
|                             | action)                                |
|                             |                                        |
|                             | 5 Competitive (unscored) - Warrants    |
|                             | further review                         |
|                             |                                        |
|                             | 6 Non-Competitive (unscored) - No      |
|                             | likelihood of being considered for     |
|                             | funding                                |
+-----------------------------+----------------------------------------+
| IRG_ROUND_CODE              | Current value of IRG Round \"date\";   |
|                             | format is YYYYMM.                      |
+-----------------------------+----------------------------------------+
| M                           | To track NIH policy for including      |
| INORITY_CLINICAL_STUDY_CODE | minority in study population.          |
|                             |                                        |
|                             | First byte codes are as follows:       |
|                             |                                        |
|                             | Code Description                       |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | 1 Includes minorities and              |
|                             | non-minorities                         |
|                             |                                        |
|                             | 2 Includes only minorities             |
|                             |                                        |
|                             | 3 Includes only non-minorities         |
|                             |                                        |
|                             | 4 Minority representation unknown      |
|                             |                                        |
|                             | Second byte codes are as follows:      |
|                             |                                        |
|                             | Code Description                       |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | A Scientifically acceptable            |
|                             |                                        |
|                             | U Scientifically unacceptable          |
|                             |                                        |
|                             | R Resolved                             |
|                             |                                        |
|                             | When the above codes are shown on      |
|                             | reports or displayed on a screen, they |
|                             | will be prefixed as appropriate with   |
|                             | an M for Minority. For example, an     |
|                             | application coded 1A will appear       |
|                             | \"M1A\" which includes minorities and  |
|                             | non-minorities, scientifically         |
|                             | acceptable.                            |
+-----------------------------+----------------------------------------+
| NEW_INVESTIGATOR_CODE       | Indicates whether the principal        |
|                             | investigator for the grant is new.     |
|                             |                                        |
|                             | Valid values are 1, 2, and NULL. A 1   |
|                             | indicates that the investigator        |
|                             | designated on the face page of the     |
|                             | application that he/she is a new       |
|                             | investigator. A 2 indicates that the   |
|                             | IC or IRG made the designation. A NULL |
|                             | indicates that the PI is not a new     |
|                             | investigator.                          |
+-----------------------------+----------------------------------------+
| NGA_EXISTS_CODE_DC          | A flag indicating whether the NGA      |
|                             | exists.                                |
+-----------------------------+----------------------------------------+
| ORG_NAME                    | Name of the grantee institution        |
+-----------------------------+----------------------------------------+
| ORG_BUSINESS_OFFICIAL       | The name of the institution's business |
|                             | official's name.                       |
+-----------------------------+----------------------------------------+
| ORG_                        | Business official's work phone number. |
| BUSINESS_OFFICIAL_PHONE_NUM |                                        |
+-----------------------------+----------------------------------------+
| OUT_YEARS_NUM_DC            | The number of committed years          |
|                             | remaining on the grant.                |
+-----------------------------+----------------------------------------+
| PHASE_3_CLINICAL_TRIAL_CODE | NIH-Defined Phase III Clinical Trial   |
|                             | indicator code.                        |
|                             |                                        |
|                             | Code Definition                        |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | Y NIH-defined Phase III Clinical Trial |
|                             |                                        |
|                             | N Clinical Research - not an           |
|                             | NIH-defined Phase III Clinical Trial   |
|                             |                                        |
|                             | X Clinical Trial, Gender and Minority  |
|                             | Codes not assigned                     |
+-----------------------------+----------------------------------------+
| PI_LINE1_ADDR               | PI Line 1 Address                      |
+-----------------------------+----------------------------------------+
| PI_LINE2_ADDR               | PI Line 2 Address                      |
+-----------------------------+----------------------------------------+
| PI_LINE3_ADDR               | PI Line 3 Address                      |
+-----------------------------+----------------------------------------+
| PI_LINE4_ADDR               | PI Line 4 Address                      |
+-----------------------------+----------------------------------------+
| PI_LINE5_ADDR               | PI Line 5 Address                      |
+-----------------------------+----------------------------------------+
| PI_PROFILE_PERSON_ID        | Profile-level person ID of the         |
|                             | Principal Investigator                 |
+-----------------------------+----------------------------------------+
| PI_ROLE_PERSON_ID           | Role-level person ID of the Principal  |
|                             | Investigator                           |
+-----------------------------+----------------------------------------+
| PI_NAME_PREFIX              | Name prefix of the Principal           |
|                             | Investigator                           |
+-----------------------------+----------------------------------------+
| PI_FIRST_NAME               | First name of the Principal            |
|                             | Investigator                           |
+-----------------------------+----------------------------------------+
| PI_LAST_NAME                | Last name of the Principal             |
|                             | Investigator                           |
+-----------------------------+----------------------------------------+
| PI_MIDDLE_NAME              | Middle name of the Principal           |
|                             | Investigator                           |
+-----------------------------+----------------------------------------+
| PI_NAME_SUFFIX              | Name suffix of the Principal           |
|                             | Investigator                           |
+-----------------------------+----------------------------------------+
| PI_EMAIL_ADDR               | Email address for the Principal        |
|                             | Investigator                           |
+-----------------------------+----------------------------------------+
| PI_FAX_NUM                  | Fax number for the Principal           |
|                             | Investigator                           |
+-----------------------------+----------------------------------------+
| PI_OFC_PHONE_NUM            | Work phone number for the Principal    |
|                             | Investigator                           |
+-----------------------------+----------------------------------------+
| PI_PHONE_EXTENSION_NUM      | Work phone extension number for the    |
|                             | Principal Investigator                 |
+-----------------------------+----------------------------------------+
| PO_PERSON_ID                | Person ID of the primary ICs Program   |
|                             | Official                               |
+-----------------------------+----------------------------------------+
| PO_FIRST_NAME               | First name of the primary ICs Program  |
|                             | Official. See PV_ICD_ASSIGNMENTS_MV    |
|                             | for name of dual ICs Program           |
|                             | Officials.                             |
+-----------------------------+----------------------------------------+
| PO_LAST_NAME                | Last name of the primary ICs Program   |
|                             | Official. See PV_ICD_ASSIGNMENTS_MV    |
|                             | for name of dual ICs Program           |
|                             | Officials.                             |
+-----------------------------+----------------------------------------+
| PO_MIDDLE_NAME              | Middle name of the primary ICs Program |
|                             | Official. See PV_ICD_ASSIGNMENTS_MV    |
|                             | for name of dual ICs Program           |
|                             | Officials.                             |
+-----------------------------+----------------------------------------+
| PO_EMAIL_ADDR               | Email address for the primary ICs      |
|                             | Program Official. See                  |
|                             | PV_ICD_ASSIGNMENTS_MV for email        |
|                             | address of dual ICs Program Officials. |
+-----------------------------+----------------------------------------+
| PO_OFC_PHONE_NUM            | Work phone number for the primary ICs  |
|                             | Program Official. See                  |
|                             | PV_ICD_ASSIGNMENTS_MV for office phone |
|                             | number of dual ICs Program Officials.  |
+-----------------------------+----------------------------------------+
| PRIORITY_CODE               | Priority notation of each application  |
|                             | council recommends to be considered    |
|                             | for funding as related to the IRG      |
|                             | assigned score:                        |
|                             |                                        |
|                             | CON - Council has concurred with IRG   |
|                             | recommendation.                        |
|                             |                                        |
|                             | HPR - Council recommended a High       |
|                             | Program Priority, application will be  |
|                             | raised in order of consideration for   |
|                             | funding.                               |
|                             |                                        |
|                             | LPR - Council recommended a Low        |
|                             | Program Priority, application will be  |
|                             | lowered in order of consideration for  |
|                             | funding.                               |
|                             |                                        |
|                             | OTH - Special circumstances            |
+-----------------------------+----------------------------------------+
| PRIORITY_SCORE_NUM          | \(1\) Competing applications -         |
|                             | priority score assigned by an IRG on   |
|                             | scored applications. The score will    |
|                             | range from 100 (most favorable) to 500 |
|                             | (least favorable). Zero (0) is coded   |
|                             | for scored applications where no       |
|                             | priority is assigned.                  |
|                             |                                        |
|                             | \(2\) Non-competing applications       |
|                             | (types 5 and 8) - priority score       |
|                             | assigned to last competing application |
|                             | for this project.                      |
+-----------------------------+----------------------------------------+
| PROG_CLASS_CODE             | This is the primary ICs main PCC. Dual |
|                             | PCCs are in PV_ICD_ASSIGNMENTS_MV      |
+-----------------------------+----------------------------------------+
| PROJECT_PERIOD_END_DATE     | The start date of the period of        |
|                             | project.                               |
+-----------------------------+----------------------------------------+
| PROJECT_PERIOD_START_DATE   | The end date of the period of project. |
+-----------------------------+----------------------------------------+
| PROJECT_TITLE               | Title of the project.                  |
+-----------------------------+----------------------------------------+
| REQ_DIR_COST_YEAR_1_AMT     | Amount requested for the current year  |
+-----------------------------+----------------------------------------+
| REQ_DIR_COST_YEAR_2_AMT     | Direct cost amount requested for 1^st^ |
|                             | future year                            |
+-----------------------------+----------------------------------------+
| REQ_DIR_COST_YEAR_3_AMT     | Direct cost amount requested for 2^nd^ |
|                             | future year                            |
+-----------------------------+----------------------------------------+
| REQ_DIR_COST_YEAR_4_AMT     | Direct cost amount requested for 3^rd^ |
|                             | future year                            |
+-----------------------------+----------------------------------------+
| REQ_DIR_COST_YEAR_5_AMT     | Direct cost amount requested for 4^th^ |
|                             | future year                            |
+-----------------------------+----------------------------------------+
| REQ_DIR_COST_YEAR_6_AMT     | Direct cost amount requested for 5^th^ |
|                             | future year                            |
+-----------------------------+----------------------------------------+
| REQ_DIR_COST_YEAR_7_AMT     | Direct cost amount requested for 6^th^ |
|                             | future year                            |
+-----------------------------+----------------------------------------+
| RFA_PA_NUMBER               | 1\. RFA Number: The issuing ICD        |
|                             | assigns a number to a specific RFA.    |
|                             | Each RFA is a unique number stored as  |
|                             | ICD FY. RFA is a formal statement      |
|                             | which: a) invites grant or cooperative |
|                             | agreement applications in a            |
|                             | well-defined scientific area to        |
|                             | accomplish specific program purposes;  |
|                             | b) indicates amount of funds set aside |
|                             | for competition and/or estimated       |
|                             | number of awards to be made and; c)    |
|                             | identifies generally only one          |
|                             | application receipt date. An RFA may   |
|                             | be reissued, as necessary.             |
|                             |                                        |
|                             | 2\. PA Number: The number assigned by  |
|                             | the Institutional Liaison Office to a  |
|                             | specific PA issued by a particular     |
|                             | ICD. PA is stored as \"PA\",           |
|                             |                                        |
|                             | FY, sequential number within the FY.   |
|                             | PA is a formal statement, which        |
|                             | invites grant or cooperative agreement |
|                             | applications in a well-defined         |
|                             | scientific area to accomplish specific |
|                             | program purposes. The applications are |
|                             | reviewed by CSR during the same cycles |
|                             | as the regular applications. Special   |
|                             | funds are not set-aside for PAs.       |
+-----------------------------+----------------------------------------+
| SCI_CLASS_CODE              | NIH Central Scientific Classification  |
|                             | Code.                                  |
+-----------------------------+----------------------------------------+
| SERIAL_NUM                  | Identification number assigned in      |
|                             | serial number order within each        |
|                             | administering organization.            |
+-----------------------------+----------------------------------------+
| SNAP_INDICATOR_CODE         | Code that indicates whether the grant  |
|                             | is streamlined non-competing award     |
|                             | process application                    |
+-----------------------------+----------------------------------------+
| SPECIAL_CONSIDER_CODE       | Identifies special initial review      |
|                             | consideration. This item is part of    |
|                             | the definition of an IRG.              |
|                             |                                        |
|                             | Code Definition                        |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | INT Administrative review only.        |
|                             |                                        |
|                             | AHR Ad Hoc Review                      |
|                             |                                        |
|                             | NIR No initial review (previously      |
|                             | reviewed under another application     |
|                             | number.)                               |
|                             |                                        |
|                             | PRT A portion of a reviewed            |
|                             | application identified in IMPAC        |
|                             |                                        |
|                             | Item 6 (Former Number).                |
+-----------------------------+----------------------------------------+
| SPECIAL_DISP_CODE           | This identifies the special            |
|                             | disposition code listed below.         |
|                             |                                        |
|                             | Code Definition                        |
|                             |                                        |
|                             | \-\-\-- \-\-\-\-\-\-\-\-\--            |
|                             |                                        |
|                             | 0 Previous version of application was  |
|                             | awarded                                |
|                             |                                        |
|                             | 1 Withdrawn by applicant.              |
|                             |                                        |
|                             | 1 Cancelled fellowship awards.         |
|                             |                                        |
|                             | 2 Award terminated prior to end of     |
|                             | current grant period.                  |
|                             |                                        |
|                             | 3 Withdrawn due to receipt of          |
|                             | application amendment. (Not applicable |
|                             | for applications not recommended for   |
|                             | further consideration or awards.)      |
|                             |                                        |
|                             | \*4 Returned (ineligible               |
|                             | organization).                         |
|                             |                                        |
|                             | \*5 Returned (ineligible principal     |
|                             | investigator).                         |
|                             |                                        |
|                             | \*6 Returned (ineligible organization  |
|                             | and principal investigator).           |
|                             |                                        |
|                             | 7 Change of institution requested.     |
|                             |                                        |
|                             | 8 Administratively withdrawn by ICD    |
|                             | prior to review or council.            |
|                             |                                        |
|                             | 9 Administratively withdrawn by DRG.   |
|                             |                                        |
|                             | \*These codes cause application to be  |
|                             | deleted from IMPAC database. Is this   |
|                             | still true for IMPAC II?               |
+-----------------------------+----------------------------------------+
| SRA_DESIGNATOR_CODE         | This column is used to identify the    |
|                             | SRA/study section holding the meeting  |
|                             | under the SEP.                         |
+-----------------------------+----------------------------------------+
| SRA_PERSON_ID               | Person ID of the SRA                   |
+-----------------------------+----------------------------------------+
| SRA_FIRST_NAME              | First name of the SRA                  |
+-----------------------------+----------------------------------------+
| SRA_FLEX_CODE               | Identifies the SRA/study section       |
|                             | holding the meeting under the SEP.     |
+-----------------------------+----------------------------------------+
| SRA_LAST_NAME               | Last name of the SRA                   |
+-----------------------------+----------------------------------------+
| SRA_MIDDLE_NAME             | Middle name of the SRA                 |
+-----------------------------+----------------------------------------+
| SRA_EMAIL_ADDR              | Email address for the SRA              |
+-----------------------------+----------------------------------------+
| SRA_WRK_PHONE_NUM           | Work phone number of the SRA           |
+-----------------------------+----------------------------------------+
| SS_ADMIN_NOTE_FLAG          | Indicator of the existence of          |
|                             | administrative note in the summary     |
|                             | statement.                             |
+-----------------------------+----------------------------------------+
| SS_BIOHAZARD_FLAG           | Indicator of the existence of          |
|                             | biohazard note in the summary          |
|                             | statement.                             |
+-----------------------------+----------------------------------------+
| SS_BUDGET_COMMENTS_FLAG     | A flag indicating whether there are    |
|                             | budget comments on summary statements. |
+-----------------------------+----------------------------------------+
| SS_FOREIGN_FLAG             | Indicator of the existence of foreign  |
|                             | note in the summary statement.         |
+-----------------------------+----------------------------------------+
| SS_STEM_CELL_RESEARCH_FLAG  | Indicator of the existence of stem     |
|                             | cell research in the summary           |
|                             | statement. (Does not currently exist   |
|                             | in IMPACII)                            |
+-----------------------------+----------------------------------------+
| SUFFIX_CODE                 | Identifies Amendments (An),            |
|                             | Supplements (Sn), and Institutional    |
|                             | Allowance for Fellowships (Xn).        |
+-----------------------------+----------------------------------------+
| SUM                         | The date the summary statement was     |
| MARY_STATEMENT_RELEASE_DATE | submitted for general access.          |
|                             | (SUBMTD_DATE)                          |
+-----------------------------+----------------------------------------+
| SU                          | The code indicating the status of the  |
| MMARY_STATEMENT_STATUS_CODE | body of the summary statement. NULL    |
|                             | means no body yet, \'IN\' - body is    |
|                             | checked in to the database; \'OUT\' -  |
|                             | body is checked out for editing.       |
|                             | (SS_BODY_STATUS_CODE)                  |
+-----------------------------+----------------------------------------+
| SUPPORT_YEAR                | Identifies specific year of support.   |
|                             | The code \"00\" indicates a new        |
|                             | agreement.                             |
+-----------------------------+----------------------------------------+
| TOTAL_AWARDED_AMT           | Amount awarded or to be awarded for    |
|                             | the fiscal year. If latest encumbrance |
|                             | date contains data, the entry in this  |
|                             | field is the actual amount awarded.    |
|                             | Otherwise, the award amount has not    |
|                             | been obligated.                        |
+-----------------------------+----------------------------------------+
| TOTAL_OBLGTD_AMT            | Total dollars obligated by the Office  |
|                             | of Financial Management at NIH.        |
+-----------------------------+----------------------------------------+
| TRACKING_EXCEPTION_CODE     | A code that identifies those contracts |
|                             | that are exempted from tracking of     |
|                             | minority and gender composition and    |
|                             | the reason they are excluded.          |
|                             |                                        |
|                             | The NIH Revitalization Act of 1993     |
|                             | requires that awards containing Human  |
|                             | Subjects be monitored for inclusion of |
|                             | women and minorities as subjects in    |
|                             | clinical research. Some awards, coded  |
|                             | as having human subjects, are excluded |
|                             | from this requirement. If Human        |
|                             | Subjects code equals to 10, leave this |
|                             | data item blank.                       |
+-----------------------------+----------------------------------------+
| UNOBLGTD_BAL_AMT            | The amount of un-obligated balance, as |
|                             | shown on the Notice of Grant Award,    |
|                             | PHS Form 1533 from prior budget        |
|                             | period(s), applied as partial payment  |
|                             | against the current award.             |
+-----------------------------+----------------------------------------+

### Outstanding Questions

This section lists elements that were requested but may or may not be in
IMPACII and are being analyzed to determine their status.

+------------------------------------+---------------------------------+
| **Data Element**                   | **Comments**                    |
+====================================+=================================+
| 901 Process                        | The electronic 901 Process is   |
|                                    | currently under development. We |
|                                    | will revisit this item later in |
|                                    | the lifecycle.                  |
+------------------------------------+---------------------------------+
| Awaiting Receipt of Applications   | Table ARAS_T used to support    |
| (ARA)                              | the receipt and referral        |
|                                    | application holds               |
|                                    | correspondence or other         |
|                                    | contacts from applicants or     |
|                                    | ICs. The specific data elements |
|                                    | needed from this table need to  |
|                                    | be identified.                  |
+------------------------------------+---------------------------------+
| ICO Application sequence number or | PD would like to be able to see |
| application review date            | approximately when their        |
|                                    | applications will be reviewed   |
|                                    | at the SRG meeting              |
+------------------------------------+---------------------------------+
| Minority Supplement Flag           | Need to determine if column     |
|                                    | APPLS_T.SPECIAL_SUPP_CODE will  |
|                                    | meet this requirement. Column   |
|                                    | SPECIAL_SUPP_CODE is used to    |
|                                    | identify Type 3-Supplement      |
|                                    | applications awarded with one   |
|                                    | of the following codes:         |
|                                    |                                 |
|                                    | Code Definition                 |
|                                    |                                 |
|                                    | \-\-\-- \-\-\-\-\-\-\-\-\--     |
|                                    |                                 |
|                                    | D Disabled                      |
|                                    |                                 |
|                                    | M Minority                      |
|                                    |                                 |
|                                    | W Women                         |
|                                    |                                 |
|                                    | Starting FY \'97, 0-9 and A-Z   |
|                                    | are also valid codes.           |
+------------------------------------+---------------------------------+
| Program Recommended Dollars        | Not tracked in IMPACII.         |
+------------------------------------+---------------------------------+
| Progress Reporting                 | Need to understand the          |
| PROGRESS_SUMMARIES_T in OLTP       | requirement better. Is this     |
|                                    | simply a flag indicating the    |
|                                    | presence or absence of the      |
|                                    | progress report? This data is   |
|                                    | stored in a LONG RAW() data     |
|                                    | type. Need to analyze the       |
|                                    | method for displaying LONG      |
|                                    | RAW() fields.                   |
+------------------------------------+---------------------------------+
| Summary Statement Sent to PI flag  | Not sure if this information is |
|                                    | currently tracked in IMPACII.   |
+------------------------------------+---------------------------------+
| Number future years recommended by | Can be derived by looking at    |
| IC Council                         | the council recommended dollars |
|                                    | columns and counting how many   |
|                                    | have dollars in them.           |
+------------------------------------+---------------------------------+
| Number future years recommended by | No longer doing budgets -- only |
| SRG/IRG                            | placing words in the summary    |
|                                    | statement                       |
+------------------------------------+---------------------------------+
| Number future years requested by   | Can be derived by looking at    |
| applicant                          | the requested dollars columns   |
|                                    | and counting how many have      |
|                                    | dollars in them                 |
+------------------------------------+---------------------------------+
| Population Tracking Code           | A future IMPACII enhancement    |
+------------------------------------+---------------------------------+
| Primary and secondary PD           | Does IMPACII track primary and  |
|                                    | secondary program officials?    |
+------------------------------------+---------------------------------+
| Patient Oriented Research (POR     | What is this and are they       |
| codes)                             | captured?                       |
+------------------------------------+---------------------------------+
| APPL_STATUS_GROUP_DESC             | Legal values requested for the  |
|                                    | PA business area are:           |
|                                    |                                 |
|                                    | Pre-Submission                  |
|                                    |                                 |
|                                    | Pending SRG                     |
|                                    |                                 |
|                                    | Pending Council                 |
|                                    |                                 |
|                                    | Post-Council                    |
|                                    |                                 |
|                                    | Post Award                      |
|                                    |                                 |
|                                    | Note: These values were         |
|                                    | recommended by the Program      |
|                                    | Portal JAD and are not yet an   |
|                                    | official part of the IMPACII    |
|                                    | lexicon. JAD participants have  |
|                                    | requested that applications be  |
|                                    | grouped into these categories.  |
+------------------------------------+---------------------------------+