VRM_POL_SATISFACTION_EVENTS_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_POL_SATIS_EVENTS_GT_PK |
POL_SATISFACTION_EVENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| POL_SATISFACTION_EVENT_ID | NUMBER | 18 | Yes | Satisfaction measurement event unique identifier. | ||
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Performance obligation line identifier. | |||
| DOCUMENT_SUB_LINE_ID | NUMBER | 18 | Source document subline unique identifier to which this satisfaction event relates. | |||
| SATISFACTION_MEASUREMENT_NUM | NUMBER | 18 | Sequence number for the satisfaction measurement record. | |||
| SATISFACTION_MEASUREMENT_DATE | DATE | The date on which the satisfaction is measured. | ||||
| 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. | ||||
| 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. | ||||
| SATISFACTION_AMOUNT | NUMBER | NA | Obsolete | |||
| DISCARDED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this satisfaction measurement event was discarded. | ||
| DISCARDED_DATE | DATE | Indicates the date on which this satisfaction measurement event is discarded. | ||||
| 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. | ||
| 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. | ||||
| DOCUMENT_LINE_ID | NUMBER | 18 | Source document line. | |||
| PERIOD_NUMBER | NUMBER | 18 | Sequence of the period number while creating the satisfaction events. Used for internal processing. | |||
| FIRST_PERIOD_FLAG | VARCHAR2 | 1 | Indicates whether current satisfaction event is related to the first period. | |||
| LAST_PERIOD_FLAG | VARCHAR2 | 1 | Indicates whether the current satisfaction event is related to the last period. | |||
| 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. | ||||
| PROCESSED_FLAG | VARCHAR2 | 1 | Indicates whether this satisfaction event is processed or not. Blank indicates processed. N indicates not processed. | |||
| SATISFACTION_EVENT_STATUS_CODE | VARCHAR2 | 30 | Oracle internal use only. Used during internal processing to identify whether the satisfaction event is newly created or not. | |||
| 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. | |||
| SATISFACTION_EVENT_TYPE_CODE | VARCHAR2 | 30 | Indicates whether satisfaction event is a primary satisfaction event or additional satisfaction event. | |||
| DOCUMENT_ADDITIONAL_SLINE_ID | NUMBER | 18 | Source document additional subline unique identifier to which this additional satisfaction event is related. | |||
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_POL_SATIS_EVENTS_GT_N1 | Non Unique | PERF_OBLIGATION_LINE_ID |
| VRM_POL_SATIS_EVENTS_GT_U1 | Unique | POL_SATISFACTION_EVENT_ID |