Data Broker Pipeline Efforts
>
Exception Item Processing
>
Schema
Exception Item Processing Schema
accountdetail_fct_cdd
Column
Type
Description
Id
STRING
This attribute defines the unique identifier exception this detail record is associated with.
InstitutionUniversalId
STRING
This attribute defines the unique identifier of the institution.
OfficerId
STRING
This attribute defines the identifier of the officer associated with the account.
EntityNumber
STRING
This attribute defines the entity number associated with the account.
NameOnAccount
STRING
This attribute defines the name on the account.
CreatedDateTime
TIMESTAMP
This attribute defines the date and time the account detail was created.
TransactionDate
DATE
This attribute defines the date of the transaction associated with the account detail.
achdetail_fct_cdd
Column
Type
Description
Id
STRING
This attribute defines the unique identifier exception this detail record is associated with.
InstitutionUniversalId
STRING
This attribute defines the unique identifier of the institution.
CreatedDateTime
TIMESTAMP
This attribute defines the date and time the ACH detail was created.
TransactionDate
DATE
This attribute defines the date of the transaction associated with the ACH detail.
AchCode
STRING
This attribute defines the ACH transaction code, indicating whether the entry is a debit or credit and if it’s related to checking, savings, or loan accounts.
AchFileKey
STRING
This attribute defines a unique key for the ACH file, used to identify the file within the ACH network.
AchBatch
STRING
This attribute defines the batch number within the ACH file, grouping related transactions together.
AchSequence
STRING
This attribute defines the sequence number of the transaction within the ACH batch.
AchStdEntryClassCode
STRING
This attribute defines the Standard Entry Class (SEC) code, which designates the type of ACH transactions, such as PPD for direct deposits or CCD for corporate credits/debits.
AchCompanyId
STRING
This attribute defines the company identification number used in the ACH transaction.
AchCompanyName
STRING
This attribute defines the name of the company involved in the ACH transaction.
OdfiRoutingNumber
STRING
This attribute defines the routing number of the Originating Depository Financial Institution (ODFI) that initiated the ACH transaction.
gldetail_fct_cdd
Column
Type
Description
Id
STRING
This attribute defines the unique identifier exception this detail record is associated with.
InstitutionUniversalId
STRING
This attribute defines the unique identifier of the institution.
CreatedDateTime
TIMESTAMP
This attribute defines the date and time the NSF detail was created.
TransactionDate
DATE
This attribute defines the date of the transaction associated with the NSF detail.
GlBranchId
STRING
ID of the branch associated with the general ledger account.
CostCenter
STRING
Cost center code associated with general ledger account.
ProductCode
STRING
Product code associated with general ledger account.
GlDescription
STRING
A description of the general ledger entry.
GlTransactionReference
STRING
Contains information that refers to the transaction that is associated with the general ledger entry.
nsfdetail_fct_cdd
Column
Type
Description
Id
STRING
This attribute defines the unique identifier exception this detail record is associated with.
InstitutionUniversalId
STRING
This attribute defines the unique identifier of the institution.
CreatedDateTime
TIMESTAMP
This attribute defines the date and time the NSF detail was created.
TransactionDate
DATE
This attribute defines the date of the transaction associated with the NSF detail.
ServiceChargeCode
STRING
This attribute defines the code for the service charge applied to the NSF transaction.
WaiveWithinTolerance
BOOL
This attribute indicates whether the NSF fee is waived within a specified tolerance.
PostingAvailableBalance_CurrencyType
STRING
This attribute defines the currency type of the posting available balance.
PostingAvailableBalance_Value
FLOAT64
This attribute defines the value of the posting available balance.
eipitem_fct_cdd
Column
Type
Description
Id
STRING
This attribute defines the unique identifier of the exception item.
InstitutionId
STRING
This attribute defines the unique identifier of the institution.
Status
STRING
This attribute defines the status of the exception item.
TransactionExceptionType
STRING
This attribute defines the type of transaction exception.
TransactionStatus
STRING
This attribute defines the status of the transaction.
TransactionDate
DATE
This attribute defines the date of the transaction.
RepostHandling
STRING
This attribute defines how reposting is handled.
ExceptionSource
STRING
This attribute defines the source of the exception.
AssignedTo
STRING
This attribute defines who the exception item is assigned to.
CreatedBy
STRING
This attribute defines who created the exception item.
LastChangedBy
STRING
This attribute defines who last changed the exception item.
CreatedDateTime
TIMESTAMP
This attribute defines the date and time the exception item was created.
LastChangedDateTime
TIMESTAMP
This attribute defines the date and time the exception item was last changed.
BranchId
STRING
This attribute defines the unique identifier of the branch.
DebitCredit
STRING
This attribute defines whether the transaction is a debit or credit.
Description
STRING
This attribute defines the description of the exception item.
TransactionAmount
FLOAT64
This attribute defines the amount of the transaction.
TransactionExceptionDescription
STRING
This attribute defines the description of the transaction exception.
TransactionID
STRING
This attribute defines the unique identifier of the transaction.
CurrencyType
STRING
This attribute defines the type of currency used in the transaction.
TransactionType
STRING
This attribute defines the type of transaction.
TransactionSourceTracerNumber
STRING
This attribute defines the source tracer number of the transaction.
eipitemfeedetail_fct_cdd
Column
Type
Description
Id
STRING
This attribute defines the unique identifier of exception item the fee is associated with.
InstitutionId
STRING
This attribute defines the unique identifier of the institution.
FeeDecision
STRING
This attribute defines the decision regarding the fee.
FeeWaiveReason
STRING
This attribute defines the reason for waiving the fee.
FeeWaivedBy
STRING
This attribute defines who waived the fee.
FeeDescription
STRING
This attribute defines the description of the fee.
PrintNotice
STRING
This attribute defines the print notice status.
AssessedFee
FLOAT64
This attribute defines the assessed fee amount.
CalculatedFee
FLOAT64
This attribute defines the calculated fee amount.
eipitemmutable_fct_cdd
Column
Type
Description
Id
STRING
This attribute defines the unique identifier of the exception item.
InstitutionId
STRING
This attribute defines the unique identifier of the institution.
AccountNumber
STRING
This attribute defines the account number associated with the exception item.
OriginalAccountNumber
STRING
This attribute defines the original account number before any changes.
TransactionCode
STRING
This attribute defines the transaction code associated with the exception item.
OriginalTransactionCode
STRING
This attribute defines the original transaction code before any changes.
AccountId
STRING
This attribute defines the account identifier associated with the exception item.
OriginalAccountId
STRING
This attribute defines the original account identifier before any changes.
AccountType
STRING
This attribute defines the type of account associated with the exception item.
OriginalAccountType
STRING
This attribute defines the original account type before any changes.
CheckNumber
STRING
This attribute defines the check number associated with the exception item.
OriginalCheckNumber
STRING
This attribute defines the original check number before any changes.
EffectiveDate
DATE
This attribute defines the effective date of the exception item.
ReturnReason
STRING
This attribute defines the reason for returning the exception item.
OnUsReturn
BOOL
This attribute indicates whether the return is on us (belonging to the same financial institution).
eipitemnote_fct_cdd
Column
Type
Description
Id
STRING
This attribute defines the unique identifier of the note.
InstitutionId
STRING
This attribute defines the unique identifier of the institution.
ExceptionItemId
STRING
This attribute defines the unique identifier of the exception item the note is associated with.
NoteSubject
STRING
This attribute defines the subject of the note.
NoteContent
STRING
This attribute defines the content of the note.
CreatedBy
STRING
This attribute defines who created the note.
LastChangedBy
STRING
This attribute defines who last changed the note.
CreatedDateTime
TIMESTAMP
This attribute defines the date and time the note was created.
LastChangedDateTime
TIMESTAMP
This attribute defines the date and time the note was last changed.