INT_PI_MOTOR_AUDIT_REPORT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPAIRER_NAME CHARACTER VARYING(181) 181
2 REPAIRER_ID BIGINT 8
3 REPAIRER_LOCATION_CONTACT_TYPE_NAME CHARACTER VARYING(256) 256
4 CCR_AB_ABCONTACT_REPAIRER_PREFERRED CHARACTER VARYING(1) 1
5 RIREPAIRER_STATE CHARACTER VARYING(256) 256
6 REPAIRER_REGION CHARACTER VARYING(8) 8
7 CCR_CCX_AUDITREPORT_EXT_ID INTEGER 4
8 CCR_CCX_AUDITREPORT_EXT_AUDITDATE DATE 4
9 INCIDENT_ID INTEGER 4
10 CCR_CCX_AUDITREPORT_EXT_REPAIRSTATUS CHARACTER VARYING(100) 100
11 CCR_CCX_AUDITREPORT_EXT_REPAIRERID INTEGER 4
12 CCR_CCX_AUDITREPORT_EXT_STATUS CHARACTER VARYING(100) 100
13 CCR_CCTL_AUDITREPORTTYPE_EXT_NAME CHARACTER VARYING(256) 256
14 CCR_CCTL_AUDITREPORTTYPE_EXT_TYPECODE CHARACTER VARYING(50) 50
15 CCR_CCX_AUDITQUESTION_EXT_DESCRIPTION CHARACTER VARYING(100) 100
16 CCR_CCX_AUDITQUESTIONAIREITEM_EXT_AUDITREPORTID NUMERIC(34,0) 19
17 CCR_CCX_AUDITQUESTIONAIREITEM_EXT_AUDITQUESTIONID NUMERIC(34,0) 19
18 AUDITQUESTIONANSWER CHARACTER VARYING(255) 255
19 CCR_CCX_AUDITQUESTIONAIREITEM_EXT_ID NUMERIC(34,0) 19
20 CCR_CCX_AUDITQUESTION_EXT_ID NUMERIC(34,0) 19
21 CCR_CCX_AUDITANSWERSCORE_EXT_SCORE NUMERIC(34,0) 19
22 CCX_AUDITREPORTTEMPLATE_EXT_BENCHSCORE NUMERIC(34,0) 19