SSP Timesheet field parameter variables
Administrators can configure dependent field lookups where a primary field's selected value dynamically filters the available options in secondary fields. For example, when an employee selects a Department, the Project and Docket lookups automatically show only the values associated with that Department.
The SSP Timesheet publishes context parameters from each field into the sourceData object. Secondary fields can reference these parameters in their sourceParams configuration using the syntax #control.<KEY>#. All parameters in SSP use the #control.<KEY># format. The CONTEXT keyword is not needed for SSP Timesheet. For example, sourceParams='STRING==#control.DEPT_NAME#'.
When a user selects a value in a primary field, the SSP Timesheet publishes the selected value as a context parameter, for example DEPT_NAME. The timesheet then passes it to any secondary field whose sourceParams references that key. The timesheet then re-executes the secondary field's lookup query, filtering results based on the primary field's value. If a primary field is empty, null, or undefined, its key is omitted from sourceData. The secondary field's lookup behaves as if no filter was applied for that parameter.
The following parameters are published into sourceData and can be consumed from field configurations as #control.<KEY>#.
The following parameters are always published for all row types.
| Key | Description |
|---|---|
EMP_ID |
Employee ID |
WORK_DATE |
Work date |
WRKS_ID |
Work summary ID |
TCODE_NAME |
Time code |
HTYPE_NAME |
Hour type |
JOB_NAME |
Job |
DEPT_NAME |
Department |
LOC_NAME |
Location |
DOCK_NAME |
Docket |
WBT_NAME |
Team |
PROJ_NAME |
Project |
ACCTA_ID |
Account access |
ACCTP_ID |
Account project |
ACCTU_ID |
Account unit |
WRKD_FLAG1 through WRKD_FLAG10 |
Custom field scalar for all row types |
WRKD_UDF1throughWRKD_UDF10 |
Custom field scalar for all row types |
ACCTD_ONE_IDthrough ACCTD_TEN_ID |
Account ID |
Use the following parameters for Work Detail rows only.
| Key | Description |
|---|---|
START_TIME |
Combined start date and start time |
END_TIME |
Combined end date and end time |
RATE |
Rate |
Use the following parameters for Premium row only in addition to the shared keys.
| Key | Description |
|---|---|
RATE |
Rate |
In the SSP timesheet, existing localization configurations that reference context variables will function correctly without modification. The SSP Timesheet field configurations are managed through the SSP config mode or the Admin Portal's maintenance forms.