APHDR Data Sets

Army Public Health Data Repository (APHDR)

PHC Select Data Dictionary NCAT (28).xlsx

APHDR Data Sets

OMB:

Document [xlsx]

Download: xlsx | pdf

Overview

NCAT v1.0.0.0 Data Dictionary
Administration
Assessment
Audit_Log
Audit_Log_Detail
Content
Log_Entry
NCAT_User
Normative
Normative_Percentage
Participant
Proctor
Property_Validator
Rank
Raw_Data
Raw_Item
Role
Role_Privilege
Security_Entity
Service
Service_Mapping
Summary_Data
Summary_Item
Switch_Item
Table_Sequence
Test
User_Role
XCheck
XLoader
XSend
XSystems

Sheet 1: NCAT v1.0.0.0 Data Dictionary

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

Sheet 2: Administration

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.

Sheet 3: Assessment

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.

Sheet 4: Audit_Log

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.

Sheet 5: Audit_Log_Detail

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.

Sheet 6: Content

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.

Sheet 7: Log_Entry

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.

Sheet 8: NCAT_User

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	EMAIL		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.

Sheet 9: Normative

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.

Sheet 10: Normative_Percentage

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.

Sheet 11: Participant

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.

Sheet 12: Proctor

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.

Sheet 13: Property_Validator

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.

Sheet 14: Rank

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.

Sheet 15: Raw_Data

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.

Sheet 16: Raw_Item

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.

Sheet 17: Role

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.

Sheet 18: Role_Privilege

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.

Sheet 19: Security_Entity

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.

Sheet 20: Service

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.

Sheet 21: Service_Mapping

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.

Sheet 22: Summary_Data

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.

Sheet 23: Summary_Item

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.

Sheet 24: Switch_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.

Sheet 25: Table_Sequence

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.

Sheet 26: Test

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.

Sheet 27: User_Role

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.

Sheet 28: XCheck

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.

Sheet 29: XLoader

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.

Sheet 30: XSend

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.

Sheet 31: XSystems

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