Table Detail Report

FORM_LIBRARY_MAPPING



Column Section Relationship Section Top of Page


Table-level Detail

Description: FORM LIBRARY MAPPIG
Definition: Maps the form library configuration of the printer to the its printer device
Table Type: REFERENCE





Column Detail - FORM_LIBRARY_MAPPING


Column Name Type Null? Definition
COPIES_NBR DOUBLE Y The amount of copies
FORM_LIBRARY_ID DOUBLE Y The ID of the default form library for the printer
FORM_LIBRARY_MAPPING_ID DOUBLE N PRIMARY KEY
OUTPUT_DISABLED_IND DOUBLE Y Indicates if the given mapping will disable printer output. Default of off.
PRINTER_ID DOUBLE Y The DEVICE_CD of the mapped printer
REDIRECT_PRINTER_ID DOUBLE Y The DEVICE_CD of the redirect printer;
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - FORM_LIBRARY_MAPPING


Child Column in FORM_LIBRARY_MAPPING(FK) Parent Table Name Parent Column Name
Parents: PRINTER_ID DEVICE DEVICE_CD
REDIRECT_PRINTER_ID DEVICE DEVICE_CD
FORM_LIBRARY_ID FORM_LIBRARY FORM_LIBRARY_ID


OUTPUT_DEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Output Destination
Definition: Output Destination Table
Table Type: REFERENCE





Column Detail - OUTPUT_DEST


Column Name Type Null? Definition
DESCRIPTION VARCHAR(100) Y Output Destination Name
DEVICE_CD DOUBLE N Unique Number identifying the Device
JOB_FILE_PATH VARCHAR(1000) Y This will allow teams who support label printing to specify custom locations for printer-specific file storage.
LABEL_PREFIX VARCHAR(20) Y Prefix for the label
LABEL_PROGRAM_NAME VARCHAR(20) Y Label Program Name
LABEL_XPOS DOUBLE Y Label XPos
LABEL_YPOS DOUBLE Y Label YPos
NAME VARCHAR(20) Y Output Destination Name
OUTPUT_DEST_CD DOUBLE N Unique number identifying the Output Destination
OUTPUT_DEVICE_CD DOUBLE N Output Device
OUTPUT_TO_FILE_IND DOUBLE Y Indicator
SCRIPT VARCHAR(100) Y scrip
TAMPERPROOF_IND DOUBLE N Indicates wether an output dest is capable of tamperproof printing
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 - OUTPUT_DEST




Parent Column in OUTPUT_DEST (PK) Child Table Name Child Column Name
Children: OUTPUT_DEST_CD CHART_REQUEST OUTPUT_DEST_CD
CHART_SERVER_PRINTER OUTPUT_DEST_CD
CR_OUTPUT_DESTINATION OUTPUT_DEST_CD
CR_REPORT_REQUEST OUTPUT_DEST_CD
EEM_ABN_FORM OUTPUT_DEST_ID
ENCNTR_CARE_MGMT_COMM OUTPUT_DEST_ID
EXPEDITE_MANUAL OUTPUT_DEST_CD
EXPEDITE_PARAMS OUTPUT_DEST_CD
MIC_ANG_TIMES PRINTER_CD
MIC_SEQ_PRINTER OUTPUT_DEST_ID
ORD_FAVORITE_DEST OUTPUT_DEST_ID
OUTPUT_DEST_XREF OUTPUT_DEST_CD
PC_ATTRIBUTE_VALUE ATTRIBUTE_VALUE_OUTPUT_DEST_CD
PM_DOC_PRINT_HIST OUTPUT_DESTINATION_ID
PM_POST_DOC_REF OUTPUT_DEST_CD
PROP_ORDER LABEL_PRINTER_ID
SCH_ACTION_NOTIFY OUTPUT_DEST_ID
SCH_NOTIFY OUTPUT_DEST_ID
SCH_ROUTE_LIST OUTPUT_DEST_ID
SN_RPT_DEST OUTPUT_DEST_ID
STATION OUTPUT_DEST_CD


OUTPUT_DEST_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Output Destination Cross Reference
Definition: This table will be used by applications to store off default output destinations
Table Type: REFERENCE





Column Detail - OUTPUT_DEST_XREF


Column Name Type Null? Definition
OUTPUT_DEST_CD DOUBLE N Id of the xrefed output destination
PARENT_ENTITY_ID DOUBLE N Id of the entity xrefed to this output dest entry
PARENT_ENTITY_NAME VARCHAR(30) N The name of the parent entity id xrefed
PRINT_POINT_CD DOUBLE N The PRINT_POINT_CD identifies if the packet is printed at order time, completion time, or only manually
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.
USAGE_TYPE_CD DOUBLE N Device type code of the device which the output dest that is xref points to.



Relationship Detail - OUTPUT_DEST_XREF


Child Column in OUTPUT_DEST_XREF(FK) Parent Table Name Parent Column Name
Parents: OUTPUT_DEST_CD OUTPUT_DEST OUTPUT_DEST_CD


PRINTER



Column Section Top of Page


Table-level Detail

Description: PRINTER
Definition: This table lists printers and their attributes.
Table Type: REFERENCE





Column Detail - PRINTER


Column Name Type Null? Definition
DEFAULT_CUSTOM_FORM_NAME VARCHAR(256) Y The default custom form for printing for the specified output destination code.
DEFAULT_ORIENTATION_FLAG DOUBLE N The default paper orientation for the specified output destination code: 1 - portrait, 2 - landscape.
DEFAULT_PAPER_HANDLING_FLAG DOUBLE N The default paper handling for the specified output destination code: 1 - simplex, 2 - duplex (long-edge binding, vertical), 3 - tumble (short-edge binding, horizontal).
DEFAULT_TRAY_NAME VARCHAR(20) Y The default tray name for the specifed output destination code.
DEVICE_CD DOUBLE N Number derived from Outputctx_seq or Reference_seq. Must match the device_cd of the device record that represents the printer. It is the unique primary key of the Printer table.
DEVICE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
IPP_LEGACY_FLAG DOUBLE N Controls if the IPP Legacy feature flag is forced on or off for this printer.
PRINTER_TYPE_CD DOUBLE N DIO printer type derived from the associated code set.
TIMEZONE_CD DOUBLE N This column is no longer used
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.