Digital Signatures Table
This table contains all details of digital signatures which is required to be kept in record. We have following columns in this tables to keep records.
Mandatory Fields
All these fields are mandatory to be filled up as the other fields are dependent on these, else all records will be incomplete.
Name of DSC Holder
You will have to put full name of DSC holder. E.g. Amitabh Bachhan
Start Date of DSC
It contains the date of Digital signature on which it was downloaded. Based on this, the Expiry date of DSC will be calculated.
Client
This field is a linked field which is linked to Client Table, so you can only select Client if it is included in the Client Table.
You can also add details of new Client directly from Digital Signature Table. You can see following screenshot on how to add it.
Years Valid
In this field, we mention 1, 2 or 3 as these are the number of years the digital signature is generally valid. You can also set default value. Currently, default value is 2.
Token Type
This is drop-down field wherein different options are given such as ePass2003, ProxyKey, TrustKey, Moserbaer, WatchData etc.
Token Password
This is text field which contains password of the DSC token. You can also set default value. Currently, default value is 12345678.
Initial Possession
In this field, while adding the record of this DSC, if the DSC token is with you, you have to select this checkbox, else leave it unchecked. This will determine the current possession field.
Calculated Fields
These are the fields which are calculated based on existing fields.
Since these are calculated fields, please do not delete this field, else the template may not work as desired.
End Date of DSC
This is the date which will be automatically calculated based on Start Date of DSC and number of Years Valid.
E.g. If DSC's start date is 15th February, 2022 and it is valid for 2 years, then End/Expiry Date will be 15th February, 2024.
Current Possession
Current Possession determines the current possession of the DSC token which is dependent on the Initial Possession and any change in Possession after Movement of DSC.
Add Movement
This is a Button field, which if clicked, will open a form and add a movement of DSC to DSC Movement Table. You can click here to know more on how to add movement to DSC.
Expiring in
This is a field which is calculated based on End Date of DSC and today's date. This will show in how many days a DSC will be expired.
DSC Status
This status shows total three types of status which is calculated based on days of expiring.
Active Status - the days left for expiring is more 30 days
Expiring Soon - the days left for expiring DSC is 30 days or less
Expired DSC - when the DSC is already expired
Optional Fields
These fields are optional fields which you may keep or remove based on your requirements.
You can hide these optional fields if you do not require these in your database. Click here to know how.
Color
You can assign a color code to each DSC e.g. based on the color keychain we attach to the DSC token. There is a separate Table which already contain few common colors.
Container
If you are keeping the Digital Signatures in different boxes/drawers etc., you can select the suitable options here. Currently default values are Box 1, Box 2 etc.
You can change it based on your requirements (Click here to know on how you can do it)
Partner Code
If in your firm, Digital Signatures are assigned to specific partners, you can add names of Firm's partners.
Click here to know how to add names of Partners
Location
If you have more than one office and keeps Digital Signatures in different offices, you can record the details in better way by selecting proper location of the DSC.
Click here to know how to add your firm's Locations
Vendor
If your Firm purchases Digital Signatures from different vendors, then you can accordingly keep records of Vendors.
Click here to know how to add details of Vendors.
Hidden Fields
There are many calculated fields which are hidden as of now, as these fields are created to do all calculations for desired output.
Please make sure not to delete any hidden fields, else the Template will not work as desired.
Last updated
