CSV File Format for Uploading Parameters

Before uploading a parameter file through the File Upload Interface utility, you need to ensure that the CSV file contains the following columns:
Column Name Description Mandatory (Yes or No)
Parameter Used to specify the parameter name.
Note: You cannot specify any special character except underscore (_​) in the parameter name.
 Yes
Description Used to specify the description for the parameter. Yes
Value Type Used to indicate the type of value that you want to store in the parameter. The valid values are:

  • ADV - Enables you to store an adhoc value in the parameter.

  • DFV - Enables you to store a predefined value in the parameter.

  • FKV - Enables you to store a reference value in the parameter.

 Yes
Source Entity Used to indicate the entity from where the parameter value should be derived. The valid values are:

  • ACCT - Enables you to derive the parameter value from the account.

  • ALGO - Enables you to derive the parameter value from an algorithm.

  • PERS - Enables you to derive the parameter value from the person.

  • PRD - Enables you to derive the parameter value from the product.

  • SQI - Enables you to derive the parameter value from a service quantity identifier.

  • TRN - Enables you to derive the parameter value from a transaction.

 Yes
Source Type Used to indicate the type of source from where the parameter value should be derived. The valid values are:

  • CHAR - Enables you to derive the parameter value from a characteristic.

  • FLD - Enables you to derive the parameter value from a field.

  • BAL - Enables you to derive the parameter value from a usage amount.

  • CNT - Enables you to derive the parameter value from a usage counter.

Note:

You must not specify the source type when the source entity is set to ALGO, SQI, or TRN.

You must not specify the source type as BAL or CNT when the source entity is set to PRD.

 Yes
Source Type Code Used to indicate the source, such as field, characteristic, usage amount, usage counter, SQI, or algorithm, from where the parameter value should be derived.
Note:

You must not specify the source type code when the source entity is set to TRN.

You must specify the source type code depending on the following source entity and source type combination:

Source Entity Source Type Source Type Code
ACCT CHAR A characteristic type where the characteristic entity is set to Account.
ACCT FLD A field from the CI_​ACCT table.
ACCT BAL A value from the BAL_​FLG lookup field.
ACCT CNT A value from the CNT_​FLG lookup field.
PERS CHAR A characteristic type where the characteristic entity is set to Person.
PERS FLD A field from the CI_​PER table.
PERS BAL A value from the BAL_​FLG lookup field.
PERS CNT A value from the CNT_​FLG lookup field.
PRD CHAR A characteristic type where the characteristic entity is set to Product.
PRD FLD A field from the C1_​PRODUCT table.
SQI - A service quantity identifier which is already defined in the system.
Yes
Validation Algorithm Used to indicate the algorithm using which you want to validate the adhoc parameter value.
Note: You must specify a validation algorithm when the value type is set to Adhoc.
 No
Reference Entity Used to indicate the table whose primary key (column) you want to set as the reference entity. Yes (Conditional)
Note: This data is required when the value type is set to Reference.
Field Name Used to indicate the column which is the primary key of the table. The parameter value is then validated against the primary column of the table. Yes (Conditional)
Note: This data is required when the value type is set to Reference.
Predefined Parameter Values
Parameter Value Used to specify the parameter value.
Note: You can specify any special characters except ampersand (&), comma (,), underscore (_​), equal to (=), tilde (~), and semi-colon(;) in the predefined parameter value.
 Yes (Conditional)
Note: This data is required when the value type is set to Predefined.
Description Used to specify the description for the parameter value. Yes (Conditional)
Note: This data is required when the value type is set to Predefined.
Parameter Usage Information
Price Item Used to indicate whether the parameter can be associated with a price item or price item bundle. The valid values are:

  • Y

  • N

Note:

You must specify the value as N when a parameter is defined using the following source entity and source type combinations:

Source Entity Source Type
ACCT BAL
ACCT CNT
PERS BAL
PERS CNT
ALGO -
SQI -
No
Pricing Eligibility Criteria Used to indicate whether the parameter can be used while defining the pricing eligibility criteria. The valid values are:

  • Y

  • N

 No
Price List Eligibility Criteria Used to indicate whether the parameter can be used while defining the price list eligibility criteria. The valid values are:

  • Y

  • N

Note: You must specify the value as N when the source entity is set to TRN.
 No
Product Eligibility Criteria Used to indicate whether the parameter can be used while defining the product eligibility criteria. The valid values are:

  • Y

  • N

Note: You must specify the value as N when the source entity is set to ALGO, SQI, or TRN.
 No

Related Topics

For more information on... See...
How to define a parameter Defining a Parameter
Sample CSV Format for Uploading Parameters Sample CSV Format for Uploading Parameters