CATSTimeSheets
Retrieve all time sheets entered in SAP CATS (Cross-Application Time Sheet) that are now in Draft, Rejected, and/or Pending Approval status within a provided parameter using the CATS Time Sheet Download connector.
View Specific Information
The following pseudo-columns should be specified in the WHERE clause in order to query the view:
- StartDate specifies the start date of time sheets.
- EndDate specifies the end date of time sheets.
For example:
SELECT * FROM CATSTimeSheets WHERE StartDate = '2023/01/01' AND EndDate = '2023/04/01'
Columns
| Name | Type | Description |
| Job_Seeker_ID | String | Unique identifier for the worker associated with the SAP CATS record. |
| TIMESHEET ID | String | The TIMESHEET ID associated to the SAP CATS record. |
| Worker_Id | String | The Worker_Id associated to the SAP CATS record. |
| Buyer_Ref | String | The Buyer_Ref associated to the SAP CATS record (if applicable). |
| Worker_Name | String | The Worker_Name associated to the SAP CATS record. |
| Entry_Date | Date | The Entry_Date value in the SAP CATS table. |
| Cost Center Code | String | Cost Center Code against which time is being recorded. |
| GL Account Code | String | General Ledger Account Code against which time is being recorded. Company configuration 'Require GLA Allocation on Job Postings and Statements of Work' must be enabled. Company configuration 'Enable Rate Schedule' must be enabled. |
| Task Code | String | Task Code against which time is being recorded. |
| Segmented Object Detail | String | Segmented Object Detail string. Segments will be separated by delimiter on the Segmented Object. Valid delimiters are colon (:), semi-colon (;), pipe (|), and dash (-). Required if 'Enable Segmented Object Detail' configuration set. This field is mutually exclusive with GL Account fields. More than one string can appear for a cost center. |
| Shift Code | String | Shift Code against which time is being recorded. Company configuration 'Enable Rate Schedule' must be enabled. |
| Time_In | String | The Time_In value in the SAP CATS table. |
| Time_Out | String | The Time_Out value in the SAP CATS table. |
| Comments | String | The Comments value in the SAP CATS table. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| StartDate | Date | This parameter specifies the start date of time sheets in MM/DD/YYYY format. |
| EndDate | Date | This parameter specifies the end date of time sheets in MM/DD/YYYY format. |