Guidance Lookups

Lookups enable quick selection from drop-down lists and are incorporated into the guidance capability to speed the process of entering data into forms. They are also used in applications to represent a set of codes and their translated meanings.

For example, a product team might store the values 'Y' and 'N' in a column in a table. When displaying those values, they would want to display "Yes" or "No" (or their translated equivalents) instead. Each set of related codes is identified as a lookup type.

This table displays guidance lookup names (called lookup types in the application), their values, and their descriptions.

Lookup Type	Lookup Values	Description
Guidance Object Association Runtime Status (ORA_ZCA_ORCH_ASSOC_RT_STATUS)	Active Completed Exited	Specifies the runtime status of the guidance object association.
Guidance Process Status (ORA_ZCA_ORCH_DT_STATUS)	Active Archive Draft	Specifies the status of the guidance process.
Guidance Process Type (ORA_ZCA_ORCH_DT_TYPE)	Guidance Builder Guided Selling	Specifies the type of the guidance process.
Guidance Stage Objective Runtime Status (ORA_ZCA_ORCH_STG_OBJ_RT_STATUS)	Canceled Completed Pending Skipped	Specifies the runtime status of the guidance stage objectives.
Guidance Stage Objective Status (ORA_ZCA_ORCH_STG_OBJ_DT_STATUS)	Mapped New	Specifies the objective status of the guidance stage.
Guidance Stage or Step Runtime Status (ORA_ZCA_ORCH_STG_STP_RT_STATUS)	Canceled Completed In Progress Not Started Skipped	Specifies the runtime status of the guidance stage or step.
Guidance Step Execution Method (ORA_ZCA_ORCH_STP_DT_EXECMETHD)	Automatic Manual	Specifies the execution method of the guidance step.
Guidance Step Transition Runtime Status (ORA_ZCA_ORCH_STPTRNS_RT_STATUS)	Canceled Completed In Progress Not Started Skipped Waiting	Specifies the runtime status of the guidance step transition.
Guidance Step Type (ORA_ZCA_ORCH_STEP_DT_TYPE)	Appointment Field Update Groovy Next Stage Stop Task Wait	Specifies the type of the guidance step.