INT_PI_MOTOR_ASSESSMENT_BOOKING

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 VEHICLEINCIDENTID BIGINT 8
2 SC_CONTACTID BIGINT 8
3 PROCESSTYPE_NAME CHARACTER VARYING(256) 256
4 BOOKING_STATUS_TYPECODE CHARACTER VARYING(50) 50
5 APPOINTMENT_TIME TIMESTAMP 8
6 APPOINTMENT_DATE DATE 4
7 CREATED_TIME TIMESTAMP 8
8 ASSESSOR BIGINT 8
9 CCR_CCTL_SC_NONBOOKASSESSMENTRSN_NAME CHARACTER VARYING(256) 256
10 BOOKING_CREATE_SEQ_DESC BIGINT 8
11 NEXT_BOOKING_START_DATE DATE 4
12 BOOKING_DATE_EXCPT_REINSP TIMESTAMP 8
13 PRIMARY_BOOKING_DATE DATE 4
14 BOOKING_CREATE_SEQ_DESC_NO_DRAFTS BIGINT 8
15 PRIMARY_BOOKING_PREV_WORKING_DAY_SEQ BIGINT 8