List of schema changes Change Type AttributeCode Type ClassCodeList WR Comments CHANGE regulationTypeCode Attribute Changed datatype name to regulationTypeCode CHANGE certificationValue ID: 575437
Download Presentation The PPT/PDF document "Schema Changes: Based on Approved Errata..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Schema Changes: Based on Approved Errata.Slide2
List of schema changes.
Change Type
Attribute/Code
Type
Class/CodeList
WR
Comments
CHANGE
regulationTypeCode
Attribute
Changed datatype name to regulationTypeCode
CHANGE
certificationValue
Attribute
Certification
14-207
Changed datatype to string
CHANGE
targetConsumerGender
Attribute
TargetConsumer
Changed Datatype in schema to TargetConsumerGenderCode
CHANGE
NonfoodIngredientModule
Attribute
NonfoodIngredient
15-148
String {1..500}
CHANGE
trackTime
Attribute
DistributionMediaTrackInformation
15-077
Changed to string {1..70}
CHANGE
productActivityRegionDescription
Attribute
ProductActivityDetails
15-047
Changed to Description500
ADD
packagingTypeDescription
Attribute
Packaging
15-045
Added Back Into Schema
CHANGE
countryOfOriginStatement
Attribute
PlaceOfProductActivity
14-154
Changed to Description500
CHANGE
provenanceStatement
Attribute
PlaceOfProductActivity
14-154
Changed to Description500
CHANGE
Class
AdditionalTradeItemDimensions
15-042
Class Name was
TradeItemDimensionsSlide3
Changed Data Type
Note: changed data type name to match attribute. Slide4
Change of
CertificationValue
DataType
Note:
certificationValue
changed to string {1..200}Slide5
Note:
nonFoodIngredientName
changed to 500 Slide6
Note:
Tracktime
changed to string (1..70).Slide7
Note: Changed all descriptions in this model to Description500Slide8
Note: Added
packagingTypeDescription
to end of attributes in order not to change sequence of attributes. Slide9
Note: Change to class nameSlide10
Note: Change to class nameSlide11
Note: Change to schema only, model was correct. Changes from
GenderCode
embedded in schema to
TargetConsumerGenderCode
which is not in schema and includes the value unisex.Slide12
Note:
Changed attribute name and data types to match 2.8Slide13
MJR 15-126
MjR
Schema Build - We need to insure that the September Schema Build remains the same and attributes are not moved.
For example in the schema today attributes are not sorted alphabetically. Should the new schema now sort these, then it will be a huge undertaking for Data Pools to remap.
See attached images to show what it looks like today.Instructions being sent to schema developers to not change current sequence of attributes.