CJM_PROGRAM_TIER_LINES_B
This table contains program tier lines information and can contain one or many tiers lines. This means that the To value of one tier will be the From value of the next tier.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CJM_PROGRAM_TIER_LINES_B_PK |
PROGRAM_TIER_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROGRAM_TIER_LINE_ID | NUMBER | 18 | Yes | Unique identifier for program tier lines. | |
| PROGRAM_TIER_HEADER_ID | NUMBER | 18 | Yes | Unique Identifier for a channel program tier header. | |
| TIER_LINE_NUMBER | NUMBER | User friendly alternate key for the tier line number to be displayed in the UI. | |||
| MINIMUM_VALUE | NUMBER | Indicates the minimum value for the tier line. | |||
| MAXIMUM_VALUE | NUMBER | Indicates the maximum value for the tier line. | |||
| DISCOUNT | NUMBER | Yes | Discount for the program tier line. | ||
| PRE_QUALIFYING_TIER_FLAG | VARCHAR2 | 1 | Indicates if the tier must start from the current tier line. | ||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CJM_PROGRAM_TIER_LINES_B_N1 | Non Unique | Default | PROGRAM_TIER_HEADER_ID |
| CJM_PROGRAM_TIER_LINES_B_U1 | Unique | Default | PROGRAM_TIER_LINE_ID |