AUC_OPT_HDR

#	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_OPT_RUN_ID	Number(3,0)	SMALLINT NOT NULL	Optimization Run ID
6	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
7	AUC_OPT_RCMD_NAME	Character(50)	VARCHAR2(50) NOT NULL	Recommendation Name
8	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals
9	AUC_OPT_BASED_ON	Character(1)	VARCHAR2(1) NOT NULL	Optimization Based On P=Price S=Score T=Total Cost
10	SSO_TOT_PRICE	Number(15,4)	DECIMAL(14,4) NOT NULL	total award price
11	SSO_OBJ_VALUE	Number(21,4)	DECIMAL(20,4) NOT NULL	objective value
12	SSO_NUM_AWARDED	Number(10,0)	DECIMAL(10) NOT NULL	num awarded suppliers
13	SSO_VNDR_OVER	Number(10,0)	DECIMAL(10) NOT NULL	num supplier over upper bound
14	SSO_VNDR_UNDER	Number(10,0)	DECIMAL(10) NOT NULL	num supplier under lower bound
15	SSO_NUM_OUTBND	Number(10,0)	DECIMAL(10) NOT NULL	num policy violated
16	DESCRLONG	Long Character	CLOB	Long Description