EHSI HEADER NEW Table
View exposing EHS inspection header detail using the newer inspection structure including inspection type, status, overall rating, room-set attributes, DLC and school-area information, PI and EHS representative contact information, follow-up indicator, and audit fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_CODE |
Code identifying dlc. |
VARCHAR2 |
20 |
DLC_NAME |
Dlc name associated with the record. |
VARCHAR2 |
60 |
EHSI_HEADER_KEY |
Surrogate key identifying the ehsi header. |
NUMBER |
20 |
EHSI_ROOM_SET_KEY |
Surrogate key identifying the ehsi room set. |
NUMBER |
20 |
EHS_REP_EMAIL |
Ehs rep email associated with the record. |
VARCHAR2 |
100 |
EHS_REP_FULL_NAME |
Ehs rep full name associated with the record. |
VARCHAR2 |
100 |
EHS_REP_MIT_ID |
Business identifier for the ehs rep mit. |
VARCHAR2 |
9 |
INSPECTION_CYCLE |
Inspection cycle associated with the record. |
VARCHAR2 |
100 |
INSPECTION_DATE |
Date associated with inspection. |
DATE |
|
INSPECTION_DESCRIPTION |
Description of inspection. |
VARCHAR2 |
60 |
INSPECTION_ID |
Business identifier for the inspection. |
NUMBER |
20 |
INSPECTION_OVERALL_RATING |
Inspection overall rating associated with the record. |
VARCHAR2 |
30 |
INSPECTION_STATUS |
Inspection status associated with the record. |
VARCHAR2 |
30 |
INSPECTION_TYPE |
Inspection type associated with the record. |
VARCHAR2 |
150 |
INSPECTION_TYPE_ID |
Business identifier for the inspection type. |
NUMBER |
10 |
INSP_HEADER_CREATE_DATE |
Date associated with insp header create. |
DATE |
|
INSP_HEADER_CREATE_USER |
Insp header create user associated with the record. |
VARCHAR2 |
12 |
INSP_LAST_UPDATE_DATE |
Date associated with insp last update. |
DATE |
|
INSP_LAST_UPDATE_USER |
Insp last update user associated with the record. |
VARCHAR2 |
12 |
IS_FOLLOW_UP_REQUIRED |
Indicator identifying whether follow up required (Y/N). |
VARCHAR2 |
1 |
PI_EMAIL |
Pi email associated with the record. |
VARCHAR2 |
100 |
PI_FULL_NAME |
Pi full name associated with the record. |
VARCHAR2 |
100 |
PI_MIT_ID |
Business identifier for the pi mit. |
VARCHAR2 |
9 |
PI_TITLE |
Pi title associated with the record. |
VARCHAR2 |
100 |
REPORT_SUBMISSION_DATE |
Date associated with report submission. |
DATE |
|
ROOM_SET_NAME |
Room set name associated with the record. |
VARCHAR2 |
60 |
SCHOOL_AREA_NAME |
School area name associated with the record. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |