APPACTIVITY¶
This source table stores information about applicant activities.
Columns¶
| Column | Data type | Description |
|---|---|---|
APPACTAPP |
NUMBER | Talent/applicant identifier for the activity. |
APPACTAUTH |
NUMBER | User identifier for the author of the activity. |
APPACTDATE |
TIMESTAMP_NTZ | Date of the activity. |
APPACTDATEUTC |
TIMESTAMP_NTZ | Date of the activity in UTC. |
APPACTID |
NUMBER | The identifier for the talent/applicant activity. |
APPACTNOTES |
VARCHAR | Activity notes or details. |
APPACTTYPE |
NUMBER | The identifier for the activity type. |
APPCOMPLETED |
NUMBER | Completed flag. |
APPCOMPLETEDATE |
TIMESTAMP_NTZ | Completion date. |
APPCOMPLETEUTC |
TIMESTAMP_NTZ | Completion date in UTC. |
APPCREATETIME |
TIMESTAMP_NTZ | Activity creation time. |
APPCREATEUTC |
TIMESTAMP_NTZ | Activity creation time in UTC. |
APPTIME |
VARCHAR | A text field that can store date and/or time information (e.g., "11:00 AM" or "11/11/2025 19:25:19"). |
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. |
EXTERNALDB |
VARCHAR | For Avionté internal use only. Non-null values typically indicate the row was imported from another data source. |
LASTUPDATEDDATE |
TIMESTAMP_NTZ | The timestamp when the row was last updated. |
MIGORIGIN |
VARCHAR | For Avionté internal use only. |
OLDID |
NUMBER | For Avionté internal use only. |
PINNED |
NUMBER | Pinned flag. |
REQRECORDID |
NUMBER | The identifier for the req record. Used to join an applicant activity to a particular requisition. |
SYNCMAIL |
NUMBER | Sync mail flag indicating whether the activity is a synced email message. |
TASKID |
NUMBER | The identifier of the related task. |
TEMPBUILDID |
NUMBER | For Avionté internal use only. |