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.

[Home] [Help]

VIEW: BEN.BEN_TCS_REPORT_DETAILS#

Source

View Text - Preformatted


select BENEFIT_ACTION_ID BENEFIT_ACTION_ID, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, JOB_NAME JOB_NAME, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME, FULL_NAME FULL_NAME, STMT_CREATED STMT_CREATED, ERROR ERROR, ELIGY_ID ELIGY_ID, ELIGY_PROF_NAME ELIGY_PROF_NAME, STMT_ID STMT_ID, STMT_NAME STMT_NAME, SETUP_VALID SETUP_VALID, TOTAL_PERSONS TOTAL_PERSONS, BEN_TCS_RPT_DET_ID BEN_TCS_RPT_DET_ID, ASSIGNMENT_ID ASSIGNMENT_ID, PERSON_ID PERSON_ID from "BEN"."BEN_TCS_REPORT_DETAILS"

View Text - HTML Formatted

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