1. Tables and Views for HCM
  2. HXT_TM_MTRX_DLY_ATRS

HXT_TM_MTRX_DLY_ATRS

This table will contain the timecard attributes for each additional detail entry in the HXT_TM_MTRX_DLY_ATR_LNKS table. Thus we will have 1..* association between HXT_TM_MTRX_DLY_ATR_LNKS and HXT_TM_MTRX_DLY_ATRS.

Details

  • Schema: FUSION

  • Object owner: HXT

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

HXT_TM_MTRX_DLY_ATRS_PK

TM_MTRX_DLY_ATR_ID

Columns

Name Datatype Length Precision Not-null Comments Status
TM_MTRX_DLY_ATR_ID NUMBER 18 Yes Primary Key Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
TM_MTRX_ROW_ID NUMBER 18 Yes TM_MTRX_ROW_ID
DETAIL_ENTRY_DAY NUMBER Yes DETAIL_ENTRY_DAY
DAILY_COMMENT VARCHAR2 2000 DAILY_COMMENT
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE_CHAR1 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR1_VALUE VARCHAR2 350 ATTRIBUTE_CHAR1_VALUE
ATTRIBUTE_CHAR2 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR2_VALUE VARCHAR2 350 ATTRIBUTE_CHAR2_VALUE
ATTRIBUTE_CHAR3 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR3_VALUE VARCHAR2 350 ATTRIBUTE_CHAR3_VALUE
ATTRIBUTE_CHAR4 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR4_VALUE VARCHAR2 350 ATTRIBUTE_CHAR4_VALUE
ATTRIBUTE_CHAR5 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR5_VALUE VARCHAR2 350 ATTRIBUTE_CHAR5_VALUE
ATTRIBUTE_CHAR6 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR6_VALUE VARCHAR2 350 ATTRIBUTE_CHAR6_VALUE
ATTRIBUTE_CHAR7 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR7_VALUE VARCHAR2 350 ATTRIBUTE_CHAR7_VALUE
ATTRIBUTE_CHAR8 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR8_VALUE VARCHAR2 350 ATTRIBUTE_CHAR8_VALUE
ATTRIBUTE_CHAR9 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR9_VALUE VARCHAR2 350 ATTRIBUTE_CHAR9_VALUE
ATTRIBUTE_CHAR10 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR10_VALUE VARCHAR2 350 ATTRIBUTE_CHAR10_VALUE
ATTRIBUTE_CHAR11 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR11_VALUE VARCHAR2 350 ATTRIBUTE_CHAR11_VALUE
ATTRIBUTE_CHAR12 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR12_VALUE VARCHAR2 350 ATTRIBUTE_CHAR12_VALUE
ATTRIBUTE_CHAR13 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR13_VALUE VARCHAR2 350 ATTRIBUTE_CHAR13_VALUE
ATTRIBUTE_CHAR14 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR14_VALUE VARCHAR2 350 ATTRIBUTE_CHAR14_VALUE
ATTRIBUTE_CHAR15 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR15_VALUE VARCHAR2 350 ATTRIBUTE_CHAR15_VALUE
ATTRIBUTE_CHAR16 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR16_VALUE VARCHAR2 350 ATTRIBUTE_CHAR16_VALUE
ATTRIBUTE_CHAR17 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR17_VALUE VARCHAR2 350 ATTRIBUTE_CHAR17_VALUE
ATTRIBUTE_CHAR18 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR18_VALUE VARCHAR2 350 ATTRIBUTE_CHAR18_VALUE
ATTRIBUTE_CHAR19 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR19_VALUE VARCHAR2 350 ATTRIBUTE_CHAR19_VALUE
ATTRIBUTE_CHAR20 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR20_VALUE VARCHAR2 350 ATTRIBUTE_CHAR20_VALUE
ATTRIBUTE_CHAR21 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR21_VALUE VARCHAR2 350 ATTRIBUTE_CHAR21_VALUE
ATTRIBUTE_CHAR22 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR22_VALUE VARCHAR2 350 ATTRIBUTE_CHAR22_VALUE
ATTRIBUTE_CHAR23 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR23_VALUE VARCHAR2 350 ATTRIBUTE_CHAR23_VALUE
ATTRIBUTE_CHAR24 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR24_VALUE VARCHAR2 350 ATTRIBUTE_CHAR24_VALUE
ATTRIBUTE_CHAR25 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR25_VALUE VARCHAR2 350 ATTRIBUTE_CHAR25_VALUE
ATTRIBUTE_CHAR26 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR26_VALUE VARCHAR2 350 ATTRIBUTE_CHAR26_VALUE
ATTRIBUTE_CHAR27 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR27_VALUE VARCHAR2 350 ATTRIBUTE_CHAR27_VALUE
ATTRIBUTE_CHAR28 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR28_VALUE VARCHAR2 350 ATTRIBUTE_CHAR28_VALUE
ATTRIBUTE_CHAR29 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR29_VALUE VARCHAR2 350 ATTRIBUTE_CHAR29_VALUE
ATTRIBUTE_CHAR30 VARCHAR2 350 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR30_VALUE VARCHAR2 350 ATTRIBUTE_CHAR30_VALUE
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER1_VALUE
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER2_VALUE
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER3_VALUE
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER4_VALUE
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER5_VALUE
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER6_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER6_VALUE
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER7_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER7_VALUE
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER8_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER8_VALUE
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER9_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER9_VALUE
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER10_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER10_VALUE
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER11_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER11_VALUE
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER12_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER12_VALUE
ATTRIBUTE_NUMBER13 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER13_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER13_VALUE
ATTRIBUTE_NUMBER14 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER14_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER14_VALUE
ATTRIBUTE_NUMBER15 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER15_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER15_VALUE
ATTRIBUTE_NUMBER16 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER16_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER16_VALUE
ATTRIBUTE_NUMBER17 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER17_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER17_VALUE
ATTRIBUTE_NUMBER18 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER18_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER18_VALUE
ATTRIBUTE_NUMBER19 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER19_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER19_VALUE
ATTRIBUTE_NUMBER20 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER20_VALUE VARCHAR2 350 ATTRIBUTE_NUMBER20_VALUE
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1_VALUE VARCHAR2 150 ATTRIBUTE_DATE1_VALUE
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2_VALUE VARCHAR2 150 ATTRIBUTE_DATE2_VALUE
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3_VALUE VARCHAR2 150 ATTRIBUTE_DATE3_VALUE
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4_VALUE VARCHAR2 150 ATTRIBUTE_DATE4_VALUE
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5_VALUE VARCHAR2 150 ATTRIBUTE_DATE5_VALUE
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE6_VALUE VARCHAR2 150 ATTRIBUTE_DATE6_VALUE
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE7_VALUE VARCHAR2 150 ATTRIBUTE_DATE7_VALUE
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE8_VALUE VARCHAR2 150 ATTRIBUTE_DATE8_VALUE
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE9_VALUE VARCHAR2 150 ATTRIBUTE_DATE9_VALUE
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE10_VALUE VARCHAR2 150 ATTRIBUTE_DATE10_VALUE
ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE11_VALUE VARCHAR2 150 ATTRIBUTE_DATE11_VALUE
ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE12_VALUE VARCHAR2 150 ATTRIBUTE_DATE12_VALUE
ATTRIBUTE_DATE13 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE13_VALUE VARCHAR2 150 ATTRIBUTE_DATE13_VALUE
ATTRIBUTE_DATE14 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE14_VALUE VARCHAR2 150 ATTRIBUTE_DATE14_VALUE
ATTRIBUTE_DATE15 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE15_VALUE VARCHAR2 150 ATTRIBUTE_DATE15_VALUE
OWNER VARCHAR2 150 It stores owner information from where the timecard is entered.
INTERNAL_SOURCE VARCHAR2 150 It stores the internal information of a timecard.
START_TIMEZONE_CODE VARCHAR2 50 START_TIMEZONE_CODE
STOP_TIMEZONE_CODE VARCHAR2 50 STOP_TIMEZONE_CODE
START_GMT_OFFSET NUMBER 22 START_GMT_OFFSET
STOP_GMT_OFFSET NUMBER 22 STOP_GMT_OFFSET

Foreign Keys

Table Foreign Table Foreign Key Column
HXT_TM_MTRX_DLY_ATRS hxt_tm_mtrx TM_MTRX_ROW_ID

Indexes

Index Uniqueness Tablespace Columns
HXT_TM_MTRX_DLY_ATRS_N1 Non Unique Default TM_MTRX_ROW_ID
HXT_TM_MTRX_DLY_ATRS_PK Unique Default TM_MTRX_DLY_ATR_ID