HRT_NOTES

Details

Schema: FUSION
Object owner: HRT
Object type: VIEW

Columns

Name
NOTE_ID ENTERPRISE_ID NOTE_TYPE_CODE NOTE_TEXT OBJECT_TYPE OBJECT_ID AUTHOR_ID VISIBILITY_FLAG NOTE_LAST_UPDATE_DATE NOTE_CREATION_DATE OBJECT_VERSION_NUMBER ATTRIBUTE_CATEGORY ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 ATTRIBUTE_DATE13 ATTRIBUTE_DATE14 ATTRIBUTE_DATE15 ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATION_DATE HIDDEN_FLAG RECEIVER_ID ACTIVE_FLAG CONTEXT_TYPE CONTEXT_ID NOTE_VISIBILITY_CODE CONTEXT_NAME_VO CONTEXT_TYPE2 CONTEXT_ID2 CONTEXT_NAME_VO2 NOTE_TEXT_AUDIT CARD_TITLE IMAGE_REFERENCE_URL REFERENCE_COUNT

Name

NOTE_ID

ENTERPRISE_ID

NOTE_TYPE_CODE

NOTE_TEXT

OBJECT_TYPE

OBJECT_ID

AUTHOR_ID

VISIBILITY_FLAG

NOTE_LAST_UPDATE_DATE

NOTE_CREATION_DATE

OBJECT_VERSION_NUMBER

ATTRIBUTE_CATEGORY

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_NUMBER11

ATTRIBUTE_NUMBER12

ATTRIBUTE_NUMBER13

ATTRIBUTE_NUMBER14

ATTRIBUTE_NUMBER15

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_DATE11

ATTRIBUTE_DATE12

ATTRIBUTE_DATE13

ATTRIBUTE_DATE14

ATTRIBUTE_DATE15

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

CREATION_DATE

HIDDEN_FLAG

RECEIVER_ID

ACTIVE_FLAG

CONTEXT_TYPE

CONTEXT_ID

NOTE_VISIBILITY_CODE

CONTEXT_NAME_VO

CONTEXT_TYPE2

CONTEXT_ID2

CONTEXT_NAME_VO2

NOTE_TEXT_AUDIT

CARD_TITLE

IMAGE_REFERENCE_URL

REFERENCE_COUNT

Query

SQL_Statement
SELECT "NOTE_ID", "ENTERPRISE_ID", "NOTE_TYPE_CODE", "NOTE_TEXT", "OBJECT_TYPE", "OBJECT_ID", "AUTHOR_ID", "VISIBILITY_FLAG", "NOTE_LAST_UPDATE_DATE", "NOTE_CREATION_DATE", "OBJECT_VERSION_NUMBER", "ATTRIBUTE_CATEGORY", "ATTRIBUTE_NUMBER1", "ATTRIBUTE_NUMBER2", "ATTRIBUTE_NUMBER3", "ATTRIBUTE_NUMBER4", "ATTRIBUTE_NUMBER5", "ATTRIBUTE_NUMBER6", "ATTRIBUTE_NUMBER7", "ATTRIBUTE_NUMBER8", "ATTRIBUTE_NUMBER9", "ATTRIBUTE_NUMBER10", "ATTRIBUTE_NUMBER11", "ATTRIBUTE_NUMBER12", "ATTRIBUTE_NUMBER13", "ATTRIBUTE_NUMBER14", "ATTRIBUTE_NUMBER15", "ATTRIBUTE_DATE1", "ATTRIBUTE_DATE2", "ATTRIBUTE_DATE3", "ATTRIBUTE_DATE4", "ATTRIBUTE_DATE5", "ATTRIBUTE_DATE6", "ATTRIBUTE_DATE7", "ATTRIBUTE_DATE8", "ATTRIBUTE_DATE9", "ATTRIBUTE_DATE10", "ATTRIBUTE_DATE11", "ATTRIBUTE_DATE12", "ATTRIBUTE_DATE13", "ATTRIBUTE_DATE14", "ATTRIBUTE_DATE15", "ATTRIBUTE1", "ATTRIBUTE2", "ATTRIBUTE3", "ATTRIBUTE4", "ATTRIBUTE5", "ATTRIBUTE6", "ATTRIBUTE7", "ATTRIBUTE8", "ATTRIBUTE9", "ATTRIBUTE10", "ATTRIBUTE11", "ATTRIBUTE12", "ATTRIBUTE13", "ATTRIBUTE14", "ATTRIBUTE15", "CREATED_BY", "LAST_UPDATED_BY", "LAST_UPDATE_DATE", "LAST_UPDATE_LOGIN", "CREATION_DATE", "HIDDEN_FLAG", "RECEIVER_ID", "ACTIVE_FLAG", "CONTEXT_TYPE", "CONTEXT_ID", "NOTE_VISIBILITY_CODE", "CONTEXT_NAME_VO", "CONTEXT_TYPE2", "CONTEXT_ID2", "CONTEXT_NAME_VO2", "NOTE_TEXT_AUDIT", "CARD_TITLE", "IMAGE_REFERENCE_URL", "REFERENCE_COUNT" FROM HRT_NOTES

SQL_Statement

SELECT

"NOTE_ID",

"ENTERPRISE_ID",

"NOTE_TYPE_CODE",

"NOTE_TEXT",

"OBJECT_TYPE",

"OBJECT_ID",

"AUTHOR_ID",

"VISIBILITY_FLAG",

"NOTE_LAST_UPDATE_DATE",

"NOTE_CREATION_DATE",

"OBJECT_VERSION_NUMBER",

"ATTRIBUTE_CATEGORY",

"ATTRIBUTE_NUMBER1",

"ATTRIBUTE_NUMBER2",

"ATTRIBUTE_NUMBER3",

"ATTRIBUTE_NUMBER4",

"ATTRIBUTE_NUMBER5",

"ATTRIBUTE_NUMBER6",

"ATTRIBUTE_NUMBER7",

"ATTRIBUTE_NUMBER8",

"ATTRIBUTE_NUMBER9",

"ATTRIBUTE_NUMBER10",

"ATTRIBUTE_NUMBER11",

"ATTRIBUTE_NUMBER12",

"ATTRIBUTE_NUMBER13",

"ATTRIBUTE_NUMBER14",

"ATTRIBUTE_NUMBER15",

"ATTRIBUTE_DATE1",

"ATTRIBUTE_DATE2",

"ATTRIBUTE_DATE3",

"ATTRIBUTE_DATE4",

"ATTRIBUTE_DATE5",

"ATTRIBUTE_DATE6",

"ATTRIBUTE_DATE7",

"ATTRIBUTE_DATE8",

"ATTRIBUTE_DATE9",

"ATTRIBUTE_DATE10",

"ATTRIBUTE_DATE11",

"ATTRIBUTE_DATE12",

"ATTRIBUTE_DATE13",

"ATTRIBUTE_DATE14",

"ATTRIBUTE_DATE15",

"ATTRIBUTE1",

"ATTRIBUTE2",

"ATTRIBUTE3",

"ATTRIBUTE4",

"ATTRIBUTE5",

"ATTRIBUTE6",

"ATTRIBUTE7",

"ATTRIBUTE8",

"ATTRIBUTE9",

"ATTRIBUTE10",

"ATTRIBUTE11",

"ATTRIBUTE12",

"ATTRIBUTE13",

"ATTRIBUTE14",

"ATTRIBUTE15",

"CREATED_BY",

"LAST_UPDATED_BY",

"LAST_UPDATE_DATE",

"LAST_UPDATE_LOGIN",

"CREATION_DATE",

"HIDDEN_FLAG",

"RECEIVER_ID",

"ACTIVE_FLAG",

"CONTEXT_TYPE",

"CONTEXT_ID",

"NOTE_VISIBILITY_CODE",

"CONTEXT_NAME_VO",

"CONTEXT_TYPE2",

"CONTEXT_ID2",

"CONTEXT_NAME_VO2",

"NOTE_TEXT_AUDIT",

"CARD_TITLE",

"IMAGE_REFERENCE_URL",

"REFERENCE_COUNT"

FROM

HRT_NOTES