GM_MD_AWDMOD_VW

(SQL View)
 Index Back

Award Modification View

This view contains the Award Modification information.

SELECT CONTRACT_NUM , BUSINESS_UNIT , PERIOD , REF_AWD_NUMBER , ISSUE_DT , BEGIN_DT , END_DT , AMOUNT , CURRENCY_CD FROM PS_GM_AWD_MOD

  • 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

    Prompt Table: SP_BU_PC_NONVW

    3 PERIOD Number(3,0) SMALLINT NOT NULL Period
    4 REF_AWD_NUMBER Character(25) VARCHAR2(25) NOT NULL Reference Award Number
    5 ISSUE_DT Date(10) DATE Issue Dt
    6 BEGIN_DT Date(10) DATE NOT NULL Begin Date
    7 END_DT Date(10) DATE NOT NULL End Date
    8 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code