This table contains information about code, name, and description of work order activity types
Module: Service Request Management
WORK_ORDER_ACTIVITY_TYPE_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| WORK_ORDER_ACTIVITY_TYPE_ID | NUMBER | 38 | 0 | True | Autogenerated number and primary key for this table. | ||
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | This column is for Oracle Internal use only. Source record identifier. | |||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| DISPLAY_SEQUENCE | NUMBER | 38 | 0 | Identifies the sequence in which the activity types are displayed in the user interface. | |||
| ENABLED_FLAG | VARCHAR2 | 16 | Enabled flag used to identify whether the work order activity type is enabled. | ||||
| ESTIMATED_DURATION | NUMBER | 38 | 0 | The estimated duration time (in minutes) that it's expected to take in order to complete a work order of this activity type. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
| LANGUAGE | VARCHAR2 | 16 | Indicates the code of the language into which the contents of the translatable columns are translated. | ||||
| DESCRIPTION | VARCHAR2 | 256 | Language dependent, translatable property used to capture the description of the activity type. | ||||
| NAME | VARCHAR2 | 128 | Language dependent, translatable activity type name. | ||||
| SOURCE_LANGUAGE | VARCHAR2 | 16 | Indicates the code of the language in which the contents of the translatable columns were originally created. |
Copyright © 2019, 2026, Oracle and/or its affiliates.