VIEW: BEN.BEN_CWB_RPT_DETAIL#

Source

View Text - Preformatted

select BENEFIT_ACTION_ID BENEFIT_ACTION_ID, PERSON_RATE_ID PERSON_RATE_ID, PL_ID PL_ID, PERSON_ID PERSON_ID, OIPL_ID OIPL_ID, GROUP_PL_ID GROUP_PL_ID, WS_MGR_ID WS_MGR_ID, LF_EVT_OCRD_DT LF_EVT_OCRD_DT, FULL_NAME FULL_NAME, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME, MANAGER_NAME MANAGER_NAME, PL_NAME PL_NAME, OPT_NAME OPT_NAME, AMOUNT AMOUNT, UNITS UNITS, PERFORMANCE_RATING PERFORMANCE_RATING, ASSIGNMENT_CHANGED_FLAG ASSIGNMENT_CHANGED_FLAG, STATUS_CD STATUS_CD, LF_EVT_CLOSED_FLAG LF_EVT_CLOSED_FLAG, ERROR_OR_WARNING_TEXT ERROR_OR_WARNING_TEXT, CWB_RPT_DETAIL_ID CWB_RPT_DETAIL_ID, GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID, GROUP_OIPL_ID GROUP_OIPL_ID, COUNTRY_CODE COUNTRY_CODE, BASE_SALARY_CURRENCY BASE_SALARY_CURRENCY, CURRENCY CURRENCY, BASE_SALARY BASE_SALARY, ELIG_SALARY ELIG_SALARY, PERCENT_OF_ELIG_SAL PERCENT_OF_ELIG_SAL, BASE_SAL_FREQ BASE_SAL_FREQ, PAY_ANN_FACTOR PAY_ANN_FACTOR, PL_ANN_FACTOR PL_ANN_FACTOR, CONVERSION_FACTOR CONVERSION_FACTOR, ADJUSTED_AMOUNT ADJUSTED_AMOUNT, PREV_SAL PREV_SAL, NEW_SAL NEW_SAL, PAY_PROPOSAL_ID PAY_PROPOSAL_ID, PAY_BASIS_ID PAY_BASIS_ID, ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID, EXCHANGE_RATE EXCHANGE_RATE, EFFECTIVE_DATE EFFECTIVE_DATE, REASON REASON, ELIGIBILITY ELIGIBILITY, FTE_FACTOR FTE_FACTOR, ELEMENT_INPUT_VALUE ELEMENT_INPUT_VALUE, AMOUNT_POSTED AMOUNT_POSTED, ASSIGNMENT_ID ASSIGNMENT_ID, ELEMENT_ENTRY_VALUE_ID ELEMENT_ENTRY_VALUE_ID, INPUT_VALUE_ID INPUT_VALUE_ID, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, EEV_SCREEN_ENTRY_VALUE EEV_SCREEN_ENTRY_VALUE, ELMNT_PROCESSING_TYPE ELMNT_PROCESSING_TYPE, UOM_PRECISION UOM_PRECISION, WS_SUB_ACTY_TYP_CD WS_SUB_ACTY_TYP_CD, POSTED_RATING POSTED_RATING, RATING_TYPE RATING_TYPE, RATING_DATE RATING_DATE, PRIOR_JOB PRIOR_JOB, POSTED_JOB POSTED_JOB, PROPOSED_JOB PROPOSED_JOB, PRIOR_POSITION PRIOR_POSITION, POSTED_POSITION POSTED_POSITION, PROPOSED_POSITION PROPOSED_POSITION, PRIOR_GRADE PRIOR_GRADE, POSTED_GRADE POSTED_GRADE, PROPOSED_GRADE PROPOSED_GRADE, PRIOR_GROUP PRIOR_GROUP, POSTED_GROUP POSTED_GROUP, PROPOSED_GROUP PROPOSED_GROUP, ASGN_CHANGE_REASON ASGN_CHANGE_REASON, PENDING_WORKFLOW PENDING_WORKFLOW, PRIOR_FLEX1 PRIOR_FLEX1, POSTED_FLEX1 POSTED_FLEX1, PROPOSED_FLEX1 PROPOSED_FLEX1, PRIOR_FLEX2 PRIOR_FLEX2, POSTED_FLEX2 POSTED_FLEX2, PROPOSED_FLEX2 PROPOSED_FLEX2, PRIOR_FLEX3 PRIOR_FLEX3, POSTED_FLEX3 POSTED_FLEX3, PROPOSED_FLEX3 PROPOSED_FLEX3, PRIOR_FLEX4 PRIOR_FLEX4, POSTED_FLEX4 POSTED_FLEX4, PROPOSED_FLEX4 PROPOSED_FLEX4, PRIOR_FLEX5 PRIOR_FLEX5, POSTED_FLEX5 POSTED_FLEX5, PROPOSED_FLEX5 PROPOSED_FLEX5, PRIOR_FLEX6 PRIOR_FLEX6, POSTED_FLEX6 POSTED_FLEX6, PROPOSED_FLEX6 PROPOSED_FLEX6, PRIOR_FLEX7 PRIOR_FLEX7, POSTED_FLEX7 POSTED_FLEX7, PROPOSED_FLEX7 PROPOSED_FLEX7, PRIOR_FLEX8 PRIOR_FLEX8, POSTED_FLEX8 POSTED_FLEX8, PROPOSED_FLEX8 PROPOSED_FLEX8, PRIOR_FLEX9 PRIOR_FLEX9, POSTED_FLEX9 POSTED_FLEX9, PROPOSED_FLEX9 PROPOSED_FLEX9, PRIOR_FLEX10 PRIOR_FLEX10, POSTED_FLEX10 POSTED_FLEX10, PROPOSED_FLEX10 PROPOSED_FLEX10, PRIOR_FLEX11 PRIOR_FLEX11, POSTED_FLEX11 POSTED_FLEX11, PROPOSED_FLEX11 PROPOSED_FLEX11, PRIOR_FLEX12 PRIOR_FLEX12, POSTED_FLEX12 POSTED_FLEX12, PROPOSED_FLEX12 PROPOSED_FLEX12, PRIOR_FLEX13 PRIOR_FLEX13, POSTED_FLEX13 POSTED_FLEX13, PROPOSED_FLEX13 PROPOSED_FLEX13, PRIOR_FLEX14 PRIOR_FLEX14, POSTED_FLEX14 POSTED_FLEX14, PROPOSED_FLEX14 PROPOSED_FLEX14, PRIOR_FLEX15 PRIOR_FLEX15, POSTED_FLEX15 POSTED_FLEX15, PROPOSED_FLEX15 PROPOSED_FLEX15, PRIOR_FLEX16 PRIOR_FLEX16, POSTED_FLEX16 POSTED_FLEX16, PROPOSED_FLEX16 PROPOSED_FLEX16, PRIOR_FLEX17 PRIOR_FLEX17, POSTED_FLEX17 POSTED_FLEX17, PROPOSED_FLEX17 PROPOSED_FLEX17, PRIOR_FLEX18 PRIOR_FLEX18, POSTED_FLEX18 POSTED_FLEX18, PROPOSED_FLEX18 PROPOSED_FLEX18, PRIOR_FLEX19 PRIOR_FLEX19, POSTED_FLEX19 POSTED_FLEX19, PROPOSED_FLEX19 PROPOSED_FLEX19, PRIOR_FLEX20 PRIOR_FLEX20, POSTED_FLEX20 POSTED_FLEX20, PROPOSED_FLEX20 PROPOSED_FLEX20, PRIOR_FLEX21 PRIOR_FLEX21, POSTED_FLEX21 POSTED_FLEX21, PROPOSED_FLEX21 PROPOSED_FLEX21, PRIOR_FLEX22 PRIOR_FLEX22, POSTED_FLEX22 POSTED_FLEX22, PROPOSED_FLEX22 PROPOSED_FLEX22, PRIOR_FLEX23 PRIOR_FLEX23, POSTED_FLEX23 POSTED_FLEX23, PROPOSED_FLEX23 PROPOSED_FLEX23, PRIOR_FLEX24 PRIOR_FLEX24, POSTED_FLEX24 POSTED_FLEX24, PROPOSED_FLEX24 PROPOSED_FLEX24, PRIOR_FLEX25 PRIOR_FLEX25, POSTED_FLEX25 POSTED_FLEX25, PROPOSED_FLEX25 PROPOSED_FLEX25, PRIOR_FLEX26 PRIOR_FLEX26, POSTED_FLEX26 POSTED_FLEX26, PROPOSED_FLEX26 PROPOSED_FLEX26, PRIOR_FLEX27 PRIOR_FLEX27, POSTED_FLEX27 POSTED_FLEX27, PROPOSED_FLEX27 PROPOSED_FLEX27, PRIOR_FLEX28 PRIOR_FLEX28, POSTED_FLEX28 POSTED_FLEX28, PROPOSED_FLEX28 PROPOSED_FLEX28, PRIOR_FLEX29 PRIOR_FLEX29, POSTED_FLEX29 POSTED_FLEX29, PROPOSED_FLEX29 PROPOSED_FLEX29, PRIOR_FLEX30 PRIOR_FLEX30, POSTED_FLEX30 POSTED_FLEX30, PROPOSED_FLEX30 PROPOSED_FLEX30, NEW_RPT NEW_RPT, PREV_EEV_SCREEN_ENTRY_VALUE PREV_EEV_SCREEN_ENTRY_VALUE from "BEN"."BEN_CWB_RPT_DETAIL"

View Text - HTML Formatted

SELECT BENEFIT_ACTION_ID BENEFIT_ACTION_ID
, PERSON_RATE_ID PERSON_RATE_ID
, PL_ID PL_ID
, PERSON_ID PERSON_ID
, OIPL_ID OIPL_ID
, GROUP_PL_ID GROUP_PL_ID
, WS_MGR_ID WS_MGR_ID
, LF_EVT_OCRD_DT LF_EVT_OCRD_DT
, FULL_NAME FULL_NAME
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, MANAGER_NAME MANAGER_NAME
, PL_NAME PL_NAME
, OPT_NAME OPT_NAME
, AMOUNT AMOUNT
, UNITS UNITS
, PERFORMANCE_RATING PERFORMANCE_RATING
, ASSIGNMENT_CHANGED_FLAG ASSIGNMENT_CHANGED_FLAG
, STATUS_CD STATUS_CD
, LF_EVT_CLOSED_FLAG LF_EVT_CLOSED_FLAG
, ERROR_OR_WARNING_TEXT ERROR_OR_WARNING_TEXT
, CWB_RPT_DETAIL_ID CWB_RPT_DETAIL_ID
, GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID
, GROUP_OIPL_ID GROUP_OIPL_ID
, COUNTRY_CODE COUNTRY_CODE
, BASE_SALARY_CURRENCY BASE_SALARY_CURRENCY
, CURRENCY CURRENCY
, BASE_SALARY BASE_SALARY
, ELIG_SALARY ELIG_SALARY
, PERCENT_OF_ELIG_SAL PERCENT_OF_ELIG_SAL
, BASE_SAL_FREQ BASE_SAL_FREQ
, PAY_ANN_FACTOR PAY_ANN_FACTOR
, PL_ANN_FACTOR PL_ANN_FACTOR
, CONVERSION_FACTOR CONVERSION_FACTOR
, ADJUSTED_AMOUNT ADJUSTED_AMOUNT
, PREV_SAL PREV_SAL
, NEW_SAL NEW_SAL
, PAY_PROPOSAL_ID PAY_PROPOSAL_ID
, PAY_BASIS_ID PAY_BASIS_ID
, ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID
, EXCHANGE_RATE EXCHANGE_RATE
, EFFECTIVE_DATE EFFECTIVE_DATE
, REASON REASON
, ELIGIBILITY ELIGIBILITY
, FTE_FACTOR FTE_FACTOR
, ELEMENT_INPUT_VALUE ELEMENT_INPUT_VALUE
, AMOUNT_POSTED AMOUNT_POSTED
, ASSIGNMENT_ID ASSIGNMENT_ID
, ELEMENT_ENTRY_VALUE_ID ELEMENT_ENTRY_VALUE_ID
, INPUT_VALUE_ID INPUT_VALUE_ID
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, EEV_SCREEN_ENTRY_VALUE EEV_SCREEN_ENTRY_VALUE
, ELMNT_PROCESSING_TYPE ELMNT_PROCESSING_TYPE
, UOM_PRECISION UOM_PRECISION
, WS_SUB_ACTY_TYP_CD WS_SUB_ACTY_TYP_CD
, POSTED_RATING POSTED_RATING
, RATING_TYPE RATING_TYPE
, RATING_DATE RATING_DATE
, PRIOR_JOB PRIOR_JOB
, POSTED_JOB POSTED_JOB
, PROPOSED_JOB PROPOSED_JOB
, PRIOR_POSITION PRIOR_POSITION
, POSTED_POSITION POSTED_POSITION
, PROPOSED_POSITION PROPOSED_POSITION
, PRIOR_GRADE PRIOR_GRADE
, POSTED_GRADE POSTED_GRADE
, PROPOSED_GRADE PROPOSED_GRADE
, PRIOR_GROUP PRIOR_GROUP
, POSTED_GROUP POSTED_GROUP
, PROPOSED_GROUP PROPOSED_GROUP
, ASGN_CHANGE_REASON ASGN_CHANGE_REASON
, PENDING_WORKFLOW PENDING_WORKFLOW
, PRIOR_FLEX1 PRIOR_FLEX1
, POSTED_FLEX1 POSTED_FLEX1
, PROPOSED_FLEX1 PROPOSED_FLEX1
, PRIOR_FLEX2 PRIOR_FLEX2
, POSTED_FLEX2 POSTED_FLEX2
, PROPOSED_FLEX2 PROPOSED_FLEX2
, PRIOR_FLEX3 PRIOR_FLEX3
, POSTED_FLEX3 POSTED_FLEX3
, PROPOSED_FLEX3 PROPOSED_FLEX3
, PRIOR_FLEX4 PRIOR_FLEX4
, POSTED_FLEX4 POSTED_FLEX4
, PROPOSED_FLEX4 PROPOSED_FLEX4
, PRIOR_FLEX5 PRIOR_FLEX5
, POSTED_FLEX5 POSTED_FLEX5
, PROPOSED_FLEX5 PROPOSED_FLEX5
, PRIOR_FLEX6 PRIOR_FLEX6
, POSTED_FLEX6 POSTED_FLEX6
, PROPOSED_FLEX6 PROPOSED_FLEX6
, PRIOR_FLEX7 PRIOR_FLEX7
, POSTED_FLEX7 POSTED_FLEX7
, PROPOSED_FLEX7 PROPOSED_FLEX7
, PRIOR_FLEX8 PRIOR_FLEX8
, POSTED_FLEX8 POSTED_FLEX8
, PROPOSED_FLEX8 PROPOSED_FLEX8
, PRIOR_FLEX9 PRIOR_FLEX9
, POSTED_FLEX9 POSTED_FLEX9
, PROPOSED_FLEX9 PROPOSED_FLEX9
, PRIOR_FLEX10 PRIOR_FLEX10
, POSTED_FLEX10 POSTED_FLEX10
, PROPOSED_FLEX10 PROPOSED_FLEX10
, PRIOR_FLEX11 PRIOR_FLEX11
, POSTED_FLEX11 POSTED_FLEX11
, PROPOSED_FLEX11 PROPOSED_FLEX11
, PRIOR_FLEX12 PRIOR_FLEX12
, POSTED_FLEX12 POSTED_FLEX12
, PROPOSED_FLEX12 PROPOSED_FLEX12
, PRIOR_FLEX13 PRIOR_FLEX13
, POSTED_FLEX13 POSTED_FLEX13
, PROPOSED_FLEX13 PROPOSED_FLEX13
, PRIOR_FLEX14 PRIOR_FLEX14
, POSTED_FLEX14 POSTED_FLEX14
, PROPOSED_FLEX14 PROPOSED_FLEX14
, PRIOR_FLEX15 PRIOR_FLEX15
, POSTED_FLEX15 POSTED_FLEX15
, PROPOSED_FLEX15 PROPOSED_FLEX15
, PRIOR_FLEX16 PRIOR_FLEX16
, POSTED_FLEX16 POSTED_FLEX16
, PROPOSED_FLEX16 PROPOSED_FLEX16
, PRIOR_FLEX17 PRIOR_FLEX17
, POSTED_FLEX17 POSTED_FLEX17
, PROPOSED_FLEX17 PROPOSED_FLEX17
, PRIOR_FLEX18 PRIOR_FLEX18
, POSTED_FLEX18 POSTED_FLEX18
, PROPOSED_FLEX18 PROPOSED_FLEX18
, PRIOR_FLEX19 PRIOR_FLEX19
, POSTED_FLEX19 POSTED_FLEX19
, PROPOSED_FLEX19 PROPOSED_FLEX19
, PRIOR_FLEX20 PRIOR_FLEX20
, POSTED_FLEX20 POSTED_FLEX20
, PROPOSED_FLEX20 PROPOSED_FLEX20
, PRIOR_FLEX21 PRIOR_FLEX21
, POSTED_FLEX21 POSTED_FLEX21
, PROPOSED_FLEX21 PROPOSED_FLEX21
, PRIOR_FLEX22 PRIOR_FLEX22
, POSTED_FLEX22 POSTED_FLEX22
, PROPOSED_FLEX22 PROPOSED_FLEX22
, PRIOR_FLEX23 PRIOR_FLEX23
, POSTED_FLEX23 POSTED_FLEX23
, PROPOSED_FLEX23 PROPOSED_FLEX23
, PRIOR_FLEX24 PRIOR_FLEX24
, POSTED_FLEX24 POSTED_FLEX24
, PROPOSED_FLEX24 PROPOSED_FLEX24
, PRIOR_FLEX25 PRIOR_FLEX25
, POSTED_FLEX25 POSTED_FLEX25
, PROPOSED_FLEX25 PROPOSED_FLEX25
, PRIOR_FLEX26 PRIOR_FLEX26
, POSTED_FLEX26 POSTED_FLEX26
, PROPOSED_FLEX26 PROPOSED_FLEX26
, PRIOR_FLEX27 PRIOR_FLEX27
, POSTED_FLEX27 POSTED_FLEX27
, PROPOSED_FLEX27 PROPOSED_FLEX27
, PRIOR_FLEX28 PRIOR_FLEX28
, POSTED_FLEX28 POSTED_FLEX28
, PROPOSED_FLEX28 PROPOSED_FLEX28
, PRIOR_FLEX29 PRIOR_FLEX29
, POSTED_FLEX29 POSTED_FLEX29
, PROPOSED_FLEX29 PROPOSED_FLEX29
, PRIOR_FLEX30 PRIOR_FLEX30
, POSTED_FLEX30 POSTED_FLEX30
, PROPOSED_FLEX30 PROPOSED_FLEX30
, NEW_RPT NEW_RPT
, PREV_EEV_SCREEN_ENTRY_VALUE PREV_EEV_SCREEN_ENTRY_VALUE
FROM "BEN"."BEN_CWB_RPT_DETAIL"