Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
ENCOUNTERSTATUSID	7	ENCOUNTERSTATUS
LKAUTODISCHARGEID	8	LKAUTODISCHARGE
LKREGPATIENTTYPELASTMODSIBLINGID	9	LKREGPATIENTTYPELASTMODSIBLING
LKDISCHARGEDISPOSITIONID	12	LKDISCHARGEDISPOSITION

	Name	Type
1	LKREGPATIENTTYPEID	INT
	Description: Primary Key

	Name	Type
2	ORGANIZATIONID	INT
	Description: OrganizationId is a foreign key to the Organization table

	Name	Type
3	CODE	NCHAR
	Description: The code used to identify the patient type code

	Name	Type
4	DESCLONG	NVARCHAR
	Description: The full description used to identify the patient type

	Name	Type
5	DESCSHORT	NVARCHAR
	Description: The abbreviated description used to identify the patient type

	Name	Type
7	ENCOUNTERSTATUSID	INT
	Description: EncounterStatusId is a foreign key to the EncounterStatus table

	Name	Type
8	LKAUTODISCHARGEID	INT
	Description: LkAutoDischargeId is a foreign key to the LkAutoDischarge table

	Name	Type
9	LKREGPATIENTTYPELASTMODSIBLINGID	INT
	Description: LkRegPatientTypeLastModSiblingId is a foreign key to the LkRegPatientTypeLastModSibling table

	Name	Type
10	PATIENTCLASS	NCHAR
	Description: Short identifier for patient class

	Name	Type
11	REQUIREMEDRECNUM	BIT
	Description: Indicates if medical record number is required

	Name	Type
12	LKDISCHARGEDISPOSITIONID	INT
	Description: LkDischargeDispositionId is a foreign key to the LkDischargeDisposition table

	Name	Type
13	RECURRINGPATIENTINACTIVEDAYS	INT
	Description: Number of recurring days for patient inactivity

	Name	Type
14	EFFECTIVEDATE	DATETIME2
	Description: The calendar date indicating when the patient type becomes effective for use in the system

	Name	Type
15	DISCONTINUEDATE	DATETIME2
	Description: The calendar date indicating when the patient type is no longer available for use in the system

	Name	Type
16	ALLOWROOMBED	BIT
	Description: Indicates if patient type allowed room / bed

	Name	Type
17	CREATEMULTREG	BIT
	Description: Indicates if patient type allowed to create multiple registrations

	Name	Type
19	CREATED	DATETIMEOFFSET
	Description: The name of person that created patient type record

	Name	Type
21	LASTMODIFIED	DATETIMEOFFSET
	Description: The date when patient type record was last modified