Table 12. Prepartitioned Siebel Tables with Physical Columns
Table
|
Index
|
Indexed Columns
|
Trigger Logic
|
S_ACT_EMP
|
S_ACT_EMP_P99
|
PARTITION_COLUMN, EMP_ID
|
" WHEN (N.IMP_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.EMP_ID,2);
END ¬"
|
S_ADDR_ORG
|
S_ADDR_ORG_P99
|
PARTITION_COLUMN, OU_ID
|
" WHEN (N.OU_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.OU_ID,2);
END ¬"
|
|
|
|
S_ADDR_PER
|
S_ADDR_PER_P99
|
PARTITION_COLUMN, PER_ID
|
" WHEN (N.PER_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.PER_ID,2);
END ¬"
|
|
|
|
S_APPLD_CVRG
|
S_APPLD_CVRG_P99
|
PARTITION_COLUMN, ASSET_ID
|
WHEN (N.ASSET_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.ASSET_ID,2);
END ¬"
|
S_ASSET
|
S_ASSET_P99
|
PARTITION_COLUMN, ROW_ID
|
"WHEN (N.ROW_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.ROW_ID,2);
END ¬"
S_ASSET
|
|
|
|
|
S_ASSET_CON
|
S_ASSET_CON_P99
|
PARTITION_COLUMN,ASSET_ID
|
"WHEN (N.ASSET_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.ASSET_ID,2);
END ¬"
|
|
|
|
S_ASSET_POSTN
Siebel Industry Applications (SIA) table
|
S_ASSET_POSTN_P99
|
PARTITION_COLUMN,ASSET_ID
|
"WHEN (N.ASSET_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.ASSET_ID,2);
END ¬"
|
|
|
|
S_COMMUNICATION
|
S_COMUNICATION_P99
|
PARTITION_COLUMN,ROW_ID
|
"WHEN (N.ROW_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.ROW_ID,2);
END ¬"
|
|
|
|
S_CONTACT
|
S_CONTACT_M12
|
LAST_NAME, FST_NAME, MID_NAME, PRIV_FLG, ALIAS_NAME
|
N/A
|
S_EVT_ACT
|
S_EVT_ACT_P99
|
PARTITION_COLUMN,OPTY_ID
|
"WHEN (N.ROW_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.OPTY_ID,2);
END ¬"
|
|
|
|
S_EXP_ITEM
|
S_EXP_ITEM_P99
|
PARTITION_COLUMN,
OWNER_EMP_ID
|
"WHEN (N.OWNER_EMP_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.OWNER_EMP_ID,2);
END ¬"
|
|
|
|
S_FN_ACCNT_TXN
|
S_FN_ACCNT_TXN_P99
|
PARTITION_COLUMN,
ACCNT_ID
|
"WHEN (N.ACCNT_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.ACCNT_ID,2);
END ¬"
|
|
|
|
S_FNCVRG_ELMNTS
Siebel Industry Applications (SIA) table
|
S_FNCVRG_ELMNTSP99
|
PARTITION_COLUMN,APPLD_CVRG_ID
|
"WHEN (N.APPLD_CVRG_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.APPLD_CVRG_ID,2);
END ¬"
|
|
|
|
S_INS_CLAIM
|
S_INS_CLAIM_P99
|
PARTITION_COLUMN,INSCLAIM_NUM
|
"WHEN (N.INSCLAIM_NUM IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.INSCLAIM_NUM,2);
END ¬"
|
|
|
|
S_INS_ITEM
|
S_INS_ITEM_P99
|
PARTITION_COLUM, ASSET_ID
|
"WHEN (N.ASSET_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.ASSET_ID,2);
END ¬"
|
|
|
|
S_INSCLM_ELMNT
|
S_INSCLM_ELMNT_P99
|
PARTITION_COLUMN,INSCLM_ID
|
"WHEN (N.INSCLM_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.INSCLM_ID,2);
END ¬"
|
|
|
|
S_OPTY
|
S_OPTY_U1
|
NAME, PR_DEPT_OU_ID, BU_ID, CONFLICT_ID
|
N/A
|
S_OPTY_POSTN
|
S_OPTY_POSTN_P99
|
PARTITION_COLUMN,OPTY_ID
|
"WHEN (N.OPTY_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.OPTY_ID,2);
END ¬"
|
|
|
|
S_ORG_EXT
|
S_ORG_EXT_U1
|
NAME, LOC, BU_ID, CONFLICT_ID
|
N/A
|
S_PARTY
|
S_PARTY_P99
|
PARTITION_COLUMN,ROW_ID
|
"WHEN (N.ROW_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.ROW_ID,2);
END ¬"
|
|
|
|
S_PARTY_REL
|
S_PARTY_REL_P99
|
PARTITION_COLUMN,PARTY_ID
|
"WHEN (N.PARTY_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.PARTY_ID,2);
END ¬"
|
|
|
|
S_POSTN_CON
|
S_POSTN_CON_P99
|
PARTITION_COLUMN,POSTN_ID
|
"WHEN (N.POSTN_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.POSTN_ID,2);
END ¬"
|
|
|
|
S_REVN
|
S_REVN_P99
|
PARTITION_COLUMN,ROW_ID
|
"WHEN (N.ROW_ID IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.ROW_ID,2);
END ¬"
|
|
|
|
S_SRV_REQ
|
S_SRV_REQ_P99
|
PARTITION_COLUMN,SR_NUM
|
"WHEN (N.SR_NUM IS NOT NULL)
BEGIN ATOMIC
SET N.PARTITION_COLUMN = RIGHT(N.SR_NUM,2);
END ¬"
|
|
|
|
