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

TABLE: CSD.CSD_DIAGNOSTIC_CODES_TL

Object Details
Object Name: CSD_DIAGNOSTIC_CODES_TL
Object Type: TABLE
Owner: CSD
FND Design Data: TableCSD.CSD_DIAGNOSTIC_CODES_TL
Subobject Name:
Status: VALID


Stores translated attributes for Diagnostic Codes


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSD_DIAGNOSTIC_CODES_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDIAGNOSTIC_CODE_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
DIAGNOSTIC_CODE_ID NUMBER
Yes Primary Key
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
NAME VARCHAR2 (80) Yes Diagnostic Code name
DESCRIPTION VARCHAR2 (240)
Diagnostic Code description
LANGUAGE VARCHAR2 (4) Yes Language code for the text
SOURCE_LANG VARCHAR2 (4)
The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
Query Text

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


SELECT DIAGNOSTIC_CODE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NAME
,      DESCRIPTION
,      LANGUAGE
,      SOURCE_LANG
FROM CSD.CSD_DIAGNOSTIC_CODES_TL;

Dependencies

[top of page]

CSD.CSD_DIAGNOSTIC_CODES_TL does not reference any database object

CSD.CSD_DIAGNOSTIC_CODES_TL is referenced by following:

SchemaAPPS
SynonymCSD_DIAGNOSTIC_CODES_TL