[Home] [Help] [Dependency Information]
Object Name: | BEN_CWB_RPT_DETAIL# |
---|---|
Object Type: | VIEW |
Owner: | BEN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BENEFIT_ACTION_ID | NUMBER | (15) | Yes | |
PERSON_RATE_ID | NUMBER | (15) | ||
PL_ID | NUMBER | (15) | ||
PERSON_ID | NUMBER | (15) | ||
OIPL_ID | NUMBER | (15) | ||
GROUP_PL_ID | NUMBER | (15) | ||
WS_MGR_ID | NUMBER | (15) | ||
LF_EVT_OCRD_DT | DATE | |||
FULL_NAME | VARCHAR2 | (240) | ||
EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | ||
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | ||
MANAGER_NAME | VARCHAR2 | (240) | ||
PL_NAME | VARCHAR2 | (240) | ||
OPT_NAME | VARCHAR2 | (240) | ||
AMOUNT | NUMBER | |||
UNITS | VARCHAR2 | (30) | ||
PERFORMANCE_RATING | VARCHAR2 | (30) | ||
ASSIGNMENT_CHANGED_FLAG | VARCHAR2 | (30) | ||
STATUS_CD | VARCHAR2 | (30) | ||
LF_EVT_CLOSED_FLAG | VARCHAR2 | (30) | ||
ERROR_OR_WARNING_TEXT | VARCHAR2 | (2000) | ||
CWB_RPT_DETAIL_ID | NUMBER | (15) | Yes | |
GROUP_PER_IN_LER_ID | NUMBER | |||
GROUP_OIPL_ID | NUMBER | |||
COUNTRY_CODE | VARCHAR2 | (30) | ||
BASE_SALARY_CURRENCY | VARCHAR2 | (30) | ||
CURRENCY | VARCHAR2 | (30) | ||
BASE_SALARY | NUMBER | |||
ELIG_SALARY | NUMBER | |||
PERCENT_OF_ELIG_SAL | NUMBER | |||
BASE_SAL_FREQ | VARCHAR2 | (30) | ||
PAY_ANN_FACTOR | NUMBER | |||
PL_ANN_FACTOR | NUMBER | |||
CONVERSION_FACTOR | NUMBER | |||
ADJUSTED_AMOUNT | NUMBER | |||
PREV_SAL | NUMBER | |||
NEW_SAL | NUMBER | |||
PAY_PROPOSAL_ID | NUMBER | |||
PAY_BASIS_ID | NUMBER | |||
ELEMENT_ENTRY_ID | NUMBER | |||
EXCHANGE_RATE | NUMBER | |||
EFFECTIVE_DATE | DATE | |||
REASON | VARCHAR2 | (30) | ||
ELIGIBILITY | VARCHAR2 | (30) | ||
FTE_FACTOR | NUMBER | |||
ELEMENT_INPUT_VALUE | VARCHAR2 | (80) | ||
AMOUNT_POSTED | NUMBER | |||
ASSIGNMENT_ID | NUMBER | |||
ELEMENT_ENTRY_VALUE_ID | NUMBER | |||
INPUT_VALUE_ID | NUMBER | |||
ELEMENT_TYPE_ID | NUMBER | |||
EEV_SCREEN_ENTRY_VALUE | NUMBER | |||
ELMNT_PROCESSING_TYPE | VARCHAR2 | (30) | ||
UOM_PRECISION | NUMBER | |||
WS_SUB_ACTY_TYP_CD | VARCHAR2 | (30) | ||
POSTED_RATING | VARCHAR2 | (30) | ||
RATING_TYPE | VARCHAR2 | (30) | ||
RATING_DATE | DATE | |||
PRIOR_JOB | VARCHAR2 | (700) | ||
POSTED_JOB | VARCHAR2 | (700) | ||
PROPOSED_JOB | VARCHAR2 | (700) | ||
PRIOR_POSITION | VARCHAR2 | (240) | ||
POSTED_POSITION | VARCHAR2 | (240) | ||
PROPOSED_POSITION | VARCHAR2 | (240) | ||
PRIOR_GRADE | VARCHAR2 | (240) | ||
POSTED_GRADE | VARCHAR2 | (240) | ||
PROPOSED_GRADE | VARCHAR2 | (240) | ||
PRIOR_GROUP | VARCHAR2 | (240) | ||
POSTED_GROUP | VARCHAR2 | (240) | ||
PROPOSED_GROUP | VARCHAR2 | (240) | ||
ASGN_CHANGE_REASON | VARCHAR2 | (30) | ||
PENDING_WORKFLOW | VARCHAR2 | (30) | ||
PRIOR_FLEX1 | VARCHAR2 | (150) | ||
POSTED_FLEX1 | VARCHAR2 | (150) | ||
PROPOSED_FLEX1 | VARCHAR2 | (150) | ||
PRIOR_FLEX2 | VARCHAR2 | (150) | ||
POSTED_FLEX2 | VARCHAR2 | (150) | ||
PROPOSED_FLEX2 | VARCHAR2 | (150) | ||
PRIOR_FLEX3 | VARCHAR2 | (150) | ||
POSTED_FLEX3 | VARCHAR2 | (150) | ||
PROPOSED_FLEX3 | VARCHAR2 | (150) | ||
PRIOR_FLEX4 | VARCHAR2 | (150) | ||
POSTED_FLEX4 | VARCHAR2 | (150) | ||
PROPOSED_FLEX4 | VARCHAR2 | (150) | ||
PRIOR_FLEX5 | VARCHAR2 | (150) | ||
POSTED_FLEX5 | VARCHAR2 | (150) | ||
PROPOSED_FLEX5 | VARCHAR2 | (150) | ||
PRIOR_FLEX6 | VARCHAR2 | (150) | ||
POSTED_FLEX6 | VARCHAR2 | (150) | ||
PROPOSED_FLEX6 | VARCHAR2 | (150) | ||
PRIOR_FLEX7 | VARCHAR2 | (150) | ||
POSTED_FLEX7 | VARCHAR2 | (150) | ||
PROPOSED_FLEX7 | VARCHAR2 | (150) | ||
PRIOR_FLEX8 | VARCHAR2 | (150) | ||
POSTED_FLEX8 | VARCHAR2 | (150) | ||
PROPOSED_FLEX8 | VARCHAR2 | (150) | ||
PRIOR_FLEX9 | VARCHAR2 | (150) | ||
POSTED_FLEX9 | VARCHAR2 | (150) | ||
PROPOSED_FLEX9 | VARCHAR2 | (150) | ||
PRIOR_FLEX10 | VARCHAR2 | (150) | ||
POSTED_FLEX10 | VARCHAR2 | (150) | ||
PROPOSED_FLEX10 | VARCHAR2 | (150) | ||
PRIOR_FLEX11 | VARCHAR2 | (150) | ||
POSTED_FLEX11 | VARCHAR2 | (150) | ||
PROPOSED_FLEX11 | VARCHAR2 | (150) | ||
PRIOR_FLEX12 | VARCHAR2 | (150) | ||
POSTED_FLEX12 | VARCHAR2 | (150) | ||
PROPOSED_FLEX12 | VARCHAR2 | (150) | ||
PRIOR_FLEX13 | VARCHAR2 | (150) | ||
POSTED_FLEX13 | VARCHAR2 | (150) | ||
PROPOSED_FLEX13 | VARCHAR2 | (150) | ||
PRIOR_FLEX14 | VARCHAR2 | (150) | ||
POSTED_FLEX14 | VARCHAR2 | (150) | ||
PROPOSED_FLEX14 | VARCHAR2 | (150) | ||
PRIOR_FLEX15 | VARCHAR2 | (150) | ||
POSTED_FLEX15 | VARCHAR2 | (150) | ||
PROPOSED_FLEX15 | VARCHAR2 | (150) | ||
PRIOR_FLEX16 | VARCHAR2 | (150) | ||
POSTED_FLEX16 | VARCHAR2 | (150) | ||
PROPOSED_FLEX16 | VARCHAR2 | (150) | ||
PRIOR_FLEX17 | VARCHAR2 | (150) | ||
POSTED_FLEX17 | VARCHAR2 | (150) | ||
PROPOSED_FLEX17 | VARCHAR2 | (150) | ||
PRIOR_FLEX18 | VARCHAR2 | (150) | ||
POSTED_FLEX18 | VARCHAR2 | (150) | ||
PROPOSED_FLEX18 | VARCHAR2 | (150) | ||
PRIOR_FLEX19 | VARCHAR2 | (150) | ||
POSTED_FLEX19 | VARCHAR2 | (150) | ||
PROPOSED_FLEX19 | VARCHAR2 | (150) | ||
PRIOR_FLEX20 | VARCHAR2 | (150) | ||
POSTED_FLEX20 | VARCHAR2 | (150) | ||
PROPOSED_FLEX20 | VARCHAR2 | (150) | ||
PRIOR_FLEX21 | VARCHAR2 | (150) | ||
POSTED_FLEX21 | VARCHAR2 | (150) | ||
PROPOSED_FLEX21 | VARCHAR2 | (150) | ||
PRIOR_FLEX22 | VARCHAR2 | (150) | ||
POSTED_FLEX22 | VARCHAR2 | (150) | ||
PROPOSED_FLEX22 | VARCHAR2 | (150) | ||
PRIOR_FLEX23 | VARCHAR2 | (150) | ||
POSTED_FLEX23 | VARCHAR2 | (150) | ||
PROPOSED_FLEX23 | VARCHAR2 | (150) | ||
PRIOR_FLEX24 | VARCHAR2 | (150) | ||
POSTED_FLEX24 | VARCHAR2 | (150) | ||
PROPOSED_FLEX24 | VARCHAR2 | (150) | ||
PRIOR_FLEX25 | VARCHAR2 | (150) | ||
POSTED_FLEX25 | VARCHAR2 | (150) | ||
PROPOSED_FLEX25 | VARCHAR2 | (150) | ||
PRIOR_FLEX26 | VARCHAR2 | (150) | ||
POSTED_FLEX26 | VARCHAR2 | (150) | ||
PROPOSED_FLEX26 | VARCHAR2 | (150) | ||
PRIOR_FLEX27 | VARCHAR2 | (150) | ||
POSTED_FLEX27 | VARCHAR2 | (150) | ||
PROPOSED_FLEX27 | VARCHAR2 | (150) | ||
PRIOR_FLEX28 | VARCHAR2 | (150) | ||
POSTED_FLEX28 | VARCHAR2 | (150) | ||
PROPOSED_FLEX28 | VARCHAR2 | (150) | ||
PRIOR_FLEX29 | VARCHAR2 | (150) | ||
POSTED_FLEX29 | VARCHAR2 | (150) | ||
PROPOSED_FLEX29 | VARCHAR2 | (150) | ||
PRIOR_FLEX30 | VARCHAR2 | (150) | ||
POSTED_FLEX30 | VARCHAR2 | (150) | ||
PROPOSED_FLEX30 | VARCHAR2 | (150) | ||
NEW_RPT | VARCHAR2 | (1) | ||
PREV_EEV_SCREEN_ENTRY_VALUE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BENEFIT_ACTION_ID
, PERSON_RATE_ID
, PL_ID
, PERSON_ID
, OIPL_ID
, GROUP_PL_ID
, WS_MGR_ID
, LF_EVT_OCRD_DT
, FULL_NAME
, EMPLOYEE_NUMBER
, BUSINESS_GROUP_ID
, BUSINESS_GROUP_NAME
, MANAGER_NAME
, PL_NAME
, OPT_NAME
, AMOUNT
, UNITS
, PERFORMANCE_RATING
, ASSIGNMENT_CHANGED_FLAG
, STATUS_CD
, LF_EVT_CLOSED_FLAG
, ERROR_OR_WARNING_TEXT
, CWB_RPT_DETAIL_ID
, GROUP_PER_IN_LER_ID
, GROUP_OIPL_ID
, COUNTRY_CODE
, BASE_SALARY_CURRENCY
, CURRENCY
, BASE_SALARY
, ELIG_SALARY
, PERCENT_OF_ELIG_SAL
, BASE_SAL_FREQ
, PAY_ANN_FACTOR
, PL_ANN_FACTOR
, CONVERSION_FACTOR
, ADJUSTED_AMOUNT
, PREV_SAL
, NEW_SAL
, PAY_PROPOSAL_ID
, PAY_BASIS_ID
, ELEMENT_ENTRY_ID
, EXCHANGE_RATE
, EFFECTIVE_DATE
, REASON
, ELIGIBILITY
, FTE_FACTOR
, ELEMENT_INPUT_VALUE
, AMOUNT_POSTED
, ASSIGNMENT_ID
, ELEMENT_ENTRY_VALUE_ID
, INPUT_VALUE_ID
, ELEMENT_TYPE_ID
, EEV_SCREEN_ENTRY_VALUE
, ELMNT_PROCESSING_TYPE
, UOM_PRECISION
, WS_SUB_ACTY_TYP_CD
, POSTED_RATING
, RATING_TYPE
, RATING_DATE
, PRIOR_JOB
, POSTED_JOB
, PROPOSED_JOB
, PRIOR_POSITION
, POSTED_POSITION
, PROPOSED_POSITION
, PRIOR_GRADE
, POSTED_GRADE
, PROPOSED_GRADE
, PRIOR_GROUP
, POSTED_GROUP
, PROPOSED_GROUP
, ASGN_CHANGE_REASON
, PENDING_WORKFLOW
, PRIOR_FLEX1
, POSTED_FLEX1
, PROPOSED_FLEX1
, PRIOR_FLEX2
, POSTED_FLEX2
, PROPOSED_FLEX2
, PRIOR_FLEX3
, POSTED_FLEX3
, PROPOSED_FLEX3
, PRIOR_FLEX4
, POSTED_FLEX4
, PROPOSED_FLEX4
, PRIOR_FLEX5
, POSTED_FLEX5
, PROPOSED_FLEX5
, PRIOR_FLEX6
, POSTED_FLEX6
, PROPOSED_FLEX6
, PRIOR_FLEX7
, POSTED_FLEX7
, PROPOSED_FLEX7
, PRIOR_FLEX8
, POSTED_FLEX8
, PROPOSED_FLEX8
, PRIOR_FLEX9
, POSTED_FLEX9
, PROPOSED_FLEX9
, PRIOR_FLEX10
, POSTED_FLEX10
, PROPOSED_FLEX10
, PRIOR_FLEX11
, POSTED_FLEX11
, PROPOSED_FLEX11
, PRIOR_FLEX12
, POSTED_FLEX12
, PROPOSED_FLEX12
, PRIOR_FLEX13
, POSTED_FLEX13
, PROPOSED_FLEX13
, PRIOR_FLEX14
, POSTED_FLEX14
, PROPOSED_FLEX14
, PRIOR_FLEX15
, POSTED_FLEX15
, PROPOSED_FLEX15
, PRIOR_FLEX16
, POSTED_FLEX16
, PROPOSED_FLEX16
, PRIOR_FLEX17
, POSTED_FLEX17
, PROPOSED_FLEX17
, PRIOR_FLEX18
, POSTED_FLEX18
, PROPOSED_FLEX18
, PRIOR_FLEX19
, POSTED_FLEX19
, PROPOSED_FLEX19
, PRIOR_FLEX20
, POSTED_FLEX20
, PROPOSED_FLEX20
, PRIOR_FLEX21
, POSTED_FLEX21
, PROPOSED_FLEX21
, PRIOR_FLEX22
, POSTED_FLEX22
, PROPOSED_FLEX22
, PRIOR_FLEX23
, POSTED_FLEX23
, PROPOSED_FLEX23
, PRIOR_FLEX24
, POSTED_FLEX24
, PROPOSED_FLEX24
, PRIOR_FLEX25
, POSTED_FLEX25
, PROPOSED_FLEX25
, PRIOR_FLEX26
, POSTED_FLEX26
, PROPOSED_FLEX26
, PRIOR_FLEX27
, POSTED_FLEX27
, PROPOSED_FLEX27
, PRIOR_FLEX28
, POSTED_FLEX28
, PROPOSED_FLEX28
, PRIOR_FLEX29
, POSTED_FLEX29
, PROPOSED_FLEX29
, PRIOR_FLEX30
, POSTED_FLEX30
, PROPOSED_FLEX30
, NEW_RPT
, PREV_EEV_SCREEN_ENTRY_VALUE
FROM BEN.BEN_CWB_RPT_DETAIL#;
|
|
|