Table Detail Report

OUTPUTCTX



Column Section Relationship Section Top of Page


Table-level Detail

Description: OUTPUTCTX
Definition: Table for tracking reprints
Table Type: ACTIVITY





Column Detail - OUTPUTCTX


Column Name Type Null? Definition
ACCESSION VARCHAR(256) Y This field contains the ACCESSION number (alphanumeric) for the report. It is parsed from the REPORT_NAME field if available.
ADHOC_AREA_CODE CHAR(10) Y Area code to use if RRD
ADHOC_COUNTRY_ACCESS CHAR(3) Y Country access to use if RRD
ADHOC_EXCHANGE CHAR(10) Y Exchange number to use if this is RRD
ADHOC_PHONE_SUFFIX VARCHAR(50) Y Phone number suffix to use if this is RRD
APPLCTX DOUBLE Y Application context number of requesting app
CHECKSUM DOUBLE Y Used to store checksum of the reprinted file
CHILD_HANDLE_ID DOUBLE N Handle id for any child jobs associated with this handle
CREATE_DT_TM DATETIME Y The date/time this entry was created.
DELIVER_DT_TM DATETIME Y When this reprint is to be distributed via RRD
DEVICE_CD DOUBLE N Device id that was used for reprinting
FILE_IDENTIFIER VARCHAR(64) Y The media object identifier for the output context file.
FILE_LOCATION VARCHAR(128) Y This field contains the full file pathname or is blank if the pathname is specified in the FILE_NAME field. It may be a UNC path or a path specific to a particular node. It may contain logicals such as CER_PRINT.
FILE_NAME VARCHAR(128) Y This field contains the base filename. If FILE_LOCATION is blank, this field may contain the full path and filename. If there is a pathname, it may be a UNC path or a path specific to a particular node. It may contain logicals such as CER_PRINT.
HANDLE_ID DOUBLE N This handle is the uniqueID used to track entries on this table, i.e. print jobs. It is the primary key of this table.
MRN VARCHAR(256) Y This field contains the MRN for the report. It is parsed from the REPORT_NAME field if available.
NOTIFICATION_TYPE DOUBLE Y This field specifies the type of notification that would be sent to the user identified by the NOTIFY_USER_ID field. Used by RRD.
NOTIFY_USER_ID DOUBLE N The user id for RRD to notify
NUMBER_OF_PAGES DOUBLE Y This field contains the number of pages in a file or 0 if pagination has not been performed.
OUTPUT_DEST_CD DOUBLE N The output destination id that this reprint was sent to
PARENT_HANDLE_ID DOUBLE N The handle ID to any parent of this job
PEER_HANDLE_ID DOUBLE N The handle ID to any peer jobs that are part of this reprint
PERSON_NAME VARCHAR(128) Y This field contains the name of the person who is the subject of this report. It is parsed from the REPORT_NAME field if available.
PHONE_NUMBER VARCHAR(73) Y This field contains the entire phone number for ADHOC faxes. It is a composite of the fields ADHOC_COUNTRY_ACCESS, ADHOC_AREA_CODE, ADHOC_EXCHANGE, and ADHOC_PHONE_SUFFIX
PRIORITY DOUBLE Y Reprint priority
PURGE_DT_TM DATETIME Y The date and time this handle and file should be purge
REPORT_NAME VARCHAR(255) Y The name of the report
REPRINT_HANDLE_ID DOUBLE N The handle id of any reprints of this file
REQUESTING_USER_ID DOUBLE N The user id of the requester
SECURITY DOUBLE Y The security tag
SERVER VARCHAR(128) Y The server name
STATUS_FLAG DOUBLE Y The status flag is used in printing to track the state of a document. The field is not used for RRD reports in favor of the transmission_status_cd field on the REPORT_QUEUE table.The following values are supported: 0 = checked out 1 = checked in / ready to process 2 = processing 3 = completed 99 = generic error status
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - OUTPUTCTX


Child Column in OUTPUTCTX(FK) Parent Table Name Parent Column Name
Parents: CHILD_HANDLE_ID OUTPUTCTX HANDLE_ID
PARENT_HANDLE_ID OUTPUTCTX HANDLE_ID
PEER_HANDLE_ID OUTPUTCTX HANDLE_ID




Parent Column in OUTPUTCTX (PK) Child Table Name Child Column Name
Children: HANDLE_ID CDI_WORK_ITEM_ACTION OUTPUTCTX_HANDLE_ID
CHART_REQUEST HANDLE_ID
CR_REPORT_REQUEST RRD_HANDLE_ID
ENCNTR_CARE_MGMT_COMM HANDLE_ID
OUTPUTCTX CHILD_HANDLE_ID
OUTPUTCTX PARENT_HANDLE_ID
OUTPUTCTX PEER_HANDLE_ID
RRDBRIDGE OUTPUT_HANDLE_ID


PC_ATTRIBUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: PC Attribute
Definition: This table is a reference table for PC attributes. It will hold all PC attributes.
Table Type: REFERENCE





Column Detail - PC_ATTRIBUTE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ATTRIBUTE_DESC VARCHAR(500) Y The PC attribute description
ATTRIBUTE_DISPLAY_NAME VARCHAR(256) Y The PC attribute display name
ATTRIBUTE_ID DOUBLE N Primary Key; Unique number identifying the PC attribute
ATTRIBUTE_LOC_NAME VARCHAR(100) N The PC attribute location path name
ATTRIBUTE_LOC_PATH VARCHAR(256) N The PC attribute location path
ATTRIBUTE_NAME VARCHAR(50) N The PC attribute name
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PC_ATTRIBUTE




Parent Column in PC_ATTRIBUTE (PK) Child Table Name Child Column Name
Children: ATTRIBUTE_ID PC_ATTRIBUTE_VALUE ATTRIBUTE_ID


PC_ATTRIBUTE_VALUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: PC Attribute Value
Definition: This table is a reference table for all PC attributes' values. It will hold the values for the attributes of a particular PC defined in the Millennium system.
Table Type: REFERENCE





Column Detail - PC_ATTRIBUTE_VALUE


Column Name Type Null? Definition
ATTRIBUTE_ID DOUBLE N Unique number identifying the PC attributes (PC_ATTRIBUTE)
ATTRIBUTE_VALUE_ID DOUBLE N Primary Key; Unique number identifying the PC attribute value
ATTRIBUTE_VALUE_OUTPUT_DEST_CD DOUBLE N The PC attribute output destination code value; Unique number identifying an output destination (OUTPUT_DEST)
ATTRIBUTE_VALUE_TXT VARCHAR(100) N The PC attribute textual value
DEVICE_CD DOUBLE N Unique number identifying the PC device (DEVICE)
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PC_ATTRIBUTE_VALUE


Child Column in PC_ATTRIBUTE_VALUE(FK) Parent Table Name Parent Column Name
Parents: DEVICE_CD DEVICE DEVICE_CD
ATTRIBUTE_VALUE_OUTPUT_DEST_CD OUTPUT_DEST OUTPUT_DEST_CD
ATTRIBUTE_ID PC_ATTRIBUTE ATTRIBUTE_ID


REMOTE_DEVICE



Column Section Top of Page


Table-level Detail

Description: Remote Device Table
Definition: THE Remote Device Table
Table Type: REFERENCE





Column Detail - REMOTE_DEVICE


Column Name Type Null? Definition
ACCESS_CD DOUBLE N Unique numberColumn
AREA_CODE CHAR(25) Y Area code for the remote device
COUNTRY_ACCESS CHAR(25) Y Country access number for the remote deviceColumn
DEVICE_ADDRESS_TYPE_CD DOUBLE N Unique number for the Device Address TypeColumn
DEVICE_CD DOUBLE N Unique number for the DeviceColumn
EXCHANGE CHAR(25) Y Exchange portion of the phone numberColumn
LOCAL_FLAG DOUBLE Y Local FlagColumn
PHONE_MASK_ID DOUBLE N Identifies the phone mask used for this deviceColumn
PHONE_SUFFIX CHAR(50) Y Phone suffix portion of the phone numberColumn
REMOTE_DEV_TYPE_ID DOUBLE N Unique number that identifies the remote device type attached to this remote device.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


REMOTE_DEVICE_TYPE



Column Section Top of Page


Table-level Detail

Description: REMOTE DEVICE TYPE
Definition: Defines the type of device at the remote site.
Table Type: REFERENCE





Column Detail - REMOTE_DEVICE_TYPE


Column Name Type Null? Definition
BAUD_RATE DOUBLE Y Baud RateColumn
DATA_BITS DOUBLE Y Data BitsColumn
DATA_TYPE_CD DOUBLE Y The type of device.Column
DEVICE_MODE CHAR(1) Y Device ModeColumn
DEVICE_TYPE_CD DOUBLE Y Device TypeColumn
LINE_SPEED DOUBLE Y Line speedColumn
NAME VARCHAR(20) Y Name of Remote DeviceColumn
OUTPUT_FORMAT_CD DOUBLE Y Printer Driver NameColumn
PARITY CHAR(1) Y ParityColumn
PRINTER_SETUP_INFO VARCHAR(50) Y Printer SetupColumn
REMOTE_DEV_TYPE_ID DOUBLE N Unique numeric identifierColumn
RESOLUTION VARCHAR(25) Y ResolutionColumn
STOP_BIT DOUBLE Y Stop bitColumn
TRANS_CPI DOUBLE Y Trans cpiColumn
TRANS_LPI DOUBLE Y Trans lpiColumn
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.