QA Report -> Verification

text parased from image from confluence page:

Load Version
Code System Name: CDT
Version: 2023
Load Number: 20231002010003
Load Status: Pending QA
TS Available Date
Load Start Time: 2023/10/02 01:00 AM
Elapsed Time: 00:03:59
# of Messages: 5
Version Number: 20230101
Obsolete ID:
Language: ENG
Country: US
Published Date: 2022/12/25 Effective Date: 2023/01/01
Request ID: 123 Request Type: Scheduled
Request Time: 2023/10/02 01:00 AM
Requester: TS QA
Load Summary
Message Group Count
Load Components
Component Status Start Time
Duration
Name
Error
Warning
Info
extract
Complete 2023/10/02 01:00:03 AM
00:00:21
1
0
0
inject
extend
assert
Complete 2023/10/02 01:01:23 AM Complete 2023/10/02 01:02:16 AM Complete 2023/10/02 01:03:17 AM
00:00:04
1
2
0
00:00:02
0
0
00:00:45
0
1
QA Rules.
Туре
Total Rules
Rules
with Data
Verification Validation
10 0
8
0
Go to QA Report
Analyze Code System Data
QA Actions
Error 19 0
Message Group Count Warning
Info
32
118
0
View Source Data Files file://nlmsambaserver.nlm.nih.gov/dev-ts-data-import/CDT/2023
QA Acceptance
Accept
QA Activities
Reject
Activity ID
Action
TS
Reason
User
Last Update Time
# of Notes
Available Date
QA Notes
Activity ID
Hashtags
QA Report
Note
User
Creation Time
Identification
Code System Name: CDT Version: 2023
Load Number: 20231002010003
Load Status: Pending QA
TS Available Date:
Load Start Time: 2023/10/02 01:00:03 AM Load End Time: 2023/10/02 01:04:02 AM Elapsed Time: 00:03:59
Version Number: 20230101
Obsolete ID:
Language: ENG
Country: US
Published Date: 2022/12/25 Effective Date: 2023/01/01
Request ID: 123
Request Type: Scheduled
Request Time: 2023/10/02 01:00 AM Requester: TS QA
Source File Path: file://nimsambaserver.nlm.nih.gov/dev-ts-data-import/CDT/2023
Source Information

Load Activities
Component Status
Start Time
End Time
Duration
Name
Error
Message Group Count Warning
Info
inject
extend assert
extract Complete 2023/10/02 01:00:03 AM 2023/10/02 01:00:24 AM Complete 2023/10/02 01:01:23 AM Complete 2023/10/02 01:02:16 AM Complete 2023/10/02 01:03:17 AM
00:00:21
0
0
2023/10/02 01:01:27 AM 2023/10/02 01:02:18 AM 2023/10/02 01:04:02 AM
00:00:04
A 2
0
00:00:02
0
00:00:45
1
Load Messages CRefresh Component Name
Clear Search Message Group
Download Message Tag Type
Message
Creation Time
extract
Q search
search
Error
inject
Warning
Q search SOURCE WARNING
inject
inject
assert
Warning Error Info
WARNING
ERROR
INFO
Items 15 of 5
44 Page
Q search
MISSING_DATA_FILE CODE_EXTRA_SPACES CODE_EXTRA_SPACES CATEGORY_NOT_FOUND RAW_TABLE_COUNT
of 1▷ Page Size 10
Q search
A required %p1 data file is missing from the source folder Trailing or leading spaces were removed from the code D98051 Trailing or leading spaces were removed from the code D98053 Category mapping is not found
There are 8 raw counts found in the table
2023/10/02 01:00:05 AM 2023/10/02 01:01:25 AM 2023/10/02 01:01:26 AM 2023/10/02 01:01:26 AM 2023/10/02 01:03:25 AM
Verification
Summary
Total Rules
10
Rules with Data 8
Error 0 19
Message Group Count Warning A 32
Action
Info 118
QA Rules
CRefresh Clear Search Download
Rule Name
Q search
Code.SumActiveInactive
Code.DuplicateCode QaCount.CountCompare Code. Hierarchy.OrphanCode QaCount.RawCountMissing Code.Term.CodeNoTerms
Code.Attribute.InvalidName
Code.Relationship.CodeNotFound
Code.ExtraSpaces Code.Term.ExtraSpaces
Items 1 - 10 of 10
Rule Description
Q search
Data Available
Message Group Count
Action
Error Warning Info
Q searc
Sum of active/inactive codes is equal to total number of codes
Yes
0
No duplicate codes in cs_code table
Yes
05
Counts between expected and actual total counts
Yes
0
A 2
Hierarchy contains orphan codes
No
0
Raw counts are not present
Yes
0
All the codes are mapped to terms
Yes
Attribute names are mapped to the reference table
No
0
All codes from cs_code_relationship table exist in cs_code table Codes contain leading or trailing spaces
Yes
Yes
Terms contain leading or trailing spaces
Yes
NOO
A7
0
A 23
OONOOOONOM
0
1
0
0
0
0
0
0
0
1
0
12
0
0
104
0000000000
Rule Messages
CRefresh Clear Search Download
Rule Name
DUPLICATE_CODE_COUNT DUPLICATE_CODE_COUNT
Message Group
Message
Tag
Q search
Q search
Code.SumActiveInactive Info
Type Q search INFO
search
ACTIVE INACTIVE_CODE_COUNT
Code.DuplicateCode
Error
ERROR
DUPLICATE_CODE_COUNT
Code.DuplicateCode
Error
ERROR
Code.DuplicateCode
Error
ERROR
DUPLICATE_CODE_COUNT
DUPLICATE_CODE_COUNT
Code.DuplicateCode Code.DuplicateCode QaCount.CountCompare Warning
Error Error
ERROR ERROR
WARNING
QaCount.CountCompare Warning
WARNING
Code.Term.CodeNoTerms
Error
Code.Term.CodeNoTerms
Items 1 10 of 169
Error Page
DEV DEV
EXPECTED_VS_ACTUAL
EXPECTED_VS_ACTUAL
CODE_NO_TERM CODE_NO_TERM
of 17 Page Size 10
Message
Q search
The sum of active/inactive codes is equal to total codes count
Code D90001 appears more than once Code D90002 appears more than once Code D90004 appears more than once Code D90005 appears more than once Code D90003 appears more than once
The difference of TERM
between expected and actual number
not available
The difference of RELATIONSHIP between expected and actual number is not available
Code D90012 is not mapped to a term Code D90013 is not mapped to a term
Creation Time
2023/10/02 01:03:18 AM
2023/10/02 01:03:20 AM 2023/10/02 01:03:20 AM 2023/10/02 01:03:20 AM 2023/10/02 01:03:20 AM 2023/10/02 01:03:21 AM
2023/10/02 01:03:23 AM
2023/10/02 01:03:24 AM
2023/10/02 01:03:27 AM 2023/10/02 01:03:27 AM
Validation
Summary
Total Rules
Rules
Message Group Count
Action
with Data
Error
Warning
0
0
0
0
Info 0
Comparison
Summary
Code System Name
Version
Load Number
Total number of codes
Number of active codes
Number of inactive codes
Total number of terms
Total number of properties
Total number of remap codes
Total number of hierarchies
Total number of transitive closures
Total number of relationships
Total number of attributes
This Version
Previous Version
Difference
CDT
CDT
2023
2022
20231002010003
20230928102341
897
874
23
895
869
26
2
5
-3
897
874
23
2406
0
2406
0
0
0
885
862
23
2654
2571
83
0
0
0
3644
3621
23
Data Type
Code
Change
Total number of new codes Number of new codes - active
Number of new codes inactive
Total number of retired codes
Number of retired codes active
This Version Action
50
View New Codes
50
0
27 View Retired Codes
22
Number of retired codes - inactive
5
Total number of codes with status change
Number of codes becoming active
Number of codes becoming inactive
2 View Codes with Status Change
0
2
Term
Total number of term types (TTY)
3
View Term Types
Property
Number of new term types Number of removed term types Total number of property names Number of new property names
0
0
6 View Property Names
6
Number of removed property names
0
Remap
Total number of new remap codes Total number of removed remap codes
0 View New/Removed Remap Codes
0
Relationship
Total number of relationship types
3
View Relationship Types
Number of new relationship types
0
Number of removed relationship types
0
Attribute
Total number of attribute names
15
View Attribute Names
Number of new attribute names
0
Number of removed attribute names
0
Notes
Label 2
View Message:
View messages of all verification rules in "Rule Messages" below
Add Note:
Add note for the rules with hashtag default to "#Verification"
Label 3
View Message:
View messages of this rule in "Rule Messages" below, filtered by the rule name (ex. "Code.Term.CodeNoTerms")
Add Note:
Add note for this rule with hashtags default
to section title and rule name (ex. "#Verification" and
"#Code.Term.Code NoTerms")
Go to individual pages to view the following lists of
"This Version" or "Previous Version"
View Code List
View Term List
View Property List
View Remap Code List View Code Hierarchy List View Relationship List
View Attribute List
View various lists of
changes in "This Version", compared to
"Previous Version"
sh977218 / ts-etl-ui

QA Report -> Verification #198
