Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
LKREGPATIENTTYPEID	7	LKREGPATIENTTYPE
LKREGADMITTYPEID	8	LKREGADMITTYPE
LKREGADMITSOURCEID	9	LKREGADMITSOURCE
LKREGFINANCIALCLASSID	10	LKREGFINANCIALCLASS
LKREGREFERRALSOURCEID	12	LKREGREFERRALSOURCE
MOMENCOUNTERID	18	ENCOUNTER
OPAREALOCATIONID	23	LOCATION
ORGANIZATIONID	39	ORGANIZATION
LOCATIONID	40	LOCATION
ENCOUNTERSTATUSID	41	ENCOUNTERSTATUS
LKSCHISOLATIONTYPEID	42	LKSCHISOLATIONTYPE
LKEMPLOYEESTATUSID	48	LKEMPLOYEESTATUS
LKCHECKINSTATUSID	49	LKCHECKINSTATUS
PATIENTID	52	PATIENT
MEDICALRECORDNUMBERID	53	MEDICALRECORDNUMBER
PARENTENCOUNTERID	54	ENCOUNTER

	Name	Type
1	ENCOUNTERID	INT
	Description: The unique Id for the Encounter table

	Name	Type
2	ACCOUNTNUMBER	NVARCHAR
	Description: Account number for the encounter To be deprecated

	Name	Type
3	REGISTRATIONNUMBER	NVARCHAR
	Description: Unique registration number used to identify an encounter without using the internal primary key EncounterId

	Name	Type
4	ADMITCLERKID	INT
	Description: Admit Clerk id

	Name	Type
5	ESTIMATEDADMITDATETIME	DATETIMEOFFSET
	Description: Estimated admit date time in UTC

	Name	Type
6	ADMITDATETIME	DATETIMEOFFSET
	Description: Admit date time in UTC

	Name	Type
7	LKREGPATIENTTYPEID	INT
	Description: LkRegPatientTypeId is a foreign key to the LkRegPatientType table

	Name	Type
8	LKREGADMITTYPEID	INT
	Description: LkRegAdmitTypeId is a foreign key to the LkRegAdmitType table

	Name	Type
9	LKREGADMITSOURCEID	INT
	Description: LkRegAdmitSourceId is a foreign key to the LkRegAdmitSource table

	Name	Type
10	LKREGFINANCIALCLASSID	INT
	Description: LkRegFinancialClassId is a foreign key to the LkRegFinancialClass table

	Name	Type
11	LKREGMEDICALSERVICEID	INT
	Description: LkRegFinancialClassId is a foreign key to the LkRegFinancialClass table

	Name	Type
12	LKREGREFERRALSOURCEID	INT
	Description: LkRegReferralSourceId is a foreign key to the LkRegReferralSource table

	Name	Type
13	ARRIVALMODEID	INT
	Description: Arrival Mode

	Name	Type
14	DISCHARGEESTIMATEDDATETIME	DATETIMEOFFSET
	Description: Discharge estimated date time in UTC

	Name	Type
15	ESTIMATEDLENGTHOFSTAY	INT
	Description: Estimated length of stay

	Name	Type
16	DISCHARGEDATETIME	DATETIMEOFFSET
	Description: Discharge date time in UTC

	Name	Type
17	DISCHARGEDISPOSITIONID	INT
	Description: To be deprecated

	Name	Type
18	MOMENCOUNTERID	INT
	Description: MomEncounterId is a foreign key to the Encounter table

	Name	Type
19	FORADOPTION	BIT
	Description: Flag for adoption

	Name	Type
20	PATIENTCLASS	CHAR
	Description: To be deprecated In Patient Type structure

	Name	Type
21	CANCELFLAG	BIT
	Description: Flag if encounter is cancelled

	Name	Type
22	LOCKEDFLAG	BIT
	Description: Flag if encounter is locked

	Name	Type
23	OPAREALOCATIONID	INT
	Description: OpAreaLocationId is a foreign key to the Location table

	Name	Type
24	SIGNATUREONFILEDATE	DATETIME
	Description: Signature on file date time in UTC

	Name	Type
25	DATAVERIFIED	BIT
	Description: Data Verified Flag

	Name	Type
26	VERIFIEDBYID	INT
	Description: Verified By

	Name	Type
27	CREATETYPEID	INT
	Description: How Was This Reg Created FullPreReg,BasicPreReg etc.

	Name	Type
28	COMPLETEFLAG	BIT
	Description: Flag if encounter is complete

	Name	Type
29	ABNCOMPLETE	BIT
	Description: Flag for Advance Beneficiary Notice

	Name	Type
30	ABNCOMPLETEDBYID	INT
	Description: Advance Beneficiary Notice completed by

	Name	Type
31	ABNCOMPLETEDDATETIME	DATETIMEOFFSET
	Description: Advance Beneficiary Notice completed date time in UTC

	Name	Type
32	PRECERTIFICATIONSTATUS	BIT
	Description: Flag for pre certification status

	Name	Type
33	PRECERTIFICATIONSTATUSBYID	INT
	Description: Pre certification by

	Name	Type
34	PRECERTIFICATIONSTATUSDATETIME	DATETIMEOFFSET
	Description: Pre certification date time in UTC

	Name	Type
35	ADVANCEDIRECTIVE	BIT
	Description: Advance directive flag

	Name	Type
36	PREGNANT	BIT
	Description: Flag if pregnant

	Name	Type
37	LACTATION	BIT
	Description: Flag if patient is Lactating for this encounter

	Name	Type
38	CENSUSOPTOUT	BIT
	Description: Flag if this encounter will be opted out of the census

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

	Name	Type
40	LOCATIONID	INT
	Description: LocationId is a foreign key to the Location table

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

	Name	Type
42	LKSCHISOLATIONTYPEID	INT
	Description: LkSchIsolationTypeId is a foreign key to the LkSchIsolationType table

	Name	Type
44	CREATED	DATETIMEOFFSET
	Description: Record created time

	Name	Type
46	LASTMODIFIED	DATETIMEOFFSET
	Description: Record Last Modified time

	Name	Type
47	CONFIDENTIAL	BIT
	Description: Employee Status of the patient for the encounter

	Name	Type
48	LKEMPLOYEESTATUSID	INT
	Description: LkEmployeeStatusId is a foreign key to the LkEmployeeStatus table

	Name	Type
49	LKCHECKINSTATUSID	INT
	Description: LkCheckinStatusId is a foreign key to the LkCheckinStatus table

	Name	Type
50	SIGNINDATETIME	DATETIMEOFFSET
	Description: Sign in date time in UTC

	Name	Type
51	CHARGEMOTHERSACCOUNT	BIT
	Description: Flag to charge mother's account

	Name	Type
52	PATIENTID	INT
	Description: PatientId is a foreign key to the Patient table

	Name	Type
53	MEDICALRECORDNUMBERID	INT
	Description: MedicalRecordNumberId is a foreign key to the MedicalRecordNumber table

	Name	Type
54	PARENTENCOUNTERID	INT
	Description: ParentEncounterId is a foreign key to the Encounter table