MSS_ORG_RESOURCE_ATTRIBUTES
This table stores assigned attributes to machine resources per an organization.
Details
-
Schema: FUSION
-
Object owner: MSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSS_ORG_RES_ATTRIBUTES_PK |
WORK_CENTER_ID, RESOURCE_ID, ATTRIBUTE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | 18 | Yes | Identifier of the organization. | ||
| WORK_CENTER_ID | NUMBER | 18 | Yes | Indicates the Work Center Identifier. | ||
| RESOURCE_ID | NUMBER | 18 | Yes | Reference to resource ID from resource table. | ||
| WORK_CENTER_CODE | VARCHAR2 | 100 | Yes | Indicates user defined work center code. | ||
| RESOURCE_CODE | VARCHAR2 | 300 | Yes | Indicates user defined resource code. | ||
| WORK_CENTER_NAME | VARCHAR2 | 120 | Display name of the work center (translatable). | |||
| RESOURCE_NAME | VARCHAR2 | 120 | Display name of the equipment or labor resource (translatable). | |||
| ATTRIBUTE_ID | NUMBER | 18 | Yes | Reference to attribute ID; foreign key to MSS_ORG_ATTRIBUTES | ||
| ATTRIBUTE_CODE | VARCHAR2 | 300 | Yes | User defined code of the attribute. | ||
| CYCLE_RULE | VARCHAR2 | 30 | Indicates the behavior of the sequence rule for the specified Resource and Attribute when using user defined attribute sequence. Valid values are RestartSequence, ContinueSequence, and ReverseSequence. Deprecated, use the new column in MSS_ORG_RES_ATTRIB_SEQS table. | Obsolete | ||
| 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_ORG_RESOURCE_ATTRIBUTES | mss_org_attributes | ORGANIZATION_ID, ATTRIBUTE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSS_ORG_RES_ATTRIBUTES_N1 | Non Unique | Default | ORGANIZATION_ID, ATTRIBUTE_ID |
| MSS_ORG_RES_ATTRIBUTES_U1 | Unique | Default | WORK_CENTER_ID, RESOURCE_ID, ATTRIBUTE_ID |