INT_PCSRCPN_PATAIL

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MD5_KEY CHARACTER VARYING(128) 128
2 REC_TYPE_CD INTEGER 4
3 BATCH_KEY INTEGER 4
4 RUN_REG_KEY BIGINT 8
5 ROW_INSERT_DT TIMESTAMP 8
6 ROW_EFFECTIVE_DT TIMESTAMP 8
7 AUDIT_FLAG CHARACTER VARYING(1) 1
8 COMPANY SMALLINT 2
9 PRODUCT CHARACTER VARYING(3) 3
10 POLICY INTEGER 4
11 ITEMNO SMALLINT 2
12 EFFECTDTE INTEGER 4
13 ACTIVTO INTEGER 4
14 TRANCNT SMALLINT 2
15 IMAGEFLAG CHARACTER VARYING(1) 1
16 PABTHDTE INTEGER 4
17 PADEATH INTEGER 4
18 PAWKSIACC SMALLINT 2
19 PAACWKPAY SMALLINT 2
20 PAWKSIILL SMALLINT 2
21 PAILWKPAY SMALLINT 2
22 PAGENDER CHARACTER VARYING(1) 1
23 PASMOKER CHARACTER VARYING(1) 1
24 PAEYELIMB INTEGER 4
25 PAEYELIMS INTEGER 4
26 PATOTDIS INTEGER 4
27 PABLDPARA INTEGER 4
28 PAROCCUP CHARACTER VARYING(4) 4
29 PAWRKPERF CHARACTER VARYING(1) 1
30 PABENFTWK SMALLINT 2
31 PACOVREST CHARACTER VARYING(1) 1
32 PAPARTACC SMALLINT 2
33 PACVRRST1 CHARACTER VARYING(1) 1
34 PACVRRST2 CHARACTER VARYING(1) 1
35 PACVRRST3 CHARACTER VARYING(1) 1
36 PAUNITS SMALLINT 2
37 PAMLTDISC CHARACTER VARYING(2) 2
38 PAACCUM CHARACTER VARYING(1) 1
39 PAINSNAME CHARACTER VARYING(35) 35