Tables Schema

Find below the list of available tables from which you can fetch data. Click on the respective table link to get information like column name, description, and data type.

Ptrx_Resource
Top
Column name Description Data type
RESOURCEID (PK) Unique Identifier of the Resource BIGINT
PASSWDRULEID Table header BIGINT
RESOURCENAME The Resource Name which is a unique name for a System or Service SCHAR
DOMAINNAME Domain Name of the resource CHAR
SSHPORT SSH connection port BIGINT
ALACCID
Unique identifier of the Auto Logon Account
BIGINT
RESOURCEDESC
Any additional details about the resource.
CHAR
LOCATION
Any additional details about the resource.
CHAR
DEPARTMENT
Any additional details about the resource.
CHAR
IPADDRESS
IP address of the resource
CHAR
RESOURCEURL
Resource URl of the resource
CHAR
LASTMONITORSYNCTIME
Last Monitor Sync Time
BIGINT
COLUMN_LONG1
Column for custom long attribute.
BIGINT
COLUMN_LONG2
Column for custom long attribute.
BIGINT
COLUMN_LONG3
Column for custom long attribute.
BIGINT
COLUMN_LONG4
Column for custom long attribute.
BIGINT
COLUMN_CHAR1
Column for custom char attribute.
CHAR
COLUMN_CHAR2
Column for custom char attribute.
CHAR
COLUMN_CHAR3
Column for custom char attribute.
CHAR
COLUMN_CHAR4
Column for custom char attribute.
CHAR
COLUMN_CHAR5
Column for custom char attribute.
CHAR
COLUMN_CHAR6
Column for custom char attribute.
CHAR
COLUMN_CHAR7
Column for custom char attribute.
CHAR
COLUMN_CHAR8
Column for custom char attribute.
CHAR
COLUMN_CHAR9
Column for custom char attribute.
CHAR
COLUMN_SCHAR1
Column for custom char attribute.
SCHAR
COLUMN_SCHAR2
Column for custom char attribute.
SCHAR
COLUMN_SCHAR3
Column for custom char attribute.
SCHAR
COLUMN_DATE1
Column for custom date attribute.
DATETIME
COLUMN_DATE2
Column for custom date attribute.
DATETIME
COLUMN_DATE3
Column for custom date attribute.
DATETIME
COLUMN_DATE4
Column for custom date attribute.
DATETIME
COLUMN_FILE1
Column for custom file attribute.
CHAR
COLUMN_FILE2
Column for custom file attribute.
CHAR
COLUMN_FILE3
Column for custom file attribute.
CHAR
COLUMN_FILE4
Column for custom file attribute.
CHAR
AUTOSUBMIT
Autologin to the site
BOOLEAN
PORT
RDP connection port
BIGINT
EXECUTE_PWDADM
Execute pwdadm for IBM AIX resource type
BOOLEAN
DOMAIN_MEMBER_RDP
RDP allowed only to domain members from domain account if this is set to true
BOOLEAN
RESTRICT_LOCAL_ACCOUNT_RDP
Restricts RDP to this resource from local accounts if this is set to true
BOOLEAN
ISDISABLED
This flag is set to true if the resource is disabled in the AD
BOOLEAN
Constraints
Ptrx_Account
Top
Column name Description Data type
ACCOUNTID (PK)
The Unique Identifier for the User Account
BIGINT
RESOURCEID
A Unique Identifier to identify the Resources that has the login name and password pair.
BIGINT
PASSWDID
Unique Identifier for the Password Entity.
BIGINT
PASSWDRULEID

BIGINT
DESCRIPTION
Description of the account for ex, whether it is System specific account or application account.
CHAR
LOGINNAME
A Unique Identifier to identify the Resources that has the login name and password pair.
SCHAR
DOMAINNAME
Domain name where the user account is present
CHAR
COMPLIANTSTATUS
Compliant status of the corresponding password
CHAR
COMPLIANTICON
Compliant icon of the corresponding password
CHAR
COMPLIANTREASON
Compliant reason of the corresponding password
CHAR
EXPIRYSTATUS
Expiry status of the corresponding password
CHAR
PASSWRDSYNCSTATUS
Sync status of the corresponding password with respect to resource
CHAR
TIMESTAMP
Account Creation Time
DATETIME
APPICATIONPORT
Port where the application is running
BIGINT
RESTARTSERVICE
Option to restart associated services to this account
BOOLEAN
RESETLOCALSERVICE
Option to reset associated local services to this account
BOOLEAN
MONITORSTATUS
Current monitor status
BOOLEAN
COLUMN_LONG1
Column for custom long attribute.
BIGINT
COLUMN_LONG2
Column for custom long attribute.
BIGINT
COLUMN_LONG3
Column for custom long attribute.
BIGINT
COLUMN_LONG4
Column for custom long attribute.
BIGINT
COLUMN_CHAR1
Column for custom char attribute.
CHAR
COLUMN_CHAR2
Column for custom char attribute.
CHAR
COLUMN_CHAR3
Column for custom char attribute.
CHAR
COLUMN_CHAR4
Column for custom char attribute.
CHAR
COLUMN_CHAR5
Column for custom char attribute.
CHAR
COLUMN_CHAR6
Column for custom char attribute.
CHAR
COLUMN_CHAR7
Column for custom char attribute.
CHAR
COLUMN_CHAR8
Column for custom char attribute.
CHAR
COLUMN_CHAR9
Column for custom char attribute.
CHAR
COLUMN_SCHAR1
Column for custom char attribute.
SCHAR
COLUMN_SCHAR2
Column for custom char attribute.
SCHAR
COLUMN_SCHAR3
Column for custom char attribute.
SCHAR
COLUMN_DATE1
Column for custom date attribute.
DATETIME
COLUMN_DATE2
Column for custom date attribute.
DATETIME
COLUMN_DATE3
Column for custom date attribute.
DATETIME
COLUMN_DATE4
Column for custom date attribute.
DATETIME
COLUMN_FILE1
Column for custom file attribute.
CHAR
COLUMN_FILE2
Column for custom file attribute.
CHAR
COLUMN_FILE3
Column for custom file attribute.
CHAR
COLUMN_FILE4
Column for custom file attribute.
CHAR
RECORDRDPSESSION
Option to record RDP sessions
BOOLEAN
RECORDCLISESSION
Option to record CLI sessions
BOOLEAN
Constraints
Ptrx_ResourceGroup
Top
Column name Description Data type
GROUPID (PK)
Unique Identifier for a Resource Group.
BIGINT
PASSWDRULEID

BIGINT
USERID

BIGINT
PARENT_ID

BIGINT
NO_OF_PARENTS

BIGINT
GLOBAL_PARENT_ID

BIGINT
NO_OF_GLOBAL_PARENTS

BIGINT
GROUPNAME
Name for the Group
CHAR
GROUPDESC
Description for the Group
CHAR
TIMESTAMP
Resource Group Created Time
DATETIME
Constraints
Ptrx_ResourceGroupMembers
Top
Column name Description Data type
GROUPID (PK)
Unique Identifier for a Resource Group.
BIGINT
RESOURCEID (PK)
Unique Identifier for a Resource.
BIGINT
USERID (PK)
Unique Identifier of user who adds a resource to the resource group.
BIGINT
Constraints
Ptrx_Owner
Top
Column name Description Data type
USERID (PK)
Unique User Identifier
BIGINT
RESOURCEID (PK)
The Unique Resource identifier
BIGINT
Constraints
Ptrx_SuperAdmin
Top
Column name Description Data type
USERID (PK)
Unique User Identifier
BIGINT
ISSUPERADMIN
true means password sync is supported
BOOLEAN
Constraints
Ptrx_AccessedTime
Top
Column name Description Data type
ACCESSID (PK)
The Unique Identifier for the Ptrx_AccessedTime
BIGINT
ACCOUNTID
The Unique Identifier of Account table
BIGINT
USERID
The Unique Identifier of User Table
BIGINT
TIMESTAMP
Password Accessed Time
DATETIME
Constraints
Ptrx_AccessControlAdmin
Top
Column name Description Data type
RESOURCEID (PK)
The Unique Identifier for the Resource.
BIGINT
USER_ID (PK)
The Unique Identifier for the User.
BIGINT
Constraints
Ptrx_AccessControlUsers
Top
Column name Description Data type
RESOURCEID (PK)
The Unique Identifier for the Resource.
BIGINT
USER_ID (PK)
The Unique Identifier for the User.
BIGINT
Constraints
Ptrx_AccessControl
Top
Column name Description Data type
RESOURCEID (PK)
The Unique Identifier for the Resource.
BIGINT
REQUEST_TIMEOUT
Request time out if it is not approved (in hours).
BIGINT
CHECKOUT_TIMEOUT
Time out for password checkout (in hours).
BIGINT
RESET_ALLOWED
Is reset allowed after password checked in
BOOLEAN
DUAL_APPROVAL
Is dual approval for password request is required
BOOLEAN
HELPDESK_APPROVAL
Is Rest approval for password request is required
BOOLEAN
STATUS
Is Access control enabled or disabled
BOOLEAN
AUTO_APPROVE
Is Auto Approve for Password Access Requests enabled or disabled
BOOLEAN
FROM_HRS
Hours value for From time in Auto Approve
INTEGER
FROM_MINS
Mins value for From time in Auto Approve
INTEGER
TO_HRS
Hours value for To time in Auto Approve
INTEGER
TO_MINS
Mins value for To time in Auto Approve
INTEGER
Constraints
Ptrx_RequestRelease
Top
Column name Description Data type
PASSWDID (PK)
The Unique Identifier for the Password.
BIGINT
USER_ID (PK)
The Unique Identifier for the User.
BIGINT
STATUS
Status of the password request.
BIGINT
TIMESTAMP
Time stamp for request actions
DATETIME
REASON
Reason for the Password Request
CHAR
HELPDESKREQUESTID
HelpDesk Request ID given for password request
CHAR
Constraints
Ptrx_UserGroup
Top
Column name Description Data type
USERGROUPID (PK)
Unique Identifier for a UserGroup.
BIGINT
GROUPNAME
Name for the Group
CHAR
GROUPDESC
Description for the Group
CHAR
TIMESTAMP
UserGroup Group Created Time
DATETIME
Constraints
Ptrx_UserGroupMembers
Top
Column name Description Data type
USERGROUPID (PK)
Unique Identifier for a UserGroup
BIGINT
USERID (PK)
Unique Identifier for a AaaUser.
BIGINT
Constraints
Ptrx_UserResGroup
Top
Column name Description Data type
GROUPID (PK)
Unique Identifier for a UserGroup
BIGINT
USERID (PK)
Unique Identifier for a AaaUser.
BIGINT
Constraints
Ptrx_UsersTwoFactorAuth
Top
Column name Description Data type
USERTWOFACTORID (PK)
The unique identifier for the Account
BIGINT
USER_ID
The notication type value.
BIGINT
TWOFACTORID
The unique identifier for the Account
BIGINT
Constraints
Ptrx_UsersMobileAccessDetails
Top
Column name Description Data type
USER_ID (PK)
Identifier of AaaUser
BIGINT
ENABLED
Status, whether the user can access mobile app
BOOLEAN
Constraints
Ptrx_UsersAddonAccessDetails
Top
Column name Description Data type
USER_ID (PK)
Identifier of AaaUser
BIGINT
ENABLED
Status, whether the user can access the browser extension
BOOLEAN
Constraints
Ptrx_TwoFactorAuth
Top
Column name Description Data type
TWOFACTORID (PK)
The Unique Resource identifier
BIGINT
AUTHENTICATORNAME
Two factor Authentication name
CHAR
AUTHENTICATORCLASSNAME
Two factor Authentication name
CHAR
AUTHENTICATORSTATUS
Two factor authenticator status
BOOLEAN
Constraints
Ptrx_ServiceAccountMapping
Top
Column name Description Data type
SERVICEID
Unique SERVICE Identifier
BIGINT
ACCOUNTID (PK)
The Unique Identifier for the Service Account
BIGINT
RESOURCEID (PK)
A Unique Identifier to identify the Resources where the service runs
BIGINT
SERVICENAME (PK)
Service name running in the resource
CHAR
Constraints
Ptrx_SchTasksDetails
Top
Column name Description Data type
SCHTASKID (PK)
Unique Scheduled Task Identifier
BIGINT
ACCOUNTID
Unique Account Identifier
BIGINT
RESOURCEID
Unique reosurce Identifier
BIGINT
SCHTASKNAME
Name of the scheduled task
CHAR
STATUS
Status of the scheduled task
CHAR
TIMESTAMP
Time at which the scheduled task password changed
DATETIME
Constraints
Ptrx_ResGrpUser
Top
Column name Description Data type
Unique Identifier for a ResourceGroup
BIGINT

USERID (PK)
Unique Identifier for a AaaUser.
BIGINT
SHAREDUSERID (PK)
Unique Identifier for a AaaUser.
BIGINT
ACCESSTYPE (PK)
The access type assigned to that user
CHAR
Constraints
Ptrx_AccountUserGroup
Top
Column name Description Data type
ACCOUNTID (PK)
Unique Identifier for a Resource
BIGINT
USERGROUPID (PK)
Unique Identifier for a UserGroup.
BIGINT
USERID (PK)
Unique Identifier for a AaaUser.
BIGINT
ACCESSTYPE
The access type assigned to that user
CHAR
Constraints
Ptrx_AccountUser
Top
Column name Description Data type
ACCOUNTID (PK)
Unique Identifier for a Account
BIGINT
USERID (PK)
Unique Identifier for a AaaUser.
BIGINT
SHAREDUSERID (PK)
Unique Identifier for a AaaUser.
BIGINT
ACCESSTYPE
The access type assigned to that user
CHAR
Constraints
Ptrx_ResUserGroup
Top
Column name Description Data type
RESOURCEID (PK)
Unique Identifier for a Resource
BIGINT
USERGROUPID (PK)
Unique Identifier for a UserGroup.
BIGINT
USERID (PK)
Unique Identifier for a AaaUser.
BIGINT
ACCESSTYPE (PK)
The access type assigned to that user
CHAR
Constraints
Ptrx_ResGrpUserGroup
Top
Column name Description Data type
GROUPID (PK)
Unique Identifier for a ResourceGroup
BIGINT
USERGROUPID (PK)
Unique Identifier for a UserGroup.
BIGINT
USERID (PK)
Unique Identifier for a AaaUser.
BIGINT
ACCESSTYPE (PK)
The access type assigned to that user
CHAR
Constraints
Ptrx_ResourceUser
Top
Column name Description Data type
RESOURCEID (PK)
Unique Identifier for a ResourceGroup
BIGINT
USERID (PK)
Unique Identifier for a AaaUser.
BIGINT
SHAREDUSERID (PK)
Unique Identifier for a AaaUser.
BIGINT
ACCESSTYPE (PK)
The access type assigned to that user
CHAR
Constraints
Ptrx_ResourceSystem
Top
Column name Description Data type
OSID (PK)
Unique Identifier for a Resource System.
BIGINT
OPERATINGSYSTEM
Name for the OS
CHAR
ICON
Icon for the OS
CHAR
ISSYNCSUPPORTED
true means password sync is supported
BOOLEAN
ISCERTIFICATE
true means certificate storage is supported
BOOLEAN
SYNCTYPE
Type of sync technique (windows \ Linux) used for password sync.
CHAR
ISDEFAULT
Boolean to denote whether the Resource type has beeen set as default.
BOOLEAN
ISSELECTED
boolean value to identify whether to list in add resource ui
BOOLEAN
Constraints
Ptrx_ResourceSystemMembers
Top
Column name Description Data type
OSID (PK)
Unique Identifier for a Resource System.
BIGINT
RESOURCEID (PK)
Unique Identifier for a Resource.
BIGINT
Constraints
Ptrx_AuditConfiguration
Top
Column name Description Data type
CONF_ID (PK)
The unique identifier for the Audit type
BIGINT
OPERATION_TYPE
Type of audit operation
CHAR
Constraints
Ptrx_UserAudit
Top
Column name Description Data type
AUDITID (PK)
Private key to identify the audit trails
BIGINT
RESOURCENAME
Audited Resource Name.
SCHAR
NAME
Audited user's first and last Name.
CHAR
OPERATEDBY
Audited user's first and last Name.
CHAR
LOGINNAME
Audited UserAccount.
SCHAR
USERNAME
Audited Passafe User.
CHAR
LUSER
Audited By which Passafe User.
CHAR
LASTACCESSEDTIME
The Last time stamp when the resource was accessed or attempted any access.
DATETIME
IPADDRESS
IP Address from which action is performed.
CHAR
OPERATIONTYPE
The type of the operation done.
BIGINT
REASON
The Reason operation failure.
CHAR
OSTYPE
Resource operating system.
CHAR
RESOURCEID
Unique Identifier for a Resource
BIGINT
ACCOUNTID
Unique Identifier for a Account
BIGINT
CLIENTTYPE
Client which user used to connect pmp
INTEGER
HELPDESKREQUESTID
HelpDesk Request ID
CHAR
Constraints
Ptrx_TaskAudit
Top
Column name Description Data type
TASKAUDITID (PK)
Private key to identify the audit trails
BIGINT
TASKNAME
Audited Task Name.
CHAR
SCHEDULENAME
Audited Schedule Name.
CHAR
CREATEDBY
FullName of the user crerated schedule
CHAR
SCHEDULE_START_TIME
The time stamp when the schedule started.
DATETIME
SCHEDULE_FINISH_TIME
The time stamp when the schedule completed.
DATETIME
STATUS
Schedule status
CHAR
Constraints
Ptrx_CriteriaGroup
Top
Column name Description Data type
CRITERIAID (PK)
Unique Identifier for a Resource Group By Criteria.
BIGINT
GROUPID
Unique Identifier for a AaaUser.
BIGINT
TABLENAME
Name for the Table and Column
CHAR
CRITERIA
CRITERIA for the Group
CHAR
CRITERIAVALUE
Value for the Group Criteria
CHAR
Constraints
Ptrx_ResourceSync
Top
Column name Description Data type
RESOURCEID (PK)
Unique Identifier of the Resource
BIGINT
ACCOUNTID (PK)
The Unique Identifier for the User Account
BIGINT
SYNCMODE
Different types of password sync mode.
BIGINT
ACCOUNTTYPE (PK)
Different types of accounts used for password sync.
CHAR
PROTOCOL
Different types of protocol used for password sync.
CHAR
PROMPTS
Prompts for the various protocol.
CHAR
DOMAINNAME
Domain Name used for MSSQL Server Authentication.
CHAR
USERNAME
User name for domain authentication Prompts for the various protocol.
CHAR
PASSWORD
Password of windows domain authentication account.
SCHAR
PORT
Port of MSSQL Server.
BIGINT
Constraints
Ptrx_CriteriaGroupLogic
Top
Column name Description Data type
LOGICID
Unique Identifier for a Resource Group By Criteria.
BIGINT
GROUPID
Unique Identifier for a resource group.
BIGINT
LOGICVALUE
Name for the Table and Column.
CHAR
Constraints
Ptrx_AppPoolAccountMapping
Top
Column name Description Data type
ACCOUNTID
The Unique Identifier for the AppPool Account.
BIGINT
RESOURCEID
A Unique Identifier to identify the Resources where the apppool runs.
BIGINT
APPPOOLNAME
AppPool name running in the resource.
CHAR
Constraints
AaaUser
Top
Column name Description Data type
USER_ID
Unique identifier.
BIGINT
FIRST_NAME
First name of user.
CHAR
MIDDLE_NAME
Middle name of user.
CHAR
LAST_NAME
Last name of user.
CHAR
CREATEDTIME
Create time of user.
BIGINT
DESCRIPTION
Description message about user.
CHAR
Constraints
AaaLogin
Top
Column name Description Data type
LOGIN_ID
Unique identifier.
BIGINT
USER_ID
Identifier of AaaUser who owns the loginname.
BIGINT
NAME
Login name to be used to access accounts owned by user.
CHAR
DOMAINNAME
Domain name to be used to access accounts owned by user based on the domain.
CHAR
Constraints
AaaAccount
Top
Column name Description Data type
ACCOUNT_ID
Unique identifier.
BIGINT
LOGIN_ID
Identifier of AaaLogin.
BIGINT
SERVICE_ID
Identifier of AaaService to which the account has access to.
BIGINT
ACCOUNTPROFILE_ID
Identifier of AccountProfile that manages the validity of the account.
BIGINT
CREATEDTIME
Time at which the account was created
BIGINT
Constraints
AaaPasswordRule
Top
Column name Description Data type
PASSWDRULE_ID
Unique identifier.
BIGINT
NAME
Name of the password rule.
CHAR
MIN_LENGTH
Governs the minimum length of the password.
INTEGER
MAX_LENGTH
Governs the maximum length of the password.
INTEGER
REQ_MIXEDCASE
Governs whether the password should contain mixed case.
BOOLEAN
NUMOF_SPLCHAR
Governs the number of special characters to be used. If the value is -1 then, it is not considered for validation.
INTEGER
BEGINWITH_LETTER
Governs whether the password should begin with a alphabet.
BOOLEAN
LOGINNAME_INDEPNDT
Governs if password can be same as loginname.
BOOLEAN
Constraints
AaaContactInfo
Top
Column name Description Data type
CONTACTINFO_ID
Unique identifier.
BIGINT
EMAILID
EMAILID.
CHAR
LANDLINE
Landline number.
CHAR
MOBILE
Mobile number.
CHAR
FAX
Fax number.
CHAR
WEB_URL
WEB URL.
CHAR
RES_PHONE
Residence phone number.
CHAR
Constraints
AaaAuthorizedRole
Top
Column name Description Data type
ACCOUNT_ID (PK)
Identifier of AaaAccount to which the roles are mapped
BIGINT
ROLE_ID
Identifier of role which is mapped to account.
BIGINT
Constraints
Ptrx_Password
Top
Column name Description Data type
PASSWDID (PK)
Unique Identifier for the Password Entity.
BIGINT
DESCRIPTION
The column type of the custom attribute
CHAR
TIMESTAMP
Password Accessed Time
DATETIME
PASSWDLENGTH
Length of the password
BIGINT
ISALPHANUMERIC
Status of the password whether it contain both alphabet and numbers
BOOLEAN
Constraints
Ptrx_PasswordRule
Top

Column name Description Data type
PASSWDRULEID (PK)
The Unique Identifier for the Password Rule.
BIGINT
PASSWDRULENAME
Unique name for the Password Rule
CHAR
MINLENGTH
Minimum length of the Password String
INTEGER
MAXLENGTH
Maximumn length of the Password String
INTEGER
SPLCHAR
Special Characters Required in the Password String
CHAR
REQNOTCHARS
Characters not required in the Password
CHAR
LOWERCASE
Lowercase Characters allowed in the Password String
CHAR
NUMOFLOWERCASE
Number of Lower Case characters to be present in the Password String
INTEGER
NUMOFUPPERCASE
Number of Upper Case characters to be present in the Password String INTEGER
NUMBERS
Numbers allowed in the Password String
CHAR
NUMOFNUMERAL
Number of Numerals to be present in the Password String
INTEGER
HEXADECIMAL
Hexadecimal Numbers allowed in the Password String
CHAR
OLDPASSWDNUM
Number of Old Passwords to be remembered
INTEGER
VALIDITYPERIOD
Number of days the Password is Valid
INTEGER
WARNINGPERIOD
The threshold time to warn the user about the Password Expiry
BIGINT
GRACEPERIOD
Number of Days the user can be allowed to skip the password change, though the password has been expired
BIGINT
Constraints

©2014, ZOHO Corp. All Rights Reserved.