---
title: aioc.sapm_password_request
slug: kronpam-how-to-guides-180/aiocsapmpasswordrequest
description: Learn about the table that stores records for approving SAPM accounts. It contains columns for primary keys, usernames, creation dates, request statuses, administrators, expiration times, comments, client IPs, second level approvals, expiration dates, act
docTags: 
createdAt: 2022-08-18T16:36:10.000Z
---

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                                                          |