EHSI FINDING DETAIL NEW Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CARRIED_FROM_FINDING_ID |
XXX |
NUMBER |
30 |
CARRIED_TO_FINDING_ID |
XXX |
NUMBER |
30 |
EHSI_ACTION_TAKEN_KEY |
XXX |
NUMBER |
34 |
EHSI_CURRENT_ASSIGNEE_KEY |
XXX |
VARCHAR2 |
15 |
EHSI_FINDING_CATEGORY_KEY |
XXX |
VARCHAR2 |
35 |
EHSI_FINDING_ID |
XXX |
NUMBER |
20 |
EHSI_FINDING_LONG_TEXT |
XXX |
VARCHAR2 |
2500 |
EHSI_FINDING_ROOMS |
XXX |
VARCHAR2 |
1000 |
EHSI_FINDING_SORT |
XXX |
VARCHAR2 |
6 |
EHSI_FINDING_TYPE_KEY |
XXX |
NUMBER |
20 |
EHSI_HEADER_KEY |
XXX |
NUMBER |
20 |
EHSI_PREVIOUS_ASSIGNEE_KEY |
XXX |
VARCHAR2 |
15 |
FINDING_CREATE_DATE |
XXX |
DATE |
|
FINDING_CREATE_USER |
XXX |
VARCHAR2 |
12 |
FINDING_LAST_UPDATE_DATE |
XXX |
DATE |
|
FINDING_LAST_UPDATE_USER |
XXX |
VARCHAR2 |
12 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |