aioc.sapm_password_request
The table keeps the records for the SAPM accounts approval by the user (Approve/Disapprove Records)
Column | Data Type | Description |
|---|---|---|
Id | Bigint | Primary Key |
Username | Varchar | UserName |
Creation_Date | Date | Request created date |
Sapm_account_id | Bigint | Foreign key to sapm_account table |
Request_status | Varchar | APPROVED/REJECTED/WAITING/DISAPPROVED/CANCELLED |
Responsible_admin | Varchar | Manager of the approval |
Expiration_time | Bigint | If the parameter is set, this field keeps the expiration period for an approved record |
Request_comment | Varchar | Password requester comment about why it is needed |
Client_IP | Varchar | Client IP address of the requester |
Second_level_admin | Varchar | If the parameter is set, this field keeps second level approval manager |
Expiration_Date | Date | Expiration_Date |
Last_activity_date | Date | Last activity Date |
Approval_Type | Varchar | SAPM_ACCOUNT or SAPM_GROUP |
Parent_request | Bigint | If there is parent request id |