| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_NOMETA_VW
|
| 2 |
CONSTRAINT_CD |
Character(18) |
VARCHAR2(18) NOT NULL |
Constraint Code
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 4 |
CONST_RULE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Rule Number
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
CONST_RULE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Constraint Rule Type
H=Header\Overall Event rule
L=Line Rule
Default Value: L
|
| 7 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 8 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
CAL_DEFN_TBL
|
| 9 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 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 |
AUC_CAT_OPERAND |
Character(2) |
VARCHAR2(2) NOT NULL |
Category Operand
EQ=Equal To
NE=Not Equal To
Default Value: EQ
|
| 14 |
AUC_EXTPRC_OPERAND |
Character(2) |
VARCHAR2(2) NOT NULL |
Extended Price Operand
EQ=Equal To
GE=Greater Than or Equal To
LE=Less Than or Equal To
NE=Not Equal To
Default Value: EQ
|
| 15 |
AUC_PRICE_OPERAND |
Character(2) |
VARCHAR2(2) NOT NULL |
Price Operand
EQ=Equal To
GE=Greater Than or Equal To
LE=Less Than or Equal To
NE=Not Equal To
Default Value: EQ
|
| 16 |
AUC_ITEM_OPERAND |
Character(2) |
VARCHAR2(2) NOT NULL |
Item Operand
EQ=Equal To
NE=Not Equal To
Default Value: EQ
|
| 17 |
AUC_QTY_OPERAND |
Character(2) |
VARCHAR2(2) NOT NULL |
Quantity Operand
EQ=Equal To
GE=Greater Than or Equal To
LE=Less Than or Equal To
NE=Not Equal To
Default Value: EQ
|
| 18 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
ITM_PURCH_VW
|
| 19 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
|
| 20 |
QTY_AUC |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Event Quantity
|
| 21 |
AUC_PRICE |
Number(17,5) |
DECIMAL(16,5) NOT NULL |
Event Start price
|
| 22 |
AUC_EXT_PRICE |
Number(18,5) |
DECIMAL(17,5) NOT NULL |
Auction Extended Price
|