Siebel Repository tables
Siebel Repository refers to set of tables in which Siebel object definition and scripts are stored. These tables store meta data about Siebel Objects and also contain the configuration information shown in Siebel Tools
S_APPLET : Stores Siebel Applets information
S_BUSCOMP : Stores Siebel Business Component Information
S_FIELD : Stores all the Field details
Situation: Generate a report with all the active BC Fields and their corresponding Table/Column/Data Type/Length. Doing this manually in Siebel Tools is a monotonous and tedious task and it will take lot of time to complete it.
Solution : Directly querying on the Siebel Repository tables which would yield the desired output. Please find below sample query for Account BC
SELECT FIELD.NAME"BC Field Name",FIELD.join_name "Join Name",NULL"Table_Name",field.col_name "Column Name",decode(TEMP.COLTYPE,'V','Varchar','U','UTC Date Time','D','Date','C','Char','X','Long','T',' DateTime','N','Number','L','Clob','S','Date Time')"Data TYPE",TEMP.COLLENGTH "Length"
FROM
SIEBEL.S_REPOSITORY REP,
SIEBEL.S_BUSCOMP BC,
SIEBEL.S_FIELD FIELD,
(selectdistincttab.name"TNAME",col.name"COLNAME",col.data_type "COLTYPE",col.length"COLLENGTH"from
siebel.s_table tab,
siebel.s_column col,
siebel.s_repository rep
where
tab.REPOSITORY_ID=REP.ROW_ID AND
REP.NAME='Siebel Repository' and
col.tbl_id=tab.row_id and
tab.namelike'S_%')temp
WHERE
field.col_name =temp.COLNAME(+)and
field.join_name=temp.TNAME (+)and
field.inactive_flg='N'and
field.col_name isnotnulland
FIELD.BUSCOMP_ID=BC.ROW_ID AND
BC.NAME='Account' AND
BC.REPOSITORY_ID=REP.ROW_ID AND
REP.NAME='Siebel Repository'
Note : The above SQL query is a sample one and based on individuals requirement query should be tuned to get the required data from Repository tables
