Table Detail Report

PL_MENU_OPTIONS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PL MENU OPTIONS
Definition: Stores the menu and tab options that will be available for the associated client
Table Type: REFERENCE





Column Detail - PL_MENU_OPTIONS


Column Name Type Null? Definition
DISPLAY_LABEL CHAR(30) Y The display label for the menu option.
MENU_CD DOUBLE N Identifies the menu or tab option that should be enabled
MENU_SEQUENCE DOUBLE Y Used to determine if the default row exists.
ORGANIZATION_ID DOUBLE N Organization id is the key to the table, which identifies the client for which these defaults will be used.
PL_MENU_OPTIONS_ID DOUBLE N Unique identifier for the row.
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 - PL_MENU_OPTIONS


Child Column in PL_MENU_OPTIONS(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


PL_ORG_LOGO_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: PL ORG LOGO XREF
Definition: This table holds the cross-reference for an Organization and chosen Logo.
Table Type: REFERENCE





Column Detail - PL_ORG_LOGO_XREF


Column Name Type Null? Definition
FORMAT_CD DOUBLE N Used to define the format of the stored image (bmp, jpeg,...). Code set 23.
LOGO_NAME VARCHAR(100) Y The name of the stored image and the path it was loaded from.
LONG_BLOB_ID DOUBLE N Unique identifier to LONG_BLOB table used to store image.
ORGANIZATION_ID DOUBLE N Unique identifier to the Organization table.
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 - PL_ORG_LOGO_XREF


Child Column in PL_ORG_LOGO_XREF(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


PL_PC_ORG_DIAG_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: PL PC ORG DIAG XREF
Definition: Defines the diagnoses for an org.
Table Type: REFERENCE





Column Detail - PL_PC_ORG_DIAG_XREF


Column Name Type Null? Definition
NOMENCLATURE_ID DOUBLE N Unique key from nomencature table.
ORGANIZATION_ID DOUBLE N Unique key from ORGANIZATION table.
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 - PL_PC_ORG_DIAG_XREF


Child Column in PL_PC_ORG_DIAG_XREF(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


PL_PC_ORG_GRP_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: PL PC ORG GRP XREF
Definition: PC - Org cross reference table.
Table Type: REFERENCE





Column Detail - PL_PC_ORG_GRP_XREF


Column Name Type Null? Definition
ALT_SEL_CATEGORY_ID DOUBLE N Key indicator from ALT_SEQ_CAT table.
ORGANIZATION_ID DOUBLE N Unique id from ORGANIZATION table.
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 - PL_PC_ORG_GRP_XREF


Child Column in PL_PC_ORG_GRP_XREF(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


PL_PC_ORG_TAB_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: PL PC ORG TAB XREF
Definition: Define procs on tabs for an org.
Table Type: REFERENCE





Column Detail - PL_PC_ORG_TAB_XREF


Column Name Type Null? Definition
ORGANIZATION_ID DOUBLE N Unique key from ORGANIZATION table.
SYNONYM_ID DOUBLE N Unique key from ORDER_CATALOG_SYNONYM table.
SYNONYM_SEQ DOUBLE N An into specifying the place of the synonym on the tab.
TAB_DESCRIPTION CHAR(15) Y Name of the tab.
TAB_SEQ DOUBLE N An into specifying the place of the tab in group.
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 - PL_PC_ORG_TAB_XREF


Child Column in PL_PC_ORG_TAB_XREF(FK) Parent Table Name Parent Column Name
Parents: SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID