AUC_TMPLTE_LS(SQL Table) |
Index Back |
|---|---|
Template Search Results |
| # | 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_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Event Type
E=Auction S=RFx |
| 4 | AUC_TMPLTE_ID | Character(10) | VARCHAR2(10) NOT NULL | Template ID |
| 5 | AUC_TMPLTE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Template Type
B=Business Unit D=Department P=Personal |
| 6 | AUC_TMPLTE_DESCR | Character(25) | VARCHAR2(25) NOT NULL | Template Description |
| 7 | SELECT_PB | Character(1) | VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit Default Value: N |