Loading Jurisdictions

(Required) <Enter a short description here.>

To load jurisdictions in the database, follow these steps:
  1. 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.
    The data in the KDD_JRSDCN database table is loaded through the ATOMIC schema.
  2. 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.