CST_WD_OPERATION_RESOURCES_GT
This table contains the resource information consumed in the operation information obtained by calling the manufacturing api to get the work definition information for configured item work definitions.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WD_OPERATION_RESOURCE_ID | NUMBER | 18 | Indicates the fusion manufacturing operation resource identifier based on which the operation resource snap shot is created for work definitions. | ||
| RESOURCE_ID | NUMBER | 18 | Yes | Indicates the resource used for the work definition operation. | |
| OPERATION_SEQ_NUMBER | NUMBER | Yes | Indicates the sequence of the operation in the work definition snap shot. | ||
| RESOURCE_SEQ_NUMBER | NUMBER | Yes | Indicates the resource sequence for the resource under the work definition operation. | ||
| RESOURCE_NAME | VARCHAR2 | 80 | Indicates the name of the resource consumed in the operation performed. | ||
| RESOURCE_DESCRIPTION | VARCHAR2 | 240 | Indicates the description of the resource consumed in the operation performed. | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Indicates the unit of measure of the resource usage rate. | |
| USAGE_RATE | NUMBER | Yes | Indicates the resource usage rate for the resource under the work definition operation. | ||
| INVERSE_USAGE_RATE | NUMBER | Indicates the inverse resource usage rate for the resource under the work definition operation. | |||
| BASIS_TYPE | VARCHAR2 | 30 | Yes | Indicates the basis type for the resource usage rate. Fixed rate means that the resource is used once as per the resource usage rate for the entire batch. Variable rate means that for each item produced, the resource is used as per the resource usage rate specified. | |
| REQUIRED_RESOURCE_USAGE | NUMBER | Indicates the required resource usage for the resource consumed in the operation performed. | |||
| ASSIGNED_UNITS | NUMBER | Yes | Indicates the number of assigned units of the resource for the operation sequence. | ||
| RESOURCE_ACTIVITY_CODE | VARCHAR2 | 30 | Indicates the activity this resource is going to perform in this operation. Values are contained within the WIS_RESOURCE_ACTIVITY lookup. | ||
| SCHEDULE_TYPE | VARCHAR2 | 30 | Yes | Indicates the schedule type of the resource consumed in the operation performed. | |
| CHARGE_TYPE | VARCHAR2 | 30 | Indicates the charge type of the resource consumed in the operation performed. | ||
| PRINCIPAL_FLAG | VARCHAR2 | 1 | Yes | Indicates the principal flag of the resource consumed in the operation performed. | |
| WD_OPERATION_ID | NUMBER | 18 | Yes | Indicates the Fusion manufacturing operation identifier based on which the work definition operation snap shot is created | |
| LEVEL_NUMBER | NUMBER | Indicates the level number of the resource consumed in the operation performed. | |||
| WORK_CENTER_ID | NUMBER | 18 | Yes | Indicates the work center identifier for the resource under the work definition operation. | |
| PHANTOM_FLAG | VARCHAR2 | 1 | Indicates the phantom flag of the resource consumed in the operation performed. | ||
| 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. |