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 |