5.3.1.1 Creating Jurisdiction in the Database through Scripts

You can create jurisdiction in the database using the following steps:

  1. Add the appropriate record to the KDD_JRSDCN database table as per the following table.

    Table 5-4 KDD_JRSDCN Table Attributes

    Column Name Description
    JRSDCN_CD Code(one to four characters) that represents a jurisdiction (for example, N for North, or S for South).
    JRSDCN_NM Name of the jurisdiction (for example, North or South).
    JRSDCN_DSPLY_NM Display name of the jurisdiction (for example, North or South).
    JRSDCN_DESC_TX Description of the jurisdiction (for example, Northern US or Southern US).
  2. Add records to the table by using a SQL script.

    INSERT INTO KDD_JRSDCN (JRSDCN_CD, JRSDCN_NM, JRSDCN_DSPLY_NM,

The KDD_JRSDCN table is empty after system initialization and requires populating before the system can operate.