LKMARITALSTATUS
Description: Defines the set of codes that can be used to indicate the marital status of a person. HL7 Value Set.

Primary Key
Column Name Ordinal Position

Foreign Key
Column Name Ordinal Position Referenced Table

Column Information
Name Type
1 LKMARITALSTATUSID INT
Description: The unique Id for the LkMaritalStatus table
Name Type
2 SYSTEM NVARCHAR
Description: The URI or OID of the defining terminology system
Name Type
3 CODE NVARCHAR
Description: String symbol used to uniquely identify the concept within the terminology system
Name Type
4 DESCRIPTION NVARCHAR
Description: Detailed Description
Name Type
5 FOREIGNSYSTEMCODE NVARCHAR
Description: To be deprecated
Name Type
6 STARTDATE DATE
Description: Effective Date
Name Type
7 ENDDATE DATE
Description: Discontinue Date
Name Type
8 EDITABLE BIT
Description: Indicates that record can be edited
Name Type
9 ACTIVE BIT
Description: Indicates that record is active