AUC_NOA_HDR(SQL Table) |
Index Back |
---|---|
NOA HeaderNOA Header |
# | 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 |