Part 3: Fast Formula Texts.

• Fast Formula to progress candidates based on interview scheduled:

DEFAULT_DATA_VALUE FOR IRC_CSP_INTRVWRQST_STATUS IS 'NA'

CONDITION_RESULT = 'N'

CONDITION_MESSAGE = 'Debug: '

i = 1

WHILE IRC_CSP_INTRVWRQST_STATUS.EXISTS(i) LOOP

(

	CONDITION_MESSAGE = CONDITION_MESSAGE || IRC_CSP_INTRVWRQST_STATUS[i]

	IF IRC_CSP_INTRVWRQST_STATUS[i] = 'INTERVIEW_SCHEDULED' THEN

		CONDITION_RESULT = 'Y'

	i = i + 1

)

RETURN CONDITION_RESULT, CONDITION_MESSAGE

• Fast Formula to progress candidates based on interview canceled:

DEFAULT_DATA_VALUE FOR IRC_CSP_INTRVWRQST_STATUS IS 'NA'

CONDITION_RESULT = 'N'

CONDITION_MESSAGE = 'Debug: '

i = 1

WHILE IRC_CSP_INTRVWRQST_STATUS.EXISTS(i) LOOP

(

	CONDITION_MESSAGE = CONDITION_MESSAGE || IRC_CSP_INTRVWRQST_STATUS[i]

	IF IRC_CSP_INTRVWRQST_STATUS[i] = 'INTERVIEW_CANCELLED' THEN

		CONDITION_RESULT = 'Y'

	i = i + 1

)

RETURN CONDITION_RESULT, CONDITION_MESSAGE

• Fast Formula to progress candidates based on interview rescheduled:

DEFAULT_DATA_VALUE FOR IRC_CSP_INTRVWRQST_STATUS IS 'NA'

CONDITION_RESULT = 'N'

CONDITION_MESSAGE = 'Debug: '



i = 1

WHILE IRC_CSP_INTRVWRQST_STATUS.EXISTS(i) LOOP

(

	CONDITION_MESSAGE = CONDITION_MESSAGE || IRC_CSP_INTRVWRQST_STATUS[i]

	IF IRC_CSP_INTRVWRQST_STATUS[i] = 'INTERVIEW_RESCHEDULED’ THEN

		CONDITION_RESULT = 'Y'

	i = i + 1

)

RETURN CONDITION_RESULT, CONDITION_MESSAGE

• Fast Formula to progress candidates based on interview completed:

DEFAULT_DATA_VALUE FOR IRC_CSP_INTRVW_ID IS -1

DEFAULT_DATA_VALUE FOR IRC_CSP_INTRVW_STATUS IS 'N/A'

CONDITION_RESULT = 'N'

CONDITION_MESSAGE = 'Debug: '



i = 1

WHILE IRC_CSP_INTRVW_ID.EXISTS(i) LOOP

(

	CONDITION_MESSAGE = CONDITION_MESSAGE || 'Interview ID: ' || to_char(IRC_CSP_INTRVW_ID[i]) || 'Interview Status: ' || IRC_CSP_INTRVW_STATUS[i]

	IF IRC_CSP_INTRVW_STATUS[i] = 'IS_COMPLETED' THEN

		CONDITION_RESULT = 'Y'

	i = i + 1

)

RETURN CONDITION_RESULT, CONDITION_MESSAGE

• Fast Formula to progress candidates based on location type Phone:

DEFAULT_DATA_VALUE FOR IRC_CSP_INTRVWSCHED_ID IS -1

DEFAULT_DATA_VALUE FOR IRC_CSP_INTRVWSCHED_LOCATION_TYPE IS 'N/A'

CONDITION_RESULT = 'N'

CONDITION_MESSAGE = 'Debug: '



i = 1

WHILE IRC_CSP_INTRVWSCHED_ID.EXISTS(i) LOOP

(

	CONDITION_MESSAGE = CONDITION_MESSAGE || 'Interview ID: ' || IRC_CSP_INTRVWSCHED_LOCATION_TYPE[i]

	IF IRC_CSP_INTRVWSCHED_LOCATION_TYPE[i] = 'ORA_IS_LOCATION_PHONE' THEN

		CONDITION_RESULT = 'Y'

	i = i + 1

)

RETURN CONDITION_RESULT, CONDITION_MESSAGE

• Fast Formula to progress candidates based on location type being In Person:

DEFAULT_DATA_VALUE FOR IRC_CSP_INTRVWSCHED_ID IS -1

DEFAULT_DATA_VALUE FOR IRC_CSP_INTRVWSCHED_LOCATION_TYPE IS 'N/A'

CONDITION_RESULT = 'N'

CONDITION_MESSAGE = 'Debug: '



i = 1

WHILE IRC_CSP_INTRVWSCHED_ID.EXISTS(i) LOOP

(

	CONDITION_MESSAGE = CONDITION_MESSAGE || 'Interview ID: ' || IRC_CSP_INTRVWSCHED_LOCATION_TYPE[i]

	IF IRC_CSP_INTRVWSCHED_LOCATION_TYPE[i] = 'ORA_IS_LOCATION_IN_PERSON' THEN

		CONDITION_RESULT = 'Y'

	i = i + 1

)

RETURN CONDITION_RESULT, CONDITION_MESSAGE

• Fast Formula to progress candidates based on location type being Web Conference:

DEFAULT_DATA_VALUE FOR IRC_CSP_INTRVWSCHED_ID IS -1

DEFAULT_DATA_VALUE FOR IRC_CSP_INTRVWSCHED_LOCATION_TYPE IS 'N/A'

CONDITION_RESULT = 'N'

CONDITION_MESSAGE = 'Debug: '



i = 1

WHILE IRC_CSP_INTRVWSCHED_ID.EXISTS(i) LOOP

(

	CONDITION_MESSAGE = CONDITION_MESSAGE || 'Interview ID: ' || IRC_CSP_INTRVWSCHED_LOCATION_TYPE[i]

	IF IRC_CSP_INTRVWSCHED_LOCATION_TYPE[i] = 'ORA_IS_LOCATION_WEBCONFERENCE' THEN

		CONDITION_RESULT = 'Y'

	i = i + 1

)

RETURN CONDITION_RESULT, CONDITION_MESSAGE

Pages: 1 2 3 4