RDM_HOME_BIP_INITIATIVES_V

Database

SDSNZS01_RDM

Schema

CDCPADM_RDM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ID INTEGER 4
2 MUID CHARACTER VARYING(4000) 4000
3 VERSIONNAME NATIONAL CHARACTER VARYING(50) 50
4 VERSIONNUMBER INTEGER 4
5 VERSION_ID INTEGER 4
6 VERSIONFLAG NATIONAL CHARACTER VARYING(50) 50
7 NAME NATIONAL CHARACTER VARYING(250) 250
8 CODE NATIONAL CHARACTER VARYING(250) 250
9 CHANGETRACKINGMASK INTEGER 4
10 INITIATIVE_CODE NATIONAL CHARACTER VARYING(250) 250
11 INITIATIVE_NAME NATIONAL CHARACTER VARYING(250) 250
12 INITIATIVE_ID INTEGER 4
13 RISK_STATE_CODE NATIONAL CHARACTER VARYING(250) 250
14 RISK_STATE_NAME NATIONAL CHARACTER VARYING(250) 250
15 RISK_STATE_ID INTEGER 4
16 LOSS_CAUSE_MANAGEMENT_CODE NATIONAL CHARACTER VARYING(250) 250
17 LOSS_CAUSE_MANAGEMENT_NAME NATIONAL CHARACTER VARYING(250) 250
18 LOSS_CAUSE_MANAGEMENT_ID INTEGER 4
19 EXPOSURE_BANDING_CODE NATIONAL CHARACTER VARYING(250) 250
20 EXPOSURE_BANDING_NAME NATIONAL CHARACTER VARYING(250) 250
21 EXPOSURE_BANDING_ID INTEGER 4
22 EXPOSURE_BAND_LOW NATIONAL CHARACTER VARYING(100) 100
23 EXPOSURE_BAND_HIGH NATIONAL CHARACTER VARYING(100) 100
24 DATE_FROM TIMESTAMP 8
25 DATE_TO TIMESTAMP 8
26 BRAND_CODE NATIONAL CHARACTER VARYING(250) 250
27 BRAND_NAME NATIONAL CHARACTER VARYING(250) 250
28 BRAND_ID INTEGER 4
29 ENTERDATETIME TIMESTAMP 8
30 ENTERUSERNAME NATIONAL CHARACTER VARYING(100) 100
31 ENTERVERSIONNUMBER INTEGER 4
32 LASTCHGDATETIME TIMESTAMP 8
33 LASTCHGUSERNAME NATIONAL CHARACTER VARYING(100) 100
34 LASTCHGVERSIONNUMBER INTEGER 4
35 VALIDATIONSTATUS NATIONAL CHARACTER VARYING(250) 250
36 CDC_SRC_SYSTEM_CODE CHARACTER(4) 4
37 CDC_RECORD_TYPE CHARACTER(14) 14
38 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
39 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8