DMS_SERVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Digital media services Service table.
Definition: Contains a list of the various distribution services in the Digital Media Service sub-system.
Table Type: REFERENCE





Column Detail - DMS_SERVICE


Column Name Type Null? Definition
DESTINATION_SERVER_NAME VARCHAR(32) Y The name of the destination print server for external printing use.
DMS_SERVICE_ID DOUBLE N Unique identifier for the row.
HOST_NAME VARCHAR(64) N The host name for this distribution service.
SERVICE_NAME VARCHAR(64) N The name of the distribution service that this row refers to.
SERVICE_TYPE VARCHAR(32) N The type of service that this distribution service refers to.
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 - DMS_SERVICE




Parent Column in DMS_SERVICE (PK) Child Table Name Child Column Name
Children: DMS_SERVICE_ID DEVICE DMS_SERVICE_ID


FILTER_ENTITY_RELTN



Column Section Top of Page


Table-level Detail

Description: Filter Entity Relation
Definition: This table contains Filter Entity Relationships that allow for filtering of data based on different entities
Table Type: REFERENCE





Column Detail - FILTER_ENTITY_RELTN


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
EXCLUSION_FILTER_IND DOUBLE Y Determines if the filter is an Exclusion or an Inclusion Filter
FILTER_ENTITY1_ID DOUBLE N The value of the primary identifier of the table to which contains the filter data
FILTER_ENTITY1_NAME VARCHAR(30) N The upper case name of the table which contains the filter data
FILTER_ENTITY2_ID DOUBLE N The value of the primary identifier of the table to which contains the filter data
FILTER_ENTITY2_NAME VARCHAR(30) Y The upper case name of the table which contains the filter data
FILTER_ENTITY3_ID DOUBLE N The value of the primary identifier of the table to which contains the filter data
FILTER_ENTITY3_NAME VARCHAR(30) Y The upper case name of the table which contains the filter data
FILTER_ENTITY4_ID DOUBLE N The value of the primary identifier of the table to which contains the filter data
FILTER_ENTITY4_NAME VARCHAR(30) Y The upper case name of the table which contains the filter data
FILTER_ENTITY5_ID DOUBLE N The value of the primary identifier of the table to which contains the filter data
FILTER_ENTITY5_NAME VARCHAR(30) Y The upper case name of the table which contains the filter data
FILTER_ENTITY_RELTN_ID DOUBLE N The primary key of the Filter Entity Relation table
FILTER_TYPE_CD DOUBLE N The type of filter that is being used
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the Entity is stored on.
PARENT_ENTITY_NAME VARCHAR(30) N The upper case name of the table to which this Entity row is stored on
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.


FILTER_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Filter Type
Definition: This table contains the filter types defined to be used for the filter entity relation.
Table Type: REFERENCE





Column Detail - FILTER_TYPE


Column Name Type Null? Definition
ALLOW_EXCLUSION_IND DOUBLE Y Allow exclusion indicator
BUILD_TOOL_IND DOUBLE Y build tool indicator
FILTER_ENTITY1_NAME VARCHAR(30) N filter entity1 name
FILTER_ENTITY2_NAME VARCHAR(30) Y filter entity2 name
FILTER_ENTITY3_NAME VARCHAR(30) Y filter entity3 name
FILTER_ENTITY4_NAME VARCHAR(30) Y filter entity4 name
FILTER_ENTITY5_NAME VARCHAR(30) Y filter entity5 name
FILTER_TYPE1_ID DOUBLE N FILTER TYPE1 IDENTIFIER
FILTER_TYPE1_TXT VARCHAR(12) N FILTER TYPE1 TEXT
FILTER_TYPE2_ID DOUBLE N FILTER TYPE2 IDENTIFIER
FILTER_TYPE2_TXT VARCHAR(12) Y FILTER TYPE2 TEXT
FILTER_TYPE3_ID DOUBLE N FILTER TYPE3 IDENTIFIER
FILTER_TYPE3_TXT VARCHAR(12) Y FILTER TYPE3 TEXT
FILTER_TYPE4_ID DOUBLE N FILTER TYPE4 IDENTIFIER
FILTER_TYPE4_TXT VARCHAR(12) Y FILTER TYPE4 TEXT
FILTER_TYPE5_ID DOUBLE N FILTER TYPE5 IDENTIFIER
FILTER_TYPE5_TXT VARCHAR(12) Y FILTER TYPE5 TEXT
FILTER_TYPE_CD DOUBLE N FILTER TYPE CODE
GET_SCRIPT_NAME VARCHAR(32) N get script name
PARENT_ENTITY_NAME VARCHAR(30) N The upper case name of the table to which this address row is related (i.e., PERSON, PRSNL, ORGANIZATION, etc.)
PARENT_TYPE_ID DOUBLE N parent type identifier
PARENT_TYPE_TXT VARCHAR(12) N parent type text
SEARCH_COMPONENT_NAME VARCHAR(32) N search component name
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 - FILTER_TYPE


Child Column in FILTER_TYPE(FK) Parent Table Name Parent Column Name
Parents: FILTER_TYPE_CD CODE_VALUE CODE_VALUE


FILTER_TYPE_DATA



Column Section Top of Page


Table-level Detail

Description: Filter Type Data
Definition: This table contains the filter types defined to be used for the filter entity relations that have filtered data.
Table Type: REFERENCE





Column Detail - FILTER_TYPE_DATA


Column Name Type Null? Definition
FILTER_ENTITY1_ID DOUBLE N The value of the primary identifier of the table to which contains the filter data
FILTER_ENTITY1_NAME VARCHAR(30) N filter_entity1_name
FILTER_ENTITY2_ID DOUBLE N The value of the primary identifier of the table to which contains the filter data
FILTER_ENTITY2_NAME VARCHAR(30) Y filter_entity2_name
FILTER_ENTITY3_ID DOUBLE N The value of the primary identifier of the table to which contains the filter data
FILTER_ENTITY3_NAME VARCHAR(30) Y filter_entity3_name
FILTER_ENTITY4_ID DOUBLE N The value of the primary identifier of the table to which contains the filter data
FILTER_ENTITY4_NAME VARCHAR(30) Y filter_entity4_name
FILTER_ENTITY5_ID DOUBLE N The value of the primary identifier of the table to which contains the filter data
FILTER_ENTITY5_NAME VARCHAR(30) Y filter_entity5_name
FILTER_TYPE_CD DOUBLE N Filter type code
FILTER_TYPE_DATA_ID DOUBLE N Filter type data identifier
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.


FORM_LIBRARY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Form Library
Definition: Stores information for each form library
Table Type: REFERENCE





Column Detail - FORM_LIBRARY


Column Name Type Null? Definition
FORM_LIBRARY_ID DOUBLE N PRIMARY KEY
FORM_LIBRARY_NAME VARCHAR(200) Y The name of the form library
FORM_NAME VARCHAR(200) Y The name of the form
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




Parent Column in FORM_LIBRARY (PK) Child Table Name Child Column Name
Children: FORM_LIBRARY_ID FORM_LIBRARY_MAPPING FORM_LIBRARY_ID