C1 report tables

The C1 report tables contain lists of codes and rules. C1 report tables lists the tables in a C1 report where additional report security is applied, ensuring you are entitled to see the record (for example, different participants see different records).

C1 report tables with security lists the tables in a C1 report where no additional report security is applied. For example, all participants running this report with the same parameters receive the same records.

Table 49 C1 report tables with security

Table name	Viewing entitlements
CATS_INBOUND_CHANGE_REQUEST	If you meet one or more of the following conditions: You initiated the Change Request You are a nominated Role on the Change Request You had a relationship with the NMI for the trading dates nominated on the Change Request, from the date this Change Request record was created MSATS creates multiple records in this table for each Change Request Each Change Request has an initial status of PVAL and a ReadyForValidation flag of either F (if it is submitted by batch and O if it submitted via the MSATS Web Portal) When the Transaction is ready for validation, a new record is created with the same status (PVAL) but with the ReadyForValidation flag set to T. Every time there is a subsequent change of status, another new record is created. (In a typical Change Request lifecycle, this means there are two PVAL records and then a record for each of the REQ, PEND, and COM statuses.
CATS_INBOUND_METER_REGISTER CATS_INBOUND_REGISTER_IDENTIFIER	If you meet one or more of the following conditions: You initiated the Change Request this record relates to You are a nominated Role on the Change Request this record relates to You had a relationship with the NMI for the dates nominated on the Change Request that were active between the create date (MaintCreatedt) of the first record and the create date (MaintCreatedt) of the most recent record on the CATS_INBOUND_ CHANGE_REQUEST table for this Change Request (If, for example, your relationship started midway through the lifecycle of the Change Request, you are entitled to see this record) The standing data access rules permit you (based on the active roles you have during the lifecycle of the Change Request) to see it. Depending on the Roles you are acting in, you may only have access to some of the data from a record. Note that on this table, the MAINTCREATEDT of the record is the date that the first record for this Change Request was created (the one where the Change Request begins in PVAL status).
CATS_INBOUND_NMI_DATA	Same as CATS_INBOUND_METER_REGISTER
CATS_INBOUND_STREAMS	Same as CATS_INBOUND_METER_REGISTER
CATS_INBOUND_ROLES	The basic security is the same as CATS_INBOUND_ METER_REGISTER however, when the CATS Standing Data Access Rules are applied to this table, if you don’t have access to data about a Role, the whole record is excluded, not just individual fields
CATS_INBOUND_OBJECTIONS	If you are the initiator of an Objection Other parties associated with a Change Request seeking information about Objections via a C1 Report can obtain it from the CATS_OUTBOUND_NOTIFICATIONS table
CATS_METER_REGISTER CATS_NMI_DATA CATS_NMI_DATA_STREAM CATS_REGISTER_IDENTIFIER	If you have a relationship with the NMI overlapping the Start and End Dates on the active record You are only entitled to see records relevant to the Role you were acting in at the time the record was active
CATS_NMI_PARTICIPANT_RELATIONS	The basic security is the same as CATS_METER_ REGISTER however, when the CATS Standing Data Access Rules are applied, if you don’t have access to data about a Role, the whole record is excluded, not just individual fields
CATS_OUTBOUND_CHANGE_REQUESTS	If you are the Initiator of the Change Request the record relates to See section 9 for more information on how to use this table
CATS_OUTBOUND_ERRORS	If you were the initiator of the Change Request or Objection the record relates to
CATS_OUTBOUND_NOTIFICATIONS	If you are the recipient of the notification
CATS_OUTBOUND_OBJECTIONS	If you are the initiator of the Objection the record relates to
CATS_OUTBOUND_REQUESTS	If you are the recipient of a Data Request
CATS_NMI_DATA (CND)	AEMO uses CND_[nn] framework to map field names in the CATS_NMI_DATA table to the C1 CATS Transaction Field Validations report. Where possible, participants should use the procedural field names defined in Standing Data for MSATS. AEMO does not support participants using the Oracle database table and field names.

Table 50 C1 report tables without security

Table name	Table name
CATS Customer Administration and Transfer Solution. A set of procedures, principles and obligations made under the National Electricity Rules as part of Market Settlement and Transfer Solutions (MSATS), and applicable to NMI (National Metering Identifier) small and large classifications._CHANGE_REASON_CODES	CATS_NMI See Relevant Rules or Procedures_STATUS_CODES
CATS_CR Change Request_INITIATION_RULES	CATS_NOTIFICATION_RULES
CATS_CR_STATUS_CODES	CATS_OBJECTION_CODES
CATS_DATA_SOURCE_CODES	CATS_OBJECTION_RULES
CATS_DEREG_CODES	CATS_PARTICIPANT_ROLES
CATS_DISCOVERY_ACCESS_RULES	CATS_PARTICIPANTS
CATS_DISCOVERY_SEARCH_RULES	CATS_READ_TYPE_CODES
CATS_DLF Distribution Loss Factor. The loss of energy, due to electrical resistance and the heating of conductors, as electricity flows through the transmission and distribution networks._CODES	CATS_RETROSPECTIVITY_CODES
CATS_EMB_NET_ID_CODES	CATS_ROLES
CATS_ERROR_CODES	CATS_TNI_CODES
CATS_JURISDICTION_CODES	CATS_TRANS_FIELD_VALIDATION
CATS_JURISDICTIONAL_RULES	CATS_TRANS_TYPE_CODES
CATS_METER_INSTALL_TYPE_CODES	MSATS Market Settlement and Transfer Solutions. The procedures published by AEMO under clause 7.2.8 of the National Electricity Rules, which include those governing the recording of financial responsibility for energy flows at a connection point, the transfer of that responsibility between market participants, and the recording of energy flows at a connection point._NATIONAL_CALENDAR
CATS_NMI_CLASS_CODES	CATS_NETWORKTARIFF_CODES
CATS_NMI_RANGES	NSLP Net System Load Profile. A profile applied to convert all second-tier basic meter readings into energy consumption for each 30-minute trading interval for settlement purposes._FLOOR_VALUE
MSATS_CODES	MSATS_CODE_COMBOS
MSATS_CODES_DATED	MSATS_CODE_GROUPS
NODE_HIERARCHY