AUC_LINE_CONST

(SQL Table)
Index Back

Sourcing Line Constraints

Line Constraints Table for Soucing 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 CONST_NBR Number(2,0) SMALLINT NOT NULL Constraint Number
7 SETID Character(5) VARCHAR2(5) NOT NULL SetID
8 CONSTRAINT_CD Character(18) VARCHAR2(18) NOT NULL Constraint Code

Prompt Table: CONSTRAINT_VW

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

Default Value: A

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

Default Value: E

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

Default Value: T

12 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

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

Default Value: O

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