INT_TEMP_RETENTIONSUMMARY_COGEN

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EFFECTIVE_DATE DATE 4
2 BRAND CHARACTER VARYING(30) 30
3 PRODUCT_TYPE CHARACTER VARYING(200) 200
4 LSP_FLAG CHARACTER VARYING(25) 25
5 RISK_STATE CHARACTER VARYING(200) 200
6 FACTOR CHARACTER VARYING(17) 17
7 SEGMENT CHARACTER VARYING(100) 100
8 TOTAL_RENEWED DOUBLE PRECISION 8
9 TOTAL_EXPIRING DOUBLE PRECISION 8
10 DATASET CHARACTER VARYING(5) 5
11 RETENTION_RATE DOUBLE PRECISION 8
12 PORTFOLIO_TOTAL_RENEWED DOUBLE PRECISION 8
13 PORTFOLIO_TOTAL_EXPIRING DOUBLE PRECISION 8
14 PORTFOLIO_RETENTION_RATE DOUBLE PRECISION 8