Table 12. Prepartitioned Siebel Tables with Physical Columns
|
|
|
|
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 Siebel Industry Applications (SIA) table |
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, 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 Siebel Industry Applications (SIA) table |
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 Siebel Industry Applications (SIA) table |
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 Siebel Industry Applications (SIA) table |
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 Siebel Industry Applications (SIA) table |
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 ¬"
|