Get all expression detail items
get
/fscmRestApi/resources/11.13.18.05/incentiveCompensationExpressionDetailItemsLOV
Request
Query Parameters
-
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables:- PrimaryKey: Finds an expression detail item with the specified primary key.
Finder Variables:- ExpressionDetailType; string; The type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE.
- OrgId; integer; The unique identifier of the business unit.
- PrimaryKey: Finds an expression detail item with the specified primary key.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- BusinessUnitName; string; The name of the business unit.
- ExpressionDetailType; string; The type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE.
- ExpressionDetailTypeCode; string; The code indicating the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE.
- OrgId; integer; The unique identifier of the business unit.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Metadata-Context: string
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version: string
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : incentiveCompensationExpressionDetailItemsLOV
Type:
Show Source
object-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
ItemsThe items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
LinksThe link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-item-response
Type:
Show Source
object-
BusinessUnitName: string
Title:
Business UnitRead Only:trueMaximum Length:240The name of the business unit. -
expressionDetailBasicAttributeGroups: array
Expression Detail Basic Attribute Groups
Title:
Expression Detail Basic Attribute GroupsThe basic attribute groups resource is used to view the primary attribute groups used in an expression. -
expressionDetailFunctionGroups: array
Expression Detail Function Groups
Title:
Expression Detail Function GroupsThe function groups resource is used to view the list of SQL functions groups based on the category of the functions they contain, that can be used in an expression. -
expressionDetailOperators: array
Expression Detail Operators
Title:
Expression Detail OperatorsThe operators resource is used to view the list of mathematical operators that can be used in an expression. -
expressionDetailPerformanceMeasures: array
Expression Detail Performance Measures
Title:
Expression Detail Performance MeasuresThe performance measures list of values resource is used to view the list of performance measures for which its attributes can be used in an expression. -
expressionDetailPlanComponents: array
Expression Detail Plan Components
Title:
Expression Detail Plan ComponentsThe plan components list of values resource is used to view the list of plan components for which its attributes can be used in an expression. -
ExpressionDetailType: string
Title:
Expression Detail Item TypeRead Only:trueMaximum Length:20The type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
ExpressionDetailTypeCode: string
Read Only:
trueMaximum Length:30The code indicating the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
expressionDetailUserDefinedFunctions: array
Expression Detail User Defined Functions
Title:
Expression Detail User Defined FunctionsThe user defined functions list of values resource is used to view the list of predefined PL/SQL functions that can be used in an expression. -
ExpressionDetailUserDefinedQueryValueSets: array
Expression Detail User Defined Query Value Sets
Title:
Expression Detail User Defined Query Value SetsThe user defined query value sets list of values resource is used to view the list of user defined queries which were created using table value sets. These user defined queries can be used in an expression. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OrgId: integer
(int64)
Read Only:
trueThe unique identifier of the business unit.
Nested Schema : Expression Detail Basic Attribute Groups
Type:
arrayTitle:
Expression Detail Basic Attribute GroupsThe basic attribute groups resource is used to view the primary attribute groups used in an expression.
Show Source
Nested Schema : Expression Detail Function Groups
Type:
arrayTitle:
Expression Detail Function GroupsThe function groups resource is used to view the list of SQL functions groups based on the category of the functions they contain, that can be used in an expression.
Show Source
Nested Schema : Expression Detail Operators
Type:
arrayTitle:
Expression Detail OperatorsThe operators resource is used to view the list of mathematical operators that can be used in an expression.
Show Source
Nested Schema : Expression Detail Performance Measures
Type:
arrayTitle:
Expression Detail Performance MeasuresThe performance measures list of values resource is used to view the list of performance measures for which its attributes can be used in an expression.
Show Source
Nested Schema : Expression Detail Plan Components
Type:
arrayTitle:
Expression Detail Plan ComponentsThe plan components list of values resource is used to view the list of plan components for which its attributes can be used in an expression.
Show Source
Nested Schema : Expression Detail User Defined Functions
Type:
arrayTitle:
Expression Detail User Defined FunctionsThe user defined functions list of values resource is used to view the list of predefined PL/SQL functions that can be used in an expression.
Show Source
Nested Schema : Expression Detail User Defined Query Value Sets
Type:
arrayTitle:
Expression Detail User Defined Query Value SetsThe user defined query value sets list of values resource is used to view the list of user defined queries which were created using table value sets. These user defined queries can be used in an expression.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-expressionDetailBasicAttributeGroups-item-response
Type:
Show Source
object-
BasicAttributesGroup: string
Title:
Basic Attributes GroupRead Only:trueMaximum Length:30The group or category of the primary attributes used in an expression. A list of accepted values are listed in the lookup type CN_EXPR_ATTR_MENU. -
BasicAttributesGroupCode: string
Read Only:
trueMaximum Length:30The code indicating the group or category of the primary attributes used in an expression. A list of accepted values are listed in the lookup type CN_EXPR_ATTR_MENU. -
expressionDetailBasicAttributeNames: array
Expression Detail Basic Attribute Names
Title:
Expression Detail Basic Attribute NamesThe basic attribute names resource is used to view the list of basic attribute names within a basic attribute group used in an expression. -
ExpressionDetailTypeCode: string
Read Only:
trueMaximum Length:30The code indicating the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
ExpressionType: string
Title:
Expression TypeRead Only:trueMaximum Length:11The type of the expression. The default value is Calculation. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OrgId: integer
(int64)
Read Only:
trueThe unique identifier of the business unit.
Nested Schema : Expression Detail Basic Attribute Names
Type:
arrayTitle:
Expression Detail Basic Attribute NamesThe basic attribute names resource is used to view the list of basic attribute names within a basic attribute group used in an expression.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-expressionDetailBasicAttributeGroups-expressionDetailBasicAttributeNames-item-response
Type:
Show Source
object-
BasicAttributeColumnName: string
Title:
Basic Attribute Column NameRead Only:trueMaximum Length:30The column within the table that the basic attribute refers to. -
BasicAttributeId: integer
(int64)
Read Only:
trueThe unique identifier of the basic attribute used in an expression. -
BasicAttributeName: string
Title:
Basic Attribute NameRead Only:trueMaximum Length:60The type or category of the entity used in an expression. A list of accepted values are listed in the meaning column of lookup codes in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
BasicAttributesGroupCode: string
Read Only:
trueMaximum Length:30The code indicating the group or category of the primary attributes used in an expression. A list of accepted values are listed in the lookup type CN_EXPR_ATTR_MENU. -
BasicAttributeTableName: string
Title:
Basic Attribute Table NameRead Only:trueMaximum Length:30The table name that the basic attribute refers to. -
ExpressionDetailTypeCode: string
Read Only:
trueMaximum Length:30The code indicating the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
ExpressionType: string
Title:
Expression TypeRead Only:trueMaximum Length:11The type of the expression. Default value is Calculation. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OrgId: integer
(int64)
Read Only:
trueThe unique identifier of the business unit.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-expressionDetailFunctionGroups-item-response
Type:
Show Source
object-
expressionDetailFunctionNames: array
Expression Detail Function Names
Title:
Expression Detail Function NamesThe function names resource is used to view the list of SQL functions within a specific function group that can be used in an expression. -
ExpressionDetailTypeCode: string
Read Only:
trueMaximum Length:30The code indicating the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
FunctionsGroup: string
Title:
Functions GroupRead Only:trueMaximum Length:30The group or category of the SQL functions used in an expression. A list of accepted values are listed in the lookup type CN_FUNCTION_TYPES. -
FunctionsGroupCode: string
Read Only:
trueMaximum Length:30The code indicating the group or category of the SQL functions used in an expression. A list of accepted values are listed in the lookup type CN_FUNCTION_TYPES. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LookupType: string
Read Only:
trueMaximum Length:30The lookup type which categorizes the SQL function. Default value is CN_FUNCTION_TYPES. -
OrgId: integer
(int64)
Read Only:
trueThe unique identifier of the business unit.
Nested Schema : Expression Detail Function Names
Type:
arrayTitle:
Expression Detail Function NamesThe function names resource is used to view the list of SQL functions within a specific function group that can be used in an expression.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-expressionDetailFunctionGroups-expressionDetailFunctionNames-item-response
Type:
Show Source
object-
ExpressionDetailTypeCode: string
Read Only:
trueMaximum Length:30The code indicating the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
FunctionCode: string
Read Only:
trueMaximum Length:30The code indicating the function within a function group, that is used in an expression. A list of acceptable values can be found by querying the corresponding function group as a lookup type. -
FunctionGroupCode: string
Read Only:
trueMaximum Length:30The code indicating the group or category of the SQL functions used in an expression. A list of accepted values are listed in the lookup type CN_FUNCTION_TYPES. -
FunctionName: string
Title:
Function NameRead Only:trueMaximum Length:80The name of the function within a function group, that is used in an expression. A list of acceptable values can be found by querying the corresponding function group as a lookup type. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-expressionDetailOperators-item-response
Type:
Show Source
object-
ExpressionDetailTypeCode: string
Read Only:
trueMaximum Length:30The code indicating the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
ExpressionOperator: string
Title:
OperatorRead Only:trueMaximum Length:255The mathematical operator used in an expression. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OrgId: integer
(int64)
Read Only:
trueThe unique identifier of the business unit.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-expressionDetailPerformanceMeasures-item-response
Type:
Show Source
object-
expressionDetailPerformanceMeasureAttributes: array
Expression Detail Performance Measure Attributes
Title:
Expression Detail Performance Measure AttributesThe performance measure attributes list of values resource is used to view the list of attributes of a performance measure, that can be used in an expression. -
ExpressionDetailTypeCode: string
Read Only:
trueMaximum Length:30The code indicating the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
MeasureId: integer
(int64)
Read Only:
trueThe unique identifier of the performance measure. -
MeasureName: string
Title:
Performance MeasureRead Only:trueMaximum Length:80The name of the performance measure. -
OrgId: integer
(int64)
Read Only:
trueThe unique identifier of the business unit. -
ProcessTransactions: string
Title:
Process TransactionsRead Only:trueMaximum Length:30Indicates whether the performance measure processes transactions individually or by grouping them.
Nested Schema : Expression Detail Performance Measure Attributes
Type:
arrayTitle:
Expression Detail Performance Measure AttributesThe performance measure attributes list of values resource is used to view the list of attributes of a performance measure, that can be used in an expression.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-expressionDetailPerformanceMeasures-expressionDetailPerformanceMeasureAttributes-item-response
Type:
Show Source
object-
AttributeConfigId: integer
(int64)
Read Only:
trueThe unique identifier of the performance measure attribute. -
ExpressionDetailTypeCode: string
Read Only:
trueMaximum Length:30The code indicating the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
MeasureId: integer
(int64)
Read Only:
trueThe unique identifier of the performance measure. -
MeasureName: string
Title:
Performance MeasureRead Only:trueMaximum Length:80The name of the performance measure. -
MeasureResultAttribute: string
Title:
Measure Result AttributeRead Only:trueMaximum Length:60The attribute of the performance measure. -
OrgId: integer
(int64)
Read Only:
trueThe unique identifier of the business unit. -
ProcessTransactions: string
Title:
Process TransactionsRead Only:trueMaximum Length:30Indicates whether the performance measure processes transactions individually or by grouping them.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-expressionDetailPlanComponents-item-response
Type:
Show Source
object-
expressionDetailPlanComponentAttributes: array
Expression Detail Plan Component Attributes
Title:
Expression Detail Plan Component AttributesThe plan component attributes list of values resource is used to view the list of attributes of a plan component that can be used in an expression. -
ExpressionDetailTypeCode: string
Read Only:
trueMaximum Length:30The code indicating the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OrgId: integer
(int64)
Read Only:
trueThe unique identifier of the business unit. -
PlanComponentId: integer
(int64)
Read Only:
trueThe unique identifier of the plan component. -
PlanComponentName: string
Title:
Plan ComponentRead Only:trueMaximum Length:80The name of the plan component.
Nested Schema : Expression Detail Plan Component Attributes
Type:
arrayTitle:
Expression Detail Plan Component AttributesThe plan component attributes list of values resource is used to view the list of attributes of a plan component that can be used in an expression.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-expressionDetailPlanComponents-expressionDetailPlanComponentAttributes-item-response
Type:
Show Source
object-
AttributeConfigId: number
Read Only:
trueThe unique identifier of the plan component's attribute. -
expressionDetailPlanComponentsMeasures: array
Expression Detail Plan Component Measures
Title:
Expression Detail Plan Component MeasuresThe plan component measures list of values resource is used to view the list of measures within a plan component for which it's attributes can be used in an expression. -
ExpressionDetailTypeCode: string
Read Only:
trueMaximum Length:30The code indicating the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OrgId: integer
(int64)
Read Only:
trueThe unique identifier of the business unit. -
PlanComponentId: integer
(int64)
Read Only:
trueThe unique identifier of the plan component. -
PlanComponentName: string
Title:
Plan ComponentRead Only:trueMaximum Length:80The name of the plan component. -
PlanComponentResultAttribute: string
Title:
Plan Component Result AttributeRead Only:trueMaximum Length:240The attribute of the plan component.
Nested Schema : Expression Detail Plan Component Measures
Type:
arrayTitle:
Expression Detail Plan Component MeasuresThe plan component measures list of values resource is used to view the list of measures within a plan component for which it's attributes can be used in an expression.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-expressionDetailPlanComponents-expressionDetailPlanComponentAttributes-expressionDetailPlanComponentsMeasures-item-response
Type:
Show Source
object-
expressionDetailPlanComponentsMeasureResultAttributes: array
Expression Detail Plan Component Measure Result Attributes
Title:
Expression Detail Plan Component Measure Result AttributesThe plan component measure result attributes list of values resource is used to view the list of attributes of a performance measure within a plan component that can be used in an expression. -
ExpressionDetailTypeCode: string
Read Only:
trueMaximum Length:30The code for the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
FormulaId: integer
(int64)
Read Only:
trueThe unique identifier of the plan component's performance measure. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OrgId: integer
(int64)
Read Only:
trueThe unique identifier of the business unit. -
PlanComponentId: integer
(int64)
Read Only:
trueThe unique identifier of the plan component. -
PlanComponentMeasureName: string
Title:
Performance MeasureRead Only:trueMaximum Length:80The name of the plan component's performance measure. -
PlanComponentName: string
Title:
Plan ComponentRead Only:trueMaximum Length:80The name of the plan component. -
PlanComponentResultAttribute: string
Title:
Plan Component Result AttributeRead Only:trueMaximum Length:23The attribute of the plan component.
Nested Schema : Expression Detail Plan Component Measure Result Attributes
Type:
arrayTitle:
Expression Detail Plan Component Measure Result AttributesThe plan component measure result attributes list of values resource is used to view the list of attributes of a performance measure within a plan component that can be used in an expression.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-expressionDetailPlanComponents-expressionDetailPlanComponentAttributes-expressionDetailPlanComponentsMeasures-expressionDetailPlanComponentsMeasureResultAttributes-item-response
Type:
Show Source
object-
AttributeConfigId: integer
(int64)
Read Only:
trueThe unique identifier of the plan component's performance measure attribute. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OrgId: integer
(int64)
Read Only:
trueThe unique identifier of the business unit. -
PlanComponentMeasureResultAttribute: string
Title:
Plan Component Measure Result AttributeRead Only:trueMaximum Length:60The plan component's performance measure's attribute.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-expressionDetailUserDefinedFunctions-item-response
Type:
Show Source
object-
ExpressionDetailTypeCode: string
Read Only:
trueMaximum Length:30The code indicating the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OrgId: integer
(int64)
Read Only:
trueThe unique identifier of the business unit. -
UserDefinedFunction: string
Read Only:
trueMaximum Length:30The group or category that the predefined functions belong to. -
UserDefinedFunctionName: string
Title:
User-Defined Function NameRead Only:trueMaximum Length:80The name of the predefined PL/SQL function. A list of accepted values are listed in the lookup type CN_USER_FUNCTIONS. -
UserFunctionCode: string
Read Only:
trueMaximum Length:30The lookup code pertaining to the predefined PL/SQL function. A list of accepted values are listed in the lookup type CN_USER_FUNCTIONS.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : incentiveCompensationExpressionDetailItemsLOV-ExpressionDetailUserDefinedQueryValueSets-item-response
Type:
Show Source
object-
ExpressionDetailTypeCode: string
Read Only:
trueMaximum Length:255The code indicating the type or category of the entity used in an expression. A list of accepted values are listed in the lookup type ORA_CN_EXPRESSION_DETAIL_TYPE. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
UserDefinedQuery: string
Read Only:
trueMaximum Length:30The code indicating the user defined query using a value set. A list of accepted values are listed in the lookup type ORA_CN_USR_DEFN_EXPRSN_VLE_SET. -
UserDefinedQueryDescription: string
Title:
User-Defined Query DescriptionRead Only:trueMaximum Length:240The name of the user defined query. A list of accepted values are listed in the lookup codes description column for lookup type ORA_CN_USR_DEFN_EXPRSN_VLE_SET. -
UserDefinedQueryName: string
Title:
User-Defined QueryRead Only:trueMaximum Length:80The name of the user defined query. A list of accepted values are listed in the lookup type ORA_CN_USR_DEFN_EXPRSN_VLE_SET. -
UserDefinedValueSetCode: string
Read Only:
trueMaximum Length:60The code indicating the value set used in the user-defined query. -
WhereClause: string
Read Only:
trueMaximum Length:4000The where clause of the value set used in the user-defined query.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source