POOL_CERTIFICATE Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
PoolCertificateCurrentAmount	MISMOAmount	DECIMAL(0, 2)	NO	The current dollar amount of the certificate.
PoolCertificateHolderPayeeIdentifier	MISMOIdentifier	VARCHAR(0)	NO	The Payee Identifier which identifies the certificate holder.
PoolCertificateIdentifier	MISMOIdentifier	VARCHAR(0)	NO	The certificate identifier assigned to the pool security.
PoolCertificateInitialPaymentDate	MISMODate	DATE	NO	The date that the first payment is due to the security holder for the certificate.
PoolCertificateIssueDate	MISMODate	DATE	NO	The date the certificate was issued.
PoolCertificateMaturityDate	MISMODate	DATE	NO	The date that the final payment is due to the security holder for the certificate.
PoolCertificateOriginalAmount	MISMOAmount	DECIMAL(0, 2)	NO	The original dollar amount of the certificate.
PoolCertificatePrincipalPaidAmount	MISMOAmount	DECIMAL(0, 2)	NO	The amount of principal paid to the security holder for the last accounting period.

POOL_CERTIFICATE Keys

Key Name

Key Type

Keys

POOL_CERTIFICATE 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_CERTIFICATE Check Constraints

Check Constraint Name

CheckConstraint

POOL_CERTIFICATE Bound Attachments

Name	Current Value

POOL_CERTIFICATE User-Defined Mappings

Model

Name

Description

POOL_CERTIFICATE Data Movement Rules

Name

Type

Rule Text/Value