This page (revision-20) was last changed on 26-Nov-2021 10:22 by kparrott

This page was created on 26-Nov-2021 10:22 by RForbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
20 26-Nov-2021 10:22 2 KB kparrott to previous
19 26-Nov-2021 10:22 2 KB ihowie to previous | to last
18 26-Nov-2021 10:22 2 KB ihowie to previous | to last
17 26-Nov-2021 10:22 2 KB jmyers to previous | to last
16 26-Nov-2021 10:22 2 KB jmyers to previous | to last
15 26-Nov-2021 10:22 2 KB jmyers to previous | to last
14 26-Nov-2021 10:22 2 KB jmyers to previous | to last
13 26-Nov-2021 10:22 2 KB jmyers to previous | to last
12 26-Nov-2021 10:22 2 KB jmyers to previous | to last
11 26-Nov-2021 10:22 2 KB jmyers to previous | to last
10 26-Nov-2021 10:22 2 KB rforbes to previous | to last
9 26-Nov-2021 10:22 2 KB rforbes to previous | to last
8 26-Nov-2021 10:22 2 KB rforbes to previous | to last
7 26-Nov-2021 10:22 1 KB RForbes to previous | to last
6 26-Nov-2021 10:22 1 KB RForbes to previous | to last
5 26-Nov-2021 10:22 1 KB RForbes to previous | to last
4 26-Nov-2021 10:22 1 KB RForbes to previous | to last
3 26-Nov-2021 10:22 969 bytes RForbes to previous | to last
2 26-Nov-2021 10:22 865 bytes RForbes to previous | to last
1 26-Nov-2021 10:22 770 bytes RForbes to last

Page References

Incoming links Outgoing links
CREATE A USERCALC CUSTOM FUNCTION
CREATE A USERCALC CUSTOM FUNCTION

Version management

Difference between version and

At line 10 changed one line
#*__Meaning__\\This field holds the product that the function is intended to be used with.
#*__Meaning__\\This field holds the product that the function is intended to be used with.\\ \\
At line 15 changed one line
#The custom function must be named P2K_xxx (must start with P2K).\\ \\As a best practice, it is recommended that you include your customer code in the name of the function, which will ensure it is not overlaid at some future point by any new development.\\ \\For workflow oriented custom functions, a recommended best practice is to also include the table/product name in the function name. For example, a custom function created for the WF_EASD table might be named P2K_CF_EASD_xxx_yyyy where xxx is your customer code and yyyy is some kind of descriptive value to aid in remembering what the function does.
#The custom function must be named P2K_xxx (must start with P2K).\\ \\As a best practice, it is recommended that you include your customer code in the name of the function, which will ensure it is not overlaid at some future point by any new development.\\ \\For workflow oriented custom functions, a recommended best practice is to also include the table/product name in the function name. For example, a custom function created for the WF_EASD table might be named P2K_CF_EASD_xxx_yyyy where xxx is your customer code and yyyy is some kind of descriptive value to aid in remembering what the function does.\\ \\
At line 19 changed 3 lines
#**Variables defined on the IMUC Variables tab are created in the usercalc as V_<''variable name''>
** example: a Variable identified as __Current Month FTE__ will be identified as __V_CURRENT_MONTH_FTE__ in the SQL code
* If defining a PR usercalc you also have access to all the package variables that are used as part of the P2K_PMCALC package (see P2K_PMCALC_SPEC.SQL)
#**Variables defined on the [IMUC Variables|IMUC#VariablesTab] tab are created in the UserCalc as V_<''variable name''>.\\For example, a variable identified as __Current Month FTE__ will be identified as __V_CURRENT_MONTH_FTE__ in the SQL code.
#*If defining a PR UserCalc, you also have access to all the package variables that are used as part of the P2K_PMCALC package (see P2K_PMCALC_SPEC.SQL)
This page (revision-20) was last changed on 26-Nov-2021 10:22 by kparrottTop