AUC_COLLAB_LOG

#	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	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
6	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
7	CHNG_DTTM	DateTime(26)	TIMESTAMP	Change Request Date/Time
8	AUC_COLLAB_SEQNUM	Number(3,0)	SMALLINT NOT NULL	Collaboration Sequence number
9	AUC_COLLAB_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Collaborator OPRID
10	AUC_COLLAB_NBR	Number(4,0)	SMALLINT NOT NULL	Random Collab Log Nbr
11	AUC_CHNG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Change A=Add B=Bid Factor Defaults D=Delete N=None U=Update
12	AUC_FIELDLABEL	Character(50)	VARCHAR2(50) NOT NULL	Field Label
13	AUC_FIELDTYPE	Character(1)	VARCHAR2(1) NOT NULL	Field Type A=AlphaNumeric Character D=Date L=Long Character N=Numeric T=DateTime
14	AUC_PREV_VALUE	Character(254)	VARCHAR2(254) NOT NULL	Previous Value
15	AUC_NEW_VALUE	Character(254)	VARCHAR2(254) NOT NULL	New Value
16	AUC_PREV_NBRVAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Previous Value
17	AUC_NEW_NBRVAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	New Value
18	AUC_NEW_COMMENTS	Long Character(32700)	CLOB	New Comments
19	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
20	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
21	AUC_TIER_NBR	Number(5,0)	INTEGER NOT NULL	Tier Number
22	AUC_IMAGE_NBR	Number(5,0)	INTEGER NOT NULL	Image Number
23	BID_FACTOR_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Bid Factor Number
24	AUC_BF_LIST_LINE	Signed Number(6,0)	DECIMAL(5) NOT NULL	List Line number
25	AUC_PRC_COMP_NBR	Number(5,0)	INTEGER NOT NULL	Sourcing Price Components
26	BID_FACTOR_CD	Character(18)	VARCHAR2(18) NOT NULL	Bid Factor Code
27	AUC_ATTACH_NUM	Number(5,0)	INTEGER NOT NULL	Attachment Number
28	BIDDER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Bidder Setid
29	BIDDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Bidder ID
30	BIDDER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bidder Type B=Bidder C=Customer P=Public U=Uploaded V=Supplier
31	BIDDER_LOC	Character(10)	VARCHAR2(10) NOT NULL	Bidder Location
32	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
33	ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
34	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
35	COMMENT_ID	DateTime(26)	TIMESTAMP	DtTm Entered
36	RANDOM_CMMT_NBR	Number(4,0)	SMALLINT NOT NULL	Random Comments Number
37	AUC_DATE	Date(10)	DATE	Collaboration Due Date
38	AUC_PREV_DATE	Date(10)	DATE	Collaboration Due Date
39	DATETIME_COLLAB	DateTime(26)	TIMESTAMP	02/2001 cel WV-802-1.0. Datetime of when the line was approved by the supplier.
40	DATETIME_PREVIOUS	DateTime(26)	TIMESTAMP	04/01/01 CEL CN#WV802-1.0: Supplier Collaboration
41	AUC_COLLAB_CHNG	Character(1)	VARCHAR2(1) NOT NULL	Collaboration Update Status A=Add Rejected D=Delete Rejected N=None R=Update Rejected U=Update Accepted
42	CONSTRAINT_CD	Character(18)	VARCHAR2(18) NOT NULL	Constraint Code
43	CONST_NBR	Number(2,0)	SMALLINT NOT NULL	Constraint Number
44	CONST_ATTR_NBR	Number(2,0)	SMALLINT NOT NULL	Constraint Attribute
45	GRP_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Group Line Number
46	AUC_COLLAB_GRP_NBR	Number(3,0)	SMALLINT NOT NULL	Collaboration Group Number