Skip to content

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

TABLE: HR.DT_DATE_PROMPTS_TL

Object Details
Object Name: DT_DATE_PROMPTS_TL
Object Type: TABLE
Owner: HR
FND Design Data: TableDT.DT_DATE_PROMPTS_TL
Subobject Name:
Status: VALID


DT_DATE_PROMPTS holds the default prompts to use for the Effective
Start Date and Effective End Date columns of all DateTrack History
views in Oracle HRMS Release 11.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Primary Key: DT_DATE_PROMPTS_TL_PK
  1. ColumnLANGUAGE
  2. ColumnZD_EDITION_NAME
Indexes
Index Type Uniqueness Tablespace Column
DT_DATE_PROMPTS_TL_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnLANGUAGE
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
LANGUAGE VARCHAR2 (4) Yes Identifies the language of the prompt.
SOURCE_LANG VARCHAR2 (4) Yes Identifies the souce language of the prompt.
EFFECTIVE_END_PROMPT VARCHAR2 (80)
Default prompt for effective end date.
EFFECTIVE_START_PROMPT VARCHAR2 (80)
Default prompt for effective start date.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT LANGUAGE
,      SOURCE_LANG
,      EFFECTIVE_END_PROMPT
,      EFFECTIVE_START_PROMPT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ZD_EDITION_NAME
FROM HR.DT_DATE_PROMPTS_TL;

Dependencies

[top of page]

HR.DT_DATE_PROMPTS_TL does not reference any database object

HR.DT_DATE_PROMPTS_TL is referenced by following:

SchemaHR
ViewDT_DATE_PROMPTS_TL#