tbl_stage_trigger_status

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single execution record of a stage trigger.

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The user ID or system process that initiated the action which fired the trigger.

Timestamp of when the trigger execution record was created.
Stored as: UTC
Logic: Records when the automated process started.

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The last user or system process that modified the trigger status record (e.g., updating the final status).

Timestamp of when the trigger status record was last modified.
Stored as: UTC
Logic: Records when the trigger process finished or its status was updated.

FK: public.tbl_employee.employeeid or other entity ID (Presumed Foreign Key)
Meaning: The ID of the record/object (e.g., employee, candidate, leave request) on which the trigger was executed.

The module or type of business object being processed by the trigger.
Format: Varchar/Text or lookup key
Example: Recruitment, Leave Management.

The outcome of the trigger execution.
Format: Varchar/Text or SmallInt
Example: Success, Failure, Pending, Skipped.
Logic: Indicates if the automated action completed successfully.

Detailed log data or response payload from the trigger action.
Format: JSONB or Text
Usage: Contains error messages on failure or execution details on success (e.g., API response, email content).

The stage of the workflow at the time the trigger was executed.
FK: public.tbl_stage.id (Presumed Foreign Key)
Logic: Provides workflow context for the trigger activity.

FK: public.tbl_stage_trigger.id
Meaning: The specific trigger rule that was executed.
Dependency: Links the status record back to the defined rule.