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_TCS_REPORT_DETAILS

Object Details

Object Name:	BEN_TCS_REPORT_DETAILS
Object Type:	TABLE
Owner:	BEN
FND Design Data:	BEN.BEN_TCS_REPORT_DETAILS
Subobject Name:
Status:	VALID

BEN_TCS_REPORT_DETAILS identifies the Statment Generation request's details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_TCS_REPORT_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BEN_TCS_RPT_DET_ID
BEN_TCS_REPORT_DET_BBID_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BENEFIT_ACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BENEFIT_ACTION_ID	NUMBER	(15)	Yes	Foreign key to BEN_BENEFIT_ACTIONS
ASSIGNMENT_NUMBER	VARCHAR2	(30)		Assignment Number
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee Number
JOB_NAME	VARCHAR2	(240)		Job Name
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ALL_ORGANIZATION_UNITS
BUSINESS_GROUP_NAME	VARCHAR2	(240)		Business group name
FULL_NAME	VARCHAR2	(240)		Employee full name
STMT_CREATED	VARCHAR2	(30)		Flag to indicate whether a statement is created
ERROR	VARCHAR2	(2000)		Errors encountered during statement generation.
ELIGY_ID	NUMBER	(15)		Foreign key to BEN_ELIGY_PRFL_F
ELIGY_PROF_NAME	VARCHAR2	(240)		Eligibility profile name
STMT_ID	NUMBER	(15)		Foreign key to BEN_TCS_STMT
STMT_NAME	VARCHAR2	(240)		Statement Name
SETUP_VALID	VARCHAR2	(30)		Flag to indicate whether the statement setup is valid.
TOTAL_PERSONS	NUMBER	(15)		Total number of persons processed.
BEN_TCS_RPT_DET_ID	NUMBER	(15)	Yes	Sequence generated primary key
ASSIGNMENT_ID	NUMBER	(15)		Foreign key to PER_ALL_ASSIGNMENTS_F
PERSON_ID	NUMBER	(15)		Foreign key to PER_ALL_PEOPLE_F

Query Text

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


SELECT BENEFIT_ACTION_ID
,      ASSIGNMENT_NUMBER
,      EMPLOYEE_NUMBER
,      JOB_NAME
,      BUSINESS_GROUP_ID
,      BUSINESS_GROUP_NAME
,      FULL_NAME
,      STMT_CREATED
,      ERROR
,      ELIGY_ID
,      ELIGY_PROF_NAME
,      STMT_ID
,      STMT_NAME
,      SETUP_VALID
,      TOTAL_PERSONS
,      BEN_TCS_RPT_DET_ID
,      ASSIGNMENT_ID
,      PERSON_ID
FROM BEN.BEN_TCS_REPORT_DETAILS;

Dependencies

[top of page]

BEN.BEN_TCS_REPORT_DETAILS does not reference any database object

BEN.BEN_TCS_REPORT_DETAILS is referenced by following:

BEN: BEN_TCS_REPORT_DETAILS#