AUC_CONSTRAINTS

(SQL Table)
Index Back

Sourcing Constraints Table

Strategic Sourcing Policies and Constraints

# 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 CONST_NBR Number(2,0) SMALLINT NOT NULL Constraint Number
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 CONSTRAINT_CD Character(18) VARCHAR2(18) NOT NULL Constraint Code

Prompt Table: CONSTRAINT_VW

8 AUC_CONST_APPLY Character(1) VARCHAR2(1) NOT NULL Constraints
A=Apply
I=Ignore

Default Value: A

9 CONST_TYPE Character(1) VARCHAR2(1) NOT NULL Constraint Type
B=Bus Unit
E=Event
G=Global

Default Value: E

10 CONST_OBJECTIVE Character(1) VARCHAR2(1) NOT NULL Constraint Objective
M=Mandatory Goal
T=Target Goal

Default Value: T

11 CONST_PRIORITY Character(1) VARCHAR2(1) NOT NULL Constraint Priority
1=1 - Not Important
2=2 - Less Important
3=3 - Important
4=4 - Very Important
5=5 - Critical

Default Value: 3

12 CONST_SUMMARY Long Character CLOB Constraint Summary
13 CONST_ORIGIN Character(1) VARCHAR2(1) NOT NULL Constraint Origin
D=Defaulted
O=Operator Created\Added

Default Value: O

14 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID