PRT_INTERR

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 SUBCOY SMALLINT 2
3 STATE SMALLINT 2
4 BRANCH SMALLINT 2
5 RISKSTATE CHARACTER VARYING(2) 2
6 RUNNO INTEGER 4
7 RUNDATE INTEGER 4
8 PRODUCT CHARACTER VARYING(3) 3
9 POLICY INTEGER 4
10 ITEMNO SMALLINT 2
11 CLASS CHARACTER VARYING(3) 3
12 SUBCLASS CHARACTER VARYING(3) 3
13 AGENT INTEGER 4
14 TRANTYPE CHARACTER VARYING(4) 4
15 RECTYPE CHARACTER VARYING(2) 2
16 TRANDATE INTEGER 4
17 TRANTIME INTEGER 4
18 EFFECTDTE INTEGER 4
19 SEQUENCE NUMERIC(7,0) 19
20 LINENO SMALLINT 2
21 ERRNO CHARACTER VARYING(4) 4
22 RECIND SMALLINT 2
23 ACTION CHARACTER VARYING(1) 1
24 PROGID CHARACTER VARYING(8) 8
25 ERRDATE INTEGER 4
26 ERRTIME INTEGER 4
27 INTERTYP CHARACTER VARYING(3) 3
28 INTERPRO CHARACTER VARYING(3) 3
29 INTERPOL CHARACTER VARYING(20) 20
30 INTERITM CHARACTER VARYING(12) 12
31 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
32 RECORD_TYPE CHARACTER VARYING(16) 16
33 COMMIT_TIMESTAMP TIMESTAMP 8
34 EXTRACT_TIMESTAMP TIMESTAMP 8