Available WF Custom Functions#

This information is as of 2005/01/03

For All Workflow Products#

DELETING	Generic	If triggering record is being deleted will return TRUE.
INSERTING	Generic	If triggering record is being inserted will return TRUE.
UPDATING	Generic	If triggering record is being updated will return TRUE.

For Workflow Product - WF_AAL#

P2K_CF_WFGES_ENDDISPATCH

Customer Specific

Special logic to End the Dispatched status for employees that have had specific work restrictions created.

For Workflow Product - WF_CRSE#

P2K_CF_TDRASTESTED	Generic	Creates an Assessment Event for any assessments tied to the RAS_ID_TESTED field on the course.
P2K_CF_TDRASSURVEYED	Generic	Creates an Assessment Event for any assessments tied to the RAS_ID_SURVEYED field on the course.

For Workflow Product - WF_EASD#

CREATEPA	Generic	Creates a PA for a PA Type that matches the name of the WF User Calc or failing that for the PA Type of "WF_EASD".
NEWHIRE	Generic	Returns TRUE if the conditions for adding a new hire are met. Those conditions are: 1.) the EASD record is being split behind the scenes so the old effective date is the BOT, 2.) the new effective date is the same as the hire date, and 3.) the original hire date and hire date are the same.
REHIRE	Generic	Returns TRUE if the conditions for adding a new hire are met. Those conditions are: 1.) the EASD record is being split behind the scenes so the old effective date is the BOT, 2.) the new effective date is the same as the hire date, and 3.) the original hire date and hire date are NOT the same.
P2K_CF_PAYRULE	Generic	Inserts Pay Rule when used with the NEWHIRE WF Custom Function and the DFLT PAYRULE system preference. Information inserted is based on DFLT PAYRULE set up.

For Workflow Product - WF_EEM#

P2K_CF_SS_END	Generic	End the Self Service Acces based on Termination date PLUS number of days in Global variable SS_END_DAYS. If the SS_END_DAYS global is -1 the End will be the 31-Dec of the Termination Year. If the Global variable is not found 0 days will be assumed. Otherwise the number found in the Global will be added to the Termination Date to calculate out when the SS Access should be ended.
P2K_CF_WF_TERMPAY	Generic	If this is included in a WF_EEM workflow, when the EEM record has a DTR_ID populated on it then with proper payroll setup, it will insert a Pay Header for with Final Pay turned on. The return value on this is of Varchar2 and will return a '0' if no work was done or will return a long message if work was done.

For Workflow Product - WF_RAP#

P2K_CF_RECSTAGE	Generic	Returns TRUE if the application is at the Stage Sequence for the Job Profile specified in the Global Variable RE_STAGE_SEQ. It will also set the Global Variable RE_STAGE_ID to hold the ID of the RST record for use in comparisons in the UserCalc.
P2K_CF_RESCHEDASSESS	Generic	Creates an Assessment Event for any assessments tied to the steps within the current recruiting stage. The Assessment Date/Time will come from the Global Variable RE_ASSESSMENT or the current date if not specified here. IF this is triggered from an Update of the RAP then RAP_ID will be populated BUT if it is triggered on an Insert the RAP_ID can not be populated because the RAP record does not physically exist yet.

For Workflow Product - WF_RASE#

P2K_CF_RE_ASSESS

Generic

IF candidate failed to get the minimum essential points on an Assessment their application is updated as rejected. For all other gradings their applications are moved up to the next Stage. A rejected application is set with a Status of 80 - Reject, a Reason of 01 - Below Essential Pts, a Rating of 07 - Rejected, and the stage is set to the highest on the Job Profile. A passed application is moved to the next stage sequence above the current stage with a Status of 30 - Pre-Screening and a Rating of 06 - Qualified.

For Workflow Product - WF_RCA#

P2K_CF_HASAPPLIED

Generic

Returns TRUE if there is at least 1 Application tied to a Candidate. It will return FALSE if the Candidate has not yet applied to any postings.

For Workflow Product - WF_SPA#

P2K_CF_WFQLT_SAP

Customer Specific

For Workflow Product - WF_TRE#

P2K_CF_WFGES_CREATEAAL

Customer Specific

---

Notes #

Click to create a new notes page