Field | Type | Description |
DATA_SOURCE_IND | NUMBER | Data Source Indicator |
EVENT_IDX | NUMBER | Event IDX |
ID | NUMBER | ID |
JRN_CLEANSED_FLAG | CHAR(1) | JRN Cleansed Flag |
JRN_FLAG | CHAR(1) | JRN Flag |
JRN_SCN | NUMBER | JRN SCN |
JRN_SLICING_TS | DATE | JRN Slicing TS |
JRN_UPDATE_DTTM | DATE | JRN Update DTTM |
LOG_TIME | DATE | Log Time |
NOTE | VARCHAR2(4000) | Note |
USER_ID | VARCHAR2(32) | User ID |
Field | Type | Description |
|---|---|---|
DATA_SOURCE_IND | NUMBER | Data Source Indicator |
ERT | DATE | ERT |
EVENT_IDX | NUMBER | Event IDX |
JRN_CLEANSED_FLAG | CHAR(1) | JRN Cleansed Flag |
JRN_FLAG | CHAR(1) | JRN Flag |
JRN_SCN | NUMBER | JRN SCN |
JRN_SLICING_TS | DATE | JRN Slicing TS |
JRN_UPDATE_DTTM | DATE | JRN Update DTTM |
NUMB | NUMBER | Call Number |
PREV_ERT | DATE | Previous ERT |
PREV_SOURCE | VARCHAR2(1) | Previous Source |
SOURCE | VARCHAR2(1) | Source |
TIME_OF_EVENT | DATE | Time of Event |
USERNAME | VARCHAR2(32) | User Name |
Field | Type | Description |
|---|---|---|
ACTIVE | VARCHAR2(1) | Active Status |
CREW_CENTER | NUMBER | Crew Center |
DATA_SOURCE_IND | NUMBER | Data Source Indicator |
JRN_CLEANSED_FLAG | CHAR(1) | JRN Cleansed Flag |
JRN_FLAG | CHAR(1) | JRN Flag |
JRN_SCN | NUMBER | JRN SCN |
JRN_SLICING_TS | DATE | JRN Slicing TS |
JRN_UPDATE_DTTM | DATE | JRN Update DTTM |
VEHICLE_ID | NUMBER | Vehicle ID |
VEHICLE_NUMB | VARCHAR2(10) | Vehicle Number |
VEHICLE_TYPE | NUMBER | Vehicle Type |
Field | Type | Description |
|---|---|---|
CREW_ID | NUMBER | Crew ID |
DATA_SOURCE_IND | NUMBER | Data Source Indicator |
JRN_CLEANSED_FLAG | CHAR(1) | JRN Cleansed Flag |
JRN_EFF_END_DTTM | DATE | JRN Effective End DTTM |
JRN_EFF_START_DTTM | DATE | JRN Effective Start DTTM |
JRN_FLAG | CHAR(1) | JRN Flag |
JRN_SCN | NUMBER | JRN SCN |
JRN_SLICING_TS | DATE | JRN Slicing TS |
VEHICLE_ID | NUMBER | Vehicle ID |
Field | Type | Description |
|---|---|---|
DATA_SOURCE_IND | NUMBER | Data Source Indicator |
JRN_CLEANSED_FLAG | CHAR(1) | JRN Cleansed Flag |
JRN_FLAG | CHAR(1) | JRN Flag |
JRN_SCN | NUMBER | JRN SCN |
JRN_SLICING_TS | DATE | JRN Slicing TS |
JRN_UPDATE_DTTM | DATE | JRN Update DTTM |
TYPE_NUM | NUMBER | Type Number |
VEHICLE_TYPE | VARCHAR2(31) | Vehicle Type |
Field | Type | Description |
|---|---|---|
AUDIT_LOG_ENTRY_ TYPE | VARCHAR2(100) | Audit Log Entry Type |
DATA_SOURCE_IND | NUMBER | Data Source Indicator |
DEV_CLS | NUMBER | Dev CLS |
DEV_IDX | NUMBER | Dev IDX |
DEVICE_ALIAS | VARCHAR2(100) | Device Alias |
INSERT_TIME | DATE | Insert Time |
INSERT_USER | VARCHAR2(32) | Insert User |
JRN_CLEANSED_FLAG | CHAR(1) | JRN Cleansed Flag |
JRN_FLAG | CHAR(1) | JRN Flag |
JRN_SCN | NUMBER | JRN SCN |
JRN_SLICING_TS | DATE | JRN Slicing TS |
JRN_UPDATE_DTTM | DATE | JRN Update DTTM |
PHASES | NUMBER | Phases |
LOG_COMMENT | VARCHAR2(1024) | Log Comment |
LOG_ORDER | NUMBER | Log Order |
REVISION | NUMBER | Revision |
SAFETY_DOC_ID | NUMBER | Safety Doc ID |
SEQ_SHEET_ID | NUMBER | Sequence Sheet ID |
SEQ_LOG_ID | NUMBER | Sequence Log ID |
STATE | NUMBER | State |
STEP_IDX | NUMBER | Step IDX |
USER_LOG | CHAR(1) | User Log |
Field | Type | Description |
|---|---|---|
BEGIN_STEP_IDX | NUMBER | Begin Step IDX |
DATA_SOURCE_IND | NUMBER | Data Source Indicator |
END_STEP_IDX | NUMBER | End Step IDX |
JRN_CLEANSED_FLAG | CHAR(1) | JRN Cleansed Flag |
JRN_FLAG | CHAR(1) | JRN Flag |
JRN_SCN | NUMBER | JRN SCN |
JRN_SLICING_TS | DATE | JRN Slicing TS |
JRN_UPDATE_DTTM | DATE | JRN Update DTTM |
SEQ_ISN_ID | NUMBER | Seq ISN ID |
SEQ_SHEET_ID | NUMBER | Sequence Sheet ID |
SUPPLY_IDX | NUMBER | Supply IDX |
Field | Type | Description |
|---|---|---|
CREW_KEY | NUMBER | Crew Key |
DATA_SOURCE_IND | NUMBER | Data Source Indicator |
DCZNUM | NUMBER | |
DCZVALIDATED | VARCHAR2(4000) | |
DELETED | VARCHAR2(1) | Deleted |
DESCRIPTION | VARCHAR2(4000) | Description |
DOC_CLS | NUMBER | Document CLS |
DOC_IDX | NUMBER | Document Index |
DOC_TYPE | VARCHAR2(32) | Document Type |
EXTERNALSAFETYDOCID | VARCHAR2(4000) | External Safety Document ID |
FEEDER_NAME | VARCHAR2(4000) | Feeder Name |
ID | NUMBER | ID |
JRN_CLEANSED_FLAG | CHAR(1) | JRN Cleansed Flag |
JRN_FLAG | CHAR(1) | JRN Flag |
JRN_SCN | NUMBER | JRN SCN |
JRN_SLICING_TS | DATE | JRN Slicing TS |
JRN_UPDATE_DTTM | DATE | JRN Update DTTM |
LAST_UPDATE | NUMBER | Last Update |
NON_MODELED_ DEVICES | VARCHAR2(4000) | Non Modeled Devices |
STATE_KEY | NUMBER | State Key |
STUDY_STATE_KEY | NUMBER | Study State Key |
SW_PLAN_CLS | NUMBER | Switch Plan CLS |
SW_PLAN_IDX | NUMBER | Switch Plan IDX |
Field | Type | Description |
|---|---|---|
ACT_KEY | NUMBER | Act Key |
ACTIVE | VARCHAR2(1) | Active |
AVAILABLE_PHASES | NUMBER | Available Phases |
COMMENTS | VARCHAR2(255) | Comments |
COND_CLS | NUMBER | Cond CLS |
COND_IDX | NUMBER | Cond IDX |
CONDITION_ CONDITION_CLASS | VARCHAR2(4000) | Condition Class |
CONDITION_ CONDITION_TYPE | VARCHAR2(4000) | Condition Type |
CONDITION_DATE | DATE | Condition Date |
CONDITION_DETAILS | VARCHAR2(4000) | Condition Details |
CONDITION_PHASE_ ANNOTATION | VARCHAR2(4000) | Condition Phase Annotation |
CONDITION_ LOCATION | VARCHAR2(4000) | Condition Location |
CONDITION_STATUS | VARCHAR2(4000) | Condition Status |
CONDITION_SWITCH_ CLS | VARCHAR2(4000) | Condition Switch CLS |
CONDITION_SWITCH_ IDX | VARCHAR2(4000) | Condition Switch Index |
CONDITION_TEXT | VARCHAR2(4000) | Condition Text |
CONDITION_USER | VARCHAR2(4000) | Condition User |
CONTROL_TIME | DATE | Control Time |
DATA_SOURCE_IND | NUMBER | Data Source Indicator |
DETAILS | VARCHAR2(4000) | Details |
DEV_CLS | NUMBER | Dev CLS |
DEV_IDX | NUMBER | Dev IDX |
DEVICE_ALIAS | VARCHAR2(100) | Device Alias |
EDITED_OPERATION | VARCHAR2(4000) | Edited Operation |
EXECUTE_ORDER | NUMBER | Execute Order |
EXECUTED_BY | VARCHAR2(255) | Executed By |
EXECUTED_TIME | DATE | Executed Time |
FINISH_DATE | DATE | Finished Date |
GND_NODE_CLS | NUMBER | GND Node CLS |
GND_NODE_IDX | NUMBER | GND Node IDX |
HIDE_STEP | VARCHAR2(1) | Hide Step |
INCIDENT_DATA | VARCHAR2(4000) | Incident Data |
INSERTSTATUS | VARCHAR2(4000) | Insert Status |
INSERT_TIME | DATE | Insert Time |
INSERT_USER | VARCHAR2(32) | Insert User |
INSTRUCT_CONDITION_IDX | NUMBER | Instruct Condition IDX |
INSTRUCTED_CREW_ID | NUMBER | Instructed Crew ID |
INSTRUCTED_TIME | DATE | Instructed Time |
INSTRUCTED_USER | VARCHAR2(32) | Instructed User |
JRN_CLEANSED_FLAG | CHAR(1) | JRN Cleansed Flag |
JRN_FLAG | CHAR(1) | JRN Flag |
JRN_SCN | NUMBER | JRN SCN |
JRN_SLICING_TS | DATE | JRN Slicing TS |
JRN_UPDATE_DTTM | DATE | JRN Update DTTM |
LAST_RESULT_OF_ OPERATION | VARCHAR2(4000) | Last Result of Operation |
LOCATION | VARCHAR2(4000) | Location |
MB_EDIT | VARCHAR2(1) | MB Edit |
NCG | NUMBER | NCG |
OPERATION_OUTCOME | VARCHAR2(4000) | Operation Outcome |
PARENT_STEP_ID | NUMBER | Parent Step ID |
PHASES | NUMBER | Phases |
PLANNED_OFFSET | NUMBER | Planned Offset |
PREV_STEP_IDX | NUMBER | Previous Step Index |
RESULT_FEEDERS | VARCHAR2(4000) | Result Feeders |
RESULT_OF_ OPERATION | VARCHAR2(4000) | Result of Operation |
REVISION | NUMBER | Revision |
REVISION_DELETED | NUMBER | Revision Deleted |
SAFETY_COND_ADDED | NUMBER | Safety Condition Added |
SAFETY_COND_ REMOVED | NUMBER | Safety Condition Removed |
SAFETY_DEV_STATUS | VARCHAR2(20) | Safety Dev Status |
SAFETY_DOC_ID | NUMBER | Safety Doc ID |
SAFETY_INFO_TEXT | VARCHAR2(1024) | Safety Information Text |
SEC_DEV_CLS | NUMBER | Sec Dev CLS |
SEC_DEV_IDX | NUMBER | Sec Dev Index |
SEQ_BLOCK_ID | NUMBER | Sequence Block ID |
SEQ_SHEET_ID | NUMBER | Sheet SEQ ID |
SET_VALUE | NUMBER | Set Value |
SRS_BITMASK | NUMBER | SRS Bitmask |
START_DATE | DATE | Start Date |
STATE_KEY | NUMBER | State Key |
STATE_TRIGGER | VARCHAR2(4000) | State Trigger |
STEP_CLS | NUMBER | Step CLS |
STEP_DESCRIPTION | VARCHAR2(255) | Step Description |
STEP_GROUP_NUMBER | NUMBER | Step Group Number |
STEP_IDX | NUMBER | Step Index |
STEP_ORDER | NUMBER | Step Order |
STUDY_SAFETY_DEV_ STATUS | VARCHAR2(20) | Study Safety Dev Status |
STUDY_STATE_KEY | NUMBER | Study State Key |
TYPE_NUM | NUMBER | Type Number |
UNDO_OPERATION_ OUTCOME | VARCHAR2(4000) | Undo Operation Outcome |
UPDATE_TIME | DATE | Update Time |
UPDATE_USER | VARCHAR2(32) | Update User |
VEHICLE_TYPE | VARCHAR2(31) | Vehicle Type |
VERSION | TIMESTAMP(6) | Version |
Field | Type | Description |
|---|---|---|
ALTERNATEFINISHDATE | DATE | Alternate Finish Date |
ALTERNATESTARTDATE | DATE | Alternate Start Date |
CHARGENUMBER1 | VARCHAR2(4000) | Charge Number 1 |
CHARGENUMBER2 | VARCHAR2(4000) | Charge Number 2 |
CHARGENUMBER3 | VARCHAR2(4000) | Charge Number 3 |
CHECKED_IN | VARCHAR2(1) | Checked in |
COMPLETED_DATE | DATE | Completed Date |
CREWWILLRESTORE | VARCHAR2(4000) | Crew Will Restore |
CREWWILLSWITCH | VARCHAR2(4000) | Crew Will Switch |
CUSTOMERREQUESTEDEMAILADDRESS | VARCHAR2(4000) | Customer Requested Email ID |
CUSTOMERREQUESTEDPHONENUMBER | VARCHAR2(4000) | Customer Requested Phone Number |
CUSTOMERREQUESTEDNAME | VARCHAR2(4000) | Customer Requested Name |
DATA_SOURCE_IND | NUMBER | Data Source Indicator |
DEFAULT_OFFSET | NUMBER | Default Offset |
DESCRIPTION | VARCHAR2(4000) | Description |
DELETED | VARCHAR2(1) | Deleted |
DEVICE_ALIAS | VARCHAR2(64) | Device Alias |
DEVICE_CLS | NUMBER | Device CLS |
DEVICE_IDX | NUMBER | Device IDX |
EDIT_MODE | NUMBER | Edit Mode |
EXTERNALSHEETID | VARCHAR2(4000) | External Sheet ID |
FEEDER_NAME | VARCHAR2(4000) | Feeder Name |
FINISH_DATE | DATE | Finish Date |
GROUNDSREQUIRED | VARCHAR2(4000) | Grounds Required |
INSERT_TIME | DATE | Insert Time |
INSERT_USER | VARCHAR2(100) | Insert User |
JRN_CLEANSED_FLAG | CHAR(1) | JRN Cleansed Flag |
JRN_FLAG | CHAR(1) | JRN Flag |
JRN_SCN | NUMBER | JRN SCN |
JRN_SLICING_TS | DATE | JRN Slicing TS |
JRN_UPDATE_DTTM | DATE | JRN Update DTTM |
LAST_SELECTED_STEP_ IDX | NUMBER | Last Selected Step IDX |
LOCATION | VARCHAR2(4000) | Location |
LOCKED_TIME | DATE | Locked Time |
LOCKED_USER | VARCHAR2(255) | Locked User |
MB_EDIT | VARCHAR2(1) | MB Edit |
NCG | NUMBER | NCG |
NUMBER_OF_STEPS | NUMBER | Number of Steps |
OFFICE | VARCHAR2(4000) | Office |
OWNER | VARCHAR2(32) | Owner |
REQUESTEREMAILADDRESS | VARCHAR2(4000) | Requester’s Email Address |
REQUESTERPHONENUMBER | VARCHAR2(4000) | Requester’s Phone Number |
REVISION | NUMBER | Revision |
REWORK_DESCRIPTION | VARCHAR2(55) | Rework Description |
REWORK_TIME | DATE | Rework Time |
SAS_DOC_TYPE | VARCHAR2(32) | SAS Doc Type |
SEQ_SHEET_ID | NUMBER | SEQ Sheet ID |
START_DATE | DATE | Start Date |
STATE_KEY | NUMBER | State Key |
SUBSTATION | VARCHAR2(4000) | Substation |
SWITCH_SHEET_CLS | NUMBER | Switch Sheet CLS |
SWITCH_SHEET_IDX | NUMBER | Switch Sheet Index |
UPDATE_TIME | DATE | Update TIME |
UPDATE_USER | VARCHAR2(100) | Update User |
VERSION | NUMBER | Version |
VOLTAGE | VARCHAR2(4000) | Voltage |
Field | Type | Description |
|---|---|---|
DATA_SOURCE_IND | NUMBER | Data Source Indicator |
DESCRIPTION | VARCHAR2(1024) | Description |
JRN_CLEANSED_FLAG | CHAR(1) | JRN Cleansed Flag |
JRN_FLAG | CHAR(1) | JRN Flag |
JRN_SCN | NUMBER | JRN SCN |
JRN_SLICING_TS | DATE | JRN Slicing TS |
JRN_UPDATE_DTTM | DATE | JRN Update DTTM |
SHEET_CATEGORY | NUMBER | Sheet Category |
SHEET_UI_PANEL | VARCHAR2(255) | Sheet UI Panel |
SWITCH_CLS_IDX_POOL | NUMBER | Switch CLS IDX Pool |
SWITCH_SHEET_CLS | NUMBER | Switch Sheet CLS |
SWITCH_SHEET_ DISPLAY_ORDER | NUMBER | Switch Sheet Display Order |
SWITCH_SHEET_TYPE | VARCHAR2(100) | Switch Sheet Type |
Field | Type | Description |
|---|---|---|
DATA | BLOB | Data |
DATA_SOURCE_IND | NUMBER | Data Source Indicator |
DESCRIPTION | VARCHAR2(4000) | Description |
DOCUMENT_ID | NUMBER | Document ID |
FILE_MODIFIED_DATE | TIMESTAMP(6) | File Modified Date |
FILE_NAME | VARCHAR2(64) | File Name |
JRN_CLEANSED_FLAG | CHAR(1) | JRN Cleansed Flag |
JRN_FLAG | CHAR(1) | JRN Flag |
JRN_SCN | NUMBER | JRN SCN |
JRN_SLICING_TS | DATE | JRN Slicing TS |
JRN_UPDATE_DTTM | DATE | JRN Update DTTM |
LENGTH | NUMBER | Length |
SEQ_SHEET_ID | NUMBER | SEQ Sheet ID |