Previous Topic

Next Topic

Book Contents

Book Index

AD_PatientStatus

This view contains data about the manually applied statuses a patient can have. A patient acquires a manually applied status when all of the patient's visits have that status.

AD_PatientStatus report view

Column

Description

SITEID

Name of the site as displayed in the user interface.

SITENUMBER

Database identifier of the site. (Can be NULL.)

PATIENTID

Unique identifier for the patient. (Can be NULL.)

DESCRIPTION

System status of the patient.

PATIENTFROZEN

Code indicating whether the patient is frozen:

  • 0—No
  • 1—Yes

PATIENTLOCKED

Code indicating whether the patient is locked:

  • 0—No
  • 1—Yes

PATIENTDMREVIEWED

Code indicating whether all of the patient's visits have been reviewed by a Data Manager:

  • 0—No
  • 1—Yes

PATIENTSDV

Code indicating whether all of the patient's visits have been source verified:

  • 0—No
  • 1—Yes

PATIENTSIGNED

Code indicating whether all of the patient's visits have been signed:

  • 0—No
  • 1—Yes

PATIENTREMOTEREVIEW

Code indicating whether all of the patient's visits have been reviewed remotely:

  • 0—No
  • 1—Yes

LAN_ID

Identifier of the language, enabling you to filter the view by language.

Copyright © 2011 - 2014 Oracle and/or its affiliates. All rights reserved.