POOL_DETAIL

POOL_DETAIL

EntityType	Dependent
Logical Entity Name	POOL_DETAIL
Default Table Name	MESSAGE/DOCUMENT_SETS/DOCUMENT_SET/DOCUMENTS/DOCUMENT/DEAL_SETS/DEAL_SET/POOL/POOL_DETAIL
Definition
Note

POOL_DETAIL Attributes

Attribute/Logical Rolename Domain Datatype NULL Definition

PoolAccrualRateStructureType PoolAccrualRateStructureEnum VARCHAR(0) YES Specifies the structure used to determine the accrual interest rate for the pool.

PoolAmortizationType AmortizationEnum VARCHAR(0) YES A classification or description for a pool of loans generally based on the variability of the rate or payment over time.The changeability of the rate or payment over time.

PoolAmortizationTypeOtherDescription MISMOString VARCHAR(0) NO A free-form text field used to collect additional information or a description of the mortgage type when Other is selected for Pool Amortization Type.

PoolAssumabilityIndicator MISMOIndicator BIT NO Indicates whether the pool is backed by loans that are assumable by another borrower.

PoolBalloonIndicator MISMOIndicator BIT NO Indicates whether or not the pool is backed by loans where a final balloon payment is required under the terms of the loan repayment schedule to fully pay off the loan.

PoolClassType PoolClassEnum VARCHAR(0) YES Indicates the type of pool and its guarantor (if any).

PoolClassTypeOtherDescription MISMOString VARCHAR(0) NO A free-form text field used to capture the Pool Class if Other is selected as the Pool Class Type.

PoolCurrentLoanCount MISMOCount INTEGER NO The current number of mortgages in the pool with principal balances as of the last cutoff.

PoolCurrentPrincipalBalanceAmount MISMOAmount DECIMAL(0, 2) NO Total dollar amount of the remaining unpaid principal balance for a pool of mortgages as of the last cutoff.

PoolCUSIPIdentifier MISMOIdentifier VARCHAR(0) NO Unique identifier for a security according to the standards set by Committee on Uniform Security Identification Practices. The CUSIP is registered with the SEC and the Federal Reserve.

PoolFixedServicingFeePercent MISMOPercent DECIMAL(0, 2) NO The servicing fee to be used in determining the rate of interest that accrues on an mortgage backed security (MBS) pool that has a weighted-average structure based on a fixed servicing fee.

PoolGuarantyFeeRatePercent MISMOPercent DECIMAL(0, 2) NO The percentage of the guaranty fee rate that applies to loans in the pool that do not have a rate specified at the individual loan level.

PoolIdentifier MISMOIdentifier VARCHAR(0) NO The unique identifier for a group or pool of loans. May include relevant prefix and suffix when not parsed into applicable fields. See Pool Prefix Identifier or Pool Suffix Identifier.

PoolingMethodType PoolingMethodEnum VARCHAR(0) YES Indicates the timing of the remittance of the scheduled principal and interest payment from the servicer to the certificate holders of a particular pool.

PoolingMethodTypeOtherDescription MISMOString VARCHAR(0) NO A free-form text field used to capture the Pooling Method Type if Other is selected.

PoolInterestAdjustmentIndexLeadDaysCount MISMOCount INTEGER NO The number of days prior to an interest rate effective date used to determine the date for the index value when calculating a new interest rate for a pool of loans.

PoolInterestAndPaymentAdjustmentIndexLeadDaysCount MISMOCount INTEGER NO The number of days prior to an interest rate effective date used to determine the date for the index value when calculating both a new interest rate and a principal and interest payment for a pool of loans.

PoolInterestOnlyIndicator MISMOIndicator BIT NO Indicates whether a pool is backed by loans with interest only payments.

PoolInterestRateRoundingPercent MISMOPercent DECIMAL(0, 2) NO The percentage to which the interest rate is rounded when a new interest rate is calculated for a pool. This field is used in conjunction with Pool Interest Rate Rounding Type which indicates how the rounding should occur.

PoolInterestRateRoundingType InterestRateRoundingEnum VARCHAR(0) YES Indicates how the interest rate is rounded when a new interest rate is calculated for a pool of loans.Specifies how the interest rate is rounded when a new interest rate is calculated for an ARM change. The interest rate can be rounded Up, Down or to the Nearest Percent. This field is used in conjunction with Interest Rate Rounding Percent which indicates the percentage to which the rounding occurs.

PoolInterestRateTruncatedDigitsCount MISMOCount INTEGER NO Indicates the number of digits the interest rate should be truncated for a pool.

PoolInvestorProductPlanIdentifier MISMOIdentifier VARCHAR(0) NO Identifies the plan of the varying loan payment and/or rate change characteristics for a pool of loans issued by the servicer.

PoolIssueDate MISMODate DATE NO The date a mortgage backed security is issued to investors.

PoolIssuerIdentifier MISMOIdentifier VARCHAR(0) NO Identification number assigned by pool guarantor to the Issuer or current servicer of the pool.

PoolMarginRatePercent MISMOPercent DECIMAL(0, 2) NO The factor that is added to the ARM index value to calculate the pool accrual rate.

PoolMaturityDate MISMODate DATE NO The date the final payment is due on the pool. The pool maturity date is typically 15 to 45 days after the maturity date of the latest maturing mortgage in the mortgage-backed security.

PoolMaximumAccrualRatePercent MISMOPercent DECIMAL(0, 2) NO The maximum rate, expressed as a percent, at which interest can accrue on a pool.

PoolMinimumAccrualRatePercent MISMOPercent DECIMAL(0, 2) NO The minimum rate, expressed as a percent, at which interest can accrue on a pool.

PoolMortgageRatePercent MISMOPercent DECIMAL(0, 2) NO The annual interest rate, expressed as a percent, of the mortgages in a pool as of last cutoff date.

PoolMortgageType MortgageEnum VARCHAR(0) YES Specifies mortgage type of the loans for the pool.

PoolMortgageTypeOtherDescription MISMOString VARCHAR(0) NO A free-form text field used to collect additional information or a description of the mortgage type when Other is selected for Pool Mortgage Type.

PoolOriginalLoanCount MISMOCount INTEGER NO The total number of loans in the pool when the pool was set up.

PoolOriginalPrincipalBalanceAmount MISMOAmount DECIMAL(0, 2) NO The total of the original principal balance of all the loans in the pool. For participations the principal balance contributed for an individual loan is adjusted based upon the participation percent.

PoolOwnershipPercent MISMOPercent DECIMAL(0, 2) NO Identifies the percentage amount of the pool owned by the investor.

PoolPrefixIdentifier MISMOIdentifier VARCHAR(0) NO The prefix associated with the pool identifier.

PoolScheduledPrincipalAndInterestPaymentAmount MISMOAmount DECIMAL(0, 2) NO Total scheduled dollar amount of the principal and interest payments of the underlying loans as of the last cutoff date.

PoolScheduledRemittancePaymentDay MISMODay DATE NO Indicates the day of the month the servicer must remit the scheduled pass through payment to the certificate holders of a particular pool.

PoolSecurityInterestRatePercent MISMOPercent DECIMAL(0, 2) NO The security interest rate, expressed as a percent, for the pool as of last cutoff date.

PoolSecurityIssueDateInterestRatePercent MISMOPercent DECIMAL(0, 2) NO The security interest rate, expressed as a percent, for the pool as of the security issue date.

PoolServiceFeeRatePercent MISMOPercent DECIMAL(0, 2) NO The annualized rate, expressed as a percent, used to compute the fee paid to the servicer as of the last cutoff date.

PoolStructureType PoolStructureEnum VARCHAR(0) YES Denotes the type of mortgage backed security structure.

PoolStructureTypeOtherDescription MISMOString VARCHAR(0) NO A free form text field used to collect additional information when Other is selected for Pool Structure Type.

PoolSuffixIdentifier MISMOIdentifier VARCHAR(0) NO Suffix associated with the pool identifier.

PoolUnscheduledPrincipalPaymentDay MISMODay DATE NO Indicates the day of the month the servicer must remit unscheduled principal payments to the certificate holders of a particular pool if they are to be remitted sooner than the scheduled remittance day.

SecurityTradeBookEntryDate MISMODate DATE NO The date that the security will be delivered to the designated book entry account.

SecurityTradeCustomerAccountIdentifier MISMOIdentifier VARCHAR(0) NO The securities trading account identifier assigned to a customer by an investor.

POOL_DETAIL Keys

Key Name Key Type Keys

POOL_DETAIL Relationships

Parent Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Supertype

POOL Identifying One to Zero or One NO

Child Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Subtype

POOL_DETAIL Check Constraints

Check Constraint Name CheckConstraint

POOL_DETAIL Bound Attachments

Name Current Value

POOL_DETAIL User-Defined Mappings

Model Name Description

POOL_DETAIL Data Movement Rules

Name Type Rule Text/Value

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
PoolAccrualRateStructureType	PoolAccrualRateStructureEnum	VARCHAR(0)	YES	Specifies the structure used to determine the accrual interest rate for the pool.
PoolAmortizationType	AmortizationEnum	VARCHAR(0)	YES	A classification or description for a pool of loans generally based on the variability of the rate or payment over time.The changeability of the rate or payment over time.
PoolAmortizationTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to collect additional information or a description of the mortgage type when Other is selected for Pool Amortization Type.
PoolAssumabilityIndicator	MISMOIndicator	BIT	NO	Indicates whether the pool is backed by loans that are assumable by another borrower.
PoolBalloonIndicator	MISMOIndicator	BIT	NO	Indicates whether or not the pool is backed by loans where a final balloon payment is required under the terms of the loan repayment schedule to fully pay off the loan.
PoolClassType	PoolClassEnum	VARCHAR(0)	YES	Indicates the type of pool and its guarantor (if any).
PoolClassTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to capture the Pool Class if Other is selected as the Pool Class Type.
PoolCurrentLoanCount	MISMOCount	INTEGER	NO	The current number of mortgages in the pool with principal balances as of the last cutoff.
PoolCurrentPrincipalBalanceAmount	MISMOAmount	DECIMAL(0, 2)	NO	Total dollar amount of the remaining unpaid principal balance for a pool of mortgages as of the last cutoff.
PoolCUSIPIdentifier	MISMOIdentifier	VARCHAR(0)	NO	Unique identifier for a security according to the standards set by Committee on Uniform Security Identification Practices. The CUSIP is registered with the SEC and the Federal Reserve.
PoolFixedServicingFeePercent	MISMOPercent	DECIMAL(0, 2)	NO	The servicing fee to be used in determining the rate of interest that accrues on an mortgage backed security (MBS) pool that has a weighted-average structure based on a fixed servicing fee.
PoolGuarantyFeeRatePercent	MISMOPercent	DECIMAL(0, 2)	NO	The percentage of the guaranty fee rate that applies to loans in the pool that do not have a rate specified at the individual loan level.
PoolIdentifier	MISMOIdentifier	VARCHAR(0)	NO	The unique identifier for a group or pool of loans. May include relevant prefix and suffix when not parsed into applicable fields. See Pool Prefix Identifier or Pool Suffix Identifier.
PoolingMethodType	PoolingMethodEnum	VARCHAR(0)	YES	Indicates the timing of the remittance of the scheduled principal and interest payment from the servicer to the certificate holders of a particular pool.
PoolingMethodTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to capture the Pooling Method Type if Other is selected.
PoolInterestAdjustmentIndexLeadDaysCount	MISMOCount	INTEGER	NO	The number of days prior to an interest rate effective date used to determine the date for the index value when calculating a new interest rate for a pool of loans.
PoolInterestAndPaymentAdjustmentIndexLeadDaysCount	MISMOCount	INTEGER	NO	The number of days prior to an interest rate effective date used to determine the date for the index value when calculating both a new interest rate and a principal and interest payment for a pool of loans.
PoolInterestOnlyIndicator	MISMOIndicator	BIT	NO	Indicates whether a pool is backed by loans with interest only payments.
PoolInterestRateRoundingPercent	MISMOPercent	DECIMAL(0, 2)	NO	The percentage to which the interest rate is rounded when a new interest rate is calculated for a pool. This field is used in conjunction with Pool Interest Rate Rounding Type which indicates how the rounding should occur.
PoolInterestRateRoundingType	InterestRateRoundingEnum	VARCHAR(0)	YES	Indicates how the interest rate is rounded when a new interest rate is calculated for a pool of loans.Specifies how the interest rate is rounded when a new interest rate is calculated for an ARM change. The interest rate can be rounded Up, Down or to the Nearest Percent. This field is used in conjunction with Interest Rate Rounding Percent which indicates the percentage to which the rounding occurs.
PoolInterestRateTruncatedDigitsCount	MISMOCount	INTEGER	NO	Indicates the number of digits the interest rate should be truncated for a pool.
PoolInvestorProductPlanIdentifier	MISMOIdentifier	VARCHAR(0)	NO	Identifies the plan of the varying loan payment and/or rate change characteristics for a pool of loans issued by the servicer.
PoolIssueDate	MISMODate	DATE	NO	The date a mortgage backed security is issued to investors.
PoolIssuerIdentifier	MISMOIdentifier	VARCHAR(0)	NO	Identification number assigned by pool guarantor to the Issuer or current servicer of the pool.
PoolMarginRatePercent	MISMOPercent	DECIMAL(0, 2)	NO	The factor that is added to the ARM index value to calculate the pool accrual rate.
PoolMaturityDate	MISMODate	DATE	NO	The date the final payment is due on the pool. The pool maturity date is typically 15 to 45 days after the maturity date of the latest maturing mortgage in the mortgage-backed security.
PoolMaximumAccrualRatePercent	MISMOPercent	DECIMAL(0, 2)	NO	The maximum rate, expressed as a percent, at which interest can accrue on a pool.
PoolMinimumAccrualRatePercent	MISMOPercent	DECIMAL(0, 2)	NO	The minimum rate, expressed as a percent, at which interest can accrue on a pool.
PoolMortgageRatePercent	MISMOPercent	DECIMAL(0, 2)	NO	The annual interest rate, expressed as a percent, of the mortgages in a pool as of last cutoff date.
PoolMortgageType	MortgageEnum	VARCHAR(0)	YES	Specifies mortgage type of the loans for the pool.
PoolMortgageTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to collect additional information or a description of the mortgage type when Other is selected for Pool Mortgage Type.
PoolOriginalLoanCount	MISMOCount	INTEGER	NO	The total number of loans in the pool when the pool was set up.
PoolOriginalPrincipalBalanceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The total of the original principal balance of all the loans in the pool. For participations the principal balance contributed for an individual loan is adjusted based upon the participation percent.
PoolOwnershipPercent	MISMOPercent	DECIMAL(0, 2)	NO	Identifies the percentage amount of the pool owned by the investor.
PoolPrefixIdentifier	MISMOIdentifier	VARCHAR(0)	NO	The prefix associated with the pool identifier.
PoolScheduledPrincipalAndInterestPaymentAmount	MISMOAmount	DECIMAL(0, 2)	NO	Total scheduled dollar amount of the principal and interest payments of the underlying loans as of the last cutoff date.
PoolScheduledRemittancePaymentDay	MISMODay	DATE	NO	Indicates the day of the month the servicer must remit the scheduled pass through payment to the certificate holders of a particular pool.
PoolSecurityInterestRatePercent	MISMOPercent	DECIMAL(0, 2)	NO	The security interest rate, expressed as a percent, for the pool as of last cutoff date.
PoolSecurityIssueDateInterestRatePercent	MISMOPercent	DECIMAL(0, 2)	NO	The security interest rate, expressed as a percent, for the pool as of the security issue date.
PoolServiceFeeRatePercent	MISMOPercent	DECIMAL(0, 2)	NO	The annualized rate, expressed as a percent, used to compute the fee paid to the servicer as of the last cutoff date.
PoolStructureType	PoolStructureEnum	VARCHAR(0)	YES	Denotes the type of mortgage backed security structure.
PoolStructureTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to collect additional information when Other is selected for Pool Structure Type.
PoolSuffixIdentifier	MISMOIdentifier	VARCHAR(0)	NO	Suffix associated with the pool identifier.
PoolUnscheduledPrincipalPaymentDay	MISMODay	DATE	NO	Indicates the day of the month the servicer must remit unscheduled principal payments to the certificate holders of a particular pool if they are to be remitted sooner than the scheduled remittance day.
SecurityTradeBookEntryDate	MISMODate	DATE	NO	The date that the security will be delivered to the designated book entry account.
SecurityTradeCustomerAccountIdentifier	MISMOIdentifier	VARCHAR(0)	NO	The securities trading account identifier assigned to a customer by an investor.

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
POOL	Identifying	One to Zero or One					NO