BILLING_NMAS_MANUAL_RECOVERY
This report shows the summary of the Billing NMAS Recovery Amounts. This table will have recovery data for manual payments for System Security Services.
Package
BILLING_RUN
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
The Billing Contract Year. |
| WEEKNO |
numeric(3, 0) |
smallint |
The Billing WeekNo |
| BILLRUNNO |
numeric(4, 0) |
smallint |
The Billing RunNo |
| PARTICIPANTID |
varchar(20) |
varchar(10) |
The Contract Participant Id. |
| CONTRACTID |
varchar(20) |
varchar(20) |
The NMAS System Security Contract ID. |
| SERVICETYPE |
varchar(40) |
varchar(40) |
The NMAS System Security Service Types (INERTIA, SYSTEM STRENGTH, TYPE1, TYPE2 and so on). |
| PAYMENTTYPE |
varchar(20) |
varchar(20) |
The Payment Type associated with the Service like Availability, Usage, Enablement, Energy Revenue, Test, ADHOC and so on. |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| PAYMENTAMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The NMAS Contract Manual Payment for the Payment Type. |
| RECOVERYSTARTDATETIME |
datetime(3) |
datetime2(0) |
The Recovery Start Date and Time for the Payment Calculation. |
| RECOVERYENDDATETIME |
datetime(3) |
datetime2(0) |
The Recovery End Date and Time for the Payment Calculation. |
| RECOVERYAMOUNT_ACE |
numeric(18, 8) |
numeric(18, 8) |
Recovery Amount on ACE portion ($). |
| RECOVERYAMOUNT_ASOE |
numeric(18, 8) |
numeric(18, 8) |
Recovery Amount on ASOE portion ($). |
| PARTICIPANT_ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
Participant Consumed Energy in MWh. |
| PARTICIPANT_ASOE_MWH |
numeric(18, 8) |
numeric(18, 8) |
Participant Sent Out Energy in MWh. |
| REGION_ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
Region Consumed Energy in MWh. |
| REGION_ASOE_MWH |
numeric(18, 8) |
numeric(18, 8) |
Region Sent Out Energy in MWh. |
| 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_NMAS_MANUAL_RECOVER_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONTRACTID, SERVICETYPE, PAYMENTTYPE, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_NMAS_MANUAL_RECOVERY |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONTRACTID, SERVICETYPE, PAYMENTTYPE, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_NMAS_MANUAL_RECOVERY |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONTRACTID, SERVICETYPE, PAYMENTTYPE, REGIONID |