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)