[Home] [Help] [Dependency Information]
Object Name: | BEN_CWB_PP_SUM_DWLD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
View for providing content into the Compensation Workbench Post Process Enhanced Summary download.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_ID | NUMBER | Business Group Id | ||
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Business Group Name | |
TOTAL_EMPLOYEES_PROCD | NUMBER | Total Employees Procd | ||
ERRED_EMPLOYEES | NUMBER | Erred Employees | ||
SUCCESSFUL_EMPLOYEES | NUMBER | Successful Employees | ||
WARNED_EMPLOYEES | NUMBER | Warned Employees | ||
ELIG_EMPLOYEES | NUMBER | Elig Employees | ||
INELIG_EMPLOYEES | NUMBER | Inelig Employees | ||
STARTED | NUMBER | Started | ||
PROCESSED | NUMBER | Processed | ||
MESSAGE_NUMBER | NUMBER | Message Number | ||
ERROR_OR_WARNING_TEXT | VARCHAR2 | (2000) | Error Or Warning Text | |
MESSAGE_EMP_COUNT | NUMBER | Message Emp Count | ||
EMPLOYEES_RATED | NUMBER | Employees Rated | ||
TOTAL_ASG_CHANGES | NUMBER | Total Asg Changes | ||
PROPOSED_JOB | NUMBER | Proposed Job | ||
PROPOSED_POSITION | NUMBER | Proposed Position | ||
PROPOSED_GRADE | NUMBER | Proposed Grade | ||
PROPOSED_GROUP | NUMBER | Proposed Group | ||
PROPOSED_FLEX1 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX2 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX3 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX4 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX5 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX6 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX7 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX8 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX9 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX10 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX11 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX12 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX13 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX14 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX15 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX16 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX17 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX18 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX19 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX20 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX21 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX22 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX23 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX24 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX25 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX26 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX27 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX28 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX29 | NUMBER | Proposed Flexfield Column | ||
PROPOSED_FLEX30 | NUMBER | Proposed Flexfield Column | ||
ELIGIBLE_COUNT | NUMBER | Eligible Count | ||
PAID_COUNT | NUMBER | Paid Count | ||
PROGRAM_NAME_H | VARCHAR2 | (240) | Program Name H | |
PROCESS_DATE_H | DATE | Yes | Program Name H | |
START_TIME_H | VARCHAR2 | (90) | Start Time H | |
END_TIME_H | VARCHAR2 | (90) | End Time H | |
PLAN_NAME_H | VARCHAR2 | (240) | Plan Name H | |
LIFE_EVENT_OCCURRED_DATE_H | VARCHAR2 | (240) | Life Event Occurred Date H | |
VALIDATE_FLAG_H | VARCHAR2 | (80) | Validate Flag H | |
AUDIT_LOG_FLAG_H | VARCHAR2 | (80) | Validate Flag H | |
DEBUG_MESSAGES_FLAG_H | VARCHAR2 | (80) | Debug Messages Flag H | |
PERSON_NAME_H | VARCHAR2 | (240) | Person Name H | |
MANAGER_NAME_H | VARCHAR2 | (240) | Manager Name H | |
BUSINESS_GROUP_NAME_H | VARCHAR2 | (240) | Business Group Name H |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_ID
, BUSINESS_GROUP_NAME
, TOTAL_EMPLOYEES_PROCD
, ERRED_EMPLOYEES
, SUCCESSFUL_EMPLOYEES
, WARNED_EMPLOYEES
, ELIG_EMPLOYEES
, INELIG_EMPLOYEES
, STARTED
, PROCESSED
, MESSAGE_NUMBER
, ERROR_OR_WARNING_TEXT
, MESSAGE_EMP_COUNT
, EMPLOYEES_RATED
, TOTAL_ASG_CHANGES
, PROPOSED_JOB
, PROPOSED_POSITION
, PROPOSED_GRADE
, PROPOSED_GROUP
, PROPOSED_FLEX1
, PROPOSED_FLEX2
, PROPOSED_FLEX3
, PROPOSED_FLEX4
, PROPOSED_FLEX5
, PROPOSED_FLEX6
, PROPOSED_FLEX7
, PROPOSED_FLEX8
, PROPOSED_FLEX9
, PROPOSED_FLEX10
, PROPOSED_FLEX11
, PROPOSED_FLEX12
, PROPOSED_FLEX13
, PROPOSED_FLEX14
, PROPOSED_FLEX15
, PROPOSED_FLEX16
, PROPOSED_FLEX17
, PROPOSED_FLEX18
, PROPOSED_FLEX19
, PROPOSED_FLEX20
, PROPOSED_FLEX21
, PROPOSED_FLEX22
, PROPOSED_FLEX23
, PROPOSED_FLEX24
, PROPOSED_FLEX25
, PROPOSED_FLEX26
, PROPOSED_FLEX27
, PROPOSED_FLEX28
, PROPOSED_FLEX29
, PROPOSED_FLEX30
, ELIGIBLE_COUNT
, PAID_COUNT
, PROGRAM_NAME_H
, PROCESS_DATE_H
, START_TIME_H
, END_TIME_H
, PLAN_NAME_H
, LIFE_EVENT_OCCURRED_DATE_H
, VALIDATE_FLAG_H
, AUDIT_LOG_FLAG_H
, DEBUG_MESSAGES_FLAG_H
, PERSON_NAME_H
, MANAGER_NAME_H
, BUSINESS_GROUP_NAME_H
FROM APPS.BEN_CWB_PP_SUM_DWLD_V;
APPS.BEN_CWB_PP_SUM_DWLD_V is not referenced by any database object
|
|
|