CLMS_ARLHEAD

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_CLMS_ARLHEAD

SDSNZP02_BANK..NROD_CLMS_ARLHEAD

SDSNZP05_BANK..CBP_CLMS_ARLHEAD

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACTION_CODE CHARACTER VARYING(1) 1
3 ACCOUNTNO INTEGER 4
4 STATUS INTEGER 4
5 STDATE CHARACTER VARYING(10) 10
6 BORCODE INTEGER 4
7 DESC CHARACTER VARYING(35) 35
8 PRODUCT INTEGER 4
9 STRTDATE TIMESTAMP 8
10 TERM INTEGER 4
11 EXPDATE TIMESTAMP 8
12 COY INTEGER 4
13 BRANCH INTEGER 4
14 MLIM INTEGER 4
15 LCAT CHARACTER VARYING(3) 3
16 LPURP INTEGER 4
17 SOURCE INTEGER 4
18 BDMCODE INTEGER 4
19 RTYPE CHARACTER VARYING(10) 10
20 PRIMLOAN INTEGER 4
21 NOVATED CHARACTER VARYING(1) 1
22 CAPITYP INTEGER 4
23 PURCLASS INTEGER 4
24 DISCOUNT NUMERIC(12,2) 19
25 PREMIUM NUMERIC(12,2) 19
26 EXPENSES NUMERIC(12,2) 19
27 NOGTEES INTEGER 4
28 GTCOM CHARACTER VARYING(30) 30
29 GTINC CHARACTER VARYING(1) 1
30 GWAIVCDE INTEGER 4
31 NOSECS INTEGER 4
32 OSECS CHARACTER VARYING(1) 1
33 SECCOMS1 CHARACTER VARYING(60) 60
34 SECCOMS2 CHARACTER VARYING(60) 60
35 APLICNO INTEGER 4
36 APPDTE TIMESTAMP 8
37 APRDATE TIMESTAMP 8
38 LEAD CHARACTER VARYING(11) 11
39 CL1DATE TIMESTAMP 8
40 CLRCODE INTEGER 4
41 RREVDTE CHARACTER VARYING(10) 10
42 RREVCOM CHARACTER VARYING(30) 30
43 ANZSIC INTEGER 4
44 UNDERW INTEGER 4
45 MLIMCLS INTEGER 4
46 WATCHLIST CHARACTER VARYING(1) 1
47 REWRITE INTEGER 4
48 REWRITTEN INTEGER 4
49 RWCQR CHARACTER VARYING(2) 2
50 RWSR CHARACTER VARYING(1) 1
51 RWCRC CHARACTER VARYING(1) 1
52 CRGSDTE TIMESTAMP 8
53 PDLCONDTE TIMESTAMP 8
54 TCRATES CHARACTER VARYING(5) 5
55 LASTBAB INTEGER 4
56 FACRATE CHARACTER VARYING(5) 5
57 USERATE CHARACTER VARYING(5) 5
58 ROLLFEE CHARACTER VARYING(1) 1
59 PAYOUTDATE TIMESTAMP 8
60 LSTRTRVWDTE TIMESTAMP 8
61 AVGMNTHLYBAL NUMERIC(19,2) 19
62 OLOAN INTEGER 4
63 NLOAN INTEGER 4
64 CL2DATE TIMESTAMP 8
65 RPMQNO INTEGER 4
66 CRGSSSV NUMERIC(19,2) 19
67 FACIDENT INTEGER 4
68 FACCLASSN INTEGER 4
69 ANCLASS INTEGER 4
70 FB1CLASS INTEGER 4
71 SCORECARD INTEGER 4
72 QUESTN19 INTEGER 4
73 QUESTN20 INTEGER 4
74 QUESTN21 INTEGER 4
75 QUESTN22 INTEGER 4
76 TOTALSCORE CHARACTER VARYING(27) 27
77 TOTOVERALL CHARACTER VARYING(2) 2
78 ORFLAG INTEGER 4
79 ORREASON CHARACTER VARYING(60) 60
80 ORSOURCE CHARACTER VARYING(60) 60
81 CALCSCORE CHARACTER VARYING(2) 2
82 ACTLSCORE CHARACTER VARYING(27) 27
83 DELTA_TYPE CHARACTER VARYING(1) 1
84 HSTCADSC CHARACTER VARYING(100) 100
85 HSTCACDRLDR CHARACTER VARYING(10) 10
86 QUESTN24RAW CHARACTER VARYING(500) 500
87 QUESTN25RAW CHARACTER VARYING(500) 500
88 QUESTN26RAW CHARACTER VARYING(500) 500
89 QUESTN27RAW CHARACTER VARYING(500) 500
90 QUESTN28RAW CHARACTER VARYING(500) 500
91 DEVPC INTEGER 4
92 EFFECTIVE_STRT_DT TIMESTAMP 8
93 EFFECTIVE_END_DT TIMESTAMP 8
94 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
95 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
96 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
97 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8