CONFIGTRANSACTIONTYPE¶
This source table stores information about CLASSIC / Back Office Configuration Transaction Types.
Columns¶
| Column | Data type | Description |
|---|---|---|
ALLOWMULTIPLEENTRY |
NUMBER | A flag indicating whether multiple entries are allowed or not. |
ALLOWWEBTIMEENTRY |
NUMBER | A flag indicating whether web time entry is allowed. |
BUILDID |
VARCHAR | Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows. |
CDCSTATUS |
VARCHAR | For Avionté internal use only. |
CONFIGTRANSACTIONTYPEGUID |
VARCHAR | The Config Transaction Type identifier for the row, formatted as GUID. |
CONFIGTRANSACTIONTYPEID |
NUMBER | The Config Transaction Type identifier for the row. |
DEDUCTIONCATEGORYID |
NUMBER | The Deduction Category identifier for the row. |
DESCRIPTION |
VARCHAR | The Description of the Config Transaction Type. |
EXTERNALDEDUCTIONID |
NUMBER | The external deduction identifier for the row. |
ISBENEFIT |
NUMBER | A flag indicating whether the Config Transaction Type is a benefit. |
ISDEDUCTION |
NUMBER | A flag indicating whether the Config Transaction Type is a deduction. |
ISDISCRETIONARYBONUS |
NUMBER | A flag indication whether the Config Transaction Type is a discretionary bonus. |
ISEQUIPMENT |
NUMBER | A flag indicating whether the Config Transaction Type is for equipment. |
ISHEALTHCARE |
NUMBER | A flag indicating whether the Config Transaction Type is for healthcare. |
ISPERMANENT |
NUMBER | A flag indicating whether the Config Transaction Type is permanent. |
ISTIERED |
NUMBER | A flag indicating whether the Config Transaction Type is tiered. |
ISTRANSACTIONAL |
NUMBER | A flag indicating whether the Config Transaction Type is transactional. |
LASTUPDATEDDATE |
TIMESTAMP_NTZ | The timestamp when the row was last updated. |
NAME |
— | Not documented in v1.5 of the source PDF. |
OFFSETVALUE |
NUMBER | For Avionté internal use only. |
ROOTSTAFFINGSUPPLIERGUID |
VARCHAR | The unique identifier for the Root Staffing Supplier, formatted as a GUID. |
SHOWEMPLOYERCONTRIBUTIONONPAYCHECK |
NUMBER | A flag indicating whether the employer contribution should be shown on the paycheck for this Config Transaction Type. |
SORTORDER |
NUMBER | The sort order for the Config Transaction Types. |
SYNCEDTOFRONTOFFICE |
NUMBER | A flag indicating whether this Config Transaction Type is synced with BOLD / Front Office. |
SYSTEMNAME |
VARCHAR | The System Name for the Config Transaction Type. |
VERTEXCMPCODE |
NUMBER | The Vertex Comp Code for the Config Transaction Type. |
W2BOX |
VARCHAR | The W-2 box that holds the Config Transaction Type. |
W2LABEL |
VARCHAR | The label for the W-2 entry for the Config Transaction Type. |