PAYMENTCHECK

This source table stores information about CLASSIC / Back Office Payment Checks.

Columns

Column	Data type	Description
1099NOTREQUIRED	NUMBER	A flag indicating whether 1099 is required or not.
AGENCYPAYAMOUNT	NUMBER	The agency payment amount for the check.
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.
CHECKDELIVERY	VARCHAR	A text field indicating where the check should be (or was) delivered (e.g., Branch, Mail).
CHECKNUMBER	VARCHAR	The check number.
CHECKSTATUSCONFIGSYSTEMCHOICEID	NUMBER	The check status config system choice identifier.
DATECLEARED	TIMESTAMP_NTZ	The date the check cleared.
EXTERNALDB	VARCHAR	For Avionté internal use only. Non-null values typically mean the row was imported from another data source.
EXTERNALID	VARCHAR	For Avionté internal use only. Non-null values typically mean the row was imported from another data source.
GROSSAMOUNT	NUMBER	The gross amount for the check.
ISDIRECTDEPOSIT	NUMBER	A flag indicating whether the check is a direct deposit or not.
ISW2	NUMBER	A flag indicating whether the check is for a W-2 talent.
LASTUPDATEDDATE	TIMESTAMP_NTZ	The timestamp when the row was last updated.
NETAMOUNT	NUMBER	The net amount of the check.
NETCHECK	NUMBER	The net check amount.
OFFSETVALUE	NUMBER	For Avionté internal use only.
PAYEEGUID	VARCHAR	The unique identifier for the payee, formatted as a GUID.
PAYEETYPECONFIGSYSTEMCHOICEID	NUMBER	The payee type config system choice identifier.
PAYMENTBATCHCHECKSEQUENCE	NUMBER	The payment batch sequence number.
PAYMENTBATCHGUID	VARCHAR	The unique identifier for the payment batch, formatted as a GUID.
PAYMENTCHECKADDRESS	VARCHAR	The payment check address.
PAYMENTCHECKGUID	VARCHAR	The unique identifier for the payment check, formatted as a GUID.
RESIDENTPSDCODE	VARCHAR	The resident PSD code.
REVERSEDBYPAYMENTCHECKGUID	VARCHAR	The GUID for the payment check that reversed this payment check, if applicable.
REVERSEDTOPAYMENTCHECKGUID	VARCHAR	The GUID for the payment check this paycheck was reversed to, if applicable.
ROOTPAYMENTCHECKGUID	VARCHAR	The unique identifier for the root payment check, formatted as a GUID.
STAFFINGSUPPLIERSITEGUID	VARCHAR	The unique identifier for the staffing supplier site, formatted as a GUID.
TOTALBENEFITS	NUMBER	The total benefits amount for the check.
TOTALDEDUCTIONS	NUMBER	The total deductions amount for the check.
TOTALTAXES	NUMBER	The total taxes for the check.
WORKPSDCODE	VARCHAR	The work PSD Code.
YTDGROSS	NUMBER	The year-to-date gross amount for the check.