Transaction Table

This table contains summary of all e-claim transactions downloaded or uploaded by GA.

Column Name	Data Type	Allow Nulls	Description
UniqueId	nvarchar(50)	No	Unique ID of the transaction in the database. This is auto incremental number generated by database automatically when new record is added. This column is Primary Key.
TransactionTypeId	smallint	No	Transaction Type ID assigned by Greenrain Connect Framework.
PostOfficeId	nvarchar(100)	Yes	Transaction ID assigned by Post Office. This ID is most likely always empty for transactions uploaded to Post Office as current upload API supported by Post Office does not return ID value. This value is to `UploadMemberRegistrationResponse.FileId` returned from DHPO upon Member.Register transaction upload.
SenderId	nvarchar(20)	No	Sender ID – who is the transaction sender.
ReceiverId	nvarchar(20)	No	Receiver ID – who is the transaction receiver.
TransactionDate	datetime	No	Transaction date extracted from e-claim file.
RecordCount	int	No	Number of records in the e-claim file.
DispositionFlagId	tinyint	No	Disposition Flag ID assigned by Greenrain Connect Framework.
FileName	nvarchar(150)	Yes	Transaction file name as it is received from Post Office or sent to Post Office.
Content	varbinary(MAX)	Yes	Transaction file content.
UploadDate	datetime	Yes	Date and time when transaction has been successfully uploaded to Post Office. This field is NULL for transactions downloaded from Post Office.
PostOfficeReturnCode	int	Yes	For Member.Register transaction uploaded to DHPO: this value is set to `UploadMemberRegistrationResponse.Result` returned from DHPO.
PostOfficeReturnMessage	nvarchar(MAX)	Yes	For Member.Register transaction uploaded to DHPO: This value is to `UploadMemberRegistrationResponse.ErrorMessage` returned from DHPO.
DownloadDate	datetime	Yes	Date and time when transaction has been downloaded from Post Office. This field is NULL for transactions uploaded to Post Office.

Greenrain Automation Help

Transaction Table

Analytics

Related content