Loading Jurisdictions
(Required) <Enter a short description here.>
To load jurisdictions in the database, follow these steps:
- Add the appropriate record to the KDD_JRSDCN database table as mentioned in the
following table.
Table 8-3 Loading Jurisdictions
Column Name Description JRSDCN_CD Code (one to four characters) that represents a jurisdiction such as N for North, or S for South. JRSDCN_NM Name of the jurisdiction such as North or South. JRSDCN_DSPLY_NM Display name of the jurisdiction such as North or South. JRSDCN_DESC_TX Description of the jurisdiction such as Northern US or Southern US. - Add records to the table 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')
The KDD_JRSDCN table is empty after system initialization and needs to be populated before the system can operate.