5.3.1.1 Creating Jurisdiction in the Database through Scripts
You can create jurisdiction in the database using the following steps:
- 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). - 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.