1.1.2 Process Table

This topic describes process table for uploading records.

For uploading, each record is processed from a cursor on process tables. This is common across all function IDs. There are 2 process tables:
  • CSTB_EXT_CONTRACT_STAT
  • STTB_UPLOAD_MASTER

Table 1-1 CSTB_EXT_CONTRACT_STAT

Name Type Characters Nullable
BRANCH_CODE VARCHAR2 3 CHAR N
SOURCE VARCHAR2 20 CHAR N
PRODUCT_CODE VARCHAR2 4 CHAR Y
COUNTERPARTY VARCHAR2 35 CHAR Y
EXTERNAL_INIT_DATE DATE NA Y
MODULE VARCHAR2 2 CHAR Y
EXTERNAL_REF_NO VARCHAR2 20 CHAR N
IMPORT_STATUS VARCHAR2 1 CHAR Y
CITICUBE_REF_NO VARCHAR2 16 CHAR Y
POST_IMPORT_STATUS CHAR 1 CHAR Y
EXPORT_STATUS CHAR 1 CHAR Y
USER_ID VARCHAR2 12 CHAR Y
JOBNO NUMBER 2 Y
CONTRACT_REF_NO VARCHAR2 16 CHAR Y
ERR_CODE VARCHAR2 11 CHAR Y
ERR_MESSAGE VARCHAR2 255 CHAR Y
ACTION_CODE VARCHAR2 10 CHAR Y
FUNCTION_ID VARCHAR2 8 CHAR Y
EXTERNAL_SEQ_NO NUMBER 22 N
UPLOAD_ID VARCHAR2 16 CHAR Y
Here a particular record from upload tables would be picked by a combination of EXTERNAL_REF_NO, EXTERNAL_SEQ_NO, BRANCH_CODE, and SOURCE. Columns like EXPORT_STATUS, CONTRACT_REF_NO, ERR_CODE, and ERR_MESSAGE would be updated by the system after processing. UPLOAD_ID signifies the thread of execution. The upload routine can be invoked in multiple threads if multiple upload IDs are present.

Table 1-2 STTB_UPLOAD_MASTER

Name Type Characters Nullable
MAINTENANCE_SEQ_NO VARCHAR2 16 CHAR N
BRANCH_CODE VARCHAR2 3 CHAR N
SOURCE_CODE VARCHAR2 15 CHAR N
MAINTENANCE_TYPE VARCHAR2 15 CHAR Y
UPLOAD_STATUS CHAR 1 CHAR Y
UPLOAD_INITIATION_DATE DATE NA Y
USER_ID VARCHAR2 12 CHAR Y
ACTION_CODE VARCHAR2 15 CHAR Y
SOURCE_SEQ_NO NUMBER NA N
UPLOAD_ID VARCHAR2 16 CHAR Y
Here a particular record from upload tables would be picked by a combination of MAINTENANCE_SEQ_NO, SOURCE_SEQ_NO, BRANCH_CODE, and SOURCE_CODE. UPLOAD_STATUS would be updated by the system after processing a record. UPLOAD_ID signifies the thread of execution. The upload routine can be invoked in multiple threads if multiple upload ids are present.

Parent topic: Upload Framework