GM_AWD_MOD_VW

(SQL View)
 Index Back

Award Modification

To be used on Console

SELECT A.CONTRACT_NUM , A.BUSINESS_UNIT , A.PERIOD , A.REF_AWD_NUMBER , A.ISSUE_DT , A.BEGIN_DT , A.END_DT , A.CURRENCY_CD , A.AMOUNT , A.DESCRSHORT2 ,A.COMMENTS , B.SEQ_NUM , B.REF_AWD_NUMBER , B.ISSUE_DT , B.DONOT_RPT_FLG , B.BEGIN_DT , B.END_DT , B.AMOUNT , B.DESCRSHORT2 , B.COMMENTS FROM PS_GM_AWD_MOD A , PS_GM_AWD_MOD_LINE B WHERE A.CONTRACT_NUM = B.CONTRACT_NUM AND A.PERIOD = B.PERIOD

  • 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 REF_AWD_NUMBER Character(25) VARCHAR2(25) NOT NULL Reference Award Number

    Default Value: GM_AWARD.REF_AWD_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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    9 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    10 DESCRSHORT2 Character(10) VARCHAR2(10) NOT NULL Short Description
    11 COMMENTS Long Character CLOB Comment
    12 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 1

    13 REF_AWD_NUM2 Character(25) VARCHAR2(25) NOT NULL Reference Award
    14 ISSUE_DATE Date(10) DATE Policy Issue Date
    15 DONOT_RPT_FLG Character(1) VARCHAR2(1) NOT NULL Do Not Report

    Y/N Table Edit

    16 BEGIN_DT_2 Date(10) DATE Begin Date
    17 END_DATE Date(10) DATE End Date
    18 AMOUNT_1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Work Field
    19 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    20 COMMENTS_LONG Long Character CLOB Comment Text