Lawson Insight Technical Documentation |
|
HCPATVISIT
HCPATVISIT FILE
Patient Visit
This is the Patient Visit information file.
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 CXCP.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ35.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HPV-COMPANY Numeric 4
Element: Company This field contains the company number.
HPV-VISIT-NBR Alpha 12
Element: Visit Nbr This is the identifier that makes a
visit unique with a company.
HPV-PATIENT-ID Alpha 12
Element: Patient Id This uniquely identifies a patient
within a company.
HPV-PATIENT-CLASS Alpha 1
Element: Patient Class This provides for a category of patient.
I = Inpatient
O = Outpatient
HPV-ROOM Alpha 10
Element: Room This identifies the room the patient is
in.
HPV-BED Numeric 2
Element: Bed This field contains the patient's bed
number.
HPV-ADMIT-DATE Numeric 8 (yyyymmdd)
Element: Admit Date The date the patient was admitted.
HPV-DISCH-DATE Numeric 8 (yyyymmdd)
Element: Disch Date The discharge date of the patient.
HPV-LAST-TRANS-DT Numeric 8 (yyyymmdd)
Element: Last Trans Dt This is the date of the last add/update
to a charge for this visit.
HPV-DIAG-REL-GRP Alpha 15
Element: Diag Rel Grp This identifies the Diagnostic Related
Group.
HPV-PRACTNR-ID Alpha 15
Element: Practnr Id This field contains the practitioner ID.
HPV-SEC-PRACTNR-ID Alpha 15
Element: Practnr Id This field contains a secondary
practitioner ID.
HPV-LAST-CHRG-SEQ Numeric 4 AP125 AP126
Element: Seq Nbr The last charge sequence is used to AP131 AP20.1
determine the next available charge AP20.2 AP20.3
sequence to assign to a new charge for AP20.4 AP20.5
the visit. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
HPV-UPDATE-DATE Numeric 8 (yyyymmdd)
Element: Update Date This is the date of the last update to
the visit record.
HCPATVISIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HPVSET1 COMPANY AP125 AP126
VISIT-NBR AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
...
HPVSET2 COMPANY KeyChange
PATIENT-ID
VISIT-NBR
HCPATVISIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Hcpatient HCPATIENT Required
HPV-COMPANY -> HPT-COMPANY (HPTSET1)
HPV-PATIENT-ID -> HPT-PATIENT-ID
HCPATVISIT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Hcpatchrg HCPATCHRG
HPV-COMPANY -> HPR-COMPANY
HPV-VISIT-NBR -> HPR-VISIT-NBR
HPR-REV-CENTER
HPR-FROM-LOCATION
HPR-DATE-OF-CHRG
HPR-ITEM
HPR-CHARGE-SEQ
|