ACH_ABARoutingAndTransitIdentifier 
Base Entity  ACH 
Attribute Name  ACH_ABARoutingAndTransitIdentifier 
Logical Rolename   
ColumnName  ACH_ABARoutingAndTransitIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  9 digit routing and transit number for the bank from which the payment is drafted 
Note 
 

ACH_ABARoutingAndTransitIdentifier Logical Attribute Properties 
Logical Attribute Name  ACH_ABARoutingAndTransitIdentifier 
Datatype  VARCHAR(0) 
Nullable  NO 

ACH_ABARoutingAndTransitIdentifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ACH_ABARoutingAndTransitIdentifier Bound Attachments 
Name  Current Value 

ACH_ABARoutingAndTransitIdentifier User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ACH_ABARoutingAndTransitIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACH_ABARoutingAndTransitIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACH_ABARoutingAndTransitIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACH_ABARoutingAndTransitIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACHAccountType 
Base Entity  ACH 
Attribute Name  ACHAccountType 
Logical Rolename   
ColumnName  ACHAccountType 
RoleName   
Domain  ACHAccountEnum 
Definition  The account type from which the payment is drafted  
Note 
 

ACHAccountType Logical Attribute Properties 
Logical Attribute Name  ACHAccountType 
Datatype  VARCHAR(0) 
Nullable  YES 

ACHAccountType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ACHAccountType Reference Value (Bound to Domain) 
Name  ValidationRule 
Description   
Type  By List 
Value  Value Description 
Checking  Checking 
Savings  Savings 

ACHAccountType Bound Attachments 
Name  Current Value 

ACHAccountType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ACHAccountType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHAccountType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHAccountType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACHAccountType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACHAdditionalEscrowAmount 
Base Entity  ACH 
Attribute Name  ACHAdditionalEscrowAmount 
Logical Rolename   
ColumnName  ACHAdditionalEscrowAmount 
RoleName   
Domain  MISMOAmount 
Definition  Dollar amount beyond the normal PITI that is be drafted and applied to the escrow account. 
Note 
 

ACHAdditionalEscrowAmount Logical Attribute Properties 
Logical Attribute Name  ACHAdditionalEscrowAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

ACHAdditionalEscrowAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ACHAdditionalEscrowAmount Bound Attachments 
Name  Current Value 

ACHAdditionalEscrowAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ACHAdditionalEscrowAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHAdditionalEscrowAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHAdditionalEscrowAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACHAdditionalEscrowAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACHAdditionalPrincipalAmount 
Base Entity  ACH 
Attribute Name  ACHAdditionalPrincipalAmount 
Logical Rolename   
ColumnName  ACHAdditionalPrincipalAmount 
RoleName   
Domain  MISMOAmount 
Definition  Dollar amount beyond the normal PITI that is be drafted and applied to reduce the principal of the loan. 
Note 
 

ACHAdditionalPrincipalAmount Logical Attribute Properties 
Logical Attribute Name  ACHAdditionalPrincipalAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

ACHAdditionalPrincipalAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ACHAdditionalPrincipalAmount Bound Attachments 
Name  Current Value 

ACHAdditionalPrincipalAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ACHAdditionalPrincipalAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHAdditionalPrincipalAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHAdditionalPrincipalAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACHAdditionalPrincipalAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACHBankAccountIdentifier 
Base Entity  ACH 
Attribute Name  ACHBankAccountIdentifier 
Logical Rolename   
ColumnName  ACHBankAccountIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  The number identifying the account from which the payment is drafted 
Note 
 

ACHBankAccountIdentifier Logical Attribute Properties 
Logical Attribute Name  ACHBankAccountIdentifier 
Datatype  VARCHAR(0) 
Nullable  NO 

ACHBankAccountIdentifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ACHBankAccountIdentifier Bound Attachments 
Name  Current Value 

ACHBankAccountIdentifier User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ACHBankAccountIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHBankAccountIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHBankAccountIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACHBankAccountIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACHDraftAfterDueDateDayCount 
Base Entity  ACH 
Attribute Name  ACHDraftAfterDueDateDayCount 
Logical Rolename   
ColumnName  ACHDraftAfterDueDateDayCount 
RoleName   
Domain  MISMOCount 
Definition  The number of days past the payment due date that payment drafting is scheduled to occur. Payment due date plus ACH Draft Days after Due Date equals draft date. 
Note 
 

ACHDraftAfterDueDateDayCount Logical Attribute Properties 
Logical Attribute Name  ACHDraftAfterDueDateDayCount 
Datatype  INTEGER 
Nullable  NO 

ACHDraftAfterDueDateDayCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ACHDraftAfterDueDateDayCount Bound Attachments 
Name  Current Value 

ACHDraftAfterDueDateDayCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ACHDraftAfterDueDateDayCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHDraftAfterDueDateDayCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHDraftAfterDueDateDayCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACHDraftAfterDueDateDayCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACHDraftFrequencyType 
Base Entity  ACH 
Attribute Name  ACHDraftFrequencyType 
Logical Rolename   
ColumnName  ACHDraftFrequencyType 
RoleName   
Domain  ACHDraftFrequencyEnum 
Definition  Indicates how frequently the servicer drafts the scheduled mortgage payment from the account of the borrower .  
Note 
 

ACHDraftFrequencyType Logical Attribute Properties 
Logical Attribute Name  ACHDraftFrequencyType 
Datatype  VARCHAR(0) 
Nullable  YES 

ACHDraftFrequencyType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ACHDraftFrequencyType Reference Value (Bound to Domain) 
Name  ValidationRule1 
Description   
Type  By List 
Value  Value Description 
Annually  Annually 
Biweekly  Biweekly 
Daily  Daily 
Monthly  Monthly 
Quarterly  Quarterly 
Semiannually  Semiannually 
Semimonthly  Semimonthly 
Weekly  Weekly 

ACHDraftFrequencyType Bound Attachments 
Name  Current Value 

ACHDraftFrequencyType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ACHDraftFrequencyType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHDraftFrequencyType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHDraftFrequencyType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACHDraftFrequencyType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACHDraftingPartyName 
Base Entity  ACH 
Attribute Name  ACHDraftingPartyName 
Logical Rolename   
ColumnName  ACHDraftingPartyName 
RoleName   
Domain  MISMOString 
Definition  Identifies who is drafting the payment on the loan. 
Note 
 

ACHDraftingPartyName Logical Attribute Properties 
Logical Attribute Name  ACHDraftingPartyName 
Datatype  VARCHAR(0) 
Nullable  NO 

ACHDraftingPartyName Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ACHDraftingPartyName Bound Attachments 
Name  Current Value 

ACHDraftingPartyName User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ACHDraftingPartyName Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHDraftingPartyName Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHDraftingPartyName Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACHDraftingPartyName Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACHInstitutionTelegraphicAbbreviationName 
Base Entity  ACH 
Attribute Name  ACHInstitutionTelegraphicAbbreviationName 
Logical Rolename   
ColumnName  ACHInstitutionTelegraphicAbbreviationName 
RoleName   
Domain  MISMOString 
Definition  The abbreviated name of the depository institution assigned by the Federal Reserve. 
Note 
 

ACHInstitutionTelegraphicAbbreviationName Logical Attribute Properties 
Logical Attribute Name  ACHInstitutionTelegraphicAbbreviationName 
Datatype  VARCHAR(0) 
Nullable  NO 

ACHInstitutionTelegraphicAbbreviationName Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ACHInstitutionTelegraphicAbbreviationName Bound Attachments 
Name  Current Value 

ACHInstitutionTelegraphicAbbreviationName User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ACHInstitutionTelegraphicAbbreviationName Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHInstitutionTelegraphicAbbreviationName Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHInstitutionTelegraphicAbbreviationName Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACHInstitutionTelegraphicAbbreviationName Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACHPendingDraftEffectiveDate 
Base Entity  ACH 
Attribute Name  ACHPendingDraftEffectiveDate 
Logical Rolename   
ColumnName  ACHPendingDraftEffectiveDate 
RoleName   
Domain  MISMODate 
Definition  Identifies the date on which automated drafting is scheduled to begin. 
Note 
 

ACHPendingDraftEffectiveDate Logical Attribute Properties 
Logical Attribute Name  ACHPendingDraftEffectiveDate 
Datatype  DATE 
Nullable  NO 

ACHPendingDraftEffectiveDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ACHPendingDraftEffectiveDate Bound Attachments 
Name  Current Value 

ACHPendingDraftEffectiveDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ACHPendingDraftEffectiveDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHPendingDraftEffectiveDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHPendingDraftEffectiveDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACHPendingDraftEffectiveDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACHReceiverSubaccountName 
Base Entity  ACH 
Attribute Name  ACHReceiverSubaccountName 
Logical Rolename   
ColumnName  ACHReceiverSubaccountName 
RoleName   
Domain  MISMOString 
Definition  The subaccount name for the receiver of the wire. 
Note 
 

ACHReceiverSubaccountName Logical Attribute Properties 
Logical Attribute Name  ACHReceiverSubaccountName 
Datatype  VARCHAR(0) 
Nullable  NO 

ACHReceiverSubaccountName Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ACHReceiverSubaccountName Bound Attachments 
Name  Current Value 

ACHReceiverSubaccountName User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ACHReceiverSubaccountName Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHReceiverSubaccountName Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHReceiverSubaccountName Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACHReceiverSubaccountName Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACHType 
Base Entity  ACH 
Attribute Name  ACHType 
Logical Rolename   
ColumnName  ACHType 
RoleName   
Domain  ACHEnum 
Definition  Indicates if the ACH information is current or pending.  
Note 
 

ACHType Logical Attribute Properties 
Logical Attribute Name  ACHType 
Datatype  VARCHAR(0) 
Nullable  YES 

ACHType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ACHType Reference Value (Bound to Domain) 
Name  ValidationRule2 
Description   
Type  By List 
Value  Value Description 
Current  Current 
Pending  Pending 

ACHType Bound Attachments 
Name  Current Value 

ACHType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ACHType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACHType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACHWireAmount 
Base Entity  ACH 
Attribute Name  ACHWireAmount 
Logical Rolename   
ColumnName  ACHWireAmount 
RoleName   
Domain  MISMOAmount 
Definition  The dollar amount of funds being transferred by the wire. 
Note 
 

ACHWireAmount Logical Attribute Properties 
Logical Attribute Name  ACHWireAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

ACHWireAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ACHWireAmount Bound Attachments 
Name  Current Value 

ACHWireAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ACHWireAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHWireAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACHWireAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACHWireAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description