Page Ref: P-10

Bid Constraint Messages
User Messages
Generator Bids
Transaction Bids
Load Bids
Unit Commitment
User Update, Misc.
Administrator Messages
Market Participant Admin
ISO Admin

User Messages
Generator Bid Messagesback to top
Message IdConstraint NameConstraint Message
10000DAM_BID_BLOCK_PLUS_CURVE_CKDAM Energy Curve segments must be <= 6 and Energy Block segments must be <= 3.
10001DAM_BID_CMMT_DATA_CKDAM generator bids must have unit commitment data assigned prior to evaluation.
10002DAM_BID_CURVE_GREATER_MIN_CKThe highest dispatch MW must be > the fixed minimum block MW.
10003DAM_BID_DISPATCH1_NULL_CKDAM Energy MWs and Energy $/MW at point 1 must BOTH be either null or non null.
10004DAM_BID_DISPATCH2_NULL_CKDAM Energy MWs and Energy $/MW at point 2 must BOTH be either null or non null.
10005DAM_BID_DISPATCH3_NULL_CKDAM Energy MWs and Energy $/MW at point 3 must BOTH be either null or non null.
10006DAM_BID_DISPATCH4_NULL_CKDAM Energy MWs and Energy $/MW at point 4 must BOTH be either null or non null.
10007DAM_BID_DISPATCH5_NULL_CKDAM Energy MWs and Energy $/MW at point 5 must BOTH be either null or non null.
10008DAM_BID_DISPATCH6_NULL_CKDAM Energy MWs and Energy $/MW at point 6 must BOTH be either null or non null.
10009DAM_BID_DISP_DOLLAR_ASCEND_CKDAM Energy $/MW must be entered in the curve in ascending order.
10010DAM_BID_DISP_DOLLAR_NO_SKIP_CKDAM Energy $/MW must be entered in the curve with no points skipped.
10011DAM_BID_DISP_MW_ASCEND_CKDAM Energy MWs must be entered in the curve in ascending order.
10012DAM_BID_DISP_MW_NO_SKIP_CKDAM Energy MWs must be entered in the curve with no points skipped.
10013DAM_BID_EXP_DT_CKDAM Bid expiration date-time must be < DAM bid date-time.
10014DAM_BID_FIXED_MIN_VAL_CKDAM Minimum Generation(MW) must be <= upper operating limit.
10015DAM_BID_MIN10_NONSYNC_NULL_CKDAM 10 Minute Non-Synchronized MWs and $/MW must BOTH be either null or non null.
10016DAM_BID_MIN10_NONSYNC_VAL_CKDAM 10 Minute Non-Synchronized reserve MWs must be >= 0 and <= Upper Operating Limit(MW).
10017DAM_BID_MIN10_SPIN_NULL_CKDAM 10 Minute Spinning MWs and $/MW must both be either null or non null.
10018DAM_BID_MIN10_SPIN_VAL_CKDAM 10 Minute Spinning reserve MWs must be >= 0 and <= ( Upper Operating Limit - Minimum Generation(MW) ).
10019DAM_BID_MIN30_NONSYNCH_NULL_CKDAM 30 Minute Non-Synchronized reserve MWs and $/MW must BOTH be either null or non null.
10020DAM_BID_MIN30_NONSYNCH_VAL_CKDAM 30 Minute Non-Synchronized reserve MWs must be >= 0 and <= Upper Operating Limit.
10021DAM_BID_MIN30_SPIN_NULL_CKDAM 30 Minute Spinning reserve MWs and $/MW must both be either null or non null.
10022DAM_BID_MIN30_SPIN_VAL_CKDAM 30 Minute Spinning reserve MWs must be >= 0 and <= Upper Operating Limit minus Fixed minimum block MW.
10023DAM_BID_NONFIRM_FLAG_CKDAM_BID_NONFIRM_FLAG_CK: If Supporting Room for Non-Firms Only then Reserve Room for Non -Firms must be NULL or If not Supporting Room for Non-Firms Only then Reserve Room for Non-Firms must not be NULL.
10024DAM_BID_REG_AVAIL_NULL_CKDAM Regulation MWs and $/MW must be either null or non null.
10025DAM_BID_REG_AVAIL_VAL_CKDAM Regulation MWs must be >= 0 and <= ( Upper Operating Limit - Minimum Generation )/2 and Upper Operating Limit must be >= Minimum Generation.
10026DAM_BID_SCHED_10MIN_30MIN_CKConstraint: DAM_BID_SCHED_10MIN_30MIN_CK on table DAM_GENERATOR_BIDS violated.
10027DAM_BID_SCHED_AVAIL_FLAG_CKConstraint: DAM_BID_SCHED_AVAIL_FLAG_CK on table DAM_GENERATOR_BIDS violated.
10028DAM_BID_SCHED_MW_GT_ZERO_CKConstraint: DAM_BID_SCHED_MW_GT_ZERO_CK on table DAM_GENERATOR_BIDS violated. All values must be >= 0.
10029DAM_BID_SCHED_NOT_NULL_CKConstraint: DAM_BID_SCHED_NOT_NULL_CK on table DAM_GENERATOR_BIDS violated.
10030DAM_BID_SCHED_ON_LINE_FLAG_CKConstraint: DAM_BID_SCHED_ON_LINE_FLAG_CK on table DAM_GENERATOR_BIDS violated.
10031DAM_BID_SCH_ENERGY_NONSYNC_CKConstraint: DAM_BID_SCH_ENERGY_NONSYNC_CK on table DAM_GENERATOR_BIDS violated.
10032DAM_BID_SEGMENTS_CKWhen DAM Energy segments is not null the Energy MWs at the first point must be <= Minimum Generation(MW).
10033DAM_BID_UP_OPER_LIM_CKDAM Upper Operating Limit(MW) must be >= 2.
10034DAM_SCH_ENGY_LESS_CURVE_MW_CKConstraint: DAM_SCH_ENGY_LESS_CURVE_MW_CK on table DAM_GENERATOR_BIDS violated.
10035DAM_SCH_ON_DISP_REG_AVAIL_CKGenerator must be on dispatch to bid regulation.
10036DGB_BS_FKBid status for DAM bid is not in the database.
10037DGB_GEN_FKGenerator for DAM bid is not in the database.
10038DGB_LAST_INS_USER_ID_FKUpdate user for DAM bid is not in the database.
10039DGB_PKDam Generator bid BBS_ID must be unique. (Internal Error - DGB_PK) Contact Market Services.
10040DGB_SCHED_SRC_FKDAM bid schedule source is not in the database.
10041DGB_UCG_FKGenerator's unit commitment data for DAM bid is not in the database.
10042DGB_USER_BILLING_FKBilling user for DAM bid is not in the database.
10043DGB_MES_DGB_FKDAM bid for message is not in the database.
10044DGB_MES_MES_FKMessage for DAM bid is not in the database.
10045DGB_MES_PKThis Message already assigned to this Bid.
10046HAM_BID_BLOCK_PLUS_CURVE_CKHAM Energy Curve segments must be <= 6 and Energy Block segments must be <= 3.
10047HAM_BID_CMMT_DATA_CKHAM generator bids must have unit commitment data assigned prior to evaluation.
10048HAM_BID_CURVE_GREATER_MIN_CKThe highest dispatch MW must be > the fixed minimum block MW.
10049HAM_BID_DISPATCH1_NULL_CKHAM Energy MWs and Energy $/MW at point 1 must BOTH be either null or non null.
10050HAM_BID_DISPATCH2_NULL_CKHAM Energy MWs and Energy $/MW at point 2 must BOTH be either null or non null.
10051HAM_BID_DISPATCH3_NULL_CKHAM Energy MWs and Energy $/MW at point 3 must BOTH be either null or non null.
10052HAM_BID_DISPATCH4_NULL_CKHAM Energy MWs and Energy $/MW at point 4 must BOTH be either null or non null.
10053HAM_BID_DISPATCH5_NULL_CKHAM Energy MWs and Energy $/MW at point 5 must BOTH be either null or non null.
10054HAM_BID_DISPATCH6_NULL_CKHAM Energy MWs and Energy $/MW at point 6 must BOTH be either null or non null.
10055HAM_BID_DISP_DOLLAR_ASCEND_CKHAM Energy $/MW must be entered in the curve in ascending order.
10056HAM_BID_DISP_DOLLAR_NO_SKIP_CKHAM Energy $/MW must be entered in the curve with no points skipped.
10057HAM_BID_DISP_MW_ASCEND_CKHAM Energy MWs must be entered in the curve in ascending order.
10058HAM_BID_DISP_MW_NO_SKIP_CKHAM Energy MWs must be entered in the curve with no points skipped.
10059HAM_BID_FIXED_MIN_VAL_CKHAM Minimum Generation(MW) must be <= Upper Operating Limit(MW).
10060HAM_BID_MIN10_NONSYNC_NULL_CKHAM 10 Minute Non-Synchronized MWs and $/MW must BOTH be either null or non null.
10061HAM_BID_MIN10_NONSYNC_VAL_CKHAM 10 Minute Non-Synchronized reserve MWs must be >= 0 and <= Upper Operating Limit(MW).
10062HAM_BID_MIN10_SPIN_NULL_CKHAM 10 Minute Spinning MWs and $/MW must both be either null or non null.
10063HAM_BID_MIN10_SPIN_VAL_CKHAM 10 Minute Spinning reserve MWs must be >= 0 and <= ( Upper Operating Limit - Minimum Generation(MW) ).
10064HAM_BID_MIN30_NONSYNCH_NULL_CKHAM 30 Minute Non-Synchronized reserve MWs and $/MW must BOTH be either null or non null.
10065HAM_BID_MIN30_NONSYNCH_VAL_CKHAM 30 Minute Non-Synchronized reserve MWs must be >= 0 and <= Upper Operating Limit.
10066HAM_BID_MIN30_SPIN_NULL_CKHAM 30 Minute Spinning reserve MWs and $/MW must both be either null or non null.
10067HAM_BID_MIN30_SPIN_VAL_CKHAM 30 Minute Spinning reserve MWs must be >= 0 and <= Upper Operating Limitminus Fixed minimum block MW.
10068HAM_BID_NONFIRM_FLAG_CKHAM_BID_NONFIRM_FLAG_CK: If Supporting Room for Non-Firms Only then Reserve Room for Non -Firms must be NULL or If not Supporting Room for Non-Firms Only then Reserve Room for Non-Firms must not be NULL.
10069HAM_BID_REG_AVAIL_NULL_CKHAM Regulation MWs and $/MW must be either null or non null.
10070HAM_BID_REG_AVAIL_VAL_CKHAM Regulation MWs must be >= 0 and <= ( Upper Operating Limit - Minimum Generation )/2.
10071HAM_BID_SCHED_10MIN_30MIN_CKConstraint: HAM_BID_SCHED_10MIN_30MIN_CK on table HAM_GENERATOR_BIDS violated.
10072HAM_BID_SCHED_AVAIL_FLAG_CKConstraint: HAM_BID_SCHED_AVAIL_FLAG_CK on table HAM_GENERATOR_BIDS violated.
10073HAM_BID_SCHED_MW_CKHAM_BID_SCHED_MW_CK constraint violated.
10074HAM_BID_SCHED_MW_GT_ZERO_CKConstraint: HAM_BID_SCHED_MW_GT_ZERO_CK on table HAM_GENERATOR_BIDS violated. All values must be >= 0.
10075HAM_BID_SCHED_NOT_NULL_CKConstraint: HAM_BID_SCHED_NOT_NULL_CK on table HAM_GENERATOR_BIDS violated.
10076HAM_BID_SCHED_ON_LINE_FLAG_CKConstraint: HAM_BID_SCHED_ON_LINE_FLAG_CK on table HAM_GENERATOR_BIDS violated.
10077HAM_BID_SCH_ENERGY_NONSYNC_CKConstraint: HAM_BID_SCH_ENERGY_NONSYNC_CK on table HAM_GENERATOR_BIDS violated.
10078HAM_BID_SEGMENTS_CKWhen HAM Energy segments is not null the Energy MWs at the first point must be <= Minimum Generation(MW).
10079HAM_BID_SPIN_RESRV_NULL_CKHAM 30 Minute Spinning reserve MWs and $/MW must both be either null or non null.
10080HAM_BID_SPIN_RESRV_VAL_CKHAM 30 Minute Spinning reserve MWs must be >= 0 and <= Upper Operating Limit.
10081HAM_BID_UP_OPER_LIM_CKHAM Upper Operating Limit(MW) must be >= 2.
10082HAM_SCH_ENGY_LESS_CURVE_MW_CKConstraint: HAM_SCH_ENGY_LESS_CURVE_MW_CK on table HAM_GENERATOR_BIDS violated.
10083HAM_SCH_ON_DISP_REG_AVAIL_CKConstraint: HAM_SCH_ON_DISP_REG_AVAIL_CK on table HAM_GENERATOR_BIDS violated.
10084HGB_BS_FKBid status for HAM bid is not in the database.
10085HGB_GEN_FKGenerator for HAM bid is not in the database.
10086HGB_LAST_INS_USER_ID_FKUpdate user for HAM bid is not in the database.
10087HGB_PKHam Generator bid BBS_ID must be unique. (Internal Error - HGB_PK) Contact Market Services.
10088HGB_UCG_FKGenerator's unit commitment data for HAM bid is not in the database.
10089HGB_USER_BILLING_FKBilling user for HAM bid is not in the database.
10090HGB_MES_HGB_FKHAM bid for message is not in the database.
10091HGB_MES_MES_FKMessage for HAM bid is not in the database.
10092HGB_MES_PKThis Message already assigned to this Bid.
10093DAM_BID_SCHED_MW_CKConstraint: DAM_BID_SCHED_MW_CK on table DAM_GENERATOR_BIDS violated.
10094DAM_BID_FIXED_RES_UP_LIM_CKFixed units (no energy curve supplied) must have Minimum Generation MWs + 10 Minute Spinning reserve MWs + 30 Minute Spinning reserve MWs <= Upper Operating Limit.
10095HAM_BID_FIXED_RES_UP_LIM_CKFixed units (no energy curve supplied) must have Minimum Generation MWs + 10 Minute Spinning reserve MWs + 30 Minute Spinning reserve MWs <= Upper Operating Limit.
10096DAM_BID_FIXED_MIN_INTEGER_CKThe DAM Minimum Generation(MW) must be a whole number.
10097HAM_BID_FIXED_MIN_INTEGER_CKThe HAM Minimum Generation(MW) must be a whole number.
10098DAM_BID_UP_OPER_LIM_INTEGER_CKThe DAM Upper Operating Limit(MW) must be a whole number.
10099HAM_BID_UP_OPER_LIM_INTEGER_CKThe HAM Upper Operating Limit(MW) must be a whole number.
10100DAM_BID_MIN10_SPIN_INTEGER_CKThe DAM 10 Minute Spinning MWs must be a whole number.
10101HAM_BID_MIN10_SPIN_INTEGER_CKThe HAM 10 Minute Spinning MWs must be a whole number.
10102DAM_BID_MIN10_NONS_INTEGER_CKThe DAM 10 Minute Non-Synchronized reserve MW must be a whole number.
10103HAM_BID_MIN10_NONS_INTEGER_CKThe HAM 10 Minute Non-Synchronized reserve MW must be a whole number.
10104DAM_BID_MIN30_SPIN_INTEGER_CKThe DAM 30 Minute Spinning MWs must be a whole number.
10105HAM_BID_MIN30_SPIN_INTEGER_CKThe HAM 30 Minute Spinning MWs must be a whole number.
10106DAM_BID_MIN30_NONS_INTEGER_CKThe DAM 10 Minute Non-Synchronized reserve MW must be a whole number.
10107HAM_BID_MIN30_NONS_INTEGER_CKThe HAM 10 Minute Non-Synchronized reserve MW must be a whole number.
10108DAM_BID_REG_AVAIL_INTEGER_CKThe DAM Regulation MW must be a whole number.
10109HAM_BID_REG_AVAIL_INTEGER_CKThe HAM Regulation MW must be a whole number.
10110DAM_BID_FIXED_NO_CURVE_CKA Bid Curve can not be submitted when the Minimum Generation (MW) is equal to the Upper Operating Limit (MW).
10111HAM_BID_FIXED_NO_CURVE_CKA Bid Curve can not be submitted when the Minimum Generation (MW) is equal to the Upper Operating Limit (MW).
10112DAM_BID_SCHED_ENERGY_GT_FIXEDThe scheduled energy MWs must be greater than or equal to the fixed minimum bid MWs.
10113DAM_BID_SCHED_REG_LT_BIDThe scheduled regulation availability MWs must be less than or equal to the regulation availability bid MWs.
10114DAM_BID_SCHED_MIN10SP_LT_BIDThe scheduled 10 minute spinning reserve MWs must be less than or equal to the 10 minute spinning reserve bid MWs.
10115DAM_BID_SCHED_MIN10NON_LT_BIDThe scheduled 10 minute nonsynch reserve MWs must be less than or equal to the 10 minute nonsynch reserve bid MWs.
10116DAM_BID_SCHED_MIN30SP_LT_BIDThe scheduled 30 minute spinning reserve MWs must be less than or equal to the 30 minute spinning reserve bid MWs.
10117DAM_BID_SCHED_MIN30NON_LT_BIDThe scheduled 30 minute nonsynch reserve MWs must be less than or equal to the 30 minute nonsynch reserve bid MWs.
10118DAM_BID_SCHED_SUM_LT_OPLIMThe sum of the scheduled energy and reserves must be less than or equal to the upper operating limit bid.
10119HAM_BID_SCHED_ENERGY_GT_FIXEDThe scheduled energy MWs must be greater than or equal to the fixed minimum bid MWs.
10120HAM_BID_SCHED_REG_LT_BIDThe scheduled regulation availability MWs must be less than or equal to the regulation availability bid MWs.
10121HAM_BID_SCHED_MIN10SP_LT_BIDThe scheduled 10 minute spinning reserve MWs must be less than or equal to the 10 minute spinning reserve bid MWs.
10122HAM_BID_SCHED_MIN10NON_LT_BIDThe scheduled 10 minute nonsynch reserve MWs must be less than or equal to the 10 minute nonsynch reserve bid MWs.
10123HAM_BID_SCHED_MIN30SP_LT_BIDThe scheduled 30 minute spinning reserve MWs must be less than or equal to the 30 minute spinning reserve bid MWs.
10124HAM_BID_SCHED_MIN30NON_LT_BIDThe scheduled 30 minute nonsynch reserve MWs must be less than or equal to the 30 minute nonsynch reserve bid MWs.
10125HAM_BID_SCHED_SUM_LT_OPLIMThe sum of the 10 min sync, 30 min sync and reserves must be less than or equal to the last point on the DISPATCH_MW bid curve or its upper operating limit.
10126DAM_BID_MIN10_SPIN_CURVE_CKA price curve must be entered when bidding 10 Minute Spinning Reserves.
10127DAM_BID_MIN30_SPIN_CURVE_CKA price curve must be entered when bidding 30 Minute Spinning Reserves.
10128HAM_BID_MIN10_SPIN_CURVE_CKA price curve must be entered when bidding 10 Minute Spinning Reserves.
10129HAM_BID_MIN30_SPIN_CURVE_CKA price curve must be entered when bidding 30 Minute Spinning Reserves.
10130DAM_BID_NEG_FIXED_NO_CURVE_CKIf fixed minimum MWs is negative then no curve is allowed and no bidding of reserves unless min 10 spin is bid then a single point block bid with the 1st point >= 0 is required and on_dispatch must = N.
10131HAM_BID_NEG_FIXED_NO_CURVE_CKIf fixed minimum MWs is negative then no curve is allowed and no bidding of reserves unless min 10 spin is bid then a single point block bid with the 1st point >= 0 is required and on_dispatch must = N.
10132DAM_BID_MIN10_NONSYNC_CURVE_CKWhen bidding 10 Minute Non-Synch Reserves then a dispatch curve must be supplied. If supplied as a curve then the 1st point MW value must <= 0. If supplied as a block then no restriction.
10133HAM_BID_MIN10_NONSYNC_CURVE_CKWhen bidding 10 Minute Non-Synch Reserves then a dispatch curve must be supplied. If supplied as a curve then the 1st point MW value must <= 0. If supplied as a block then no restriction.
10134HAM_BID_MIN10_SPIN_PR_CAP_CK10 minute spinning reserves dollars per MW must be less than $1000.00.
10135HAM_BID_MIN30_NONS_PR_CAP_CK30 minute non-synchronized reserves dollars per MW must be less than $1000.00.
10136HAM_BID_MIN30_SPIN_PR_CAP_CK30 minute spinning reserves dollars per MW must be less than $1000.00.
10137HAM_BID_MIN10_NONS_PR_CAP_CK10 minute non-synchronized reserves dollars per MW must be less than $1000.00.
10138HAM_BID_REG_AVAIL_PR_CAP_CKRegulation reserves dollars per MW must be less than $1000.00.
10139DAM_BID_MIN10_NONS_PRCAP_CK10 minute non-synchronized reserves dollars per MW must be less than $1000.00.
10140DAM_BID_MIN10_SPIN_PR_CAP_CK10 minute spinning reserves dollars per MW must be less than $1000.00.
10141DAM_BID_MIN30_SPIN_PR_CAP_CK30 minute spinning reserves dollars per MW must be less than $1000.00.
10142DAM_BID_MIN30_NONS_PRCAP_CK30 minute non-synchronized reserves dollars per MW must be less than $1000.00.
10143DAM_BID_REG_AVAIL_PR_CAP_CKRegulation reserves dollars per MW must be less than $1000.00.
10200GEN_BIDS_HAM_RESERVES_NODOL_CKHAM can only bid null or zero reserve dollars.
10202GEN_BIDS_CMMT_DATA_CKGenerator bids must have unit commitment data assigned prior to evaluation.
10203GEN_BIDS_EUOL_VALUE_CKUOL(n) must be <= UOL(e).
10204GEN_BIDS_EXP_DT_CKDAM Bid expiration date-time must be < DAM bid date-time.
10205GEN_BIDS_FIXED_MIN_DOLLAR_CKMinimum Generation $ must = 0 when Minimum Generation MW = 0 and Minimum Generation $ must >= 0 when Minimum Generation MW > 0.
10207GEN_BIDS_FIXED_MIN_VAL_CKMinimum Generation MW must be <= UOL(n).
10210GEN_BIDS_OOM_UP_OP_LIM_NULL_CKHAM bid UOL must not be null or Ham bid status is OOM.
10212GEN_BIDS_REG_AVAIL_NULL_CKRegulation MW and Dollar must be both null or non null.
10214GEN_BIDS_STATUS_CKIncorrect bid status.
10216GEN_BID_BID_SCHD_TYPE_FKThis Bid Schedule Type does not exist.
10217GEN_BID_BID_STATUS_FKThis Bid Status Type does not exist.
10218GEN_BID_BILLING_USER_ID_FKNot a vaild billing user.
10219GEN_BID_GEN_ID_FKThis Generator does not exist.
10220GEN_BID_SOURCE_ID_FKThis Market Source does not exist.
10221GEN_BID_UNIT_COM_GEN_FKUnit Commitment of this Generator does not exist.
10222GEN_BID_USER_ID_FKNot a valid user.
10223GEN_DATEHR_STAT_SCH_SRC_UKThe same bid already exists.
10224GEN_BID_MES_PKThe same message for this bid already exist.
10225GEN_BID_MES_GENERATOR_FKGenerator bid does not exist.
10226GEN_BID_MES_MES_FKThis message does not exist.

Transaction Bid Messagesback to top
Message IdConstraint NameConstraint Message
20000MES_TB_MES_FKMessage for transaction bid is not in the database.
20001MES_TB_PKThis Message already assigned to this Bid.
20002MES_TB_TB_FKTransaction bid for message is not in the database.
20003TB_BS_FKBid status for transaction bid is not in the database.
20004TB_LAST_INS_USER_ID_FKUpdate user for transaction bid is not in the database.
20005TB_MARKET_SEGMENT_SOURCES_FKMarket segment source for transaction bid is not in the database.
20006TB_PKTransaction bid BBS_ID must be unique. (Internal Error - TB_PK) Contact Market Services.
20007TB_TC_FKTransaction contract for transaction bid is not in the database.
20008TB_UK1The combination of the transaction id, market and date hour must be unique for the Transaction Bid.
20009TB_USER_REF_ID_FKUser reference for transaction bid is not in the database.
20010TRANS_BID_MW_CKConstraint: TRANS_BID_MW_CK on table TRANSACTION_BIDS violated.
20011TRANS_BID_SCHED_MW_CKTRANS_BID_SCHED_MW_CK scheduled MWs cannot be NULL if status is Accepted or AdvisoryAccepted and scheduled MWs must be NULL if status is Rejected.
20012TB_NERC_TAG_NULL_CKTB_NERC_TAG_NULL_CK: The NERC Sending Control Area, NERC PSE Entity, PSE Number and NERC Receiving Control Area must all be NULL or Non-NULL
20013TB_NERC_TAG_PSE_NUMBER_FORMATTB_NERC_TAG_PSE_NUMBER_FORMAT: PSE Number must be in the fomat of three numeric characters followed by one alpha character.
20014TB_NERC_TRANS_PRIORITY_CKTB_NERC_TRANS_PRIORITY_CK: If the NERC Priority = 7 then the Transaction Priority must be Non NULL.
20015TC_BUS_HAS_SINK_FKSink bus for transaction contract is not in the database.
20016TC_GEN_HAS_SOURCE_FKSource generator for transaction contract is not in the database.
20017TC_LAST_INS_USER_ID_FKUpdate user for transaction contract is not in the database.
20018TC_NP_FKNerc priority for transaction contract is not in the database.
20019TC_PKTransaction Contract Transaction ID must be unique. (Internal error - TC_PK) Contact Market Services
20020TC_UK1The combination of sink bus, source generator, user reference, nerc priority, nerc sending control area, nerc pse entity, pse number and nerc receiving control area must be unique for the Transaction Contract.
20021TRANS_BID_TRANS_PRIORITY_CKTRANS_BID_TRANS_PRIORITY_CK: Transaction Priority cannot be <= 0.
20022TRANS_BID_CONF_CKTRANS_BID_CONF_CK: The buyer and seller confirmation flags and bids status values are not compatible. Internal processing error. Notify market relations.
20023TB_ENERGY_FIXED_BLK_MW_INT_CKThe Energy MW must be a whole number.
20024TRANS_BID_MW_NOT_ZERO_CKIn the DAM and NON FIRM markets, energy bid MWs can not be zero.
20025TRANS_BID_MW_POS_CKEnergy bid MWs must be positive values.

Load Bid Messagesback to top
Message IdConstraint NameConstraint Message
30000ENERGY_BID_MW_POS_CKFixed Energy Bid MWs must be >= 0.
30001ENERGY_FORECAST_BID_MW_POS_CKForecast Energy Bid MWs must be >= 0.
30002ENERGY_PRICE_CAP_DOL1_POS_CKEnergy Price Cap Bid $/MW at point 1 must be >= 0.
30003ENERGY_PRICE_CAP_DOL2_POS_CKEnergy Price Cap Bid $/MW at point 2 must be >= 0.
30004ENERGY_PRICE_CAP_DOL3_POS_CKEnergy Price Cap Bid $/MW at point 3 must be >= 0.
30005ENERGY_PRICE_CAP_MW1_POS_CKEnergy Price Cap Bid MWs at point 1 must be > 0.
30006ENERGY_PRICE_CAP_MW2_POS_CKEnergy Price Cap Bid MWs at point 2 must be > 0.
30007ENERGY_PRICE_CAP_MW3_POS_CKEnergy Price Cap Bid MWs at point 3 must be > 0.
30008INTRPT_CAP_DOLLAR_POS_CKInterruptible Price Cap $/MW must be >= 0.
30009INTRPT_CAP_LT_PR_CAP_MW_CKInterruptible Price Cap MWs must be <= the sum of the positive Price Cap MWs at points 1, 2, and 3.
30010INTRPT_CAP_MW_POS_CKInterruptible Price Cap MWs must be > 0.
30011INTRPT_FIXED_DOLLAR_POS_CKInterruptible Fixed $/MW must be >= 0.
30012INTRPT_FIXED_MW_POS_CKInterruptible Fixed MWs must be > 0.
30013LB_BS_FKBid status for load bid is not in the database.
30014LB_BUS_FKBus for load bid is not in the database.
30015LB_ENERGY_MW_NULL_CKAtleast One Load Bid Type must be Submitted. Energy Bid MWs is non null or Energy Forecast Bid MWs is non null or Energy Price Cap Bid MWs at point 1 is non null.
30016LB_ENERGY_PRICE_CAP1_NULL_CKEnergy Price Cap MWs and $/MW at point 1 must be either null or non null.
30017LB_ENERGY_PRICE_CAP2_NULL_CKEnergy Price Cap MWs and $/MW at point 2 must be either null or non null.
30018LB_ENERGY_PRICE_CAP3_NULL_CKEnergy Price Cap MWs and $/MW at point 3 must be either null or non null.
30019LB_ENERGY_PR_CAP_DOL_ASCEND_CKEnergy Price Cap $/MW must be entered in the curve in ascending order.
30020LB_ENERGY_PR_CAP_DOL_NOSKIP_CKEnergy Price Cap $/MW must be entered in the curve with no points skipped.
30021LB_ENERGY_PR_CAP_MW_NO_SKIP_CKEnergy Price Cap MWs must be entered in the curve with no points skipped.
30022LB_INTRPT_CAP_EN_PCAP_NULL_CKInterruptible Price Cap MWs cannot be entered without a corresponding Price Cap Bid.
30023LB_INTRPT_CAP_NULL_CKInterruptible Price Cap MWs and $/MW must be either null or non null.
30024LB_INTRPT_FIXED_ENERGY_NULL_CKInterruptible Fixed MWs cannot be entered without a corresponding Fixed Energy Bid.
30025LB_INTRPT_FIXED_NULL_CKInterruptible Fixed MWs and $/MW must be either null or non null.
30026LB_INTRPT_TYPE_NULL_CKInterruptible Type must be specified when Interruptible Fixed Bid or Interruptible Price Cap Bid is submitted.
30027LB_LAST_INS_USER_ID_FKUpdate user for load bid is not in the database.
30028LB_LSE_FKLoad serving entity for load bid is not in the database.
30029LB_PKLoad bid BBS_ID must be unique. (Internal Error - LB_PK) Contact Market Services.
30030LB_USER_BILLING_FKBilling user for load bid is not in the database.
30031SCH_ENERGY_PR_CAP_MW_POS_CKConstraint: SCH_ENERGY_PR_CAP_MW_POS_CK on table LOAD_BIDS violated.
30032SCH_ENGY_PR_CAP_INT_PR_CAP_CKConstraint: SCH_ENGY_PR_CAP_INT_PR_CAP_CK on table LOAD_BIDS violated.
30033SCH_INTRPT_CAP_MW_POS_CKConstraint: SCH_INTRPT_CAP_MW_POS_CK on table LOAD_BIDS violated.
30034SCH_INTRPT_FIXED_MW_POS_CKConstraint: SCH_INTRPT_FIXED_MW_POS_CK on table LOAD_BIDS violated.
30035LB_MES_LB_FKLoad bid for message is not in the database.
30036LB_MES_MES_FKMessage for load bid is not in the database.
30037LB_MES_PKThis Message already assigned to this Bid.
30038LOAD_BID_EGY_FORCAST_MW_INT_CKThe Energy Forecast Bid MWs must be a whole number.
30039LOAD_BID_ENERGY_BID_MW_INT_CKThe Energy Bid MW must be a whole number.
30040LOAD_BID_INTRPT_FIXED_INT_CKThe Interruptible Fixed MW must be a whole number.
30041LOAD_BID_PRICE_CAP_MW1_INT_CKThe Energy Price Cap MWs must be a whole number.
30042LOAD_BID_PRICE_CAP_MW2_INT_CKThe Energy Price Cap MWs must be a whole number.
30043LOAD_BID_PRICE_CAP_MW3_INT_CKThe Energy Price Cap MWs must be a whole number.
30044LOAD_BID_INTRPT_CAP_INT_CKThe Interruptible Price Cap MW must be a whole number.
30045ENERGY_PRICE_CAP_MW_NEG_POS_CKFor Energy Price Caps all negative MWs must be supplied before any positive MWs.
30046ENERGY_PRICE_CAP_MW_NONZERO_CKEnergy Price Cap MWs may not be zero.
30047SCH_INTRPT_CAP_MW_CKThe scheduled interruptible price cap MWs must be <= interruptible price cap MWs bid.
30048SCH_ENERGY_PR_CAP_MW_CKConstraint: SCH_ENERGY_PR_CAP_MW_CK on table LOAD_BIDS violated.

Unit Commitment Messagesback to top
Message IdConstraint NameConstraint Message
40000UCG_GEN_FKGenerator for unit commitment generator data is not in the database.
40001UCG_LAST_INS_USER_ID_FKUpdate user for unit commitment generator data is not in the database.
40002UCG_PKGenerator and BBS_CMMT_ID must be unique for UNIT COMMITMENT GENERATOR DATA. (Internal Error - UCG_PK) Contact Market Services.
40003UC_MAX_STOPS_DAY_POS_CKGenerator Maximun Stops per Day must be >= 1.
40004UC_MIN_DOWN_TIME_MAX_CKGenerator Minimun Down Time(hrs) must be <= 168.
40005UC_MIN_DOWN_TIME_POS_CKGenerator Minimum Down Time(hrs) must be >= 0.
40006UC_MIN_RUN_TIME_VAL_CKGenerator Minimum Run Time(hrs) must be between 0 and 24.
40007UC_STRT_UP_COST_CRV1_POS_CKFirst point(k$) on generator Startup Cost Curve must be >= 0.
40008UC_STRT_UP_COST_CRV2_POS_CKSecond point(k$) on generator Startup Cost Curve must be >= 0.
40009UC_STRT_UP_COST_CRV3_POS_CKThird point(k$) on generator Startup Cost Curve must be >= 0.
40010UC_STRT_UP_COST_CRV4_POS_CKFourth point(k$) on generator Startup Cost Curve must be >= 0.
40011UC_STRT_UP_COST_CRV5_POS_CKFifth point(k$) on generator Startup Cost Curve must be >= 0.
40012UC_STRT_UP_COST_CRV6_POS_CKSixth point(k$) on generator Startup Cost Curve must be >= 0.
40013UC_STRT_UP_COST_TIME_CRV2_CKGenerator Hours Off-Line(hrs) and Startup Cost(k$) at point 2 must BOTH be either null or non null.
40014UC_STRT_UP_COST_TIME_CRV3_CKGenerator Hours Off-Line(hrs) and Startup Cost(k$) at point 3 must BOTH be either null or non null..
40015UC_STRT_UP_COST_TIME_CRV4_CKGenerator Hours Off-Line(hrs) and Startup Cost(k$) at point 4 must BOTH be either null or non null.
40016UC_STRT_UP_COST_TIME_CRV5_CKGenerator Hours Off-Line(hrs) and Startup Cost(k$) at point 5 must BOTH be either null or non null.
40017UC_STRT_UP_COST_TIME_CRV6_CKGenerator Hours Off-Line(hrs) and Startup Cost(k$) at point 6 must BOTH be either null or non null.
40018UC_STRT_UP_HRS_OFFLINE_CRV1_CKGenerator Hours Off-Line(hrs) and Startup Hours at point 1 must BOTH be either null or non null.
40019UC_STRT_UP_HRS_OFFLINE_CRV2_CKGenerator Hours Off-Line(hrs) and Startup Hours at point 2 must BOTH be either null or non null.
40020UC_STRT_UP_HRS_OFFLINE_CRV3_CKGenerator Hours Off-Line(hrs) and Startup Hours at point 3 must BOTH be either null or non null.
40021UC_STRT_UP_HRS_OFFLINE_CRV4_CKGenerator Hours Off-Line(hrs) and Startup Hours at point 4 must BOTH be either null or non null.
40022UC_STRT_UP_HRS_OFFLINE_CRV5_CKGenerator Hours Off-Line(hrs) and Startup Hours at point 5 must BOTH be either null or non null.
40023UC_STRT_UP_HRS_OFFLINE_CRV6_CKGenerator Hours Off-Line(hrs) and Startup Hours at point 6 must BOTH be either null or non null.
40024UC_STRT_UP_HRS_OFF_ASCEND_CKGenerator Hours Off-Line(hrs) must be ascending.
40025UC_STRT_UP_HRS_OFF_NO_SKIP_CKGenerator Hours Off-Line(hrs) must have no skipped values.
40026UC_STRT_UP_HRS_STRT_ASCEND_CKGenerator Hours To Start(hrs) must be ascending.
40027UC_STRT_UP_HRS_STRT_NO_SKIP_CKGenerator Hours To Start(hrs) must have no skipped values.
40028UC_STRT_UP_TIME_ASCEND_CKGenerator Startup Hours must be ascending.
40029UC_STRT_UP_TIME_NO_SKIP_CKGenerator Startup Hours must have no skipped values.
40030UC_STRT_UP_COST_ASCEND_CKGenerator Startup Costs must be ascending.
40031UC_STRT_UP_COST_NO_SKIP_CKGenerator Startup Costs must have no skipped values.

User Update, Misc.back to top
Message IdConstraint NameConstraint Message
50000ORG_BID_TCC_VS_BILL_ORG_QL_CKNyiso Customer must be Billing Org Qualified to recieve BID_TCC flag

Administrator Messages
Market Participant Adminback to top
Message IdConstraint NameConstraint Message
200000BUS_USE_BUS_FKBus for the user is not in the database.
200001BUS_USE_PKThis User already authorized for this Bus.
200002BUS_USE_USE_FKUser for the bus is not in the database.
200003GEN_USE_GEN_FKGenerator for the user is not in the database.
200004GEN_USE_PKThis User is already authorized for this Generator.
200005GEN_USE_USE_FKUser for the generator is not in the database.
200006USERS_UK1A user already existes with the Oracle User Name you entered. A different name must be selected.
200007USER_ACTIVE_CKUSER_ACTIVE_CK: User must be Active = 'Y' for any of the Authorized to Bid flags to be set to 'Y'.
200008USER_ORACLE_USERNAME_CKIllegal Oracle User name. Use a different name.
200009USE_LAST_UPD_ADM_ID_FKUpdate administrator for usere is not in the database.
200010USE_LAST_UPD_USER_ID_FKUpdate user for user is not in the database.
200011USE_ORG_FKUser's organization is not in the database.
200012USE_PKUser USER_ID must be unique. (Internal error USE_PK) Contact Market Services.

ISO Adminback to top
Message IdConstraint NameConstraint Message
300000ADM_ACTIVE_CKADM_ACTIVE_CK: Inactive administrators are not allowed to have administrative permissions set to 'Y'.
300001ADM_LAST_INS_ADM_IDUpdate Administrator is not in the database.
300002ADM_ORACLE_USERNAME_CKIllegal Oracle User name. Use a different name.
300003ADM_ORG_FKAdministrator's organization is not in the database.
300004ADM_PKAdministrator ADM_ID must be unique. (Internal error - ADM_PK) Contact Market Services.
300005ADM_UK1An administrator already existes with the Oracle User Name you entered. A different name must be selected.
300006ADM_GEN_ADM_FKAdministrator for the generator is not in the database.
300007ADM_GEN_GEN_FKGenerator for the administrator is not in the database.
300008ADM_GEN_PKThis Administrator is already assigned to the this Generator.
300009ADM_LSE_ADM_FKAdministrator for the load serving entity is not in the database.
300010ADM_LSE_LSE_FKLoad serving entity for the administrator is not in the database.
300011ADM_LSE_PKThis Administrator is already assigned to the this Load Serving Entity.
300012ADM_ORG_ADM_FKAdministrator for the organization is not in the database.
300013ADM_ORG_ORG_FKOrganization for the administrator is not in the database.
300014ADM_ORG_PKThis Administrator is already assigned to the this Organization.
300015BUSES_NAME_UKBus name (Station Name, Voltage Class, Load Name) must be unique.
300016BUS_ACTIVE_CKBUS_ACTIVE_CK: Must set bid permissions to 'N' before making bus inactive.
300017BUS_EDC_AREA_CKBUS_EDC_AREA_CK: Bus EDC area must be between 1 and 13.
300018BUS_LAST_INS_ADM_IDUpdate Administrator is not in the database.
300019BUS_LSE_FKLoad serving entity for bus is not in the database.
300020BUS_PKLoad bus BUS_ID must be unique. (Internal error BUS_PK) Contact Market Services.
300021BUS_PTID_LSE_UKLoad Serving entity combined with BUS PTID must be unique.
300022BUS_SUB_FKSubzone for bus is not in the database.
300023GEN_ACTIVE_CKAll generator Qualified to Bid flags must be set to 'N' and the Billing Organization set to NONE selected before Active flag is set to 'N'.
300024GEN_BILLING_ORG_CKActive generators must have billing organization identification.
300025GEN_BILLING_ORG_FKBilling organization for generator is not in the database.
300026GEN_CONTRACT_SUMMER_CKContracted Summer Installed Capacity must be <= Max Summer Operating Limit.
300027GEN_CONTRACT_WINTER_CKContracted Winter Installed Capacity must be <= Max Winter Operating Limit.
300028GEN_DAM_FIX_CKWhen Day Ahead - Fixed Energy flag = 'N' then Day Ahead - Dispatch Energy, 10 Minute Spinning, 30 Minute Spinning and Regulation Control must = 'N'.
300029GEN_DAM_RESRV_CKWhen Day Ahead - 30 Minute Non-Synchronized Reserve = 'N' then Day Ahead - Fixed Energy, Dispatch Energy, 10 Minute Non-Synch, 10 Minute Spinning, 30 Minute Spinning and Regulation Control must = 'N'.
300030GEN_EMER_RESP_RATE_NULL_CKBoth Normal Response Rate and Emergency Response Rate cannnot be null.
300031GEN_EMER_RESP_RATE_VAL_CKEmergency Response Rate must be >= Normal Response Rate.
300032GEN_GEN2_UKGenerator PTID must be unique.
300033GEN_GEN3_UKGenerator NERC ID must be unique.
300034GEN_GENTYPE_CKGenerators and SYNCH. Condensors cannot have bid flags = Y or a billing org identification.
300035GEN_GT_FKGenerator type is not in the database
300036GEN_HAM_FIX_CKWhen Balancing Market - Fixed Energy flag = 'N' then Balancing Market - Dispatch Energy, 10 Minute Spinning, 30 Minute Spinning and Regulation Control must = 'N'.
300037GEN_HAM_RESRV_CKWhen Balancing Market - 30 Minute Non-Synchronized Reserve = 'N' then Balancing Market - Fixed Energy, Dispatch Energy, 10 Minute Non-Synch, 10 Minute Spinning, 30 Minute Spinning and Regulation Control must = 'N'.
300038GEN_LAST_INS_ADM_ID_FKUpdate administrator for generator is not in the database.
300039GEN_LAST_UPD_USER_ID_FKUpdate user for generator is not in the database.
300040GEN_LEAD_LAG_CURVE_POS_CKLeading and Lagging Unit VAR Capability (MW & MVAR) must be >= 0.
300041GEN_MAX_RESP_RATE_NULL_CKMax Regulation Response Rate cannot be non null when Day Ahead or Balancing Market Regulation Control = 'N'
300042GEN_MAX_RESP_RATE_VAL_CKNon null value of Max Regulation Response Rate must be >= .01*(Max Winter Operating Limit + Max Summer Operating Limit)/2 and <= non null value of Normal Response Rate.
300043GEN_NORMAL_RESP_RATE_NULL_CKWhen Normal_Response_Rate is null then Qualified to Bid: Day Ahead and Balancing Market - Fixed Energy, Dispatch Energy, 10 Minute Spinning, 10 Minute Non-Sync, 30 Minute Spinning, 30 Minute Non-Sync and Regulation Control must be 'N'.
300044GEN_NORMAL_RESP_RATE_VAL_CKNon null value of the Normal Response Rate must be >= .01*(Max Winter Operating Limit + Max Summer Operating Limit)/2.
300045GEN_PENALTY_FACTOR_CKPenalty Factor must be between 0.8 and 1.3
300046GEN_PKGenerator GEN_ID must be unique. (Internal error - GEN_PK) Contact Market Services.
300047GEN_POWER_FACTOR_CKPower Factor must be between -1.0 and 1.0.
300048GEN_SUBZONE_FKSubzone for generator is not in the database.
300049GEN_SUMMER_MAX_CKMax Summer Operating Limit must be >= 2.0 and > Physical Min MW.
300050GEN_WINTER_MAX_CKMax Winter Operating Limit must be >= 2.0 and > Physical Min MW.
300051GEN_ORG_GEN_FKGenerator for the organization is not in the database.
300052GEN_ORG_ORG_FKOrganization for the generator is not in the database.
300053GEN_ORG_PKThis Organization is already authorized for this Generator.
300054LCS_LAST_INS_ADM_ID_FKUpdate administrator for load serving entity is not in the database.
300055LSE_ACTIVE_CKLSE_ACTIVE_CK: When LSE is Qualified to Bid then it must also be Active.
300056LSE_BID_BILL_ORG_CKLSE_BID_BILL_ORG_CK: IF LSE is qualified to bid then it must have a Billing Organinization Identification assigned.
300057LSE_BILL_ORGANIZATION_FKBilling organization for load serving entity is not in the database.
300058LSE_NAME_UKLoad Serving Entity Name must be unique.
300059LSE_PKLoad Serving Entity LSE_ID must be unique. (Internal error - LSE_PK) Contact Market Services.
300060LSE_PTID_UKLoad Serving Entity PTID must be unique.
300061LSE_ORG_LSE_FKLoad serving entity for organization is not in the database.
300062LSE_ORG_ORG_FKOrganization for load serving entity is not in the database.
300063LSE_ORG_PKThis Organization is already authorized for this Load Serving Entity.
300064ORG_ACTIVE_CKORG_ACTIVE_CK: Organization must have Active = 'Y' for any of the Authorized to Bid flags to be set to 'Y'.
300065ORG_DAM_HAM_CLOSE_OFFSET_CKORG_DAM_HAM_CLOSE_OFFSET_CK: An organizations Maximum Future Bid Days, DAM Close Offset Hours, DAM Post Offset Hours, HAM Close Offset Minutes and HAM Post Offset Minutes must be > 0. The DAM/HAM Close Offset must be > the DAM/HAM Post Offset.
300066ORG_LAST_INS_ADM_ID_FKUpdate administrator for organization is not in the database.
300067ORG_ORG2_UKAgreement Reference Number must be unique.
300068ORG_ORG_TYPE_FKOrganization type is not in the database.
300069ORG_PE_TYPE_CKORG_PE_TYPE_CK: Only organizations of type Direct Customer may be Billing Organization Qualified.
300070ORG_PKOrganization ORG_ID must be unique. (Internal error - ORG_PK) Contact Market Services.
300071ORG_TYPE_BID_CKORG_TYPE_BID_CK: Only organization type = 'DIRECT CUSTOMER' or 'NY ISO' may have any of the Authorized to Bid flags set to 'Y'.
300072SUB_LAST_INS_ADM_ID_FKUpdate administrator for subzone is not in the database.
300073SUB_LSE_FKLoad serving entity for subzone is not in the database.
300074SUB_PKSubzone SUBZONE_ID must be unique. (Internal error SUB_PK) Contact Market Services.
300075SUB_SUB2_UKSubzone PTID must be unique.
300076SUB_SUB3_UKSubzone Name must be unique.
300077SUB_ZON_FKZone for subzone is not in the database.
300078ZON_LAST_INS_ADM_ID_FKUpdate administrator for zone is not in the database.
300079ZON_PKZone ZONE_ID must be unique. (Internal error ZON_PK) Contact Market Services.
300080ZON_ZON2_UKZone PTID must be unique.
300081ZON_ZON3_UKZone Name must be unique.
300082BUS_NO_INTRPT_LOAD_CKSupporting interruptable load bids is not currently supported.
300083BUS_BID_FLAG_PCLB_CKZonal load locations (voltage_class='PCLB') can only be price cap bid qualified.
300182INV_CTRL_POSTED_NOTIFY_CKMarket Notification Flag cannot be checked until the Posting Verified Flag is checked.
300183INV_CTRL_ALL_FLAGS_CKCannot check Invoice Locked flag until ICAP Verified, Past Due Balances, Working Capital and Interest Verified flags are checked.
305000ASL2_PKThe combination of ZONE_ID, SOURCE_ID and TIME_STAMP must be unique for ANCILLARY_SERVICE_LBMPS.
305001ASL2_SRC_FKAncillary services lbmp source is not in the database.
305002ASL2_UPDATE_USER_IUpdate User is not in the database.
305003ASL2_ZON_FKZone for ancillary service lbmp is not in the database.
305004ASL_MW_TYPE_CKASL_MW_TYPE_CK: Reserve lost opportunity cost, 10 minute spinning block reserves, 10 minute nonsynch reserves, 30 minute operating reserves and regulation availability are not allowed to be all null.
305005GA_GEN_FKGenerator is not in the database.
305006GA_PKThe combination of GEN_ID and DATE_HR must be unique for GENERATOR_AVAILABILITIES.
305007GPR_GEN_FKGenerator for generator pts result is not in the database.
305008GPR_PKThe combination of GEN_ID and TIME_STAMP must be unique for GENERATOR_PTS_RESULTS.
305009GPR_SIH_FKSCD interval header for generator pts result is not in the database.
305010GSS_GEN_FKGenerator for generator scd schedule is not in the database.
305011GSS_PKThe combination of GEN_ID, TIME_STAMP and Source_ID must be unique for GENERATOR_SCD_SCHEDULES.
305012GSS_RES_LOST_OPP_NULL_CKGSS_RES_LOST_OPP_NULL_CK: When reserve lost opportunity generation MWs are null then the corresponding cost must be null.
305013GSS_SRC_FKSource for generator scd schedule is not in the database.
305014GSS_USER_FKUpdate user for generator scd schedule is not in the database.
305015GSH_GEN_FKGenerator for generator status history is not in the database.
305016GSH_PKThe combination of GEN_ID and STATUS_CHANGE_TIME_STAMP must be unique for GENERATOR_STATUS_HISTORIES.
305017GT_LAST_UPDATE_ADM_IDUpdate Administrator is not in the database.
305018GT_PKGEN_TYPE ID must be unique.
305019GRES_GEN_FKGenerator for generator reliability evaluation scheduleis not in the database.
305020GRES_PKThe combination of GEN_ID and DATE_HR must be unique for GEN_RELIABILITY_EVAL_SCHEDULES.
305021GRES_UCG_FKGenerator's unit commitment data for generator reliability evaluation schedule is not in the database.
305022LBMPS_LAST_UPD_USER_ID_FKUpdate user for lbmp is not in the database.
305023LBMPS_PKThe combination of PTID, Source_ID and TIME_STAMP must be unique for LBMPS.
305024LBMPS_SRC_FKSource for lbmp is not in the database.
305025SIH_PKTime Stamp must be unique for SCD Interval Headers.
305026TFR_PKThe combination of PTID and TIME_STAMP must be unique for TIE_FLOW_RESULTS.
305027TFR_SIH_FKSCD interval header for tie flow result is not in the database.
305028TFR_USE_FKUpdate user for tie flow result is not in the database.
305029TRR_LSE_FKLoad serving entity for TP regulation result is not in the database.
305030TRR_PKThe combination of LSE_ID and TIME_STAMP must be unique for TP_REGULATION_RESULTS.
305031TRR_SIH_FKSCD interval header for TP regulation result is not in the database.
305032TC1_INT_FKInterface for transmission constraint is not in the database.
305033TC1_LAST_INS_USER_ID_FKUpdate user for transmission constraint is not in the database.
305034TC1_PKBBS_ID must be unique for TRANSMISSION_CONSTRAINTS .
305035TC1_SRC_FKSource for transmission constraint is not in the database.
305036TC1_SRC_HAM_DAM_CKTC1_SRC_HAM_DAM_CK: Source ID must be either 3 or 4.
305037ZL_LAST_UPD_USER_ID_FKUpdate user for zone load is not in the database.
305038ZL_PKThe combination of ZONE_ID and DATE_HR must be unique for ZONE_LOADS. (Internal error ZL_PK).
305039ZL_SRC_FKSource for zone load is not in the database.
305040ZL_ZON_FKZone for zone load is not in the database.
305041IEL_PKINTERFACE ERROR LOG ID must be unique.
305042IEL_SEVERITY_LEVEL_CKConstraint: IEL_SEVERITY_LEVEL_CK on table INTERFACE_ERROR_LOG violated.
305043GEN_LOAD_PHY_MIN_GEN_CKGenerator's physical min gen must be 0 for Curtailable and Self Supply Loads.
305044GEN_LOAD_TYPE_CKCurtailable and Self Supply Loads may not be qualified to bid DAM/HAM 10/30 Min spinning or non-synch, DAM/HAM regulation or HAM fixed or dispatchable energy .
305045GEN_LOAD_AVR_CKAVR qualified must be N for Curtailable and Self Supply Loads.
305046GEN_LOAD_NERC_CKNERC di must be NULL for Curtailable and Self Supply Loads.
305048GEN_LOAD_LEAD_LAG_CURVE_CKLead and Lag Cap curve mvars and mws must be null for Curtailable and Self Supply Loads.
310000BS_LAST_INS_ADM_IDUpdate Administrator is not in the database.
310001BS_PKBid Status ID must be unique.
310002CM_LAST_INS_ADM_IDUpdate Administrator is not in the database.
310003CONSTRAINT_MSG_PKConstraint Name must be unique.
310004DH_PKDate Hour must be unique.
310005DST_SCHEDULE_DATE_CKBeginning daylight savings time must be < ending time.
310006DST_SCHEDULE_PKBegin date must be unique.
310007GLOBAL_PARAM_PKParameter Name must be unique.
310008GP_LAST_UPD_USER_ID_FKUpdate user for global parameter is not in the database.
310009ME_PKMenu Entry ID must be unique.
310010MES_LAST_INS_ADM_ID_FKUpdate administrator for message is not in the database.
310011MES_NAME_UKMessage Name must be unique.
310012MES_PKMessage_id must be unique.
310013NP_PKPriority ID must be unique.
310014NP_UKPriority Description must be unique.
310015ORG_TYP_LAST_INS_ADM_FKUpdate administrator for organization type is not in the database.
310016ORG_TYP_ORG_TYP2_UKOrganization Type Description must be uniue.
310017ORG_TYP_PKOrganization Type ID must be unique.
310018SRC_ADM_FKUpdate administrator for source is not in the database.
310019SRC_PKSource ID must be unique.
310020INT_INT2_UKInterface PTID must be unique.
310021INT_LAST_INS_ADM_ID_FKUpdate administrator for interface is not in the database.
310022INT_PKInterface ID must be unique.
310023ME_PRIV_ME_FKMenu entry for privilege is not in the database.
310024ME_PRIV_PKThe combination of Menu Entry ID and privilege must be unique.