AUC_HDR_CLB_GRP(SQL Table) |
Index Back |
|---|---|
Collaboration Group 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_COLLAB_GRP_NBR |
Number(3,0) | SMALLINT NOT NULL | Collaboration Group Number |
| 6 | AUC_COLLAB_GRP | Character(40) | VARCHAR2(40) NOT NULL | Collaboration Group |
| 7 | AUC_COLLAB_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Process Type
P=Parallel S=Sequential Default Value: S |
| 8 | AUC_COLLAB_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Collaboration Source
A=Award B=Split Analysis C=Event Create Default Value: C |
| 9 | AUC_ROUTE_SEQ | Number(3,0) | SMALLINT NOT NULL | Routing Sequence |
| 10 | WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilisation totals |
| 11 | AUC_REVIEW_BY_DTTM | DateTime(26) | TIMESTAMP | Review By DateTime |
| 12 | AUC_AWDRVW_BY_DTTM | DateTime(26) | TIMESTAMP | Analysis Review By |
| 13 | AUC_DSP_BFCOST | Character(1) | VARCHAR2(1) NOT NULL |
Display Total Cost
Y/N Table Edit Default Value: Y |
| 14 | AUC_ROUTE_DTTM | DateTime(26) | TIMESTAMP | Routed To DateTime |
| 15 | AUC_AWD_ROUTE_DTTM | DateTime(26) | TIMESTAMP | Routed To DateTime |
| 16 | AUC_BF_RVW_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
Bid Factor Default Option
A=All Bid Factors C=Specific Bid Factors N=None Default Value: N |