Generated documentation

	Jobs
	Generated by Talend Data Fabric

Project Name	Local_First_Project	GENERATION DATE	Mar 19, 2019 7:06:31 AM
AUTHOR	user@talend.com	Talend Data Fabric VERSION	7.1.1.20181026_1147

Summary

Project Description

Description

Preview Picture

Settings

Context List

Component List

Components Description

Project Description

Properties	Values
Name	Local_First_Project
Language	java
Description

Description

Properties	Values
Name	DI_Demo_CSV_to_Snowflake
Author	user@talend.com
Version	0.1
Purpose	Demo Import of data from CSV
Status
Description
Creation	Aug 7, 2018 10:57:38 AM
Modification	Mar 19, 2019 7:05:44 AM

Preview Picture

Settings

Extra settings

Name	Value
COMP_DEFAULT_FILE_DIR
Multi thread execution	false
Implicit tContextLoad	false

Status & Logs

Name	Value
Use statistics (tStatCatcher)	false
Use logs (tLogCatcher)	false
Use volumetrics (tFlowMeterCatcher)	false
On Console	false
On Files	false
On Databases	false
Catch components statistics	false
Catch runtime errors	true
Catch user errors	true
Catch user warnings	true

Context List

ContextDefault

Name	Prompt	Need Prompt?	Type	Value	Source
file_path	file_path?	false	id_String	"C:\jons\Talend\Talend_Demo\"	Talend_Demo
log_path	log_path?	false	id_String	"C:\jons\Talend\Talend_Demo\log\"	Talend_Demo

Contextprod

Name	Prompt	Need Prompt?	Type	Value	Source
file_path	file_path?	false	id_String	"C:\jons\Talend\Talend_Demo\"	Talend_Demo
log_path	log_path?	false	id_String		Talend_Demo

Contextdev

Name	Prompt	Need Prompt?	Type	Value	Source
file_path	file_path?	false	id_String	"C:\jons\Talend\Talend_Demo\"	Talend_Demo
log_path	log_path?	false	id_String	"C:\jons\Talend\Talend_Demo\log\"	Talend_Demo

Component List

Component Name	Component Type
simple_logPROCESSING_1	simple_logPROCESSING
tAggregateRow_1	tAggregateRow
tDBConnection_1	tSnowflakeConnection
tDBOutput_1	tSnowflakeOutput
tDBOutput_2	tSnowflakeOutput
tDBRow_1	tSnowflakeRow
tDBRow_2	tSnowflakeRow
tDie_1	tDie
tDie_2	tDie
tDie_3	tDie
tDie_4	tDie
tFileInputDelimited_1	tFileInputDelimited
tLogRow_2	tLogRow
tLogRow_3	tLogRow
tMap_1	tMap
tPrejob_1	tPrejob
tSortRow_1	tSortRow
tWarn_1	tWarn
tWarn_2	tWarn

Components Description

Component tAggregateRow

	UNIQUE NAME	tAggregateRow_1	INPUT(S)	tMap_1
	LABEL	group by Payer	OUTPUT(S)	tDBOutput_2

Component Parameters:

Properties	Values
Unique Name	tAggregateRow_1
Component Name	tAggregateRow
Version	0.102 (ALPHA)
Family	Processing
Startable	false
SUBTREE_START	false
END_OF_FLOW	false
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tAggregateRow
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	C:\Program Files (x86)\Talend-Studio\studio\configuration\lib\java
Subjob color
Title color
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
REPOSITORY_ALLOW_AUTO_SWITCH	true
Schema	Built-In
Group by	[{OUTPUT_COLUMN=PAYER, INPUT_COLUMN=PAYER}]
Operations	[{OUTPUT_COLUMN=BILLED_AMT, FUNCTION=sum, INPUT_COLUMN=BILLED_AMT, IGNORE_NULL=false}, {OUTPUT_COLUMN=PAID_AMT, FUNCTION=sum, INPUT_COLUMN=PAID_AMT, IGNORE_NULL=false}, {OUTPUT_COLUMN=COPAY_AMT, FUNCTION=sum, INPUT_COLUMN=COPAY_AMT, IGNORE_NULL=false}]
Delimiter (only for list operation)	","
Use financial precision, this is the max precision for "sum" and "avg" operations, checked option heaps more memory and slower than unchecked.	true
Check type overflow (slower)	false
Check ULP (Unit in the Last Place), ensure that a value will be incremented or decremented correctly, only for float and double types. (slower)	false
Label format	group by Payer
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tAggregateRow_1 :

Column	Key	Type	Nullable
PAYER	false	String	true
BILLED_AMT	false	BigDecimal	true
PAID_AMT	false	BigDecimal	true
COPAY_AMT	false	BigDecimal	true

Original Function Parameters:

Component tSnowflakeConnection

	UNIQUE NAME	tDBConnection_1	INPUT(S)	tPrejob_1
	LABEL	snowflake_Conn	OUTPUT(S)	tDie_1

Component Parameters:

Properties	Values
Database	tSnowflakeConnection
Unique Name	tDBConnection_1
Component Name	tSnowflakeConnection
Family	Cloud/Snowflake
Start	false
Startable	true
SUBTREE_START	true
END_OF_FLOW	true
Activate	true
Help	HELP
Update components	true
IREPORT_PATH
Property Type	Built-In
Query Type	Built-In
tStatCatcher Statistics	false
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
Account	"xxxxxxxxxxx.us-east-1"
Snowflake Region	AWS_US_WEST
User Id	xxxxxxx
Password	xxxxxxxxxx
Warehouse	"HEALTHCARE_DEMO"
Schema	"PUBLIC"
Database	"HEALTHCARE_DEMO"
Use Custom Snowflake Region	false
Region ID
Login Timeout	15
Tracing	OFF
Role	""
Label format	snowflake_Conn
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Original Function Parameters:

Component tSnowflakeOutput

	UNIQUE NAME	tDBOutput_1	INPUT(S)	tSortRow_1
	LABEL	MCH_Payer	OUTPUT(S)	none

Component Parameters:

Properties	Values
Database	tSnowflakeOutput
Unique Name	tDBOutput_1
Component Name	tSnowflakeOutput
Family	Cloud/Snowflake
Startable	false
SUBTREE_START	false
END_OF_FLOW	true
Activate	true
Help	HELP
Update components	true
IREPORT_PATH
Property Type	Built-In
Query Type	Built-In
tStatCatcher Statistics	false
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
properties.referencedComponent.displayName
Account	""
Snowflake Region
User Id	""
Password	""
Warehouse	""
Schema	""
Database	""
Table	"MEDICAL_CLAIM_HEADER_PAYER"
Schema	{"type":"record","name":"MEDICAL_CLAIM_HEADER_PAYER","fields":[{"name":"PAYER","type":"string","default":"","talend.field.length":255,"talend.field.dbType":12,"talend.field.dbColumnName":"PAYER","talend.field.default":""},{"name":"ENCOUNTER_DATE","type":{"type":"int","logicalType":"date"},"default":"","talend.field.pattern":"yyyy-MM-dd","talend.field.dbType":91,"talend.field.dbColumnName":"ENCOUNTER_DATE","talend.field.default":""},{"name":"SERVICE_START_DATE","type":{"type":"int","logicalType":"date"},"default":"","talend.field.pattern":"yyyy-MM-dd","talend.field.dbType":91,"talend.field.dbColumnName":"SERVICE_START_DATE","talend.field.default":""},{"name":"PAID_DT","type":{"type":"int","logicalType":"date"},"default":"","talend.field.pattern":"yyyy-MM-dd","talend.field.dbType":91,"talend.field.dbColumnName":"PAID_DT","talend.field.default":""},{"name":"BILLED_AMT","type":{"type":"string","java-class":"java.math.BigDecimal"},"default":"","talend.field.precision":18,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"BILLED_AMT","talend.field.default":""},{"name":"PAID_AMT","type":{"type":"string","java-class":"java.math.BigDecimal"},"default":"","talend.field.precision":18,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"PAID_AMT","talend.field.default":""},{"name":"COPAY_AMT","type":{"type":"string","java-class":"java.math.BigDecimal"},"default":"","talend.field.precision":18,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"COPAY_AMT","talend.field.default":""}]}
Table Action	NONE
Output Action	INSERT
Upsert Key Column	PAYER
Use Custom Snowflake Region	false
Region ID
Login Timeout	15
Tracing	OFF
Role	""
Convert columns and table to uppercase	true
Convert empty strings to null	true
Custom DB Type	false
DB column type	[]
schemaReject.schema	{"type":"record","name":"rejectOutput","fields":[{"name":"columnName","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"rowNumber","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"category","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"character","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"errorMessage","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"byteOffset","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"line","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"sqlState","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"code","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"}]}
REPOSITORY_ALLOW_AUTO_SWITCH	true
Label format	MCH_Payer
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tDBOutput_1 :

Column	Key	Type	Nullable
PAYER	false	String	false
ENCOUNTER_DATE	false	java.util.Date	false
SERVICE_START_DATE	false	java.util.Date	false
PAID_DT	false	java.util.Date	false
BILLED_AMT	false	BigDecimal	false
PAID_AMT	false	BigDecimal	false
COPAY_AMT	false	BigDecimal	false

Original Function Parameters:

Component tSnowflakeOutput

	UNIQUE NAME	tDBOutput_2	INPUT(S)	tAggregateRow_1
	LABEL	MCH_Payer_Aggr	OUTPUT(S)	none

Component Parameters:

Properties	Values
Database	tSnowflakeOutput
Unique Name	tDBOutput_2
Component Name	tSnowflakeOutput
Family	Cloud/Snowflake
Startable	false
SUBTREE_START	false
END_OF_FLOW	true
Activate	true
Help	HELP
Update components	true
IREPORT_PATH
Property Type	Built-In
Query Type	Built-In
tStatCatcher Statistics	false
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
properties.referencedComponent.displayName
Account	""
Snowflake Region
User Id	""
Password	""
Warehouse	""
Schema	""
Database	""
Table	"MEDICAL_CLAIM_HEADER_PAYER_AGGREGATE"
Schema	{"type":"record","name":"MEDICAL_CLAIM_HEADER_PAYER_AGGREGATE","fields":[{"name":"PAYER","type":["string","null"],"default":"","talend.field.length":255,"talend.field.dbType":12,"talend.field.dbColumnName":"PAYER","talend.field.default":""},{"name":"BILLED_AMT","type":[{"type":"string","java-class":"java.math.BigDecimal"},"null"],"default":"","talend.field.precision":17,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"BILLED_AMT","talend.field.default":""},{"name":"PAID_AMT","type":[{"type":"string","java-class":"java.math.BigDecimal"},"null"],"default":"","talend.field.precision":17,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"PAID_AMT","talend.field.default":""},{"name":"COPAY_AMT","type":[{"type":"string","java-class":"java.math.BigDecimal"},"null"],"default":"","talend.field.precision":17,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"COPAY_AMT","talend.field.default":""}]}
Table Action	NONE
Output Action	INSERT
Upsert Key Column	PAYER
Use Custom Snowflake Region	false
Region ID
Login Timeout	15
Tracing	OFF
Role	""
Convert columns and table to uppercase	true
Convert empty strings to null	true
Custom DB Type	false
DB column type	[]
schemaReject.schema	{"type":"record","name":"rejectOutput","fields":[{"name":"columnName","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"rowNumber","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"category","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"character","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"errorMessage","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"byteOffset","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"line","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"sqlState","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"code","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"}]}
REPOSITORY_ALLOW_AUTO_SWITCH	true
Label format	MCH_Payer_Aggr
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tDBOutput_2 :

Column	Key	Type	Nullable
PAYER	false	String	true
BILLED_AMT	false	BigDecimal	true
PAID_AMT	false	BigDecimal	true
COPAY_AMT	false	BigDecimal	true

Original Function Parameters:

Component tSnowflakeRow

	UNIQUE NAME	tDBRow_1	INPUT(S)	none
	LABEL	truncate MCHP	OUTPUT(S)	tLogRow_2, tDBRow_2, tDie_3

Component Parameters:

Properties	Values
Database	tSnowflakeRow
Unique Name	tDBRow_1
Component Name	tSnowflakeRow
Family	Cloud/Snowflake
Start	true
Startable	true
SUBTREE_START	true
END_OF_FLOW	false
Activate	true
Help	HELP
Update components	true
IREPORT_PATH
Property Type	Built-In
Query Type	Built-In
tStatCatcher Statistics	false
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
properties.referencedComponent.displayName
Account	""
Snowflake Region
User Id	""
Password	""
Warehouse	""
Schema	""
Database	""
Table	"MEDICAL_CLAIM_HEADER_PAYER"
Schema	{"type":"record","name":"MEDICAL_CLAIM_HEADER_PAYER","fields":[{"name":"PAYER","type":"string","default":"","talend.field.length":255,"talend.field.dbType":12,"talend.field.dbColumnName":"PAYER","talend.field.default":""},{"name":"ENCOUNTER_DATE","type":{"type":"int","logicalType":"date"},"default":"","talend.field.pattern":"yyyy-MM-dd","talend.field.dbType":91,"talend.field.dbColumnName":"ENCOUNTER_DATE","talend.field.default":""},{"name":"SERVICE_START_DATE","type":{"type":"int","logicalType":"date"},"default":"","talend.field.pattern":"yyyy-MM-dd","talend.field.dbType":91,"talend.field.dbColumnName":"SERVICE_START_DATE","talend.field.default":""},{"name":"PAID_DT","type":{"type":"int","logicalType":"date"},"default":"","talend.field.pattern":"yyyy-MM-dd","talend.field.dbType":91,"talend.field.dbColumnName":"PAID_DT","talend.field.default":""},{"name":"BILLED_AMT","type":{"type":"string","java-class":"java.math.BigDecimal"},"default":"","talend.field.precision":18,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"BILLED_AMT","talend.field.default":""},{"name":"PAID_AMT","type":{"type":"string","java-class":"java.math.BigDecimal"},"default":"","talend.field.precision":18,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"PAID_AMT","talend.field.default":""},{"name":"COPAY_AMT","type":{"type":"string","java-class":"java.math.BigDecimal"},"default":"","talend.field.precision":18,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"COPAY_AMT","talend.field.default":""}]}
Guess Query
Guess Schema
Query	"truncate table MEDICAL_CLAIM_HEADER_PAYER"
Die on error	false
Use Custom Snowflake Region	false
Region ID
Login Timeout	15
Tracing	OFF
Role	""
Use PreparedStatement	false
Set PreparedStatement Parameters	[]
Commit every	10000
schemaFlow.schema	{"type":"record","name":"MEDICAL_CLAIM_HEADER_PAYER","fields":[{"name":"PAYER","type":"string","default":"","talend.field.length":255,"talend.field.dbType":12,"talend.field.dbColumnName":"PAYER","talend.field.default":""},{"name":"ENCOUNTER_DATE","type":{"type":"int","logicalType":"date"},"default":"","talend.field.pattern":"yyyy-MM-dd","talend.field.dbType":91,"talend.field.dbColumnName":"ENCOUNTER_DATE","talend.field.default":""},{"name":"SERVICE_START_DATE","type":{"type":"int","logicalType":"date"},"default":"","talend.field.pattern":"yyyy-MM-dd","talend.field.dbType":91,"talend.field.dbColumnName":"SERVICE_START_DATE","talend.field.default":""},{"name":"PAID_DT","type":{"type":"int","logicalType":"date"},"default":"","talend.field.pattern":"yyyy-MM-dd","talend.field.dbType":91,"talend.field.dbColumnName":"PAID_DT","talend.field.default":""},{"name":"BILLED_AMT","type":{"type":"string","java-class":"java.math.BigDecimal"},"default":"","talend.field.precision":18,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"BILLED_AMT","talend.field.default":""},{"name":"PAID_AMT","type":{"type":"string","java-class":"java.math.BigDecimal"},"default":"","talend.field.precision":18,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"PAID_AMT","talend.field.default":""},{"name":"COPAY_AMT","type":{"type":"string","java-class":"java.math.BigDecimal"},"default":"","talend.field.precision":18,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"COPAY_AMT","talend.field.default":""}]}
schemaReject.schema	{"type":"record","name":"rejectOutput","fields":[{"name":"PAYER","type":"string","default":"","talend.field.length":255,"talend.field.dbType":12,"talend.field.dbColumnName":"PAYER","talend.field.default":""},{"name":"ENCOUNTER_DATE","type":{"type":"int","logicalType":"date"},"talend.field.pattern":"yyyy-MM-dd","talend.field.dbType":91,"talend.field.dbColumnName":"ENCOUNTER_DATE","talend.field.default":""},{"name":"SERVICE_START_DATE","type":{"type":"int","logicalType":"date"},"talend.field.pattern":"yyyy-MM-dd","talend.field.dbType":91,"talend.field.dbColumnName":"SERVICE_START_DATE","talend.field.default":""},{"name":"PAID_DT","type":{"type":"int","logicalType":"date"},"talend.field.pattern":"yyyy-MM-dd","talend.field.dbType":91,"talend.field.dbColumnName":"PAID_DT","talend.field.default":""},{"name":"BILLED_AMT","type":{"type":"string","java-class":"java.math.BigDecimal"},"default":"","talend.field.precision":18,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"BILLED_AMT","talend.field.default":""},{"name":"PAID_AMT","type":{"type":"string","java-class":"java.math.BigDecimal"},"default":"","talend.field.precision":18,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"PAID_AMT","talend.field.default":""},{"name":"COPAY_AMT","type":{"type":"string","java-class":"java.math.BigDecimal"},"default":"","talend.field.precision":18,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"COPAY_AMT","talend.field.default":""},{"name":"errorCode","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"errorMessage","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"}]}
REPOSITORY_ALLOW_AUTO_SWITCH	true
Label format	truncate MCHP
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tDBRow_1 :

Column	Key	Type	Nullable
PAYER	false	String	false
ENCOUNTER_DATE	false	java.util.Date	false
SERVICE_START_DATE	false	java.util.Date	false
PAID_DT	false	java.util.Date	false
BILLED_AMT	false	BigDecimal	false
PAID_AMT	false	BigDecimal	false
COPAY_AMT	false	BigDecimal	false

Original Function Parameters:

Component tSnowflakeRow

	UNIQUE NAME	tDBRow_2	INPUT(S)	tDBRow_1
	LABEL	truncate MCHPA	OUTPUT(S)	tLogRow_3, tDie_4, tWarn_2, tFileInputDelimited_1

Component Parameters:

Properties	Values
Database	tSnowflakeRow
Unique Name	tDBRow_2
Component Name	tSnowflakeRow
Family	Cloud/Snowflake
Start	false
Startable	true
SUBTREE_START	true
END_OF_FLOW	false
Activate	true
Help	HELP
Update components	true
IREPORT_PATH
Property Type	Built-In
Query Type	Built-In
tStatCatcher Statistics	false
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
properties.referencedComponent.displayName
Account	""
Snowflake Region
User Id	""
Password	""
Warehouse	""
Schema	""
Database	""
Table	"MEDICAL_CLAIM_HEADER_PAYER_AGGREGATE"
Schema	{"type":"record","name":"MEDICAL_CLAIM_HEADER_PAYER_AGGREGATE","fields":[{"name":"PAYER","type":["string","null"],"default":"","talend.field.length":255,"talend.field.dbType":12,"talend.field.dbColumnName":"PAYER","talend.field.default":""},{"name":"BILLED_AMT","type":[{"type":"string","java-class":"java.math.BigDecimal"},"null"],"default":"","talend.field.precision":17,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"BILLED_AMT","talend.field.default":""},{"name":"PAID_AMT","type":[{"type":"string","java-class":"java.math.BigDecimal"},"null"],"default":"","talend.field.precision":17,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"PAID_AMT","talend.field.default":""},{"name":"COPAY_AMT","type":[{"type":"string","java-class":"java.math.BigDecimal"},"null"],"default":"","talend.field.precision":17,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"COPAY_AMT","talend.field.default":""}]}
Guess Query
Guess Schema
Query	"truncate table MEDICAL_CLAIM_HEADER_PAYER_AGGREGATE"
Die on error	false
Use Custom Snowflake Region	false
Region ID
Login Timeout	15
Tracing	OFF
Role	""
Use PreparedStatement	false
Set PreparedStatement Parameters	[]
Commit every	10000
schemaFlow.schema	{"type":"record","name":"MEDICAL_CLAIM_HEADER_PAYER_AGGREGATE","fields":[{"name":"PAYER","type":["string","null"],"default":"","talend.field.length":255,"talend.field.dbType":12,"talend.field.dbColumnName":"PAYER","talend.field.default":""},{"name":"BILLED_AMT","type":[{"type":"string","java-class":"java.math.BigDecimal"},"null"],"default":"","talend.field.precision":17,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"BILLED_AMT","talend.field.default":""},{"name":"PAID_AMT","type":[{"type":"string","java-class":"java.math.BigDecimal"},"null"],"default":"","talend.field.precision":17,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"PAID_AMT","talend.field.default":""},{"name":"COPAY_AMT","type":[{"type":"string","java-class":"java.math.BigDecimal"},"null"],"default":"","talend.field.precision":17,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"COPAY_AMT","talend.field.default":""}]}
schemaReject.schema	{"type":"record","name":"rejectOutput","fields":[{"name":"PAYER","type":["string","null"],"default":"","talend.field.length":255,"talend.field.dbType":12,"talend.field.dbColumnName":"PAYER","talend.field.default":""},{"name":"BILLED_AMT","type":[{"type":"string","java-class":"java.math.BigDecimal"},"null"],"default":"","talend.field.precision":17,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"BILLED_AMT","talend.field.default":""},{"name":"PAID_AMT","type":[{"type":"string","java-class":"java.math.BigDecimal"},"null"],"default":"","talend.field.precision":17,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"PAID_AMT","talend.field.default":""},{"name":"COPAY_AMT","type":[{"type":"string","java-class":"java.math.BigDecimal"},"null"],"default":"","talend.field.precision":17,"talend.field.scale":2,"talend.field.dbType":3,"talend.field.dbColumnName":"COPAY_AMT","talend.field.default":""},{"name":"errorCode","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"},{"name":"errorMessage","type":"string","talend.isLocked":"false","talend.field.generated":"true","talend.field.length":"255"}]}
REPOSITORY_ALLOW_AUTO_SWITCH	true
Label format	truncate MCHPA
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tDBRow_2 :

Column	Key	Type	Nullable
PAYER	false	String	true
BILLED_AMT	false	BigDecimal	true
PAID_AMT	false	BigDecimal	true
COPAY_AMT	false	BigDecimal	true

Original Function Parameters:

Component tDie

	UNIQUE NAME	tDie_1	INPUT(S)	tDBConnection_1
	LABEL	Failed to connect to DB	OUTPUT(S)	none

Component Parameters:

Properties	Values
Unique Name	tDie_1
Component Name	tDie
Version	0.102 (ALPHA)
Family	Logs_Errors
Start	false
Startable	true
SUBTREE_START	true
END_OF_FLOW	true
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tDie
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	C:\Program Files (x86)\Talend-Studio\studio\configuration\lib\java
Subjob color
Title color
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
Die message	"the end is near"
Error code	4
Priority	5
Exit the JVM immediately	false
Schema	Built-In
Label format	Failed to connect to DB
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tDie_1 :

Column	Key	Type	Length	Precision	Nullable	Comment

Original Function Parameters:

Component tDie

	UNIQUE NAME	tDie_2	INPUT(S)	tFileInputDelimited_1
	LABEL	File read failure	OUTPUT(S)	none

Component Parameters:

Properties	Values
Unique Name	tDie_2
Component Name	tDie
Version	0.102 (ALPHA)
Family	Logs_Errors
Start	false
Startable	true
SUBTREE_START	true
END_OF_FLOW	true
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tDie
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	C:\Program Files (x86)\Talend-Studio\studio\configuration\lib\java
Subjob color
Title color
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
Die message	"the end is near"
Error code	4
Priority	5
Exit the JVM immediately	false
Schema	Built-In
Label format	File read failure
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tDie_2 :

Column	Key	Type	Length	Precision	Nullable	Comment

Original Function Parameters:

Component tDie

	UNIQUE NAME	tDie_3	INPUT(S)	tDBRow_1
	LABEL	fail truncate	OUTPUT(S)	none

Component Parameters:

Properties	Values
Unique Name	tDie_3
Component Name	tDie
Version	0.102 (ALPHA)
Family	Logs_Errors
Start	false
Startable	true
SUBTREE_START	true
END_OF_FLOW	true
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tDie
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	C:\Program Files (x86)\Talend-Studio\studio\configuration\lib\java
Subjob color
Title color
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
Die message	"the end is near"
Error code	4
Priority	5
Exit the JVM immediately	false
Schema	Built-In
Label format	fail truncate
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tDie_3 :

Column	Key	Type	Length	Precision	Nullable	Comment

Original Function Parameters:

Component tDie

	UNIQUE NAME	tDie_4	INPUT(S)	tDBRow_2
	LABEL	fail truncate	OUTPUT(S)	none

Component Parameters:

Properties	Values
Unique Name	tDie_4
Component Name	tDie
Version	0.102 (ALPHA)
Family	Logs_Errors
Start	false
Startable	true
SUBTREE_START	true
END_OF_FLOW	true
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tDie
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	C:\Program Files (x86)\Talend-Studio\studio\configuration\lib\java
Subjob color
Title color
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
Die message	"failed to truncate MCHA"
Error code	4
Priority	5
Exit the JVM immediately	false
Schema	Built-In
Label format	fail truncate
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tDie_4 :

Column	Key	Type	Length	Precision	Nullable	Comment

Original Function Parameters:

Component tFileInputDelimited

	UNIQUE NAME	tFileInputDelimited_1	INPUT(S)	tDBRow_2
	LABEL	MCH_payer	OUTPUT(S)	tMap_1, tDie_2, tWarn_1

Component Parameters:

Properties	Values
Unique Name	tFileInputDelimited_1
Component Name	tFileInputDelimited
Version	0.102 (ALPHA)
Family	File/Input
Start	false
Startable	true
SUBTREE_START	true
END_OF_FLOW	false
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tFileInputDelimited
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	C:\Program Files (x86)\Talend-Studio\studio\configuration\lib\java
Subjob color
Title color
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
Property Type	repository: DELIM:MCH_payer
REPOSITORY_ALLOW_AUTO_SWITCH	true
Schema	Built-In
File name/Stream	"C:/jons/Talend/Talend_Demo/Medical_Claim_Header_Payer.csv"
CSV options	false
Row Separator	"\n"
CSV Row Separator	"\n"
Field Separator	","
Escape char	"""
Text enclosure	"""
Header	1
Footer	0
Limit
Skip empty rows	false
Uncompress as zip file	false
Die on error	false
Schema	repository: DELIM:MCH_payer - MCH_metadata
!!!TEMP_DIR.NAME!!!	"C:/jons/Talend/workspace_7.0.1"
Advanced separator (for numbers)	false
Thousands separator	","
Decimal separator	"."
Extract lines at random	false
Number of lines	10
Trim all columns	false
Check column to trim	[{SCHEMA_COLUMN=Payer, TRIM=false}, {SCHEMA_COLUMN=Encounter_Date, TRIM=false}, {SCHEMA_COLUMN=Service_Start_Date, TRIM=false}, {SCHEMA_COLUMN=Paid_Dt, TRIM=false}, {SCHEMA_COLUMN=Billed_Amt, TRIM=false}, {SCHEMA_COLUMN=Paid_Amt, TRIM=false}, {SCHEMA_COLUMN=Copay_Amt, TRIM=false}]
Check each row structure against schema	false
Check date	false
Encoding	"UTF-8"
Split row before field	false
Permit hexadecimal (0xNNN) or octal (0NNNN) for numeric types	false
Decode table	[{SCHEMA_COLUMN=Payer, DECODE=false}, {SCHEMA_COLUMN=Encounter_Date, DECODE=false}, {SCHEMA_COLUMN=Service_Start_Date, DECODE=false}, {SCHEMA_COLUMN=Paid_Dt, DECODE=false}, {SCHEMA_COLUMN=Billed_Amt, DECODE=false}, {SCHEMA_COLUMN=Paid_Amt, DECODE=false}, {SCHEMA_COLUMN=Copay_Amt, DECODE=false}]
!!!DESTINATION.NAME!!!
Min column number of optimize code	100
Label format	MCH_payer
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for MCH_metadata :

Column	Key	Type	Length	Precision	Nullable
Payer	false	String	10		true
Encounter_Date	false	java.util.Date	10		true
Service_Start_Date	false	java.util.Date	10		true
Paid_Dt	false	java.util.Date	10		true
Billed_Amt	false	BigDecimal	8	3	true
Paid_Amt	false	BigDecimal	8	4	true
Copay_Amt	false	BigDecimal	7	4	true

Original Function Parameters:

Component tLogRow

	UNIQUE NAME	tLogRow_2	INPUT(S)	tDBRow_1
	LABEL	__UNIQUE_NAME__	OUTPUT(S)	none

Component Parameters:

Properties	Values
Unique Name	tLogRow_2
Component Name	tLogRow
Version	0.101 (ALPHA)
Family	Logs_Errors
Startable	false
SUBTREE_START	false
END_OF_FLOW	true
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tLogRow
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	C:\Program Files (x86)\Talend-Studio\studio\configuration\lib\java
Subjob color
Title color
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
REPOSITORY_ALLOW_AUTO_SWITCH	true
Schema	Built-In
Basic	true
Table (print values in cells of a table)	false
Vertical (each row is a key/value list)	false
Print unique name	true
Print label	false
Print unique name and label	false
Field Separator	"\|"
Print header	false
Print component unique name in front of each output row	false
Print schema column name in front of each value	false
Use fixed length for values	false
Lengths	[{SCHEMA_COLUMN=PAYER, LENGTH=10}, {SCHEMA_COLUMN=ENCOUNTER_DATE, LENGTH=10}, {SCHEMA_COLUMN=SERVICE_START_DATE, LENGTH=10}, {SCHEMA_COLUMN=PAID_DT, LENGTH=10}, {SCHEMA_COLUMN=BILLED_AMT, LENGTH=10}, {SCHEMA_COLUMN=PAID_AMT, LENGTH=10}, {SCHEMA_COLUMN=COPAY_AMT, LENGTH=10}]
Print content with log4j	true
Min column number of optimize code	100
Label format	__UNIQUE_NAME__
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tLogRow_2 :

Column	Key	Type	Nullable
PAYER	false	String	false
ENCOUNTER_DATE	false	java.util.Date	false
SERVICE_START_DATE	false	java.util.Date	false
PAID_DT	false	java.util.Date	false
BILLED_AMT	false	BigDecimal	false
PAID_AMT	false	BigDecimal	false
COPAY_AMT	false	BigDecimal	false

Original Function Parameters:

Component tLogRow

	UNIQUE NAME	tLogRow_3	INPUT(S)	tDBRow_2
	LABEL	__UNIQUE_NAME__	OUTPUT(S)	none

Component Parameters:

Properties	Values
Unique Name	tLogRow_3
Component Name	tLogRow
Version	0.101 (ALPHA)
Family	Logs_Errors
Startable	false
SUBTREE_START	false
END_OF_FLOW	true
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tLogRow
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	C:\Program Files (x86)\Talend-Studio\studio\configuration\lib\java
Subjob color
Title color
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
REPOSITORY_ALLOW_AUTO_SWITCH	true
Schema	Built-In
Basic	true
Table (print values in cells of a table)	false
Vertical (each row is a key/value list)	false
Print unique name	true
Print label	false
Print unique name and label	false
Field Separator	"\|"
Print header	false
Print component unique name in front of each output row	false
Print schema column name in front of each value	false
Use fixed length for values	false
Lengths	[{SCHEMA_COLUMN=PAYER, LENGTH=10}, {SCHEMA_COLUMN=BILLED_AMT, LENGTH=10}, {SCHEMA_COLUMN=PAID_AMT, LENGTH=10}, {SCHEMA_COLUMN=COPAY_AMT, LENGTH=10}]
Print content with log4j	true
Min column number of optimize code	100
Label format	__UNIQUE_NAME__
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tLogRow_3 :

Column	Key	Type	Nullable
PAYER	false	String	true
BILLED_AMT	false	BigDecimal	true
PAID_AMT	false	BigDecimal	true
COPAY_AMT	false	BigDecimal	true

Original Function Parameters:

Component tPrejob

	UNIQUE NAME	tPrejob_1	INPUT(S)	none
	LABEL	__UNIQUE_NAME__	OUTPUT(S)	tDBConnection_1

Component Parameters:

Properties	Values
Unique Name	tPrejob_1
Component Name	tPrejob
Version	0.102 (ALPHA)
Family	Orchestration
Start	true
Startable	true
SUBTREE_START	true
END_OF_FLOW	true
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tPrejob
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	C:\Program Files (x86)\Talend-Studio\studio\configuration\lib\java
Subjob color	255;220;180
Title color	230;100;0
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
Label format	__UNIQUE_NAME__
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Original Function Parameters:

Component tSortRow

	UNIQUE NAME	tSortRow_1	INPUT(S)	tMap_1
	LABEL	sort on Paid Dt	OUTPUT(S)	tDBOutput_1

Component Parameters:

Properties	Values
Unique Name	tSortRow_1
Component Name	tSortRow
Version	0.102 (ALPHA)
Family	Processing
Startable	false
SUBTREE_START	false
END_OF_FLOW	false
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tSortRow
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	C:\Program Files (x86)\Talend-Studio\studio\configuration\lib\java
Subjob color
Title color
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
REPOSITORY_ALLOW_AUTO_SWITCH	true
Schema	Built-In
Criteria	[{COLNAME=PAID_DT, SORT=date, ORDER=asc}]
Sort on disk	false
Temp data directory path	"C:/jons/Talend/workspace_7.0.1/temp"
Create temp data directory if does not exist	true
Buffer size of external sort	1000000
Label format	sort on Paid Dt
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tSortRow_1 :

Column	Key	Type	Nullable
PAYER	false	String	false
ENCOUNTER_DATE	false	java.util.Date	false
SERVICE_START_DATE	false	java.util.Date	false
PAID_DT	false	java.util.Date	false
BILLED_AMT	false	BigDecimal	false
PAID_AMT	false	BigDecimal	false
COPAY_AMT	false	BigDecimal	false

Original Function Parameters:

Component tWarn

	UNIQUE NAME	tWarn_1	INPUT(S)	tFileInputDelimited_1
	LABEL	File Read Success	OUTPUT(S)	none

Component Parameters:

Properties	Values
Unique Name	tWarn_1
Component Name	tWarn
Version	0.101 (ALPHA)
Family	Logs_Errors
Start	false
Startable	true
SUBTREE_START	true
END_OF_FLOW	true
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tWarn
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	C:\Program Files (x86)\Talend-Studio\studio\configuration\lib\java
Subjob color
Title color
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
Warn message	">>> INFO: Data has been read!"
Code	3607
Priority	3
Schema	Built-In
Label format	File Read Success
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tWarn_1 :

Column	Key	Type	Length	Precision	Nullable	Comment

Original Function Parameters:

Component tWarn

	UNIQUE NAME	tWarn_2	INPUT(S)	tDBRow_2
	LABEL	Truncate OK	OUTPUT(S)	none

Component Parameters:

Properties	Values
Unique Name	tWarn_2
Component Name	tWarn
Version	0.101 (ALPHA)
Family	Logs_Errors
Start	false
Startable	true
SUBTREE_START	true
END_OF_FLOW	true
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tWarn
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	C:\Program Files (x86)\Talend-Studio\studio\configuration\lib\java
Subjob color
Title color
Enable parallel execution	false
Number of parallel executions	2
PARALLELIZE_KEEP_EMPTY	false
Warn message	"Tables Truncated OK"
Code	3606
Priority	3
Schema	Built-In
Label format	Truncate OK
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tWarn_2 :

Column	Key	Type	Length	Precision	Nullable	Comment

Original Function Parameters:

Component simple_logPROCESSING

	UNIQUE NAME	simple_logPROCESSING_1	INPUT(S)	none
	LABEL	Simple Log Processing	OUTPUT(S)	none

Component Parameters:

Properties	Values
Version	Latest
Show Information	false
Comment

Component tMap

	UNIQUE NAME	tMap_1	INPUT(S)	tFileInputDelimited_1
	LABEL	__UNIQUE_NAME__	OUTPUT(S)	tSortRow_1, tAggregateRow_1

Component Parameters:

Properties	Values
tStatCatcher Statistics	false
Enable parallel execution	false
Mapping links display as:	AUTO
Temp data directory path:
Max buffer size (nb of rows):	2000000
Ignore trailing zeros for BigDecimal	true
Show Information	false
Comment
Use an existing validation rule	false

Mapper table for tMap_1 ( input ):

Mapper table Properties( row1 ):

Properties	Values
Name	row1
Matching-mode	UNIQUE_MATCH
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false
expressionFilter	null

Metadata Table Entries( row1 ):

Name	Type	isNullable
Payer	String	true
Encounter_Date	java.util.Date	true
Service_Start_Date	java.util.Date	true
Paid_Dt	java.util.Date	true
Billed_Amt	BigDecimal	true
Paid_Amt	BigDecimal	true
Copay_Amt	BigDecimal	true

Constraint Table Entries( row1 ):

Name	Type	Expression	isNullable

Mapper table for tMap_1 ( output ):

Mapper table Properties( out_MCHP ):

Properties	Values
Name	out_MCHP
Matching-mode
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false
expressionFilter	null

Metadata Table Entries( out_MCHP ):

Name	Type	Expression	isNullable
PAYER	String	row1.Payer	false
ENCOUNTER_DATE	java.util.Date	row1.Encounter_Date	false
SERVICE_START_DATE	java.util.Date	row1.Service_Start_Date	false
PAID_DT	java.util.Date	row1.Paid_Dt	false
BILLED_AMT	BigDecimal	row1.Billed_Amt	false
PAID_AMT	BigDecimal	row1.Paid_Amt	false
COPAY_AMT	BigDecimal	row1.Copay_Amt	false

Constraint Table Entries( out_MCHP ):

Name	Type	Expression	isNullable

Mapper table Properties( out_Aggr ):

Properties	Values
Name	out_Aggr
Matching-mode
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false
expressionFilter	null

Metadata Table Entries( out_Aggr ):

Name	Type	Expression	isNullable
PAYER	String	row1.Payer	true
BILLED_AMT	BigDecimal	row1.Billed_Amt	true
PAID_AMT	BigDecimal	row1.Paid_Amt	true
COPAY_AMT	BigDecimal	row1.Copay_Amt	true

Constraint Table Entries( out_Aggr ):

Name	Type	Expression	isNullable

Mapper table for tMap_1 ( var ):

Mapper table Properties( Var ):

Properties	Values
Name	Var
Matching-mode
isMinimized	true
isReject	false
isRejectInnerJoin	false
isInnerJoin	false
expressionFilter	null

Metadata Table Entries( Var ):

Name	Type	Expression	isNullable

Constraint Table Entries( Var ):

Name	Type	Expression	isNullable