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: BEN.BEN_DM_INPUT_FILE

Object Details

Object Name:	BEN_DM_INPUT_FILE
Object Type:	TABLE
Owner:	BEN
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_DM_INPUT_FILE_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	INPUT_FILE_ID
BEN_DM_INPUT_FILE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ORDER

Columns

Name	Datatype	Length	Mandatory	Comments
INPUT_FILE_ID	NUMBER	(15)	Yes	Primary Key
SOURCE_BUSINESS_GROUP_NAME	VARCHAR2	(80)	Yes	Business Group for the Participant in the Source Database
SOURCE_NATIONAL_IDENTIFIER	VARCHAR2	(80)	Yes
SOURCE_PERSON_ID	NUMBER	(15)	Yes	Source PER_ALL_PEOPLE_F.PERSON_ID of the Participant
TARGET_PERSON_ID	NUMBER	(15)		Target PER_ALL_PEOPLE_F.PERSON_ID of the Participant
TARGET_BUSINESS_GROUP_NAME	VARCHAR2	(80)	Yes	Business Group for the Participant in the Target Database
TARGET_NATIONAL_IDENTIFIER	VARCHAR2	(80)		Target National Identifier if the Participant will be replicated.
GROUP_ORDER	NUMBER	(15)		Group Order for the Upload. All Related Participant and Dependants will be processed by a single thread.
PERSON_TYPE	VARCHAR2	(1)		P - Participant, D - Dependant
DATA_SOURCE	VARCHAR2	(1)		I - Input file, D - Derived
STATUS	VARCHAR2	(30)		Status
LAST_UPDATE_DATE	DATE			WHO column
LAST_UPDATED_BY	NUMBER	(15)		WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		WHO column
CREATED_BY	NUMBER	(15)		WHO column
CREATION_DATE	DATE			WHO column

Query Text

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


SELECT INPUT_FILE_ID
,      SOURCE_BUSINESS_GROUP_NAME
,      SOURCE_NATIONAL_IDENTIFIER
,      SOURCE_PERSON_ID
,      TARGET_PERSON_ID
,      TARGET_BUSINESS_GROUP_NAME
,      TARGET_NATIONAL_IDENTIFIER
,      GROUP_ORDER
,      PERSON_TYPE
,      DATA_SOURCE
,      STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM BEN.BEN_DM_INPUT_FILE;

Dependencies

[top of page]

BEN.BEN_DM_INPUT_FILE does not reference any database object

BEN.BEN_DM_INPUT_FILE is referenced by following:

APPS: BEN_DM_INPUT_FILE; BEN_DM_INPUT_FILE_WHO