diff options
author | mtaal | 2007-07-17 12:22:34 +0000 |
---|---|---|
committer | mtaal | 2007-07-17 12:22:34 +0000 |
commit | 9e91f847edcba86432186e3b9a091859735b2887 (patch) | |
tree | f62a8869fc4bc31dbd1e06e4ac5fa95c4b06774c /tests/org.eclipse.emf.teneo.hibernate.test/test | |
parent | 908530671922959cec1f6b795a680ca283140d6f (diff) | |
download | org.eclipse.emf.teneo-9e91f847edcba86432186e3b9a091859735b2887.tar.gz org.eclipse.emf.teneo-9e91f847edcba86432186e3b9a091859735b2887.tar.xz org.eclipse.emf.teneo-9e91f847edcba86432186e3b9a091859735b2887.zip |
[196689]
[196803]
Diffstat (limited to 'tests/org.eclipse.emf.teneo.hibernate.test/test')
-rw-r--r-- | tests/org.eclipse.emf.teneo.hibernate.test/test/consumer.ecore | 1884 |
1 files changed, 1884 insertions, 0 deletions
diff --git a/tests/org.eclipse.emf.teneo.hibernate.test/test/consumer.ecore b/tests/org.eclipse.emf.teneo.hibernate.test/test/consumer.ecore new file mode 100644 index 000000000..67da04ae9 --- /dev/null +++ b/tests/org.eclipse.emf.teneo.hibernate.test/test/consumer.ecore @@ -0,0 +1,1884 @@ +<?xml version="1.0" encoding="UTF-8"?> +<ecore:EPackage xmi:version="2.0" + xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xmlns:ecore="http://www.eclipse.org/emf/2002/Ecore" name="consumer" + nsURI="http://vsp.com/" nsPrefix="com.vsp.consumer"> + <eClassifiers xsi:type="ecore:EClass" name="Address"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="This is the location where a person or organization resides or receives mail."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="	
	@Table(
	 name="CMR3605T"
	 uniqueConstraints = {	
	 						@UniqueConstraint(columnNames={"ADDRESS_SK"})
	 					 }	 
	 }
	)	
	
	"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="Address"/> + <details key="kind" value="elementOnly"/> + </eAnnotations> + <eStructuralFeatures xsi:type="ecore:EReference" name="consumerSK" lowerBound="1" + eType="#//Consumer" containment="true" resolveProxies="false"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="A generated key to uniquely the parent"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@ManyToOne
 			@JoinColumn(name="CONSUMER_SK")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="addressSK" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Int" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="A generated key to uniquely the record."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Id
				@Column(name="ADDRESS_SK" nullable="false")
				@TableGenerator(
 			name="empGen",
 			allocationSize=1
 			)
 			@GeneratedValue(strategy=TABLE, generator="empGen")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="addressSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="street1" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Address Street line 1"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ADDR_ST_1",length="30")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="street1"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="street2" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Address Street line 2"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ADDR_ST_2",length="30")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="street2"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="city" lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" + defaultValueLiteral="" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="City address"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ADDR_CITY",length="20")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="city"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="state" lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" + defaultValueLiteral="" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="State code [Is this too US centric?]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ADDR_STATE",length="2")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="state"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="zipFirst5" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Zip code first 5. [Is this too US centric? Why split the zip code?]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ADDR_ZIP_FIRST_5",length="5")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="zipFirst5"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="zipLast4" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Zip code first 5. [Is this too US centric? Why split the zip code?]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ADDR_ZIP_LAST_4",length="4")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="zipLast4"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="countryCode" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="State code [Is this too US centric?]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ADDR_COUNTRY_CD",length="3")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="countryCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="addressCode" lowerBound="1" + eType="#//AddressCodeType" defaultValueLiteral="UN" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 		Type of address. E.g. Primary residence, contact address, shipping address, billing address, etc. Type can be 'unknown'.
 		[Need specific list of allowed values]
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="ADDR_TYPE_CD",length="2")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="addressCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="noMarketingIndicator" lowerBound="1" + eType="#//NoMarketingIndicatorType1" defaultValueLiteral="Y" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Indicates if no marketing is allowed / preferred for this contact channel.
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="NO_MARKETING_IND",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="noMarketingIndicator"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="preferredAddressIndicator" + lowerBound="1" eType="#//PreferredAddressIndicatorType" defaultValueLiteral="N" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Indicates that this is the preferred record.
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="PREFER_ADDR_IND",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="preferredAddressIndicator"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="createDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Information created date."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="CREATE_DT")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="createDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="effectiveStartDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="The date when this entry becomes effective. May or may not be the same as the create date."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="EFFECTIVE_START_DT")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="effectiveStartDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="effectiveEndDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="The date when the entry is no longer valid. NULL signifies that the entry is still active any time after the start date."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="EFFECTIVE_END_DT",nullable="true")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="effectiveEndDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLockCount" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Int" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Lock Count is used to support optimistic locking. There is a db before update trigger associated with this column."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Version
				@Column(name="ISD_LOCK_CT")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLockCount"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateUserId" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_ID - Last update user id. [Where does this id come from?]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ISD_LUPD_ID",length="8")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateUserId"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateTimeStamp" + lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Time"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_TS - Last update timestamp."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
					@Column(name="ISD_LUPD_TS", updatable = false, insertable = false)
					@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateTimeStamp"/> + </eAnnotations> + </eStructuralFeatures> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="AddressCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="addressCode_._type"/> + </eAnnotations> + <eLiterals name="PR"/> + <eLiterals name="CA" value="1"/> + <eLiterals name="SA" value="2"/> + <eLiterals name="BA" value="3"/> + <eLiterals name="UN" value="4"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="AddressCodeTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="addressCode_._type:Object"/> + <details key="baseType" value="addressCode_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="CitizenshipIndicatorType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="citizenshipIndicator_._type"/> + </eAnnotations> + <eLiterals name="Y"/> + <eLiterals name="N" value="1"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="CitizenshipIndicatorTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="citizenshipIndicator_._type:Object"/> + <details key="baseType" value="citizenshipIndicator_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EClass" name="Consumer"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="This is where information related to an individual is stored."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="	
	@Table(
	 name="CMR3601T"
	 uniqueConstraints = {	@UniqueConstraint(columnNames={"CONSUMER_SK", "DATE_OF_BIRTH"}),
	 						@UniqueConstraint(columnNames={"CONSUMER_SK"})
	 					 }	 
	 }
	)	
	
	"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="Consumer"/> + <details key="kind" value="elementOnly"/> + </eAnnotations> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="consumerSK" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Int" defaultValueLiteral="0" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="A generated key to uniquely identify a person"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="CONSUMER_SK" nullable="false")
				@Id
				@TableGenerator(
 			name="empGen",
 			allocationSize=1
 			)
 			@GeneratedValue(strategy=TABLE, generator="empGen")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="consumerID" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Int" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="The Unique Identifier for a person. This is a genrated unique id for a consumer that is unique for every consumer."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="CONSUMER_ID")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerID"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="namePrefix" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Prefix of a name such as Mr."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="NAME_PREFIX",length="6")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="namePrefix"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="nameFirst" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="First name."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="FIRST_NAME",length="12")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="nameFirst"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="nameMiddelInitial" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Middle name."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="MIDDLE_INITIAL",length="1")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="nameMiddelInitial"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="nameLast" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Last name."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="LAST_NAME",length="18")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="nameLast"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="nameSuffix" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="CEO, PhD, etc."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="NAME_SUFFIX",length="6")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="nameSuffix"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="sSN" lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Social Security Number"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
					@Column(name="SSN",length="9")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="SSN"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="dateOfBirth" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Date of birth"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="DATE_OF_BIRTH")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="dateOfBirth"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="genderCode" lowerBound="1" + eType="#//GenderCodeType" defaultValueLiteral="M" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Gender code. Male or female.
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="GENDER_CD",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="genderCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="matialStatusCode" lowerBound="1" + eType="#//MatialStatusCodeType" defaultValueLiteral="S" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Marital status code. [NOTE: valid values weren't
 			specified, so I'm going with S,M,D and W
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="MARITAL_STATUS_CD",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="matialStatusCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="citizenshipIndicator" lowerBound="1" + eType="#//CitizenshipIndicatorType" defaultValueLiteral="Y" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Citizenship indicator. 'Y' or 'N'
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="CITIZENSHIP_IND",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="citizenshipIndicator"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="disabilityIndicator" lowerBound="1" + eType="#//DisabilityIndicatorType" defaultValueLiteral="N" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Disability indicator. Denote if one is disabled.
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="DISABILITY_IND",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="disabilityIndicator"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="ethnicityCode" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Ethnicity code. [Need list of available values]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ETHNICITY_CD",length="2")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="ethnicityCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="otherID" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Other id? [Assigned by the coverage group, this is the ID number used by the employer independent of VSP]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="OTHER_ID",length="30")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="otherID"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="otherIDTypeCode" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Other ID type code. [Need list of available values]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="OTHER_ID_TYPE_CD",length="1")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="otherIDTypeCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="personalInfo" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Personal information?"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="PERSONAL_INFO",length="20")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="personalInfo"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="placeOfBirth" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Place of birth"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="PLACE_OF_BIRTH",length="30")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="placeOfBirth"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="preferCommuniationMethod" + lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" + defaultValueLiteral="" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Indicates the preferred communication method. E.G. HP=Home phone, WP=work email, etc. [Need a specific list of available values]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="PREFER_COMM_METHOD", length="2")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="preferCommuniationMethod"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLockCount" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Int" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Lock Count is used to support optimistic locking. There is a db before update trigger associated with this column."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Version
				@Column(name="ISD_LOCK_CT")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLockCount"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateUserId" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_ID - Last update user id. [Where does this id come from?]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ISD_LUPD_ID",length="8")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateUserId"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateTimeStamp" + lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Time"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_TS - Last update timestamp."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
					@Column(name="ISD_LUPD_TS", updatable = false, insertable = false)
					@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateTimeStamp"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EReference" name="dependentConsumers" upperBound="-1" + eType="#//RelatedConsumer" containment="true" resolveProxies="false"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="list of dependent consumers"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@OneToMany(mappedBy="RelatedConsumer")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="dependentConsumers"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EReference" name="addressList" upperBound="-1" + eType="#//Address" containment="true" resolveProxies="false"> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@OneToMany(mappedBy="Address")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="addressList"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EReference" name="phoneList" upperBound="-1" + eType="#//Phone" containment="true" resolveProxies="false"> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@OneToMany(mappedBy="Phone")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="phoneList"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EReference" name="emailList" upperBound="-1" + eType="#//EMailType" containment="true" resolveProxies="false"> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@OneToMany(mappedBy="EMailType")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="emailList"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EReference" name="consumerStateList" upperBound="-1" + eType="#//ConsumerState" containment="true" resolveProxies="false"> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@OneToMany(mappedBy="ConsumerState")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerStateList"/> + </eAnnotations> + </eStructuralFeatures> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="ConsumerDataSourceCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="consumerDataSourceCode_._type"/> + </eAnnotations> + <eLiterals name="_" literal=""/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="ConsumerDataSourceCodeTypeObject" + instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="consumerDataSourceCode_._type:Object"/> + <details key="baseType" value="consumerDataSourceCode_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EClass" name="ConsumerState"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="This is the state of a consumer at a particular time. Example Consumer States are: Current member; former member; prospect, suspect, etc. A person/consumer can have more that one state at any given time."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="	
	@Table(
	 name="CMR3603T"
	 uniqueConstraints = {	
	 						@UniqueConstraint(columnNames={"CMR_STATE_SK"})
	 					 }	 
	 }
	)	
	
	"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="ConsumerState"/> + <details key="kind" value="elementOnly"/> + </eAnnotations> + <eStructuralFeatures xsi:type="ecore:EReference" name="consumerSK" lowerBound="1" + eType="#//Consumer" containment="true" resolveProxies="false"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="A generated key to uniquely the parent"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@ManyToOne
 			@JoinColumn(name="CONSUMER_SK")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="consumerStateSK" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Int" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="A generated key to uniquely the record."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Id
				@Column(name="CMR_STATE_SK" nullable="false")
				@TableGenerator(
 			name="empGen",
 			allocationSize=1
 			)
 			@GeneratedValue(strategy=TABLE, generator="empGen")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerStateSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="consumerStateCode" lowerBound="1" + eType="#//ConsumerStateCodeType" defaultValueLiteral="SU" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 		Consumer State Code. The code of the consumer state. E.G. 'Suspect'. 'Prospect', 'Current Member', 'Former member'.
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="CMR_STATE_CD",length="2")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerStateCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="consumerStateStatusCode" + lowerBound="1" eType="#//ConsumerStateStatusCodeType" defaultValueLiteral="A" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
Consumer State Status Code. Indicates this status of the state for the consumer. E.g. Active or Inactive. 
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="CMR_STATE_ST_CD",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerStateStatusCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="consumerDataSourceCode" + lowerBound="1" eType="#//ConsumerDataSourceCodeType" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
			Consumer data source code. Where we get the information about this consumer.
			[Need list of valid codes]
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="CMR_DATA_SRC_CD",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerDataSourceCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="reasonCode" lowerBound="1" + eType="#//ReasonCodeType" defaultValueLiteral="" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
			Consumer State Reason Code. Why and how did the consumer get to this state. 
			[Need list of valid codes]
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="CMR_STATE_REAS_CD",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="reasonCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="startDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="The date when this entry becomes effective. May or may not be the same as the create date."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="CMR_STATE_START_DT")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="startDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="endDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="The date when the entry is no longer valid. NULL signifies that the entry is still active any time after the start date."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="CMR_STATE_END_DT",nullable="true")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="endDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLockCount" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Int" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Lock Count is used to support optimistic locking. There is a db before update trigger associated with this column."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Version
				@Column(name="ISD_LOCK_CT")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLockCount"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateUserId" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_ID - Last update user id. [Where does this id come from?]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ISD_LUPD_ID",length="8")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateUserId"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateTimeStamp" + lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Time"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_TS - Last update timestamp."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
					@Column(name="ISD_LUPD_TS", updatable = false, insertable = false)
					@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateTimeStamp"/> + </eAnnotations> + </eStructuralFeatures> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="ConsumerStateCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="consumerStateCode_._type"/> + </eAnnotations> + <eLiterals name="SU"/> + <eLiterals name="PR" value="1"/> + <eLiterals name="CM" value="2"/> + <eLiterals name="FM" value="3"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="ConsumerStateCodeTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="consumerStateCode_._type:Object"/> + <details key="baseType" value="consumerStateCode_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="ConsumerStateStatusCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="consumerStateStatusCode_._type"/> + </eAnnotations> + <eLiterals name="A"/> + <eLiterals name="I" value="1"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="ConsumerStateStatusCodeTypeObject" + instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="consumerStateStatusCode_._type:Object"/> + <details key="baseType" value="consumerStateStatusCode_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="DisabilityIndicatorType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="disabilityIndicator_._type"/> + </eAnnotations> + <eLiterals name="Y"/> + <eLiterals name="N" value="1"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="DisabilityIndicatorTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="disabilityIndicator_._type:Object"/> + <details key="baseType" value="disabilityIndicator_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="EmailCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="emailCode_._type"/> + </eAnnotations> + <eLiterals name="HO"/> + <eLiterals name="WO" value="1"/> + <eLiterals name="UN" value="2"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="EmailCodeTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="emailCode_._type:Object"/> + <details key="baseType" value="emailCode_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EClass" name="EMailType"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="The information about a person's email."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="	
	@Table(
	 name="CMR3607T"
	 uniqueConstraints = {	@UniqueConstraint(columnNames={"EMAIL_SK"})
	 					 }	 
	 }
	)	
	
	"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="EMailType"/> + <details key="kind" value="elementOnly"/> + </eAnnotations> + <eStructuralFeatures xsi:type="ecore:EReference" name="consumerSK" lowerBound="1" + eType="#//Consumer" containment="true" resolveProxies="false"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="A generated key to uniquely the parent"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@ManyToOne
 			@JoinColumn(name="CONSUMER_SK")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="emailSK" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Int" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="A generated key to uniquely the record."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Id
				@Column(name="EMAIL_SK" nullable="false")
				@TableGenerator(
 			name="empGen",
 			allocationSize=1
 			)
 			@GeneratedValue(strategy=TABLE, generator="empGen")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="emailSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="emailCode" lowerBound="1" + eType="#//EmailCodeType" defaultValueLiteral="UN" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 		Type of email. E.g. Home, Work, etc. Type can be 'unknown'.
 		[Need specific list of allowed values]
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="EMAIL_TYPE_CD",length="2")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="emailCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="noMarketingIndicator" lowerBound="1" + eType="#//NoMarketingIndicatorType" defaultValueLiteral="Y" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Indicates if no marketing is allowed / preferred for this contact channel.
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="NO_MARKETING_IND",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="noMarketingIndicator"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="preferredEMailIndicator" + lowerBound="1" eType="#//PreferredEMailIndicatorType" defaultValueLiteral="N" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Indicates that this is the preferred record.
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="PREFER_EMAIL_IND",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="preferredEMailIndicator"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="emailAddress" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Actual e-mail address"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="EMAIL_ADDR",length="50")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="emailAddress"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="createDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Information created date."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="CREATE_DT")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="createDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="effectiveStartDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="The date when this entry becomes effective. May or may not be the same as the create date."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="EFFECTIVE_START_DT")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="effectiveStartDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="effectiveEndDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="The date when the entry is no longer valid. NULL signifies that the entry is still active any time after the start date."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="EFFECTIVE_END_DT",nullable="true")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="effectiveEndDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLockCount" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Int" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Lock Count is used to support optimistic locking. There is a db before update trigger associated with this column."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Version
				@Column(name="ISD_LOCK_CT")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLockCount"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateUserId" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_ID - Last update user id. [Where does this id come from?]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ISD_LUPD_ID",length="8")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateUserId"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateTimeStamp" + lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Time"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_TS - Last update timestamp."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
					@Column(name="ISD_LUPD_TS", updatable = false, insertable = false)
					@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateTimeStamp"/> + </eAnnotations> + </eStructuralFeatures> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="GenderCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="genderCode_._type"/> + </eAnnotations> + <eLiterals name="M"/> + <eLiterals name="F" value="1"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="GenderCodeTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="genderCode_._type:Object"/> + <details key="baseType" value="genderCode_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="MatialStatusCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="matialStatusCode_._type"/> + </eAnnotations> + <eLiterals name="M"/> + <eLiterals name="D" value="1"/> + <eLiterals name="W" value="2"/> + <eLiterals name="S" value="3"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="MatialStatusCodeTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="matialStatusCode_._type:Object"/> + <details key="baseType" value="matialStatusCode_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EClass" name="Member"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Member is one who has VSP benefit, usually working for a client who has a contract with VSP. Member also includes dependents of the subscriber. A person can have multiple active 'membership' at the same time"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="	
	@Table(
	 name="CMR3604T"
	 uniqueConstraints = {	
	 						@UniqueConstraint(columnNames={"CMR_STATE_SK"})
	 					 }	 
	 }
	)	
	
	"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="Member"/> + <details key="kind" value="elementOnly"/> + </eAnnotations> + <eStructuralFeatures xsi:type="ecore:EReference" name="consumerStateSK" lowerBound="1" + eType="#//ConsumerState" containment="true" resolveProxies="false"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="A generated key to uniquely the parent"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@ManyToOne
 			@JoinColumn(name="CMR_STATE_SK")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerStateSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="clientId" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="CLIENT_ID. Uniquely identify a client."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="CLIENT_ID",length="8")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="clientId"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="divisionId" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Client Division."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="CLIENT_DIVISION_ID",length="4")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="divisionId"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="classId" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Client Class."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="CLIENT_CLASS_ID",length="4")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="classId"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EReference" name="consumerSK" lowerBound="1" + eType="#//Consumer" containment="true" resolveProxies="false"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="[Why do I need this if I have subscriber SK]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@ManyToOne
 			@JoinColumn(name="CONSUMER_SK")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EReference" name="subscriberSK" lowerBound="1" + eType="#//Consumer" containment="true" resolveProxies="false"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Subsber_SK. If this is a dependent record, this field will point to the sk of the subscribing member record (CMR_STATE_SK). If this is the subscriber himself/herself, the column will be 0.
				[This as a char9 doesn't make sense to me. Is it actually a surrogate key?]
				"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@ManyToOne
 			@JoinColumn(name="SUBSCRIBER_SK")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="subscriberSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="clientMemberId" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Client member id. Subscriber_ID if it is a subscriber. If dit is a dependent, number assigned by the client and can be NULL."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="CLIENT_MBR_ID",length="9",nullable="true")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="clientMemberId"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="memberRelationshipCode" + lowerBound="1" eType="#//MemberRelationshipCodeType" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Member relationship code.
 			[Need list of values]
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="MEMBER_RELATE_CD",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="memberRelationshipCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="expandedMemberId" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Expanded member id. Subscriber or dependent id that is supplied by the Client and not 9 digit numeric."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="EXPANDED_MBR_ID",length="30",nullable="true")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="expandedMemberId"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="startDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Effective start date of membership."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="EFFECTIVE_START_DT")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="startDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="endDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Effective end date of membership."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="EFFECTIVE_END_DT",nullable="true")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="endDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="memberStatusCode" lowerBound="1" + eType="#//MemberStatusCodeType" defaultValueLiteral="A" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
?? Active, Inactive? 
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="MEMBER_STATUS_CD",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="memberStatusCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="terminationReasonCode" + lowerBound="1" eType="#//TerminationReasonCodeType" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
			Consumer State Reason Code. Why and how did the consumer get to this state. 
			[Need list of valid codes]
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="MBR_TERM_REASON_CD",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="terminationReasonCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="productSuspended" lowerBound="1" + eType="#//ProductSuspendedType" defaultValueLiteral="N" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Indicate if the client is paying its bill (?) (From object model.)
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="PRODUCT_SUSP_IND",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="productSuspended"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="memberCoverageCode" lowerBound="1" + eType="#//MemberCoverageCodeType" defaultValueLiteral="O" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Member coverage code. Indicate what does a member has such as Member Only; Member plus family; member plus one; Member plus children, etc.
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="MBR_COVERAGE_CD",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="memberCoverageCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="billingEntity" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="[Talk to model team]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="BILLING_ENTITY",length="10",nullable="true")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="billingEntity"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="relationshipStartDate" + lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Relationship (member to subscriber) start date."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="RELATE_START_DT")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="relationshipStartDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="relationshipEndDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Relationship (member to subscriber) end date. NULL signifies active relationship."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="RELATE_END_DT",nullable="true")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="relationshipEndDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLockCount" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Int" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Lock Count is used to support optimistic locking. There is a db before update trigger associated with this column."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Version
				@Column(name="ISD_LOCK_CT")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLockCount"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateUserId" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_ID - Last update user id. [Where does this id come from?]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ISD_LUPD_ID",length="8")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateUserId"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateTimeStamp" + lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Time"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_TS - Last update timestamp."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
					@Column(name="ISD_LUPD_TS", updatable = false, insertable = false)
					@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateTimeStamp"/> + </eAnnotations> + </eStructuralFeatures> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="MemberCoverageCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="memberCoverageCode_._type"/> + </eAnnotations> + <eLiterals name="O"/> + <eLiterals name="F" value="1"/> + <eLiterals name="_1" value="2" literal="1"/> + <eLiterals name="C" value="3"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="MemberCoverageCodeTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="memberCoverageCode_._type:Object"/> + <details key="baseType" value="memberCoverageCode_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="MemberRelationshipCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="memberRelationshipCode_._type"/> + </eAnnotations> + <eLiterals name="_" literal=""/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="MemberRelationshipCodeTypeObject" + instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="memberRelationshipCode_._type:Object"/> + <details key="baseType" value="memberRelationshipCode_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="MemberStatusCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="memberStatusCode_._type"/> + </eAnnotations> + <eLiterals name="A"/> + <eLiterals name="I" value="1"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="MemberStatusCodeTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="memberStatusCode_._type:Object"/> + <details key="baseType" value="memberStatusCode_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="NoMarketingIndicatorType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="noMarketingIndicator_._type"/> + </eAnnotations> + <eLiterals name="Y"/> + <eLiterals name="N" value="1"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="NoMarketingIndicatorType1"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="noMarketingIndicator_._1_._type"/> + </eAnnotations> + <eLiterals name="Y"/> + <eLiterals name="N" value="1"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="NoMarketingIndicatorType2"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="noMarketingIndicator_._2_._type"/> + </eAnnotations> + <eLiterals name="Y"/> + <eLiterals name="N" value="1"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="NoMarketingIndicatorTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="noMarketingIndicator_._type:Object"/> + <details key="baseType" value="noMarketingIndicator_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="NoMarketingIndicatorTypeObject1" + instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="noMarketingIndicator_._1_._type:Object"/> + <details key="baseType" value="noMarketingIndicator_._1_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="NoMarketingIndicatorTypeObject2" + instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="noMarketingIndicator_._2_._type:Object"/> + <details key="baseType" value="noMarketingIndicator_._2_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EClass" name="Phone"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Information about a phone number and it type"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="	
	@Table(
	 name="CMR3606T"
	 uniqueConstraints = {	@UniqueConstraint(columnNames={"PHONE_SK"})
	 					 }	 
	 }
	)	
	
	"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="Phone"/> + <details key="kind" value="elementOnly"/> + </eAnnotations> + <eStructuralFeatures xsi:type="ecore:EReference" name="consumerSK" lowerBound="1" + eType="#//Consumer" containment="true" resolveProxies="false"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="A generated key to uniquely the parent"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@ManyToOne
 			@JoinColumn(name="CONSUMER_SK")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="phoneSK" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Int" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="A generated key to uniquely the record."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Id
				@Column(name="PHONE_SK" nullable="false")
				@TableGenerator(
 			name="empGen",
 			allocationSize=1
 			)
 			@GeneratedValue(strategy=TABLE, generator="empGen")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="phoneSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="phoneCode" lowerBound="1" + eType="#//PhoneCodeType" defaultValueLiteral="UN" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 		Type of phone number. E.g. Home, cell, fax, etc. Type can be 'unknown'.
 		[Need specific list of allowed values]
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="PHONE_TYPE_CD",length="2")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="phoneCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="noMarketingIndicator" lowerBound="1" + eType="#//NoMarketingIndicatorType2" defaultValueLiteral="Y" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Indicates if no marketing is allowed / preferred for this contact channel.
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="NO_MARKETING_IND",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="noMarketingIndicator"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="preferredPhoneIndicator" + lowerBound="1" eType="#//PreferredPhoneIndicatorType" defaultValueLiteral="N" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Indicates that this is the preferred record.
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="PREFER_PHONE_IND",length="1")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="preferredPhoneIndicator"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="countryCode" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="country code"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="PHONE_COUNTRY_CD",length="3")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="countryCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="areaCode" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="phone area code"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="PHONE_AREA_CD",length="3")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="areaCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="phoneNumber" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="phone number without area code. "/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="PHONE_NBR",length="7")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="phoneNumber"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="phoneExtension" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String" defaultValueLiteral="" + unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Phone's extension number"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="PHONE_EXTENSION",length="4")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="phoneExtension"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="createDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Information created date."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="CREATE_DT")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="createDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="effectiveStartDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="The date when this entry becomes effective. May or may not be the same as the create date."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="EFFECTIVE_START_DT")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="effectiveStartDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="effectiveEndDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="The date when the entry is no longer valid. NULL signifies that the entry is still active any time after the start date."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="EFFECTIVE_END_DT",nullable="true")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="effectiveEndDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLockCount" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Int" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Lock Count is used to support optimistic locking. There is a db before update trigger associated with this column."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Version
				@Column(name="ISD_LOCK_CT")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLockCount"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateUserId" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_ID - Last update user id. [Where does this id come from?]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ISD_LUPD_ID",length="8")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateUserId"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateTimeStamp" + lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Time"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_TS - Last update timestamp."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
					@Column(name="ISD_LUPD_TS", updatable = false, insertable = false)
					@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateTimeStamp"/> + </eAnnotations> + </eStructuralFeatures> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="PhoneCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="phoneCode_._type"/> + </eAnnotations> + <eLiterals name="HO"/> + <eLiterals name="WO" value="1"/> + <eLiterals name="CE" value="2"/> + <eLiterals name="FA" value="3"/> + <eLiterals name="UN" value="4"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="PhoneCodeTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="phoneCode_._type:Object"/> + <details key="baseType" value="phoneCode_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="PreferredAddressIndicatorType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="preferredAddressIndicator_._type"/> + </eAnnotations> + <eLiterals name="Y"/> + <eLiterals name="N" value="1"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="PreferredAddressIndicatorTypeObject" + instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="preferredAddressIndicator_._type:Object"/> + <details key="baseType" value="preferredAddressIndicator_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="PreferredEMailIndicatorType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="preferredEMailIndicator_._type"/> + </eAnnotations> + <eLiterals name="Y"/> + <eLiterals name="N" value="1"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="PreferredEMailIndicatorTypeObject" + instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="preferredEMailIndicator_._type:Object"/> + <details key="baseType" value="preferredEMailIndicator_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="PreferredPhoneIndicatorType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="preferredPhoneIndicator_._type"/> + </eAnnotations> + <eLiterals name="Y"/> + <eLiterals name="N" value="1"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="PreferredPhoneIndicatorTypeObject" + instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="preferredPhoneIndicator_._type:Object"/> + <details key="baseType" value="preferredPhoneIndicator_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="ProductSuspendedType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="productSuspended_._type"/> + </eAnnotations> + <eLiterals name="Y"/> + <eLiterals name="N" value="1"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="ProductSuspendedTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="productSuspended_._type:Object"/> + <details key="baseType" value="productSuspended_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="ReasonCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="reasonCode_._type"/> + </eAnnotations> + <eLiterals name="_" literal=""/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="ReasonCodeTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="reasonCode_._type:Object"/> + <details key="baseType" value="reasonCode_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EClass" name="RelatedConsumer"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="This table provide the many to many relationship between consumers that are related."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="	
	@Table(
	 name="CMR3602T"
	 uniqueConstraints = {	@UniqueConstraint(columnNames={"CONSUMER_SK", "DATE_OF_BIRTH"}),
	 						@UniqueConstraint(columnNames={"CONSUMER_SK"})
	 					 }	 
	 }
	)	
	
	"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="RelatedConsumer"/> + <details key="kind" value="elementOnly"/> + </eAnnotations> + <eStructuralFeatures xsi:type="ecore:EReference" name="consumerSK" lowerBound="1" + eType="#//Consumer" containment="true" resolveProxies="false"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="A generated key to uniquely identify a person"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@ManyToOne
 			@JoinColumn(name="CONSUMER_SK")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="consumerSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EReference" name="relatedConsumerSK" lowerBound="1" + eType="#//Consumer" containment="true" resolveProxies="false"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="The related comsumer SK. The ID of the related consumer."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@OneToOne(cascade = CascadeType.ALL)
 			@JoinColumn(name="RELATED_CMR_SK")				
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="relatedConsumerSK"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="relationshipCode" lowerBound="1" + eType="#//RelationshipCodeType" defaultValueLiteral="SP" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="
 			Consumer relationship code. The relationship between the related person to the base person. 
 			It can be spouse, child, domestic partner, roommate, etc. [Need specific two character codes]
 		"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
 			@Column(name="CMR_RELATE_CD",length="2")
 		"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="relationshipCode"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="relationStartDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Relationship start date."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="RELATE_START_DT")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="relationStartDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="relationEndDate" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Date"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Relationship end date. NULL signifies active relationship."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Column(name="RELATE_END_DT",nullable="true")
				@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="relationEndDate"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLockCount" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Int" unsettable="true"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="Lock Count is used to support optimistic locking. There is a db before update trigger associated with this column."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
				@Version
				@Column(name="ISD_LOCK_CT")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLockCount"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateUserId" lowerBound="1" + eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//String"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_ID - Last update user id. [Where does this id come from?]"/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="@Column(name="ISD_LUPD_ID",length="8")"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateUserId"/> + </eAnnotations> + </eStructuralFeatures> + <eStructuralFeatures xsi:type="ecore:EAttribute" name="isdLastUpdateTimeStamp" + lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Time"> + <eAnnotations source="http://www.eclipse.org/emf/2002/GenModel"> + <details key="documentation" value="ISD_LUPD_TS - Last update timestamp."/> + </eAnnotations> + <eAnnotations source="teneo.jpa"> + <details key="appinfo" value="
					@Column(name="ISD_LUPD_TS", updatable = false, insertable = false)
					@Type(type="timestamp")
				"/> + </eAnnotations> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="kind" value="element"/> + <details key="name" value="isdLastUpdateTimeStamp"/> + </eAnnotations> + </eStructuralFeatures> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="RelationshipCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="relationshipCode_._type"/> + </eAnnotations> + <eLiterals name="SP"/> + <eLiterals name="CH" value="1"/> + <eLiterals name="DP" value="2"/> + <eLiterals name="RM" value="3"/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="RelationshipCodeTypeObject" instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="relationshipCode_._type:Object"/> + <details key="baseType" value="relationshipCode_._type"/> + </eAnnotations> + </eClassifiers> + <eClassifiers xsi:type="ecore:EEnum" name="TerminationReasonCodeType"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="terminationReasonCode_._type"/> + </eAnnotations> + <eLiterals name="_" literal=""/> + </eClassifiers> + <eClassifiers xsi:type="ecore:EDataType" name="TerminationReasonCodeTypeObject" + instanceClassName="org.eclipse.emf.common.util.Enumerator"> + <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData"> + <details key="name" value="terminationReasonCode_._type:Object"/> + <details key="baseType" value="terminationReasonCode_._type"/> + </eAnnotations> + </eClassifiers> +</ecore:EPackage> |