AUC_NOA_HDR

(SQL Table)
Index Back

NOA Header

NOA Header

  • Parent Record Of AUC_NOA_ATTCH AUC_NOA_BIDDER
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
    3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
    4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
    5 AUC_NOA_BDR_FLG Character(4) VARCHAR2(4) NOT NULL Notification To be Sent
    A=Only Awarded Bidders
    AN=All Bidders
    N=Only Non-Awarded Bidders
    SB=Specific Bidders

    Default Value: AUC_HDR.AUC_NOA_BDR_FLG

    6 AUC_NOA_SENT Character(1) VARCHAR2(1) NOT NULL NOA Status
    N=Not Sent
    Y=Sent

    Default Value: N

    7 AUC_NOA_LAST_SENT DateTime(26) TIMESTAMP Last Notified
    8 AUC_STD_COMM_TYPE4 Character(4) VARCHAR2(4) NOT NULL Standard Comment Type

    Prompt Table: AUC_STD_COM_TP4

    9 AUC_STD_COMM_ID4 Character(10) VARCHAR2(10) NOT NULL Standard Comment ID

    Prompt Table: AUC_STD_COM_4

    10 AUC_STD_OPEN_COMM Long Character CLOB Opening Text
    11 AUC_STD_COMM_TYPE6 Character(4) VARCHAR2(4) NOT NULL Standard Comment Type

    Prompt Table: AUC_STD_COM_TP6

    12 AUC_STD_COMM_ID6 Character(10) VARCHAR2(10) NOT NULL Standard Comment ID

    Prompt Table: AUC_STD_COM_6

    13 AUC_STD_CLOSE_COMM Long Character CLOB Closing Text
    14 DESCRLONG Long Character CLOB Long Description
    15 AUC_NOA_TMP_ID Character(30) VARCHAR2(30) NOT NULL Standard Email Template

    Default Value: AUC_HDR.AUC_NOA_TMP_ID

    Prompt Table: AUC_NOA_GEN_VW

    16 AUC_NOA_TMP_ID2 Character(30) VARCHAR2(30) NOT NULL NOA Report Template

    Default Value: AUC_HDR.AUC_NOA_TMP_ID2

    Prompt Table: AUCNOA_TMPL_VW

    17 AUC_NOA_TMP_ID3 Character(30) VARCHAR2(30) NOT NULL *Non-Award Template

    Default Value: AUC_HDR.AUC_NOA_TMP_ID3

    Prompt Table: AUCNONA_TMP_VW