MetaData Lineage: EDS Fieldattribute Extract

Owned by Olga Galis (Deactivated)
Last updated: Jul 24, 2024 by Pamela Totas (Deactivated)
3 min read

 

EDS fieldatrribute extract is similar to EagleML extract. This extract contains meta information about Eagle fields like field type, name, database table, description and etc. This implementation links two metadata storages - MDC which is the Eagle metadata storage and Ontology, EDS metadata storage.

As a result, the data set is enriched with additional details. Core, custom and derived fields are supported. Prerequisite steps for the extract to work:

Metadata Lineage from Eagle MDC to Ontology - field attributes and element definitions

Set Up Temporary Table for fieldExpressions

Please use eagle_ml-2-0_default_cm_exec_eds stream to run EDS fieldattribute extract:

<EagleML xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="RunTaskRequest" eaglemlVersion="2-0" xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd" eaglemlType="RunTaskRequest"> <header> <messageId>E30X5FTN4N317JFF</messageId> <sentBy>MC2EJM</sentBy> <sendTo>http://www.eagleinvsys.com/eagle_default_ruleservice</sendTo> <creationTimestamp>2018-04-13T09:52:39.73-05:00</creationTimestamp> <expiryTimestamp/> <expiryLoadFlag/> </header> <taskIdentifier> <processingSequenceNumber/> <correlationId>EDS_FIELDATTRIBUTE_EXTRACT</correlationId> <businessTaskId>EDS_FIELDATTRIBUTE_EXTRACT</businessTaskId> <sequenceNumber/> </taskIdentifier> <taskTypeEnum>NEW</taskTypeEnum> <synchronousExecution>yes</synchronousExecution> <taskParameters> <taskParameter> <name>StreamName</name> <dataType>S</dataType> <value>eagle_default_ruleservice</value> </taskParameter> <taskParameter> <name>ServiceName</name> <value>EBS</value> </taskParameter> <taskParameter> <name>ServiceMethodName</name> <dataType>S</dataType> <value>extract</value> </taskParameter> <taskParameter> <name>ResourceName</name> <value>fieldattribute</value> </taskParameter> <taskParameter> <name>OutputFormat</name> <dataType>S</dataType> <value>EagleJSON</value> </taskParameter> <taskParameter> <name>SaveSQLQuery</name> <dataType>S</dataType> <value>Y</value> </taskParameter> </taskParameters> </EagleML>

EQL REST API is supported, for example: https://o171-e001-ww01.eagleinvsys.com/eagle/v2/eql

{     "ResourceName": "fieldattribute",     "ServiceName": "EBS",     "ServiceMethodName": "extract",     "savesqlquery": "Y" }

The following filters are supported:

  • fieldattributeid

  • fieldtype

  • fieldname

<taskParameter> <name>fieldattributeid</name> <dataType>S</dataType> <value>264</value> </taskParameter> <taskParameter> <name>fieldtype</name> <dataType>S</dataType> <value>fieldtype_VALUE</value> </taskParameter> <taskParameter> <name>fieldname</name> <dataType>S</dataType> <value>fieldname_value</value> </taskParameter>

 

  1. The processing rule for EDS fieldattribute extract was improved to support new element fieldAttributeOntologyDescription for all fields with direct or simple mapping.

<referenceTransaction> <header> <objectType>FieldAttribute</objectType> </header> <fieldAttribute> <calcType>di</calcType> <databaseName>cash</databaseName> <fieldAttributeDescription>i Local Currency</fieldAttributeDescription> <fieldAttributeId>138</fieldAttributeId> <fieldIndicator>cf</fieldIndicator> <fieldName>LOCAL_CURRENCY</fieldName> <tableName>CASH_ACTIVITY</tableName> <fieldIdentifier>I LOCAL CURRENCY</fieldIdentifier> <scope>2</scope> <readOnly>Y</readOnly> <fieldAttributeOntologyDescription>Local currency. Three-letter currency code.</fieldAttributeOntologyDescription> </fieldAttribute> </referenceTransaction>

This field will be part of the EDS extract by default. In order to create a mashup file the manual step is required. Described here

  1. A new logic was implemented for derived or calculated fields. Now all user defined expressions for the calculated fields will be part of the extract. Two additional elements are part of the extract:

fieldExpression element includes user friendly expression available in MDC
userData element contains RAW definition of the value stored in the database

New fields are included by default, but they can be excluded by setting RTR parameter includederivedattributes to N.

<referenceTransaction> <header> <objectType>FieldAttribute</objectType> </header> <fieldAttribute> <statField>Y</statField> <fieldAttributeDescription>DC for subtraction</fieldAttributeDescription> <fieldAttributeId>1429</fieldAttributeId> <fieldAttributeProcessId>1014</fieldAttributeProcessId> <fieldIndicator>DE</fieldIndicator> <fieldType>NUM</fieldType> <fieldFormat>2</fieldFormat> <fieldCategory>&lt;none&gt;</fieldCategory> <currencyProcess>NOT</currencyProcess> <fieldValueType>NOT</fieldValueType> <fieldIdentifier>DETAIL CAL FOR SUBTRACTION - SUPERUSERS</fieldIdentifier> <scope>2</scope> <readOnly>N</readOnly> <processDescription>Expression Calculator</processDescription> <processType>USERDEFINED</processType> <fieldExpression>H-PD-Market_Value_Income - H-PD-Local_Market_Value</fieldExpression> <userData>#`FP1014~#`FD1170~-~#`FD1155~</userData> </fieldAttribute> </referenceTransaction>

The initial configuration steps are required. Described here

This functionality is limited for the calculated fields below with field_attribute_process_id:

1010 Arithmetic Addition Calculator
1011 Arithmetic Subtraction Calculator
1012 Arithmetic Division Calculator
1013 Arithmetic Multiplication Calculator
1014 Expression Calculator
1015 Adjustments Calculator
1025 Trade Adjustment Calculator
1030 IRR Calculator
1031 Modified Dietz Calculator
1032 Dollar Value Added Calculator
1033 Average Invested Balance Calculator

Example extract is attached.

RDC Enrichments

Five additional fields are supported:

  • fieldAttributeReference

  • enrichmentRule

  • rdcValidation

  • rdcFieldGroup

  • rdcDataStrategy

 Additional logic was implemented to group values and use TEMP table for join. Grouped values are separated by ; symbol.

  • fieldAttributeReference  - field attributes which are used in calculations

Extract file:

  • enrichmentRule - the enrichment rule for the field

Extract file:

RDC

  • validation - list of used validations

Extract file:

Value in the cell:

First Compounding Date Cannot Be Greater than Maturity Date; First Compounding Date Cannot Be Greater than Termination Date; First Compounding Date Cannot Be Less than Dated Date; First Compounding Date Cannot Be Less than Effective Date

RDC

  • rdcFieldGroup - list of selected groups

Extract file:

RDC

Single value:

Multiple values:

  • rdcDataStrategy - list of applied data strtategies

Extract file:

Custom Mashup

In case you want to use custom file (CSV, JSON, etc.) to mashup it with fieldattributes extract.

  1. Create custom dataset definition for the file in the folder: estar\tpe\dynamic\metadata\core\datasets

For example:

{
"_id": "ea_mapping",
"dataframes": [
{
"id": "ea_mapping",
"type": "dftFile",
"group_name": "Ontology",
"description": "Ontology metadata",
"maxrows": 9999999,
"source_sink": {
"sink_type": "ssFileType",
"sink_params": {
"file_name": "/apps/eagle/estar/tpe/dynamic/metadata/core/ontology/templates/EADataMapping.csv",
"mode": "r"
},
"source_format_dialect": {
"lineterminator": "\n",
"delimiter": ";",
"headerlines": 1,
"headerat": 1,
"dialectname": "csv_char_strip"
}
},
"format": "csv",
"vocabulary": {
"LOB": "LOB",
"SUBJECT_AREA_DOMAIN": "SUBJECT_AREA_DOMAIN",
"SUB_DOMAIN": "SUB_DOMAIN",
"BUSINESS_NAME": "BUSINESS_NAME",
"BUSINESS_DESCRIPTION": "BUSINESS_DESCRIPTION",
"PHASE_1_NYLIM": "PHASE_1_NYLIM",
"REQUIRED_FOR_FUTURE_STATE": "REQUIRED_FOR_FUTURE_STATE",
"SOURCE_PLATFORM": "SOURCE_PLATFORM",
"SOURCE_TABLE": "SOURCE_TABLE",
"SOURCE_COLUMN_SOURCE_COLUMN_STAT": "SOURCE_COLUMN_SOURCE_COLUMN_STAT",
"SOURCE_COLUMN_GAAP": "SOURCE_COLUMN_GAAP",
"SOURCE_COLUMN_TAX": "SOURCE_COLUMN_TAX",
"FORMAT": "FORMAT",
"COMMENTS_DERIVATIONS_TRANSFORMATIONS_FOR_SOURCE": "COMMENTS_DERIVATIONS_TRANSFORMATIONS_FOR_SOURCE",
"EXTRACT_FIELD_EXTRACT_FIELD_STAT": "EXTRACT_FIELD_EXTRACT_FIELD_STAT",
"EXTRACT_FIELD_GAAP": "EXTRACT_FIELD_GAAP",
"EXTRACT_FIELDTAX": "EXTRACT_FIELDTAX",
"NEW_BUSINESS_NAME_IF_APPLICABLE": "NEW_BUSINESS_NAME_IF_APPLICABLE",
"SCHEMA": "SCHEMA",
"TABLE": "TABLE",
"COLUMN": "COLUMN",
"FORMAT": "FORMAT",
"ML_ELEMENT": "ML_ELEMENT",
"EAGLE_TAG_SETUP": "EAGLE_TAG_SETUP",
"SUBJECT_AREA_FOR_INTERNAL": "SUBJECT_AREA_FOR_INTERNAL",
"TARGET_FIELD_NAME_FOR_INTERNAL": "TARGET_FIELD_NAME_FOR_INTERNAL",
"DERIVATION_TRANSFORMATION_INTERNAL_INGESTION": "DERIVATION_TRANSFORMATION_INTERNAL_INGESTION",
"MANDATORY_FIELD": "MANDATORY_FIELD"
},
"unique_key": [
{
"field": "TABLE_COLUMN",
"expression": "|TABLE| + |COLUMN|"
}
],
"source_query_policy": {
"cache_mode": "none",
"method": "file",
"base_template": "",
"full": {
"filter_params": {
"filter_definitions": {}
}
},
"filter_params": {
"filter_definitions": {}
}
},
"cache_policy": {
"type": "aside",
"cache_provider": "cache-manager-file",
"storage_method": "keyvalue",
"compression_codec": "N",
"encryption_codec": "N",
"format_dialect": "mashup_csv_dialect",
"ttl_delta": 0,
"ttl_unique": 60
}
}
]
}

This file describe custom CSV file:

NOTE: pay attention on file path and adjust it correspondently.

  1. Place file for mashup to path specified in dataset definition:

For example in dataset definition, path is defined as:

"file_name": " /apps/eagle/estar/tpe/dynamic/metadata/core/ontology/templates/EADataMapping.csv",

  1. To make this works create custom processing rule in cache:

  • KEY: eagle.ebs.resource:O17_FIELDATTRIBUTE_2.0.57

  • VALUE:

{
"resource_version": "2.0.57",
"is_core": true,
"extract": {
"dataframe": {
"FIELDATTRIBUTE": {
"id": "fieldattribute",
"group_name": "Reference",
"description": "fieldattribute extract",
"maxrows": 99999999,
"source_sink": {
"sink_type": "ssDbType",
"sink_params": {}
},
"format": "dbcursor",
"unique_key": [
{
"field": "FIELD_ATTRIBUTE_ID",
"expression": "|FIELD_ATTRIBUTE_ID|"
}
],
"source_query_policy": {
"cache_mode": "none",
"filter_params": {
"filter_definitions": {
"fieldattributefilter": {
"filter_type": "cursor",
"description": "Field attribute logic for derived attributes",
"parameters": [
{
"name": "includederivedattributes"
}
],
"build_cursor_statement_method": "eagledb:fieldattribute"
},
"fieldattributeid": {
"filter_type": "bind",
"description": "field attribute id filter",
"parameters": [
{
"name": "fieldattributeid",
"type": "NUMBER",
"source_type_dialect": {
"precision": "38",
"scale": "0"
}
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.FIELD_ATTRIBUTE_ID @(:fieldattributeid)"
},
{
"sourceProvider": "eagledb://mssql",
"filter": "MASTERTABLE.FIELD_ATTRIBUTE_ID @(:fieldattributeid)"
}
]
},
"fieldname": {
"filter_type": "bind",
"description": "field name filter",
"parameters": [
{
"name": "fieldname",
"type": "CHAR",
"length": "30"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.FIELD_NAME @(:fieldname)"
},
{
"sourceProvider": "eagledb://mssql",
"filter": "MASTERTABLE.FIELD_NAME @(:fieldname)"
}
]
},
"fieldtype": {
"filter_type": "bind",
"description": "field type filter",
"parameters": [
{
"name": "fieldtype",
"type": "CHAR",
"length": "4"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.FIELD_TYPE @(:fieldtype)"
},
{
"sourceProvider": "eagledb://mssql",
"filter": "MASTERTABLE.FIELD_TYPE @(:fieldtype)"
}
]
},
"fromdate": {
"filter_type": "bind",
"description": "fromdate filter",
"parameters": [
{
"name": "fromdate",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.UPDATE_DATE >= :fromdate"
},
{
"sourceProvider": "eagledb://mssql",
"filter": "MASTERTABLE.UPDATE_DATE >= :fromdate"
}
]
},
"todate": {
"filter_type": "bind",
"description": "todate filter",
"parameters": [
{
"name": "todate",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.UPDATE_DATE <= :todate"
},
{
"sourceProvider": "eagledb://mssql",
"filter": "MASTERTABLE.UPDATE_DATE <= :todate"
}
]
},
"dbproviderfilter": {
"filter_type": "cursor",
"description": "db provider filter",
"parameters": [
{
"name": "dbprovider"
}
],
"build_cursor_statement_method": "eagledb:dbproviderfilter"
}
}
},
"unique": {
"template": "json-def://FIELDATTRIBUTE"
},
"delta": {
"template": "json-def://FIELDATTRIBUTE",
"mandatory_filters": [
"fromdate",
"todate"
]
},
"full": {
"template": "json-def://FIELDATTRIBUTE"
},
"base_template": "json-def://FIELDATTRIBUTE",
"query_template": {
"FIELDATTRIBUTE": {
"query_id": "FIELDATTRIBUTE",
"key": "FIELD_ATTRIBUTE_ID",
"notNullableColumns": "FIELD_ATTRIBUTE_ID",
"resource": "eagledb:RULES.FIELD_ATTRIBUTES",
"is_main_table": true,
"tables": [
{
"mashupMode": "LEFT",
"notNullableColumns": "FIELD_ATTRIBUTE_ID",
"resource": "eagledb:RULES.FIELD_ATTRIBUTE_DETAIL",
"owner": "RULES",
"table_name": "FIELD_ATTRIBUTE_DETAIL",
"column_prefix": "1"
},
{
"expression": "MASTERTABLE.FIELD_ATTRIBUTE_PROCESS_ID = FIELD_ATTRIBUTE_PROCESS.FIELD_ATTRIBUTE_PROCESS_ID ",
"mashupMode": "LEFT",
"notNullableColumns": "FIELD_ATTRIBUTE_PROCESS_ID",
"resource": "eagledb:RULES.FIELD_ATTRIBUTE_PROCESS",
"owner": "RULES",
"table_name": "FIELD_ATTRIBUTE_PROCESS",
"column_prefix": "2_"
},
{
"expression": "MASTERTABLE.FIELD_ATTRIBUTE_ID = FIELD_PROCESS_DEFINITION.FIELD_ATTRIBUTE_ID and FIELD_PROCESS_DEFINITION.USER_DATA is not NULL",
"mashupMode": "LEFT",
"notNullableColumns": "FIELD_ATTRIBUTE_ID, SEQ_NO",
"resource": "eagledb:RULES.FIELD_PROCESS_DEFINITION",
"owner": "RULES",
"table_name": "FIELD_PROCESS_DEFINITION",
"column_prefix": "3_"
},
{
"mashupMode": "LEFT",
"notNullableColumns": "FIELD_ATTRIBUTE_ID",
"resource": "eagledb:ENGREF.EAGLE_MDC_CALC_FIELDS_V2",
"owner": "ENGREF",
"table_name": "EAGLE_MDC_CALC_FIELDS_V2",
"column_prefix": "4_"
},
{
"mashupMode": "LEFT",
"notNullableColumns": "FIELD_ATTRIBUTE_ID",
"resource": "eagledb:ENGREF.EAGLE_RDC_CALC_FIELDS_V2",
"owner": "ENGREF",
"table_name": "EAGLE_RDC_CALC_FIELDS_V2",
"column_prefix": "5_"
}
]
}
}
},
"cache_policy": {
"type": "aside",
"cache_provider": "cache-manager-file",
"storage_method": "keyvalue",
"compression_codec": "gzip",
"encryption_codec": "N",
"format_dialect": "mashup_csv_dialect",
"ttl_delta": 0,
"ttl_unique": 60
}
}
},
"interface": {
"FIELDATTRIBUTE": {
"_id": "fieldattribute",
"group_name": "Reference",
"description": "fieldattribute extract",
"format": "eaglemlformat",
"emlObjectType": "FieldAttribute",
"emlTxnType": "referenceTransaction",
"dataset": "fieldattribute",
"dataframe": "fieldattribute",
"register_for_mashups": [
{
"_alias": "ontology_metadata",
"dataset": "ontology_metadata",
"dataframe": "ontology_metadata",
"keyexpr": "|FIELD_PATH|",
"columns": ""
},
{
"_alias": "ea_mapping",
"dataset": "ea_mapping",
"dataframe": "ea_mapping",
"keyexpr": "|TABLE| + '.' + |COLUMN|",
"columns": ""
}
],
"mashups": {
"ontology_metadata": "select first FIELD_DEFINITION from ontology_metadata where (|mainds.TABLE_NAME| + '.' + |mainds.FIELD_NAME|)=(|FIELD_PATH|)",
"ea_mapping": "select first LOB,SUBJECT_AREA_DOMAIN,SUB_DOMAIN,BUSINESS_NAME,BUSINESS_DESCRIPTION,PHASE_1_NYLIM,REQUIRED_FOR_FUTURE_STATE,SOURCE_PLATFORM,SOURCE_TABLE,SOURCE_COLUMN_SOURCE_COLUMN_STAT,SOURCE_COLUMN_GAAP,SOURCE_COLUMN_TAX,FORMAT,COMMENTS_DERIVATIONS_TRANSFORMATIONS_FOR_SOURCE,EXTRACT_FIELD_EXTRACT_FIELD_STAT,EXTRACT_FIELD_GAAP,EXTRACT_FIELD-TAX,NEW_BUSINESS_NAME_IF_APPLICABLE,SCHEMA,TABLE,COLUMN,FORMAT,ML_ELEMENT,EAGLE_TAG_SETUP,SUBJECT_AREA_FOR_INTERNAL,TARGET_FIELD_NAME_FOR_INTERNAL,DERIVATION_TRANSFORMATION_INTERNAL_INGESTION,MANDATORY_FIELD from ea_mapping where (|mainds.TABLE_NAME| + '.' + |mainds.FIELD_NAME|)=(|TABLE| + '.' + |COLUMN|)"
}
},
"taxonomy": [
[
"|STAT_FIELD|",
"",
false,
null,
"",
"statField"
],
[
"|CALC_TYPE|",
"",
false,
null,
"",
"calcType"
],
[
"|DATABASE_NAME|",
"",
false,
null,
"",
"databaseName"
],
[
"|FIELD_ATTRIBUTE_DESCRIPTION|",
"",
false,
null,
"",
"fieldAttributeDescription"
],
[
"|FIELD_ATTRIBUTE_ID|",
"number",
false,
null,
"",
"fieldAttributeId"
],
[
"|FIELD_ATTRIBUTE_PROCESS_ID|",
"number",
false,
null,
"",
"fieldAttributeProcessId"
],
[
"|FIELD_INDICATOR|",
"",
false,
null,
"",
"fieldIndicator"
],
[
"|FIELD_NAME|",
"",
false,
null,
"",
"fieldName"
],
[
"|FIELD_TYPE|",
"",
false,
null,
"",
"fieldType"
],
[
"|TABLE_NAME|",
"",
false,
null,
"",
"tableName"
],
[
"|REF_CODE_ID|",
"number",
false,
null,
"",
"refCodeId"
],
[
"|FIELD_FORMAT|",
"",
false,
null,
"",
"fieldFormat"
],
[
"|COMMENTS|",
"",
false,
null,
"",
"comments"
],
[
"|NUMERATOR_ID|",
"number",
false,
null,
"",
"numeratorId"
],
[
"|DENOMINTOR_ID|",
"number",
false,
null,
"",
"denomintorId"
],
[
"|NUMERATOR_ID2|",
"number",
false,
null,
"",
"numeratorId2"
],
[
"|FIELD_CATEGORY|",
"",
false,
null,
"",
"fieldCategory"
],
[
"|CURRENCY_PROCESS|",
"",
false,
null,
"",
"currencyProcess"
],
[
"|FIELD_VALUE_TYPE|",
"",
false,
null,
"",
"fieldValueType"
],
[
"|FIELD_IDENTIFIER|",
"",
false,
null,
"",
"fieldIdentifier"
],
[
"|SCOPE|",
"number",
false,
null,
"",
"scope"
],
[
"|READ_ONLY|",
"",
false,
null,
"",
"readOnly"
],
[
"|PROCESS_DESCRIPTION|",
"",
false,
null,
"",
"processDescription"
],
[
"|PROCESS_TYPE|",
"",
false,
null,
"",
"processType"
],
[
"|PARAMETER_LIST|",
"",
false,
null,
"",
"parameterList"
],
[
"|DATABASE_NAME_1|",
"",
false,
null,
"",
"processDatabaseName"
],
[
"|STORED_PROCEDURE_NAME|",
"",
false,
null,
"",
"processStoredProcedureName"
],
[
"|ontology_metadata.FIELD_DEFINITION|",
"",
false,
null,
"",
"fieldAttributeOntologyDescription"
],
[
"|FIELD_ATTRIBUTE_FORMULA|",
"",
false,
null,
"",
"fieldExpression"
],
[
"|USER_DATA|",
"",
false,
null,
"",
"userData"
],
[
"|FIELD_ATTRIBUTE_REF_LIST|",
"",
false,
null,
"",
"fieldAttributeReference"
],
[
"|ENRICHMENT_RULE|",
"",
false,
null,
"",
"enrichmentRule"
],
[
"|VALIDATION_LIST|",
"",
false,
null,
"",
"rdcValidation"
],
[
"|GROUP_LIST|",
"",
false,
null,
"",
"rdcFieldGroup"
],
[
"|DATA_STRATEGY_LIST|",
"",
false,
null,
"",
"rdcDataStrategy"
],
[
"|ea_mapping.LOB|",
"",
false,
null,
"",
"ea_mapping.LOB"
],
[
"|ea_mapping.SUBJECT_AREA_DOMAIN|",
"",
false,
null,
"",
"ea_mapping.SUBJECT_AREA_DOMAIN"
],
[
"|ea_mapping.SUB_DOMAIN|",
"",
false,
null,
"",
"ea_mapping.SUB_DOMAIN"
],
[
"|ea_mapping.BUSINESS_NAME|",
"",
false,
null,
"",
"ea_mapping.BUSINESS_NAME"
],
[
"|ea_mapping.BUSINESS_DESCRIPTION|",
"",
false,
null,
"",
"ea_mapping.BUSINESS_DESCRIPTION"
],
[
"|ea_mapping.PHASE_1_NYLIM|",
"",
false,
null,
"",
"ea_mapping.PHASE_1_NYLIM"
],
[
"|ea_mapping.REQUIRED_FOR_FUTURE_STATE|",
"",
false,
null,
"",
"ea_mapping.REQUIRED_FOR_FUTURE_STATE"
],
[
"|ea_mapping.SOURCE_PLATFORM|",
"",
false,
null,
"",
"ea_mapping.SOURCE_PLATFORM"
],
[
"|ea_mapping.SOURCE_TABLE|",
"",
false,
null,
"",
"ea_mapping.SOURCE_TABLE"
],
[
"|ea_mapping.SOURCE_COLUMN_SOURCE_COLUMN_STAT|",
"",
false,
null,
"",
"ea_mapping.SOURCE_COLUMN_SOURCE_COLUMN_STAT"
],
[
"|ea_mapping.SOURCE_COLUMN_GAAP|",
"",
false,
null,
"",
"ea_mapping.SOURCE_COLUMN_GAAP"
],
[
"|ea_mapping.SOURCE_COLUMN_TAX|",
"",
false,
null,
"",
"ea_mapping.SOURCE_COLUMN_TAX"
],
[
"|ea_mapping.FORMAT|",
"",
false,
null,
"",
"ea_mapping.FORMAT"
],
[
"|ea_mapping.COMMENTS_DERIVATIONS_TRANSFORMATIONS_FOR_SOURCE|",
"",
false,
null,
"",
"ea_mapping.COMMENTS_DERIVATIONS_TRANSFORMATIONS_FOR_SOURCE"
],
[
"|ea_mapping.EXTRACT_FIELD_EXTRACT_FIELD_STAT|",
"",
false,
null,
"",
"ea_mapping.EXTRACT_FIELD_EXTRACT_FIELD_STAT"
],
[
"|ea_mapping.EXTRACT_FIELD_GAAP|",
"",
false,
null,
"",
"ea_mapping.EXTRACT_FIELD_GAAP"
],
[
"|ea_mapping.EXTRACT_FIELD-TAX|",
"",
false,
null,
"",
"ea_mapping.EXTRACT_FIELD-TAX"
],
[
"|ea_mapping.NEW_BUSINESS_NAME_IF_APPLICABLE|",
"",
false,
null,
"",
"ea_mapping.NEW_BUSINESS_NAME_IF_APPLICABLE"
],
[
"|ea_mapping.SCHEMA|",
"",
false,
null,
"",
"ea_mapping.SCHEMA"
],
[
"|ea_mapping.TABLE|",
"",
false,
null,
"",
"ea_mapping.TABLE"
],
[
"|ea_mapping.COLUMN|",
"",
false,
null,
"",
"ea_mapping.COLUMN"
],
[
"|ea_mapping.FORMAT|",
"",
false,
null,
"",
"ea_mapping.FORMAT"
],
[
"|ea_mapping.ML_ELEMENT|",
"",
false,
null,
"",
"ea_mapping.ML_ELEMENT"
],
[
"|ea_mapping.EAGLE_TAG_SETUP|",
"",
false,
null,
"",
"ea_mapping.EAGLE_TAG_SETUP"
],
[
"|ea_mapping.SUBJECT_AREA_FOR_INTERNAL|",
"",
false,
null,
"",
"ea_mapping.SUBJECT_AREA_FOR_INTERNAL"
],
[
"|ea_mapping.TARGET_FIELD_NAME_FOR_INTERNAL|",
"",
false,
null,
"",
"ea_mapping.TARGET_FIELD_NAME_FOR_INTERNAL"
],
[
"|ea_mapping.DERIVATION_TRANSFORMATION_INTERNAL_INGESTION|",
"",
false,
null,
"",
"ea_mapping.DERIVATION_TRANSFORMATION_INTERNAL_INGESTION"
],
[
"|ea_mapping.MANDATORY_FIELD|",
"",
false,
null,
"",
"ea_mapping.MANDATORY_FIELD"
]
]
},
"query_definition": {
"FIELDATTRIBUTE": {
"_version": "589",
"_id": null,
"master_table": {
"needs_schema_suffix": true,
"table_logical_schema": "RULES",
"owner": "RULESDBO",
"table_name": "FIELD_ATTRIBUTES",
"table_alias": "MASTERTABLE",
"column_prefix": null,
"select_columns": null,
"column_aliases": null,
"mashup_mode": "",
"exclude_columns": null,
"expression": "MASTERTABLE. = MASTERTABLE.",
"old_syntax_expression": "MASTERTABLE. = MASTERTABLE. (+)",
"columns": [
{
"column_name": "CALC_TYPE",
"alias": "CALC_TYPE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.CALC_TYPE) CALC_TYPE",
"source": "RULES.FIELD_ATTRIBUTES.CALC_TYPE",
"source_provider": null
},
{
"column_name": "COMMENTS",
"alias": "COMMENTS",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.COMMENTS) COMMENTS",
"source": "RULES.FIELD_ATTRIBUTES.COMMENTS",
"source_provider": null
},
{
"column_name": "DATABASE_NAME",
"alias": "DATABASE_NAME",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.DATABASE_NAME) DATABASE_NAME",
"source": "RULES.FIELD_ATTRIBUTES.DATABASE_NAME",
"source_provider": null
},
{
"column_name": "DENOMINTOR_ID",
"alias": "DENOMINTOR_ID",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.DENOMINTOR_ID) DENOMINTOR_ID",
"source": "RULES.FIELD_ATTRIBUTES.DENOMINTOR_ID",
"source_provider": null
},
{
"column_name": "FIELD_ATTRIBUTE_DESCRIPTION",
"alias": "FIELD_ATTRIBUTE_DESCRIPTION",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.FIELD_ATTRIBUTE_DESCRIPTION) FIELD_ATTRIBUTE_DESCRIPTION",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_ATTRIBUTE_DESCRIPTION",
"source_provider": null
},
{
"column_name": "FIELD_ATTRIBUTE_ID",
"alias": "FIELD_ATTRIBUTE_ID",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.FIELD_ATTRIBUTE_ID) FIELD_ATTRIBUTE_ID",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_ATTRIBUTE_ID",
"source_provider": null
},
{
"column_name": "FIELD_ATTRIBUTE_PROCESS_ID",
"alias": "FIELD_ATTRIBUTE_PROCESS_ID",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.FIELD_ATTRIBUTE_PROCESS_ID) FIELD_ATTRIBUTE_PROCESS_ID",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_ATTRIBUTE_PROCESS_ID",
"source_provider": null
},
{
"column_name": "FIELD_FORMAT",
"alias": "FIELD_FORMAT",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.FIELD_FORMAT) FIELD_FORMAT",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_FORMAT",
"source_provider": null
},
{
"column_name": "FIELD_INDICATOR",
"alias": "FIELD_INDICATOR",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.FIELD_INDICATOR) FIELD_INDICATOR",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_INDICATOR",
"source_provider": null
},
{
"column_name": "FIELD_NAME",
"alias": "FIELD_NAME",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.FIELD_NAME) FIELD_NAME",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_NAME",
"source_provider": null
},
{
"column_name": "FIELD_TYPE",
"alias": "FIELD_TYPE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.FIELD_TYPE) FIELD_TYPE",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_TYPE",
"source_provider": null
},
{
"column_name": "NUMERATOR_ID",
"alias": "NUMERATOR_ID",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.NUMERATOR_ID) NUMERATOR_ID",
"source": "RULES.FIELD_ATTRIBUTES.NUMERATOR_ID",
"source_provider": null
},
{
"column_name": "NUMERATOR_ID2",
"alias": "NUMERATOR_ID2",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.NUMERATOR_ID2) NUMERATOR_ID2",
"source": "RULES.FIELD_ATTRIBUTES.NUMERATOR_ID2",
"source_provider": null
},
{
"column_name": "REF_CODE_ID",
"alias": "REF_CODE_ID",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.REF_CODE_ID) REF_CODE_ID",
"source": "RULES.FIELD_ATTRIBUTES.REF_CODE_ID",
"source_provider": null
},
{
"column_name": "SRC_INTFC_INST",
"alias": "SRC_INTFC_INST",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.SRC_INTFC_INST) SRC_INTFC_INST",
"source": "RULES.FIELD_ATTRIBUTES.SRC_INTFC_INST",
"source_provider": null
},
{
"column_name": "STAT_FIELD",
"alias": "STAT_FIELD",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.STAT_FIELD) STAT_FIELD",
"source": "RULES.FIELD_ATTRIBUTES.STAT_FIELD",
"source_provider": null
},
{
"column_name": "TABLE_NAME",
"alias": "TABLE_NAME",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.TABLE_NAME) TABLE_NAME",
"source": "RULES.FIELD_ATTRIBUTES.TABLE_NAME",
"source_provider": null
},
{
"column_name": "UPDATE_DATE",
"alias": "UPDATE_DATE",
"data_type": "DATETIME",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "CASE WHEN MASTERTABLE.UPDATE_DATE IS NOT NULL THEN TO_CHAR(CAST(MASTERTABLE.UPDATE_DATE AS TIMESTAMP WITH TIME ZONE), 'YYYY-MM-DD') || 'T' || TO_CHAR(CAST(MASTERTABLE.UPDATE_DATE AS TIMESTAMP WITH TIME ZONE), 'HH24:MI:SSTZH:TZM') ELSE NULL END UPDATE_DATE",
"source": "RULES.FIELD_ATTRIBUTES.UPDATE_DATE",
"source_provider": null
},
{
"column_name": "UPDATE_SOURCE",
"alias": "UPDATE_SOURCE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.UPDATE_SOURCE) UPDATE_SOURCE",
"source": "RULES.FIELD_ATTRIBUTES.UPDATE_SOURCE",
"source_provider": null
}
],
"fields": [
"RTRIM(MASTERTABLE.CALC_TYPE) CALC_TYPE",
"RTRIM(MASTERTABLE.COMMENTS) COMMENTS",
"RTRIM(MASTERTABLE.DATABASE_NAME) DATABASE_NAME",
"TO_CHAR(MASTERTABLE.DENOMINTOR_ID) DENOMINTOR_ID",
"RTRIM(MASTERTABLE.FIELD_ATTRIBUTE_DESCRIPTION) FIELD_ATTRIBUTE_DESCRIPTION",
"TO_CHAR(MASTERTABLE.FIELD_ATTRIBUTE_ID) FIELD_ATTRIBUTE_ID",
"TO_CHAR(MASTERTABLE.FIELD_ATTRIBUTE_PROCESS_ID) FIELD_ATTRIBUTE_PROCESS_ID",
"RTRIM(MASTERTABLE.FIELD_FORMAT) FIELD_FORMAT",
"RTRIM(MASTERTABLE.FIELD_INDICATOR) FIELD_INDICATOR",
"RTRIM(MASTERTABLE.FIELD_NAME) FIELD_NAME",
"RTRIM(MASTERTABLE.FIELD_TYPE) FIELD_TYPE",
"TO_CHAR(MASTERTABLE.NUMERATOR_ID) NUMERATOR_ID",
"TO_CHAR(MASTERTABLE.NUMERATOR_ID2) NUMERATOR_ID2",
"TO_CHAR(MASTERTABLE.REF_CODE_ID) REF_CODE_ID",
"TO_CHAR(MASTERTABLE.SRC_INTFC_INST) SRC_INTFC_INST",
"RTRIM(MASTERTABLE.STAT_FIELD) STAT_FIELD",
"RTRIM(MASTERTABLE.TABLE_NAME) TABLE_NAME",
"CASE WHEN MASTERTABLE.UPDATE_DATE IS NOT NULL THEN TO_CHAR(CAST(MASTERTABLE.UPDATE_DATE AS TIMESTAMP WITH TIME ZONE), 'YYYY-MM-DD') || 'T' || TO_CHAR(CAST(MASTERTABLE.UPDATE_DATE AS TIMESTAMP WITH TIME ZONE), 'HH24:MI:SSTZH:TZM') ELSE NULL END UPDATE_DATE",
"RTRIM(MASTERTABLE.UPDATE_SOURCE) UPDATE_SOURCE"
],
"partition_number": 1,
"cluster_key": null
},
"tables": [
{
"needs_schema_suffix": true,
"table_logical_schema": "RULES",
"owner": "RULESDBO",
"table_name": "FIELD_ATTRIBUTE_DETAIL",
"table_alias": "FIELD_ATTRIBUTE_DETAIL",
"column_prefix": null,
"select_columns": null,
"column_aliases": null,
"mashup_mode": "LEFT",
"exclude_columns": null,
"expression": "MASTERTABLE.FIELD_ATTRIBUTE_ID = FIELD_ATTRIBUTE_DETAIL.FIELD_ATTRIBUTE_ID",
"old_syntax_expression": "MASTERTABLE.FIELD_ATTRIBUTE_ID = FIELD_ATTRIBUTE_DETAIL.FIELD_ATTRIBUTE_ID (+)",
"columns": [
{
"column_name": "ATTRIB_USER_DATA",
"alias": "ATTRIB_USER_DATA",
"data_type": "CLOB",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "FIELD_ATTRIBUTE_DETAIL.ATTRIB_USER_DATA ATTRIB_USER_DATA",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.ATTRIB_USER_DATA",
"source_provider": null
},
{
"column_name": "CURRENCY_PROCESS",
"alias": "CURRENCY_PROCESS",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_DETAIL.CURRENCY_PROCESS) CURRENCY_PROCESS",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.CURRENCY_PROCESS",
"source_provider": null
},
{
"column_name": "FIELD_CATEGORY",
"alias": "FIELD_CATEGORY",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_DETAIL.FIELD_CATEGORY) FIELD_CATEGORY",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.FIELD_CATEGORY",
"source_provider": null
},
{
"column_name": "FIELD_IDENTIFIER",
"alias": "FIELD_IDENTIFIER",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_DETAIL.FIELD_IDENTIFIER) FIELD_IDENTIFIER",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.FIELD_IDENTIFIER",
"source_provider": null
},
{
"column_name": "FIELD_VALUE_TYPE",
"alias": "FIELD_VALUE_TYPE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_DETAIL.FIELD_VALUE_TYPE) FIELD_VALUE_TYPE",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.FIELD_VALUE_TYPE",
"source_provider": null
},
{
"column_name": "READ_ONLY",
"alias": "READ_ONLY",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_DETAIL.READ_ONLY) READ_ONLY",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.READ_ONLY",
"source_provider": null
},
{
"column_name": "SCOPE",
"alias": "SCOPE",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(FIELD_ATTRIBUTE_DETAIL.SCOPE) SCOPE",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.SCOPE",
"source_provider": null
}
],
"fields": [
"FIELD_ATTRIBUTE_DETAIL.ATTRIB_USER_DATA ATTRIB_USER_DATA",
"RTRIM(FIELD_ATTRIBUTE_DETAIL.CURRENCY_PROCESS) CURRENCY_PROCESS",
"RTRIM(FIELD_ATTRIBUTE_DETAIL.FIELD_CATEGORY) FIELD_CATEGORY",
"RTRIM(FIELD_ATTRIBUTE_DETAIL.FIELD_IDENTIFIER) FIELD_IDENTIFIER",
"RTRIM(FIELD_ATTRIBUTE_DETAIL.FIELD_VALUE_TYPE) FIELD_VALUE_TYPE",
"RTRIM(FIELD_ATTRIBUTE_DETAIL.READ_ONLY) READ_ONLY",
"TO_CHAR(FIELD_ATTRIBUTE_DETAIL.SCOPE) SCOPE"
],
"partition_number": 1,
"cluster_key": null
},
{
"needs_schema_suffix": true,
"table_logical_schema": "RULES",
"owner": "RULESDBO",
"table_name": "FIELD_ATTRIBUTE_PROCESS",
"table_alias": "FIELD_ATTRIBUTE_PROCESS",
"column_prefix": null,
"select_columns": null,
"column_aliases": null,
"mashup_mode": "LEFT",
"exclude_columns": null,
"expression": "MASTERTABLE.FIELD_ATTRIBUTE_PROCESS_ID = FIELD_ATTRIBUTE_PROCESS.FIELD_ATTRIBUTE_PROCESS_ID ",
"old_syntax_expression": "MASTERTABLE.FIELD_ATTRIBUTE_PROCESS_ID = FIELD_ATTRIBUTE_PROCESS.FIELD_ATTRIBUTE_PROCESS_ID ",
"columns": [
{
"column_name": "DATABASE_NAME",
"alias": "DATABASE_NAME_1",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_PROCESS.DATABASE_NAME) DATABASE_NAME_1",
"source": "RULES.FIELD_ATTRIBUTE_PROCESS.DATABASE_NAME",
"source_provider": null
},
{
"column_name": "FIELD_ATTRIBUTE_PROCESS_ID",
"alias": "FIELD_ATTRIBUTE_PROCESS_ID_1",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(FIELD_ATTRIBUTE_PROCESS.FIELD_ATTRIBUTE_PROCESS_ID) FIELD_ATTRIBUTE_PROCESS_ID_1",
"source": "RULES.FIELD_ATTRIBUTE_PROCESS.FIELD_ATTRIBUTE_PROCESS_ID",
"source_provider": null
},
{
"column_name": "PARAMETER_LIST",
"alias": "PARAMETER_LIST",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_PROCESS.PARAMETER_LIST) PARAMETER_LIST",
"source": "RULES.FIELD_ATTRIBUTE_PROCESS.PARAMETER_LIST",
"source_provider": null
},
{
"column_name": "PROCESS_DESCRIPTION",
"alias": "PROCESS_DESCRIPTION",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_PROCESS.PROCESS_DESCRIPTION) PROCESS_DESCRIPTION",
"source": "RULES.FIELD_ATTRIBUTE_PROCESS.PROCESS_DESCRIPTION",
"source_provider": null
},
{
"column_name": "PROCESS_TYPE",
"alias": "PROCESS_TYPE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_PROCESS.PROCESS_TYPE) PROCESS_TYPE",
"source": "RULES.FIELD_ATTRIBUTE_PROCESS.PROCESS_TYPE",
"source_provider": null
},
{
"column_name": "STORED_PROCEDURE_NAME",
"alias": "STORED_PROCEDURE_NAME",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_PROCESS.STORED_PROCEDURE_NAME) STORED_PROCEDURE_NAME",
"source": "RULES.FIELD_ATTRIBUTE_PROCESS.STORED_PROCEDURE_NAME",
"source_provider": null
}
],
"fields": [
"RTRIM(FIELD_ATTRIBUTE_PROCESS.DATABASE_NAME) DATABASE_NAME_1",
"TO_CHAR(FIELD_ATTRIBUTE_PROCESS.FIELD_ATTRIBUTE_PROCESS_ID) FIELD_ATTRIBUTE_PROCESS_ID_1",
"RTRIM(FIELD_ATTRIBUTE_PROCESS.PARAMETER_LIST) PARAMETER_LIST",
"RTRIM(FIELD_ATTRIBUTE_PROCESS.PROCESS_DESCRIPTION) PROCESS_DESCRIPTION",
"RTRIM(FIELD_ATTRIBUTE_PROCESS.PROCESS_TYPE) PROCESS_TYPE",
"RTRIM(FIELD_ATTRIBUTE_PROCESS.STORED_PROCEDURE_NAME) STORED_PROCEDURE_NAME"
],
"partition_number": 1,
"cluster_key": null
},
{
"needs_schema_suffix": true,
"table_logical_schema": "RULES",
"owner": "RULESDBO",
"table_name": "FIELD_PROCESS_DEFINITION",
"table_alias": "FIELD_PROCESS_DEFINITION",
"column_prefix": null,
"select_columns": null,
"column_aliases": null,
"mashup_mode": "LEFT",
"exclude_columns": null,
"expression": "MASTERTABLE.FIELD_ATTRIBUTE_ID = FIELD_PROCESS_DEFINITION.FIELD_ATTRIBUTE_ID and FIELD_PROCESS_DEFINITION.USER_DATA is not NULL",
"old_syntax_expression": "MASTERTABLE.FIELD_ATTRIBUTE_ID = FIELD_PROCESS_DEFINITION.FIELD_ATTRIBUTE_ID and FIELD_PROCESS_DEFINITION.USER_DATA is not NULL",
"columns": [
{
"column_name": "PARAMETER_TYPE",
"alias": "PARAMETER_TYPE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_PROCESS_DEFINITION.PARAMETER_TYPE) PARAMETER_TYPE",
"source": "RULES.FIELD_PROCESS_DEFINITION.PARAMETER_TYPE",
"source_provider": null
},
{
"column_name": "PARAMETER_VALUE",
"alias": "PARAMETER_VALUE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_PROCESS_DEFINITION.PARAMETER_VALUE) PARAMETER_VALUE",
"source": "RULES.FIELD_PROCESS_DEFINITION.PARAMETER_VALUE",
"source_provider": null
},
{
"column_name": "SEQ_NO",
"alias": "SEQ_NO",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(FIELD_PROCESS_DEFINITION.SEQ_NO) SEQ_NO",
"source": "RULES.FIELD_PROCESS_DEFINITION.SEQ_NO",
"source_provider": null
},
{
"column_name": "USER_DATA",
"alias": "USER_DATA",
"data_type": "LONG",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "FIELD_PROCESS_DEFINITION.USER_DATA USER_DATA",
"source": "RULES.FIELD_PROCESS_DEFINITION.USER_DATA",
"source_provider": null
}
],
"fields": [
"RTRIM(FIELD_PROCESS_DEFINITION.PARAMETER_TYPE) PARAMETER_TYPE",
"RTRIM(FIELD_PROCESS_DEFINITION.PARAMETER_VALUE) PARAMETER_VALUE",
"TO_CHAR(FIELD_PROCESS_DEFINITION.SEQ_NO) SEQ_NO",
"FIELD_PROCESS_DEFINITION.USER_DATA USER_DATA"
],
"partition_number": 1,
"cluster_key": null
},
{
"needs_schema_suffix": true,
"table_logical_schema": "ENGREF",
"owner": "ESTAR",
"table_name": "EAGLE_MDC_CALC_FIELDS_V2",
"table_alias": "EAGLE_MDC_CALC_FIELDS_V2",
"column_prefix": null,
"select_columns": null,
"column_aliases": null,
"mashup_mode": "LEFT",
"exclude_columns": null,
"expression": "MASTERTABLE.FIELD_ATTRIBUTE_ID = EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_ID",
"old_syntax_expression": "MASTERTABLE.FIELD_ATTRIBUTE_ID = EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_ID (+)",
"columns": [
{
"column_name": "FIELD_ATTRIBUTE_FORMULA",
"alias": "FIELD_ATTRIBUTE_FORMULA",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "ESTAR",
"precision": null,
"scale": null,
"field_expr": "RTRIM(EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_FORMULA) FIELD_ATTRIBUTE_FORMULA",
"source": "ENGREF.EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_FORMULA",
"source_provider": null
},
{
"column_name": "FIELD_ATTRIBUTE_REF_LIST",
"alias": "FIELD_ATTRIBUTE_REF_LIST",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "ESTAR",
"precision": null,
"scale": null,
"field_expr": "RTRIM(EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_REF_LIST) FIELD_ATTRIBUTE_REF_LIST",
"source": "ENGREF.EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_REF_LIST",
"source_provider": null
}
],
"fields": [
"RTRIM(EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_FORMULA) FIELD_ATTRIBUTE_FORMULA",
"RTRIM(EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_REF_LIST) FIELD_ATTRIBUTE_REF_LIST"
],
"partition_number": 1,
"cluster_key": null
},
{
"needs_schema_suffix": true,
"table_logical_schema": "ENGREF",
"owner": "ESTAR",
"table_name": "EAGLE_RDC_CALC_FIELDS_V2",
"table_alias": "EAGLE_RDC_CALC_FIELDS_V2",
"column_prefix": null,
"select_columns": null,
"column_aliases": null,
"mashup_mode": "LEFT",
"exclude_columns": null,
"expression": "MASTERTABLE.FIELD_ATTRIBUTE_ID = EAGLE_RDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_ID",
"old_syntax_expression": "MASTERTABLE.FIELD_ATTRIBUTE_ID = EAGLE_RDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_ID (+)",
"columns": [
{
"column_name": "DATA_STRATEGY_LIST",
"alias": "DATA_STRATEGY_LIST",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "ESTAR",
"precision": null,
"scale": null,
"field_expr": "RTRIM(EAGLE_RDC_CALC_FIELDS_V2.DATA_STRATEGY_LIST) DATA_STRATEGY_LIST",
"source": "ENGREF.EAGLE_RDC_CALC_FIELDS_V2.DATA_STRATEGY_LIST",
"source_provider": null
},
{
"column_name": "ENRICHMENT_RULE",
"alias": "ENRICHMENT_RULE",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "ESTAR",
"precision": null,
"scale": null,
"field_expr": "RTRIM(EAGLE_RDC_CALC_FIELDS_V2.ENRICHMENT_RULE) ENRICHMENT_RULE",
"source": "ENGREF.EAGLE_RDC_CALC_FIELDS_V2.ENRICHMENT_RULE",
"source_provider": null
},
{
"column_name": "GROUP_LIST",
"alias": "GROUP_LIST",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "ESTAR",
"precision": null,
"scale": null,
"field_expr": "RTRIM(EAGLE_RDC_CALC_FIELDS_V2.GROUP_LIST) GROUP_LIST",
"source": "ENGREF.EAGLE_RDC_CALC_FIELDS_V2.GROUP_LIST",
"source_provider": null
},
{
"column_name": "VALIDATION_LIST",
"alias": "VALIDATION_LIST",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "ESTAR",
"precision": null,
"scale": null,
"field_expr": "RTRIM(EAGLE_RDC_CALC_FIELDS_V2.VALIDATION_LIST) VALIDATION_LIST",
"source": "ENGREF.EAGLE_RDC_CALC_FIELDS_V2.VALIDATION_LIST",
"source_provider": null
}
],
"fields": [
"RTRIM(EAGLE_RDC_CALC_FIELDS_V2.DATA_STRATEGY_LIST) DATA_STRATEGY_LIST",
"RTRIM(EAGLE_RDC_CALC_FIELDS_V2.ENRICHMENT_RULE) ENRICHMENT_RULE",
"RTRIM(EAGLE_RDC_CALC_FIELDS_V2.GROUP_LIST) GROUP_LIST",
"RTRIM(EAGLE_RDC_CALC_FIELDS_V2.VALIDATION_LIST) VALIDATION_LIST"
],
"partition_number": 1,
"cluster_key": null
}
],
"excluded_tables": [],
"key": "FIELD_ATTRIBUTE_ID",
"xrefs": [],
"fields": [
"RTRIM(MASTERTABLE.CALC_TYPE) CALC_TYPE",
"RTRIM(MASTERTABLE.COMMENTS) COMMENTS",
"RTRIM(MASTERTABLE.DATABASE_NAME) DATABASE_NAME",
"TO_CHAR(MASTERTABLE.DENOMINTOR_ID) DENOMINTOR_ID",
"RTRIM(MASTERTABLE.FIELD_ATTRIBUTE_DESCRIPTION) FIELD_ATTRIBUTE_DESCRIPTION",
"TO_CHAR(MASTERTABLE.FIELD_ATTRIBUTE_ID) FIELD_ATTRIBUTE_ID",
"TO_CHAR(MASTERTABLE.FIELD_ATTRIBUTE_PROCESS_ID) FIELD_ATTRIBUTE_PROCESS_ID",
"RTRIM(MASTERTABLE.FIELD_FORMAT) FIELD_FORMAT",
"RTRIM(MASTERTABLE.FIELD_INDICATOR) FIELD_INDICATOR",
"RTRIM(MASTERTABLE.FIELD_NAME) FIELD_NAME",
"RTRIM(MASTERTABLE.FIELD_TYPE) FIELD_TYPE",
"TO_CHAR(MASTERTABLE.NUMERATOR_ID) NUMERATOR_ID",
"TO_CHAR(MASTERTABLE.NUMERATOR_ID2) NUMERATOR_ID2",
"TO_CHAR(MASTERTABLE.REF_CODE_ID) REF_CODE_ID",
"TO_CHAR(MASTERTABLE.SRC_INTFC_INST) SRC_INTFC_INST",
"RTRIM(MASTERTABLE.STAT_FIELD) STAT_FIELD",
"RTRIM(MASTERTABLE.TABLE_NAME) TABLE_NAME",
"CASE WHEN MASTERTABLE.UPDATE_DATE IS NOT NULL THEN TO_CHAR(CAST(MASTERTABLE.UPDATE_DATE AS TIMESTAMP WITH TIME ZONE), 'YYYY-MM-DD') || 'T' || TO_CHAR(CAST(MASTERTABLE.UPDATE_DATE AS TIMESTAMP WITH TIME ZONE), 'HH24:MI:SSTZH:TZM') ELSE NULL END UPDATE_DATE",
"RTRIM(MASTERTABLE.UPDATE_SOURCE) UPDATE_SOURCE",
"FIELD_ATTRIBUTE_DETAIL.ATTRIB_USER_DATA ATTRIB_USER_DATA",
"RTRIM(FIELD_ATTRIBUTE_DETAIL.CURRENCY_PROCESS) CURRENCY_PROCESS",
"RTRIM(FIELD_ATTRIBUTE_DETAIL.FIELD_CATEGORY) FIELD_CATEGORY",
"RTRIM(FIELD_ATTRIBUTE_DETAIL.FIELD_IDENTIFIER) FIELD_IDENTIFIER",
"RTRIM(FIELD_ATTRIBUTE_DETAIL.FIELD_VALUE_TYPE) FIELD_VALUE_TYPE",
"RTRIM(FIELD_ATTRIBUTE_DETAIL.READ_ONLY) READ_ONLY",
"TO_CHAR(FIELD_ATTRIBUTE_DETAIL.SCOPE) SCOPE",
"RTRIM(FIELD_ATTRIBUTE_PROCESS.DATABASE_NAME) DATABASE_NAME_1",
"TO_CHAR(FIELD_ATTRIBUTE_PROCESS.FIELD_ATTRIBUTE_PROCESS_ID) FIELD_ATTRIBUTE_PROCESS_ID_1",
"RTRIM(FIELD_ATTRIBUTE_PROCESS.PARAMETER_LIST) PARAMETER_LIST",
"RTRIM(FIELD_ATTRIBUTE_PROCESS.PROCESS_DESCRIPTION) PROCESS_DESCRIPTION",
"RTRIM(FIELD_ATTRIBUTE_PROCESS.PROCESS_TYPE) PROCESS_TYPE",
"RTRIM(FIELD_ATTRIBUTE_PROCESS.STORED_PROCEDURE_NAME) STORED_PROCEDURE_NAME",
"RTRIM(FIELD_PROCESS_DEFINITION.PARAMETER_TYPE) PARAMETER_TYPE",
"RTRIM(FIELD_PROCESS_DEFINITION.PARAMETER_VALUE) PARAMETER_VALUE",
"TO_CHAR(FIELD_PROCESS_DEFINITION.SEQ_NO) SEQ_NO",
"FIELD_PROCESS_DEFINITION.USER_DATA USER_DATA",
"RTRIM(EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_FORMULA) FIELD_ATTRIBUTE_FORMULA",
"RTRIM(EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_REF_LIST) FIELD_ATTRIBUTE_REF_LIST",
"RTRIM(EAGLE_RDC_CALC_FIELDS_V2.DATA_STRATEGY_LIST) DATA_STRATEGY_LIST",
"RTRIM(EAGLE_RDC_CALC_FIELDS_V2.ENRICHMENT_RULE) ENRICHMENT_RULE",
"RTRIM(EAGLE_RDC_CALC_FIELDS_V2.GROUP_LIST) GROUP_LIST",
"RTRIM(EAGLE_RDC_CALC_FIELDS_V2.VALIDATION_LIST) VALIDATION_LIST"
],
"column_info": [
{
"column_name": "CALC_TYPE",
"alias": "CALC_TYPE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.CALC_TYPE) CALC_TYPE",
"source": "RULES.FIELD_ATTRIBUTES.CALC_TYPE",
"source_provider": null
},
{
"column_name": "COMMENTS",
"alias": "COMMENTS",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.COMMENTS) COMMENTS",
"source": "RULES.FIELD_ATTRIBUTES.COMMENTS",
"source_provider": null
},
{
"column_name": "DATABASE_NAME",
"alias": "DATABASE_NAME",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.DATABASE_NAME) DATABASE_NAME",
"source": "RULES.FIELD_ATTRIBUTES.DATABASE_NAME",
"source_provider": null
},
{
"column_name": "DENOMINTOR_ID",
"alias": "DENOMINTOR_ID",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.DENOMINTOR_ID) DENOMINTOR_ID",
"source": "RULES.FIELD_ATTRIBUTES.DENOMINTOR_ID",
"source_provider": null
},
{
"column_name": "FIELD_ATTRIBUTE_DESCRIPTION",
"alias": "FIELD_ATTRIBUTE_DESCRIPTION",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.FIELD_ATTRIBUTE_DESCRIPTION) FIELD_ATTRIBUTE_DESCRIPTION",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_ATTRIBUTE_DESCRIPTION",
"source_provider": null
},
{
"column_name": "FIELD_ATTRIBUTE_ID",
"alias": "FIELD_ATTRIBUTE_ID",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.FIELD_ATTRIBUTE_ID) FIELD_ATTRIBUTE_ID",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_ATTRIBUTE_ID",
"source_provider": null
},
{
"column_name": "FIELD_ATTRIBUTE_PROCESS_ID",
"alias": "FIELD_ATTRIBUTE_PROCESS_ID",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.FIELD_ATTRIBUTE_PROCESS_ID) FIELD_ATTRIBUTE_PROCESS_ID",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_ATTRIBUTE_PROCESS_ID",
"source_provider": null
},
{
"column_name": "FIELD_FORMAT",
"alias": "FIELD_FORMAT",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.FIELD_FORMAT) FIELD_FORMAT",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_FORMAT",
"source_provider": null
},
{
"column_name": "FIELD_INDICATOR",
"alias": "FIELD_INDICATOR",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.FIELD_INDICATOR) FIELD_INDICATOR",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_INDICATOR",
"source_provider": null
},
{
"column_name": "FIELD_NAME",
"alias": "FIELD_NAME",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.FIELD_NAME) FIELD_NAME",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_NAME",
"source_provider": null
},
{
"column_name": "FIELD_TYPE",
"alias": "FIELD_TYPE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.FIELD_TYPE) FIELD_TYPE",
"source": "RULES.FIELD_ATTRIBUTES.FIELD_TYPE",
"source_provider": null
},
{
"column_name": "NUMERATOR_ID",
"alias": "NUMERATOR_ID",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.NUMERATOR_ID) NUMERATOR_ID",
"source": "RULES.FIELD_ATTRIBUTES.NUMERATOR_ID",
"source_provider": null
},
{
"column_name": "NUMERATOR_ID2",
"alias": "NUMERATOR_ID2",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.NUMERATOR_ID2) NUMERATOR_ID2",
"source": "RULES.FIELD_ATTRIBUTES.NUMERATOR_ID2",
"source_provider": null
},
{
"column_name": "REF_CODE_ID",
"alias": "REF_CODE_ID",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.REF_CODE_ID) REF_CODE_ID",
"source": "RULES.FIELD_ATTRIBUTES.REF_CODE_ID",
"source_provider": null
},
{
"column_name": "SRC_INTFC_INST",
"alias": "SRC_INTFC_INST",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(MASTERTABLE.SRC_INTFC_INST) SRC_INTFC_INST",
"source": "RULES.FIELD_ATTRIBUTES.SRC_INTFC_INST",
"source_provider": null
},
{
"column_name": "STAT_FIELD",
"alias": "STAT_FIELD",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.STAT_FIELD) STAT_FIELD",
"source": "RULES.FIELD_ATTRIBUTES.STAT_FIELD",
"source_provider": null
},
{
"column_name": "TABLE_NAME",
"alias": "TABLE_NAME",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.TABLE_NAME) TABLE_NAME",
"source": "RULES.FIELD_ATTRIBUTES.TABLE_NAME",
"source_provider": null
},
{
"column_name": "UPDATE_DATE",
"alias": "UPDATE_DATE",
"data_type": "DATETIME",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "CASE WHEN MASTERTABLE.UPDATE_DATE IS NOT NULL THEN TO_CHAR(CAST(MASTERTABLE.UPDATE_DATE AS TIMESTAMP WITH TIME ZONE), 'YYYY-MM-DD') || 'T' || TO_CHAR(CAST(MASTERTABLE.UPDATE_DATE AS TIMESTAMP WITH TIME ZONE), 'HH24:MI:SSTZH:TZM') ELSE NULL END UPDATE_DATE",
"source": "RULES.FIELD_ATTRIBUTES.UPDATE_DATE",
"source_provider": null
},
{
"column_name": "UPDATE_SOURCE",
"alias": "UPDATE_SOURCE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(MASTERTABLE.UPDATE_SOURCE) UPDATE_SOURCE",
"source": "RULES.FIELD_ATTRIBUTES.UPDATE_SOURCE",
"source_provider": null
},
{
"column_name": "ATTRIB_USER_DATA",
"alias": "ATTRIB_USER_DATA",
"data_type": "CLOB",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "FIELD_ATTRIBUTE_DETAIL.ATTRIB_USER_DATA ATTRIB_USER_DATA",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.ATTRIB_USER_DATA",
"source_provider": null
},
{
"column_name": "CURRENCY_PROCESS",
"alias": "CURRENCY_PROCESS",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_DETAIL.CURRENCY_PROCESS) CURRENCY_PROCESS",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.CURRENCY_PROCESS",
"source_provider": null
},
{
"column_name": "FIELD_CATEGORY",
"alias": "FIELD_CATEGORY",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_DETAIL.FIELD_CATEGORY) FIELD_CATEGORY",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.FIELD_CATEGORY",
"source_provider": null
},
{
"column_name": "FIELD_IDENTIFIER",
"alias": "FIELD_IDENTIFIER",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_DETAIL.FIELD_IDENTIFIER) FIELD_IDENTIFIER",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.FIELD_IDENTIFIER",
"source_provider": null
},
{
"column_name": "FIELD_VALUE_TYPE",
"alias": "FIELD_VALUE_TYPE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_DETAIL.FIELD_VALUE_TYPE) FIELD_VALUE_TYPE",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.FIELD_VALUE_TYPE",
"source_provider": null
},
{
"column_name": "READ_ONLY",
"alias": "READ_ONLY",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_DETAIL.READ_ONLY) READ_ONLY",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.READ_ONLY",
"source_provider": null
},
{
"column_name": "SCOPE",
"alias": "SCOPE",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(FIELD_ATTRIBUTE_DETAIL.SCOPE) SCOPE",
"source": "RULES.FIELD_ATTRIBUTE_DETAIL.SCOPE",
"source_provider": null
},
{
"column_name": "DATABASE_NAME",
"alias": "DATABASE_NAME_1",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_PROCESS.DATABASE_NAME) DATABASE_NAME_1",
"source": "RULES.FIELD_ATTRIBUTE_PROCESS.DATABASE_NAME",
"source_provider": null
},
{
"column_name": "FIELD_ATTRIBUTE_PROCESS_ID",
"alias": "FIELD_ATTRIBUTE_PROCESS_ID_1",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(FIELD_ATTRIBUTE_PROCESS.FIELD_ATTRIBUTE_PROCESS_ID) FIELD_ATTRIBUTE_PROCESS_ID_1",
"source": "RULES.FIELD_ATTRIBUTE_PROCESS.FIELD_ATTRIBUTE_PROCESS_ID",
"source_provider": null
},
{
"column_name": "PARAMETER_LIST",
"alias": "PARAMETER_LIST",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_PROCESS.PARAMETER_LIST) PARAMETER_LIST",
"source": "RULES.FIELD_ATTRIBUTE_PROCESS.PARAMETER_LIST",
"source_provider": null
},
{
"column_name": "PROCESS_DESCRIPTION",
"alias": "PROCESS_DESCRIPTION",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_PROCESS.PROCESS_DESCRIPTION) PROCESS_DESCRIPTION",
"source": "RULES.FIELD_ATTRIBUTE_PROCESS.PROCESS_DESCRIPTION",
"source_provider": null
},
{
"column_name": "PROCESS_TYPE",
"alias": "PROCESS_TYPE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_PROCESS.PROCESS_TYPE) PROCESS_TYPE",
"source": "RULES.FIELD_ATTRIBUTE_PROCESS.PROCESS_TYPE",
"source_provider": null
},
{
"column_name": "STORED_PROCEDURE_NAME",
"alias": "STORED_PROCEDURE_NAME",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_ATTRIBUTE_PROCESS.STORED_PROCEDURE_NAME) STORED_PROCEDURE_NAME",
"source": "RULES.FIELD_ATTRIBUTE_PROCESS.STORED_PROCEDURE_NAME",
"source_provider": null
},
{
"column_name": "PARAMETER_TYPE",
"alias": "PARAMETER_TYPE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_PROCESS_DEFINITION.PARAMETER_TYPE) PARAMETER_TYPE",
"source": "RULES.FIELD_PROCESS_DEFINITION.PARAMETER_TYPE",
"source_provider": null
},
{
"column_name": "PARAMETER_VALUE",
"alias": "PARAMETER_VALUE",
"data_type": "CHAR",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "RTRIM(FIELD_PROCESS_DEFINITION.PARAMETER_VALUE) PARAMETER_VALUE",
"source": "RULES.FIELD_PROCESS_DEFINITION.PARAMETER_VALUE",
"source_provider": null
},
{
"column_name": "SEQ_NO",
"alias": "SEQ_NO",
"data_type": "NUMBER",
"column_type": "string",
"owner": "RULESDBO",
"precision": 38,
"scale": 0,
"field_expr": "TO_CHAR(FIELD_PROCESS_DEFINITION.SEQ_NO) SEQ_NO",
"source": "RULES.FIELD_PROCESS_DEFINITION.SEQ_NO",
"source_provider": null
},
{
"column_name": "USER_DATA",
"alias": "USER_DATA",
"data_type": "LONG",
"column_type": "string",
"owner": "RULESDBO",
"precision": null,
"scale": null,
"field_expr": "FIELD_PROCESS_DEFINITION.USER_DATA USER_DATA",
"source": "RULES.FIELD_PROCESS_DEFINITION.USER_DATA",
"source_provider": null
},
{
"column_name": "FIELD_ATTRIBUTE_FORMULA",
"alias": "FIELD_ATTRIBUTE_FORMULA",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "ESTAR",
"precision": null,
"scale": null,
"field_expr": "RTRIM(EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_FORMULA) FIELD_ATTRIBUTE_FORMULA",
"source": "ENGREF.EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_FORMULA",
"source_provider": null
},
{
"column_name": "FIELD_ATTRIBUTE_REF_LIST",
"alias": "FIELD_ATTRIBUTE_REF_LIST",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "ESTAR",
"precision": null,
"scale": null,
"field_expr": "RTRIM(EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_REF_LIST) FIELD_ATTRIBUTE_REF_LIST",
"source": "ENGREF.EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_REF_LIST",
"source_provider": null
},
{
"column_name": "DATA_STRATEGY_LIST",
"alias": "DATA_STRATEGY_LIST",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "ESTAR",
"precision": null,
"scale": null,
"field_expr": "RTRIM(EAGLE_RDC_CALC_FIELDS_V2.DATA_STRATEGY_LIST) DATA_STRATEGY_LIST",
"source": "ENGREF.EAGLE_RDC_CALC_FIELDS_V2.DATA_STRATEGY_LIST",
"source_provider": null
},
{
"column_name": "ENRICHMENT_RULE",
"alias": "ENRICHMENT_RULE",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "ESTAR",
"precision": null,
"scale": null,
"field_expr": "RTRIM(EAGLE_RDC_CALC_FIELDS_V2.ENRICHMENT_RULE) ENRICHMENT_RULE",
"source": "ENGREF.EAGLE_RDC_CALC_FIELDS_V2.ENRICHMENT_RULE",
"source_provider": null
},
{
"column_name": "GROUP_LIST",
"alias": "GROUP_LIST",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "ESTAR",
"precision": null,
"scale": null,
"field_expr": "RTRIM(EAGLE_RDC_CALC_FIELDS_V2.GROUP_LIST) GROUP_LIST",
"source": "ENGREF.EAGLE_RDC_CALC_FIELDS_V2.GROUP_LIST",
"source_provider": null
},
{
"column_name": "VALIDATION_LIST",
"alias": "VALIDATION_LIST",
"data_type": "VARCHAR2",
"column_type": "string",
"owner": "ESTAR",
"precision": null,
"scale": null,
"field_expr": "RTRIM(EAGLE_RDC_CALC_FIELDS_V2.VALIDATION_LIST) VALIDATION_LIST",
"source": "ENGREF.EAGLE_RDC_CALC_FIELDS_V2.VALIDATION_LIST",
"source_provider": null
}
],
"multi_partition": true
}
}
},
"common": {
"db": {
"snowflake": {
"Temporal": {
"valid_time": {
"expression": "|updateTimestamp|",
"execute_on": "row"
},
"transaction_time": {
"expression": "convert(today(), 'yyyy-mm-dd') + ' ' + convert(currenttime(1), 'hh:mm:ss.uuu')",
"execute_on": "start",
"field": "zcreated_at",
"source_type_dialect": {
"source_type": "DATETIME",
"dialect": "YYYY-MM-DDThh:mm:ss[Z|(+|-)hh:mm]"
}
},
"ingestion_time": {
"expression": "convert(today(), 'yyyy-mm-dd') + ' ' + convert(currenttime(1), 'hh:mm:ss.uuu')",
"execute_on": "start",
"field": "zingested_at",
"source_type_dialect": {
"source_type": "DATETIME",
"dialect": "YYYY-MM-DDThh:mm:ss[Z|(+|-)hh:mm]"
}
},
"warehouse_time": {
"expression": "convert(today(), 'yyyy-mm-dd') + ' ' + convert(currenttime(1), 'hh:mm:ss.uuu')",
"execute_on": "start",
"field": "zwh_created_at",
"source_type_dialect": {
"source_type": "DATETIME",
"dialect": "YYYY-MM-DDThh:mm:ss[Z|(+|-)hh:mm]"
}
},
"transaction_end_time": {
"expression": "'9999-12-31'",
"execute_on": "start",
"field": "zcreated_at_end",
"source_type_dialect": {
"source_type": "DATETIME",
"dialect": "YYYY-MM-DDThh:mm:ss[Z|(+|-)hh:mm]"
}
}
},
"rowUniqueIds": {
"gzuid": {
"expression": "guid()",
"execute_on": "start",
"field": "zuid",
"source_type_dialect": {
"source_type": "VARCHAR2"
},
"length": "200"
},
"row_number": {
"expression": "get_source_row_number(:GVAR_RTR:)",
"execute_on": "row",
"field": "zrow_number",
"source_type_dialect": {
"precision": "38",
"scale": "0",
"source_type": "NUMBER"
}
},
"row_lineage": {
"expression": "'[' + :gzuid: + ',' + convert(get_source_row_number(:GVAR_RTR:), 0) + ']'",
"execute_on": "row",
"field": "zlineage",
"source_type_dialect": {
"source_type": "VARCHAR2"
},
"length": "300"
},
"gvariant": {
"expression": "''",
"execute_on": "start",
"field": "zvariant",
"source_type_dialect": {
"source_type": "VARCHAR2"
},
"length": "200"
},
"gtenant_id": {
"expression": "get_tenant_id(:GVAR_RTR:)",
"execute_on": "start",
"field": "ztenant_id",
"source_type_dialect": {
"source_type": "VARCHAR2"
},
"length": "50"
},
"row_lineage_hash": {
"expression": "''",
"execute_on": "start",
"field": "zlineage_hash",
"source_type_dialect": {
"source_type": "VARCHAR2"
},
"length": "300"
},
"gtracking_id": {
"expression": "get_instruction_param('correlationId', :GVAR_RTR:) or guid()",
"execute_on": "start",
"field": "ztracking_id",
"source_type_dialect": {
"source_type": "VARCHAR2"
},
"length": "200"
},
"record_uid": {
"expression": "''",
"execute_on": "start",
"field": "zrecord_uid",
"source_type_dialect": {
"source_type": "VARCHAR2"
},
"length": "200"
},
"override_id": {
"expression": "''",
"execute_on": "start",
"field": "zoverride_id",
"source_type_dialect": {
"source_type": "VARCHAR2"
},
"length": "200"
},
"override_state": {
"expression": "''",
"execute_on": "start",
"field": "zoverride_state",
"source_type_dialect": {
"source_type": "VARCHAR2"
},
"length": "200"
},
"zrow_source_check_sum": {
"expression": "|rowCheckSum|",
"execute_on": "row",
"field": "zrow_source_check_sum",
"source_type_dialect": {
"source_type": "VARCHAR2"
},
"length": "4000"
},
"zrow_target_check_sum": {
"expression": "''",
"execute_on": "row",
"field": "zrow_target_check_sum",
"source_type_dialect": {
"source_type": "VARCHAR2"
},
"length": "4000"
}
},
"rowInsertWrapper": {
"impl": "call ESTAR.ExecuteSQL(:1);"
},
"extract": {
"taxonomy": [
[
"|zcreated_at|",
"",
false,
null,
"",
"zcreatedAt"
],
[
"|zingested_at|",
"",
false,
null,
"",
"zingestedAt"
],
[
"|zwh_created_at|",
"",
false,
null,
"",
"zwhcreatedAt"
],
[
"|zcreated_at_end|",
"",
false,
null,
"",
"zcreatedAtEnd"
],
[
"|zuid|",
"",
false,
null,
"",
"zuid"
],
[
"|zrow_number|",
"",
false,
null,
"",
"zrowNumber"
],
[
"|zlineage|",
"",
false,
null,
"",
"zlineage"
],
[
"|zvariant|",
"",
false,
null,
"",
"zvariant"
],
[
"|ztenant_id|",
"",
false,
null,
"",
"ztenantId"
],
[
"|zlineage_hash|",
"",
false,
null,
"",
"zlineage_hash"
],
[
"|ztracking_id|",
"",
false,
null,
"",
"ztrackingId"
],
[
"|zrecord_uid|",
"",
false,
null,
"",
"zrecordUID"
],
[
"|zoverride_id|",
"",
false,
null,
"",
"zoverrideId"
],
[
"|zoverride_state|",
"",
false,
null,
"",
"zoverrideState"
],
[
"|zrow_source_check_sum|",
"",
false,
null,
"",
"zrowSourceCheckSum"
],
[
"|zrow_target_check_sum|",
"",
false,
null,
"",
"zrowTargetCheckSum"
]
],
"filter_definitions": {
"fromzcreatedat": {
"filter_type": "bind",
"parameters": [
{
"name": "fromzcreatedat",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zcreated_at\" >= :fromzcreatedat"
}
]
},
"fromzcreatedatend": {
"filter_type": "bind",
"parameters": [
{
"name": "fromzcreatedatend",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zcreated_at_end\" >= :fromzcreatedatend"
}
]
},
"fromzingestedat": {
"filter_type": "bind",
"parameters": [
{
"name": "fromzingestedat",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zingested_at\" >= :fromzingestedat"
}
]
},
"fromzwhcreatedat": {
"filter_type": "bind",
"parameters": [
{
"name": "fromzwhcreatedat",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zwh_created_at\" >= :fromzwhcreatedat"
}
]
},
"tozcreatedat": {
"filter_type": "bind",
"parameters": [
{
"name": "tozcreatedat",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zcreated_at\" <= :tozcreatedat"
}
]
},
"tozcreatedatend": {
"filter_type": "bind",
"parameters": [
{
"name": "tozcreatedatend",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zcreated_at_end\" <= :tozcreatedatend"
}
]
},
"tozingestedat": {
"filter_type": "bind",
"parameters": [
{
"name": "tozingestedat",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zingested_at\" <= :tozingestedat"
}
]
},
"tozwhcreatedat": {
"filter_type": "bind",
"parameters": [
{
"name": "tozwhcreatedat",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zwh_created_at\" <= :tozwhcreatedat"
}
]
},
"zcreatedat": {
"filter_type": "bind",
"parameters": [
{
"name": "zcreatedat",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zcreated_at\" = :zcreatedat"
}
]
},
"zcreatedatend": {
"filter_type": "bind",
"parameters": [
{
"name": "zcreatedatend",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zcreated_at_end\" = :zcreatedatend"
}
]
},
"zingestedat": {
"filter_type": "bind",
"parameters": [
{
"name": "zingestedat",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zingested_at\" = :zingestedat"
}
]
},
"zlineage": {
"filter_type": "bind",
"parameters": [
{
"name": "zlineage",
"type": "VARCHAR2",
"length": 300
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zlineage\" @(:zlineage)"
}
]
},
"zlineage_hash": {
"filter_type": "bind",
"parameters": [
{
"name": "zlineage_hash",
"type": "VARCHAR2",
"length": 300
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zlineage_hash\" @(:zlineage_hash)"
}
]
},
"zoverrideid": {
"filter_type": "bind",
"parameters": [
{
"name": "zoverrideid",
"type": "VARCHAR2",
"length": 200
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zoverride_id\" @(:zoverrideid)"
}
]
},
"zoverridestate": {
"filter_type": "bind",
"parameters": [
{
"name": "zoverridestate",
"type": "VARCHAR2",
"length": 200
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zoverride_state\" @(:zoverridestate)"
}
]
},
"zrecorduid": {
"filter_type": "bind",
"parameters": [
{
"name": "zrecorduid",
"type": "VARCHAR2",
"length": 200
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zrecord_uid\" @(:zrecorduid)"
}
]
},
"zrownumber": {
"filter_type": "bind",
"parameters": [
{
"name": "zrownumber",
"type": "NUMBER"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zrow_number\" @(:zrownumber)"
}
]
},
"zrowsourcechecksum": {
"filter_type": "bind",
"parameters": [
{
"name": "zrowsourcechecksum",
"type": "VARCHAR2",
"length": 4000
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zrow_source_check_sum\" @(:zrowsourcechecksum)"
}
]
},
"zrowtargetchecksum": {
"filter_type": "bind",
"parameters": [
{
"name": "zrowtargetchecksum",
"type": "VARCHAR2",
"length": 4000
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zrow_target_check_sum\" @(:zrowtargetchecksum)"
}
]
},
"ztenantid": {
"filter_type": "bind",
"parameters": [
{
"name": "ztenantid",
"type": "VARCHAR2",
"length": 50
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"ztenant_id\" @(:ztenantid)"
}
]
},
"ztrackingid": {
"filter_type": "bind",
"parameters": [
{
"name": "ztrackingid",
"type": "VARCHAR2",
"length": 200
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"ztracking_id\" @(:ztrackingid)"
}
]
},
"zuid": {
"filter_type": "bind",
"parameters": [
{
"name": "zuid",
"type": "VARCHAR2",
"length": 200
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zuid\" @(:zuid)"
}
]
},
"zvariant": {
"filter_type": "bind",
"parameters": [
{
"name": "zvariant",
"type": "VARCHAR2",
"length": 200
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zvariant\" @(:zvariant)"
}
]
},
"zwhcreatedat": {
"filter_type": "bind",
"parameters": [
{
"name": "zwhcreatedat",
"type": "DATETIME"
}
],
"bindings": [
{
"sourceProvider": "eagledb://oracle",
"filter": "MASTERTABLE.\"zwh_created_at\" = :zwhcreatedat"
}
]
}
}
}
}
},
"mapping": {
"statField": "RULES.FIELD_ATTRIBUTES.STAT_FIELD",
"calcType": "RULES.FIELD_ATTRIBUTES.CALC_TYPE",
"databaseName": "RULES.FIELD_ATTRIBUTES.DATABASE_NAME",
"fieldAttributeDescription": "RULES.FIELD_ATTRIBUTES.FIELD_ATTRIBUTE_DESCRIPTION",
"fieldAttributeId": "RULES.FIELD_ATTRIBUTES.FIELD_ATTRIBUTE_ID",
"fieldAttributeProcessId": "RULES.FIELD_ATTRIBUTES.FIELD_ATTRIBUTE_PROCESS_ID",
"fieldIndicator": "RULES.FIELD_ATTRIBUTES.FIELD_INDICATOR",
"fieldName": "RULES.FIELD_ATTRIBUTES.FIELD_NAME",
"fieldType": "RULES.FIELD_ATTRIBUTES.FIELD_TYPE",
"tableName": "RULES.FIELD_ATTRIBUTES.TABLE_NAME",
"refCodeId": "RULES.FIELD_ATTRIBUTES.REF_CODE_ID",
"fieldFormat": "RULES.FIELD_ATTRIBUTES.FIELD_FORMAT",
"comments": "RULES.FIELD_ATTRIBUTES.COMMENTS",
"numeratorId": "RULES.FIELD_ATTRIBUTES.NUMERATOR_ID",
"denomintorId": "RULES.FIELD_ATTRIBUTES.DENOMINTOR_ID",
"numeratorId2": "RULES.FIELD_ATTRIBUTES.NUMERATOR_ID2",
"fieldCategory": "RULES.FIELD_ATTRIBUTE_DETAIL.FIELD_CATEGORY",
"currencyProcess": "RULES.FIELD_ATTRIBUTE_DETAIL.CURRENCY_PROCESS",
"fieldValueType": "RULES.FIELD_ATTRIBUTE_DETAIL.FIELD_VALUE_TYPE",
"fieldIdentifier": "RULES.FIELD_ATTRIBUTE_DETAIL.FIELD_IDENTIFIER",
"scope": "RULES.FIELD_ATTRIBUTE_DETAIL.SCOPE",
"readOnly": "RULES.FIELD_ATTRIBUTE_DETAIL.READ_ONLY",
"processDescription": "RULES.FIELD_ATTRIBUTE_PROCESS.PROCESS_DESCRIPTION",
"processType": "RULES.FIELD_ATTRIBUTE_PROCESS.PROCESS_TYPE",
"parameterList": "RULES.FIELD_ATTRIBUTE_PROCESS.PARAMETER_LIST",
"processDatabaseName": "RULES.FIELD_ATTRIBUTE_PROCESS.DATABASE_NAME",
"processStoredProcedureName": "RULES.FIELD_ATTRIBUTE_PROCESS.STORED_PROCEDURE_NAME",
"fieldExpression": "ENGREF.EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_FORMULA",
"userData": "RULES.FIELD_PROCESS_DEFINITION.USER_DATA",
"fieldAttributeReference": "ENGREF.EAGLE_MDC_CALC_FIELDS_V2.FIELD_ATTRIBUTE_REF_LIST",
"enrichmentRule": "ENGREF.EAGLE_RDC_CALC_FIELDS_V2.ENRICHMENT_RULE",
"rdcValidation": "ENGREF.EAGLE_RDC_CALC_FIELDS_V2.VALIDATION_LIST",
"rdcFieldGroup": "ENGREF.EAGLE_RDC_CALC_FIELDS_V2.GROUP_LIST",
"rdcDataStrategy": "ENGREF.EAGLE_RDC_CALC_FIELDS_V2.DATA_STRATEGY_LIST"
},
"enum_mapping": {
"statField": [
"N",
"Y"
],
"calcType": [
"AS",
"AV",
"CD",
"CT",
"DC",
"DI",
"DS",
"FO",
"FV",
"HM",
"MD",
"ME",
"MN",
"MX",
"NO",
"NT",
"OC",
"PD",
"RA",
"RR",
"SD",
"SM",
"SP",
"XO",
"as",
"av",
"cd",
"ct",
"dc",
"di",
"ds",
"fo",
"fv",
"hm",
"md",
"me",
"mn",
"mx",
"no",
"nt",
"oc",
"pd",
"ra",
"rr",
"sd",
"sm",
"sp",
"xo"
],
"fieldIndicator": [
"A",
"AC",
"AP",
"C",
"CA",
"CC",
"CD",
"CF",
"CI",
"CL",
"CM",
"CO",
"CR",
"CX",
"D",
"DD",
"DE",
"DF",
"E",
"EA",
"EC",
"EH",
"EL",
"EM",
"ES",
"EX",
"F",
"FA",
"FD",
"FE",
"FS",
"FT",
"FX",
"G",
"H",
"HA",
"I",
"IA",
"II",
"IL",
"IP",
"IR",
"IS",
"IT",
"IX",
"LA",
"LE",
"LT",
"P",
"PA",
"PE",
"PF",
"PR",
"PS",
"PT",
"PX",
"R",
"RD",
"RH",
"RI",
"S",
"SH",
"SL",
"T",
"TS",
"TX",
"U",
"VC",
"VR",
"XR",
"ZZ",
"g"
],
"fieldType": [
"CNUM",
"DATE",
"LONG",
"NCHR",
"NUM",
"S",
"cnum",
"date",
"long",
"nchr",
"num",
"s"
],
"currencyProcess": [
"BEG",
"BFG",
"END",
"ENF",
"NOT",
"RET"
],
"fieldValueType": [
"NOT",
"RET",
"UVV"
],
"readOnly": [
"N",
"Y"
]
}
}
}

Pay attention on the following:

  1. Add definition with key in the register_for_mashups block

  2. Add mashup in mashups block

  3. Add mapping in taxonomy block

 

one.jpg

  • KEY: eagle.ebs.resource:O17_FIELDATTRIBUTE_VERSIONS

  • VALUE: 2.0.57
    NOTE: O17 this is tenant prefix. it can be different for your case.

  1. Run EQL extract:

{ "ServiceName": "EBS", "ServiceMethodName": "extract", "resourcename": "fieldattribute", "outputformat": "EagleJSON", "disabledatasetcache": "Y", "resourceversion": "2.0.57", "filters": { "fieldattributeid": "5300,4876,4877,2014,4263,4265,371,4266,5864,2110,108,109" } }

 "resourceversion": "2.0.57",Version can be different depends on the rule version you create

 Output example with custom mashup:

{ "eagleJSONVersion": "2-0", "eagleJSONType": "ReferenceTransactionMessage", "eagleJSONRevision": "294", "referenceTransactionMessage": { "header": {}, "referenceTransaction": [ { "header": { "objectType": "FieldAttribute" }, "fieldAttribute": [ { "objectType": "FieldAttribute", "statField": "Y", "calcType": "di", "databaseName": "security", "fieldAttributeDescription": "i Cusip", "fieldAttributeId": 108, "fieldIndicator": "S", "fieldName": "PRIMARY_ASSET_ID", "tableName": "SECURITY_MASTER", "refCodeId": 99, "comments": "Cusip", "fieldIdentifier": "I CUSIP", "scope": 2, "readOnly": "N", "fieldAttributeOntologyDescription": "Stores the most appropriate (primary) market security identifier of the financial instrument.", "rdcFieldGroup": "IIP_AF_5", "ea_mapping.LOB": "NYL Investors", "ea_mapping.SUBJECT_AREA_DOMAIN": "SECURITY", "ea_mapping.SUB_DOMAIN": "SECURITY", "ea_mapping.BUSINESS_NAME": "PRIMARY_ASSET_ID", "ea_mapping.BUSINESS_DESCRIPTION": "Current Primary Identifier of a security", "ea_mapping.PHASE_1_NYLIM": "-NA-", "ea_mapping.REQUIRED_FOR_FUTURE_STATE": "Y", "ea_mapping.SOURCE_PLATFORM": "CAMRA", "ea_mapping.SOURCE_TABLE": "SECURITY", "ea_mapping.SOURCE_COLUMN_SOURCE_COLUMN_STAT": "CUSIP", "ea_mapping.FORMAT": "CHAR(100)", "ea_mapping.COMMENTS_DERIVATIONS_TRANSFORMATIONS_FOR_SOURCE": "This is CUSIP", "ea_mapping.EXTRACT_FIELD_EXTRACT_FIELD_STAT": "CUSIP", "ea_mapping.FORMAT": "CHAR(100)", "ea_mapping.ML_ELEMENT": "EagleML/referenceTransaction/genericSMF/primaryAssetId", "ea_mapping.SUBJECT_AREA_FOR_INTERNAL": "cam_egl_smf", "ea_mapping.TARGET_FIELD_NAME_FOR_INTERNAL": "primaryAssetId", "ea_mapping.MANDATORY_FIELD": "Y" } ] } ] } }