Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PTM Patient Type Masterfile
Column Name Column Datatype Column Null Option Column Comment
PTTYPEvarchar(1)not null Patient Type
DESCRIPTIONvarchar(24)null Patient Type Description
CLASSvarchar(3)null Patient Class
OP_TYPEvarchar(1)null Outpatient Type
HOLD_DAYSvarchar(3)null Hold Days
PURGE_ORDERSvarchar(3)null Purge Orders
REREG_DAYSvarchar(4)null Number of Days patient visit record will stay in Re-Registration state in patient file before being purged from system
INS_CODE_2T3Tvarchar(3)null Secondary or Tertiary Insurance Code
ASC_TYPEvarchar(1)null ASC(Ambulatory Surgery Class) Type
SITE_ACCESSvarchar(20)null Site Access
ACTIVE_FLAGvarchar(3)null Active Flag

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates