PRT_INSTPREM

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER VARYING(3) 3
3 POLICY INTEGER 4
4 TERMSTART INTEGER 4
5 INSTSEQ SMALLINT 2
6 ACTIVTO INTEGER 4
7 ACTIVFROM INTEGER 4
8 TRANCNT SMALLINT 2
9 INSTDATE INTEGER 4
10 INSTTYPE CHARACTER VARYING(1) 1
11 INSTSTAT CHARACTER VARYING(1) 1
12 INSTAMT NUMERIC(9,2) 19
13 BASICPRM NUMERIC(9,2) 19
14 CHARGES NUMERIC(9,2) 19
15 STMPDUTY NUMERIC(9,2) 19
16 DEBITDATE INTEGER 4
17 DEBITTYPE CHARACTER VARYING(1) 1
18 DEBITSEQ INTEGER 4
19 BSBNO CHARACTER VARYING(6) 6
20 DEBITACCT CHARACTER VARYING(9) 9
21 CREDCARD CHARACTER VARYING(16) 16
22 REJECTDATE INTEGER 4
23 REJECTCNT SMALLINT 2
24 REJREASON CHARACTER VARYING(2) 2
25 STATE SMALLINT 2
26 BRANCH SMALLINT 2
27 GST NUMERIC(9,2) 19
28 COMMISN NUMERIC(9,2) 19
29 COMMGST NUMERIC(9,2) 19
30 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
31 RECORD_TYPE CHARACTER VARYING(16) 16
32 COMMIT_TIMESTAMP TIMESTAMP 8
33 EXTRACT_TIMESTAMP TIMESTAMP 8
34 CDC_ID BIGINT 8
35 COMPANY_CDC SMALLINT 2
36 POLICY_CDC BIGINT 8
37 ACTIVTO_CDC DATE 4
38 DW_TIMESTAMP TIMESTAMP 8