GM_AWDMLS_ATT_V

(SQL View)
 Index Back

Award Attachments View

Award attachments view with milestone details

SELECT ATT.CONTRACT_NUM , SEQ_NBR , ATT.BUSINESS_UNIT , DESCR , ATT.MILESTONE_ID , ' ' , ' ' ,' ' ,' ' ,0 ,0 , ATT.COMMENTS , GM_ATT_TYPE , ATTACHSYSFILENAME , ATTACHUSERFILE , OPRID , LASTUPDDTTM , MILESTONE_TYPE , MILESTONE_CODE FROM PS_GM_AWD_ATTACH ATT , PS_GM_AWD_MILE MILE WHERE ATT.CONTRACT_NUM = MILE.CONTRACT_NUM AND ATT.MILESTONE_ID = MILE.MILESTONE_ID

  • Related Language Record: GM_AWD_ATT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Award ID
    2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: GM_AWARD.BUSINESS_UNIT

    Prompt Table: SP_BU_CA_NONVW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 MILESTONE_ID Character(6) VARCHAR2(6) NOT NULL Milestone_ID identifies the milestones that can be referenced from multiple functional areas.

    Prompt Table: GM_MLS_SRCH_VW

    6 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

    Prompt Table: SP_BU_PC_NONVW

    7 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: GM_AWD_PRJ_VW2

    8 CERT_CODE Character(5) VARCHAR2(5) NOT NULL Certification Code

    Prompt Table: GM_SRCH_CERT_VW

    9 BUDGET_PERIOD_GM Number(3,0) SMALLINT NOT NULL BUDGET_PERIOD_GM

    Prompt Table: GM_AWD_BUDPD_VW

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

    Prompt Table: GM_AWDMOD_PD_VW

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

    Prompt Table: GM_AWDMODSEQ_VW

    12 COMMENTS Long Character CLOB Comment
    13 GM_ATT_TYPE Character(1) VARCHAR2(1) NOT NULL Grants Attachment Type
    A=Award Modifications
    C=Certifications
    F=Funding Period
    G=General
    M=Milestones

    Default Value: G

    14 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    15 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    16 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    17 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    18 MILESTONE_TYPE Character(5) VARCHAR2(5) NOT NULL Milestone Type
    19 MILESTONE_CODE Character(15) VARCHAR2(15) NOT NULL Milestone Code