PRT_MFLTTAIL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER(3) 3
3 POLICY INTEGER 4
4 ITEMNO SMALLINT 2
5 TRANCNT SMALLINT 2
6 EFFECTDTE INTEGER 4
7 ACTIVTO INTEGER 4
8 IMAGEFLAG CHARACTER(1) 1
9 BUSNSSINS CHARACTER(4) 4
10 MFUNITS INTEGER 4
11 MFMODELPR INTEGER 4
12 STATSCODE CHARACTER(3) 3
13 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 RECORD_TYPE CHARACTER VARYING(16) 16
15 COMMIT_TIMESTAMP TIMESTAMP 8
16 EXTRACT_TIMESTAMP TIMESTAMP 8
17 COMPANY_CDC SMALLINT 2
18 DW_TIMESTAMP TIMESTAMP 8
19 CDC_ID BIGINT 8
20 POLICY_CDC INTEGER 4
21 ACTIVTO_CDC DATE 4
22 EFFECTDTE_CDC DATE 4
23 RADIUS CHARACTER(4) 4
24 INGESTIND CHARACTER(1) 1
25 SCHEDVAL CHARACTER(1) 1