DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PER_ABS_ATTENDANCE_TYPES_TL

Object Details
Object Name: PER_ABS_ATTENDANCE_TYPES_TL
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_ABS_ATTENDANCE_TYPES_TL
Subobject Name:
Status: VALID


Holds translated information for Absence Types


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PER_ABS_ATTENDANCE_TYPES_TL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnABSENCE_ATTENDANCE_TYPE_ID
ColumnLANGUAGE
PER_ABS_ATTENDANCE_TYP_TL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
ABSENCE_ATTENDANCE_TYPE_ID NUMBER (9) Yes System generated primary key column
LANGUAGE VARCHAR2 (4) Yes Language of this row, part of the system primary key
SOURCE_LANG VARCHAR2 (4) Yes Language from which this row was copied
NAME VARCHAR2 (30) Yes Translated name of Absence Type
CREATED_BY NUMBER (15)
Standard AOL Audit Column
CREATION_DATE DATE

Standard AOL Audit Column
LAST_UPDATED_BY NUMBER (15)
Standard AOL Audit Column
LAST_UPDATE_DATE DATE

Standard AOL Audit Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard AOL Audit Column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ABSENCE_ATTENDANCE_TYPE_ID
,      LANGUAGE
,      SOURCE_LANG
,      NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HR.PER_ABS_ATTENDANCE_TYPES_TL;

Dependencies

[top of page]

HR.PER_ABS_ATTENDANCE_TYPES_TL does not reference any database object

HR.PER_ABS_ATTENDANCE_TYPES_TL is referenced by following:

SchemaAPPS
TriggerPER_ABS_ATTENDANCE_T041308_WHO
SynonymPER_ABS_ATTENDANCE_TYPES_TL
SchemaPUBLIC
SynonymPER_ABS_ATTENDANCE_TYPES_TL