ISO 15000-5 CCT Compliance
- Serm Kulvatunyou
OAGIS is based on Core Data Type spec. version 3.01. This is in the CCTS 3.0 series.
ISO 15000-5 uses Core Component Type (CCT) defined within the 15000-5 itself. This is in the CCTS 2.0 series.
To merge the two, we will try to make CDTs based on CCTs. We need to put CCTs into Score DB and make CDTs based on them. Or we will merge CCTs and CDTs.
This table try to Merge CDTs and CCTs
DT table
For CCTs that have map to CDTs retain the CDT data in the DT table. Populate CCTs that have no map to CDTs as follow. Actually there is only one CCT which is the “Numeric. Type”.
guid = generate one.
DT.type = 0.
DT.version_num = “1.0”
DT.previous_version_dt_id = Leave blank
Use first token of CCT DEN for DT.data_type_term column.
DT.qualifier = Blank; DT.based_dt_sc_id = blank.
DT.den = take from the table above.
DT.content_component_den = same as DT.data_type_term + “. Content”.
DT.Definition = definition in the CCT table above.
content_component_definition = DT.Definition
The rest of the columns are the same as in section 4.1.1.9.2 in the design doc.
Other DT related tables
For the cdt_awd_pri and cdt_awd_pri_xps_type_map of “Numeric. Type” uses the same as those of the “Number. Type” CDT.
For DT_SC table
SCs that share with those of CDTs, retain CDT data, except that an object_class_term column needs to be added to the DT_SC table. Fill the column with the CDT’s data type term.
SCs that are added.
Guid = generate a new one.
object_class_term, property_term, and representation_term are as indicated in the table below.
definition = blank.
owner_dt_id = dt.dt_id of the CDT, to which the SC is added to.
cardinality_min = 0
dardinality_max = 1
based_dt_sc_id = blank
Follow the same logic as in the design doc for the cdt_sc_awd_pri and cdt_sc_awd_pri_xps_type_map. The table below also summarize cdt_sc_awd_pri assignment.
Other To Do’s:
Need to check whether any of the added SC is duplicate with any SC added to a BDT.
Existing BDTs derived from these CDTs will have to set max cardinality of the SCs used only by CCT to 0.
Legends for the table below
Some CCT component DENs have only two token. We need to make it consistently 3 tokens. These are highlighted with Bold-Italic font in the Resulting DEN column below, because the DEN is a little off from the spec. I looked at the spec, there is no DEN rule for CCT’s SC. CC DEN’s rule does not talk about truncation in duplicate property and representation terms. There is only mention of such truncation in the ASBIE and BBIE name as follows. “For Basic and Association Business Information Entities, if the Property Term is equal to the third component of the Dictionary Entry Name, and the Property Term is not qualified, the Property Term shall be removed from the Dictionary Entry Name.” There is no talk of truncation in DEN in the CCTS 3.0 either. I think truncation only exists in the serialization.
Rows with no background are SC to add to the corresponding CDT. BDTs based on the CDT have to set max cardinality of SCs in these rows to zero.
Rows with green background are existing CDT SCs that don’t map to any CCT component. These are shown for reference only.
Rows with yellow background are existing CDT SCs that map to CCT components. I.e., there is no need to add this SC to existing CDT SCs.
Type | SC |
| Resulting DEN | Remark |
|---|---|---|---|---|
Amount. Type merged to Amount. Type CDT | Amount Currency. Identifier
| object_class_term=”Amount Currency” property_term=”Identifier” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Amount Currency. Identifier. Identifier | Or we can say that the resulting DEN is “Amount Current. Identifier” as in spec by saying that the duplicated token is truncated. Or we can treat this as CCT errata. |
| Amount Currency. Code List Version. Identifier | object_class_term=”Amount Currency” property_term=”Code List Version” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Amount Currency. Code List Version. Identifier |
|
| Amount. Currency. Code |
|
|
|
Binary Object. Type merged to Binary Object. Type CDT | Binary Object. Format. Text | object_class_term=”Binary Object” property_term=”Format” representation_term=”Text” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on String | Binary Object. Format. Text |
|
| Binary Object. Mime. Code |
|
| It is MIME in CDT. |
| Binary Object. Encoding. Code | object_class_term=”Binary Object” property_term=”Encoding” representation_term=”Code” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Binary Object. Encoding. Code |
|
| Binary Object. Character Set. Code |
|
|
|
| Binary Object. Uniform Resource. | object_class_term=”Binary Object” property_term=”Uniform Resource Identifier” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Binary Object. Uniform Resource. | Property term is truncated in DEN |
| Binary Object. Filename. Text | object_class_term=”Binary Object” property_term=”Filename” representation_term=”Text” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on String | Binary Object. Filename. Text |
|
| Binary Object. Filename. Name |
|
|
|
Code. Type merged to Code. Type CDT | Code List. Identifier | object_class_term=”Code List” property_term=”Identifier” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Code List. Identifier. Identifier | Or we can say that the resulting DEN is “Code List. Identifier” as in the spec by saying that the duplicated token is truncated. Or we can treat this as CCT errata. |
| Code. List. Identifier |
|
| Or we can map this to the SC above, but the Resulting DEN will be different from the CCT spec. We cannot use the CCT DEN for the CDT b/c serialization rule will screw up. |
| Code List. Agency. Identifier | object_class_term=”Code List” property_term=”Agency” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Code List. Agency. Identifier |
|
| Code. List Agency. Identifier |
|
| Or we can map this to the SC above, but the Resulting DEN will be different from the CCT spec. |
| Code List. Agency Name. Text | object_class_term=”Code List” property_term=”Agency Name” representation_term=”Text” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on String | Code List. Agency Name. Text |
|
| Code List. Name. Text | object_class_term=”Code List” property_term=”Name” representation_term=”Text” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on String | Code List. Name. Text |
|
| Code List. Version. Identifier | object_class_term=”Code List” property_term=”Version” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Code List. Version. Identifier |
|
| Code. Name. Text | object_class_term=”Code” property_term=”Name” representation_term=”Text” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on String | Code. Name. Text |
|
| Language. Identifier | object_class_term=”Language” property_term=”Identifier” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Language. Identifier. Identifier | Or we can say that the resulting DEN is “Language. Identifier” as in the spec by saying that the duplicated token is truncated. Or we can treat this as CCT errata. |
| Code List. Uniform Resource. Identifier | object_class_term=”Code List” property_term=”Uniform Resource Identifier” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Code List. Uniform Resource. Identifier |
|
| Code List Scheme. Uniform Resource. | object_class_term=”Code List Scheme” property_term=”Uniform Resource Identifier” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Code List Scheme. Uniform Resource. |
|
| Code. List Version. Identifier |
|
|
|
Date Time. | Date Time. Format. Text | object_class_term=”Date Time” property_term=”Format” representation_term=”Text” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on String | Date Time. Format. Text |
|
| Date Time. Time Zone. Code |
|
|
|
| Date Time. Daylight Saving. Indicator |
|
|
|
Identifier. Type merged with Identifier. Type CDT
| Identification Scheme. Identifier | object_class_term=”Identification Scheme” property_term=”Identifier” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Identification Scheme. Identifier. Identifier | Or we can say that the resulting DEN is “Identification Scheme. Identifier” as in the spec by saying that the duplicated token is truncated. Or we can treat this as CCT errata. |
| Identifier. Scheme. Identifier |
|
|
|
| Identification Scheme Agency. Identifier | object_class_term=”Identification Scheme” property_term=”Agency” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Identification Scheme Agency. Identifier |
|
| Identifier. Scheme Agency. Identifier |
|
|
|
| Identification Scheme. Agency Name. | object_class_term=”Identification Scheme” property_term=”Agency Name” representation_term=”Text” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on String | Identification Scheme. Agency Name. |
|
| Identification Scheme. Version. | object_class_term=”Identification Scheme” property_term=”Version” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Identification Scheme. Version. |
|
| Identifier. Scheme Version. Identifier |
|
|
|
| Identification Scheme Data. Uniform | object_class_term=”Identification Scheme Data” property_term=”Uniform Resource Identifier” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Identification Scheme Data. Uniform | The property term got truncated. |
| Identification Scheme. Uniform | object_class_term=”Identification Scheme” property_term=”Uniform Resource Identifier” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Identification Scheme. Uniform | The property term got truncated. |
Indicator. | Indicator. Format. Text | object_class_term=”Indicator” property_term=”Format” representation_term=”Text” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on String | Indicator. Format. Text |
|
Measure. | Measure Unit. Code | object_class_term=”Measure Unit” property_term=”Code” representation_term=”Code” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Measure Unit. Code. Code | Or we can say that the resulting DEN is “Measure Unit. Code” as in spec by saying that the duplicated token is truncated. Or we can treat this as CCT errata. |
| Measure. Unit. Code |
|
|
|
| Measure Unit. Code List Version. | object_class_term=”Measure Unit” property_term=”Code List Version” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token |
|
|
Numeric. | Numeric. Format. Text | object_class_term=”Numeric” property_term=”Format” representation_term=”Text” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on String | Numeric. Format. Text | CCT has no map to CDT |
Quantity. | Quantity. Unit. Code |
|
|
|
| Quantity Unit. Code List. Identifier | object_class_term=”Quantity Unit” property_term=”Code List” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token |
|
|
| Quantity Unit. Code List Agency. Identifier | object_class_term=”Quantity Unit” property_term=”Code List Agency” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token |
|
|
| Quantity Unit. Code List Agency Name. Text | object_class_term=”Quantity Unit” property_term=”Code List Agency Name” representation_term=”Text” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on String |
|
|
Text. Type merged with Text. Type CDT | Language. Identifier | object_class_term=”Language” property_term=”Identifier” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Language. Identifier. Identifier | Or we can say that the resulting DEN is “Language. Identifier. Identifier” as in spec by saying that the duplicated token is truncated. Or we can treat this as CCT errata |
| Language. Locale. Identifier | object_class_term=”Language” property_term=”Locale” representation_term=”Identifier” cdt_pri_id=NormalizedString, String, Token is_default= Set to true on Token | Language. Locale. Identifier |
|
| Text. Language. Code |
|
|
|