Rate Cards
A rate card is a record that contains the rates at which a client is charged and a worker is paid for logged time against a placement. It enables effective tracking of financials associated with time logs and therefore is an essential part of time logging.
Rate card object
Rate cards are stored within the Rate Card (seven20__Rate_Card__c) object. The object has the following fields:
| Field Label | API Name | Type | Description |
|---|---|---|---|
| Name | Name | Text(80) | The name of the rate card |
| Charge Rate | seven20__Charge_Rate__c | Currency(16,2) | The rate at which the client is charged |
| Pay Rate | seven20__Pay_Rate__c | Currency(16,2) | The rate at which the worker is paid |
| Active | seven20__Active__c | Checkbox | If checked, the rate card is active, and can be used in time logging |
| Is Standard | seven20__Default_Rate_Card__c | Checkbox | If checked, the rate card is the default rate card for the placement |
| Currency | CurrencyIsoCode | Picklist | The currency that the rates are in |
| Placement | seven20__Placement__c | Lookup(seven20__Placement__c) | The placement that the rate card is associated with |
| Job | seven20__Job__c | Lookup(seven20__Job__c) | The job that the rate card is associated with |
| Account | seven20__Account__c | Lookup(Account) | The account that the rate card is associated with |
Only one of the Placement, Job or Account fields can be populated on a rate card.
Account and Job rate cards
Rate cards can also be configured on the Account and Job objects. These rate cards allow for templates to be defined for accounts, or jobs, which use consistent rate cards. Rate cards on the Account level can be cloned to any newly created jobs, and those on the Job level can be cloned to any newly created placements. This is managed through the use of a picklist field on each object, as follows:
| Object | Field API Name |
|---|---|
| Account | seven20__Convert_Rate_Cards_To_Jobs__c |
| Job | seven20__Convert_Rate_Cards_To_Placements__c |
For rate cards to be copied, the value of the picklist must equal Yes.
Do not change the API values of the picklist options.
Standard / Default rate card
A standard rate card is a rate card that is created by default based on the seven20__Charge_Rate__c and seven20__Pay_Rate__c fields on the placement. The standard rate card is created when the placement is created and is updated when the placement is updated. It has the following fields set:
| Field API Name | Value |
|---|---|
| Name | "Standard" |
| seven20__Charge_Rate__c | Value from Placement |
| seven20__Pay_Rate__c | Value from Placement |
| seven20__Active__c | TRUE |
| seven20__Default_Rate_Card__c | TRUE |
| seven20__Placement__c | Placement record Id |
If either the seven20__Charge_Rate__c or seven20__Pay_Rate__c fields are not set on the placement, the standard rate card will have the field set as 0. If neither value is set, the standard rate card will not be created.
It is not possible to manually flag records as the standard rate card through the Configure Rate Cards UI.
There is no restriction for automations creating/updating the standard rate card, however any changes to seven20__Charge_Rate__c or seven20__Pay_Rate__c on the Placement record will cause any values to be overridden.
This functionality is controlled via a Seven20 Configuration setting record with the developer name Create_Standard_Rate_Cards, which is disabled by default. If enabled, the standard rate card will be created when the placement is created, but any existing placements will not retroactively have a standard rate card created.
Configuring rate cards
Rate cards can be configured through the Configure Rate Cards quick action that is available on the Placement, Job and Account objects. Activating the quick action opens a modal which is used to manage existing and new rate cards. The contents of this modal are the same regardless of the object it is launched from.
The modal consists of a table with the following columns:
| Column | Type | Required | Description |
|---|---|---|---|
| Name | Text(80) | Yes | The name of the rate card |
| Description | Text(255) | No | A description of the rate card |
| Pay Rate | Currency(16,2) | Yes | The rate at which the worker is paid |
| Charge Rate | Currency(16,2) | Yes | The rate at which the client is charged |
| Active | Checkbox | No | If checked, the rate card is active |
| Is Standard | Checkbox | No | If checked, the rate card is the standard rate card for the placement. This column cannot be edited |
| Remove Bin button | Button | N/A | A button to remove a newly added rate card, only available for new rate cards that havent been saved to the database |
Pressing the save button will save the rate cards and close the modal. Any created rate cards will have the appropriate lookup populated with the Id of the record it was launched from.
Rate cards can also be created programmatically, so long as the above required fields are populated.