DIMCUSTOMER¶
This dimension table stores information about individual customers/clients. There’s only one row in the table and it has setup information for a client.
Columns¶
| Column | Data type | Description |
|---|---|---|
ADHOC |
NUMBER | Not used. |
AMPCODE |
VARCHAR | The unique Avionté Customer Code for a given Avionté Customer. |
BACKOFFICEDBNAME |
VARCHAR | The corresponding client's CLASSIC database name. |
BUILDID |
NUMBER | Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows. |
C2CBURDEN |
NUMBER | The Corporation-to-Corporation Burden rate. |
CUSTOMERACTIVE |
NUMBER | An indication of whether the customer/client record is active or not. |
CUSTOMERBUILDID |
NUMBER | This column has the same value BUILDID. |
CUSTOMERKEY |
NUMBER | The primary key referencing a customer/client record. |
CUSTOMERNAME |
VARCHAR | The name of the customer/client. For a visual reference of this data element in the source system, see Appendix B: CUSTOMERNAME. |
DATALOADED |
NUMBER | An indication of whether the customer/client record is loaded in Snowflake or not. |
DMSTASKNAME |
VARCHAR | DMS Task Name. For Avionté internal use only. |
DWFILEID |
VARCHAR | Not used. |
DWINSERTEDDATE |
TIMESTAMP_NTZ | The date and time when the customer/client record was inserted. |
DWISACTIVE |
VARCHAR | An indication of whether the customer/client record is active or not. Values: 1 for the existing record, 0 for the deleted record. |
DWUPDATEDBY |
VARCHAR | The user who last updated the customer/client record. |
DWUPDATEDDATE |
TIMESTAMP_NTZ | The date and time when the customer/client record was last updated. |
ESTHOURS |
NUMBER | The estimated number of hours. |
INSIGHTSINTEGRATEDCLIENT |
VARCHAR | An indication of whether the client is Insights or Front Office only client. |
INSTPRODUCTION |
NUMBER | The identifier for the production instance. |
INSTURL |
VARCHAR | The URL of the production instance. |
MODDATE |
TIMESTAMP_NTZ | The date and time when the customer/client record was modified. |
TEN99BURDEN |
NUMBER | The 1099 Burden factor defined per customer/client level (Contractor). |
W2BURDEN |
NUMBER | The W2 Burden factor defined per customer/client level (Regular talent). |