Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
BATCH_DTT |
|
DATE |
NO |
Name: BATCH DATE Description: The date time that overall import was executed. |
MESSAGE_GROUP_NAME |
|
VARCHAR(50) |
NO |
Name: MESSAGE GROUP NAME Description: The import data type that record pertains to. |
FILE_NAME |
|
VARCHAR(254) |
NO |
Name: FILE NAME Description: Import data source file name or table name. |
MESSAGE_NAME |
|
VARCHAR(50) |
NO |
Name: MESSAGE NAME Description: Would be same as MESSAGE_GROUP_NAME for URS. |
S_SOURCE_CD |
|
VARCHAR(10) |
NO |
Name: S SOURCE CODE Description: The source of the import data. |
EXTERNAL_USER |
|
VARCHAR(20) |
YES |
Name: EXTERNAL USER Description: User ID of the non-TC user initiating the insert into the Import table. |
START_DTT |
|
DATE |
NO |
Name: START DATE Description: The start date time that source for import data type was processed. |
END_DTT |
|
DATE |
YES |
Name: END DATE Description: The end date time that source for import data type was processed. |
READ_NO |
|
NUMERIC(10, 0) |
NO |
Name: READ NUMBER Description: The counter for the source import data type for records read. |
UPDATE_NO |
|
NUMERIC(10, 0) |
NO |
Name: UPDATE NUMBER Description: The counter for the source import data type for records updated. |
INSERT_NO |
|
NUMERIC(10, 0) |
NO |
Name: INSERT NUMBER Description: The counter for the source import data type for records inserted. |
DELETE_NO |
|
NUMERIC(10, 0) |
NO |
Name: DELETE NUMBER Description: The counter for the source import data type for records deleted. |
REJECTED_NO |
|
NUMERIC(10, 0) |
NO |
Name: REJECTED NUMBER Description: The counter for the source import data type for records rejected. |
ROWVERSION |
|
NUMERIC(10, 0) |
NO |
|
MODIFIED_BY |
|
VARCHAR(20) |
NO |
|
TIME_STAMP |
|
DATE |
NO |
|