The Input Pass Thru output fields are available for Desktop (Access) and Desktop (XML) Application Types. Input Pass Thru's are items from the input data that you write directly onto the output. Some data items that might typically be used in this context are date of birth, date of hire, name, status history with labels (rather than codes), etc.

Description is a text field in which you enter a helpful descriptive name by which the entry will be known. This may be any phrase including spaces. All characters are available. These are the names you will see in the Output Definition Results report.

If using the Application Type Desktop (Access):

Output Field Name is the name that you want displayed with the calculation results in the reports and, for scalars, the column heading for the Access database. For arrays, the Output Field Name will appear in the VarName column of the InputPassThruArrays table and the Description will be written to the Name column.

Data Dictionary is a multi-choice field that displays all the unhidden entries from the Data Dictionary. Select the field that you want from the list. When you select a coded field (either scalar or array), then you have the additional option of  whether to Output the codes or the labels. For example, for a location field, you would have the option of writing either the location number or the location name to Access.

When writing the Output Definition results to Access, all Input Pass Thru arrays are written to a new table called InputPassThruArrays. The Primary Keys in this table are RunID, VarName, Name, StartDate, and StopDate.  For effective date arrays, the StopDate is set to 1/1/1900 because NULLs are not allowed in Primary Key fields. The array's value is written to the Value, Date, or Label column depending on the underlying data type of array Data Dictionary field.

If using the Application Type Desktop (XML):

Input: is a multi-choice field that displays all the unhidden fields in the Data Dictionary. Select the field that you want from the list.

Under the Output: label, select Field: to pull the XML output field definition (i.e., the XML tag(s) to which the output will be written) from the Input Pass Thru fields defined in the XML Output Linkage, or select XML tag(s):  to directly choose the output XML tag(s).

If you select XML tag(s) for the Output,  the choices on the dialog box will vary depending on the type of Data Dictionary field selected as the Input.

• If the input is a scalar field, specify a path and tag from the XML Output Schema where you want the scalar value written. You can click on the  button to choose a path and tag from those in the schema. 

• If the input is an effective date array field, then under ​XML tags:, you must select a Container tag, a Value tag, and an Effective date tag.  You can click on the  button to choose a path for the Container or a (path and) tag for the Value and effective date field.  Once a Container has been specified,   button will only list the tags within that container for the Value and Effective date.

• If the input is a start and stop array field, then under ​XML tags:, you must select a Container tag, a Value tag, a Start date tag, and a Stop date tag.  You can click on the  button to choose a path for the Container or a (path and) tag for the Value and date fields.  Once a Container has been specified,   button will only list the tags within that container for the Value and date fields. 

When you select a coded field (either scalar or array), you have the additional option of whether to Output the codes or the labels. For example, for a location field, you would have the option of writing either the location number or the location name to XML.