MSS_CAMPAIGNS
Stores manufacturing campaign definitions for an organization.
Details
-
Schema: FUSION
-
Object owner: MSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSS_CAMPAIGNS_PK |
CAMPAIGN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CAMPAIGN_ID | NUMBER | 18 | Yes | Unique identifier of the campaign. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | Identifier of the organization that the campaign belongs to. | |
| CAMPAIGN_NAME | VARCHAR2 | 300 | Yes | User-defined name of the campaign. | |
| DESCRIPTION | VARCHAR2 | 500 | Description of the manufacturing campaign. | ||
| WORK_CENTER_ID | NUMBER | 18 | Yes | Identifier of the work center associated with the campaign. Foreign key to MSS_ORG_RESOURCE_PARAMETERS. | |
| RESOURCE_ID | NUMBER | 18 | Yes | Identifier of the campaign resource on which the campaign is scheduled. Foreign key to MSS_ORG_RESOURCE_PARAMETERS. | |
| CAMPAIGN_ATTRIBUTE_SET_ID | NUMBER | 18 | Identifier of the campaign attribute value combination associated with the campaign. Foreign key to MSS_CAMPAIGN_ATTRIBUTE_SETS. | ||
| CAMPAIGN_SEQ_NUMBER | NUMBER | Yes | Sequence number that determines campaign ordering on the resource. | ||
| STATUS | VARCHAR2 | 40 | Yes | Status of the campaign. Valid values: Open|Completed. | |
| RUN_RATE_UNITS | NUMBER | Yes | Quantity produced in the number of hours specified by RUN_RATE_HOURS. | ||
| RUN_RATE_HOURS | NUMBER | Yes | Number of hours required to produce the quantity specified by RUN_RATE_UNITS. | ||
| CAMPAIGN_BASIS | VARCHAR2 | 30 | Basis used to define campaign size. Valid values: Quantity or Duration. If Quantity, duration is derived from run rate; if Duration, planned quantity is derived from run rate. | ||
| DURATION_HOURS | NUMBER | Yes | Planned duration of the campaign in hours. | ||
| PLANNED_QUANTITY | NUMBER | Yes | Planned quantity of the campaign, expressed in the campaign quantity unit of measure, which is defined in the MSS_ORG_RESOURCE_PARAMETERS table. | ||
| EARLIEST_START_DATE | TIMESTAMP | Earliest date and time at which the campaign may start. | |||
| START_DATE | TIMESTAMP | Calculated start date and time of the campaign. | |||
| END_DATE | TIMESTAMP | Calculated end date and time of the campaign. | |||
| LAST_WORK_ORDER_END_DATE | TIMESTAMP | Calculated completion date and time of the last work order assigned to the campaign. | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSS_CAMPAIGNS | mss_org_resource_parameters | ORGANIZATION_ID, WORK_CENTER_ID, RESOURCE_ID |
| MSS_CAMPAIGNS | mss_campaign_attribute_sets | CAMPAIGN_ATTRIBUTE_SET_ID |
| mss_campaign_work_orders | mss_campaigns | CAMPAIGN_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSS_CAMPAIGNS_N1 | Non Unique | Default | ORGANIZATION_ID, WORK_CENTER_ID, RESOURCE_ID |
| MSS_CAMPAIGNS_N2 | Non Unique | Default | CAMPAIGN_ATTRIBUTE_SET_ID |
| MSS_CAMPAIGNS_U1 | Unique | Default | CAMPAIGN_ID |