HCPATVISIT FILE Patient Visit This is the Patient Visit information file. REFERENCED BY PC210 PC530 UPDATED BY BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1 PC20.1 PC310 PC520 PC521 PC540 OE114 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 PO31.1 RQ35.1 WH130 WH132 WH190 WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 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 WO132 WO140 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY HPV-COMPANY Numeric 4 CX506 PC20.1 Company This field contains the company number. PC520 PC521 HPV-VISIT-NBR Alpha 12 CX506 PC20.1 Visit Number This is the identifier that makes a PC520 PC521 visit unique with a company. HPV-PATIENT-ID Alpha 12 CX506 PC20.1 Patient ID This uniquely identifies a patient PC520 PC521 within a company. HPV-PATIENT-CLASS Alpha 1 CX506 PC20.1 Patient Class This provides for a category of PC520 PC521 patient. I = Inpatient O = Outpatient HPV-ROOM Alpha 10 PC20.1 PC520 Room This identifies the room the patient is PC521 in. HPV-BED Numeric 2 PC20.1 PC520 Bed This field contains the patient's bed PC521 number. HPV-ADMIT-DATE Numeric 8 (yyyymmdd) PC20.1 PC520 Admit Date The date the patient is admitted. PC521 HPV-DISCH-DATE Numeric 8 (yyyymmdd) PC20.1 PC520 Disch Date The date the patient is discharged. PC521 HPV-LAST-TRANS-DT Numeric 8 (yyyymmdd) PC20.1 PC520 Last Trans Dt This is the date of the last add/update to a charge for this visit. HPV-DIAG-REL-GRP Alpha 15 PC20.1 PC520 Diagnosis Related This field identifies the Diagnostic PC521 Group Related Group. HPV-PRACTNR-ID Alpha 15 PC20.1 PC520 Practitioner ID This field identifies the PC521 practitioner. HPV-SEC-PRACTNR-ID Alpha 15 PC20.1 PC520 Sec Practnr Id This field contains a secondary practitioner ID. HPV-LAST-CHRG-SEQ Numeric 4 BL92.1 CX100 Last Chrg Seq The last charge sequence is used to CX20.1 CX20.2 determine the next available charge CX20.4 CX20.5 sequence to assign to a new charge for CX220 CX30.1 the visit. CX300 CX506 CXCP.1 OE114 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 PC20.1 PC520 PC540 PO31.1 RQ35.1 WH130 WH132 WH190 WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 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 WO132 WO140 HPV-UPDATE-DATE Numeric 8 (yyyymmdd) CX506 PC20.1 Update Date This is the date of the last update to PC520 PC521 the visit record. HCPATVISIT FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN HPVSET1 COMPANY BL92.1 CX100 VISIT-NBR CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1 PC20.1 PC210 PC520 PC521 PC530 PC540 OE114 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 PO31.1 RQ35.1 ... HPVSET2 COMPANY KeyChange PC20.2 PC310 PATIENT-ID PC521 VISIT-NBR HCPATVISIT FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Hcpatient HCPATIENT Required HPV-COMPANY -> HPT-COMPANY 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 |