OBP24_FLX_OR_LRM_POLICY_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 APPLICATION_ID CHARACTER VARYING(50) 50
2 PROD_GRP_SERIAL_NO BYTEINT 1
3 SUBMISSION_ID CHARACTER VARYING(50) 50
4 FACILITY_ID CHARACTER VARYING(40) 40
5 INSURANCE_ID CHARACTER VARYING(50) 50
6 LMI_PREMIUM_AMOUNT DOUBLE PRECISION 8
7 LMI_PREMIUM_CCY CHARACTER VARYING(10) 10
8 QUOTE_STATUS_TYPE CHARACTER VARYING(40) 40
9 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
10 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
11 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
12 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8