| Neurocognitive Assessment Tool (NCAT) | |
| Data Dictionary | |
| Date: 15 December 2009 | |
| Contract No: W74V8H-04-D-0026 | |
| Delivery Order No: 0002 | |
| Document Control No:DHIMS-0002-DD-091215 | |
| Version: 0.2 | |
| This document does not require Government approval | |
| Prepared by: | |
| Evolvent Technologies, Inc. | |
| 5111 Leesburg Pike, Suite 506 | |
| Falls Church, VA 22041 | |
| Prepared for: | |
| TRICARE Management Activity (TMA) | |
| Defense Health Information Management System (DHIMS) | |
| 5109 Leesburg Pike, Suite 100 | |
| Falls Church, VA 22041 |
| Table Description: Data related to the administration of an NCAT assessment battery to include location and assessment time, as well as session and computer ID. | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| ADMINISTRATION | ADMINISTRATION_ID | Y | No | NUMBER | 22 | 12 | 0 | A unique identifier serving as the primary key for the Administration table. |
| ADMINISTRATION | ASSESSMENT_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier of the assessment, serving as a foreign key to the Assessment table. |
| ADMINISTRATION | PROCTOR_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique ID of the proctor who administered the assessment, serving as a foreign key to the Proctor table. |
| ADMINISTRATION | LOCATION | No | VARCHAR2 | 50 | The physical location where the assessment was administered. | |||
| ADMINISTRATION | SESSION_ID | No | VARCHAR2 | 50 | The unique session number for the administration session. If an assessment must be administered more than once, the session number will be sequentially incremented for each subsequent administration of a test. | |||
| ADMINISTRATION | TAKEN_DT | Yes | DATE | 7 | The date and time the administration session was administered, represented using the NCAT MWS time zone. | |||
| ADMINISTRATION | TAKEN_DT_ACTUAL | No | CHAR | 25 | The date and time the administration session was administered, represented using the local time on the NCAT client machine on which the assessment was administered. | |||
| ADMINISTRATION | COMPUTER_ID | No | VARCHAR2 | 50 | The computer ID/name of the NCAT client machine from which the assessment was administered. | |||
| ADMINISTRATION | LATEST | No | NUMBER | 22 | 1 | 0 | A value indicating if the administration is the last administration taken. Valid values are '0'=No, '1'=Yes. | |
| Table Description: Data related to an assessment battery to include reason for testing, date of assessment, and current assessment status. | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| ASSESSMENT | ASSESSMENT_ID | Y | No | NUMBER | 22 | 12 | 0 | A unique identifier serving as the primary key for Assessment table. |
| ASSESSMENT | PARTICIPANT_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier of the participant, serving as a foreign key to the Participant table. |
| ASSESSMENT | CHARACTERIZATION_ID | No | CHAR | 36 | A unique GUID (identifier) representing the Assessment received from the NCAT client machine on which the assessment was administered. | |||
| ASSESSMENT | REASON | Yes | VARCHAR2 | 2000 | Descriptive reason for the assessment. Restricted to the values displayed in a DDLB to the end user. Values available are: PRE-DEPLOYMENT, POST-DEPLOYMENT, CLINICAL POST-INJURY, CLINICAL GENERAL. | |||
| ASSESSMENT | SETTING | Yes | VARCHAR2 | 50 | Physical setting of the assessment. Valid values are: GARRISON, FIELD, TAXONOMY I, TAXONOMY II, TAXONOMY III, TAXONOMY IV, TAXONOMY V. | |||
| ASSESSMENT | THEATER | Yes | NUMBER | 22 | A value indicating if an assessment was taken in theater. Valid values are '0'=No, '1' = Yes. | |||
| ASSESSMENT | RECEIVED_DT | No | DATE | 7 | The date the assessment was received by the NCAT MWS, using the time zone of the NCAT MWS. | |||
| ASSESSMENT | PROCESS_STATUS | No | NUMBER | 22 | Number status of this record with regards to communication with DEERS and the transmission to the CDR+. Foreign key to the Process_Status table. | |||
| Table Description: Logged events for NCAT database transactions | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| AUDIT_LOG | AUDIT_LOG_ID | Y | No | NUMBER | 22 | 12 | 0 | A unique identifier serving as the primary key for the Audit_Log table. |
| AUDIT_LOG | USER_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the NCAT user, serving as a foreign key to the User table. |
| AUDIT_LOG | OCCURRED_DT | No | DATE | 7 | The date and time the audited action was performed on the NCAT MWS. | |||
| AUDIT_LOG | ACTION | No | VARCHAR2 | 50 | Brief text description of the action being audited. For example: View, Insert, Modify, etc. | |||
| Table Description: Details of logged events for NCAT to include both original and changed data values | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| AUDIT_LOG_DETAIL | AUDIT_LOG_DETAIL_ID | Y | No | NUMBER | 22 | 12 | 0 | A unique identifier serving as the primary key for the Audit_Log_Detail table. |
| AUDIT_LOG_DETAIL | AUDIT_LOG_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the audit_log entry, serving as a foreign key to the Audit_Log table. |
| AUDIT_LOG_DETAIL | NAME | No | VARCHAR2 | 50 | The name of the audit log value. This could be a database column name, or a specific audit log event value. | |||
| AUDIT_LOG_DETAIL | VALUE | No | VARCHAR2 | 2000 | The modified value associated with the audited record. | |||
| AUDIT_LOG_DETAIL | VALUE_ORIGINAL | No | VARCHAR2 | 2000 | The original/previous value of audited record. If the Audit_Log 'action' is UPDATE, then the value of this column would be the original value of the column before the update transaction occurred. If the Audit_Log 'action' is INSERT, then the value of this column would be null since there would be no original value prior to this transaction. | |||
| AUDIT_LOG_DETAIL | SORT | No | NUMBER | 22 | The sort order in which the value was inserted. In the case of multiple updates on a single table row, a sequence of events can be established. | |||
| Table Description: Original XML assessment data received from the NCAT Client software | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| CONTENT | CONTENT_ID | Y | No | NUMBER | 22 | 12 | 0 | A unique identifier serving as the primary key for the Content table. |
| CONTENT | ASSESSMENT_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the assessment, serving as a foreign key to the Assessment table. |
| CONTENT | XML_DATA | Y | No | NCLOB | 4000 | The original XML data received from the NCAT client machine on which the assessment was administered. | ||
| Table Description: NCAT MWS transaction log data | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| LOG_ENTRY | ENTRY_ID | Y | No | NUMBER | 22 | 12 | 0 | A unique identifier serving as the primary key for the Log_Entry table. |
| LOG_ENTRY | CREATED_DT | Y | No | DATE | 7 | Date and time that the log entry was created. | ||
| LOG_ENTRY | APP_NAME | Y | No | VARCHAR2 | 60 | The name of the NCAT software component that created the log entry. | ||
| LOG_ENTRY | SOURCE | Y | No | VARCHAR2 | 40 | Text description of the source file of the log entry. | ||
| LOG_ENTRY | ENTRY_LEVEL | Y | No | NUMBER | 22 | 2 | 0 | The log entry level of detail. Valid values are: 'Error', 'Information', 'Critical', 'Warning', and 'Verbose'. |
| LOG_ENTRY | ENTRY_PRIORITY | Y | No | NUMBER | 22 | 2 | 0 | The priority of the log entry. Valid values are: 'None', 'Critical', 'High', 'Medium', 'Low', 'Trace', and 'Debug'. |
| LOG_ENTRY | ENTRY_CATEGORY | Y | No | NUMBER | 22 | 2 | 0 | The category of the log entry. Valid values are: 0='Assessment', 1='Business Logic', 2='Data Access', 3='Debug', 4='General', 5='Trace', 6='Security', 7='WindowsService', 8='WebService', 9='EF', 10='AHLTA', 11='ANAM', 12='CDR', 13='XML', 14='UI', 15='Standard', 16='Administrative', 17='Application', and 18='Error'. |
| LOG_ENTRY | ENTRY_TYPE | Y | No | VARCHAR2 | 40 | The type of the log entry. Valid values are: 'Trace', 'Error', 'Info', 'Critical', 'Debug', 'Warning'. | ||
| LOG_ENTRY | ENTRY_NAME | Y | No | VARCHAR2 | 40 | The name of the method that is creating the log entry. | ||
| LOG_ENTRY | ENTRY_VALUE | Y | No | VARCHAR2 | 4000 | The error message to be logged. | ||
| Table Description: NCAT MWS account data for each user | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| NCAT_USER | USER_ID | Y | No | NUMBER | 22 | 12 | 0 | A unique identifier serving as the primary key for the NCAT_User table. |
| NCAT_USER | FIRST_NAME | No | VARCHAR2 | 50 | The first name of the user. | |||
| NCAT_USER | LAST_NAME | No | VARCHAR2 | 50 | The last name of the user. | |||
| NCAT_USER | No | VARCHAR2 | 384 | The email address of the user. | ||||
| NCAT_USER | CREATE_DT | No | DATE | 7 | The date the user account was created. | |||
| NCAT_USER | UPDATE_DT | No | DATE | 7 | The date the user account was last updated. | |||
| NCAT_USER | DELETE_DT | No | DATE | 7 | The date the user account was inactivated. | |||
| NCAT_USER | RANK_ID | No | NUMBER | 22 | 12 | 0 | The unique identifier for the user's rank, serving as a foreign key to the Rank table. | |
| NCAT_USER | SERVICE_ID | No | NUMBER | 22 | 12 | 0 | The unique identifier for the user's branch of service, serving as a foreign key to the Service table. | |
| NCAT_USER | PHONE | No | VARCHAR2 | 50 | The phone number where the user may be contacted. | |||
| NCAT_USER | LOGIN_ID | No | VARCHAR2 | 50 | The login ID for the NCAT user account and is the same as the user's SnareWorks login ID. | |||
| NCAT_USER | CERTIFICATE_ID | No | VARCHAR2 | 50 | The public key hash value of the CAC certificate that the user registered with NCAT. Public key Hash of the certificate that the user registers their CAC with |
|||
| NCAT_USER | TMDS_ID | No | VARCHAR2 | 50 | The TMDS Login ID associated with the user account. | |||
| Table Description: Normative data used for compiling the NCAT Performance Report (NPR) | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| NORMATIVE | NORMATIVE_ID | Y | No | NUMBER | 22 | 12 | 0 | A unique identifier serving as the primary key for the Normative table. |
| NORMATIVE | SAMPLE | No | VARCHAR2 | 50 | The name of the normative sample. | |||
| NORMATIVE | TEST | No | VARCHAR2 | 50 | The name of the test to which this normative sample applies. | |||
| NORMATIVE | SEX | No | VARCHAR2 | 50 | The sex associated with this normative test. Valid values are: 'M'=Male and 'F'=Female. | |||
| NORMATIVE | AGE_MIN | No | NUMBER | 22 | The minimum age, expressed in years, for this normative test. | |||
| NORMATIVE | AGE_MAX | No | NUMBER | 22 | The maximum age, expressed in years, for this normative test. | |||
| NORMATIVE | NUM | No | NUMBER | 22 | The numeric value for this normative test. | |||
| NORMATIVE | VAR | No | VARCHAR2 | 50 | The variance value for this normative test. | |||
| NORMATIVE | MEAN | No | NUMBER | 22 | The mean value for this normative test. | |||
| NORMATIVE | STD | No | NUMBER | 22 | The standard deviation value for this normative test. | |||
| Table Description: Normative percentage and values associated with a normative sample | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| NORMATIVE_PERCENTAGE | PERCENTAGE_ID | Y | No | NUMBER | 22 | 12 | 0 | A unique identifier serving as the primary key for the Normative_Percentage table. |
| NORMATIVE_PERCENTAGE | NORMATIVE_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the normative sample, serving as a foreign key to the Normative table. |
| NORMATIVE_PERCENTAGE | PERCENTAGE | Y | No | VARCHAR2 | 5 | The normative percentage. | ||
| NORMATIVE_PERCENTAGE | VALUE | Y | No | NUMBER | 22 | The numeric value of the normative percentage. | ||
| Table Description: Test-Taker data transformed from the original XML received from the NCAT Client software | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| PARTICIPANT | PARTICIPANT_ID | Y | YES | NUMBER | 22 | 12 | 0 | A unique identifier serving as the primary key for the Participant table. |
| PARTICIPANT | ID | YES | VARCHAR2 | 50 | The participant’s ID or SSN. | |||
| PARTICIPANT | PREFIX | YES | CHAR | 2 | The participant's name prefix. | |||
| PARTICIPANT | FIRST_NAME | YES | VARCHAR2 | 50 | The participant’s first name. | |||
| PARTICIPANT | MIDDLE_NAME | YES | VARCHAR2 | 50 | The participant’s middle name. | |||
| PARTICIPANT | LAST_NAME | YES | VARCHAR2 | 50 | The participant’s last name. | |||
| PARTICIPANT | DOB | YES | DATE | 7 | The participant’s date of birth. | |||
| PARTICIPANT | GENDER | YES | VARCHAR2 | 50 | The participant’s sex. | |||
| PARTICIPANT | SERVICE | YES | VARCHAR2 | 50 | The participant’s branch of service. | |||
| PARTICIPANT | MOS | YES | VARCHAR2 | 50 | The participant’s MOS/specialty code. | |||
| PARTICIPANT | UIC | YES | VARCHAR2 | 50 | The participant’s unit identification code (UIC). | |||
| PARTICIPANT | STATUS | YES | VARCHAR2 | 50 | The participant’s status. | |||
| PARTICIPANT | GRADE | YES | VARCHAR2 | 50 | The participant’s military grade/rank. | |||
| PARTICIPANT | ADDRESS_TYPE | YES | VARCHAR2 | 50 | The address type. | |||
| PARTICIPANT | STREET | YES | VARCHAR2 | 50 | The street name and number for the address provided. | |||
| PARTICIPANT | CITY | YES | VARCHAR2 | 50 | The city name. | |||
| PARTICIPANT | STATE | YES | VARCHAR2 | 50 | The state abbreviation. | |||
| PARTICIPANT | ZIP | YES | VARCHAR2 | 50 | The zip code. | |||
| PARTICIPANT | ALTERNATE_PHONE | YES | VARCHAR2 | 50 | The participant's alternative phone number. | |||
| PARTICIPANT | PHONE | YES | VARCHAR2 | 50 | The participant's primary phone number. | |||
| PARTICIPANT | UNIT_PHONE | YES | VARCHAR2 | 50 | Unit phone number. | |||
| PARTICIPANT | CURRENT_UNIT | YES | VARCHAR2 | 50 | Current unit number. | |||
| PARTICIPANT | DEPLOYING_UNIT | YES | VARCHAR2 | 50 | Deploying unit number. | |||
| PARTICIPANT | OPERATION | YES | VARCHAR2 | 50 | The operation description. | |||
| PARTICIPANT | EDIPN | YES | VARCHAR2 | 50 | The participant’s EDIPN from DEERS. | |||
| PARTICIPANT | BLAST | YES | VARCHAR2 | 50 | The Blast history of the Test-Taker. | |||
| PARTICIPANT | BULLET | YES | VARCHAR2 | 50 | The Bullets history of the Test-Taker. | |||
| PARTICIPANT | FRAGMENT | YES | VARCHAR2 | 50 | The Fragment history of the Test-Taker. | |||
| PARTICIPANT | VEHICLE | YES | VARCHAR2 | 50 | The Vehicular history of the Test-Taker. | |||
| PARTICIPANT | SPORTS | YES | VARCHAR2 | 50 | The Sports history of the Test-Taker. | |||
| PARTICIPANT | FALL | YES | VARCHAR2 | 50 | The Fall history of the Test-Taker. | |||
| PARTICIPANT | FIGHT | YES | VARCHAR2 | 50 | The Fight history of the Test-Taker. | |||
| PARTICIPANT | OTHER_BLOW | YES | VARCHAR2 | 50 | The Other Blow history of the Test-Taker. | |||
| PARTICIPANT | DAZED | YES | VARCHAR2 | 50 | The Dazed history of the Test-Taker. | |||
| PARTICIPANT | UNCONSCIOUS1 | YES | VARCHAR2 | 50 | The Unc1min history of the Test-Taker. | |||
| PARTICIPANT | UNCONSCIOUS2 | YES | VARCHAR2 | 50 | The Unc1 to 20 history of the Test-Taker. | |||
| PARTICIPANT | UNCONSCIOUS3 | YES | VARCHAR2 | 50 | The Unc1 to 20 history of the Test-Taker. | |||
| PARTICIPANT | AMNESIA | YES | VARCHAR2 | 50 | The Not Remembering history of the Test-Taker. | |||
| PARTICIPANT | BLEED_EAR | YES | VARCHAR2 | 50 | The Bleed Ear history of the Test-Taker. | |||
| PARTICIPANT | HEAD_INJURY | YES | VARCHAR2 | 50 | The Head Injury history of the Test-Taker. | |||
| PARTICIPANT | CONCUSSION_SYMP | YES | VARCHAR2 | 50 | The Symp Conc history of the Test-Taker. | |||
| PARTICIPANT | OTHER_SYMP | YES | VARCHAR2 | 50 | The Other Symp history of the Test-Taker. | |||
| PARTICIPANT | HEADACHE | YES | VARCHAR2 | 50 | The Headache history of the Test-Taker. | |||
| PARTICIPANT | NAUSEA | YES | VARCHAR2 | 50 | The Nausea history of the Test-Taker. | |||
| PARTICIPANT | SENSITIVITY | YES | VARCHAR2 | 50 | The Sens To Light history of the Test-Taker. | |||
| PARTICIPANT | BALANCE | YES | VARCHAR2 | 50 | The Balance Problem history of the Test-Taker. | |||
| PARTICIPANT | RINGING | YES | VARCHAR2 | 50 | The Ear Ringing history of the Test-Taker. | |||
| PARTICIPANT | SLEEP_PROBLEM | YES | VARCHAR2 | 50 | The Sleep Problem history of the Test-Taker. | |||
| PARTICIPANT | IRRITABLE | YES | VARCHAR2 | 50 | The Irritable history of the Test-Taker. | |||
| PARTICIPANT | MEMORY_LAPSE | YES | VARCHAR2 | 50 | The Memory Lapse history of the Test-Taker. | |||
| PARTICIPANT | OTHER_SYMP_CHRONOLOGY | YES | VARCHAR2 | 50 | The Other Symptom history of the Test-Taker. | |||
| PARTICIPANT | MACE1 | YES | VARCHAR2 | 50 | The Mace1 history of the Test-Taker. | |||
| PARTICIPANT | MACE2 | YES | VARCHAR2 | 50 | The Mace2 history of the Test-Taker. | |||
| PARTICIPANT | MACE3 | YES | VARCHAR2 | 50 | The Mace3 history of the Test-Taker. | |||
| PARTICIPANT | MACE1_DT | YES | VARCHAR2 | 50 | The mace_dt history of the Test-Taker. | |||
| PARTICIPANT | MACE2_DT | YES | VARCHAR2 | 50 | The mace2_dt history of the Test-Taker. | |||
| PARTICIPANT | MACE3_DT | YES | VARCHAR2 | 50 | The mace3_dt history of the Test-Taker. | |||
| PARTICIPANT | INTERVAL | YES | VARCHAR2 | 50 | The Interval history of the Test-Taker. | |||
| PARTICIPANT | COMMENT1 | YES | VARCHAR2 | 2000 | Comment field number 1. | |||
| PARTICIPANT | COMMENT2 | YES | VARCHAR2 | 2000 | Comment field number 2. | |||
| PARTICIPANT | AHLTA_UNIT_NUMBER | YES | VARCHAR2 | 20 | The AHLTA Unit number. | |||
| Table Description: Proctor data | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| PROCTOR | PROCTOR_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the Proctor table. |
| PROCTOR | ID | No | VARCHAR2 | 50 | The proctor’s personal identification. Oftentimes the social security number. | |||
| PROCTOR | FIRST_NAME | No | VARCHAR2 | 50 | The proctor’s first name. | |||
| PROCTOR | MIDDLE_NAME | No | VARCHAR2 | 50 | The proctor’s middle name. | |||
| PROCTOR | LAST_NAME | No | VARCHAR2 | 50 | The proctor’s last name. | |||
| PROCTOR | DOB | No | DATE | 7 | The proctor’s date of birth. | |||
| PROCTOR | GENDER | No | VARCHAR2 | 50 | The proctor’s sex. | |||
| PROCTOR | SERVICE | No | VARCHAR2 | 50 | The proctor’s branch of service. | |||
| PROCTOR | MOS | No | VARCHAR2 | 50 | The proctor’s MOS/specialty code. | |||
| PROCTOR | UIC | No | VARCHAR2 | 50 | The proctor’s unit identification code (UIC). | |||
| PROCTOR | STATUS | No | VARCHAR2 | 50 | The proctor’s status. | |||
| PROCTOR | GRADE | No | VARCHAR2 | 50 | The proctor’s military grade/rank. | |||
| Table Description: Validation data for properties which are used during testing and debugging of software | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| PROPERTY_VALIDATOR | PROPERTY_VALIDATOR_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the Property_Validator table. |
| PROPERTY_VALIDATOR | DESCRIPTION | No | VARCHAR2 | 2000 | Text description of the property validator. | |||
| PROPERTY_VALIDATOR | NAME | No | VARCHAR2 | 50 | The name of the property validator. When property validators are referenced in the code they are referenced by this name. | |||
| PROPERTY_VALIDATOR | REGULAR_EXPRESSION | No | VARCHAR2 | 2000 | The regular expression is the operational/arithmetic rule used to validate the property. | |||
| PROPERTY_VALIDATOR | GOOD_VALUE | No | VARCHAR2 | 100 | The good value for the property used as a pass value during software testing/debugging. | |||
| PROPERTY_VALIDATOR | BAD_VALUE | No | VARCHAR2 | 100 | The bad value for the property used as a fail value during software testing/debugging. | |||
| Table Description: Reference table for military rank data | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| RANK | RANK_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the Rank table. |
| RANK | RANK | No | VARCHAR2 | 50 | Text description for the rank. | |||
| RANK | SORT | No | NUMBER | 22 | The sort order of the rank. | |||
| Table Description: NCAT assessment data in raw form, by event, derived from the original XML received from the NCAT Client software | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| RAW_DATA | RAW_DATA_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the Raw_Data table. |
| RAW_DATA | RAW_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the raw item, serving as a foreign key to the Raw_Item table. |
| RAW_DATA | NAME | No | VARCHAR2 | 50 | Text description of the raw data. | |||
| RAW_DATA | EVENT | No | VARCHAR2 | 50 | Text description of the raw event. | |||
| RAW_DATA | VALUE | No | NVARCHAR2 | 100 | The date and time of the raw data. | |||
| RAW_DATA | SORT | No | NUMBER | 22 | The sort order of the raw data. | |||
| Table Description: NCAT assessment data in raw form, by field, derived from the original XML received from the NCAT Client software | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| RAW_ITEM | RAW_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the Raw_Item table. |
| RAW_ITEM | TEST_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the test, serving as a foreign key to the Test table. |
| RAW_ITEM | TYPE | No | VARCHAR2 | 50 | The type of the test. Valid values are: 'Basic', and 'Section'. | |||
| RAW_ITEM | NAME | No | VARCHAR2 | 50 | Text description of the raw item. | |||
| RAW_ITEM | RAW_DT | No | DATE | 7 | The date and time of the raw item, represented in the time zone of the NCAT MWS. | |||
| RAW_ITEM | RAW_DT_ACTUAL | No | CHAR | 25 | The actual date and time of the raw item, expressed in the time zone of the NCAT client machine on which the assessment was administered. | |||
| RAW_ITEM | SORT | No | NUMBER | 22 | The sort order of the raw item. | |||
| Table Description: Role data for NCAT MWS | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| ROLE | ROLE_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the Role table. |
| ROLE | ROLE_NAME | No | VARCHAR2 | 50 | Text name of the NCAT role. | |||
| ROLE | DESCRIPTION | No | VARCHAR2 | 2000 | Text description of the NCAT role. | |||
| Table Description: Privileges granted to a role | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| ROLE_PRIVILEGE | ROLE_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the role, serving as a foreign key to the Role table and part of the composite key Role_ID + Security_ID. |
| ROLE_PRIVILEGE | SECURITY_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the security entity, serving as a foreign key to the Security_Entity table and part of the composite key Role_ID + Security_ID. |
| ROLE_PRIVILEGE | INSERT_R | No | NUMBER | 22 | Represents the ‘insert’ right for this Role. 0 – Not Granted, 1 – Granted, 2 – Denied. | |||
| ROLE_PRIVILEGE | DELETE_R | No | NUMBER | 22 | Represents the ‘delete’ right for this Role. 0 – Not Granted, 1 – Granted, 2 – Denied. | |||
| ROLE_PRIVILEGE | UPDATE_R | No | NUMBER | 22 | Represents the ‘download’ right for this Role. 0 – Not Granted, 1 – Granted, 2 – Denied. | |||
| ROLE_PRIVILEGE | INSTALL_R | No | NUMBER | 22 | Represents the ‘install’ right for this Role. 0 – Not Granted, 1 – Granted, 2 – Denied. | |||
| ROLE_PRIVILEGE | DOWNLOAD_R | No | NUMBER | 22 | Represents the ‘login’ right for this Role. 0 – Not Granted, 1 – Granted, 2 – Denied. | |||
| ROLE_PRIVILEGE | LOGIN_R | No | NUMBER | 22 | Represents the ‘modify’ right for this Role. 0 – Not Granted, 1 – Granted, 2 – Denied. | |||
| ROLE_PRIVILEGE | RECEIVE_R | No | NUMBER | 22 | Represents the ‘receive’ right for this Role. 0 – Not Granted, 1 – Granted, 2 – Denied. | |||
| ROLE_PRIVILEGE | SEND_R | No | NUMBER | 22 | Represents the ‘send’ right for this Role. 0 – Not Granted, 1 – Granted, 2 – Denied. | |||
| ROLE_PRIVILEGE | VIEW_R | No | NUMBER | 22 | Represents the ‘view’ right for this Role. 0 – Not Granted, 1 – Granted, 2 – Denied. | |||
| Table Description: Security entity reference data | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| SECURITY_ENTITY | SECURITY_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the Security_Entity table. |
| SECURITY_ENTITY | SECURITY_NAME | No | VARCHAR2 | 50 | The name of the security entity. | |||
| Table Description: Military branch of service reference data | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| SERVICE | SERVICE_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the Service table. |
| SERVICE | SERVICE | No | VARCHAR2 | 50 | Text name of the branch of service. | |||
| Table Description: Associative table for the mapping of branch of service to service component | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| SERVICE_MAPPING | SERVICE_ID | Y | No | NUMBER | 22 | 15 | 0 | The unique identifier for the Service, serving as a foreign key to the Service table. |
| SERVICE_MAPPING | SERVICE | No | VARCHAR2 | 50 | Text description for the branch of service as entered on the NCAT Client. | |||
| Table Description: Summarized data for use with the NCAT Performance Report (NPR) | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| SUMMARY_DATA | SUMMARY_DATA_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the Summary_Data table. |
| SUMMARY_DATA | SUMMARY_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the summary item, serving as a foreign key to the Summary_Item table. |
| SUMMARY_DATA | NAME | No | VARCHAR2 | 50 | Text name of the raw data section. | |||
| SUMMARY_DATA | VALUE | No | NVARCHAR2 | 100 | The value of the raw data section. | |||
| SUMMARY_DATA | SORT | No | NUMBER | 22 | The sort order of the raw data section. | |||
| Table Description: Summarized item for use with the NCAT Performance Report (NPR) | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| SUMMARY_ITEM | SUMMARY_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the Summary_Item table. |
| SUMMARY_ITEM | TEST_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier of the Test, serving as a foreign key to the Test table. |
| SUMMARY_ITEM | TYPE | No | VARCHAR2 | 50 | The type of the test. Valid values are: 'Basic', 'Section', and'Category'. | |||
| SUMMARY_ITEM | NAME | No | VARCHAR2 | 50 | Text description of the name of the summary item. | |||
| SUMMARY_ITEM | SUMMARY_DT | No | DATE | 7 | Date and time of the summary item, represented as the time zone of the NCAT MWS. | |||
| SUMMARY_ITEM | SUMMARY_DT_ACTUAL | No | CHAR | 25 | Date and time of the summary item, represented as the time zone of the NCAT client machine on which the assessment was administered. | |||
| SUMMARY_ITEM | SORT | No | NUMBER | 22 | The sort order of the summary item. | |||
| Table Description: Switch data associated with a test within the assessment battery | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| SWITCH_ITEM | SWITCH_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the Switch_Item table. |
| SWITCH_ITEM | TEST_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier of the Test, serving as a foreign key to the Test table. |
| SWITCH_ITEM | NAME | No | VARCHAR2 | 50 | Text description of the switch name. | |||
| SWITCH_ITEM | VALUE | No | VARCHAR2 | 300 | The numeric value of the switch. | |||
| SWITCH_ITEM | SORT | No | NUMBER | 22 | The sort order of the switch within the test. | |||
| Table Description: Repository of sequence numbers used by NCAT database tables | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| TABLE_SEQUENCE | TABLE_NAME | Y | No | VARCHAR2 | 50 | Unique identifier for the Table_Sequence table describing the name of the table for which this sequence belongs. | ||
| TABLE_SEQUENCE | NEXT_SEQUENCE | Y | No | NUMBER | 22 | 15 | 0 | The next sequence number of the database table's primary key. |
| Table Description: Associative table to link a test within the assessment battery with an administration of that test | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| TEST | TEST_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the Test table. |
| TEST | ADMINISTRATION_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier of the Administration, serving as a foreign key to the Administration table. |
| TEST | NAME | No | VARCHAR2 | 50 | Text description of the test name. | |||
| TEST | EXTENSION | No | VARCHAR2 | 50 | Text description of the test file extension. Valid values are: cdd, cds, m2s, moo, mth, pro, shd, slp, sr2, sub, and tbq. | |||
| TEST | TAKEN_DT | No | DATE | 7 | Date and time that the test was started by the Test-Taker, represented in the time zone of the NCAT MWS. | |||
| TEST | TAKEN_DT_ACTUAL | No | CHAR | 25 | Date and time that the test was started by the Test-Taker, represented in the time zone of the NCAT client machine on which the assessment was administered. | |||
| TEST | SORT | No | NUMBER | 22 | The sort order of this test in the assessment battery. | |||
| Table Description: Associative table to link an NCAT user account to a user role, defining permissions for a user account | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| USER_ROLE | USER_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the NCAT user, serving as a foreign key to NCAT_User table and a part of the composite key User_ID + Role_ID. |
| USER_ROLE | ROLE_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the NCAT role, serving as a foreign key to Role table and a part of the composite key User_ID + Role_ID. |
| Table Description: Tracking table for external checks performed on the assessments. | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| XCHECK | XCHECK_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the XCheck table. |
| XCHECK | XLOADER_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier of the XLoader, serving as a foreign key to the XLoader table. |
| XCHECK | CREATE_DT | Y | No | TIMESTAMP(6) | 11 | 6 | Date and time that the XCheck record was created. | |
| XCHECK | STATUS_ID | Y | No | NUMBER | 22 | 8 | 0 | Numeric status for the assessment. Foreign key to the Process_Status table. |
| XCHECK | XSYSTEM_ID | Y | No | NUMBER | 22 | 8 | 0 | The unique identifier for the XSystem record, serving as a foreign key to the XSystem table. |
| XCHECK | RETRY_COUNT | Y | No | NUMBER | 22 | 4 | 0 | Cumulative retry count for sending to the external system. Set to 3 by default. |
| XCHECK | PROCESSED | Y | No | NUMBER | 22 | 1 | 0 | Indicator that the check has been performed. Valid values are: '1'=Processed, '0'=Not yet processed. |
| XCHECK | DELETED | Y | No | NUMBER | 22 | 1 | 0 | Indicator that the row is marked as deleted so that this check is no longer performed. '0'=Not deleted, '1'=Deleted. |
| Table Description: Tracking table for processing assessments as they are prepared for transmission to external systems. XSend table is loaded with processed data to be sent. | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| XLOADER | XLOADER_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the XLoader table. |
| XLOADER | CREATE_DT | Y | No | TIMESTAMP(6) | 11 | 6 | Date and time that the XLoader record was created. | |
| XLOADER | ASSESSMENT_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier of the Assessment, serving as a foreign key to the Assessment table. |
| XLOADER | CHARACTERIZATION_ID | Y | No | VARCHAR2 | 36 | The unique GUID (identifier) representing the Assessment received from the NCAT client machine on which the assessment was administered. | ||
| XLOADER | STATUS_ID | Y | No | NUMBER | 22 | 8 | 0 | Numeric status for the assessment. Foreign key to the Process_Status table. |
| XLOADER | XSYSTEM_ID | Y | No | NUMBER | 22 | 8 | 0 | The unique identifier for the XSystem record, serving as a foreign key to the XSystem table. |
| XLOADER | RETRY_COUNT | Y | No | NUMBER | 22 | 4 | 0 | Cumulative retry count for loading the assessment. Set to 3 by default. |
| XLOADER | PROCESSED | Y | No | NUMBER | 22 | 1 | 0 | Indicator that the check has been performed. Valid values are: '1'=Processed, '0'=Not yet processed. |
| XLOADER | DELETED | Y | No | NUMBER | 22 | 1 | 0 | Indicator that the row is marked as deleted so that this check is no longer performed. '0'=Not deleted, '1'=Deleted. |
| Table Description: Tracking table to identify assessments awaiting transmission to external systems | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| XSEND | XSEND_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the XSend table. |
| XSEND | XLOADER_ID | Y | No | NUMBER | 22 | 12 | 0 | The unique identifier for the XLoader, serving as a foreign key to the XLoader table. |
| XSEND | CREATE_DT | Y | No | TIMESTAMP(6) | 11 | 6 | Date and time that the XSend record was created. | |
| XSEND | STATUS_ID | Y | No | NUMBER | 22 | 8 | 0 | Numeric status for the assessment. Foreign key to the Process_Status table. |
| XSEND | XSYSTEM_ID | Y | No | NUMBER | 22 | 8 | 0 | The unique identifier for the XSystem record, serving as a foreign key to the XSystem table. |
| XSEND | RETRY_COUNT | Y | No | NUMBER | 22 | 4 | 0 | Cumulative retry count for sending to the external system. Set to 3 by default. |
| XSEND | PROCESSED | Y | No | NUMBER | 22 | 1 | 0 | Indicator that the check has been performed. Valid values are: '1'=Processed, '0'=Not yet processed. |
| XSEND | DELETED | Y | No | NUMBER | 22 | 1 | 0 | Indicator that the row is marked as deleted so that this check is no longer performed. '0'=Not deleted, '1'=Deleted. |
| Table Description: Data identifying external systems to receive NCAT data and used for NCAT data validation | ||||||||
| Table Name | Column Name | Req | PHC Requested | Data Type | Data Length | Data Precision | Data Scale | Column Description |
| XSYSTEMS | XSYSTEM_ID | Y | No | NUMBER | 22 | 8 | 0 | The unique identifier for the XSystems table. |
| XSYSTEMS | XSYSTEM | Y | No | VARCHAR2 | 100 | Text description of the external system name. | ||
| XSYSTEMS | URL | No | VARCHAR2 | 256 | Uniform Resource Locator (URL) of the external system web service. | |||
| XSYSTEMS | CLIENT_CERTIFICATE | No | VARCHAR2 | 256 | Certificate for the system. | |||
| XSYSTEMS | CREATE_DT | Y | No | TIMESTAMP(6) | 11 | 6 | Date and time that the XSystems record was created. | |
| XSYSTEMS | LAST_UPDATE_DT | Y | No | TIMESTAMP(6) | 11 | 6 | Timestamp of the last update to the XSystems record. | |
| XSYSTEMS | RETRY_MAX | Y | No | NUMBER | 22 | 4 | 0 | The maximum number of retries that will be attempted with the external web service. Set to a value of 3 by default. |
| XSYSTEMS | TOSEND | Y | No | NUMBER | 22 | 1 | 0 | Indicates whether or not the test assessment is to be sent to the designated external system. Valid values are: '0'=Check only, and '1'=Send. |
| XSYSTEMS | SEND_ARCHIVE | Y | No | NUMBER | 22 | 1 | 0 | Indicates whether or not to send assessments created prior to NCAT implementation to the external system. Valid values are: '0'=Do not send, and '1'=Send. The default value is '0'. |
| XSYSTEMS | CONTACT_EMAIL | No | VARCHAR2 | 100 | Email address for external system point of contact. | |||
| XSYSTEMS | SEND_EMAIL | Y | No | NUMBER | 22 | 1 | 0 | Indicates whether or not email is used to send error messages. Valid values are: '0'=Do not send, and '1'=Send. |
| XSYSTEMS | DELETED | Y | No | NUMBER | 22 | 1 | 0 | Indicator that the row is marked as deleted so that this check is no longer performed. '0'=Not deleted, '1'=Deleted. |
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |