WIS_WD_DETAILS_INT
This is the interface table for work definition details.
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
WIS_WD_DETAILS_INT_PK |
INTERFACE_ROW_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INTERFACE_ROW_ID | NUMBER | 18 | Yes | The unique identifier of a work definition interface record. Its value is an application generated unique id. | |
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. | |
INTERFACE_BATCH_CODE | VARCHAR2 | 30 | Yes | Represents the user identified code for the interface batch. | |
INTERFACE_BATCH_ID | NUMBER | 18 | Represents the internal interface batch identifier. This is used to group a batch of interface records for processing. When interface records are brought in via services or the UI, the system will internally generate this value. | ||
INTERFACE_STATUS_CODE | VARCHAR2 | 30 | Yes | Represents the progress of the interface processing with statuses such as ready for processing or currently in process as well as the various flavors of completion statuses. Valid values exist in the lookup with lookup type = ORA_WIE_INTERFACE_STATUS. | |
HEADER_NUMBER | VARCHAR2 | 18 | Yes | This attribute allows the user to connect the header records with the details in the various work definition interface details tables. | |
ACTION_CODE | VARCHAR2 | 30 | Yes | A code used to indicate if the system should create or update this entity. Valid values exist in the lookup with lookup type = ORA_WIS_WD_IMP_DETAIL_ACTION. | |
LOAD_TYPE | VARCHAR2 | 30 | Yes | A code used to indicate the type of data this detail record contains. This indicates if the data being loaded represents the work definition operation, work definition operation material, work definition operation resource, etc. Valid values exist in the lookup with lookup type = ORA_WIS_WD_IMP_LOAD_TYPE. | |
HEADER_INT_ROW_ID | NUMBER | 18 | The unique identifier of the row in the header interface table associated with this detail record. | ||
ORGANIZATION_ID | NUMBER | 18 | The organization identifier that represents the manufacturing plant to which this work definition operation belongs. | ||
WORK_DEFINITION_ID | NUMBER | 18 | Represents the work definition identifier that is the foreign key to the WIS_WORK_DEFINITIONS table. | ||
OPERATION_NAME | VARCHAR2 | 120 | Indicates the name of the work definition operation. | ||
OPERATION_DESCRIPTION | VARCHAR2 | 240 | Indicates the description of the work definition operation. | ||
OPERATION_TYPE | VARCHAR2 | 30 | Specifies the type of the operation. Valid values are contained within the ORA_WIS_OPERATION_TYPE lookup. | ||
OPERATION_SEQ_NUMBER | NUMBER | Indicates the execution sequence of the operation. | |||
WD_OPERATION_ID | NUMBER | 18 | The unique identifier of a work definition operation. Its value is an application generated unique id. | ||
EFFECTIVE_FROM_DATE | TIMESTAMP | Indicates the date from which this operation is effective. | |||
EFFECTIVE_TO_DATE | TIMESTAMP | Indicates the date from which this operation is no longer effective. | |||
WORK_CENTER_CODE | VARCHAR2 | 30 | Indicates the user key of the work center where this operation is executed. | ||
WORK_CENTER_ID | NUMBER | 18 | Indicates the work center where this operation is executed. | ||
COUNT_POINT_FLAG | VARCHAR2 | 1 | Flag used to indicate if this is a count point operation. If an operation is a count point operation, then you have to manually complete it. Any operations in between the count points are automatically completed (i.e. backflushed, etc.). | ||
AUTO_TRANSACT_FLAG | VARCHAR2 | 1 | Indicates whether both resources and materials are automatically charged based on the supply type or the charge type setups for the operation. If the supply type is Operation Pull, the component level issue transactions will happen when the operation is completed. If the supply type is Assembly Pull, the component level issue transactions will happen at the assembly completion event. Resource transactions are automatically done when the quantity is moved outside the operation. Valid values are 'Y' and 'N'. | ||
SERIAL_TRACKING_FLAG | VARCHAR2 | 1 | Flag used to indicate that the product is tracked by serial number while executing this operation. | ||
OPTION_DEPENDENT_FLAG | VARCHAR2 | 1 | Indicates whether the operation is dependent on the choice of one or multiple optional components. This applies to an ATO Model work definition only. | ||
PLANNING_PERCENT | NUMBER | Percentage used by planning for resources forecast explosion. This applies to an ATO Model work definition only. | |||
RULE_TEXT | CLOB | Holds the text which represents the rule in the format entered by the user. | |||
APPLICABILITY_RULE_ID | NUMBER | 18 | Flag used to indicate whether the operation is dependent on the choice of one or multiple optional components. This applies to an ATO Model work definition only. | ||
ADDL_MTL_AT_MANUAL_ISSUE | VARCHAR2 | 30 | Indicates whether or not this operation allows additional materials to be added at manual issue. Valid values exist in the lookup with lookup type = ORA_WIS_ADDL_MANUAL_ISSUE_OPTS. | ||
OP_COMPL_WITH_UNDER_ISSUE | VARCHAR2 | 30 | Indicates whether or not to allow operation completions with under issued material. Valid values exist in the lookup with lookup type = ORA_WIS_OP_COMPLETION_VAL_OPTS. | ||
OP_COMPL_WITH_OPEN_EXCEPTIONS | VARCHAR2 | 30 | Indicates whether or not to allow operation completions with open exceptions. Valid values exist in the lookup with lookup type = ORA_WIS_OP_COMPLETION_VAL_OPTS. | ||
REFERENCED_FLAG | VARCHAR2 | 1 | Flag used to indicate whether this operation references a standard operation. | ||
STANDARD_OPERATION_CODE | VARCHAR2 | 30 | A code that represents the user key to the standard operation. | ||
STANDARD_OPERATION_ID | NUMBER | 18 | Represents the standard operation identifier that is the foreign key to the WIS_STANDARD_OPERATIONS_B table. | ||
SHIPPING_DOCUMENTS_FLAG | VARCHAR2 | 1 | Flag used to determine whether shipping documents need to be generated for a supplier operation. Valid Values: 'Y' and 'N'. | ||
OSP_ITEM_NUMBER | VARCHAR2 | 300 | Item number that represents the value added service in a supplier operation. This is also commonly known as a partially finished assembly. | ||
OSP_ITEM_ID | NUMBER | 18 | Item identifier that represents the value added service in a supplier operation. This is also commonly known as a partially finished assembly. | ||
SUPPLIER_NAME | VARCHAR2 | 360 | Represents the name of the suggested supplier for a supplier operation. | ||
SUPPLIER_ID | NUMBER | 18 | Represents the identifier of the suggested supplier for a supplier operation. | ||
SUPPLIER_SITE_CODE | VARCHAR2 | 15 | Represents the code of the suggested supplier site for a supplier operation. | ||
SUPPLIER_SITE_ID | NUMBER | 18 | Represents the identifier of the suggested supplier site for a supplier operation. | ||
LEAD_TIME_UOM | VARCHAR2 | 3 | Represents the unit of measure code for the fixed and/or variable lead time values on the supplier operation. | ||
LEAD_TIME_UNIT_OF_MEASURE | VARCHAR2 | 25 | Represents the unit of measure for the fixed and/or variable lead time values on the supplier operation. | ||
FIXED_LEAD_TIME | NUMBER | Represents the fixed lead time used to calculate the operation's start and end date for the supplier operation. | |||
VARIABLE_LEAD_TIME | NUMBER | Represents the variable lead time used to calculate the operation's start and end date based on the operation quantity for the supplier operation. | |||
LEAD_TIME_PERCENT | NUMBER | Represents the offset percent used in lead time roll up to calculate the cumulative lead times. | |||
WORKER_ID | NUMBER | The partition number for multi-threading. | |||
RESOURCE_SEQ_NUMBER | NUMBER | Defines the actual sequence of the resource used in the operation. Multiple resources can be scheduled to be working concurrently within the same operation. Simultaneity is implemented by having more than one resource with the same sequence number. | |||
WD_OPERATION_RESOURCE_ID | NUMBER | 18 | The unique identifier of a work definition operation resource. Its value is an application generated unique id. | ||
RESOURCE_CODE | VARCHAR2 | 30 | Indicates the user key of the resource assigned to the operation. | ||
RESOURCE_ID | NUMBER | 18 | Indicates the resource assigned to the operation. | ||
ASSIGNED_UNITS | NUMBER | Indicates the number of resource instances assigned to this operation. | |||
USAGE_RATE | NUMBER | The resource usage rate to yield one unit of product. | |||
UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the resource usage rate. | ||
BASIS_TYPE | VARCHAR2 | 30 | Indicates whether the resource usage is fixed (i.e. usage per lot produced) or variable (i.e. usage per item produced). Valid values exist in the lookup with lookup type = EGP_BOM_BASIS_TYPE. | ||
SCHEDULE_TYPE | VARCHAR2 | 30 | Indicates if this resource is scheduled or not. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_SCHEDULE. | ||
PRINCIPAL_FLAG | VARCHAR2 | 1 | When two or more resources are running in parallel (i.e. simultaneous resources which have the same sequence number), one and only one of them must be marked as the principal/primary resource. Planning will identify bottlenecks if the principal resource is not available when checking for capacity. | ||
CHARGE_TYPE | VARCHAR2 | 30 | Indicates how the resource is charged during work execution. Valid values exist in the lookup with lookup type = ORA_WIS_CHARGE_TYPE. | ||
RESOURCE_ACTIVITY_CODE | VARCHAR2 | 30 | Indicates the activity this production resource is going to perform at this operation. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_ACTIVITY. | ||
INVERSE_USAGE_RATE | NUMBER | Indicates the inverse resource usage rate. | |||
ALTERNATE_RESOURCE_CODE | VARCHAR2 | 30 | Represents the resource code for the alternate resource. | ||
ALTERNATE_RESOURCE_ID | NUMBER | 18 | Represents the alternate resource identifier. This is a foreign key to the WIS_RESOURCES_B table. | ||
ALTERNATE_RESOURCE_UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code for the alternate resource. | ||
PRIORITY_RANKING | NUMBER | Indicates the order of preference. Planning uses this information to choose the appropriate alternate resource. | |||
MATERIAL_SEQ_NUMBER | NUMBER | Indicates the sequence of this material line within this operation. | |||
WD_OPERATION_MATERIAL_ID | NUMBER | 18 | The unique identifier of a work definition operation material. Its value is an application generated unique id. | ||
MATERIAL_TYPE | VARCHAR2 | 30 | Type of material consumed by the operation. Valid values exist in the lookup with lookup type = ORA_WIS_WD_INPUT_MATERIAL. | ||
MATERIAL_QUANTITY | NUMBER | This is the quantity required to produce one unit of finished goods. In the case of an ATO model, this field will not be populated and instead fetched directly from PIM. | |||
UNIT_OF_MEASURE | VARCHAR2 | 25 | Represents the unit of measure of the material quantity. | ||
YIELD_FACTOR | NUMBER | This is the percentage of material quantity actually incorporated into the finished good. | |||
INVERSE_MATERIAL_QUANTITY | NUMBER | Indicates the inverse quantity of material. | |||
SUPPLY_TYPE | VARCHAR2 | 30 | Indicates the supply type code. Valid values exist in the lookup with lookup type = EGP_WIP_SUP_TYPE. | ||
ADHOC_FLAG | VARCHAR2 | 1 | Flag used to indicate whether this material line is based on the item structure. | ||
COMPONENT_SEQUENCE_ID | NUMBER | 18 | Reference to the item structure component (EGP_COMPONENTS_B) assigned to this operation. | ||
COMPONENT_SEQUENCE_ID_PATH | CLOB | Contains the lineage key of this component in the ATO Model item structure. This attribute refers to EGP_EXPLOSIONS_V.COMP_SEQ_PATH. It is used to uniquely identify this component in the exploded ATO Model item structure. | |||
COMPONENT_HIERARCHY | VARCHAR2 | 4000 | Contains the user enterable lineage key of this component in the ATO Model item structure. This lineage key would be the path from the top level model to the item that user wants to assign. | ||
INVENTORY_ITEM_NUMBER | VARCHAR2 | 300 | Represents the unique number of the item for this material line. | ||
INVENTORY_ITEM_ID | NUMBER | 18 | Represents the unique identifier of the item for this material line. | ||
FIND_NUMBER | NUMBER | A unique number used to identify each instance of the same component occurring multiple times at the same level in an item structure. | |||
SUPPLY_SUBINVENTORY_NAME | VARCHAR2 | 10 | Indicates the subinventory from which this material line is consumed. | ||
SUPPLY_LOCATOR_ID | NUMBER | 18 | Indicates the locator from which this material line is consumed. | ||
SUPPLY_LOCATOR_SEGMENT1 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT2 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT3 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT4 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT5 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT6 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT7 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT8 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT9 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT10 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT11 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT12 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT13 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT14 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT15 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT16 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT17 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT18 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT19 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
SUPPLY_LOCATOR_SEGMENT20 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
WD_OPERATION_OUTPUT_ID | NUMBER | 18 | The unique identifier of a work definition operation output. Its value is an application generated unique id. | ||
OUTPUT_SEQ_NUMBER | NUMBER | Indicates the sequence of this output line within this operation. | |||
OUTPUT_TYPE | VARCHAR2 | 30 | Type of output produced by the operation. Valid values exist in the lookup with lookup type = ORA_WIS_WD_OUTPUT_MATERIAL. | ||
OUTPUT_QUANTITY | NUMBER | Represents the output quantity expected to be produced at this operation. | |||
COMPLETION_TYPE | VARCHAR2 | 30 | Indicates the completion type code. Valid values exist in the lookup with lookup type = ORA_WIS_OUTPUT_COMPL_TYPE. | ||
PRIMARY_FLAG | VARCHAR2 | 1 | Indicates whether this is the primary output for the work definition. Valid values are Y or N. | ||
COST_ALLOCATION_PERCENTAGE | NUMBER | Indicates the cost percentage share of this output across all outputs. This column will be null for manually entered costs. | |||
COSTING_PRIORITY | NUMBER | Costing uses the highest priority work definition to calculate the standard cost using the cost rollup. Upon exploding the BOM the child work definitions are threaded using the priority number chosen at the very top. | |||
COMPL_SUBINVENTORY_CODE | VARCHAR2 | 10 | Indicates the subinventory into which this output line is produced. | ||
COMPL_LOCATOR_ID | NUMBER | 18 | Indicates the locator into which this output line is produced. | ||
COMPL_LOCATOR_SEGMENT1 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT2 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT3 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT4 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT5 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT6 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT7 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT8 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT9 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT10 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT11 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT12 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT13 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT14 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT15 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT16 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT17 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT18 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT19 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT20 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
RESEQUENCE_FLAG | VARCHAR2 | 1 | Flag used to indicate if the operation can be re-sequenced while executing the operation. Valid values are Y or N. | ||
PROFILE_ID | NUMBER | 18 | Foreign key reference to HCM model profiles. | ||
PROFILE_CODE | VARCHAR2 | 30 | The unique code which identifies the HCM model profile. | ||
EQP_QUAL_PROFILE_ID | NUMBER | 18 | Foreign key reference to equipment qualification profiles. | ||
EQP_QUAL_PROFILE_CODE | VARCHAR2 | 30 | The unique code which identifies the equipment qualification profile. | ||
DOCUMENT_ITEM_ID | NUMBER | 18 | Represents the unique identifier of the document item being associated to the resource instance that provides automation program information. Foreign key to EGP_SYSTEM_ITEMS_B table. | ||
PROGRAM_FILE_NAME | VARCHAR2 | 300 | Represents the name of the program file that needs to be associated to the resource instance associated to the work definition operation. | ||
EQP_PARAMS_FILENAME | VARCHAR2 | 512 | Represents the name of the file used to define program parameters and their values for an automation equipment resource. | ||
EQP_PARAMS_FILE_CONTENT | CLOB | Contains the program parameters and their values in csv format. | |||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | 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. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
LOAD_REQUEST_ID | NUMBER | 18 | This column is used when loading data from the csv file to the interface table using the central ESS program. This is the request id for the job that did the move from UCM to the interface table. | ||
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 |
---|---|---|---|
WIS_WD_DETAILS_INT_N01 | Non Unique | Default | HEADER_INT_ROW_ID, INTERFACE_STATUS_CODE, LOAD_TYPE, ACTION_CODE |
WIS_WD_DETAILS_INT_N02 | Non Unique | Default | WORKER_ID, INTERFACE_STATUS_CODE, LOAD_TYPE, ACTION_CODE |
WIS_WD_DETAILS_INT_N03 | Non Unique | Default | INTERFACE_BATCH_CODE, HEADER_NUMBER |
WIS_WD_DETAILS_INT_N04 | Non Unique | Default | REQUEST_ID, INTERFACE_STATUS_CODE |
WIS_WD_DETAILS_INT_N05 | Non Unique | Default | LAST_UPDATE_DATE, INTERFACE_STATUS_CODE |
WIS_WD_DETAILS_INT_U01 | Unique | Default | INTERFACE_ROW_ID |