1. Tables and Views for HCM
  2. HWM_TCD_EXP_DATA_PAY

HWM_TCD_EXP_DATA_PAY

This table contains details for Time Clock Device export data for Payroll Object

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_TCD_EXP_DATA_PAY_PK

PAY_DATA_ID, PAY_DATA_VERSION

Columns

Name Datatype Length Precision Not-null Comments
PAY_DATA_ID NUMBER 18 Yes System generated number to uniquely represent the payroll data record
TCD_EXP_DATA_ESS_PROCESS_ID NUMBER 18 Export process which generated the data
STATUS VARCHAR2 20 Export or Collection Data Status
DELETE_FLAG VARCHAR2 1 Used for soft delete of the row
PAY_DATA_VERSION NUMBER 9 Yes Version of the payroll data record
PAYROLL_TIME_TYPE VARCHAR2 150 Payroll time type
PERSON_ID NUMBER 18 Yes Person id
ELIGIBILITY VARCHAR2 1 The eligibility of the payroll time type for the persons
REC_TYPE VARCHAR2 10 The type of the record like created, modified, deleted
LATEST_VERSION VARCHAR2 1 LATEST_VERSION
SETUP_PROFILE_ID NUMBER 18 The setup profile id driving the export data collection.
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.
ENTERPRISE_ID NUMBER 18 Yes Enterprise id
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
HWM_TCD_EXP_DATA_PAY_U1 Unique Default PAY_DATA_ID, PAY_DATA_VERSION