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: BEN.BEN_CWB_PERSON_INFO#

Object Details

Object Name:	BEN_CWB_PERSON_INFO#
Object Type:	VIEW
Owner:	BEN
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
GROUP_PER_IN_LER_ID	NUMBER	(15)	Yes
ASSIGNMENT_ID	NUMBER	(15)	Yes
PERSON_ID	NUMBER	(15)	Yes
SUPERVISOR_ID	NUMBER	(15)
EFFECTIVE_DATE	DATE
FULL_NAME	VARCHAR2	(240)
BRIEF_NAME	VARCHAR2	(360)
CUSTOM_NAME	VARCHAR2	(480)
SUPERVISOR_FULL_NAME	VARCHAR2	(240)
SUPERVISOR_BRIEF_NAME	VARCHAR2	(360)
SUPERVISOR_CUSTOM_NAME	VARCHAR2	(480)
LEGISLATION_CODE	VARCHAR2	(30)
YEARS_EMPLOYED	NUMBER
YEARS_IN_JOB	NUMBER
YEARS_IN_POSITION	NUMBER
YEARS_IN_GRADE	NUMBER
EMPLOYEE_NUMBER	VARCHAR2	(30)
START_DATE	DATE
ORIGINAL_START_DATE	DATE
ADJUSTED_SVC_DATE	DATE
BASE_SALARY	NUMBER
BASE_SALARY_CHANGE_DATE	DATE
PAYROLL_NAME	VARCHAR2	(80)
PERFORMANCE_RATING	VARCHAR2	(30)
PERFORMANCE_RATING_TYPE	VARCHAR2	(30)
PERFORMANCE_RATING_DATE	DATE
BUSINESS_GROUP_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
GRADE_ID	NUMBER	(15)
POSITION_ID	NUMBER	(15)
PEOPLE_GROUP_ID	NUMBER	(15)
SOFT_CODING_KEYFLEX_ID	NUMBER	(15)
LOCATION_ID	NUMBER	(15)
PAY_RATE_ID	NUMBER	(15)
ASSIGNMENT_STATUS_TYPE_ID	NUMBER	(15)
FREQUENCY	VARCHAR2	(30)
GRADE_ANNULIZATION_FACTOR	NUMBER
PAY_ANNULIZATION_FACTOR	NUMBER
GRD_MIN_VAL	NUMBER
GRD_MAX_VAL	NUMBER
GRD_MID_POINT	NUMBER
GRD_QUARTILE	VARCHAR2	(30)
GRD_COMPARATIO	NUMBER
EMP_CATEGORY	VARCHAR2	(30)
CHANGE_REASON	VARCHAR2	(30)
NORMAL_HOURS	NUMBER
EMAIL_ADDRESS	VARCHAR2	(240)
BASE_SALARY_FREQUENCY	VARCHAR2	(30)
NEW_ASSGN_OVN	NUMBER	(9)
NEW_PERF_EVENT_ID	NUMBER	(15)
NEW_PERF_REVIEW_ID	NUMBER	(15)
POST_PROCESS_STAT_CD	VARCHAR2	(30)
FEEDBACK_RATING	VARCHAR2	(30)
FEEDBACK_COMMENTS	VARCHAR2	(2000)
FEEDBACK_DATE	DATE
OBJECT_VERSION_NUMBER	NUMBER	(9)
CUSTOM_SEGMENT1	VARCHAR2	(150)
CUSTOM_SEGMENT2	VARCHAR2	(150)
CUSTOM_SEGMENT3	VARCHAR2	(150)
CUSTOM_SEGMENT4	VARCHAR2	(150)
CUSTOM_SEGMENT5	VARCHAR2	(150)
CUSTOM_SEGMENT6	VARCHAR2	(150)
CUSTOM_SEGMENT7	VARCHAR2	(150)
CUSTOM_SEGMENT8	VARCHAR2	(150)
CUSTOM_SEGMENT9	VARCHAR2	(150)
CUSTOM_SEGMENT10	VARCHAR2	(150)
CUSTOM_SEGMENT11	NUMBER
CUSTOM_SEGMENT12	NUMBER
CUSTOM_SEGMENT13	NUMBER
CUSTOM_SEGMENT14	NUMBER
CUSTOM_SEGMENT15	NUMBER
CUSTOM_SEGMENT16	NUMBER
CUSTOM_SEGMENT17	NUMBER
CUSTOM_SEGMENT18	NUMBER
CUSTOM_SEGMENT19	NUMBER
CUSTOM_SEGMENT20	NUMBER
PEOPLE_GROUP_NAME	VARCHAR2	(240)
PEOPLE_GROUP_SEGMENT1	VARCHAR2	(60)
PEOPLE_GROUP_SEGMENT2	VARCHAR2	(60)
PEOPLE_GROUP_SEGMENT3	VARCHAR2	(60)
PEOPLE_GROUP_SEGMENT4	VARCHAR2	(60)
PEOPLE_GROUP_SEGMENT5	VARCHAR2	(60)
PEOPLE_GROUP_SEGMENT6	VARCHAR2	(60)
PEOPLE_GROUP_SEGMENT7	VARCHAR2	(60)
PEOPLE_GROUP_SEGMENT8	VARCHAR2	(60)
PEOPLE_GROUP_SEGMENT9	VARCHAR2	(60)
PEOPLE_GROUP_SEGMENT10	VARCHAR2	(60)
PEOPLE_GROUP_SEGMENT11	VARCHAR2	(60)
ASS_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ASS_ATTRIBUTE1	VARCHAR2	(150)
ASS_ATTRIBUTE2	VARCHAR2	(150)
ASS_ATTRIBUTE3	VARCHAR2	(150)
ASS_ATTRIBUTE4	VARCHAR2	(150)
ASS_ATTRIBUTE5	VARCHAR2	(150)
ASS_ATTRIBUTE6	VARCHAR2	(150)
ASS_ATTRIBUTE7	VARCHAR2	(150)
ASS_ATTRIBUTE8	VARCHAR2	(150)
ASS_ATTRIBUTE9	VARCHAR2	(150)
ASS_ATTRIBUTE10	VARCHAR2	(150)
ASS_ATTRIBUTE11	VARCHAR2	(150)
ASS_ATTRIBUTE12	VARCHAR2	(150)
ASS_ATTRIBUTE13	VARCHAR2	(150)
ASS_ATTRIBUTE14	VARCHAR2	(150)
ASS_ATTRIBUTE15	VARCHAR2	(150)
ASS_ATTRIBUTE16	VARCHAR2	(150)
ASS_ATTRIBUTE17	VARCHAR2	(150)
ASS_ATTRIBUTE18	VARCHAR2	(150)
ASS_ATTRIBUTE19	VARCHAR2	(150)
ASS_ATTRIBUTE20	VARCHAR2	(150)
ASS_ATTRIBUTE21	VARCHAR2	(150)
ASS_ATTRIBUTE22	VARCHAR2	(150)
ASS_ATTRIBUTE23	VARCHAR2	(150)
ASS_ATTRIBUTE24	VARCHAR2	(150)
ASS_ATTRIBUTE25	VARCHAR2	(150)
ASS_ATTRIBUTE26	VARCHAR2	(150)
ASS_ATTRIBUTE27	VARCHAR2	(150)
ASS_ATTRIBUTE28	VARCHAR2	(150)
ASS_ATTRIBUTE29	VARCHAR2	(150)
ASS_ATTRIBUTE30	VARCHAR2	(150)
WS_COMMENTS	VARCHAR2	(2000)
CPI_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
CPI_ATTRIBUTE1	VARCHAR2	(150)
CPI_ATTRIBUTE2	VARCHAR2	(150)
CPI_ATTRIBUTE3	VARCHAR2	(150)
CPI_ATTRIBUTE4	VARCHAR2	(150)
CPI_ATTRIBUTE5	VARCHAR2	(150)
CPI_ATTRIBUTE6	VARCHAR2	(150)
CPI_ATTRIBUTE7	VARCHAR2	(150)
CPI_ATTRIBUTE8	VARCHAR2	(150)
CPI_ATTRIBUTE9	VARCHAR2	(150)
CPI_ATTRIBUTE10	VARCHAR2	(150)
CPI_ATTRIBUTE11	VARCHAR2	(150)
CPI_ATTRIBUTE12	VARCHAR2	(150)
CPI_ATTRIBUTE13	VARCHAR2	(150)
CPI_ATTRIBUTE14	VARCHAR2	(150)
CPI_ATTRIBUTE15	VARCHAR2	(150)
CPI_ATTRIBUTE16	VARCHAR2	(150)
CPI_ATTRIBUTE17	VARCHAR2	(150)
CPI_ATTRIBUTE18	VARCHAR2	(150)
CPI_ATTRIBUTE19	VARCHAR2	(150)
CPI_ATTRIBUTE20	VARCHAR2	(150)
CPI_ATTRIBUTE21	VARCHAR2	(150)
CPI_ATTRIBUTE22	VARCHAR2	(150)
CPI_ATTRIBUTE23	VARCHAR2	(150)
CPI_ATTRIBUTE24	VARCHAR2	(150)
CPI_ATTRIBUTE25	VARCHAR2	(150)
CPI_ATTRIBUTE26	VARCHAR2	(150)
CPI_ATTRIBUTE27	VARCHAR2	(150)
CPI_ATTRIBUTE28	VARCHAR2	(150)
CPI_ATTRIBUTE29	VARCHAR2	(150)
CPI_ATTRIBUTE30	VARCHAR2	(150)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
GROUP_PL_ID	NUMBER	(15)
LF_EVT_OCRD_DT	DATE
BASE_SALARY_CURRENCY	VARCHAR2	(30)
FTE_FACTOR	NUMBER
GRD_QUINTILE	VARCHAR2	(30)
GRD_DECILE	VARCHAR2	(30)
GRD_PCT_IN_RANGE	NUMBER
GRADE_RATE_FREQUENCY	VARCHAR2	(30)
SALARY_1_YEAR_AGO	NUMBER
SALARY_1_YEAR_AGO_FREQUENCY	VARCHAR2	(30)
SALARY_1_YEAR_AGO_CURRENCY	VARCHAR2	(15)
SALARY_1_YEAR_AGO_ANN_FCTR	NUMBER
SALARY_2_YEAR_AGO	NUMBER
SALARY_2_YEAR_AGO_FREQUENCY	VARCHAR2	(30)
SALARY_2_YEAR_AGO_CURRENCY	VARCHAR2	(15)
SALARY_2_YEAR_AGO_ANN_FCTR	NUMBER
SALARY_3_YEAR_AGO	NUMBER
SALARY_3_YEAR_AGO_FREQUENCY	VARCHAR2	(30)
SALARY_3_YEAR_AGO_CURRENCY	VARCHAR2	(15)
SALARY_3_YEAR_AGO_ANN_FCTR	NUMBER
SALARY_4_YEAR_AGO	NUMBER
SALARY_4_YEAR_AGO_FREQUENCY	VARCHAR2	(30)
SALARY_4_YEAR_AGO_CURRENCY	VARCHAR2	(15)
SALARY_4_YEAR_AGO_ANN_FCTR	NUMBER
SALARY_5_YEAR_AGO	NUMBER
SALARY_5_YEAR_AGO_FREQUENCY	VARCHAR2	(30)
SALARY_5_YEAR_AGO_CURRENCY	VARCHAR2	(15)
SALARY_5_YEAR_AGO_ANN_FCTR	NUMBER
PREV_SAL	NUMBER
PREV_SAL_FREQUENCY	VARCHAR2	(30)
PREV_SAL_CURRENCY	VARCHAR2	(15)
PREV_SAL_ANN_FCTR	NUMBER
PREV_SAL_CHG_DATE	DATE
PREV_SAL_CHG_RSN	VARCHAR2	(30)
MKT_CURRENCY	VARCHAR2	(15)
MKT_FREQUENCY	VARCHAR2	(30)
MKT_ANNUALIZATION_FACTOR	NUMBER
MKT_MIN_SALARY	NUMBER
MKT_25PCT_SALARY	NUMBER
MKT_MID_SALARY	NUMBER
MKT_75PCT_SALARY	NUMBER
MKT_MAX_SALARY	NUMBER
MKT_EMP_QUARTILE	VARCHAR2	(30)
MKT_EMP_PCT_IN_RANGE	NUMBER
MKT_EMP_COMPARATIO	NUMBER
MKT_SURVEY_ID	NUMBER	(15)
CURRENT_PAY_PROPOSAL_ID	NUMBER	(15)
APPRAISAL_ID	NUMBER	(15)
EMAIL_STATUS	VARCHAR2	(30)

Query Text

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


SELECT GROUP_PER_IN_LER_ID
,      ASSIGNMENT_ID
,      PERSON_ID
,      SUPERVISOR_ID
,      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
,      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
,      FREQUENCY
,      GRADE_ANNULIZATION_FACTOR
,      PAY_ANNULIZATION_FACTOR
,      GRD_MIN_VAL
,      GRD_MAX_VAL
,      GRD_MID_POINT
,      GRD_QUARTILE
,      GRD_COMPARATIO
,      EMP_CATEGORY
,      CHANGE_REASON
,      NORMAL_HOURS
,      EMAIL_ADDRESS
,      BASE_SALARY_FREQUENCY
,      NEW_ASSGN_OVN
,      NEW_PERF_EVENT_ID
,      NEW_PERF_REVIEW_ID
,      POST_PROCESS_STAT_CD
,      FEEDBACK_RATING
,      FEEDBACK_COMMENTS
,      FEEDBACK_DATE
,      OBJECT_VERSION_NUMBER
,      CUSTOM_SEGMENT1
,      CUSTOM_SEGMENT2
,      CUSTOM_SEGMENT3
,      CUSTOM_SEGMENT4
,      CUSTOM_SEGMENT5
,      CUSTOM_SEGMENT6
,      CUSTOM_SEGMENT7
,      CUSTOM_SEGMENT8
,      CUSTOM_SEGMENT9
,      CUSTOM_SEGMENT10
,      CUSTOM_SEGMENT11
,      CUSTOM_SEGMENT12
,      CUSTOM_SEGMENT13
,      CUSTOM_SEGMENT14
,      CUSTOM_SEGMENT15
,      CUSTOM_SEGMENT16
,      CUSTOM_SEGMENT17
,      CUSTOM_SEGMENT18
,      CUSTOM_SEGMENT19
,      CUSTOM_SEGMENT20
,      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
,      ASS_ATTRIBUTE_CATEGORY
,      ASS_ATTRIBUTE1
,      ASS_ATTRIBUTE2
,      ASS_ATTRIBUTE3
,      ASS_ATTRIBUTE4
,      ASS_ATTRIBUTE5
,      ASS_ATTRIBUTE6
,      ASS_ATTRIBUTE7
,      ASS_ATTRIBUTE8
,      ASS_ATTRIBUTE9
,      ASS_ATTRIBUTE10
,      ASS_ATTRIBUTE11
,      ASS_ATTRIBUTE12
,      ASS_ATTRIBUTE13
,      ASS_ATTRIBUTE14
,      ASS_ATTRIBUTE15
,      ASS_ATTRIBUTE16
,      ASS_ATTRIBUTE17
,      ASS_ATTRIBUTE18
,      ASS_ATTRIBUTE19
,      ASS_ATTRIBUTE20
,      ASS_ATTRIBUTE21
,      ASS_ATTRIBUTE22
,      ASS_ATTRIBUTE23
,      ASS_ATTRIBUTE24
,      ASS_ATTRIBUTE25
,      ASS_ATTRIBUTE26
,      ASS_ATTRIBUTE27
,      ASS_ATTRIBUTE28
,      ASS_ATTRIBUTE29
,      ASS_ATTRIBUTE30
,      WS_COMMENTS
,      CPI_ATTRIBUTE_CATEGORY
,      CPI_ATTRIBUTE1
,      CPI_ATTRIBUTE2
,      CPI_ATTRIBUTE3
,      CPI_ATTRIBUTE4
,      CPI_ATTRIBUTE5
,      CPI_ATTRIBUTE6
,      CPI_ATTRIBUTE7
,      CPI_ATTRIBUTE8
,      CPI_ATTRIBUTE9
,      CPI_ATTRIBUTE10
,      CPI_ATTRIBUTE11
,      CPI_ATTRIBUTE12
,      CPI_ATTRIBUTE13
,      CPI_ATTRIBUTE14
,      CPI_ATTRIBUTE15
,      CPI_ATTRIBUTE16
,      CPI_ATTRIBUTE17
,      CPI_ATTRIBUTE18
,      CPI_ATTRIBUTE19
,      CPI_ATTRIBUTE20
,      CPI_ATTRIBUTE21
,      CPI_ATTRIBUTE22
,      CPI_ATTRIBUTE23
,      CPI_ATTRIBUTE24
,      CPI_ATTRIBUTE25
,      CPI_ATTRIBUTE26
,      CPI_ATTRIBUTE27
,      CPI_ATTRIBUTE28
,      CPI_ATTRIBUTE29
,      CPI_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      GROUP_PL_ID
,      LF_EVT_OCRD_DT
,      BASE_SALARY_CURRENCY
,      FTE_FACTOR
,      GRD_QUINTILE
,      GRD_DECILE
,      GRD_PCT_IN_RANGE
,      GRADE_RATE_FREQUENCY
,      SALARY_1_YEAR_AGO
,      SALARY_1_YEAR_AGO_FREQUENCY
,      SALARY_1_YEAR_AGO_CURRENCY
,      SALARY_1_YEAR_AGO_ANN_FCTR
,      SALARY_2_YEAR_AGO
,      SALARY_2_YEAR_AGO_FREQUENCY
,      SALARY_2_YEAR_AGO_CURRENCY
,      SALARY_2_YEAR_AGO_ANN_FCTR
,      SALARY_3_YEAR_AGO
,      SALARY_3_YEAR_AGO_FREQUENCY
,      SALARY_3_YEAR_AGO_CURRENCY
,      SALARY_3_YEAR_AGO_ANN_FCTR
,      SALARY_4_YEAR_AGO
,      SALARY_4_YEAR_AGO_FREQUENCY
,      SALARY_4_YEAR_AGO_CURRENCY
,      SALARY_4_YEAR_AGO_ANN_FCTR
,      SALARY_5_YEAR_AGO
,      SALARY_5_YEAR_AGO_FREQUENCY
,      SALARY_5_YEAR_AGO_CURRENCY
,      SALARY_5_YEAR_AGO_ANN_FCTR
,      PREV_SAL
,      PREV_SAL_FREQUENCY
,      PREV_SAL_CURRENCY
,      PREV_SAL_ANN_FCTR
,      PREV_SAL_CHG_DATE
,      PREV_SAL_CHG_RSN
,      MKT_CURRENCY
,      MKT_FREQUENCY
,      MKT_ANNUALIZATION_FACTOR
,      MKT_MIN_SALARY
,      MKT_25PCT_SALARY
,      MKT_MID_SALARY
,      MKT_75PCT_SALARY
,      MKT_MAX_SALARY
,      MKT_EMP_QUARTILE
,      MKT_EMP_PCT_IN_RANGE
,      MKT_EMP_COMPARATIO
,      MKT_SURVEY_ID
,      CURRENT_PAY_PROPOSAL_ID
,      APPRAISAL_ID
,      EMAIL_STATUS
FROM BEN.BEN_CWB_PERSON_INFO#;

Dependencies

[top of page]

BEN.BEN_CWB_PERSON_INFO# references the following:

BEN: BEN_CWB_PERSON_INFO

BEN.BEN_CWB_PERSON_INFO# is referenced by following:

APPS: BEN_CWB_PERSON_INFO; BEN_CWB_PERSON_INFO_WHO