Sub-Title Crosswalk

The Sub-Title Crosswalk (STCW) page is used to map which employee assignment (ESMT) Sub-Titles can be used with which Position (PSMT) Sub-Titles.
The page allows sites to control their salary budgets based on approved positions. These positions are based on their title and sub-title; therefore, departments should be using the same or equivalent sub-titles as from the position when hiring or assigning employees to the positions to ensure they have enough budget for the year.
This page is used to map Employee Assignment (ESMT) Sub-Titles with Position (PSMT) Sub-Titles. When this feature is used (that is, the Enable Subtitle Crosswalk flag is selected on Extended Department (DEPTX)) and the STCW page is configured, then related validations are enforced on ESMT creation and modification.

Field InformationField Information

The Sub-Title Crosswalk reference page contains the following fields:

Field Name	Field Description
PSMT Sub-Title	The PSMT Sub-Title that will be cross walked to a valid ESMT Sub-Title. Must exist on the Sub-Title (STTL) table.
ESMT Sub-Title	The ESMT Sub-Title that is valid against the PSMT Sub-Title. Must exist on the Sub-Title (STTL) table.
From	The date this information becomes effective. This field should be entered in mm/dd/ccyy format.
To	The last date for which this information is effective. The default value for the operating system is 12/31/9999, which indicates the latest available date.

The pick lists associated with Sub-Title fields are not tied to Title and Sub - Title relationships. The pick lists are independent of Title and allows user to pick a correct Sub-Title. Even the validation on ESMT based on the crosswalk table does not look at the associated Title.
No wildcard values for either the ESMT Sub-Title or the PSMT Sub-Title fields are supported on the STCW page.

Data from STCW can be downloaded into spreadsheet format by clicking the Download action from the Grid Actions menu. Once downloaded, the data can be updated and uploaded back to STCW by selecting Upload from the Grid Actions menu. The Download action is available when there is at least one record returned as a result of a browse or search action. When the Download action is selected, all data that was returned as a result of the previous browse or search is selected for download. Once the download is complete the data can be manipulated using the preferred spreadsheet application and can then be uploaded back to STCW, based on the user’s security setup. If the user can add records to the reference table online, they are able to upload records to the table. If additional security is desired, the System Maintenance Utility job that is triggered by the Upload action can be configured with Job Security to restrict the Upload action.
If you plan to use the Download action, data in the fields on this page should not contain any special characters, including return characters. When opening the downloaded file, if special characters are present in the reference page record, that particular record might be, for example, split into two records in the downloaded file, and the extra records would have to be manually deleted/modified.