How to Populate User Keys and Required Columns using Siebel EIM

It is mandatory to load the required columns of the base tables. If one or more required fields are missed, then the EIM process will fail to load the base table and generate the REQUIRED_COLS error status. To identify which are the required columns for a base table, the following query can be used:

SELECT TBL.NAME, COL.NAME
FROM   S_COLUMN COL, S_TABLE TBL
WHERE  COL.TBL_ID=TBL.ROW_ID
AND    COL.REQUIRED='Y'
AND    TBL.NAME = <<give Base Table Name here>>;

Similarly to determine the user keys for a base table, the following query can be used:

SELECT distinct  TBL.NAME,
    COL.NAME
FROM     S_COLUMN COL,
      S_TABLE TBL
WHERE    COL.TBL_ID=TBL.ROW_ID
AND      TBL.NAME = <<give Base Table Name here>>
AND      COL.USR_KEY_SEQUENCE IS NOT NULL;

If the above query does not return any row, then that implies that the corresponding base table does not have any user key.