REQ_ATTACHMENTS

This source table stores information about documents that have been attached to a BOLD / Front Office Req.

Columns

Column	Data type	Description
ATTIDATTTYPE	NUMBER	The identifier for this record The type of attachment.
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.
CDCSTATUS	VARCHAR	For Avionté internal use only.
DATEUPLOADED	TIMESTAMP_NTZ	The timestamp the document was uploaded.
EXTERNALDB	VARCHAR	For Avionté internal use only. Non-null values typically mean the row was imported from another data source.
HCMNAME	VARCHAR	For Avionté internal use only. The filename Avionté uses to store the file internally.
JOBDOCTYPEID	NUMBER	The identifier for the job document type.
LASTUPDATEDDATE	TIMESTAMP_NTZ	The timestamp when the row was last updated.
OLDID	NUMBER	For Avionté internal use only.
ORIGNAME	VARCHAR	The original human readable filename.
REQID	VARCHAR	The identifier for the requisition.
REQRECORDID	NUMBER	The identifier for the requisition record.
TEMPBUILDID	NUMBER	For Avionté internal use only.
UPLOADEDBY	VARCHAR	The HCM ID of the user who uploaded the attachment.
UPLOADUSERID	NUMBER	The user ID of the user who uploaded the attachment.