srp_id

varchar2

8

0

The logical SRP server name.

srp_desc

varchar2

255

1

A description of the SRP.

srp_conn_type

char

1

0

Connection protocol from the SARM to the SRP. Valid values are:

• O – for Open Client.

• S – for sockets.

srp_host_name

varchar2

80

1

Name of the machine that the SRP resides upon.

srp_host_port

varchar2

6

1

The port number that the SRP is waiting on for socket connections.

wo_estimate_evt

varchar2

8

1

Work order estimate event.

If you configure the SARM using the configuration variable WO_TIME_ESTIMATE_ON to perform this work order estimation calculation, the SARM determines the approximate number and processing time for ASDLs on the work order. The SARM then calculates an approximate time estimate for this work order.

wo_failure_evt

varchar2

8

1

Work order failure event.

wo_complete_evt

varchar2

8

1

Work order complete event.

wo_start_evt

varchar2

8

1

Work order start event.

wo_soft_err_evt

varchar2

8

1

This notification is generated whenever an ASDL response on the work order is ‘Fail But Continue'. If the work order fails or completes, then this notification is followed by a Failure or Completion notification.

If this event is not required by the SRP, you must specify NO_WO_EVENT_NOTIFICATION (NO EVENT).

wo_blocked_evt

varchar2

8

1

Not supported.

wo_rollback_evt

varchar2

8

1

Generated when a work order fails and rollback is configured on one or more CSDLs on the order. It is also generated when a completed work order is cancelled and the SARM rolls back any completed ASDLs on the work order.

If this event is not required by the SRP, specify NO_WO_EVENT_NOTIFICATION (NO EVENT).

wo_timeout_evt

varchar2

8

1

Work order timeout event.

ne_unknown_evt

varchar2

8

1

If defined, the system event issued by the SARM when an NE unknown notification is being transmitted back to the SRP from the SARM. This notification is transmitted to the SRP upon a Remote to Host NE, or DN to Host NE routing error.

ne_avail_evt

varchar2

8

1

No longer used.

ne_unavail_evt

varchar2

8

1

No longer used.

wo_accept_evt

varchar2

8

1

If defined, the system event issued by the SARM when a work order acceptance notification is being transmitted back to the SRP from the SARM.

aux_srp_id

varchar2

8

1

Specifies the auxiliary SRP to where the SARM opens network connections in the event that the primary SRP is unavailable. Set this field to NULL.

aux_srp_conn_type

char

1

1

Connection protocol for SARM to auxiliary SRP communications. Valid values are:

• O – for Open Client.

• S – for sockets.

aux_srp_host_name

varchar2

80

1

Name of the machine that the auxiliary SRP resides upon.

aux_srp_host_port

varchar2

6

1

The number of the port that the auxiliary SRP is waiting on for socket connections.

stats_unid

number

38

0

The unique ID of the statistical entry which is generated at insert time.

stats_dts

date

-

0

The date and time that the statistical entry was logged.

wo_id

varchar2

80

0

The work order to which this statistical entry is related.

This is determined from the work order table at insert time.

wo_stat

number

1

0

The status of the associated work order.

This is determined from the work order table at insert time. An update trigger updates the work order status to match that of the work order.

This means that when a work order is completed, all statistical entries associated with that work order is updated to ‘Completed'.

The possible values for this field are the same as those in wo_stat in the SARM database table tbl_wrk_ord. See "tbl_wrk_ord (SARM)."

user_id

varchar2

64

0

The user ID associated with this log entry.

The user ID is determined from the orig_login field in the SARM database table tbl_wrk_ord at insert time. See "tbl_wrk_ord (SARM)."

srq_id

number

38

0

The service request related to this statistical entry.

asdl_cmd

varchar2

80

0

The ASDL being provisioned when the statistics log entry was created.

mcli

varchar2

80

1

If set, the Remote NE.

hcli

varchar2

80

0

The Host NE to which the ASDL currently being processed is routed.

dn

varchar2

24

1

If set, the directory number currently being provisioned.

len

varchar2

16

1

If set, the line equipment number currently being provisioned.

ne_cmd

varchar2

255

1

If set, the NE command string sent to the NE.

cmd_type

varchar2

25

1

If set, the type of NE command string.

The possible values which form the basis for simple statistical gathering include:

• ADD – service addition.

• REMOVE – service removal.

• CHANGE – service change.

• QUERY – query only, no provisioning performed.

You can customize this field and also specify other command types to better suit your statistical requirements.

cmd_stat

varchar2

25

1

If set, identifies the status of the NE command after transmission to the NE.

The possible values which form the basis for statistical gathering include:

• SUCCEED – Command completed successfully.

• FAIL – Command failed.

• RETRY – Command failed but retried.

• MAINTENANCE – Command failed because the NE is currently unavailable to receive provisioning requests.

• SOFT_FAIL – Command failed but processing continues on other ASDLs.

• DELAYED_FAIL – An ASDL had failed during provisioning. The SARM skips any subsequent ASDL in the CSDL, continues provisioning at the next CSDL, and then fails the order.

This field is customizable.

You can specify other command states to better suit your statistical requirements.

Refer to the ASAP Cartridge Development Guide for more detailed descriptions of these base_types.

cmd_reason

varchar2

255

1

If set, identifies the reason that the NE command failed. This is the error string returned from the NE.

You can generate reports to determine the principal error conditions in the provisioning process.

parm1

varchar2

25

1

Multi-purpose text field in which customer specific information is logged.

This field logs additional information in this table. To allow this in a flexible manner, these miscellaneous parameter fields have been provided.

parm2

varchar2

25

1

Same as parm1.

parm3

varchar2

25

1

Same as parm1.

parm4

varchar2

25

1

Same as parm1.

parm5

varchar2

25

1

Same as parm1.

parm6

varchar2

25

1

Same as parm1.

asdl_cmd

varchar2

80

0

The ASDL command.

reverse_asdl

varchar2

80

0

Only required if rollback is configured on the ASDL. If the ASDL requires rollback, the reverse ASDL command must be invoked.

ignore_rollback

char

1

0

Ignore rollback flag.

Possible values are:

• Y – Rollback is ignored for this ASDL.

• N – Rollback is required for this ASDL. In this case, rollback is only performed if there is a valid rollback ASDL command defined.

Rollback can be initiated for this ASDL in two cases.

• The work order fails and rollback is configured on one or more CSDLs on the work order. In this case, if configured, this ASDL is rolled back.

• When a cancellation is received on the work order. If this ASDL has been completed and rollback is configured, the SARM initiates rollback for this ASDL.

route_flag

char

1

0

Routing of the ASDL. Possible value is:

• (N) ROUTE_TO_NEP – The ASDL is routed to the NEP only.

This value is defined in the header file sarm_defs.h.

Deprecated. Column maintained for backward compatibility only.

description

varchar2

255

1

A description of the ASDL.

asdl_timeout

number

8

0

The maximum number of seconds for an ASDL timeout. If there is no response in the given timeout value, the ASDL will timeout. For more information, see the ASAP System Administrator's Guide.

asdl_retry_number

number

8

0

The maximum number of retries if an ASDL requests timeout. If the number of retries exceeds asdl_retry_number, the order is failed and rolled back. For more information, see the ASAP System Administrator's Guide.

asdl_retry_interval

number

8

0

The time period in seconds between ASDL retries. For more information, see the ASAP System Administrator's Guide.

srq_id

number

38

0

The service request ID uniquely identifying where the ASDL belongs.

asdl_stat

number

1

0

Status of the ASDL.

If defined, this field is updated while processing the ASDL and its rollback ASDL.

Possible values include:

• ASDL_NEP_COMPLETE 10

• ASDL_NEP_FAIL 11

• ASDL_NEP_RBACK_COMP 12

• ASDL_NEP_RBACK_FAIL 13

• ASDL_INITIAL 14

• ASDL_NEP_FAIL_CONTINUE 17

• ASDL_NEP_FAIL_DELAYED 20

These values are defined in sarm_defs.h.

asdl_unid

number

38

0

A unique ID identifying the ASDL log entry. This is a unique identifier and is assigned sequentially starting at the value1.

csdl_seq_no

number

38

0

The sequence number uniquely identifying the CSDL on the SRQ that generated this ASDL.

asdl_option

varchar2

255

1

Reserved.

asdl_cmd

varchar2

80

0

The ASDL command.

rollback_asdl

varchar2

80

1

If rollback is required on this ASDL, use this command to roll back the original ASDL. It is set by the SARM once the rollback is completed as a history record.

This field is NULL unless rollback of this ASDL is performed.

comp_dts

date

-

1

The completion date and time of the ASDL processing.

rollback_dts

date

-

1

The date and time of the ASDL rollback.

host_clli

varchar2

80

0

The Host NE to which the ASDL is routed by the SARM.

queue_dts

date

-

1

The date and time when the ASDL was placed in the SARM provisioning queue.

start_dts

date

-

1

The date and time when provisioning starts for this ASDL.

The difference between this value and the queue_dts represents the time the ASDL spent in the queue of pending ASDLs before being transmitted to the NEP for provisioning.

retry_count

number

38

1

A count of the number of times the ASDL was retried at the NE.

asdl_cmd

varchar2

80

0

The ASDL command.

parm_seq_no

number

38

0

The sequence number of the ASDL parameter within the parameter list.

asdl_lbl

varchar2

80

0

The ASDL label used in transmitting the ASDL parameter name value pairs to the NEP for interpretation by the NE State Tables or Java methods.

csdl_lbl

varchar2

80

0

The CSDL or global work order parameter label, which is transmitted to the SARM by the SRP or returned by the NEP State Tables or Java methods as a return CSDL global parameter.

For an indexed or compound parameter, the CSDL command defined in this table is not exactly the same as the label transmitted by the SRP. This table stores the CSDL's base name.

default_vlu

varchar2

255

1

In the case when the CSDL parameter is not passed to the SARM, the SARM substitutes the default value for the csdl_lbl. This default parameter value is referenced only for Scalar parameters.

param_typ

char

1

0

There are three ASDL parameter formats:

• SCALAR – Specifies the parameter label transmitted on the ASDL command.

• COMPOUND – Specifies the base name of the Compound parameter transmitted on the ASDL command.

• INDEXED – Specifies the base name of the ASDL command transmitted on the ASDL command.

ASDL parameters can be either required or optional. Consequently, the possible parameter type values include:

• R – required scalar parameter.

• O – optional scalar parameter.

• C – required compound parameter. This parameter type is also used for compound indexed parameters. For more information, see the ASAP Cartridge Development Guide.

• N – optional compound parameter.

• M – mandatory indexed parameter.

• I – optional indexed parameter.

• X – required XML parameter.

• Y – optional XML parameter.

• P – required XPATH parameter.

• Q – optional XPATH parameter.

• S – Parameter count. This value gives the State Table or Java method the total number of parameters associated with this ASDL command.

• + – Current index value for this ASDL. Only applicable to indexed ASDLs.

For more information about XML and XPATH parameters, see ASAP Cartridge Development Guide.

dep_asdl_lbl

varchar2

80

0

An ASDL parameter that identifies the XML document that the XPATH is evaluated against. Applies only to parameter types P and Q.

asdl

varchar2

80

0

The ASDL for which loopback processing is provided.

parm_option

varchar2

80

0

Reserved for future use.

exit_status

varchar2

20

0

The exit status returned to the Interpreter from the simulation. The possible values include:

• MAINT – Simulates the NE having gone into Maintenance mode and allows testing of the conditions.

• FAIL – Simulates a hard error from the State Table.

• SUCCEED – Default successful State Table execution.

• STOP – Stops a work order after the execution of a state table or script is complete.

asdl_status

varchar2

20

1

The ASDL status returned to the SARM.

This column is only used when exit_status is FAIL. The possible values include:

• RETRY – The ASDL is retried by the SARM. You can configure both the retry period and number of retries within the SARM using the configuration variables (NUM_TIMES_RETRY and RETRY_TIME_INTERVAL).

• CONT or SOFT_FAIL – The ASDL fails but provisioning continues, for example, attempting to remove a service that is not present.

• DELAYED_FAIL – The ASDL fails but provisioning on the rest of the order continues, at the end of which the order will fail.

• FAIL – The ASDL fails and all provisioning on this work order ceases, for example, an unrecoverable error occurred.

• STOP – Stops a work order after the execution of a state table or script is complete.

Refer to the ASAP Cartridge Development Guide for more detailed descriptions of these base_types.

asdl_time

number

38

0

The time interval, in seconds, that the Interpreter waits before returning a response to the invoking server.

This interval is used to simulate a delay in the processing of the NE responses to mimic usual run-time conditions.

error_text

varchar2

255

1

An error text description sent back to the SARM detailing the cause of the error.

Error text can be viewed by the front-end user interface. If it is not explicitly specified, generic descriptive text is supplied.

wo_id

varchar2

80

0

The ID of the work order property.

name

varchar2

80

0

The name of the work order property.

value

varchar2

255

1

The value given to the work order property.

host_clli

varchar2

80

0

The Host NE that is blacked out.

dayname

varchar2

10

1

If this field contains the valid name of a day of the week (for example, Sunday or Monday) then the date portions of start_tm and end_tm are ignored. If this field is empty than both the date and time portions from start_tm and end_tm will be used. If this field contains an invalid value, the blackout will not occur.

start_tm

date

-

0

The start date and time for the blackout interval.

end_tm

date

-

0

The end date and time for the blackout interval.

description

varchar2

255

1

A description of the NE blackout reason.

mach_clli

varchar2

80

0

Remote NE.

host_clli

varchar2

80

0

Host NE to which the Remote NE is connected.

asdl_cmd

varchar2

80

1

The ASDL command for which this routing definition is valid. This is useful for services that require ASDL-dependent routing.

dev_type

char

1

0

The device line type. The possible values include:

• D – Serial Port Dialup

• F – TCP/IP FTP Connection

• G – Generic Terminal Based Connection

• H – Serial Port Hardwired

• M – Generic Message Based Connection

• P – SNMP Connection

• S – TCP/IP Socket Connection

• T – TCP/IP Telnet Connection

• W – LDAP Connection

host

varchar2

80

0

The Host NE for which this parameter value applies. If specifying communication parameters for all Host NEs, set this parameter to COMMON_HOST (COMMON_HOST_CFG).

device

varchar2

40

0

The device for which this parameter value applies. If specifying communication parameters for all devices, set this parameter to COMMON_DEVICE (COMMON_DEVICE_CFG).

param_label

varchar2

80

0

The parameter label. There are many communication parameters that you must specify in this table in order for the ASAP communication library to function correctly.

These communication parameters and their usage are detailed in the ASAP System Administrator's Guide.

param_value

varchar2

255

0

The parameter value.

param_desc

varchar2

255

1

Description of the communication parameter.

cp_device

varchar2

40

0

A logical device used in the communications between a command processor thread and a multiplexing device. This device must be first configured in the table tbl_resource_pool.

mux

varchar2

40

0

The name of the multiplexing device that the specified command processor logical device maps to. The multiplexing device must be first configured in the table tbl_nep_mux.

csdl_cmd

varchar2

80

0

CSDL command that translates into one or more ASDL commands.

asdl_seq_no

number

38

0

The sequence number of the ASDL command associated with the CSDL. This enables one CSDL to generate more than one ASDL command.

asdl_cmd

varchar2

80

0

ASDL command to which the CSDL translates.

pnr

number

38

1

Values are:

• 0 (default) – This ASDL is not the 'point of no return' for rollback purposes

• 1 – This ASDL is the 'point of no return' for partial rollback. If rollback occurs, and execution has continued beyond this point, roll back to this ASDL but no further.

• 2 – 'point of no return' for no rollback. Once past this ASDL, no rollback can occur.

csdl_cmd

varchar2

80

0

Foreign key to tbl_csdl_asdl.csdl_cmd.

asdl_seq_no

varchar2

80

0

The sequence number of the ASDL command associated with the CSDL. This enables one CSDL to generate more than one ASDL command.

cond_flag

char

1

0

The conditions to be met for the ASDL to be executed for the CSDL. The values for this field are as follows:

• A – Always execute the ASDL for this CSDL when the expression is NULL (no expression), when the expression contains the string TRUE, or when the expression is evaluated to be true.

• E – Check for the associated label to be present for the CSDL parameter label/value pairs and check that its value is equal to the label value. Similar to "=" or LIKE in the algebraic expression.

• D – Check that the label is defined. Similar to ISDEF operations in the algebraic expression.

• N – Check that the label is not defined. Checks that the label is similar to NOTDEF.

The condition is checked for each ASDL associated with the CSDL. If the condition is satisfied, the ASDL is added to the list of ASDLs for the CSDL. If not, the ASDL is not executed.

Validation is performed in the parameter validation stage in referencing the table tbl_asdl_parm.

label

varchar2

80

1

The parameter label to test in the condition flag.

value

varchar2

255

1

The parameter value associated with the label which is tested in the condition flag.

eval_exp

varchar2

255

1

Contains combination of parameter names, operators, and values to which the parameters are compared.

apply_from

number

38

1

The first indexed ASDL that this rule should apply to:

Valid range is from 1 to 9999. Must be less than or equal to the value specified in column apply_to.

If is not specified, then this rule will be applied to any indexed ASDL up to and including the one specified in column apply_to.

apply_to

number

38

1

The last indexed ASDL that this rule should apply to:

Valid range is from 1 to 9999. Must be greater than or equal to the value specified in column apply_from.

If is not specified, then this rule will be applied to any indexed ASDL starting from the one specified in column apply_from.

csdl_cmd

varchar2

80

0

The CSDL command.

rollback_req

char

1

0

A flag indicating if rollback is required for this CSDL.

In certain circumstances, it may be preferable for no rollback to occur.

If any of the CSDLs on a work order require rollback, the dynamic work order structure in SARM's memory is flagged and the entire work order is rolled back if any CSDL fails. Possible values are:

• Y – Rollback required.

• N – No rollback required.

In the SRP database, wo_rback must be set to Y or D for the CSDL to rollback.

csdl_level

smallint

1

0

The level of the CSDL in the SRQ. An integer between 0 and 255 that indicates the sequence level for the CSDL command within the work order. The SARM uses this integer to determine the order in which to provision CSDL commands from an SRP. The SARM then provisions CSDL commands that have lower level numbers first. Sequence levels are only relevant for inter-dependent CSDL commands

As the SARM receives the CSDLs from the SRP, it reorders them in a sequence that corresponds to their respective CSDL levels to ensure the correct provisioning sequence. This reordered sequence may not be the same as the sequence in which the SRP transmitted the CSDLs to the SARM.

The field csdl_id in the table tbl_srq_csdl contains the SRP CSDL sequence of the CSDLs transmitted to the SARM.

fail_event

varchar2

8

1

If set, the system event to be triggered upon CSDL failure.

This event can log or print error messages, trigger system alarms, etc. Use this column to immediately notify personnel of CSDL failure.

complete_event

varchar2

8

1

If set, the system event triggered upon CSDL completion.

option_asdl

number

38

0

Reserved for future use.

description

varchar2

255

1

Description of the CSDL command. This description field is displayed in front-end user interfaces only.

host_clli

varchar2

80

0

The Host NE.

asdl_cmd

varchar2

80

0

The ASDL commands to be used to track consecutive hard errors.

threshold

number

38

0

The threshold number of consecutive hard errors that must occur for the SARM to disable the specified Host NE.

template_name

varchar2

20

0

The name of the event template dataset. This is a unique user-defined identifier for a distinct return parameter dataset.

parameter_type

varchar2

20

0

Identifies the type of the parameter to be added to the event template dataset:

• GLOBAL_PARAMETER

• CSDL_PARAMETER

• INFO_PARAM

• EXTENDED_PROPERTY

csdl

varchar2

80

1

The CSDL to apply the event template dataset to. The csdl parameter is only required if the parameter_type is CSDL_PARAMETER or INFO_PARAM:

parameter_name

varchar2

20

0

Name of the parameter to be added to the event template dataset.

name

varchar2

20

0

The name of the event template. Points to a set of return parameters in tbl_event_dataset thus allowing for the case where multiple trigger criteria could map to a single set of return parameters.

event_type

varchar2

20

0

(Mandatory) The event type to apply the event template name to. Following are the event types:

• Order Startup event: Returns order parameters, extended work order property.

• Order Complete event: Returns order parameters, information parameters, extended work order parameters, and service action parameters.

• Order Timeout event: Returns order parameters, information parameters, extended work order parameters, and service action parameters.

• Order Fail event: Returns order parameters, information parameters, extended work order parameters, and service action parameters.

Note: For each service action or just for the given service action, service action parameters are returned.

csdl

varchar2

80

1

The CSDL to apply the event template to. Optional.

Note: This field is applicable only when the event type is set to orderFailEvent.

name

varchar2

80

0

Name of the library

type

char

1

0

Type of the library

• S - represents Script

• Q - represents SQL

• J - represents Jar

library

blob

-

1

The binary form of the library.

host_clli

varchar2

80

0

The Host NE identifier.

tech_type

varchar2

16

0

Technology of the Host NE or SRP.

sftwr_load

varchar2

16

0

Software version of the Host NE, for example, BCS33, PAC4, or the token software load of the SRP.

The technology and software load must be consistent with the values given in the table tbl_nep_asdl_prog in order to ensure that the State Table Interpreter or JInterpreter are able to translate an ASDL.

host_clli

varchar2

80

0

The Host NE which the ASDL command is routed to.

asdl_cmd

varchar2

80

1

The ASDL command that is being routed.

id_routing_from

varchar2

255

0

The starting point of a range of ID_ROUTING.

id_routing_to

varchar2

255

0

The end point of a range of ID_ROUTING.

100

200

A-ADD_POTS_LINE

HOUSTON

100

200

A-OPTION_ON

DALLAS

10.9.1.0

10.9.10.255

A-ADD_POTS_LINE

TORONTO

10.9.11.0

10.9.18.255

A-ADD_POTS_LINE

DALLAS

wo_id

varchar2

80

0

The work order ID.

parm_lbl

varchar2

80

0

The parameter label.

parm_group

varchar2

80

1

NE parameter group information returned to the Host system.

This parameter group is set in the State Tables before the Information parameters are returned to the SARM. The SRP API routines specify parameters belonging to particular parameter groups in the Information parameter retrieval.

parm_vlu

varchar2

255

1

The value associated with the parameter label.

All control characters x0 to x1F, except x9, xA, and xD (tab, cr and nl), are stripped from the event text after it is retrieved from the database and before used in the XML document. This behavior is in compliance with XML 1.0 specification.

csdl_seq_no

number

38

0

The CSDL sequence number in the work order that is being processed when the Information parameter is generated.

csdl_cmd

varchar2

80

0

The CSDL command being processed when the Information parameter is generated from the Interpreter State Table.

csdl_id

number

38

0

The ID of the CSDL being processed when the Information parameter is generated.

This CSDL ID is the same as in table tbl_srq_csdl and enables the SRP to track which CSDL the information parameter belongs to.

vlu_hint

char

1

0

Indicates whether the parameter value is a real value or an XML document or XPath expression. Can be one of the following:

• X - indicates a reference to XML document

• P - indicates a reference to XPath expression

• T - indicates a reference to large text (reserved for future use)

key_1

varchar2

16

0

Work Order ID.

key_2

number

-

1

Event type. Possible values are defined oca.idls as follows:

• (1) ASC_WO_COMPLETE_EVT

• (2) ASC_WO_FAILURE_EVT

• (3) ASC_WO_COMPLETE_FAILURE_EVT

• (4) ASC_WO_OTHER_EVT

• (5) ASC_WO_ALL_EVT

• (6) ASC_WO_SOFT_ERR_EVT

• (8) ASC_WO_TIMEOUT_EVT

• (9) ASC_WO_ROLLBACK_EVT

• (10) ASC_WO_ACCEPT_EVT

• (11) ASC_WO_STARTUP_EVT

• (12) ASC_WO_ESTIMATE_EVT

• (13) ASC_NE_UNKNOWN_EVT

label

varchar2

600

0

An external system ID that is passed with the Work Order. It is not used by the SARM, but it is used by the SRP for proper routing to upstream systems.

value

varchar2

128

1

A sister external system ID that is passed with the Work Order. It is not used by the SARM, but it is used by the SRP for proper routing to upstream systems.

ref_id

number

20

0

Reference ID returned by the Database for the XML Order Data.

data

blob

-

1

Raw XML Data, XPath Expression or other large data.

lang_cd

varchar2

3

0

The language code.

This code determines the text message and format the SARM utilizes.

The language code that the SARM uses is set by the SARM configuration variable LANGUAGE_OF_MSG. The default is USA.

msg_id

number

38

0

Unique message identifier for messages referenced within the SARM.

msg_type

char

1

0

This field specifies the type of message formatting.

Possible values are:

• (D) Dynamic – The SARM performs parameter substitution into the formatted string in the message field which allows dynamic customizing of the message text.

• (S) Static – The SARM does not perform any parameter substitution; instead it uses the raw message in the next message field.

message

char

255

0

The message text. If the type field is S, this field resembles a printf() format string. If the type field is D, no parameter substitution is performed.

var_description

char

40

1

Description of the substitutable fields within the message.

wo_audit

char

1

1

The destination for this log message. Possible values are:

• ASAP_LOG_SRQ (srq_log)

• ASAP_LOG_WOA (work order audit)

• ASAP_SRQWOA (both)

• ASAP_LOG_NO (none)

host_clli

varchar2

80

0

The Host NE. This is the name of the SessionManager thread within the NEP which manages all interaction with the Host NE and all connections to it.

For dynamic routing, this is the name of the template.

nep_svr_cd

varchar2

8

0

The logical name of the NEP server that connects to the Host NE.

primary_pool

varchar2

8

1

The primary resource pool used by the NEP managing the Host NE. It determines the primary devices used to connect to the Host NE. The primary pool is dedicated to a specific NE.

The Host NE Session Manager within the NEP uses entries in this primary pool before attempting to use entries in the NEP's secondary resource pool to connect to this Host NE, as defined in tbl_nep.

max_connections

number

2

0

The maximum number of concurrent connections allowed to the Host NE. This includes connections from both primary and secondary pools.

For multiple dedicated Command Processors to a Host NE, configure the spawn threshold to 1 and the kill threshold to 0. This ensures that multiple Command Processors are used.

For dynamic routing, this information can be provided on each order.

drop_timeout

number

2

0

The maximum provisioning activity idle time, in minutes, that must elapse before the Session Manager managing the Host NE disconnects the primary connection to the NE.

Until this threshold is exceeded, the Session Manager managing the NE maintains a dedicated Command Processor with a dedicated connection to the NE when there are no pending ASDL requests (maximum idle time).

This time-out interval only applies to the primary connection to the NE, as all auxiliary connections have reached their kill_threshold by this point.

For a busy Host NE, this time interval should be set high as there is a high probability of an incoming ASDL for the Host NE in that period. However, this value should be set low for a less active Host NE as the resource pool device in use by the Command Processor may be required by another Session Manager to communicate with another Host NE. This is most likely the case when the device is from the NEP's resource pool (the secondary pool which is also accessible to all Session Managers).

For dynamic routing, drop timeout information can be provided on each order.

throughput

smallint

1

0

NE instance throughput control – the minimum number of milliseconds a transaction takes per NE instance. The value 0 disables NE instance thoughput control.

spawn_threshold

number

2

0

The number of ASDL requests in the SARM's “ASDL Ready Queue" destined to the NE. When this number is exceeded, the SARM requests the NEP Session Manager to open a new auxiliary connection to the NE.

As the number of ASDLs in the SARM ASDL Ready Queue continues to exceed this spawn threshold, the SARM continues to request the NEP establishment of auxiliary connections to the NE.

For example, the spawn threshold to a particular NE is 10. Once the ASDL Ready Queue size reaches 11, the SARM requests the NEP to establish an auxiliary connection to the NE.

If the ASDL Ready Queue size reaches 12, the SARM requests another auxiliary connection be established by the NEP, and so on.

This spawn threshold value should always be above the kill threshold if multiple connections are required to a particular NE.

For dynamic routing, spawn threshold information can be provided on each order.

kill_threshold

number

2

0

Upon receiving an ASDL completion, the SARM determines whether the current ASDL Ready queue size is less than the kill threshold. If so, it checks whether the ASDL was completed by an auxiliary connection. If so, the SARM transmits a disconnect request to the NEP Session Manager which disconnects the auxiliary connection. If the ASDL completion was performed on the primary connection, the SARM will not issue a disconnect request.

For example, if the spawn_threshold is 10 and the kill threshold is 5, when the SARM receives an ASDL completion when its ASDL Ready queue size is 4 or less, it checks whether the ASDL completion was performed by an auxiliary connection. If so, it issues a disconnect request to the NEP Session Manager managing this NE. If the ASDL completion was not performed by an auxiliary connection, as would be the case when the spawn threshold was never exceeded, the SARM will not issue a disconnect request.

For multiple dedicated connections, set the relevant number of connections in max_connections, the spawn threshold to 1, the kill threshold to 0, and the appropriate number of devices in the primary and secondary resource pools.

For dynamic routing, kill threshold information can be provided on each order.

template_flag

Char ('Y','N')

1

0

Flag to indicate if this network element entry identifies a static NE (N) or a dynamic network element template (Y).

The default value is 'N'.

loopback_on

Char ('Y', 'N', 'G')

1

0

Y: The NE is in loopback state regardless of the LOOPBACK_ON ASAP configuration parameter.

N: The NE is not in loop back state regardless of the LOOPBACK_ON ASAP configuration parameter.

G: The NE loop back state is determined by the LOOPBACK_ON ASAP configuration parameter.

The default value is 'G'.

request_timeout

number

8

0

The maximum number of seconds for an NE request timeout. If there is no response in the given timeout value, the associated ASDL will timeout. For more information, see the ASAP System Administrator's Guide.

request_retry_number

number

8

0

The maximum number of retries, if the NE requests timeout. If the number of retries exceeds request_retry_number, the order is failed and rolled back. For more information, see the ASAP System Administrator's Guide.

request_retry_interval

number

8

0

The time period in seconds between NE retries. For more information, see the ASAP System Administrator's Guide.

event_identity

number

20

0

Unique ID of this log message in this table.

host_clli

varchar2

80

0

The Host NE identifier if an NE or the SRP name if an SRP.

event_dts

date

-

0

The time when the event was generated.

state

varchar2

80

0

The current state of the NE. Possible states are:

• Available

• Down

• Connecting

• Maintenance

• Port Failure

• Disabled

• Unknown NE State

evt_text

varchar2

255

0

Description of the event.

host_clli

varchar2

80

0

The Host NE where the ASDL is routed by the SARM.

Even though one Host NE is specified on the CSDL, different ASDLs on that CSDL can be routed to different Host NEs.

nep_svr_cd

varchar2

8

0

Name of the NEP server.

state

varchar2

80

0

The current state of the NE. Possible states are:

• Available

• Down

• Connecting

• Maintenance

• Port Failure

• Disabled

• Unknown NE State

asdl_time_est

number

38

0

Estimated time to process an ASDL.

pending_count

number

38

0

Number of ASDLs pending.

in_progress_count

number

38

0

Number of ASDLs in progress.

connect_count

number

38

0

Number of connections to the NE.

retry_count

number

38

0

The number of times the ASDL was retried at the NE.

held_count

number

38

0

Number of ASDLs held.

consec_fail_count

number

38

0

Number of consecutive failures.

connect_dts

date

-

0

Date/time stamp of the last connection.

disconnect_dts

date

-

0

Date/time stamp of the last disconnect.

avail_dts

date

-

0

Date/time stamp of the last time mode available.

maint_dts

date

-

0

Date/time stamp of the last time it was put into maintenance mode.

err_disable_dts

date

-

0

Date/time stamp of the last time an error disabled the NE.

err_enable_dts

date

-

0

Date/time stamp of the last time the NE was enabled after an error.

adm_disable_dts

date

-

0

The last time an administrator disabled the NE.

adm_enable_dts

date

-

0

The last time an administrator enabled the NE.

swd_sessions

number

38

1

Number of switch direct sessions.

swd_start_dts

date

-

1

The last time a session started.

swd_end_dts

date

-

1

The time when a switch direct session ended.

swd_user_id

varchar2

64

1

Switch direct user.

pad1

char

255

0

Padding to make a table row occupy a page. This reduces concurrence on the database data page by different database processes.

pad2

char

255

0

Same as pad1.

pad3

char

255

0

Same as pad1.

pad4

char

255

0

Same as pad1.

strsub_type

varchar2

20

0

TBD

description

varchar2

255

1

TBD

asdl

varchar2

80

1

Name of the ASDL associated with the character. If no value is provided, the substitution will be made for all ASDL commands.

csdl

varchar2

80

1

Name of the CSDL associated with the character. If no value is provided, the substitution will be made for all CSDL commands.

ne_vendor

varchar2

255

1

Name of the software vendor for the network element associated with the character. If no value is provided, the substitution will be made for all network element vendors.

tech_type

varchar2

255

1

Technology type for the network element associated with the character. If no value is provided, the substitution will be made for all technology types.

sftwr_load

varchar2

16

1

Software load for the network element associated with the character. If no value is provided, the substitution will be made for all software loads.

ne_str_pattern

varchar2

255

1

TBD

ne_replace_pattern

varchar2

255

1

TBD

nep_svr_cd

varchar2

8

0

The logical name of the NEP managing the secondary pool of devices. It is not the physical environment specific name listed in the interfaces file.

dialup_pool

varchar2

8

1

Secondary pool of devices available to all Session Managers within the NEP. If specified, you must define this resource pool in tbl_resource_pool. If null, there are no secondary devices available in the NEP.

tech

varchar2

16

0

The technology or type of the NE with which the Interpreter interacts, for example, DMS, S12, etc.

sftwr_load

varchar2

16

0

The Software Load of the software currently running on the NE.

Since this field is non-null, you must place a value in the field even if there is no defined software load for this NE type.

The table tbl_host_clli also adheres to the same convention for the software load value.

asdl_cmd

varchar2

80

0

The ASDL command passed to the Interpreter that determines the Interpreter State Table program to be loaded and executed, or passed to the JInterpreter that determines the Java program to be executed. ASAP reserves some special ASDL commands to map special requirements, such as LOGIN or CONNECTION_HANDLER, to a program.

program

varchar2

255

0

Name of the Interpreter State Table program in tbl_nep_program to load and execute, or name of the Java connection class or Java provisioning method for JInterpreter to execute.

State Tables within the NEP execute and receive the MML commands and responses. The State Tables within the SRP generally assist with the SRP work order translation process.

interpreter_type

varchar2 ['S','J']

1

0

A value of “S" indicates a State Table interpreter, whereas a value of “J" indicates a JInterpreter. A null value defaults to “S".

mux

varchar2

40

0

The name of the multiplexing device. Communication parameters for this device are specified in tbl_comm_param.

host_clli

varchar2

80

0

The NE that the multiplexing device communicates with. You must first configure the NE in tbl_ne_config.

mux_dev_type

char

1

0

The type of communications protocol or interface used in the interactions between the multiplexing device type and the NE.

cp_dev_type

char

1

0

The type of communications protocol used in the interactions between the multiplexing device type and the command processor threads.

program

varchar

255

0

Name of the java class in the form package.class name.

jclass

blob

The binary form of the java class.

program

varchar2

255

0

The name of the State Table Program. With this program the ASDL, Technology, and Software load map in the tbl_nep_asdl_prog static database table.

line_no

number

38

0

The line number in the State Table program which acts as a label for that instruction. The line number is similar to the ones used in BASIC programs.

action

varchar2

32

0

An action string to identify the particular action performed by the Interpreter in the Command Processor.

A number of State Table actions are provided by various ASAP component libraries, for example, Interpreter, NEP, SRP, etc. You can add action functions and overwrite existing action functions as required.

act_string

varchar2

255

1

The action string associated with the State Table action. This field is required depending on the specified State Table action.

act_int

number

38

1

The action integer which, if set, represents the next line number in the State Table program. The next line number is where execution of the State Table should continue or there is a numeric field specific to the particular action function. If the action integer points to an invalid line number or is absent from the State Table program, the Interpreter registers a run time error and fails the operation.

This field is required depending on the specified State Table action.

program

varchar2

255

0

The name of the State Table program. With this program the ASDL, Technology, and Software load, map in the tbl_nep_asdl_prog static database table.

line_no

number

38

0

The line number in the State Table program which acts as a label for that instruction. The line number is similar to the ones used in BASIC programs.

seq

number

38

0

Order of the source code.

source

varchar2

255

1

Line of the State Table source code.

asdl_cmd

varchar2

80

0

The ASDL command that provides ASDL specific routing capabilities by telephone number. This is important for such services as Voice Mail which is routed to separate NEs based on the ASDL.

npa

varchar2

3

0

The NPA is the first three digits in a telephone number.

nxx

varchar2

3

0

The NXX is the second three digits in a telephone number.

from_line

varchar2

4

0

The starting point of a range of telephone LINE numbers. It is the remaining four numbers in a telephone number which provide routing.

to_line

varchar2

4

0

The end point of a range of telephone LINE numbers to provide routing.

cont_typ

varchar2

1

0

Reserved for future use.

cont_nm

varchar2

8

0

Reserved for future use.

queue_nm

varchar2

64

0

The Host NE to which this ASDL is routed. The SARM determines the NEP managing this Host NE and routes the ASDL appropriately.

translation_name

varchar2

255

0

Name of the Translation Object.

query_type

varchar2

80

0

Type of the Query.

type

char

1

0

Type of the object.

• J - JMS

• X - XPATH

parm

varchar2

255

1

Name of the parameter.

value

varchar2

255

1

Value for the parameter.

name

varchar2

255

0

A unique name given to the translation script as an identifier.

script_name

varchar2

255

1

Name of the script file that implements translation.

translation_type

varchar2

255

0

Type of Translation to be executed. Possible values are XSLT and DO_NOT_FORWARD.

type

char

1

0

Type of the translation object

parm

varchar2

255

1

Name of the parameter

value

varchar2

255

1

Value of the parameter

message_direction

varchar2

80

1

Translation Direction which indicates the whether this translation is for incoming orders, responses or events. Possible values are UPSTREAM, EVENT and RESPONSE.

script

BLOB

-

1

Binary form of the library/script.

asap_sys

varchar2

8

0

This is the environment in which this database record is to be used. As the ASAP databases are environment independent, only logical representations of physical entities exist within them.

• tbl_resource_pool – The table that contains specific environment-dependent information that varies between environments.

• asap_sys – Distinguishes different environments. It takes the value of the environment variable, ASAP_SYS, TEST, PROD, etc., in the current environment.

At run time, only those records with this field defined to be the same as the environment variable asap_sys, are loaded by the NEP.

pool

varchar2

8

0

The name of the pool of devices. It is referenced by:

• tbl_nep – The secondary resource pool of the entire NEP.

• tbl_ne_config – The primary resource pool of the NE.

device

varchar2

40

0

The device name. This is the name of the logical device used to establish a connection to an NE. The device corresponding to this logical device is specified by means of the communications parameter table, tbl_comm_param.

line_type

char

1

0

The communication protocol used by this device. The possible values include:

• C – CORBA

• D – Serial Port Dialup

• F – TCP/IP FTP Connection

• G – Generic Terminal Based Connection

• H – Serial Port Hardwired

• M – Generic Message Based Connection

• P – SNMP Connection

• S – TCP/IP Socket Connection

• T – TCP/IP Telnet Connection

• W – LDAP Connection

This is enforced by the associated data rule on the datatype.

For the X.25 protocol, you can use both G and M. For the X.29, you can only use G because the X.29 does not support message-based type.

Such definitions are defined in the header file nep_core.h.

vs_key

number

38

-

Reserved. The shared memory segment identifier for the Virtual Screen buffer.

srq_id

number

38

0

SRQ unique ID.

srq_dd

date

-

0

Due date and time of this SRQ. This is the same as the sched_dts in the work order table.

grp_cd

char

1

0

The action of the SRQ. Possible values include:

• A – ADD: addition of service.

• R – REMOVE: removal of service.

• C – CHANGE: change/update of existing service.

• Q – QUERY: query existing service.

This action field is important to the order in which SRQs are processed within the same work order and between work orders.

These values are defined in asap_core.h.

srq_pri

char

1

0

Priority of this SRQ as assigned by the Host order system.

It is equal to the work order priority. Possible values include:

• (1) ASAP_SRQ_HIGH_PRIO – High priority SRQ.

• (5) ASAP_SRQ_NORMAL_PRIO – Normal priority SRQ.

• (9) ASAP_SRQ_LOW_PRIO – Low priority SRQ.

These values are defined in asap_core.h.

This priority field is the first field in the internal composite ASAP SRQ priority within the ASAP core followed by the SRQ due date and the SRQ action such as Remove, Change, or Add.

srq_stat

number

38

0

SRQ status that is updated while the SRQ is being processed by the SARM. Possible values include:

• (0) HELD – SRQ is held awaiting manual intervention.

• (1) INITIAL – SRQ is yet to begin provisioning.

• (2) SRQ_ABORTED – SRQ has been aborted due to order update or cancel.

• (3) NEP_UNAVAIL – NEP routing for the SRQ's current ASDL is temporarily unavailable.

• (7) IN_PROCESSING – SRQ in process.

• (12) COMPLETED – SRQ successfully completed. It may have exceptions and/or revisions.

• (13) FAILED – SRQ failed. See the SRQ log details to determine the cause of failure.

• (14) TRANSLATION_ERROR – The SRP could not translate the SRQ correctly but transmitted it to the SARM.

• (15) SRQ_ROLLBACK – SRQ has been rolled back.

• (16) REVIEW – SRQ is in Reviewed status.

• (60) CMD_RETRY – An ASDL on this SRQ is currently in the ASDL Retry queue. The SARM waits for a configured period or number of retries.

These definitions are defined in sarm_defs.h.

evt_dt_tm

date

-

0

Last date and time that this SRQ record was updated.

wo_id

varchar2

80

0

The ID of the work order that this SRQ belongs to.

srq_chg

char

1

1

Indicates whether the SRQ has been altered since being received by ASAP. Possible values include:

• N – No revisions on the SRQ.

• Y – Revisions in ASAP not to be reflected back to the Host System.

• C – Revisions in ASAP to be reflected back to the Host System.

proc_typ

char

1

1

Type of processing required for this SRQ. Possible values include:

• (I) IMMEDIATE – Immediate requests to be provisioned as they are received.

• (D) DELAYED – Delayed or batch requests due in the future.

Batch requests have lower priority than immediate requests. Values are defined in sarm_defs.h.

cur_csdl_seq_no

number

38

1

The sequence number of the current CSDL being processed within this SRQ.

This serves as a pointer into the CSDL table which enables the SARM to determine which CSDL it had been processing. This is used by the SARM upon restarting an In Progress work order.

cur_csdl_st

number

38

1

The status of the current CSDL being processed within this SRQ.

This field and the sequence number are updated by the SARM as the SRQ is being processed.

Possible values of this field are detailed in the csdl_st field of the tbl_srq_csdl table.

host_clli

varchar2

80

1

The Host NE associated with the latest ASDL on the SRQ. This is updated by the SARM to the value of the current ASDL Host NE value.

There may be multiple Host NEs associated with a CSDL since each ASDL may be routed to a different Host NE.

srq_id

number

38

0

The SRQ ID that the parameter name value pairs are associated.

unid

number

38

0

If the ASDL type is ROLLBACK_TYPE, (according to tbl_asdl_log) then this field is set to the value of the ASDL unique ID (asdl_unid) in the ASDL log table (tbl_asdl_log). This allows the ASDL log table to determine the rollback parameters associated with a particular ASDL.

These parameter types are defined in the header file sarm_defs.h.

parm_lbl

varchar2

80

0

The parameter label, for example, LEN, or DN.

parm_vlu

varchar2

255

1

The parameter value associated with the parameter label.

vlu_hint

char

1

0

Indicates whether the parameter value is a real value or an XML document or XPath expression. Can be one of the following:

• X - indicates a reference to XML document

• P - indicates a reference to XPath expression

• T - indicates a reference to large text (reserved for future use)

srq_id

number

38

0

Unique ID of the SRQ that is associated with the CSDL.

csdl_seq_no

number

38

0

Sequence number that distinguishes CSDLs within the SRQ.

actn_noun_lbl

varchar2

80

0

CSDL command.

csdl_st

number

38

0

Status of the CSDL. Possible values include:

• (100) HELD_STATE – The CSDL is Held awaiting manual release within ASAP.

• (101) INITIAL_STATE – The CSDL is yet to begin processing.

• (102) FAILED_CSDL – The CSDL has failed.

• (103) ABORTED_CSDL – The CSDL has been aborted (usually by an OCA user).

• (104) COMPLETED_CSDL – The CSDL has completed successfully.

• (106) ROLLBACK_COMPLETED_CSDL – The CSDL has been successfully rolled back.

CSDL status values are defined in sarm_defs.h.

asdl_seq_no

number

38

0

The sequence number of the ASDL currently being processed by the SARM on the CSDL.

It is updated dynamically by the SARM as the ASDLs are processed. The SARM uses this field to determine the current ASDL to be provisioned upon restart.

index_parm_cnt

number

38

0

Current index value in Indexed ASDL parameters.

This field is dynamically updated by the SARM as it provisions an ASDL with a set of Indexed parameters.

When the SARM restarts an In Progress order, it uses the value in this field to determine the relevant set of Indexed ASDL parameters to transmit with this ASDL. Use the getParam method to retrieve the value of the given input parameter as passed down to the JInterpreter by the SARM. Use the getIntParam method to retrieve the value of the given input parameter as passed down to the JInterpreter by the SARM and casts this value to an integer.

Refer to the ASAP Online Reference for more information.

csdl_id

number

38

0

The CSDL ID in the SRP transmitted to the SARM.

When the SRP transmits a CSDL to the SARM, it passes this CSDL ID which SARM stores in the field.

With this, the SARM generates the csdl_seq_no field value once it receives all CSDLs from the SRP and orders them according to their respective levels.

This field is maintained by the SARM so that the SRP can query the SARM for CSDL specific information. It is used by the SRP to correlate the CSDL in the SRP with the CSDL in the SARM.

asdl_route

char

1

0

Specifies the routing of the current ASDL on the CSDL. The CSDL is mapped to one or more ASDLs by the table tbl_csdl_asdl.

Once the SARM acknowledges the ASDL, it looks up the appropriate entry in the tbl_asdl_config to determine the routing for this ASDL.

Possible values include:

• (?) TO_BE_DETERMINED – The SARM has not yet determined the routing of the first ASDL on this CSDL.

• (N) ROUTE_TO_NEP – ASDL routed to the NEP.

This value is defined in the header file sarm_defs.h.

csdl_type

char

1

1

The type of CSDL.

orig_seq_no

number

38

1

The original sequence number of the CSDL on the SRQ.

estimate

number

38

1

The time estimate to provision the CSDL.

start_dts

date

-

1

The date and time that the CSDL started provisioning.

abort_dts

date

-

1

The date and time that the CSDL was aborted.

failure_dts

date

-

1

The date and time that the CSDL failed provisioning.

comp_dts

date

-

1

The date and time that the CSDL completed provisioning.

update_dts

date

-

1

The date and time that the CSDL was last updated.

update_uid

varchar2

64

1

The user who last updated the CSDL.

prov_sequence

number

38

1

The provisioning sequence of the CSDL on the SRQ. You can specify an alternate provisioning sequence to the one originally received from the originating system.

srq_id

number

38

0

ID of the Service Request.

srq_log_identity

number

20

0

Unique ID of the log message in this table. This is an identity field automatically generated by the RDBMS upon insertion. This replaces the earlier field for performance reasons.

evt_dt_tm

date

-

0

Date and time of the logged event.

csdl_seq_no

number

38

0

Sequence number of the CSDL within the SRQ that the event is associated with.

This is the same as the csdl_seq_no field in the CSDL table.

srq_stat

number

38

0

Status of the SRQ at the time the event occurred.

For possible values, see srq_stat in tbl_srq, "tbl_srq."

csdl_st

number

38

0

Status of the CSDL when the event occurred.

For possible values, see csdl_st in tbl_srq_csdl, "tbl_srq_csdl."

srq_evt

varchar2

8

0

The SRQ Log Event.

The SRP may inquire for the SRQ log by specifying particular SRQ events of interest in the inquiry RPCs. Possible values include:

• SRQ_INFO_EVENT "INFO" – Information messages.

• SRQ_ERROR_EVENT "ERROR" – Error messages.

• NE_CMD_EVENT "NE_CMD" – Command entered to the NE.

• NE_RESP_EVENT "NE_RESP" – Response from the NE.

These values are defined in the header file sarm_defs.h.

You must set WO_AUDIT_LEVEL in ASAP.cfg to 2 to generate SRQ_ERROR_EVENTS.

evt_text

varchar2

255

1

Text description of the event.

For NE responses, it contains 255 characters at a time (including newline characters) from the NE generated report. This should be considered when the information is being displayed by a front-end user interface.

This allows each log record to contain more NE response information than if one NE response record was contained in each SRQ log record.

If generated by an application, this text describes the event as displayed to you.

All control characters x0 to x1F, except x9, xA, and xD (tab, cr and nl), are stripped from the event text after it is retrieved from the database and before used in the XML document. This behavior is in compliance with XML 1.0 specification.

asdl_unid

number

38

1

The ID of the ASDL that generated the log entry. If there is no current ASDL for the log entry, set this field to null.

srq_id

number

38

0

The SRQ ID that is associated with the parameter name value pairs.

parm_typ

char

1

0

The type of SRQ parameter. Possible values include:

• (P) GLOBAL_TYPE – Parameters are set by one CSDL in an SRQ and referenced by others (they are global within the SRQ).

• (C) CSDL_TYPE – Parameters are local to the current CSDL being processed within the SRQ. They are referenced by other ASDLs within the same CSDL.

These parameter types are defined in the header file sarm_defs.h.

unid

number

38

0

If the parameter type is CSDL_TYPE, this field equals the CSDL sequence number (csdl_seq_no) in the CSDL tbl_srq_csdl. This field is not used if the parameter type is GLOBAL_TYPE.

parm_lbl

varchar2

80

0

The parameter label, for example, LEN or DN.

parm_vlu

varchar2

255

1

The parameter value associated with the parameter label.

parm_subvlu

varchar2

80

1

Contains the first 32 bytes of the global or CSDL parameter value.

vlu_hint

char

1

0

Indicates whether the parameter value is a real value or an XML document or XPath expression. Can be one of the following:

• X - indicates a reference to XML document

• P - indicates a reference to XPath expression

• T - indicates a reference to large text (reserved for future use)

service_id

varchar2

80

0

Service Identifier.

description

varchar2

1024

1

Description of the bundle or service action.

spawn_parm

varchar2

255

1

Name of the spawning parameter on the order that will cause this service bundle or service action to be added to the order if it has the correct value

spawn_value

varchar2

255

1

Value of the spawning parameter that will cause the service bundle or service action to be added to the order.

service_type

char

1

0

The service_type field indicates whether the table entry is a service bundle or a service action.

• B – Service bundle

• C – Service action

service_id

varchar2

80

0

Service Identifier.

csdl_cmd

varchar2

80

0

Name of the CSDL.

csdl_seq_no

number

20

0

Sequence number of the CSDL.

cond_flag

char

1

0

Conditional flag for the CSDL. Possible values are:

• A - ALWAYS

• E - EQUALS

• D - DEFINED

• N - NOT_DEFINED

label

varchar2

80

1

The parameter label.

value

varchar2

255

1

Value of the parameter.

eval_exp

varchar2

255

1

Contains combination of parameter names, operators, and values to which the parameters are compared.

inc_ord_resp

char

1

1

Identifies whether order data need to be included in the response or not.

• Y – Yes

• N – No

description

varchar2

1024

1

Description of the service bundle or service action.

load_dts

date

-

0

Date and time at which the SRT configuration was reloaded.

correlation_id

varchar2

80

0

SRT Correlation identifier

asap_id

varchar2

80

0

ASAP Work Order identifier

service_id

varchar2

80

0

Service Identifier.

csdl_cmd

varchar2

80

0

The CSDL command.

csdl_seq_no

number

20

0

Sequence number of the CSDL.

parm_seq_no

number

20

0

Sequence number of the parameter.

bundle_label

varchar2

80

0

The upstream label used in transmitting the parameters for provisioning.

csdl_label

varchar2

80

0

The CSDL label used in transmitting the parameters for provisioning.

default value

varchar2

255

1

Default Value.

parm_type

char

1

0

Type of the parameter. Possible values include:

• R - Required Scalar

• O - Optional Scalar

• C - Required Compound

• N - Optional Compound

• M - Required Indexed

• I - Optional Indexed

asap_id

varchar2

80

0

ASAP identifier.

name

varchar2

1024

0

Name of the parameter.

value

varchar2

1024

0

Value of the parameter.

type

varchar2

1024

0

Type of the parameter.

xpath_name

varchar2

1024

0

xpath to generate a name.

xpath_value

varchar2

1024

0

xpath to generate a value

name

varchar2

255

0

Name of the lookup.

type

varchar2

128

0

Type of the lookup.

cache_scope

varchar2

32

1

Scope of the lookup. Scope can be either: NONE, NODE or SYSTEM.

cache_timeout

varchar2

20

1

The amount of time in milliseconds to cache a value if the scope is SYSTEM.

cache_max_size

number

20

1

The maximum number of entries to cache if the scope is SYSTEM. Once MaxSize is reached, least recently used values will be dropped.

lookup_name

varchar2

255

0

Name of the lookup

parm_name

varchar2

255

0

Name of the input parameter

parm_type

char

1

0

Type of the parameter. Possible values are:

• V - represents Adapter Properties Value

• L - represents Lookup

parm_value

varchar2

255

0

Value of the parameter associated with the parameter name. If parm_type is L then parm_value contains an XPath, otherwise parm_value contains an instance string value.