Document ID: GETN057 Module: User Management / Security / Auditing Purpose: To track and display the identity of the user who created a specific record. 1. Overview The "Added By Users" (GETN057) functionality is an audit and control mechanism designed to capture the User ID of the individual who initially created a record. This field is automatically populated by the system upon the successful creation of a new entry and cannot be manually edited by end-users. Terjemah Kitab Qutul Qulub Pdf Upd Fixed Apr 2026
SELECT record_id, record_name, created_by FROM application_table WHERE created_by = 'target_user_id'; | Issue | Possible Cause | Resolution | | :--- | :--- | :--- | | Field displays "System" | Record was created via a scheduled batch job or backend script. | Verify if the record was migrated or created by an automated process. | | Field is blank | Record existed before this feature was implemented (Legacy Data). | Run a data update script to populate legacy records with a default value (e.g., 'ARCHIVE_USER'). | | Incorrect User Displayed | User account was renamed after the record was created. | The field captures the ID at the moment of creation . This is expected behavior unless the system uses a dynamic lookup to the User Table. | 8. Revision History | Version | Date | Author | Description | | :--- | :--- | :--- | :--- | | 1.0 | 2023-10-27 | System | Initial creation of GETN057 specification. | Kwentong Kalibugan Sa Bata Exclusive