Skip to content

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 Comments
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:

SchemaBEN
TableBEN_CWB_PERSON_INFO
BEN.BEN_CWB_PERSON_INFO# is referenced by following:

SchemaAPPS
SynonymBEN_CWB_PERSON_INFO
TriggerBEN_CWB_PERSON_INFO_WHO