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. |