GNOM_INTPRT_HT_AUDIT

Description: |
Happy Together audit information for a genomic interpretation.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
GNOM_INTPRT_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | GNOM_INTPRT_ID | NUMERIC | No |
The unique identifier (.1 item) for the interpretation record.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 | HT_AUDIT_RESULT_KEY | VARCHAR | No |
The Reference ID of the result data to which this interpretation is linked.
5 | HT_AUDIT_DOCUMENT_CSN_ID | NUMERIC | No |
The CSN of the source DXR from which this interpretation was reconciled.
6 | HT_AUDIT_ACTION_C_NAME | VARCHAR | No |
The action that was performed during auto-reconciliation.
May contain organization-specific values: No
Category Entries:
Created
Automatically Retracted
Invalidated
7 | HT_AUDIT_INST_UTC_DTTM | DATETIME (UTC) | No |
The time instant in UTC when the action was performed.
8 | HT_AUDIT_LOCAL_DTTM | DATETIME (Local) | No |
The time instant in local time when the action was performed.
9 | HT_AUDIT_TIME_ZONE_C_NAME | VARCHAR | No |
The time zone the action was performed in. Stores the system default time zone.
May contain organization-specific values: No
Category Entries:
Africa/Johannesburg
America/Anchorage
America/Halifax
America/Puerto_Rico
America/Chicago
America/Regina
America/New_York
AMERICA/EASTERN_NO_DST
Pacific/Honolulu
America/Denver
America/Phoenix
America/Los_Angeles
ETC/UNIVERSAL
Europe/Amsterdam
AMERICA/PACIFIC_NO_DST
America/St_Johns
Europe/London
Europe/Lisbon
Europe/Athens
Europe/Kaliningrad
Australia/Sydney
Australia/Brisbane
Australia/Lord_Howe
America/Sao_Paulo
America/Fortaleza
Africa/Cairo
Asia/Dubai
Africa/Abidjan
Africa/Accra
Africa/Addis_Ababa
Africa/Algiers
Africa/Asmara
Africa/Bamako
Africa/Bangui
Africa/Banjul
Africa/Blantyre
Africa/Brazzaville
Africa/Bujumbura
Africa/Casablanca
Africa/Conakry
Africa/Dakar
Africa/Dar_es_Salaam
Africa/Djibouti
Africa/Douala
Africa/Freetown
Africa/Gaborone
Africa/Harare
Africa/Juba
Africa/Kampala
Africa/Khartoum
Africa/Kigali
Africa/Kinshasa
Africa/Lagos
Africa/Libreville
Africa/Lome
Africa/Luanda
Africa/Lusaka
Africa/Maputo
Africa/Maseru
Africa/Mbabane
Africa/Nairobi
Africa/Ndjamena
Africa/Niamey
Africa/Nouakchott
Africa/Ouagadougou
Africa/Porto-Novo
Africa/Tripoli
Africa/Tunis
Africa/Windhoek
America/Argentina/Buenos_Aires
America/Asuncion
America/Barbados
America/Belize
America/Bogota
America/Caracas
America/Chihuahua
America/Costa_Rica
America/El_Salvador
America/Guatemala
America/Guayaquil
America/Guyana
America/Havana
America/Hermosillo
America/Jamaica
America/La_Paz
America/Lima
America/Managua
America/Mexico_City
America/Montevideo
America/Montreal
America/Nassau
America/Panama
America/Paramaribo
America/Port_of_Spain
America/Port-au-Prince
America/Recife
America/Santiago
America/Santo_Domingo
America/Tegucigalpa
America/Tijuana
Asia/Aden
Asia/Almaty
Asia/Amman
Asia/Ashgabat
Asia/Baghdad
Asia/Bahrain
Asia/Baku
Asia/Bangkok
Asia/Beirut
Asia/Bishkek
Asia/Chongqing
Asia/Colombo
Asia/Damascus
Asia/Dhaka
Asia/Dili
Asia/Dushanbe
Asia/Ho_Chi_Minh
Asia/Hong_Kong
Asia/Jakarta
Asia/Jerusalem
Asia/Kabul
Asia/Karachi
Asia/Kathmandu
Asia/Kolkata
Asia/Kuala_Lumpur
Asia/Kuwait
Asia/Manila
Asia/Muscat
Asia/Nicosia
Asia/Phnom_Penh
Asia/Qatar
Asia/Rangoon
Asia/Riyadh
Asia/Seoul
Asia/Shanghai
Asia/Singapore
Asia/Taipei
Asia/Tashkent
Asia/Tbilisi
Asia/Tokyo
Asia/Ulaanbaatar
Asia/Vientiane
Asia/Vladivostok
Asia/Yekaterinburg
Asia/Yerevan
Atlantic/Cape_Verde
Europe/Belgrade
Europe/Berlin
Europe/Brussels
Europe/Bucharest
Europe/Budapest
Europe/Chisinau
Europe/Copenhagen
Europe/Dublin
Europe/Helsinki
Europe/Istanbul
Europe/Kiev
Europe/Madrid
Europe/Malta
Europe/Minsk
Europe/Moscow
Europe/Oslo
Europe/Paris
Europe/Prague
Europe/Riga
Europe/Rome
Europe/Sofia
Europe/Stockholm
Europe/Tallinn
Europe/Tirane
Europe/Vienna
Europe/Vilnius
Europe/Warsaw
Europe/Zurich
Indian/Antananarivo
Indian/Mauritius
Pacific/Fiji
Pacific/Pohnpei
Africa/Monrovia
America/North_Dakota/Beulah
America/Bahia_Banderas
America/Goose_Bay
America/Araguaina
Atlantic/Reykjavik
Africa/Malabo
Europe/Sarajevo
Europe/Zagreb
Europe/Skopje
Europe/Podgorica
Europe/Bratislava
Europe/Ljubljana
Pacific/Auckland
America/Belem
Australia/Adelaide
Australia/Broken_Hill
Australia/Currie
Australia/Darwin
Australia/Eucla
Australia/Hobart
Australia/Lindeman
Australia/Melbourne
Australia/Perth
Pacific/Guam
America/Cancun
(DEMO USE ONLY TIME ZONE)