4.3.2.1 Loading Jurisdictions

To load jurisdictions in the database, follow these steps:

1. Add the appropriate record to the KDD_JRSDCN database table.

   The following table shows the KDD_JRSDCN database table attributes.

   Table 4-6 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 the name of the jurisdiction (For example, North or South).
   JRSDCN_DESC_TX	Description of the jurisdiction (For example, Northern US or Southern US).

   Note:

   The data in the KDD_JRSDCN database table is loaded through the ATOMIC schema.
2. Add records to the table by using an SQL script similar to the following sample script:

   INSERT INTO KDD_JRSDCN (JRSDCN_CD, JRSDCN_NM,JRSDCN_DSPLY_NM,JRSDCN_DESC_TX)

   VALUES ('E', 'East', 'East', 'Eastern')

   Note:

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