DIM_SDW_CLMS_MIGRATED_PH

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 FROM_PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
2 TO_PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
3 EFF_END_DATE TIMESTAMP 8
4 FROM_PRDT_SYS_CODE CHARACTER VARYING(3) 3
5 TO_PRDT_SYS_CODE CHARACTER VARYING(3) 3
6 FROM_ACCOUNT_NUMBER CHARACTER VARYING(20) 20
7 TO_ACCOUNT_NUMBER CHARACTER VARYING(20) 20
8 FROM_SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
9 TO_SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
10 FROM_PRODUCT_CODE CHARACTER VARYING(12) 12
11 TO_PRODUCT_CODE CHARACTER VARYING(12) 12
12 FROM_SUB_PRODUCT_CODE CHARACTER VARYING(12) 12
13 TO_SUB_PRODUCT_CODE CHARACTER VARYING(12) 12
14 MIGRATION_DATE TIMESTAMP 8
15 LOAD_DATE TIMESTAMP 8