Loading Organizations

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

1. Add the appropriate record to the KDD_ORG database table as mentioned in the following table.

   Table 8-4 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	Parent organization of which this organization is considered to be a child. NOTE: This should 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. NOTE: This should reference a user in the Investigation Owner table (KDD_REVIEW_OWNER.OWNER_SEQ_ID). You can also set the value to owner_seq_id 1, which is SYSTEM, if another suitable ID is not available.
   COMMENT_TX	Additional remarks added by the user.

2. Add records to the table using an 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,COMMENT_TX)
   VALUES ('ORG1','COMPLIANCE ORG','DEPARTMENT FOR INVESTIGATION','ORG1
   PARENT ORG','01-JUN-2014',1234,'ADDING KDD_ORG ENTRIES')