dbo.SXARCMPPS3MSchemeScheduleTypeJSONQuery 
Default Table Name  SXARCMPPS3MSchemeScheduleTypeJSONQuery 
Definition  Table stores external cause of injury diagnosis list staging information for 3M PPS. 

dbo.SXARCMPPS3MSchemeScheduleTypeJSONQuery Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Build    int  NO  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 
CreatedBy    varchar(50)  NO  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 
CreatedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
PPS3MSchemeScheduleTypeJSONQueryID(PK)    bigint  NO  Auto generated unique primary key value. 
ContentVersionID(FK)    int  NO  A foreign key to the ContentVersionID column in the SXARCMPPS3MContentVersion table. 
SchemeID    int  NO  Scheme identifier associated with content version. 
SchemeName    varchar(100)  NO  Name of the scheme. 
ScheduleTypeCode    varchar(20)  NO  Name of schedule type code 
JSONQuery    varchar(max)  YES  JSON Query for scheme and schedule type 
GrouperSchemeProductID    int  YES  Holds Grouper scheme id associated Scheme 

dbo.SXARCMPPS3MSchemeScheduleTypeJSONQuery Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMPPS3MSchemeScheduleTypeJSONQueryPK  PrimaryKey  PPS3MSchemeScheduleTypeJSONQueryID