SORT21

Tables (22)

Copy Of Untitled (OFM_UTILITY_SORT_JOINKEYS_FILTER_COND)

  • Key (JOINKEYS_SEQ) — NUMBER(1) — Foreign key → Untitled.Key — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → Untitled.Field3 — NOT NULL
  • Field (FILTER_TYPE) — VARCHAR2(10) — NOT NULL
  • Field2 (COND) — VARCHAR2(10) — NOT NULL
  • Key (LOGEXP_ID) — NUMBER(20) — Foreign key → Untitled.Key — NOT NULL
  • Field4 (FORMAT) — VARCHAR2(10)

Copy Of Untitled2 (OFM_UTILITY_SORT_JOIN_REFORMAT_FIELD)

  • Field (FIELD_SEQ) — NUMBER(5) — Primary key — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → OFM_UTILITY_SORT_COMMAND.Field3 — NOT NULL
  • Field (FILE) — VARCHAR(2) — NOT NULL
  • Field (POSITION) — NUMBER(5) — NOT NULL
  • Field (LENGTH) — NUMBER(5) — NOT NULL
  • Field (FILL) — VARCHAR2(10) — NOT NULL
  • Field

OFM_UTILITY_SORT_COMMAND

  • Field (PROJECT_ID) — VARCHAR2(32) — Primary key — NOT NULL
  • Key (JOB_NAME) — VARCHAR2(256) — Primary key — NOT NULL
  • Field2 (STEP_NAME) — VARCHAR2(256) — Primary key — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Primary key — NOT NULL
  • Field4 (COMMAND) — VARCHAR2(10) — NOT NULL

Untitled (OFM_UTILITY_SORT_REFORMAT_FINDREP_INOUT)

  • Field (INOUT_SEQ) — NUMBER(20) — Primary key — NOT NULL
  • Field (FINDREP_SEQ) — NUMBER(20) — Foreign key → Untitled.Field — NOT NULL
  • Field (IFTHEN_ID) — NUMBER(20) — Foreign key → Untitled.Field — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → Untitled.Field3 — NOT NULL
  • Field (INCON) — VARCHAR2(256) — NOT NULL
  • Field (OUTCON) — VARCHAR2(256) — NOT NULL

Untitled (OFM_UTLITY_SORT_REFORMAT_BUILD_OVERLAY_ITEM_AREXP)

  • Key (ITEM_SEQ) — NUMBER(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (IFTHEN_ID) — NUMBER(20) — Foreign key → Untitled.Field — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → Untitled.Field3 — NOT NULL
  • Field (DIRECTION) — NUMBER(1) — NOT NULL
  • Field (POSITION) — NUMBER(5) — NOT NULL
  • Field (LENGTH) — NUMBER(5) — NOT NULL
  • Field (FORMAT) — NUMBER(5) — NOT NULL
  • Field (OPERATOR) — VARCHAR(3) — NOT NULL

Untitled (OFM_UTLITY_SORT_REFORMAT_BUILD_OVERLAY_ITEM)

  • Key (ITEM_SEQ) — NUMBER(20) — Primary key — NOT NULL
  • Field (IFTHEN_ID) — NUMBER(20) — Foreign key → Untitled.Field — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → Untitled.Field3 — NOT NULL
  • Field (ITEM_TYPE) — NUMBER(2) — NOT NULL
  • Field (COLUMN) — NUMBER(5) — NOT NULL
  • Field (SEPERATION) — VARCHAR(10) — NOT NULL
  • Field (POSITION) — NUMBER(5) — NOT NULL
  • Field (LENGTH) — NUMBER(5) — NOT NULL
  • Field (ALIGNMENT) — VARCHAR(1) — NOT NULL
  • Field (LABEL) — NUMBER(3) — NOT NULL
  • Field (TRAN) — VARCHAR(10) — NOT NULL
  • Field (FORMAT) — VARCHAR(10) — NOT NULL
  • Field (MN) — NUMBER(2) — NOT NULL
  • Field (PATTERN) — VARCHAR(50) — NOT NULL
  • Field (X) — VARCHAR(1) — NOT NULL
  • Field (Y) — VARCHAR(1) — NOT NULL
  • Field (SIGNS) — VARCHAR(10) — NOT NULL
  • Field (Z) — VARCHAR(1) — NOT NULL
  • Field (TO) — VARCHAR(10) — NOT NULL
  • Field (Y2X) — VARCHAR(1) — NOT NULL
  • Field (Y4X) — VARCHAR(1) — NOT NULL
  • Field (TODATE) — VARCHAR(20) — NOT NULL
  • Field (SHIFT) — NUMBER(1) — NOT NULL
  • Field (PREBLANK) — VARCHAR(20) — NOT NULL
  • Field (LEAD) — VARCHAR(60) — NOT NULL
  • Field (TRAIL) — VARCHAR(60) — NOT NULL
  • Field (MID) — VARCHAR(60) — NOT NULL
  • Field (PAIR) — NUMBER(1) — NOT NULL
  • Field (START) — NUMBER(12) — NOT NULL
  • Field (INCR) — NUMBER(8) — NOT NULL
  • Field (RESTART_POS) — NUMBER(5) — NOT NULL
  • Field (RESTART_LEN) — NUMBER(5) — NOT NULL
  • Field (RESTART_LABEL) — NUMBER(3) — NOT NULL

Untitled (OFM_UTILITY_SORT_OPTION)

  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → OFM_UTILITY_SORT_COMMAND.Field3 — NOT NULL
  • Field (ARESALL) — NUMBER(7) — NOT NULL
  • Field (ARESINV) — NUMBER(7) — NOT NULL
  • Field (AVGRLEN) — NUMBER(5) — NOT NULL
  • Field (CHALT) — NUMBER(1) — NOT NULL
  • Field (CHECK) — NUMBER(1) — NOT NULL
  • Field (CINV) — NUMBER(1) — NOT NULL
  • Field (CKPT) — NUMBER(1) — NOT NULL
  • Field (COBEXIT) — VARCHAR2(4) — NOT NULL
  • Field (COPY) — NUMBER(1) — NOT NULL
  • Field (DSA) — NUMBER(4) — NOT NULL
  • Field (DSPSIZE) — VARCHAR(4) — NOT NULL
  • Field (DYNALLOC) — NUMBER(1) — NOT NULL

Untitled (OFM_UTILITY_SORT_JOIN)

  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → OFM_UTILITY_SORT_COMMAND.Field3 — NOT NULL
  • Field (F1) — NUMBER(1) — NOT NULL
  • Field (F2) — NUMBER(1) — NOT NULL
  • Field (ONLY) — NUMBER(1) — NOT NULL

Untitled (OFM_UTILITY_SORT_JOINKEYS_FIELD)

  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → Untitled.Field3 — NOT NULL
  • Key (JOINKEYS_SEQ) — NUMBER(1) — Foreign key → Untitled.Key — NOT NULL
  • Field (POSITION) — NUMBER(5) — NOT NULL
  • Field (LENGTH) — NUMBER(5) — NOT NULL
  • Field (TYPE) — VARCHAR2(10) — NOT NULL

Untitled (OFM_UTILITY_SORT_JOINKEYS)

  • Key (JOINKEYS_SEQ) — NUMBER(1) — Primary key — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → OFM_UTILITY_SORT_COMMAND.Field3 — NOT NULL
  • Field (FILE) — VARCHAR2(2)
  • Field (F1) — VARCHAR2(8)
  • Field (F2) — VARCHAR2(8)
  • Field (SORTED) — NUMBER(1) — NOT NULL
  • Field (NOSEQCK) — NUMBER(1) — NOT NULL
  • Field (TYPE) — VARCHAR2(1) — NOT NULL
  • Field (STOPAFT) — NUMBER(5) — NOT NULL
  • Field (TASKID) — NUMBER(5) — NOT NULL

Untitled (OFM_UTILITY_SORT_SUM)

  • Key (FIELD_SEQ) — NUMBER(20) — Primary key — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → OFM_UTILITY_SORT_COMMAND.Field3 — NOT NULL
  • Field (POSITION) — NUMBER(5)
  • Field (LENGTH) — NUMBER(5)
  • Field (TYPE) — VARCHAR2(10)
  • Field (NONE) — NUMBER(1)
  • Field (XSUM) — NUMBER(1)

Untitled (OFM_UTILITY_SORT_MODS)

  • Field (MOD_SEQ) — NUMBER(2) — Primary key — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → OFM_UTILITY_SORT_COMMAND.Field3 — NOT NULL
  • Field (EXIT_CODE) — NUMBER(2) — NOT NULL
  • Field (FUNC_NAME) — VARCHAR2(256) — NOT NULL
  • Field (LIB_PATH) — VARCHAR2(512) — NOT NULL
  • Field (LIB_TYPE) — VARCHAR2(8) — NOT NULL

Untitled (OFM_UTILITY_SORT_REFORMAT_FINDREP)

  • Field (FINDREP_SEQ) — NUMBER(20) — Primary key — NOT NULL
  • Field (IFTHEN_ID) — NUMBER(20) — Foreign key → Untitled.Field — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → Untitled.Field3 — NOT NULL
  • Field (STARTPOS) — NUMBER(5) — NOT NULL
  • Field (ENDPOS) — NUMBER(5) — NOT NULL
  • Field (DO) — NUMBER(4) — NOT NULL
  • Field (MAXLEN) — NUMBER(5) — NOT NULL
  • Field (OVERRUN) — VARCHAR2(5) — NOT NULL
  • Field (SHIFT) — VARCHAR2(3) — NOT NULL

Untitled (OFM_UTLITY_SORT_REFORMAT_BUILD_OVERLAY)

  • Field (IFTHEN_ID) — NUMBER(20) — Foreign key → Untitled.Field — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → Untitled.Field3 — NOT NULL
  • Field (BUILD_OVERLAY_TYPE) — NUMBER(1) — NOT NULL

Untitled (OFM_UTLITY_SORT_REFORMAT_PARSE_START_END)

  • Field (START_END_SEQ) — NUMBER(20) — Primary key — NOT NULL
  • Field (PARSE_SEQ) — NUMBER(20) — Foreign key → Untitled.Field — NOT NULL
  • Field (IFTHEN_ID) — NUMBER(20) — Foreign key → Untitled.Field — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → Untitled.Field3 — NOT NULL
  • Key (START_END_TYPE) — NUMBER(1) — NOT NULL
  • Field (VALUE) — VARCHAR2(256) — NOT NULL

Untitled (OFM_UTLITY_SORT_REFORMAT_PARSE)

  • Field (PARSE_SEQ) — NUMBER(20) — Primary key — NOT NULL
  • Field (IFTHEN_ID) — NUMBER(20) — Foreign key → Untitled.Field — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → Untitled.Field3 — NOT NULL
  • Field (LABEL) — NUMBER(3) — NOT NULL
  • Field (FIXLEN) — NUMBER(5) — NOT NULL
  • Field (ABSPOS) — NUMBER(5) — NOT NULL
  • Field (ADDPOS) — NUMBER(5) — NOT NULL
  • Field (SUBPOS) — NUMBER(5) — NOT NULL
  • Field (PAIR) — VARCHAR2(5)
  • Field (REPEAT) — NUMBER(4)

Untitled (OFM_UTILITY_SORT_REFORMAT_IFTHEN_GROUP_BEGIN_END)

  • Field (BEGIN_END_SEQ) — NUMBER(20) — Primary key — NOT NULL
  • Field (GROUP_ID) — NUMBER(20) — Foreign key → Untitled.Field — NOT NULL
  • Field (IFTHEN_ID) — NUMBER(20) — Foreign key → Untitled.Field — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → Untitled.Field3 — NOT NULL
  • Field (BEGIN_END_TYPE) — NUMBER(1) — NOT NULL
  • Key (LOGEXP_ID) — NUMBER(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (OFM_UTILITY_SORT_REFORMAT_IFTHEN_GROUP)

  • Field (GROUP_ID) — NUMBER(20) — Primary key — NOT NULL
  • Field (IFTHEN_ID) — NUMBER(20) — Foreign key → Untitled.Field — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → Untitled.Field3 — NOT NULL
  • Field2 (KEYBEGIN_POSITION) — NUMBER(5)
  • Field3 (KEYBEGIN_LENGTH) — NUMBER(5)

Untitled (OFM_UTILITY_SORT_REFORMAT_IFTHEN)

  • Field (IFTHEN_ID) — NUMBER(20) — Primary key — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → OFM_UTILITY_SORT_COMMAND.Field3 — NOT NULL
  • Field (WHEN_TYPE) — NUMBER(3) — NOT NULL
  • Key (LOGEXP_ID) — NUMBER(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (OFM_UTILITY_SORT_SORT_MERGE_FIELD)

  • Field (FIELD_SEQ) — NUMBER(20) — Primary key — NOT NULL
  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → OFM_UTILITY_SORT_COMMAND.Field3 — NOT NULL
  • Field (COMMAND_TYPE) — VARCHAR2(5) — NOT NULL
  • Field2 (POSITION) — NUMBER(5) — NOT NULL
  • Field3 (LENGTH) — NUMBER(5) — NOT NULL
  • Field (TYPE) — VARCHAR2(10) — NOT NULL
  • Field (ORDER) — VARCHAR2(5) — NOT NULL

Untitled (OFM_UTILITY_SORT_LOGICAL_EXPRESSION)

  • Key (LOGEXP_ID) — NUMBER(20) — Primary key — NOT NULL
  • Field (LOGEXP_SEQ) — NUMBER(20) — Primary key — NOT NULL
  • Field2 (LEFT_POSITION) — NUMBER(5) — NOT NULL
  • Field3 (LEFT_LENGTH) — NUMBER(5) — NOT NULL
  • Field4 (LEFT_FORMAT) — VARCHAR2(10)
  • Field (COMPARE) — VARCHAR2(10) — NOT NULL
  • Field5 (RIGHT_TYPE) — NUMBER(3) — NOT NULL
  • Field6 (RIGHT_POSITION) — NUMBER(5)
  • Field (RIGHT_LENGTH) — NUMBER(5)
  • Field2 (RIGHT_FORMAT) — NUMBER(5)
  • Field3 (CONSTANT) — VARCHAR2(256)
  • Field (AND_OR) — VARCHAR2(3)

Untitled (OFM_UTILITY_SORT_FILTER_COND)

  • Field3 (COMMAND_ID) — NUMBER(20) — Foreign key → OFM_UTILITY_SORT_COMMAND.Field3 — NOT NULL
  • Field (FILTER_TYPE) — VARCHAR2(10) — NOT NULL
  • Field2 (COND) — VARCHAR2(10) — NOT NULL
  • Key (LOGEXP_ID) — NUMBER(20) — Foreign key → Untitled.Key — NOT NULL
  • Field4 (FORMAT) — VARCHAR2(10)