INT_CI_INCIDENT_DRILLTHRU_DATES_YESNO

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INCIDENT_INSPECTION_PLAN_DATE_YEAR INTEGER 4
2 INCIDENT_INSPECTION_PLAN_DATE_QUARTER INTEGER 4
3 INCIDENT_INSPECTION_PLAN_DATE_MONTH INTEGER 4
4 INCIDENT_INSPECTION_PLAN_DATE_DAY INTEGER 4
5 INCIDENT_INSPECTION_PLAN_DATE_DAY_TYPE_ID INTEGER 4
6 INCIDENT_INSPECTION_PLAN_DATE_WEEK_TYPE_ID INTEGER 4
7 INCIDENT_INSPECTION_PLAN_DATE_MONTH_TYPE_ID INTEGER 4
8 INCIDENT_INSPECTION_PLAN_DATE_QUARTER_TYPE_ID INTEGER 4
9 INCIDENT_INSPECTION_PLAN_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
10 INCIDENT_INSPECTION_PLAN_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
11 INCIDENT_INSPECTION_PLAN_DATE_R12_MONTH_TYPE_ID INTEGER 4
12 INCIDENT_INSPECTION_PLAN_DATE_R13_MONTH_TYPE_ID INTEGER 4
13 INCIDENT_INSPECTION_PLAN_DATE_HALF_TYPE_ID INTEGER 4
14 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_YEAR INTEGER 4
15 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_QUARTER INTEGER 4
16 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_MONTH INTEGER 4
17 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_DAY INTEGER 4
18 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_DAY_TYPE_ID INTEGER 4
19 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_WEEK_TYPE_ID INTEGER 4
20 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_MONTH_TYPE_ID INTEGER 4
21 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_QUARTER_TYPE_ID INTEGER 4
22 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
23 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
24 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_R12_MONTH_TYPE_ID INTEGER 4
25 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_R13_MONTH_TYPE_ID INTEGER 4
26 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_HALF_TYPE_ID INTEGER 4
27 INCIDENT_ASSESSMENT_CLOSE_DATE_YEAR INTEGER 4
28 INCIDENT_ASSESSMENT_CLOSE_DATE_QUARTER INTEGER 4
29 INCIDENT_ASSESSMENT_CLOSE_DATE_MONTH INTEGER 4
30 INCIDENT_ASSESSMENT_CLOSE_DATE_DAY INTEGER 4
31 INCIDENT_ASSESSMENT_CLOSE_DATE_DAY_TYPE_ID INTEGER 4
32 INCIDENT_ASSESSMENT_CLOSE_DATE_WEEK_TYPE_ID INTEGER 4
33 INCIDENT_ASSESSMENT_CLOSE_DATE_MONTH_TYPE_ID INTEGER 4
34 INCIDENT_ASSESSMENT_CLOSE_DATE_QUARTER_TYPE_ID INTEGER 4
35 INCIDENT_ASSESSMENT_CLOSE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
36 INCIDENT_ASSESSMENT_CLOSE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
37 INCIDENT_ASSESSMENT_CLOSE_DATE_R12_MONTH_TYPE_ID INTEGER 4
38 INCIDENT_ASSESSMENT_CLOSE_DATE_R13_MONTH_TYPE_ID INTEGER 4
39 INCIDENT_ASSESSMENT_CLOSE_DATE_HALF_TYPE_ID INTEGER 4
40 INCIDENT_REPORTED_DATE_YEAR INTEGER 4
41 INCIDENT_REPORTED_DATE_QUARTER INTEGER 4
42 INCIDENT_REPORTED_DATE_MONTH INTEGER 4
43 INCIDENT_REPORTED_DATE_DAY INTEGER 4
44 INCIDENT_REPORTED_DATE_DAY_TYPE_ID INTEGER 4
45 INCIDENT_REPORTED_DATE_WEEK_TYPE_ID INTEGER 4
46 INCIDENT_REPORTED_DATE_MONTH_TYPE_ID INTEGER 4
47 INCIDENT_REPORTED_DATE_QUARTER_TYPE_ID INTEGER 4
48 INCIDENT_REPORTED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
49 INCIDENT_REPORTED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
50 INCIDENT_REPORTED_DATE_R12_MONTH_TYPE_ID INTEGER 4
51 INCIDENT_REPORTED_DATE_R13_MONTH_TYPE_ID INTEGER 4
52 INCIDENT_REPORTED_DATE_HALF_TYPE_ID INTEGER 4
53 INCIDENT_CREATED_DATE_YEAR INTEGER 4
54 INCIDENT_CREATED_DATE_QUARTER INTEGER 4
55 INCIDENT_CREATED_DATE_MONTH INTEGER 4
56 INCIDENT_CREATED_DATE_DAY INTEGER 4
57 INCIDENT_CREATED_DATE_DAY_TYPE_ID INTEGER 4
58 INCIDENT_CREATED_DATE_WEEK_TYPE_ID INTEGER 4
59 INCIDENT_CREATED_DATE_MONTH_TYPE_ID INTEGER 4
60 INCIDENT_CREATED_DATE_QUARTER_TYPE_ID INTEGER 4
61 INCIDENT_CREATED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
62 INCIDENT_CREATED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
63 INCIDENT_CREATED_DATE_R12_MONTH_TYPE_ID INTEGER 4
64 INCIDENT_CREATED_DATE_R13_MONTH_TYPE_ID INTEGER 4
65 INCIDENT_CREATED_DATE_HALF_TYPE_ID INTEGER 4
66 INCIDENT_UPDATED_DATE_YEAR INTEGER 4
67 INCIDENT_UPDATED_DATE_QUARTER INTEGER 4
68 INCIDENT_UPDATED_DATE_MONTH INTEGER 4
69 INCIDENT_UPDATED_DATE_DAY INTEGER 4
70 INCIDENT_UPDATED_DATE_DAY_TYPE_ID INTEGER 4
71 INCIDENT_UPDATED_DATE_WEEK_TYPE_ID INTEGER 4
72 INCIDENT_UPDATED_DATE_MONTH_TYPE_ID INTEGER 4
73 INCIDENT_UPDATED_DATE_QUARTER_TYPE_ID INTEGER 4
74 INCIDENT_UPDATED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
75 INCIDENT_UPDATED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
76 INCIDENT_UPDATED_DATE_R12_MONTH_TYPE_ID INTEGER 4
77 INCIDENT_UPDATED_DATE_R13_MONTH_TYPE_ID INTEGER 4
78 INCIDENT_UPDATED_DATE_HALF_TYPE_ID INTEGER 4
79 INCIDENT_REPORT_ONLY_ID BIGINT 8
80 INCIDENT_REPORT_ONLY_NAME CHARACTER VARYING(256) 256
81 INCIDENT_INSPECTION_REQUIRED_FLAG INTEGER 4
82 INCIDENT_INSPECTION_REQUIRED_NAME CHARACTER VARYING(256) 256
83 INCIDENT_MAKE_SAFE_REPAIR_REQUIRED_ID BIGINT 8
84 INCIDENT_MAKE_SAFE_REPAIR_REQUIRED_NAME CHARACTER VARYING(256) 256
85 INCIDENT_RECOVERY_INDICATOR_ID BIGINT 8
86 INCIDENT_RECOVERY_INDICATOR_NAME CHARACTER VARYING(256) 256
87 INCIDENT_EXTERNAL_ASSESSOR_FLAG INTEGER 4
88 INCIDENT_EXTERNAL_ASSESSOR_NAME CHARACTER VARYING(256) 256
89 INCIDENT_ASSESSMENT_CLAIMED_ITEM_BUILDING_FLAG INTEGER 4
90 INCIDENT_ASSESSMENT_CLAIMED_ITEM_BUILDING_FLAG_NAME CHARACTER VARYING(256) 256
91 INCIDENT_ASSESSMENT_CLAIMED_ITEM_CONTENT_FLAG INTEGER 4
92 INCIDENT_ASSESSMENT_CLAIMED_ITEM_CONTENT_FLAG_NAME CHARACTER VARYING(256) 256
93 INCIDENT_REPAIR_ESTIMATE_RECEIVED_STATUS BIGINT 8
94 INCIDENT_REPAIR_ESTIMATE_RECEIVED_STATUS_NAME CHARACTER VARYING(256) 256
95 INCIDENT_ID BIGINT 8