PON_REQUIREMENT_SCORES
PON_REQUIREMENT_SCORES stores the scoring criteria for a header level requirement.
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PON_REQUIREMENT_SCORES_PK |
SCORE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AUCTION_HEADER_ID | NUMBER | 18 | Yes | Auction header id. | |
| REQUIREMENT_ID | NUMBER | 18 | Yes | Requirement id. | |
| SCORE_ID | NUMBER | 18 | Yes | Score id. | |
| SCORE_LEVEL | VARCHAR2 | 10 | Yes | Stores value "SCORE". Used for association/view link. | |
| DISP_SEQ_NUMBER | NUMBER | Score order within its containing requirement. Unique within its containing requirement. Store values such as 10,20,30. | |||
| SCORE_DISPLAY_NUMBER | VARCHAR2 | 80 | Identifier for the response value. It will be set for acceptable values belonging to requirements that are Multiple Choice with single selection or Multiple Choice with multiple selections as well as acceptable responses of Number, Date, or Date Time requirements. | ||
| TEXT_VALUE | VARCHAR2 | 1000 | Acceptable value for a text requirement. | ||
| NUMBER_FROM_RANGE | NUMBER | Begining of range of acceptable values for a Number requirement. | |||
| NUMBER_TO_RANGE | NUMBER | End of range of acceptable values for a Number requirement. | |||
| DATE_FROM_RANGE | DATE | Begining of range of acceptable values for a Date requirement. | |||
| DATE_TO_RANGE | DATE | End of range of acceptable values for a Date requirement. | |||
| DATETIME_FROM_RANGE | DATE | Begining of range of acceptable values for a DateTime requirement. | |||
| DATETIME_TO_RANGE | DATE | End of range of acceptable values for a DateTime requirement. | |||
| ALLOW_ATTACHMENT_CODE | VARCHAR2 | 30 | Indicate whether attachments from suppliers are allowed. Stores the lookup code of lookup type PON_REQ_ALLOW_ATTACHMENT. Possible Values are NOT_ALLOWED, OPTIONAL and REQUIRED. | ||
| SCORE | NUMBER | Score | |||
| TARGET_FLAG | VARCHAR2 | 1 | Indicates that this response value is the target response value for this requirement. | ||
| IS_DEFAULT_SCORE_ROW | VARCHAR2 | 1 | Indicate whether this is the special no response row. | ||
| ACC_RESPONSE_ID | NUMBER | 18 | Stores the ACC_RESPONSE_ID of POQ_QUES_ACC_RESPONSES_VL for acceptable values that were brought over when adding question as a requirement. | ||
| PREVIOUS_SCORE_ID | NUMBER | 18 | Stores the previous document acceptable values' score_id during copy/new round/amendment. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PON_REQUIREMENT_SCORES | pon_auction_headers_all | AUCTION_HEADER_ID |
| PON_REQUIREMENT_SCORES | pon_requirements | REQUIREMENT_ID |
| pon_requirements | pon_requirement_scores | SCORE_ID |
| pon_bid_requirement_values | pon_requirement_scores | SCORE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PON_REQUIREMENT_SCORES_N1 | Non Unique | Default | REQUIREMENT_ID |
| PON_REQUIREMENT_SCORES_N2 | Non Unique | Default | AUCTION_HEADER_ID |
| PON_REQUIREMENT_SCORES_U1 | Unique | Default | SCORE_ID |