Oracle Utilities Network Management System field | Oracle Utilities Customer to Meter field | Notes |
|---|---|---|
SERV_POINT_ID | ||
DEVICE_ID | externalId | Device ID provide must exist in the NMS supply nodes table. From C2M, obtain an external ID from facility. |
FEEDER_ID | ||
ACCOUNT_TYPE | serviceType | Account Type provide must exist in the Account Type Table in NMS. Use DVM OUC2M_OUNMS_ AccountType. |
CREATION_TIME | Timestamp for the record's creation. NMS stored procedure will put the current date time on for new records inserted. Not mapped by the integration. | |
ACTIVE | status | Flag identifying currently active records: Y - For Current Customers N - For Inactive customers From C2M, usageSubscriptionInfo/status is mapped. Use OUC2M_OUNMS_UsageSub_Status DVM. |
CUST_ID | cisAccountId | Unique external system generated primary key. C2M Account must be linked to a metered service point via active service agreement. |
CUST_ACCOUNT_NUMBER | cisAccountId | |
CUST_NAME | name | This is the primary person linked to the account. If it is a Person, it contains the concatenation of last, first and middle names. If it is a business, contains the business name. |
CUST_LAST_NAME | ||
CUST_FIRST_NAME | ||
CUST_MIDDLE_NAME | ||
CUST_HOME_AREA_CODE | First 3 numbers of homePhone | Get Area Code from C2M homePhone element. homePhone retrieved from C2M depends on the home phone type defined in C2M feature configuration schema constants. |
CUST_HOME_PHONE | From fourth to tenth number of homePhone | Get Phone Number from C2M homePhone element. homePhone retrieved from C2M depends on the home phone type defined in C2M feature configuration schema constants. |
CUST_DAY_AREA_CODE | First 3 numbers of businessPhone | Get Area Code from C2M homePhone element. homePhone retrieved from C2M depends on the home phone type defined in C2M feature configuration schema constants. |
CUST_DAY_PHONE | From fourth to tenth number of businessPhone | Get Phone Number from C2M homePhone element. homePhone retrieved from C2M depends on the home phone type defined in C2M feature configuration schema constants. |
CUST_DAY_PHONE_EXT | This is the extension for the businessPhone. | |
CUST_ADDRESS1 | ||
CUST_ADDRESS2 | ||
CUST_ADDRESS3 | ||
CUST_ADDRESS4 | ||
CUST_CITY | ||
CUST_STATE | ||
CUST_POSTCODE1 | ||
CUST_POSTCODE2 | ||
CUST_UDF1 | userDefinedField1 | Person/Contact user Defined Field |
CUST_UDF2 | userDefinedField2 | Person/Contact user Defined Field |
CUST_UDF3 | userDefinedField3 | Person/Contact user Defined Field |
CUST_UDF4 | userDefinedField4 | Person/Contact user Defined Field |
SERV_PREMISE_ID | cisPremiseId | Unique external system generated primary key. |
SERV_ACCOUNT_NUMBER | cisAccountId | Account number linked to the premise ID. |
SERV_LIFE_SUPPORT | lifeSupportSensitiveLoad | The C2M premise life support/sensitive load field. Use DVM OUC2M_OUNMS_LifeSupportIndicator. |
SERV_ADDRESS1 | ||
SERV_ADDRESS2 | ||
SERV_ADDRESS3 | ||
SERV_ADDRESS4 | ||
SERV_CITY | ||
SERV_STATE | ||
SERV_CITY_STATE | Concatenate city, state | The delimiter that the integration uses for concatenation will always be (,) comma. |
SERV_POSTCODE1 | postal | |
SERV_POSTCODE2 | ||
SERV_A_PRIORITY | Set of 26 Service Priorities are available for configuration. Kindly refer the C2M feature configuration to configure the service priorities for Critical, Medial, Key or other services (A to Z). | |
SERV_B_PRIORITY | ||
SERV_C_PRIORITY | ||
SERV_D_PRIORITY | ||
SERV_E_PRIORITY | ||
SERV_F_PRIORITY | ||
SERV_G_PRIORITY | ||
SERV_H_PRIORITY | ||
SERV_I_PRIORITY | ||
SERV_J_PRIORITY | ||
SERV_K_PRIORITY | ||
SERV_L_PRIORITY | ||
SERV_M_PRIORITY | ||
SERV_N_PRIORITY | ||
SERV_O_PRIORITY | ||
SERV_P_PRIORITY | ||
SERV_Q_PRIORITY | ||
SERV_R_PRIORITY | ||
SERV_S_PRIORITY | ||
SERV_T_PRIORITY | ||
SERV_U_PRIORITY | ||
SERV_V_PRIORITY | ||
SERV_W_PRIORITY | ||
SERV_X_PRIORITY | ||
SERV_Y_PRIORITY | ||
SERV_Z_PRIORITY | ||
SERV_UDF1 | userDefinedField1 | Service location user defined field |
SERV_UDF2 | userDefinedField2 | Service location user defined field |
SERV_UDF3 | userDefinedField3 | Service location user defined field |
SERV_UDF4 | userDefinedField4 | Service location user defined field |
METER_ID | meterId | From C2M Device Table |
METER_NUMBER | badgeNumber | From C2M Device Table |
METER_TYPE | meterType | From C2M Device Table OUC2M_OUNMS_MeterType DVM |
METER_MANUFACTURER | Manufacturer | From C2M Device Table Use OUC2M_OUNMS_Manufacturer DVM |
METER_UDF1 | userDefinedField1 | Meter user defined field |
METER_UDF2 | userDefinedField2 | Meter user defined field |
METER_UDF3 | userDefinedField3 | Meter user defined field |
METER_UDF4 | userDefinedField4 | Meter user defined field |
SP_UDF1 | userDefinedField1 | Service point User Defined Field |
SP_UDF2 | userDefinedField2 | Service point User Defined Field |
SP_UDF3 | userDefinedField3 | Service point User Defined Field |
SP_UDF4 | userDefinedField4 | Service point User Defined Field |
OUC2M Customer SP Sync Request Message | OUNMS Create/Update Customer Stored Procedure | ||||
|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | DVM Name | Comments |
sendDetails | OuterMostTag | P_CUST | |||
syncRequestId | sendDetails | Field | |||
contactInfo | sendDetails | Group | |||
usageSubscriptionInfo | sendDetails | Group | |||
servicePointInfo | sendDetails | Group | |||
facilityInfo | sendDetails | Group | |||
meterInfo | sendDetails | Group | |||
itemInfo | sendDetails | Group | |||
contactId | contactInfo | Field | |||
cisPersonId | contactInfo | Field | |||
name | contactInfo | Field | CUST_NAME | ||
homePhone | contactInfo | Field | CUST_HOME_AREA_ CODE CUST_HOME_PHONE | ||
businessPhone | contactInfo | Field | CUST_DAY_AREA_CODE CUST_DAY_PHONE | ||
customerUDFs | contactInfo | Group | |||
userDefinedField1 | customerUDFs | Field | CUST_UDF1 | ||
userDefinedField2 | customerUDFs | Field | CUST_UDF2 | ||
userDefinedField3 | customerUDFs | Field | CUST_UDF3 | ||
userDefinedField4 | customerUDFs | Field | CUST_UDF4 | ||
usId | usageSubscriptionInfo | Field | |||
status | usageSubscriptionInfo | Field | ACTIVE | OUC2M_OUNMS_Usag eSub_Status | |
cisSAId | usageSubscriptionInfo | Field | |||
cisAccountId | usageSubscriptionInfo | Field | CUST_ID CUST_ACCOUNT_ NUMB ER SERV_ACCOUNT_ NUMB ER | ||
spId | servicePointInfo | Field | |||
spType | servicePointInfo | Field | |||
Division | servicePointInfo | Field | |||
cisSPId | servicePointInfo | Field | SERV_POINT_ID | ||
cisPremiseId | servicePointInfo | Field | SERV_PREMISE_ID | ||
facilityId | servicePointInfo | Field | |||
lifeSupportSensitiveLoad | servicePointInfo | Field | SERV_LIFE_SUPPORT | ||
country | servicePointInfo | Field | |||
addressLine1 | servicePointInfo | Field | CUST_ADDRESS1 SERV_ADDRESS1 | ||
addressLine2 | servicePointInfo | Field | CUST_ADDRESS2 SERV_ADDRESS2 | ||
addressLine3 | servicePointInfo | Field | CUST_ADDRESS3 SERV_ADDRESS3 | ||
addressLine4 | servicePointInfo | Field | CUST_ADDRESS4 SERV_ADDRESS4 | ||
number1 | servicePointInfo | Field | |||
number2 | servicePointInfo | Field | |||
inCityLimit | servicePointInfo | Field | |||
city | servicePointInfo | Field | CUST_CITY SERV_CITY | ||
geographic | servicePointInfo | Field | |||
county | servicePointInfo | Field | |||
state | servicePointInfo | Field | CUST_STATE SERV_STATE | ||
postal | servicePointInfo | Field | CUST_POSTCODE1 SERV_POSTCODE1 | ||
criticalCustomerTypes | servicePointInfo | Group | |||
servicePointUDFs | servicePointInfo | Group | |||
serviceLocationUDFs | servicePointInfo | Group | |||
serviceType | servicePointInfo | Field | ACCOUNT_TYPE | OUC2M_OUNMS_ AccountType | |
criticalCustomerTypeA | criticalCustomerTypes | Field | SERV_A_PRIORITY | OUC2M_OUNMS_Serv_A_Priority | |
criticalCustomerTypeB | criticalCustomerTypes | Field | SERV_B_PRIORITY | OUC2M_OUNMS_Serv_B_Priority | |
criticalCustomerTypeC | criticalCustomerTypes | Field | SERV_C_PRIORITY | OUC2M_OUNMS_Serv_C_Priority | |
criticalCustomerTypeD | criticalCustomerTypes | Field | SERV_D_PRIORITY | OUC2M_OUNMS_Serv_D_Priority | |
criticalCustomerTypeE | criticalCustomerTypes | Field | SERV_E_PRIORITY | OUC2M_OUNMS_Serv_E_Priority | |
criticalCustomerTypeF | criticalCustomerTypes | Field | SERV_F_PRIORITY | OUC2M_OUNMS_Serv_F_Priority | |
criticalCustomerTypeG | criticalCustomerTypes | Field | SERV_G_PRIORITY | OUC2M_OUNMS_Serv_G_Priority | |
criticalCustomerTypeH | criticalCustomerTypes | Field | SERV_H_PRIORITY | OUC2M_OUNMS_Serv_H_Priority | |
criticalCustomerTypeI | criticalCustomerTypes | Field | SERV_I_PRIORITY | OUC2M_OUNMS_Serv_I_Priority | |
criticalCustomerTypeJ | criticalCustomerTypes | Field | SERV_J_PRIORITY | OUC2M_OUNMS_Serv_J_Priority | |
criticalCustomerTypeK | criticalCustomerTypes | Field | SERV_K_PRIORITY | OUC2M_OUNMS_Serv_K_Priority | |
criticalCustomerTypeL | criticalCustomerTypes | Field | SERV_L_PRIORITY | OUC2M_OUNMS_Serv_L_Priority | |
criticalCustomerTypeM | criticalCustomerTypes | Field | SERV_M_PRIORITY | OUC2M_OUNMS_Serv_M_Priority | |
criticalCustomerTypeN | criticalCustomerTypes | Field | SERV_N_PRIORITY | OUC2M_OUNMS_Serv_N_Priority | |
criticalCustomerTypeO | criticalCustomerTypes | Field | SERV_O_PRIORITY | OUC2M_OUNMS_Serv_O_Priority | |
criticalCustomerTypeP | criticalCustomerTypes | Field | SERV_P_PRIORITY | OUC2M_OUNMS_Serv_P_Priority | |
criticalCustomerTypeQ | criticalCustomerTypes | Field | SERV_Q_PRIORITY | OUC2M_OUNMS_Serv_Q_Priority | |
criticalCustomerTypeR | criticalCustomerTypes | Field | SERV_R_PRIORITY | OUC2M_OUNMS_Serv_R_Priority | |
criticalCustomerTypeS | criticalCustomerTypes | Field | SERV_S_PRIORITY | OUC2M_OUNMS_Serv_S_Priority | |
criticalCustomerTypeT | criticalCustomerTypes | Field | SERV_T_PRIORITY | OUC2M_OUNMS_Serv_T_Priority | |
criticalCustomerTypeU | criticalCustomerTypes | Field | SERV_U_PRIORITY | OUC2M_OUNMS_Serv_U_Priority | |
criticalCustomerTypeV | criticalCustomerTypes | Field | SERV_V_PRIORITY | OUC2M_OUNMS_Serv_V_Priority | |
criticalCustomerTypeW | criticalCustomerTypes | Field | SERV_W_PRIORITY | OUC2M_OUNMS_Serv_W_Priority | |
criticalCustomerTypeX | criticalCustomerTypes | Field | SERV_W_PRIORITY | OUC2M_OUNMS_Serv_X_Priority | |
criticalCustomerTypeY | criticalCustomerTypes | Field | SERV_W_PRIORITY | OUC2M_OUNMS_Serv_Y_Priority | |
criticalCustomerTypeZ | criticalCustomerTypes | Field | SERV_W_PRIORITY | OUC2M_OUNMS_Serv_Z_Priority | |
userDefinedField1 | servicePointUDFs | Field | SP_UDF1 | ||
userDefinedField2 | servicePointUDFs | Field | SP_UDF2 | ||
userDefinedField3 | servicePointUDFs | Field | SP_UDF3 | ||
userDefinedField4 | servicePointUDFs | Field | SP_UDF4 | ||
userDefinedField1 | serviceLocationUDFs | Field | SERV_UDF1 | ||
userDefinedField2 | serviceLocationUDFs | Field | SERV_UDF2 | ||
userDefinedField3 | serviceLocationUDFs | Field | SERV_UDF3 | ||
userDefinedField4 | serviceLocationUDFs | Field | SERV_UDF4 | ||
facilityId | facilityInfo | Field | |||
facilityType | facilityInfo | Field | |||
externalId | facilityInfo | Field | DEVICE_ID | ||
meterId | meterInfo | Field | METER_ID | If meterinfo exists send meterId to METER_ID. | |
badgeNumber | meterInfo | Field | METER_NUMBER | If meterinfo exists, send badgeNumber to METER_NUMBER. | |
serialNumber | meterInfo | Field | |||
MeterType | meterInfo | Field | METER_TYPE | OUC2M_OUNMS_ MeterType | |
manufacturer | meterInfo | Field | METER_ MANUFACTURER | OUC2M_OUNMS_ Manufacturer | |
MeterUDFs | meterInfo | Group | |||
userDefinedField1 | meterUDFs | Field | METER_UDF1 | ||
userDefinedField2 | meterUDFs | Field | METER_UDF2 | ||
userDefinedField3 | meterUDFs | Field | METER_UDF3 | ||
userDefinedField4 | meterUDFs | Field | METER_UDF4 | ||
itemId | itemInfo | Field | METER_ID | If itemId exists, send it to METER_ID. | |
badgeNumber | itemInfo | Field | METER_NUMBER | ||
serialNumber | itemInfo | Field | |||
itemType | itemInfo | Field | METER_TYPE | OUC2M_OUNMS_ MeterType | |
manufacturer | itemInfo | Field | METER_ MANUFACTURER | OUC2M_OUNMS_ Manufacturer | |
OUC2M Customer SP Sync Request Message OUNMS Create/Update Customer Stored Procedure Output | OUC2M F1-UpdateAndTransitionSyncRequest Message | ||||
|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | DVM Name | Comments |
sendDetails | OuterMost Tag | F1- UpdateAndTransitionSync Request | |||
syncRequestId | sendDetails | Field | syncRequestId | ||
OutputParameters | Outermost Tag | ||||
P_ERR_NO | OutputParameters | Field | |||
exceptionInfo | |||||
messageCategory | Send C2M.Generic.MessageCategory property value defined in OUC2MOUNMSConfigurationProperties.x ml file. | ||||
messageNumber | Send C2M.Generic. MessageNumber property value defined in OUC2MOUNMSConfigurationProperties.x ml file. | ||||
P_ERR_MSG | OutputParameters | Field | comments | ||
messageParameters | |||||
parameterSequence | '1' | ||||
P_ERR_MSG | OutputParameters | Field | messageParameterValue | ||