CONFIGCHOICE

This source table stores information about CLASSIC / Back Office Configuration Choices.

Columns

Column	Data type	Description
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.
CHOICECODE	VARCHAR	The Code / Name of the configuration setting.
CHOICECODEDESC	VARCHAR	The description of the configuration setting.
CONFIGCHOICECATEGORYID	NUMBER	The identifier for the Config Choice Category.
CONFIGCHOICEGUID	VARCHAR	The identifier for the Config Choice, formatted as a GUID.
CONFIGCHOICEID	NUMBER	The identifier for the Config Choice.
DATEENTERED	TIMESTAMP_NTZ	The timestamp when the Config Choice was created.
ENTEREDBYUSERGUID	VARCHAR	The User GUID for the person that created the Config Choice.
LASTUPDATEDDATE	TIMESTAMP_NTZ	The timestamp when the row was last updated.
OFFSETVALUE	NUMBER	For Avionté internal use only.
ROOTSTAFFINGSUPPLIERGUID	VARCHAR	The Root Staffing Supplier the Config Choice is used in.
SETUPTABLE	VARCHAR	For Avionté internal use only.