eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CSF.CSF_DEBRIEF_HEADERS

Object Details

Object Name:	CSF_DEBRIEF_HEADERS
Object Type:	TABLE
Owner:	CSF
FND Design Data:	CSF.CSF_DEBRIEF_HEADERS
Subobject Name:
Status:	VALID

CSF_DEBRIEF_HEADERS contains the header information about the Field service report ie the information that a field service engineer records during a field visit .
The primary key is CS_DEBRIEF_HEADER_ID and this is a foreign key into CS_DEBRIEF_LINES.
Each Task has resource assignments and each such task resource assignment is associated with a Field Service Report . Every Field service report header indicates an interaction with the customer.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSF_DEBRIEF_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEBRIEF_HEADER_ID
CSF_DEBRIEF_HEADERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEBRIEF_NUMBER
CSF_DEBRIEF_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_ASSIGNMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DEBRIEF_HEADER_ID	NUMBER		Yes	The unique identifier for header
DEBRIEF_NUMBER	VARCHAR2	(50)	Yes	The unique number for field service report
DEBRIEF_DATE	DATE		Yes	The field service report date
DEBRIEF_STATUS_ID	NUMBER			The Field Service Report status identifier
TASK_ASSIGNMENT_ID	NUMBER		Yes	The task assignment unique identifier
CREATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 1
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment for attribute 2
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 3
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 4
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 5
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 6
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 7
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 8
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 9
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 10
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 11
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 12
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 13
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 14
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment for attribute 15
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
SECURITY_GROUP_ID	NUMBER			Security group identifier
STATISTICS_UPDATED	VARCHAR2	(15)		Statistics Updated
PROCESSED_FLAG	VARCHAR2	(40)		Status of debrief while being processed
TRAVEL_START_TIME	DATE			Travel Start Time
TRAVEL_END_TIME	DATE			Travel End Time
OBJECT_VERSION_NUMBER	NUMBER			Object version number
TRAVEL_DISTANCE_IN_KM	NUMBER			Traveled distance stored in kilometers

Query Text

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


SELECT DEBRIEF_HEADER_ID
,      DEBRIEF_NUMBER
,      DEBRIEF_DATE
,      DEBRIEF_STATUS_ID
,      TASK_ASSIGNMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      SECURITY_GROUP_ID
,      STATISTICS_UPDATED
,      PROCESSED_FLAG
,      TRAVEL_START_TIME
,      TRAVEL_END_TIME
,      OBJECT_VERSION_NUMBER
,      TRAVEL_DISTANCE_IN_KM
FROM CSF.CSF_DEBRIEF_HEADERS;

Dependencies

[top of page]

CSF.CSF_DEBRIEF_HEADERS does not reference any database object

CSF.CSF_DEBRIEF_HEADERS is referenced by following:

APPS: CSF_DEBRIEF_HEADERS