BILLING_APC_COMPENSATION
Billing result table for APC compensation payments.
Package
BILLING_RUN
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
Billing contract year |
| WEEKNO |
numeric(3, 0) |
smallint |
Billing week number |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Billing run number |
| APEVENTID |
numeric(6, 0) |
int |
AP Event Id |
| CLAIMID |
numeric(6, 0) |
int |
AP Event Claim Id |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
Participant identifier |
| COMPENSATION_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Payment amount to the participant |
| EVENT_TYPE |
varchar(20) |
varchar(20) |
The Administered Price Event Type. Valid values: ENERGY, FCAS, BOTH |
| COMPENSATION_TYPE |
varchar(20) |
varchar(20) |
The Type of Administered Price Compensation Claim. Valid values: DIRECT_COST, OTHER_COST |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The date and time of last changed record |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_APC_COMPENSATION_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, APEVENTID, CLAIMID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_APC_COMPENSATION |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, APEVENTID, CLAIMID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_APC_COMPENSATION_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, APEVENTID, CLAIMID |