GM_AWD_MOD_LINE

(SQL Table)
 Index Back

Award Modification

This record contains the Award Modification information.

  • Parent record: GM_AWARD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: CA_CNTR_SRCH_VW

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: GM_AWARD.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

    3 PERIOD Number(3,0) SMALLINT NOT NULL Period

    Default Value: 1

    4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 1

    5 REF_AWD_NUMBER Character(25) VARCHAR2(25) NOT NULL Reference Award Number

    Default Value: GM_AWARD.REF_AWD_NUMBER

    6 ISSUE_DT Date(10) DATE Issue Dt
    7 DONOT_RPT_FLG Character(1) VARCHAR2(1) NOT NULL Do Not Report

    Y/N Table Edit

    8 BEGIN_DT Date(10) DATE NOT NULL Begin Date

    Default Value: GM_AWD_MOD.BEGIN_DT

    9 END_DT Date(10) DATE NOT NULL End Date

    Default Value: GM_AWD_MOD.END_DT

    10 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    11 DESCRSHORT2 Character(10) VARCHAR2(10) NOT NULL Short Description
    12 COMMENTS Long Character CLOB Comment
    13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    14 PROJECT_ID_TO Character(15) VARCHAR2(15) NOT NULL Project ID To

    Prompt Table: GM_PRJ_ID_TO_VW