4.3.2.5 Loading Organizations

To load an organization in the database, follow these steps:

1. Add the appropriate user record to the KDD_ORG database table. The following table shows the KDD_ORG database table attributes.

   Table 4-10 KDD_ORG Table Attributes

   Column Name	Description
   ORG_CD	Unique identifier for this organization.
   ORG_NM	Short name for this organization that is used for display purposes.
   ORG_DESC_TX	Description of this organization.
   PRNT_ORG_CD	The parent organization of which this organization is a child. This must reference an ORG_CD in the KDD_ORG table.
   MODFY_DT	Last modified date and time for this organization record.
   MODFY_ID	User ID of the user who last modified this organization data. This must reference a user in the Investigation Owner table (KDD_REVIEW_OWNER.OWNER_SEQ_ID).
   COMMENT_TX	Additional remarks added by the user.

2. Add more records to the table by using a SQL script similar to the following sample script:

   INSERT INTO KDD_ORG (ORG_CD,ORG_NM,ORG_DESC_TX,PRNT_ORG_CD,MODFY_DT,MODFY_ID,COM MENT_TX) VALUES ('ORG1','COMPLIANCE ORG','DEPARTMENT FOR INVESTIGATION','ORG1 PARENT ORG','01-JUN-2014',1234,'ADDING