VRM_POL_SATISFACTION_EVENTS
This table contains performance obligation line satisfaction events information for customer contract.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_POL_SATIS_EVENT_PK |
POL_SATISFACTION_EVENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| POL_SATISFACTION_EVENT_ID | NUMBER | 18 | Yes | Satisfaction measurement event unique identifier. | |
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Yes | Performance obligation line identifier. | |
| SATISFACTION_MEASUREMENT_NUM | NUMBER | 18 | Yes | Sequence number for the satisfaction measurement record. | |
| SATISFACTION_MEASUREMENT_DATE | DATE | Yes | The date on which the satisfaction is measured. This date will be used as the accounting date for the revenue accounting entry. If the satisfaction measurement event is created using the revenue schedule then the default measurement date will be the last date of the period for which the measurement event is created. | ||
| SATISFACTION_QUANTITY | NUMBER | Specifies the quantity satisfied on the measurement date. Used only when the model is Measure Quantity Satisfied. The default value is the fulfilled quantity of the source document line. | |||
| SATISFACTION_PERCENT | NUMBER | Specifies the percentage satisfied on the measurement date. If the model is Measure Percentage Satisfied then the value for this field will be either manually entered by the user or it will be provided by the source system. If the model is Measure Period Satisfied then the value for this field will be derived from the revenue schedule provided for the performance obligation line. | |||
| SATISFACTION_PERIOD_PROPORTION | NUMBER | If the satisfaction measurement model is Measure Period Satisfied then the value for this field will be derived from the revenue schedule provided for the performance obligation line. | |||
| DISCARDED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this satisfaction measurement event was discarded. | |
| DISCARDED_DATE | DATE | The date on which this satisfaction measurement event was discarded. | |||
| DOCUMENT_SUB_LINE_ID | NUMBER | 18 | Source document subline unique identifier to which this satisfaction event is related. | ||
| DOCUMENT_LINE_ID | NUMBER | 18 | Source document line. | ||
| DOCUMENT_ADDITIONAL_SLINE_ID | NUMBER | 18 | Source document additional subline unique identifier to which this additional satisfaction event is related. | ||
| SATISFACTION_PERIOD_START_DATE | DATE | Start date of the period satisfied. Used only when the model is Measure Period Satisfied. | |||
| SATISFACTION_PERIOD_END_DATE | DATE | End date of the period satisfied. Used only when the model is Measure Period Satisfied. | |||
| PROCESSED_FLAG | VARCHAR2 | 1 | Indicates whether this performance obligation line satisfaction event is processed or not. Blank indicates processed. N indicates not processed. | ||
| PROCESSED_AMOUNT | NUMBER | Recognized amount for this satisfaction event. | |||
| PROCESSED_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that processed this row. | ||
| HOLD_FLAG | VARCHAR2 | 1 | Indicates whether this performance obligation line satisfaction event can be processed. Can be used while processing contingencies. | ||
| COMMENTS | VARCHAR2 | 1000 | User entered comments while performing an action on a satisfaction event. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CREATED_FROM | VARCHAR2 | 30 | Yes | The process or user interface from which this row is created.. | |
| 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. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| DISCARDED_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that discarded this row. | ||
| SPLIT_FLAG | VARCHAR2 | 1 | Indicates whether this satisfaction measurement event was split because of a mid-month termination while processing an immaterial change. | ||
| PROCESSED_PERIOD_PROPORTION | NUMBER | Proportion of the satisfaction event period before the contract modification date. | |||
| SATISFACTION_EVENT_TYPE_CODE | VARCHAR2 | 30 | Indicates whether satisfaction event is a primary satisfaction event or additional satisfaction event. Valid values are from the lookup type ORA_VRM_SATIS_EVENT_TYPE | ||
| ADDITIONAL_SE_TYPE_CODE | VARCHAR2 | 30 | Additional satisfaction event used in the rule. Valid values are from the lookup type ORA_VRM_ADDL_SATIS_EVENTS. | ||
| ASE_PROCESS_FLAG | VARCHAR2 | 1 | Indicates whether the additional satisfaction event is validated against the primary satisfaction event. Valid values are Y and N. | ||
| ASE_SPLIT_FLAG | VARCHAR2 | 1 | Indicates whether the primary satisfaction event is split based on the additional satisfaction event. Valid values are Y and N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_POL_SATISFACTION_EVENTS | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
| VRM_POL_SATISFACTION_EVENTS | vrm_source_doc_sub_lines | DOCUMENT_SUB_LINE_ID |
| VRM_POL_SATISFACTION_EVENTS | vrm_source_doc_lines | DOCUMENT_LINE_ID |
| vrm_perf_obligation_lin_dists | vrm_pol_satisfaction_events | POL_SATISFACTION_EVENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_POL_SATIS_EVENT_N1 | Non Unique | Default | PROCESSED_FLAG, DISCARDED_FLAG |
| VRM_POL_SATIS_EVENT_N2 | Non Unique | Default | PERF_OBLIGATION_LINE_ID |
| VRM_POL_SATIS_EVENT_U1 | Unique | FUSION_TS_TX_DATA | POL_SATISFACTION_EVENT_ID |