ZCH_DATA_MGMT_BATCHES

Details

Schema: FUSION
Object owner: ZCH
Object type: VIEW

Columns

Name
DATA_MGMT_BATCH_ID BATCH_NUMBER BATCH_STATUS_CODE PROCESS_OPTION_CODE OBJ_NAME OBJ_DEF ASSIGNED_USER_ID BATCH_TYPE REQUEST_ID TOTAL_RECORDS_PROCESSED TOTAL_RECORDS_ERROR BATCH_START_TIME BATCH_END_TIME PROCESS_DURATION PROCESS_DURATION_UOM PROCESS_MODE REQUESTED_USER_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER REPEAT_FLAG PARENT_BATCH_ID CONFIG_CODE DQ_REQUEST_ID MATCH_MODE BATCH_NAME DESCRIPTION MATCH_THRESHOLD MATCH_CLUSTER_LEVEL MERGE_THRESHOLD LINK_THRESHOLD SEND_NOTIFICATION CLNS_MIN_VERIF_LEVEL CLNS_MIN_VERIF_SCORE CLNS_DEFAULT_COUNTRY_CODE CLNS_OUTPUT_CASE CLNS_PARTIAL_VERIF_ALLOWED CLNS_AMBIGUOUS_ADDR_ALLOWED CLNS_RETURN_NATIVE_SCRIPT OBJ_FILTER_EXPR

Name

DATA_MGMT_BATCH_ID

BATCH_NUMBER

BATCH_STATUS_CODE

PROCESS_OPTION_CODE

OBJ_NAME

OBJ_DEF

ASSIGNED_USER_ID

BATCH_TYPE

REQUEST_ID

TOTAL_RECORDS_PROCESSED

TOTAL_RECORDS_ERROR

BATCH_START_TIME

BATCH_END_TIME

PROCESS_DURATION

PROCESS_DURATION_UOM

PROCESS_MODE

REQUESTED_USER_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

REPEAT_FLAG

PARENT_BATCH_ID

CONFIG_CODE

DQ_REQUEST_ID

MATCH_MODE

BATCH_NAME

DESCRIPTION

MATCH_THRESHOLD

MATCH_CLUSTER_LEVEL

MERGE_THRESHOLD

LINK_THRESHOLD

SEND_NOTIFICATION

CLNS_MIN_VERIF_LEVEL

CLNS_MIN_VERIF_SCORE

CLNS_DEFAULT_COUNTRY_CODE

CLNS_OUTPUT_CASE

CLNS_PARTIAL_VERIF_ALLOWED

CLNS_AMBIGUOUS_ADDR_ALLOWED

CLNS_RETURN_NATIVE_SCRIPT

OBJ_FILTER_EXPR

Query

SQL_Statement
SELECT B.DATA_MGMT_BATCH_ID DATA_MGMT_BATCH_ID, B.BATCH_NUMBER BATCH_NUMBER, B.BATCH_STATUS_CODE BATCH_STATUS_CODE, B.PROCESS_OPTION_CODE PROCESS_OPTION_CODE, B.OBJ_NAME OBJ_NAME, B.OBJ_DEF OBJ_DEF, B.ASSIGNED_USER_ID ASSIGNED_USER_ID, B.BATCH_TYPE BATCH_TYPE, B.REQUEST_ID REQUEST_ID, B.TOTAL_RECORDS_PROCESSED, B.TOTAL_RECORDS_ERROR, B.BATCH_START_TIME, B.BATCH_END_TIME, B.PROCESS_DURATION, B.PROCESS_DURATION_UOM, B.PROCESS_MODE, B.REQUESTED_USER_ID REQUESTED_USER_ID, B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.REPEAT_FLAG REPEAT_FLAG, B.PARENT_BATCH_ID PARENT_BATCH_ID, B.CONFIG_CODE CONFIG_CODE, B.DQ_REQUEST_ID DQ_REQUEST_ID, B.MATCH_MODE MATCH_MODE, TL.BATCH_NAME BATCH_NAME, TL.DESCRIPTION DESCRIPTION, B.MATCH_THRESHOLD MATCH_THRESHOLD, B.MATCH_CLUSTER_LEVEL MATCH_CLUSTER_LEVEL, B.MERGE_THRESHOLD MERGE_THRESHOLD, B.LINK_THRESHOLD LINK_THRESHOLD, B.SEND_NOTIFICATION, B.CLNS_MIN_VERIF_LEVEL, B.CLNS_MIN_VERIF_SCORE, B.CLNS_DEFAULT_COUNTRY_CODE, B.CLNS_OUTPUT_CASE, B.CLNS_PARTIAL_VERIF_ALLOWED, B.CLNS_AMBIGUOUS_ADDR_ALLOWED, B.CLNS_RETURN_NATIVE_SCRIPT, B.OBJ_FILTER_EXPR FROM ZCH_DATA_MGMT_BATCHES_B B, ZCH_DATA_MGMT_BATCHES_TL TL WHERE B.DATA_MGMT_BATCH_ID = TL.DATA_MGMT_BATCH_ID AND TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.DATA_MGMT_BATCH_ID DATA_MGMT_BATCH_ID,

B.BATCH_NUMBER BATCH_NUMBER,

B.BATCH_STATUS_CODE BATCH_STATUS_CODE,

B.PROCESS_OPTION_CODE PROCESS_OPTION_CODE,

B.OBJ_NAME OBJ_NAME,

B.OBJ_DEF OBJ_DEF,

B.ASSIGNED_USER_ID ASSIGNED_USER_ID,

B.BATCH_TYPE BATCH_TYPE,

B.REQUEST_ID REQUEST_ID,

B.TOTAL_RECORDS_PROCESSED,

B.TOTAL_RECORDS_ERROR,

B.BATCH_START_TIME,

B.BATCH_END_TIME,

B.PROCESS_DURATION,

B.PROCESS_DURATION_UOM,

B.PROCESS_MODE,

B.REQUESTED_USER_ID REQUESTED_USER_ID,

B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE,

B.CREATION_DATE CREATION_DATE,

B.CREATED_BY CREATED_BY,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

B.REPEAT_FLAG REPEAT_FLAG,

B.PARENT_BATCH_ID PARENT_BATCH_ID,

B.CONFIG_CODE CONFIG_CODE,

B.DQ_REQUEST_ID DQ_REQUEST_ID,

B.MATCH_MODE MATCH_MODE,

TL.BATCH_NAME BATCH_NAME,

TL.DESCRIPTION DESCRIPTION,

B.MATCH_THRESHOLD MATCH_THRESHOLD,

B.MATCH_CLUSTER_LEVEL MATCH_CLUSTER_LEVEL,

B.MERGE_THRESHOLD MERGE_THRESHOLD,

B.LINK_THRESHOLD LINK_THRESHOLD,

B.SEND_NOTIFICATION,

B.CLNS_MIN_VERIF_LEVEL,

B.CLNS_MIN_VERIF_SCORE,

B.CLNS_DEFAULT_COUNTRY_CODE,

B.CLNS_OUTPUT_CASE,

B.CLNS_PARTIAL_VERIF_ALLOWED,

B.CLNS_AMBIGUOUS_ADDR_ALLOWED,

B.CLNS_RETURN_NATIVE_SCRIPT,

B.OBJ_FILTER_EXPR

FROM

ZCH_DATA_MGMT_BATCHES_B B,

ZCH_DATA_MGMT_BATCHES_TL TL

WHERE

B.DATA_MGMT_BATCH_ID = TL.DATA_MGMT_BATCH_ID AND TL.LANGUAGE = USERENV('LANG')