1.59.2 Rebalancing Rule Mapping Upload

This topic provides detailed information on the rebalancing rule mapping upload.

Serial Number: 1

Segment Identification Number: 00REB

Description: This segment is used for providing rebalancing rule mapping header information.

Attributes: Mandatory

Table 1-189 Rebalancing Rule Mapping Upload

Field Name DESCRIPTION DATA TYPE LENGTH TABLENAME
SEGMENTID Segment ID.

Value of Segment ID is 00REB

VARCHAR2 20 PATM_REBAL_RULEMAP_ HDR_UPLOAD
SEQUENCENUMBER Sequence Number NUMBER 22 PATM_REBAL_RULEMAP_ HDR_UPLOAD
PROCESSID Process ID VARCHAR2 50 PATM_REBAL_RULEMAP_ HDR_UPLOAD
BULKCLIENTCODE Bulk Client Code VARCHAR2 12 PATM_REBAL_RULEMAP_ HDR_UPLOAD
UPLOADMODE Upload Mode VARCHAR2 1 PATM_REBAL_RULEMAP_ HDR_UPLOAD
IMPORTFILENAME Import File Name VARCHAR2 255 PATM_REBAL_RULEMAP_ HDR_UPLOAD
REBALRULEID Rebalance Rule ID VARCHAR2 16 PATM_REBAL_RULEMAP_ HDR_UPLOAD
AUTH_STAT Auth Stat VARCHAR2 1 PATM_REBAL_RULEMAP_ HDR_UPLOAD
ONCE_AUTH Once Auth VARCHAR2 1 PATM_REBAL_RULEMAP_ HDR_UPLOAD
RECORD_STAT Record Stat VARCHAR2 1 PATM_REBAL_RULEMAP_ HDR_UPLOAD
MOD_NO Modification Number NUMBER 22 PATM_REBAL_RULEMAP_ HDR_UPLOAD
USER_ID User ID VARCHAR2 15320 PATM_REBAL_RULEMAP_ HDR_UPLOAD

Serial Number: 2

Segment Identification Number: 01DET

Description: This segment is used for providing rebalancing rule mapping information.

Attributes: Mandatory

Table 1-190 Rebalancing Rule Mapping Upload

Field Name DESCRIPTION DATA TYPE LENGTH TABLENAME
SEGMENTID Segment ID.

Value of Segment ID is 01DET

VARCHAR2 20 PATM_REBAL_RULEMAP_DET_UPLOAD
SEQUENCENUMBER Sequence Number NUMBER 22 PATM_REBAL_RULEMAP_DET_UPLOAD
PROCESSID Process ID VARCHAR2 50 PATM_REBAL_RULEMAP_DET_UPLOAD
BULKCLIENTCODE Bulk Client Code VARCHAR2 12 PATM_REBAL_RULEMAP_DET_UPLOAD
REBALRULEID Rebalance Rule ID VARCHAR2 16 PATM_REBAL_RULEMAP_DET_UPLOAD
PORTFOLIOID Portfolio ID VARCHAR2 16 PATM_REBAL_RULEMAP_DET_UPLOAD
PARTYID Party ID VARCHAR2 16 PATM_REBAL_RULEMAP_DET_UPLOAD
ACCOUNTID Account ID VARCHAR2 16 PATM_REBAL_RULEMAP_DET_UPLOAD