932 lines
22 KiB
Plaintext
932 lines
22 KiB
Plaintext
table Dim_PackInfo
|
|
lineageTag: f420be02-8dc1-467f-8e0e-a8231e8b72e6
|
|
|
|
column PACK_COD
|
|
dataType: string
|
|
lineageTag: 2fe29ac4-ec3b-42cb-86ce-17e060fec44f
|
|
summarizeBy: none
|
|
sourceColumn: PACK_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PACK_DES
|
|
dataType: string
|
|
lineageTag: 58063e41-a010-4665-b743-4555f3a1abb4
|
|
summarizeBy: none
|
|
sourceColumn: PACK_DES
|
|
|
|
changedProperty = SortByColumn
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PACK_LCH
|
|
dataType: string
|
|
lineageTag: d93fc95d-29c0-4675-88cc-e26d87032d6d
|
|
summarizeBy: none
|
|
sourceColumn: PACK_LCH
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_COD
|
|
dataType: string
|
|
lineageTag: fb0d1cb1-2984-456e-8707-4cfebe4169ec
|
|
summarizeBy: none
|
|
sourceColumn: PROD_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_DES
|
|
dataType: string
|
|
lineageTag: 703c6908-b2f7-4b8e-a565-1d91e603dc0f
|
|
summarizeBy: none
|
|
sourceColumn: PROD_DES
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_DES_C
|
|
dataType: string
|
|
lineageTag: 254e868a-b297-4e27-b186-744ecb658faf
|
|
summarizeBy: none
|
|
sourceColumn: PROD_DES_C
|
|
|
|
changedProperty = SortByColumn
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column CMPS_COD
|
|
dataType: string
|
|
lineageTag: b65462b8-5280-4819-8036-14d112376e9f
|
|
summarizeBy: none
|
|
sourceColumn: CMPS_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column CMPS_DES
|
|
dataType: string
|
|
lineageTag: 6cac86f3-c1f3-407e-9ae0-eceb64695b7b
|
|
summarizeBy: none
|
|
sourceColumn: CMPS_DES
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column CMPS_DES_C
|
|
dataType: string
|
|
lineageTag: eff3f2c2-8119-4111-af35-5f8174133e2a
|
|
summarizeBy: none
|
|
sourceColumn: CMPS_DES_C
|
|
|
|
changedProperty = SortByColumn
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC1_COD
|
|
dataType: string
|
|
lineageTag: 5de4d0d0-f003-4024-a369-081d4a5fd080
|
|
summarizeBy: none
|
|
sourceColumn: ATC1_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC1_DES
|
|
dataType: string
|
|
lineageTag: f02d78fd-d5df-4397-a894-8f114424385d
|
|
summarizeBy: none
|
|
sourceColumn: ATC1_DES
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC1_DES_C
|
|
dataType: string
|
|
lineageTag: 7cbbfb49-2ca2-406d-8c00-fddf33b2c6e4
|
|
summarizeBy: none
|
|
sourceColumn: ATC1_DES_C
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC2_COD
|
|
dataType: string
|
|
lineageTag: d908ea98-f389-43ab-8966-2706f25c9d5a
|
|
summarizeBy: none
|
|
sourceColumn: ATC2_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC2_DES
|
|
dataType: string
|
|
lineageTag: 688a385b-1d0c-45c6-a413-d7be0b988afe
|
|
summarizeBy: none
|
|
sourceColumn: ATC2_DES
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC2_DES_C
|
|
dataType: string
|
|
lineageTag: ecef3c5f-149f-46c1-be65-71afea59b523
|
|
summarizeBy: none
|
|
sourceColumn: ATC2_DES_C
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC3_COD
|
|
dataType: string
|
|
lineageTag: 8a726f1a-32b9-42ef-9f29-09c244c03cf3
|
|
summarizeBy: none
|
|
sourceColumn: ATC3_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC3_DES
|
|
dataType: string
|
|
lineageTag: 4ef7d78b-b807-4d0d-ae87-36aed8c6ff6d
|
|
summarizeBy: none
|
|
sourceColumn: ATC3_DES
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC3_DES_C
|
|
dataType: string
|
|
lineageTag: 98f4fec7-f457-4b07-ac94-b07ddd3c88fc
|
|
summarizeBy: none
|
|
sourceColumn: ATC3_DES_C
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC4_COD
|
|
dataType: string
|
|
lineageTag: 704ef81d-1d26-44c7-9d9d-3ac119e628c7
|
|
summarizeBy: none
|
|
sourceColumn: ATC4_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC4_DES
|
|
dataType: string
|
|
lineageTag: 4363ec7f-9e85-4090-a928-20af2c065002
|
|
summarizeBy: none
|
|
sourceColumn: ATC4_DES
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC4_DES_C
|
|
dataType: string
|
|
lineageTag: 49efe84f-b9c1-44fb-bb66-6aac7e3cee31
|
|
summarizeBy: none
|
|
sourceColumn: ATC4_DES_C
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP1_COD
|
|
dataType: string
|
|
lineageTag: b3fdbbd8-cc0e-44a2-8bc3-74de2b77e64a
|
|
summarizeBy: none
|
|
sourceColumn: APP1_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP1_DES
|
|
dataType: string
|
|
lineageTag: 240c79e5-5336-42c4-ad35-ea1e615b128d
|
|
summarizeBy: none
|
|
sourceColumn: APP1_DES
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP1_DES_C
|
|
dataType: string
|
|
lineageTag: dd56abcc-b68f-4b97-b1e2-ff1d292c8656
|
|
summarizeBy: none
|
|
sourceColumn: APP1_DES_C
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP2_COD
|
|
dataType: string
|
|
lineageTag: dcf72800-3021-4ad2-a70f-f838a6e68012
|
|
summarizeBy: none
|
|
sourceColumn: APP2_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP2_DES
|
|
dataType: string
|
|
lineageTag: d04d2892-16be-4ebd-adcd-ce0f3c517527
|
|
summarizeBy: none
|
|
sourceColumn: APP2_DES
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP2_DES_C
|
|
dataType: string
|
|
lineageTag: 8531419e-be46-4f02-9908-dc5fbab04158
|
|
summarizeBy: none
|
|
sourceColumn: APP2_DES_C
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP3_COD
|
|
dataType: string
|
|
lineageTag: 52a1dea4-4dbb-44b6-9b79-9a285776c384
|
|
summarizeBy: none
|
|
sourceColumn: APP3_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP3_DES
|
|
dataType: string
|
|
lineageTag: aa57090b-6402-4c0d-a5ad-818e746ce79c
|
|
summarizeBy: none
|
|
sourceColumn: APP3_DES
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP3_DES_C
|
|
dataType: string
|
|
lineageTag: 2b7ce819-150d-46aa-8bdb-05793fdde0db
|
|
summarizeBy: none
|
|
sourceColumn: APP3_DES_C
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column GENE_ORIG_DESC
|
|
dataType: string
|
|
lineageTag: 7f805bf6-850d-4925-964d-015e6f7ea4fd
|
|
summarizeBy: none
|
|
sourceColumn: GENE_ORIG_DESC
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column VBP_DESC
|
|
dataType: string
|
|
lineageTag: 72ac4722-00b5-49b3-adce-5153b1a464e1
|
|
summarizeBy: none
|
|
sourceColumn: VBP_DESC
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column CORP_COD
|
|
dataType: string
|
|
lineageTag: e3d5a1e0-d797-4022-84a7-ca5f19e39750
|
|
summarizeBy: none
|
|
sourceColumn: CORP_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column GEN_RN
|
|
dataType: string
|
|
lineageTag: 8b12411b-233e-4d8d-bb2b-a23d1b2893c0
|
|
summarizeBy: none
|
|
sourceColumn: GEN_RN
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MOLECULE_CODE_DESC = IF([CMPS_DES] = "-"," - " , [CMPS_DES]& " - " & [CMPS_DES_C])
|
|
lineageTag: 3527bbbc-a941-4357-b996-3161d6ae5a2d
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC1_CODE_DESC = [ATC1_COD] & " - " & [ATC1_DES_C]
|
|
lineageTag: 95dfd568-a634-4ee6-93b7-b9eaad5fee0f
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC2_CODE_DESC = [ATC2_COD] & " - " & [ATC2_DES_C]
|
|
lineageTag: 08396fc1-0b78-48fa-af64-6e9aba7debd8
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC3_CODE_DESC = [ATC3_COD] & " - " & [ATC3_DES_C]
|
|
lineageTag: d2937c33-2fd4-4f4a-8d79-c4360bc318fd
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC4_CODE_DESC = [ATC4_COD] & " - " & [ATC4_DES_C]
|
|
lineageTag: e8147896-2b3d-4784-8af9-808f6f4e0807
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP1_COD_DES_C = [APP1_COD] & " - " & [APP1_DES_C]
|
|
lineageTag: eaeaa2d6-77ad-4b2e-8875-32a8e69af1ad
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP2_COD_DES_C = [APP2_COD] & " - " & [APP2_DES_C]
|
|
lineageTag: 5a58d6c4-f2a8-4acf-9c92-cd45836c81b5
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP3_COD_DES_C = [APP3_COD] & " - " & [APP3_DES_C]
|
|
lineageTag: ca0b9bee-0c36-476c-b411-41338150964d
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MOLECULE_DES_C = [CMPS_DES_C] & " - " & [CMPS_DES]
|
|
lineageTag: e9eaccb6-c51f-459d-8bc0-15d15b0e98b8
|
|
summarizeBy: none
|
|
sortByColumn: CMPS_RN
|
|
|
|
changedProperty = SortByColumn
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_PACK = [PROD_DES] & " - " & [PACK_DES]
|
|
lineageTag: 4b881842-d882-4f6d-b879-34b69bc0a5dd
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_CORP = [CORP_DES] & "(" & [PROD_DES]&")"
|
|
lineageTag: c781d692-765e-4f49-9945-eac15e0f41e4
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column CORP_DES
|
|
dataType: string
|
|
lineageTag: d8dc8bf5-0104-4acc-b3b7-1f97e88dde0d
|
|
summarizeBy: none
|
|
sourceColumn: CORP_DES
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column CORP_DES_C
|
|
dataType: string
|
|
lineageTag: 94a183de-e511-4b7a-b71e-1214f25538a3
|
|
summarizeBy: none
|
|
sourceColumn: CORP_DES_C
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_CORP_C = [PROD_DES_C] & "(" & [CORP_DES_C]&")"
|
|
lineageTag: c800e12c-120a-4f7f-a34c-9cd432a66a4b
|
|
summarizeBy: none
|
|
sortByColumn: PROD_RN
|
|
|
|
changedProperty = SortByColumn
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MANU_DES
|
|
dataType: string
|
|
lineageTag: 891e1902-4bc3-4512-9381-a11f03dc8af5
|
|
summarizeBy: none
|
|
sourceColumn: MANU_DES
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PACK_RN
|
|
dataType: string
|
|
lineageTag: 04e027ce-98d3-4d89-b8a7-0952fad4f687
|
|
summarizeBy: none
|
|
sourceColumn: PACK_RN
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_RN
|
|
dataType: string
|
|
lineageTag: 12a207d7-e23f-4b08-b4c5-d91825f5003e
|
|
summarizeBy: none
|
|
sourceColumn: PROD_RN
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_PACK_CORP = [PROD_DES_C] & " " & [PACK_DES]& "(" & [CORP_DES_C]&")"
|
|
lineageTag: 990697ca-2f91-4375-b79c-2d412bf92652
|
|
summarizeBy: none
|
|
sortByColumn: PACK_RN
|
|
|
|
changedProperty = SortByColumn
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column CMPS_RN
|
|
dataType: string
|
|
lineageTag: c7289ec0-4351-47e3-b711-3f2a24f4cbdd
|
|
summarizeBy: none
|
|
sourceColumn: CMPS_RN
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column DATA_SOURCE
|
|
dataType: string
|
|
lineageTag: 65bd749b-1888-4022-87e2-e04c2f68ebc5
|
|
summarizeBy: none
|
|
sourceColumn: DATA_SOURCE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PACK_SOURCE = ```
|
|
[PACK_COD] & [DATA_SOURCE] & [NEW_CODE]
|
|
```
|
|
lineageTag: edc6d470-39af-4bd9-bd1b-76a8c703ad23
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column STGH_DES
|
|
dataType: string
|
|
lineageTag: 7af92276-177a-4f3c-908e-cdbb55f1e263
|
|
summarizeBy: none
|
|
sourceColumn: STGH_DES
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column BIO_DESC
|
|
dataType: string
|
|
lineageTag: ba2d591e-23e5-4876-802c-786d1c4a02e9
|
|
summarizeBy: none
|
|
sourceColumn: BIO_DESC
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ETH_OTC_DESC
|
|
dataType: string
|
|
lineageTag: 43d019d0-858d-49cf-9309-79e73e1b3ab9
|
|
summarizeBy: none
|
|
sourceColumn: ETH_OTC_DESC
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column NRDL_DESC
|
|
dataType: string
|
|
lineageTag: d9473b87-f987-4314-a595-7f3e21f7a7af
|
|
summarizeBy: none
|
|
sourceColumn: NRDL_DESC
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column NRDL_ENTRY_DATE
|
|
dataType: string
|
|
lineageTag: d85ebc8a-ce77-4d40-9d3e-b579ba9c3726
|
|
summarizeBy: none
|
|
sourceColumn: NRDL_ENTRY_DATE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column EDL_DESC
|
|
dataType: string
|
|
lineageTag: a9f3707a-6f6c-4c22-aae7-3f89bb72e3e8
|
|
summarizeBy: none
|
|
sourceColumn: EDL_DESC
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column TCM_DESC
|
|
dataType: string
|
|
lineageTag: b7d1757a-dac5-44b2-8250-be28e33330e2
|
|
summarizeBy: none
|
|
sourceColumn: TCM_DESC
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PAED_DESC
|
|
dataType: string
|
|
lineageTag: aa6ff961-ad17-4a2e-bfcc-8978247015f2
|
|
summarizeBy: none
|
|
sourceColumn: PAED_DESC
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column GQCE_DESC
|
|
dataType: string
|
|
lineageTag: 6e5f859b-63c0-4863-8d3d-08b10af5eaba
|
|
summarizeBy: none
|
|
sourceColumn: GQCE_DESC
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MANU_COD
|
|
dataType: string
|
|
lineageTag: 64df9695-aa3d-445c-934f-9331fb3e7495
|
|
summarizeBy: none
|
|
sourceColumn: MANU_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MNFL_COD
|
|
dataType: string
|
|
lineageTag: e2bd7f82-e90f-4bf2-a9b0-fdaf2f929669
|
|
summarizeBy: none
|
|
sourceColumn: MNFL_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column VBP_BATCH
|
|
dataType: string
|
|
lineageTag: a7cd1c88-73b3-4ee3-ba8d-f6b9f19fc053
|
|
summarizeBy: none
|
|
sourceColumn: VBP_BATCH
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column VBP_IMPLEMENTING_TIME
|
|
dataType: string
|
|
lineageTag: c14e7f12-4f6d-4eb5-b579-ae212f3c1f9b
|
|
summarizeBy: none
|
|
sourceColumn: VBP_IMPLEMENTING_TIME
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC
|
|
dataType: string
|
|
lineageTag: 685c7c74-076b-473d-8bcb-36e463db339b
|
|
summarizeBy: none
|
|
sourceColumn: ATC
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column NEW_CODE
|
|
dataType: string
|
|
lineageTag: b104776c-f0a4-43f7-bede-73bff24b0c09
|
|
summarizeBy: none
|
|
sourceColumn: NEW_CODE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column COMMON_NAME
|
|
dataType: string
|
|
lineageTag: 11ab4733-a410-407b-9916-c77b59821e17
|
|
summarizeBy: none
|
|
sourceColumn: COMMON_NAME
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PRODUCT_NAME
|
|
dataType: string
|
|
lineageTag: 11043a28-b76c-4c5a-9f07-895f22721e87
|
|
summarizeBy: none
|
|
sourceColumn: PRODUCT_NAME
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MANU_DES_XIEHE
|
|
dataType: string
|
|
lineageTag: 1c72ae6d-abac-40d4-ab4d-c56663c1187e
|
|
summarizeBy: none
|
|
sourceColumn: MANU_DES_XIEHE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PACK_DES_XIEHE
|
|
dataType: string
|
|
lineageTag: 3772d845-a962-4ceb-9e5e-865188a5cbbb
|
|
summarizeBy: none
|
|
sourceColumn: PACK_DES_XIEHE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column DRUG_DELIVERY_ROUTE
|
|
dataType: string
|
|
lineageTag: 2a43e243-63d3-46b8-9609-8d4ae1103245
|
|
summarizeBy: none
|
|
sourceColumn: DRUG_DELIVERY_ROUTE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column NFC
|
|
dataType: string
|
|
lineageTag: 06a7141c-139e-4450-9984-e8c9c2e407fe
|
|
summarizeBy: none
|
|
sourceColumn: NFC
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column CORP_TYPE
|
|
dataType: string
|
|
lineageTag: b0fc0260-0803-4528-a425-4ef5836a6378
|
|
summarizeBy: none
|
|
sourceColumn: CORP_TYPE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column LAUNCHTIME
|
|
dataType: string
|
|
lineageTag: b04aa76a-f488-4396-ab8b-25cd35b5e0db
|
|
summarizeBy: none
|
|
sourceColumn: LAUNCHTIME
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_VBP = [PROD_DES_C] & "(" & [VBP_BRAND]&")"
|
|
lineageTag: 3ac4bcbe-deab-40cc-ae2c-2284761b7d94
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MANU_DES_C
|
|
dataType: string
|
|
lineageTag: 88125f10-9755-4d68-975c-4f0fe9f670af
|
|
summarizeBy: none
|
|
sourceColumn: MANU_DES_C
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MOLECULE_SOURCE = [CMPS_DES] & [DATA_SOURCE]
|
|
lineageTag: a6c0b55a-e20a-41c1-8e2a-ea8ebdcce51d
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PACK_SOURCE_AUTH = [PACK_COD] & [DATA_SOURCE]
|
|
lineageTag: fd424c49-1925-4ea9-9a91-49693c20f53a
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MANU_C = ```
|
|
[CORP_DES_C]
|
|
```
|
|
lineageTag: 6dd9a1e4-a6eb-4530-a8a9-53b495d6188a
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column Data_Surce2 =
|
|
|
|
IF([DATA_SOURCE] = "THC(Quarterly)","THC")
|
|
lineageTag: cc0ecd7a-e99d-4554-8706-494e26b155a8
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column VBP_BRAND
|
|
dataType: string
|
|
lineageTag: 0d4070ed-40b3-4040-b940-3f8817716f50
|
|
summarizeBy: none
|
|
sourceColumn: VBP_BRAND
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_CORP_EN = [PROD_DES] & "(" & [CORP_DES]&")"
|
|
lineageTag: 3f4e8882-261b-4f5e-87d5-c937d3bfc839
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_PACK_CORP_EN = [PROD_DES] & "-" & [PACK_DES]& "(" & [CORP_DES]&")"
|
|
lineageTag: 7b021f40-cc80-4fca-b194-dc8c117cc0ab
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_VBP_EN = [PROD_DES] & "(" & [VBP_BRAND]&")"
|
|
lineageTag: f9340cc0-8601-4b9d-8231-0c07f6e408a9
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP1_COD_DES = [APP1_COD] & " - " & [APP1_DES]
|
|
lineageTag: ea41a7f4-7a3f-4072-baa0-c9ae77de2b3a
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP2_COD_DES = [APP2_COD] & " - " & [APP2_DES]
|
|
lineageTag: 55856921-d3c3-4b23-bb34-a5ff9eed6a83
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column APP3_COD_DES = [APP3_COD] & " - " & [APP3_DES]
|
|
lineageTag: e1410049-e27b-4ecb-b70f-604285fa986c
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC1_CODE_DESC_EN = [ATC1_COD] & " - " & [ATC1_DES]
|
|
lineageTag: 5f6ad3a8-63cc-469c-bc3e-cc5cdc02c474
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC2_CODE_DESC_EN = [ATC2_COD] & " - " & [ATC2_DES]
|
|
lineageTag: bc49d8e8-3f57-4ef8-b989-5db5fd0e869a
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC3_CODE_DESC_EN = [ATC3_COD] & " - " & [ATC3_DES]
|
|
lineageTag: cfc7c2ec-66ef-40f6-9410-e884d6e0dbfa
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ATC4_CODE_DESC_EN = [ATC4_COD] & " - " & [ATC4_DES]
|
|
lineageTag: f4c0292a-91d1-47e5-9671-f5b87a72649b
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_DES_C_S
|
|
dataType: string
|
|
lineageTag: c2a0347a-d4ed-45b6-995c-c6c0a638cbcd
|
|
summarizeBy: none
|
|
sourceColumn: PROD_DES_C_S
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_DES_S
|
|
dataType: string
|
|
lineageTag: c1f98745-7939-41f4-9726-71c68b2eae7d
|
|
summarizeBy: none
|
|
sourceColumn: PROD_DES_S
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition Dim_PackInfo = m
|
|
mode: import
|
|
queryGroup: OLD\非首页
|
|
source = ```
|
|
let
|
|
Source =
|
|
Value.NativeQuery(
|
|
Databricks.Catalogs(
|
|
ServerAddress, HttpPath, [
|
|
Catalog = CatalogName,
|
|
Database = null,
|
|
EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
|
|
]
|
|
){
|
|
[Name = CatalogName, Kind = "Database"]
|
|
}[Data],
|
|
"
|
|
with dim_pack (
|
|
select CMPS_COD,min(CMPS_DES_C) CMPS_DES_C, min(CMPS_RN) CMPS_RN
|
|
from dm.DM_TD_EXTERNAL_PACKINFO group by 1
|
|
),
|
|
|
|
dim_manu as (
|
|
select PACK_COD,DATA_SOURCE,max(MANU_DES_C) MANU_DES_C
|
|
from DM.dm_td_external_packinfo_temp2
|
|
group by 1,2)
|
|
,result (
|
|
SELECT
|
|
DISTINCT A.PACK_COD,
|
|
PACK_DES,
|
|
PACK_LCH,
|
|
A.PROD_COD,
|
|
A.PROD_DES,
|
|
PROD_DES_C,
|
|
A.CMPS_COD,
|
|
case when A.CMPS_DES is null or A.CMPS_DES='' then '-' else upper(A.CMPS_DES) end as CMPS_DES,
|
|
case when B.CMPS_DES_C is null or B.CMPS_DES_C='' then '-' else upper(B.CMPS_DES_C) end as CMPS_DES_C,
|
|
A.VBP_BATCH,
|
|
A.VBP_IMPLEMENTING_TIME,
|
|
STGH_DES,
|
|
BIO_DESC,
|
|
ETH_OTC_DESC,
|
|
NRDL_DESC,
|
|
NRDL_ENTRY_DATE,
|
|
EDL_DESC,
|
|
TCM_DESC,
|
|
A.PAED_DESC,
|
|
GQCE_DESC,
|
|
MANU_COD,
|
|
MANU_DES,
|
|
MNFL_COD,
|
|
ATC1_COD,
|
|
ATC1_DES,
|
|
ATC1_DES_C,
|
|
ATC2_COD,
|
|
C.MANU_DES_C,
|
|
ATC2_DES,
|
|
ATC2_DES_C,
|
|
ATC3_COD,
|
|
ATC3_DES,
|
|
ATC3_DES_C,
|
|
ATC4_COD,
|
|
ATC4_DES,
|
|
ATC4_DES_C,
|
|
APP1_COD,
|
|
APP1_DES,
|
|
APP1_DES_C,
|
|
APP2_COD,
|
|
APP2_DES,
|
|
APP2_DES_C,
|
|
APP3_COD,
|
|
APP3_DES,
|
|
APP3_DES_C,
|
|
GENE_ORIG_DESC,
|
|
VBP_DESC,
|
|
VBP_BRAND,
|
|
CORP_COD,
|
|
GEN_RN,
|
|
CORP_DES,
|
|
CORP_DES_C,
|
|
PACK_RN,
|
|
PROD_RN,
|
|
B.CMPS_RN,
|
|
A.DATA_SOURCE,
|
|
ATC,
|
|
NEW_CODE,
|
|
COMMON_NAME,
|
|
PRODUCT_NAME,
|
|
MANU_DES_XIEHE,
|
|
PACK_DES_XIEHE,
|
|
DRUG_DELIVERY_ROUTE,
|
|
NFC,
|
|
CORP_TYPE,
|
|
LAUNCHTIME
|
|
FROM
|
|
DM.DM_TD_EXTERNAL_PACKINFO A
|
|
left join dim_pack B ON A.CMPS_COD = B.CMPS_COD
|
|
left join dim_manu C ON A.PACK_COD = C.PACK_COD and A.DATA_SOURCE = C.DATA_SOURCE
|
|
union all
|
|
select
|
|
'DTPOTHERS' PACK_COD
|
|
,'DTPOTHERS' PACK_DES
|
|
,'Y2005M03' PACK_LCH
|
|
,'DTPOTHERS' PROD_COD
|
|
,'DTPOTHERS' PROD_DES
|
|
,'DTPOTHERS' as PROD_DES_C
|
|
,'DTPOTHERS' as CMPS_COD
|
|
,'DTPOTHERS' as CMPS_DES
|
|
,'DTPOTHERS' as CMPS_DES_C
|
|
,'DTPOTHERS' as VBP_BATCH
|
|
,'DTPOTHERS' as VBP_IMPLEMENTING_TIME
|
|
,'DTPOTHERS' as STGH_DES
|
|
,'DTPOTHERS' as BIO_DESC
|
|
,'DTPOTHERS' as ETH_OTC_DESC
|
|
,'DTPOTHERS' as NRDL_DESC
|
|
,'DTPOTHERS' as NRDL_ENTRY_DATE
|
|
,'DTPOTHERS' as EDL_DESC
|
|
,'DTPOTHERS' as TCM_DESC
|
|
,'DTPOTHERS' as PAED_DESC
|
|
,'DTPOTHERS' as GQCE_DESC
|
|
,'DTPOTHERS' as MANU_COD
|
|
,'DTPOTHERS' as MANU_DES
|
|
,'DTPOTHERS' as MNFL_COD
|
|
,'L' as ATC1_COD
|
|
,'ANTINEOPLAST+IMMUNOMODUL' as ATC1_DES
|
|
,'抗肿瘤药及免疫调节剂' as ATC1_DES_C
|
|
,'L01' as ATC2_COD
|
|
,'' MANU_DESC_C
|
|
,'ANTINEOPLASTICS' as ATC2_DES
|
|
,'抗肿瘤药' as ATC2_DES_C
|
|
,'DTPOTHERS' as ATC3_COD
|
|
,'DTPOTHERS' as ATC3_DES
|
|
,'DTPOTHERS' as ATC3_DES_C
|
|
,'DTPOTHERS' as ATC4_COD
|
|
,'DTPOTHERS' as ATC4_DES
|
|
,'DTPOTHERS' as ATC4_DES_C
|
|
,'DTPOTHERS' as APP1_COD
|
|
,'DTPOTHERS' as APP1_DES
|
|
,'DTPOTHERS' as APP1_DES_C
|
|
,'DTPOTHERS' as APP2_COD
|
|
,'DTPOTHERS' as APP2_DES
|
|
,'DTPOTHERS' as APP2_DES_C
|
|
,'DTPOTHERS' as APP3_COD
|
|
,'DTPOTHERS' as APP3_DES
|
|
,'DTPOTHERS' as APP3_DES_C
|
|
,'DTPOTHERS' as GENE_ORIG_DESC
|
|
,'DTPOTHERS' as VBP_DESC
|
|
,'VBP-IN' as VBP_BRAND
|
|
,'DTPOTHERS' as CORP_COD
|
|
,'DTPOTHERS' as GEN_RN
|
|
,'DTPOTHERS' as CORP_DES
|
|
,'DTPOTHERS' as CORP_DES_C
|
|
,'DTPOTHERS' as PACK_RN
|
|
,'DTPOTHERS' as PROD_RN
|
|
,'DTPOTHERS' as CMPS_RN
|
|
,'DTP(Quarterly)' as DATA_SOURCE
|
|
,NULL as ATC
|
|
,'' as NEW_CODE
|
|
,NULL as COMMON_NAME
|
|
,NULL as PRODUCT_NAME
|
|
,NULL as MANU_DES_XIEHE
|
|
,NULL as PACK_DES_XIEHE
|
|
,NULL as DRUG_DELIVERY_ROUTE
|
|
,NULL as NFC
|
|
,'MNC' as CORP_TYPE
|
|
,NULL as LAUNCHTIME)
|
|
|
|
select t1.*
|
|
,if( t2.prod_cod is not null , concat(t1.PROD_DES_C,'(',t1.prod_cod,')(',t1.cmps_cod,')'),t1.PROD_DES_C) as PROD_DES_C_S
|
|
,if( t2.prod_cod is not null , concat(t1.PROD_DES,'(',t1.prod_cod,')(',t1.cmps_cod,')'),t1.PROD_DES) as PROD_DES_S
|
|
from result t1
|
|
left join dm.dm_td_exchange_packinfo_m_prod t2 on t1.prod_cod = t2.prod_cod and t1.cmps_cod = t2.cmps_cod and t1.data_source = t2.data_source
|
|
"
|
|
& UsingLimit,
|
|
null,
|
|
[
|
|
EnableFolding = true
|
|
]
|
|
)
|
|
in
|
|
Source
|
|
```
|
|
|
|
annotation PBI_ResultType = Table
|
|
|
|
annotation PBI_NavigationStepName = Navigation
|
|
|
|
annotation TabularEditor_TableGroup = 04_DimTable
|
|
|