GM_PROP_PROF

(SQL Table)
 Index Back

Proposal Professionals

The list of professionals associated with the proposal / project. This list is used to determine who is associated with a project, their project role and who is to be included in the proposal budgets.

  • Parent Record Of GM_PROP_PROF_AA GM_PROP_PROF_CB

  • Audit Record: GM_AU_PROJ_RES

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
    3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
    4 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
    5 ROW_NUMBER Number(3,0) SMALLINT NOT NULL Row_Number

    Default Value: 1

    6 PERS_NUM Number(3,0) SMALLINT NOT NULL Professional Sequence

    Default Value: 10

    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: GM_PERSONAL1_VW

    8 GM_WF_ELIGIBLE Character(1) VARCHAR2(1) NOT NULL Workflow Eligible

    Y/N Table Edit

    9 NAME Character(50) VARCHAR2(50) NOT NULL Name
    10 PROF_ROLE_TYPE Character(4) VARCHAR2(4) NOT NULL Role Type

    Prompt Table: %EDITTABLE2

    11 REPORT_ROLE Character(4) VARCHAR2(4) NOT NULL Reporting Role used for Grants Post Award

    Prompt Table: %EDITTABLE3

    12 ADDRESS_NBR Number(2,0) SMALLINT NOT NULL Address Nbr
    13 PROJECT_ROLE Character(30) VARCHAR2(30) NOT NULL Project Role
    14 FIRST_TIME_PI Character(1) VARCHAR2(1) NOT NULL First Time PI

    Y/N Table Edit

    Default Value: N

    15 CREDIT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Percentage Credit
    16 PI_WAIVER Character(1) VARCHAR2(1) NOT NULL PI Eligibility Waiver

    Y/N Table Edit

    Default Value: N

    17 ORG Character(30) VARCHAR2(30) NOT NULL Organization
    18 NEW_PERSONNEL Character(1) VARCHAR2(1) NOT NULL New Personnel

    Y/N Table Edit

    Default Value: N

    19 GM_RESEARCH_FLG Character(1) VARCHAR2(1) NOT NULL Research

    Y/N Table Edit

    Default Value: Y

    20 CREDENTIAL Character(60) VARCHAR2(60) NOT NULL Credentials
    21 CO_ITYPE Character(40) VARCHAR2(40) NOT NULL NASA Co-Itype
    22 US_GOVT_EMP_IND Character(1) VARCHAR2(1) NOT NULL US Government Employee

    Y/N Table Edit

    Default Value: N

    23 USA_GOV_CD Character(4) VARCHAR2(4) NOT NULL US Government Agency

    Prompt Table: GM_US_GOV_CD

    24 AMOUNT_REQUEST Number(27,3) DECIMAL(26,3) NOT NULL Amount Requested
    25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    26 FORN_ORG_EMP_IND Character(1) VARCHAR2(1) NOT NULL Foreign Organization Employee

    Y/N Table Edit

    Default Value: N

    27 CONTACT_PI Character(1) VARCHAR2(1) NOT NULL Contact PI

    Y/N Table Edit

    Default Value: N

    28 PRIMARY_PI Character(1) VARCHAR2(1) NOT NULL Primary PI

    Y/N Table Edit

    Default Value: N

    29 INCL_IN_AWD_HDR Character(1) VARCHAR2(1) NOT NULL Include in Award Header Professionals when Proposal is Generated

    Y/N Table Edit

    Default Value: N