INT_PCSRCPN_PGTAIL

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 PGPREMISE CHARACTER VARYING(1) 1
17 PGEXTGLS CHARACTER VARYING(1) 1
18 PGEXSQMTR SMALLINT 2
19 PGINTGLS CHARACTER VARYING(1) 1
20 PGINSQMTR SMALLINT 2
21 PGTEMSHUT SMALLINT 2
22 PGREFRAME SMALLINT 2
23 PGSGNTAPE SMALLINT 2
24 PGSTCKDES SMALLINT 2
25 PGTOUGH CHARACTER VARYING(1) 1
26 PGTRIPLEX CHARACTER VARYING(1) 1
27 PGBENT CHARACTER VARYING(1) 1
28 PGSTAIN CHARACTER VARYING(1) 1
29 PGADVERT SMALLINT 2
30 PGBASINS CHARACTER VARYING(1) 1
31 PGSHOWFRM SMALLINT 2
32 PGREMDEB SMALLINT 2
33 PGSPECIFY CHARACTER VARYING(1) 1
34 PGMLTDISC CHARACTER VARYING(2) 2