[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
BEN.BEN_TCS_REPORT_DETAILS does not reference any database object
BEN.BEN_TCS_REPORT_DETAILS is referenced by following:
|
|
|