TRPMT_DIV

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DIV_ID CHARACTER VARYING(255) 255
2 DIV_RV_ID BIGINT 8
3 DIV_ALCO DOUBLE PRECISION 8
4 DIV_BADDEBT_ID CHARACTER VARYING(255) 255
5 DIV_HURDLE_RATE DOUBLE PRECISION 8
6 DIV_ACQ_BORCOST DOUBLE PRECISION 8
7 DIV_FIX_BORCOST DOUBLE PRECISION 8
8 DIV_VAR_BORCOST DOUBLE PRECISION 8
9 DIV_ADEQ_RATIO DOUBLE PRECISION 8
10 DIV_CORP_TAX_RATE DOUBLE PRECISION 8
11 DIV_COST_MAXI DOUBLE PRECISION 8
12 DIV_COST_MINI DOUBLE PRECISION 8
13 DIV_CUSTTIER1_VAL DOUBLE PRECISION 8
14 DIV_CUSTTIER2_VAL DOUBLE PRECISION 8
15 DIV_CUSTTIER3_VAL DOUBLE PRECISION 8
16 DIV_CUSTTIER4_VAL DOUBLE PRECISION 8
17 DIV_CUSTTIER5_VAL DOUBLE PRECISION 8
18 DIV_ACQ_DEALCOST DOUBLE PRECISION 8
19 DIV_FIX_DEALCOST DOUBLE PRECISION 8
20 DIV_VAR_DEALCOST DOUBLE PRECISION 8
21 DIV_DEBT_PCT DOUBLE PRECISION 8
22 DIV_DEPT_CODE CHARACTER VARYING(255) 255
23 DIV_DIV_TYPE CHARACTER VARYING(255) 255
24 DIV_ECONRSKWGHT_ID CHARACTER VARYING(255) 255
25 DIV_GST_RATE DOUBLE PRECISION 8
26 DIV_ACQ_LOANCOST DOUBLE PRECISION 8
27 DIV_FIX_LOANCOST DOUBLE PRECISION 8
28 DIV_VAR_LOANCOST DOUBLE PRECISION 8
29 DIV_MEZZ_DEBT DOUBLE PRECISION 8
30 DIV_SUB_DEPT_CODE CHARACTER VARYING(255) 255
31 DIV_SUB_DEBT_COST DOUBLE PRECISION 8
32 DIV_TARGET_ROE DOUBLE PRECISION 8
33 DIV_ACTIVE INTEGER 4
34 DATE_CREATED TIMESTAMP 8
35 CREATED_BY CHARACTER VARYING(255) 255
36 DATE_MODIFIED TIMESTAMP 8
37 MODIFIED_BY CHARACTER VARYING(255) 255
38 DIV_BRKG_LOANCOSTFIX DOUBLE PRECISION 8
39 DIV_BRKG_LOANCOSTVAR DOUBLE PRECISION 8
40 DIV_BRKG_LOANCOSTACQ DOUBLE PRECISION 8
41 DIV_BRKG_DEALFIX DOUBLE PRECISION 8
42 DIV_BRKG_DEALACQ DOUBLE PRECISION 8
43 DIV_BRKG_COSTOVERMIN DOUBLE PRECISION 8
44 DIV_BRKG_COSTOVERMAX DOUBLE PRECISION 8
45 DIV_BRWR_BASED_ROE INTEGER 4
46 DIV_BRWR_CMPLX_LABEL CHARACTER VARYING(255) 255
47 DIV_CORP_TAX_RATERV DOUBLE PRECISION 8
48 DIV_ECO_CAP_COST DOUBLE PRECISION 8
49 DIV_REALVAL_DISCRATE DOUBLE PRECISION 8
50 DIV_BASIS_RISK DOUBLE PRECISION 8
51 DIV_BUSINESS_RISK DOUBLE PRECISION 8
52 DIV_OPERATIONAL_RISK DOUBLE PRECISION 8
53 DIV_FIXED_ASSET_RISK DOUBLE PRECISION 8
54 DIV_DISPLAY_RAROC INTEGER 4
55 DIV_DISPLAY_REALVALUE INTEGER 4
56 DIV_3YR_ROLLING_AVG_PCT DOUBLE PRECISION 8
57 DIV_HURDLE_RATE_PCT DOUBLE PRECISION 8
58 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
59 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
60 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
61 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8