Employee Benefit Statements
ProceduresDocument CollectionData CollectionTutorial for Doing-it-YourselfSamples & ExamplesAn Employee Website + more
Click here for the Index Employee Communications
A variety of Targeted Examples, ranging from an online Employee Budget Worksheet, to Retirement Communications, online Enrollment & much more.
Click here for the Index The Human Resources Collaborative Suite
Why it's neededTools we usedYour ToolsOverview and IntroductionMovies and more
Click here for the Index
Employee Benefit Statements
An onlineEmployee Budget Worksheet
Collaborate.Easily,productively
ProceduresDocument CollectionData CollectionTutorial for Doing-it-YourselfSamples & ExamplesAn Employee Website + more
Click here for the Index Employee Communications
A variety of Targeted Examples, ranging from an online Employee Budget Worksheet, to Retirement Communications, online Enrollment & much more.
Click here for the Index The Human Resources Collaborative Suite
Why it's neededTools we usedYour ToolsOverview and IntroductionMovies and more
Click here for the Index
New Function or Trigger
Standard, built-in Functions
NOTES:
A Function is a 'shortcut' for an 'automatic calculation or result'. An example is the function: TRIM( ). If you used TRIM, it would remove all the leading and trailing spaces from some text. So: TRIM(address) would get rid of all the spaces before the 1st character and after the last character. " 123 Anywhere Lane " would be automatically 'fixed' and become "123 Anywhere Lane".
Your HRCS comes with many 'standard functions' that are pre-written, but your HRCS also allows you to create your own functions. This can be a powerful way to enhance HR productivity. If it takes 5 minutes to write a calculation - and - variations of this calculation will be created many times in the future, then it will be a time-saver to create a function that will run your calculations automatically without a lengthy 'rewrite'.
This level of flexibility and power is far beyond a typical HR information system and is an advanced feature. This means that you may find it difficult. If so, ask your IT group to help - or - we can do it for you. That is the power of collaboration.
This level of flexibility and power is far beyond a typical HR information system and is an advanced feature. This means that you may find it difficult. If so, ask your IT group to help - or - we can do it for you. That is the power of collaboration.
avg(arg1)count(arg1)min(arg1)max(arg1)sum(arg1)bit_and(expression)bit_or(expression)bool_and(expression)bool_or(expression)every(expression)
abs(arg1)acos(arg1)asin(arg1)atan(arg1)ceil(arg1)cos(arg1)cot(arg1)degrees(arg1)exp(arg1)floor(arg1)ln(arg1)log(arg1)pi()pow(arg1, arg2)radians(arg1)round(arg1)sin(arg1)sqrt(arg1)tan(arg1)
convert(arg1, [src_encoding name,] dest_encoding_name)lower(arg1)upper(arg1)length(arg1)md5(arg1)replace(arg1, from, to)substr(arg1, from[, count])trim(arg1)
age(arg1)cur_date()cur_datetime()cur_time()get_periods(from_interval [, start_date[, actual_date]])
if(cond_expr, true_expr, false_expr)COALESCE(value [, ...])NULLIF(value1, value2))GREATEST(value [, ...])LEAST(value [, ...])
to_char(arg1,frmt_str)to_date(arg1,frmt_str)to_number(arg1,frmt_str)
array_append(anyarray, anyelement)array_cat(anyarray, anyarray)array_dims(anyarray)array_lower(anyarray, int)array_prepend(anyelement, anyarray)array_to_string(anyarray, text)array_upper(anyarray, int)string_to_array(text, text)
corr(Y, X)covar_pop(Y, X)covar_samp(Y, X)regr_avgx(Y, X)regr_avgy(Y, X)regr_count(Y, X)regr_intercept(Y, X)regr_r2(Y, X)regr_slope(Y, X)regr_sxx(Y, X)regr_sxy(Y, X)regr_syy(Y, X)stddev(expression)stddev_pop(expression)stddev_samp(expression)variance(expression)var_pop(expression)var_samp(expression)
di_moneylast(S, E, r)di_canspend(E, r, n)ii_moneylast(S, E, r, ss)ii_canspend(E, r, n, ss)
chart(name)barcode(code,fgcolor,bgcolor)image(imagename,folder,schema)
FV(pv double precision, i double precision, n double precision)yc_int_2(f_start integer, f_interval integer)yc_interval(f_start integer, f_interval integer, seq_length integer, elm_idx integer)
Aggregates
Math
Array
Conditional
Statistics
Container
String
Format
User Defined
Financial
Date Time
Additional info on Functions and Triggers will be added to this site. If you would like to explore creating a new Function, from your Menu, click New -> Function.
TriggersA trigger is a specification that the database should automatically execute a particular function whenever a certain type of operation is performed. Triggers can be defined to execute either before or after any INSERT, UPDATE, or DELETE operation, either once per modified row, or once per SQL statement. If a trigger event occurs, the trigger's function is called at the appropriate time to handle the event.
The trigger function must be defined before the trigger itself can be created.
To read more about Functions and Triggers, go to:
PostgreSQL manual
TriggersA trigger is a specification that the database should automatically execute a particular function whenever a certain type of operation is performed. Triggers can be defined to execute either before or after any INSERT, UPDATE, or DELETE operation, either once per modified row, or once per SQL statement. If a trigger event occurs, the trigger's function is called at the appropriate time to handle the event.
The trigger function must be defined before the trigger itself can be created.
To read more about Functions and Triggers, go to:
Have a Question?
Your email
Employee Benefit Statements
An onlineEmployee Budget Worksheet
Collaborate.Easily,productively