You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Enterable Calculation Values on Calculation Cards 'value' Field DBI for Fast Formula or Tables

in Reporting and Analytics for HCM

Summary:


Hi There, looking for Enterable Calculation Values on Calculation Cards 'value' Field DBI for Fast Formula or Tables

Content (please ensure you mask any confidential information):



 select  "PAY_DIR_CARD_COMPONENTS_F"."DIR_CARD_COMP_ID" as "DIR_CARD_COMP_ID",         "PAY_DIR_CARD_COMPONENTS_F"."EFFECTIVE_START_DATE" as "EFFECTIVE_START_DATE",         "PAY_DIR_CARD_COMPONENTS_F"."DIR_CARD_COMP_DEF_ID" as "DIR_CARD_COMP_DEF_ID",         "PAY_DIR_CARD_COMPONENTS_F"."DIR_CARD_ID" as "DIR_CARD_ID",         "PAY_DIR_CARD_COMPONENTS_F"."CONTEXT_VALUE1" as "CONTEXT_VALUE1",         "PAY_DIR_CARDS_F"."PAYROLL_RELATIONSHIP_ID" as "PAYROLL_RELATIONSHIP_ID",         "PAY_DIR_CARD_COMP_DEFS_TL"."COMPONENT_NAME" as "COMPONENT_NAME",         "PAY_DIR_CARD_COMP_DEFS_TL"."LANGUAGE" as "LANGUAGE",         "PAY_PAY_RELATIONSHIPS_DN"."PAYROLL_RELATIONSHIP_NUMBER" as "PAYROLL_RELATIONSHIP_NUMBER",         "PAY_PAY_RELATIONSHIPS_DN"."PAYROLL_STAT_UNIT_ID" as "PAYROLL_STAT_UNIT_ID",         "PAY_PAY_RELATIONSHIPS_DN"."START_DATE" as "START_DATE",         "PAY_PAY_RELATIONSHIPS_DN"."END_DATE" as "END_DATE" , PTRU.ESTAB_NAME,PTRU.ORGANIZATION_ID from   "FUSION"."PAY_PAY_RELATIONSHIPS_DN" "PAY_PAY_RELATIONSHIPS_DN",        "FUSION"."PAY_DIR_CARD_COMP_DEFS_TL" "PAY_DIR_CARD_COMP_DEFS_TL",        "FUSION"."PAY_DIR_CARDS_F" "PAY_DIR_CARDS_F",        "FUSION"."PAY_DIR_CARD_COMPONENTS_F" "PAY_DIR_CARD_COMPONENTS_F" , PER_TAX_REPORTING_UNITS PTRU where   "PAY_DIR_CARD_COMPONENTS_F"."DIR_CARD_ID"="PAY_DIR_CARDS_F"."DIR_CARD_ID" and     "PAY_DIR_CARD_COMPONENTS_F"."DIR_CARD_COMP_DEF_ID"="PAY_DIR_CARD_COMP_DEFS_TL"."DIR_CARD_COMP_DEF_ID" and    

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!