PROBINSTSSO_BOUND_INDEX1/0 Table Edit (1=True, 0=False)
1/0 Table Edit (1=True, 0=False)
1/0 Table Edit (1=True, 0=False)
1/0 Table Edit (1=True, 0=False)
SSO_ATTR_BOUNDS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | SSO_BOUND_INDEX |
Number(10,0) | DECIMAL(10) NOT NULL | Bound constraint idx |
| 3 | SSO_BOUND_CODE | Character(30) | VARCHAR2(30) NOT NULL | policy code |
| 4 | SSO_ATTRIB_INDEX | Number(10,0) | DECIMAL(10) NOT NULL | attribute index |
| 5 | SSO_IF_AWARDED | Number(1,0) | SMALLINT NOT NULL | If awarded |
| 6 | SSO_ITEM_OR_TOT | Number(6,0) | INTEGER NOT NULL |
item or total
1/0 Table Edit (1=True, 0=False) |
| 7 | SSO_QTY_OR_PRICE | Number(1,0) | SMALLINT NOT NULL |
quantity or price
1/0 Table Edit (1=True, 0=False) |
| 8 | SSO_VNDR_OR_AGGR | Number(1,0) | SMALLINT NOT NULL |
single or aggregate suppliers
1/0 Table Edit (1=True, 0=False) |
| 9 | SSO_PCNT_OR_ABS | Number(1,0) | SMALLINT NOT NULL |
pecentage or absolute value
1/0 Table Edit (1=True, 0=False) |
| 10 | SSO_LOWER_BOUND | Number(15,4) | DECIMAL(14,4) NOT NULL | lower bound |
| 11 | SSO_UPPER_BOUND | Number(15,4) | DECIMAL(14,4) NOT NULL | upper bound |
| 12 | SSO_LESS_LO_P | Number(17,6) | DECIMAL(16,6) NOT NULL | Less lbd pnty |
| 13 | SSO_MORE_UP_P | Number(17,6) | DECIMAL(16,6) NOT NULL | More ubd pnty |
| 14 | SSO_BOUND_WEIGHT | Number(17,6) | DECIMAL(16,6) NOT NULL | Use bound |
| 15 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |