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. |
ClaimPrintFormLocatorMasterID |
|
int |
NO |
Primary key |
Name |
|
varchar(50) |
NO |
Print form locator name |
XPos |
|
numeric(10, 2) |
NO |
X position on print form for the field |
YPos |
|
numeric(10, 2) |
NO |
Y position on print form for the field |
UpdatedLength |
|
int |
NO |
Print form field character length |
LineNumber |
|
int |
YES |
Transaction/detail item line number |
Description |
|
varchar(100) |
YES |
description |
IsGroupMember |
|
bit |
YES |
Flag to determine whether its part of group or not |
ClaimPrintFormLocatorGroupID |
|
int |
YES |
A foreign key to the ClaimPrintFormLocatorMasterID column in the SXARCMClaimPrintFormLocatorMaster table. |
ClaimFormatID |
|
int |
NO |
A foreign key to the ClaimFormatID column in the SXARCMClaimFormat table. |
DataFormat |
|
varchar(255) |
YES |
data Format |
IsStdFormat |
|
bit |
NO |
verify for standard format |
Alignment |
|
char(1) |
YES |
Alignment |
SequenceNumber |
|
int |
NO |
Sequence Number for Claim Print Form Locator Master |
IsPFAField |
|
bit |
NO |
Is Print Format Adjustment Field |
ClaimPrintDataFormatID |
|
int |
YES |
A foreign key to the ClaimPrintDataFormatID column in the SXARCMClaimPrintDataFormat table. |
PFADefaultLength |
|
int |
NO |
Print Format Adjustment Default Length |
PFAToolTip |
|
varchar(100) |
YES |
Print Format Adjustment Tool Tip |
PFAXPosDeviation |
|
int |
YES |
xpos deviation |
PFAYPosDeviation |
|
int |
YES |
y pos deviation |
ColumnWidth |
|
numeric(10, 2) |
NO |
This Column stores the value of Fixed Length of Paper Fields in Claim Form |
BoxXpos |
|
numeric(10, 2) |
NO |
This Column stores the value of X pos to highlight the complete box |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
BoxHeight |
|
numeric(10, 2) |
NO |
This Column stores the value of box height to highlight the complete box |
BoxYpos |
|
numeric(10, 2) |
NO |
This Column stores the value of Y pos to highlight the compelte box |
PaperFormatTypeGroupID |
|
int |
YES |
A foreign key to the ClaimFieldFormatTypeGroupID column in the SXARCMClaimFieldFormatTypeGroup table. |
IsGroupMemberVisible |
|
bit |
NO |
Flag for field's visibility in field details config |