Skip to content

BILLING_CASHSEC_INTEREST_PAY

Indicates the amount of cash security interest payment the participant receives.

Package

BILLING_RUN

Visibility

Private

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
CONTRACTYEAR numeric(4, 0) 🔑 smallint 🔑 ContractYear/ WeekNo/ BillRunNo for the Interest payment
WEEKNO numeric(3, 0) 🔑 smallint 🔑 The Billing WeekNo
BILLRUNNO numeric(3, 0) 🔑 smallint 🔑 The Billing RunNo
CASH_SECURITY_ID varchar(20) 🔑 varchar(20) 🔑 The Cash Security ID
PARTICIPANTID varchar(20) varchar(10) Unique identifier for the Participant lodging the cash security
CASH_AMOUNT numeric(18, 8) numeric(18, 8) Dollar amount of the cash security
INTEREST_ACCT_ID varchar(20) varchar(20) The interest account ID for calculating the interest payment
INTEREST_AMOUNT numeric(18, 8) numeric(18, 8) Interest amount calculated for the billing week
LASTCHANGED datetime(3) datetime2(0) The last changed date time of the record

Official MMS data model indexes

Index name Index type Index columns (in order)
BILLING_CASHSEC_INTERESTPAY_PK clustered, unique, primary key CONTRACTYEAR, WEEKNO, BILLRUNNO, CASH_SECURITY_ID

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_BILLING_CASHSEC_INTEREST_PAY clustered, unique, primary key CONTRACTYEAR, WEEKNO, BILLRUNNO, CASH_SECURITY_ID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
PK_BILLING_CASHSEC_INTEREST_PAY clustered, unique, primary key CONTRACTYEAR, WEEKNO, BILLRUNNO, CASH_SECURITY_ID