dbo.SXARCMPPS3MProduct 
Default Table Name  SXARCMPPS3MProduct 
Definition  Table containing list of 3M grouper plus content service (GPCS) products available for use within the SFM Prospective Payment System (PPS) implementation. 

dbo.SXARCMPPS3MProduct 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. 
TouchedBy    varchar(50)  NO  Information about the user that last updated 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. 
TouchedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was last updated 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. 
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. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
PPS3MProductID(PK)    int  NO  Auto generated unique primary key value. 
UserKey1    varchar(50)  YES  default value used in UserKey1 field of SFM Config - Grouper Pricer Configuration 
UserKey2    varchar(15)  YES  default value used in UserKey2 field of SFM Config - Grouper Pricer Configuration 
VisitType    int  NO  account group of visit product is to be used with 
Name    varchar(200)  NO  Name of 3M GPCS product 
OutputScreen    smallint  NO  Default Value for Output Screen field in SFM Config - Grouper Pricer Configuration. Allows user to configure which screen the outputs will be displayed on (DRG for Diagnostic Related Groups, ASC for Ambulatory Surgical Center, APC for Ambulatory Procedure Classification and EAPG for Enhanced Ambulatory Patient Group)

Mapped to Mapped to Eclipsys.Financials.Common.Enums.PPS3MResultOutputScreen enum 
SchemeType    int  YES  Identifies what type of product this is (Grouper, Reimbursement or Editor). Used in code behind SFM Config - Grouper Pricer Configuration for filtering.

Mapped to Eclipsys.Financials.Common.Enums.PPS3MSchemeTypeEnum 
Grouper    varchar(50)  YES  Column will store type of grouper 
IsSupported    bit  NO  This column will indicate if SFM supports a scheme and if a user can activate it using Dictionary Maintanence 
PPSVendorID(FK)    int  NO  A foreign key to the PPSVendorID column in the SXARCMPPSVendor table. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXARCMPPS3MProduct Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMPPS3MProductPK  PrimaryKey  PPS3MProductID