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]

VIEW: APPS.BENBV_CWB_PERSON_INFO_V

Object Details

Object Name:	BENBV_CWB_PERSON_INFO_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BENBV_CWB_PERSON_INFO_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EFFECTIVE_DATE	DATE			Effective Date.
FULL_NAME	VARCHAR2	(240)		Employee Full Name.
BRIEF_NAME	VARCHAR2	(360)		Employee Brief Name.
CUSTOM_NAME	VARCHAR2	(480)		Employee Custom Name.
SUPERVISOR_FULL_NAME	VARCHAR2	(240)		Manager Full Name.
SUPERVISOR_BRIEF_NAME	VARCHAR2	(360)		Manager Brief Name.
SUPERVISOR_CUSTOM_NAME	VARCHAR2	(480)		Manager Custom Name.
LEGISLATION_CODE	VARCHAR2	(30)		Legislation Code.
YEARS_EMPLOYED	NUMBER			Years Employed.
YEARS_IN_JOB	NUMBER			Years in Job.
YEARS_IN_POSITION	NUMBER			Years in Position.
YEARS_IN_GRADE	NUMBER			Years in Grade.
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee Number.
START_DATE	DATE			Start Date.
ORIGINAL_START_DATE	DATE			Original Start Date.
ADJUSTED_SVC_DATE	DATE			Adjusted Service Date.
BASE_SALARY	NUMBER			Base Salary.
BASE_SALARY_CHANGE_DATE	DATE			Salary Change Date.
PAYROLL_NAME	VARCHAR2	(80)		Payroll.
PERFORMANCE_RATING	VARCHAR2	(30)		Performance Rating.
PERFORMANCE_RATING_TYPE	VARCHAR2	(30)		Performance Rating Type.
PERFORMANCE_RATING_DATE	DATE			Performance Rating Date.
GRADE_ANNULIZATION_FACTOR	NUMBER			Grade Annualization Factor .
PAY_ANNULIZATION_FACTOR	NUMBER			Pay Annualization Factor.
GRD_MIN_VAL	NUMBER			Grade Min.
GRD_MAX_VAL	NUMBER			Grade Max.
GRD_MID_POINT	NUMBER			Grade Mid.
EMP_CATEGORY	VARCHAR2	(30)		Employment Category.
CHANGE_REASON	VARCHAR2	(30)		Assignment Change Reason.
NORMAL_HOURS	NUMBER			Normal Hours.
EMAIL_ADDRESS	VARCHAR2	(240)		Email Address.
CUSTOM_SEGMENT1	VARCHAR2	(150)		Custom Segment
CUSTOM_SEGMENT2	VARCHAR2	(150)		Custom Segment
CUSTOM_SEGMENT3	VARCHAR2	(150)		Custom Segment
CUSTOM_SEGMENT4	VARCHAR2	(150)		Custom Segment
CUSTOM_SEGMENT5	VARCHAR2	(150)		Custom Segment
CUSTOM_SEGMENT6	VARCHAR2	(150)		Custom Segment
CUSTOM_SEGMENT7	VARCHAR2	(150)		Custom Segment
CUSTOM_SEGMENT8	VARCHAR2	(150)		Custom Segment
CUSTOM_SEGMENT9	VARCHAR2	(150)		Custom Segment
CUSTOM_SEGMENT10	VARCHAR2	(150)		Custom Segment
WS_COMMENTS	VARCHAR2	(2000)		Worksheet Comments.
FREQUENCY	VARCHAR2	(30)		Frequency
GRD_QUARTILE	VARCHAR2	(30)		Grade Quartile
GRD_COMPARATIO	NUMBER			Grade Comparison Ratio
CUSTOM_SEGMENT11	NUMBER			Custom Segment
CUSTOM_SEGMENT12	NUMBER			Custom Segment
CUSTOM_SEGMENT13	NUMBER			Custom Segment
CUSTOM_SEGMENT14	NUMBER			Custom Segment
CUSTOM_SEGMENT15	NUMBER			Custom Segment
PEOPLE_GROUP_NAME	VARCHAR2	(240)		People Group Name
PEOPLE_GROUP_SEGMENT1	VARCHAR2	(60)		People Group Segment
PEOPLE_GROUP_SEGMENT2	VARCHAR2	(60)		People Group Segment
PEOPLE_GROUP_SEGMENT3	VARCHAR2	(60)		People Group Segment
PEOPLE_GROUP_SEGMENT4	VARCHAR2	(60)		People Group Segment
PEOPLE_GROUP_SEGMENT5	VARCHAR2	(60)		People Group Segment
PEOPLE_GROUP_SEGMENT6	VARCHAR2	(60)		People Group Segment
PEOPLE_GROUP_SEGMENT7	VARCHAR2	(60)		People Group Segment
PEOPLE_GROUP_SEGMENT8	VARCHAR2	(60)		People Group Segment
PEOPLE_GROUP_SEGMENT9	VARCHAR2	(60)		People Group Segment
PEOPLE_GROUP_SEGMENT10	VARCHAR2	(60)		People Group Segment
PEOPLE_GROUP_SEGMENT11	VARCHAR2	(60)		People Group Segment
BASE_SALARY_FREQUENCY	VARCHAR2	(30)		Base Salary Frequency.
NEW_ASSGN_OVN	NUMBER	(9)		New Assignment Object Version Number
FEEDBACK_COMMENTS	VARCHAR2	(2000)		Feedback Comments
FEEDBACK_DATE	DATE			Feedback Date
FEEDBACK_RATING	VARCHAR2	(30)		Feedback Rating
ASS_ATTRIBUTE1	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE10	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE11	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE12	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE13	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE14	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE15	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE16	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE17	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE18	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE19	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE2	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE20	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE21	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE22	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE23	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE24	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE25	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE26	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE27	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE28	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE29	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE3	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE30	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE4	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE5	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE6	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE7	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE8	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE9	VARCHAR2	(150)		DFF Attribute for PER_ASSIGNMENTS
ASS_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
_DF:CPI	CHAR	(31)
POST_PROCESS_STAT_CD	VARCHAR2	(30)		(Lookup code based on lookup type )
POST_PROCESS_STAT_CD_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type )
GROUP_PER_IN_LER_ID	NUMBER	(15)	Yes	Group Per in Ler ID
ASSIGNMENT_ID	NUMBER	(15)	Yes	Foreign Key to PER_ALL_ASSIGNMENTS_F
PERSON_ID	NUMBER	(15)	Yes	Person ( Foreign Key to PER_ALL_PEOPLE_F )
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
ORGANIZATION_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
JOB_ID	NUMBER	(15)		Foreign key to PER_JOBS
GRADE_ID	NUMBER	(15)		Foreign key to PER_GRADES.
POSITION_ID	NUMBER	(15)		Foreign key to PER_POSITIONS.
PEOPLE_GROUP_ID	NUMBER	(15)		Foreign key to PAY_PEOPLE_GROUPS.
SOFT_CODING_KEYFLEX_ID	NUMBER	(15)		Legislative KeyFlex.
LOCATION_ID	NUMBER	(15)		Foreign key to HR_LOCATIONS.
PAY_RATE_ID	NUMBER	(15)		Pay Rate.
ASSIGNMENT_STATUS_TYPE_ID	NUMBER	(15)		Assignment Status Type
NEW_PERF_REVIEW_ID	NUMBER	(15)		New Performance Review.
NEW_PERF_EVENT_ID	NUMBER	(15)		New Performance Event.
SUPERVISOR_ID	NUMBER	(15)		Supervisor.
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.

Query Text

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


SELECT EFFECTIVE_DATE
,      FULL_NAME
,      BRIEF_NAME
,      CUSTOM_NAME
,      SUPERVISOR_FULL_NAME
,      SUPERVISOR_BRIEF_NAME
,      SUPERVISOR_CUSTOM_NAME
,      LEGISLATION_CODE
,      YEARS_EMPLOYED
,      YEARS_IN_JOB
,      YEARS_IN_POSITION
,      YEARS_IN_GRADE
,      EMPLOYEE_NUMBER
,      START_DATE
,      ORIGINAL_START_DATE
,      ADJUSTED_SVC_DATE
,      BASE_SALARY
,      BASE_SALARY_CHANGE_DATE
,      PAYROLL_NAME
,      PERFORMANCE_RATING
,      PERFORMANCE_RATING_TYPE
,      PERFORMANCE_RATING_DATE
,      GRADE_ANNULIZATION_FACTOR
,      PAY_ANNULIZATION_FACTOR
,      GRD_MIN_VAL
,      GRD_MAX_VAL
,      GRD_MID_POINT
,      EMP_CATEGORY
,      CHANGE_REASON
,      NORMAL_HOURS
,      EMAIL_ADDRESS
,      CUSTOM_SEGMENT1
,      CUSTOM_SEGMENT2
,      CUSTOM_SEGMENT3
,      CUSTOM_SEGMENT4
,      CUSTOM_SEGMENT5
,      CUSTOM_SEGMENT6
,      CUSTOM_SEGMENT7
,      CUSTOM_SEGMENT8
,      CUSTOM_SEGMENT9
,      CUSTOM_SEGMENT10
,      WS_COMMENTS
,      FREQUENCY
,      GRD_QUARTILE
,      GRD_COMPARATIO
,      CUSTOM_SEGMENT11
,      CUSTOM_SEGMENT12
,      CUSTOM_SEGMENT13
,      CUSTOM_SEGMENT14
,      CUSTOM_SEGMENT15
,      PEOPLE_GROUP_NAME
,      PEOPLE_GROUP_SEGMENT1
,      PEOPLE_GROUP_SEGMENT2
,      PEOPLE_GROUP_SEGMENT3
,      PEOPLE_GROUP_SEGMENT4
,      PEOPLE_GROUP_SEGMENT5
,      PEOPLE_GROUP_SEGMENT6
,      PEOPLE_GROUP_SEGMENT7
,      PEOPLE_GROUP_SEGMENT8
,      PEOPLE_GROUP_SEGMENT9
,      PEOPLE_GROUP_SEGMENT10
,      PEOPLE_GROUP_SEGMENT11
,      BASE_SALARY_FREQUENCY
,      NEW_ASSGN_OVN
,      FEEDBACK_COMMENTS
,      FEEDBACK_DATE
,      FEEDBACK_RATING
,      ASS_ATTRIBUTE1
,      ASS_ATTRIBUTE10
,      ASS_ATTRIBUTE11
,      ASS_ATTRIBUTE12
,      ASS_ATTRIBUTE13
,      ASS_ATTRIBUTE14
,      ASS_ATTRIBUTE15
,      ASS_ATTRIBUTE16
,      ASS_ATTRIBUTE17
,      ASS_ATTRIBUTE18
,      ASS_ATTRIBUTE19
,      ASS_ATTRIBUTE2
,      ASS_ATTRIBUTE20
,      ASS_ATTRIBUTE21
,      ASS_ATTRIBUTE22
,      ASS_ATTRIBUTE23
,      ASS_ATTRIBUTE24
,      ASS_ATTRIBUTE25
,      ASS_ATTRIBUTE26
,      ASS_ATTRIBUTE27
,      ASS_ATTRIBUTE28
,      ASS_ATTRIBUTE29
,      ASS_ATTRIBUTE3
,      ASS_ATTRIBUTE30
,      ASS_ATTRIBUTE4
,      ASS_ATTRIBUTE5
,      ASS_ATTRIBUTE6
,      ASS_ATTRIBUTE7
,      ASS_ATTRIBUTE8
,      ASS_ATTRIBUTE9
,      ASS_ATTRIBUTE_CATEGORY
,      _DF:CPI
,      POST_PROCESS_STAT_CD
,      POST_PROCESS_STAT_CD_M
,      GROUP_PER_IN_LER_ID
,      ASSIGNMENT_ID
,      PERSON_ID
,      BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      JOB_ID
,      GRADE_ID
,      POSITION_ID
,      PEOPLE_GROUP_ID
,      SOFT_CODING_KEYFLEX_ID
,      LOCATION_ID
,      PAY_RATE_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      NEW_PERF_REVIEW_ID
,      NEW_PERF_EVENT_ID
,      SUPERVISOR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.BENBV_CWB_PERSON_INFO_V;

Dependencies

[top of page]

APPS.BENBV_CWB_PERSON_INFO_V references the following:

APPS: BEN_CWB_PERSON_INFO; HR_BIS - show dependent code

APPS.BENBV_CWB_PERSON_INFO_V is not referenced by any database object