ALEX_XMDBTOOL (Attributes)

Column	Data type	Null	Description
XMDBTOOL_ID	INTEGER	N	PK
TABLE_NAME	VARCHAR(255)	N	Table Name that is involved in the current transaction. Only table entries that available here are authorized for upload or download based on the loadtype value.
SEQUENCE	INTEGER	N	This attribute sets the hierarchical values for the table. If all the tables in the given module are at the same level and if there is no parent child relationship between the tables, this attribute should be set to 0. If there is parent child relationship defined then the header table ,or the root table, in the given module should have this attribute set to 1. All other child tables should have this attribute value set to 2. Remember , that in a given module, if the tables in the module have the parent child relationship, then the root node, or in other words, the table that has no parent, can only have 1 set in this attribute.
XMTYPE	CHAR(1)	N	Indicates the Authorization for the table. If authorized for upload it should be U and if authorized for download it should be D and if authorized for both it can be marked as B.
MODULE	VARCHAR(255)	N	Defines the Module Name. Each module can have multiple tables present. In case the table is not part of any module , then this attribute will have the value set to NM.
PRE_QUERY	VARCHAR(MAX)	Y	Define a prequery, generally an SQL update statement that should be applied to the related table, before the start of the standard transaction, initiated by client process. The sql statements can have placeholder values instead of the actual hard-coded values. These placeholder values can be replaced by the actual values that are passed from the client side. For e.g. update alex_application_filter set data_key = 07895D where data_key = %datakeyvalue% where datakeyvalue is the placeholder variable. This variable will be replaced by the actual value say 07575D which is passed from the client side parameter.
INLINE_QUERY	VARCHAR(MAX)	Y	Define a Inline Query, which is a standard sql select statement, that can be applied to the related table, during the standard transaction, initiated by client process. The sql statements can have placeholder values instead of the actual hard-coded values. These placeholder values can be replaced by the actual values that are passed from the client side. For e.g. select * from alex_application_filter where data_key = %datakeyvalue% where datakeyvalue is the placeholder variable. This variable will be replaced by the actual value say 07575D which is passed as the client side parameter.
POST_QUERY	VARCHAR(MAX)	Y	Define a postquery, essentially an update statement that should be applied to the related table, after the end of the standard transaction, initiated by client process. The sql statements can have placeholder values instead of the actual hard-coded values. These placeholder values can be replaced by the actual values that are passed from the client side.
HAS_CHILD	INTEGER	N	Used for situations where we have parent child relationship. If there is no parent child relation ship this value will be 0. Else if this table has got corresponding child tables then it will have the value of 1 which indicates that this table has got child tables.
PARENT_ID	INTEGER	N	Used again only in situations where there is a parent child relationship. If there is no parent child relationship between the tables in the module OR if there is no parent to this table, this value will always be 0. Else this value will be having the Xmdbtool_id of its parent table.. For e.g. if there are 2 tables t1 and t2 in a given module and t2 is the child of t1. And assume that the xmdbtool_id of t1 is 20 and xmdbool_id of t2 is 21, Then the parentId of t1 will be set to 0 and parentId of t2 will be having the value of 20.
TIME_RANGE	VARCHAR(255)	Y	This is used set time limits as to when the user can initiate a client process. Ideally this parameter can be set as time window and its only during this allowed time-window the user can initiate a upload or download process.
ACTIVE_STATUS	SMALLINT	N	Set this to 1 to make the entry active else mark it to 0 to make it ineffective.
CHANGE_TIMESTAMP	TIMESTAMP	Y	The entry data time value.
POST_QUERY_SFTP	TEXT	Y	SQL query can be run in case the SFTP transfer fails.

XMDBTOOL_ID

INTEGER

N

PK

TABLE_NAME

VARCHAR(255)

N

Table Name that is involved in the current transaction. Only table entries that available here are authorized for upload or download based on the loadtype value.

SEQUENCE

INTEGER

N

This attribute sets the hierarchical values for the table. If all the tables in the given module are at the same level and if there is no parent child relationship between the tables, this attribute should be set to 0. If there is parent child relationship defined then the header table ,or the root table, in the given module should have this attribute set to 1. All other child tables should have this attribute value set to 2. Remember , that in a given module, if the tables in the module have the parent child relationship, then the root node, or in other words, the table that has no parent, can only have 1 set in this attribute.

XMTYPE

CHAR(1)

N

Indicates the Authorization for the table. If authorized for upload it should be U and if authorized for download it should be D and if authorized for both it can be marked as B.

MODULE

VARCHAR(255)

N

Defines the Module Name. Each module can have multiple tables present. In case the table is not part of any module , then this attribute will have the value set to NM.

PRE_QUERY

VARCHAR(MAX)

Y

Define a prequery, generally an SQL update statement that should be applied to the related table, before the start of the standard transaction, initiated by client process. The sql statements can have placeholder values instead of the actual hard-coded values. These placeholder values can be replaced by the actual values that are passed from the client side. For e.g. update alex_application_filter set data_key = 07895D where data_key = %datakeyvalue% where datakeyvalue is the placeholder variable. This variable will be replaced by the actual value say 07575D which is passed from the client side parameter.

INLINE_QUERY

VARCHAR(MAX)

Y

Define a Inline Query, which is a standard sql select statement, that can be applied to the related table, during the standard transaction, initiated by client process. The sql statements can have placeholder values instead of the actual hard-coded values. These placeholder values can be replaced by the actual values that are passed from the client side. For e.g. select * from alex_application_filter where data_key = %datakeyvalue% where datakeyvalue is the placeholder variable. This variable will be replaced by the actual value say 07575D which is passed as the client side parameter.

POST_QUERY

VARCHAR(MAX)

Y

Define a postquery, essentially an update statement that should be applied to the related table, after the end of the standard transaction, initiated by client process. The sql statements can have placeholder values instead of the actual hard-coded values. These placeholder values can be replaced by the actual values that are passed from the client side.

HAS_CHILD

INTEGER

N

Used for situations where we have parent child relationship. If there is no parent child relation ship this value will be 0. Else if this table has got corresponding child tables then it will have the value of 1 which indicates that this table has got child tables.

PARENT_ID

INTEGER

N

Used again only in situations where there is a parent child relationship. If there is no parent child relationship between the tables in the module OR if there is no parent to this table, this value will always be 0. Else this value will be having the Xmdbtool_id of its parent table.. For e.g. if there are 2 tables t1 and t2 in a given module and t2 is the child of t1. And assume that the xmdbtool_id of t1 is 20 and xmdbool_id of t2 is 21, Then the parentId of t1 will be set to 0 and parentId of t2 will be having the value of 20.

TIME_RANGE

VARCHAR(255)

Y

This is used set time limits as to when the user can initiate a client process. Ideally this parameter can be set as time window and its only during this allowed time-window the user can initiate a upload or download process.

ACTIVE_STATUS

SMALLINT

N

Set this to 1 to make the entry active else mark it to 0 to make it ineffective.

CHANGE_TIMESTAMP

TIMESTAMP

Y

The entry data time value.

POST_QUERY_SFTP

TEXT

Y

SQL query can be run in case the SFTP transfer fails.