INT_BASE_PI_JCI_POLSCHD

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY_NO INTEGER 4
2 POLICY_NO INTEGER 4
3 AGREEMENT_TYPE CHARACTER(3) 3
4 SCHEDULE_START DATE 4
5 POLICY_TERM SMALLINT 2
6 DUE_DATE DATE 4
7 REP_NO SMALLINT 2
8 INSTALMENT_FREQ CHARACTER(1) 1
9 POLSTATUS CHARACTER(1) 1
10 TAKEN_UP_IND CHARACTER VARYING(1) 1
11 SCHEDULE_TRIGGER CHARACTER VARYING(11) 11
12 CURRENT_TRANCNT SMALLINT 2
13 INS_PRD_START DATE 4
14 SCHEDULE_END DATE 4