Historic Auto Table

Owned by Peter Antley
Mar 25, 2022


CREATE TABLE STATSUAT.AAIS_STAT_AU (
ID NUMBER(38,0),
TRANSMITTAL_ID NUMBER(38,0),
CHANGE_COMMENTS VARCHAR2(4000),
UPDATED_BY NUMBER(38,0),
EFF_START_DATE TIMESTAMP,
EFF_END_DATE TIMESTAMP,
LAST_VALIDATED_DATE TIMESTAMP,
STATUS VARCHAR2(20),
LINE_NUMBER NUMBER(38,0),
VERSION NUMBER(38,0) DEFAULT 1,
VAL_VER NUMBER(38,0) DEFAULT 1,
REP_YR_4DIGIT NUMBER(4,0),
LINE VARCHAR2(2),
REP_MO VARCHAR2(2),
REP_YR VARCHAR2(1),
COMP VARCHAR2(4),
STATE VARCHAR2(2),
TERRITORY VARCHAR2(3),
OPT_ZIP_CD_IND VARCHAR2(1),
TRANS VARCHAR2(1),
PREM_AMT NUMBER(12,2),
LOSS_AMT NUMBER(12,2),
PROG_CD VARCHAR2(1),
COV_CODE VARCHAR2(1),
SUBLINE VARCHAR2(1),
RES030 VARCHAR2(4),
AGE VARCHAR2(1),
SEX_MARITAL VARCHAR2(1),
VEHICLE_USE VARCHAR2(1),
VEHICLE_PERF VARCHAR2(1),
COMMERCIAL_CLASS VARCHAR2(1),
DRIV_TRAIN_GOOD_STUDENT VARCHAR2(1),
COMMERCIAL_USE VARCHAR2(1),
PENALTY_POINTS VARCHAR2(1),
LIA_LIM VARCHAR2(1),
DED_AMT VARCHAR2(1),
BODY_STYLE VARCHAR2(2),
BODY_SIZE VARCHAR2(1),
MODEL_YEAR VARCHAR2(2),
UM_UIM_MOTORIST VARCHAR2(1),
EXPOSURE NUMBER(38,0),
CLM_CNT NUMBER(38,0),
COL VARCHAR2(1),
MOS_COV VARCHAR2(2),
RES050 VARCHAR2(1),
TERRORISM VARCHAR2(1),
RES051 VARCHAR2(1),
RES052 VARCHAR2(4),
SING_MULT_CAR VARCHAR2(1),
ACCIDENT_MON VARCHAR2(2),
RES057 VARCHAR2(3),
ACCIDENT_YR VARCHAR2(2),
RES060 VARCHAR2(4),
PACKAGE_ID VARCHAR2(1),
POOL VARCHAR2(1),
CLAIM_NUM VARCHAR2(12),
POLICY_NUM VARCHAR2(14),
CLAIM_ID VARCHAR2(2),
RES080 VARCHAR2(1),
ZIP VARCHAR2(5),
ZIP_SUFF VARCHAR2(4),
UM_UIM_STACK_IND VARCHAR2(1),
RES091 VARCHAR2(2),
SYMBOL VARCHAR2(2),
PASS_RESTRAINT VARCHAR2(1),
ANTI_LOCK VARCHAR2(1),
ANTI_THEFT VARCHAR2(2),
DEF_DRIVER VARCHAR2(1),
PIP_LIMIT_DED VARCHAR2(1),
NJ_PIP_LIMIT VARCHAR2(2),
RES099 VARCHAR2(2),
NJ_PIP_DED VARCHAR2(1),
RAT_TERM_ZONE VARCHAR2(3),
RES101 VARCHAR2(3),
ASSIGN_RISK_RATE_CLASS VARCHAR2(4),
ASSIGN_RISK_PTS_SUR VARCHAR2(2),
EXP_RATING_MOD VARCHAR2(3),
RES111 VARCHAR2(2),
RES113 VARCHAR2(1),
EXCEPT_A VARCHAR2(2),
EXCEPT_B VARCHAR2(2),
EXCEPT_C VARCHAR2(2),
EXCEPT_D VARCHAR2(2),
RES122 VARCHAR2(15),
COUNTY VARCHAR2(3),
CO_USE VARCHAR2(11),
NOTES VARCHAR2(4000),
VIN VARCHAR2(17),
LIMIT_LOSS_CD_ID VARCHAR2(1),
CONSTRAINT PK_AAIS_STAT_AU PRIMARY KEY (ID),
CONSTRAINT SYS_C0015348 CHECK ("ID" IS NOT NULL),
CONSTRAINT SYS_C0015349 CHECK ("TRANSMITTAL_ID" IS NOT NULL),
CONSTRAINT SYS_C0015350 CHECK ("EFF_END_DATE" IS NOT NULL),
CONSTRAINT FK_AAIS_STAT_AU_TRANSMITTAL FOREIGN KEY (TRANSMITTAL_ID) REFERENCES STATSUAT.TRANSMITTAL(ID) ON DELETE CASCADE
);
CREATE INDEX IDX_AAIS_STAT_AU_TRANS_ID ON STATSUAT.AAIS_STAT_AU (TRANSMITTAL_ID);
CREATE UNIQUE INDEX PK_AAIS_STAT_AU ON STATSUAT.AAIS_STAT_AU (ID);