Table Detail Report

CDI_CM_FOLDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: CPDI Content Management Folder
Definition: Stores content management folder information.
Table Type: REFERENCE





Column Detail - CDI_CM_FOLDER


Column Name Type Null? Definition
CDI_CM_FOLDER_ID DOUBLE N Unique generated number that identifies a single row on the CDI_CM_FOLDER table.
FOLDER_NAME VARCHAR(255) N The name of the content management folder.
FOLDER_TYPE_FLAG DOUBLE N Identifies a purpose for this folder. 0 = Not specified, 1 = Search folder, 2 = Shared folder, 3 - Staged search folder.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
SEARCH_ORDER DOUBLE N The order search folders are used when searching for a document where a lower search order indicates the folder be searched sooner. A search order of 1 indicates the folder where new images are saved (domain default).
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 - CDI_CM_FOLDER


Child Column in CDI_CM_FOLDER(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in CDI_CM_FOLDER (PK) Child Table Name Child Column Name
Children: CDI_CM_FOLDER_ID CDI_ARCHIVE_FOLDER_RELTN CDI_CM_FOLDER_ID


CDI_CM_LOGIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Content Management Login
Definition: This table defines users that can be used to login to the 3rd party content management system.
Table Type: REFERENCE





Column Detail - CDI_CM_LOGIN


Column Name Type Null? Definition
CDI_CM_LOGIN_ID DOUBLE N The unique primary key for this table.
CM_PASSWORD VARCHAR(64) N The password for the 3rd party system.
CM_USERNAME VARCHAR(64) N The username for the 3rd party system.
ORGANIZATION_ID DOUBLE N The organization the user is associated with.
ORG_DEFAULT_IND DOUBLE N Indicates that this is the default user to be used for any position that does not have a specific user associated.
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 - CDI_CM_LOGIN


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




Parent Column in CDI_CM_LOGIN (PK) Child Table Name Child Column Name
Children: CDI_CM_LOGIN_ID CDI_CM_LOGIN_POSITION CDI_CM_LOGIN_ID


CDI_CM_LOGIN_POSITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Content Management Login Position
Definition: This table associates users defined in the CDI_CM_LOGIN table to MIllenium user's positions.
Table Type: REFERENCE





Column Detail - CDI_CM_LOGIN_POSITION


Column Name Type Null? Definition
CDI_CM_LOGIN_ID DOUBLE N The unique identifier for the CDI_CM_Login table. It associates a row in this table to the CDI_CM_Login table.
CDI_CM_LOGIN_POSITION_ID DOUBLE N This is the unique primary key of this table.
POSITION_CD DOUBLE N The Millennium user's position code that this user is associated with.
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 - CDI_CM_LOGIN_POSITION


Child Column in CDI_CM_LOGIN_POSITION(FK) Parent Table Name Parent Column Name
Parents: CDI_CM_LOGIN_ID CDI_CM_LOGIN CDI_CM_LOGIN_ID


CDI_COVER_PAGE_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CPDI Cover Page Template
Definition: Stores templates used to generate cover pages used when faxing CPDI documents outbound.
Table Type: REFERENCE





Column Detail - CDI_COVER_PAGE_TEMPLATE


Column Name Type Null? Definition
CDI_COVER_PAGE_TEMPLATE_ID DOUBLE N Unique generated number that identifies a single row on the CDI_COVER_PAGE_TEMPLATE table.
LONG_TEXT_ID DOUBLE N Foreign key to the LONG_TEXT table row containing the contents of the template.
TEMPLATE_NAME VARCHAR(100) N The name of the template.
TEMPLATE_NAME_KEY VARCHAR(100) N The name key of the template.
TEMPLATE_NAME_KEY_A_NLS VARCHAR(400) N Stores the corresponding non-english ACCENTED character set values for the TEMPLATE_NAME_KEY column.
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 - CDI_COVER_PAGE_TEMPLATE


Child Column in CDI_COVER_PAGE_TEMPLATE(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID


CDI_DOCUMENT_CHECKOUT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CPDI Document Checkout
Definition: Tracks user checkouts of CPDI documents.
Table Type: ACTIVITY





Column Detail - CDI_DOCUMENT_CHECKOUT


Column Name Type Null? Definition
AX_APPID DOUBLE N The Application Identification from the OTG database for this document.
AX_DOCID DOUBLE N The document Identification from the OTG database for this document.
BLOB_HANDLE VARCHAR(255) N Identifier of the document that is checked out.
CDI_DOCUMENT_CHECKOUT_ID DOUBLE N Unique generated number that identifies a single row on the CDI_DOCUMENT_CHECKOUT table.
CHECKOUT_DT_TM DATETIME Y Date and time the document was checked out.
PERSON_ID DOUBLE N ID of the person who has the document checked out.
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 - CDI_DOCUMENT_CHECKOUT


Child Column in CDI_DOCUMENT_CHECKOUT(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PRSNL PERSON_ID