Source Type

Specifies the source type where a new Source Type is to be used. Source Types that can be used with Form Builder are Table, Query, View, and rowsources:

Table

This Source Type points to a specific table in the database. This Type can return all the fields in that table. Source Parameters include:

  • Table name - For example, project.
  • Primary key sequence - Specify a sequence when inserting records. For example, seq_butvr_id.
  • Primary key field index - Displays a column number of where Primary Key resides. For example, 1.

Query

Allows user to specify custom SQL statements varying in complexity. Source Parameters include:

  • SQL query - Standard SQL query.
  • Primary key field index - The column number where Primary Key resides.
  • Extra query parameters - Used for jdbc parameters, usually looking for variable names or constants used with jdbc.

View

Points to a specific view in the database. This type returns all the fields in that table. Source Parameters include:

  • View name
  • Table name
  • Primary key sequence - Used for specifying a sequence when inserting records.
  • Primary key field index - The column number where Primary Key resides.

Cross Tab

A specialized rowsource for creating cross-tab reports. Source Parameters include:

  • Base Data SQL - The SQL query that returns data to be summarized.
  • Row Headings - A comma separated list of rows to use as the grouping of data.
  • Column Heading - Column to use as heading.
  • Column Head SQL - The SQL query that returns a set of possible column headings.
  • Operation - The options are SUM, AVG, MAX, MIN.
  • Operation Argument - The column to use as argument in an operation.
  • Add Else Case - Includes data not belonging to column headings listed.
  • Add Row Summary - Includes a row summary column.

[rowsource]

In certain situations, the Form Builder Data Source control type “query” does not provide an efficient means to specify the data source. For example, if you want to use complex SQL queries. When the SQL queries become complex and inefficient to handle special cases, use rowsources.

In the following example, the user specifies a view called View_Recipient_Message for a data source (for example, dsView) to which the user links a Label control. The view displays the data when the report is run.

EMPLOYEE

Returns employee attributes as of the given date.

Parameters:

  • EmpId : Required employee ID (that is, emp_id field)
  • WorkDate : Required date

EMPLOYEE DEFAULT LABOR

Returns employee default labor table attributes as of the given date.

Parameters:

  • EmpId : Required employee ID (for example, emp_id field)
  • WorkDate : Required date

EMPLOYEE BALANCE

Returns employee balance attributes from the given date and balances.

Parameters:

  • EmpId : Required employee ID (for example, emp_id field)
  • WorkDate : Required date
  • BalanceNames : Required balance in comma-delimited format (that is, VACATION,SICK). Use an asterisk (*) for all balances.

METRICS.PAGE

Provides access to page metrics gathered by the WFM system using the PageMetricsSource class. See the Troubleshooting chapter of the Time and Attendance Implementation and Administration Guide.

MAINTENANCE_SCHEDULE

Returns information for registry variables found under system/security/maintenance.

PROP.JAVA

Returns information for standard Java system properties, using the System.getProperties(); method.

CONDITION

Returns information for registry variables found under system/rules/conditonclasses.

SEC_EMPLOYEE_LOOKUP

Returns employees based on security registry parameters.

SEC_WORKBRAIN_TEAM

Returns security teams.



Examples of Table and Query source types are shown in the sample reports of this document.