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 |