EGO_ENGINEERING_CHANGES_B
EGO_ENGINEERING_CHANGES_B stores information about both Engineering change order and New item request headers.Each row includes the unique identifier of the Change Order or New Item Request, the description, the change type, the reason and priority codes, the status, the requestor, the assignee, approval status, the implementation costs, and any cancellation information.
Details
-
Schema: FUSION
-
Object owner: EGO
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
EGO_ENGINEERING_CHANGES_B_PK |
CHANGE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
CHANGE_ID | NUMBER | 18 | Yes | Internal ID for uniquely identifying the change objects | ||
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. | ||
CHANGE_TYPE_ID | NUMBER | 18 | Yes | Identifier determining the change type of the change object | ||
BASE_CHANGE_MGMT_TYPE_CODE | VARCHAR2 | 30 | Yes | Code identifying the base change management type differentiating Change Order and New Item Request | ||
ORGANIZATION_ID | NUMBER | 18 | Yes | Identifier for Organization of the change object | ||
CHANGE_NOTICE | VARCHAR2 | 50 | Yes | Engineering change order number or New Item request number | ||
STATUS_TYPE | NUMBER | 18 | Yes | Change order or New Item Request Status | ||
STATUS_CODE | NUMBER | 18 | Yes | Code identifying the current status of the change object | ||
EFFECTIVE_IMMEDIATELY_FLAG | VARCHAR2 | 1 | This flag is copied from change order or new item request type to use as a default effective date for the affected items or new item request lines | |||
EFFECTIVITY_INCREMENT_DAYS | NUMBER | 9 | To specify a number by which the current context date would be incremented and set as an effective date on the lines for this change object instance. | |||
AUTO_COMPLETE_ON_CANCEL_FLAG | VARCHAR2 | 1 | Autocomplete Change Order When Change Line is Canceled | |||
INITIATION_DATE | TIMESTAMP | Yes | Date on which the change object is initiated | |||
IMPLEMENTATION_DATE | TIMESTAMP | Implementation date of the entire ECO or NIR | ||||
CANCELLATION_DATE | TIMESTAMP | Cancellation date of the entire ECO or NIR | ||||
PRIORITY_CODE | VARCHAR2 | 30 | Code identifying the priority of the change object | |||
REASON_CODE | VARCHAR2 | 30 | Code identifying the reason for the change object | |||
REQUESTOR_ID | VARCHAR2 | 64 | Identifier of the employee who requested this ECO or NIR | |||
APPROVAL_STATUS_TYPE | NUMBER | 18 | Identifier for the approval status of change object | |||
APPROVAL_DATE | DATE | Date the ECO or NIR was approved | ||||
APPROVAL_REQUEST_DATE | DATE | Date the approval status is changed to 'Approval requested | ||||
HIERARCHY_ID | NUMBER | 18 | Identifier to determine the change order propagation organization hierarchy | |||
ASSIGNEE_ID | VARCHAR2 | 64 | Identifier of the user or role to which the change object is assigned | |||
NEED_BY_DATE | DATE | Date by which the change object is needed | ||||
INTERNAL_USE_ONLY | VARCHAR2 | 1 | Internal Flag to denote if change order was created for versioned or non-versioned items | |||
SOURCE_TYPE_CODE | VARCHAR2 | 30 | Code identifying the source of change type for the change object | |||
SOURCE_ID | NUMBER | 18 | No longer used. | |||
SOURCE_NAME | VARCHAR2 | 80 | No longer used. | |||
PROMOTE_STATUS_CODE | NUMBER | 18 | Status code identifying auto promote status when submitting a new item request using quick submit action | |||
IMPLEMENTATION_REQ_ID | NUMBER | 18 | Stores Implementation Background request id of the change object | |||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
PROGRAM_NAME | VARCHAR2 | 30 | No longer used. | |||
PROGRAM_APP_NAME | VARCHAR2 | 50 | No longer used. | |||
CUSTOMER_ID | NUMBER | 18 | Identifier for the Customer who raised the Change Order. | |||
SUPPLIER_ID | NUMBER | 18 | Identifier for the Supplier for whom the Change Order is raised. | |||
MANUFACTURER_ID | NUMBER | 18 | Identifier for the Manufacturer. | |||
SOURCE_CODE | VARCHAR2 | 30 | Indicates the source of the Change Order. The supported Lookup Codes are defined for the Lookup Type with the name ORA_EGO_SOURCE | |||
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. | |||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name 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. | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
CURRENCY_CODE | VARCHAR2 | 15 | No longer used. | |||
CORP_CURRENCY_CODE | VARCHAR2 | 15 | No longer used. | |||
CURCY_CONV_RATE_TYPE | VARCHAR2 | 30 | No longer used. | |||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE26 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE27 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE28 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE29 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE30 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | ||
ATTRIBUTE31 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE32 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE33 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE34 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE35 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE36 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE37 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE38 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE39 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE40 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE41 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE42 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE43 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE44 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE45 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE46 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE47 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE48 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE49 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE50 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE51 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE52 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE53 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE54 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE55 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE56 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE57 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE58 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE59 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE60 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE61 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE62 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE63 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE64 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE65 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE66 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE67 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE68 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE69 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE70 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
WF_PROCESS_INSTANCE_ID | NUMBER | 18 | No longer used. | |||
WF_PROCESS_TEMPLATE | VARCHAR2 | 100 | No longer used. | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_NUMBER11 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER12 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER13 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER14 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER15 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER16 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER17 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER18 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER19 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER20 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE11 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE12 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE13 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE14 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE15 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE16 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE17 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE18 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE19 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE20 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE21 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE22 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE23 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE24 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE25 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE26 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE27 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE28 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE29 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE30 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE31 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE32 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE33 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE34 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE35 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | EGO_ENGINEERING_CHANGES (EGO_ENGINEERING_CHANGES) | |||
ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ASSIGNEE_ROLE_ID | VARCHAR2 | 64 | Stores the Role GUID of the assignee role | |||
EXTN_ATTRIBUTE_NUMBER001 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER002 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER003 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER004 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER005 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER006 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER007 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER008 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER009 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER010 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER011 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER012 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER013 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER014 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER015 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER016 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER017 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER018 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER019 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER020 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER021 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER022 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER023 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER024 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER025 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER026 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER027 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER028 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER029 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER030 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER031 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER032 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER033 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER034 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER035 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER036 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER037 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER038 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER039 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER040 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER041 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER042 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER043 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER044 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER045 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER046 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER047 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER048 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER049 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER050 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER051 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER052 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER053 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER054 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER055 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER056 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER057 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER058 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER059 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER060 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER061 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER062 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER063 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER064 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER065 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER066 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER067 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER068 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER069 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER070 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER071 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER072 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER073 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER074 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER075 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER076 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER077 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER078 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER079 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER080 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER081 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER082 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER083 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER084 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER085 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER086 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER087 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER088 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER089 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER090 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER091 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER092 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER093 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER094 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER095 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER096 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER097 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER098 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER099 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER100 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
EGO_ENGINEERING_CHANGES_B | ego_change_types_b | CHANGE_TYPE_ID |
EGO_ENGINEERING_CHANGES_B | ego_change_statuses_b | STATUS_CODE |
EGO_ENGINEERING_CHANGES_B | ego_change_statuses_b | STATUS_TYPE |
ego_external_created_changes | ego_engineering_changes_b | CHANGE_ID |
ego_change_propagation_maps | ego_engineering_changes_b | CHANGE_ID |
ego_revised_components | ego_engineering_changes_b | CHANGE_ID |
ego_change_logs | ego_engineering_changes_b | CHANGE_ID |
ego_change_lines_b | ego_engineering_changes_b | CHANGE_ID |
ego_engineering_changes_tl | ego_engineering_changes_b | CHANGE_ID |
ego_change_local_orgs | ego_engineering_changes_b | CHANGE_ID |
ego_change_eff_b | ego_engineering_changes_b | CHANGE_ID |
ego_change_obj_relationships | ego_engineering_changes_b | CHANGE_ID |
ego_co_publication | ego_engineering_changes_b | CHANGE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
EGO_ENGINEERING_CHANGES_B_PK | Unique | FUSION_TS_TX_DATA | CHANGE_ID |
EGO_ENGINEERING_CHANGES_B_UK1 | Unique | FUSION_TS_TX_DATA | CHANGE_NOTICE, ORGANIZATION_ID |
EGO_ENG_CHANGES_B_N1 | Non Unique | FUSION_TS_TX_DATA | ORGANIZATION_ID, BASE_CHANGE_MGMT_TYPE_CODE |
EGO_ENG_CHANGES_B_N2 | Non Unique | FUSION_TS_TX_DATA | BASE_CHANGE_MGMT_TYPE_CODE, STATUS_TYPE |
EGO_ENG_CHANGES_B_N3 | Non Unique | FUSION_TS_TX_DATA | ASSIGNEE_ID |
EGO_ENG_CHANGES_B_N4 | Non Unique | FUSION_TS_TX_DATA | CHANGE_TYPE_ID |
EGO_ENG_CHANGES_B_N5 | Non Unique | FUSION_TS_TX_DATA | SOURCE_TYPE_CODE, ORGANIZATION_ID, TO_CHAR("CHANGE_ID") |
ego_engineering_changes_b_X01 | Non Unique | FUSION_TS_TX_IDX | EXTN_ATTRIBUTE_NUMBER001 |
ego_engineering_changes_b_X02 | Non Unique | FUSION_TS_TX_IDX | EXTN_ATTRIBUTE_NUMBER002 |
ego_engineering_changes_b_X03 | Non Unique | FUSION_TS_TX_IDX | EXTN_ATTRIBUTE_NUMBER003 |