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
Ptrx_Account
Ptrx_ResourceSystem
Ptrx_ResourceSystemMembers
Ptrx_PasswordRule
Ptrx_Password
Ptrx_ResourceSync
Ptrx_ResourceGroup
Ptrx_ResourceGroupMembers
Ptrx_Owner
Ptrx_AccessedTime
Ptrx_AppPoolAccountMapping
Ptrx_CriteriaGroup
Ptrx_CriteriaGroupLogic

AaaUser
AaaAccount
AaaLogin
AaaPasswordRule
AaaAuthorizedRole
AaaContactInfo
Ptrx_UserGroup
Ptrx_UserGroupMembers
Ptrx_UsersTwoFactorAuth
Ptrx_UsersMobileAccessDetails
Ptrx_TwoFactorAuth
Ptrx_SuperAdmin
Ptrx_UserAudit
Ptrx_TaskAudit

Ptrx_UserResGroup
Ptrx_ResGrpUser
Ptrx_AccountUserGroup
Ptrx_AccountUser
Ptrx_ResUserGroup
Ptrx_ResGrpUserGroup
Ptrx_ResourceUser
Ptrx_AccessControlAdmin
Ptrx_AccessControlUsers
Ptrx_AccessControl
Ptrx_RequestRelease
Ptrx_ServiceAccountMapping
Ptrx_SchTasksDetails
Ptrx_AuditConfiguration

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

Primary key Ptrx_Resource(RESOURCEID)
Foreign key Ptrx_PasswordRule_FK(PASSWDRULEID) references AaaPasswordRule(PASSWDRULE_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_Account(ACCOUNTID)
Foreign key Ptrx_Account_FK(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign keyPtrx_Account_FK2(PASSWDRULEID) references AaaPasswordRule(PASSWDRULE_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_ResourceGroup(GROUPID)
Foreign key Ptrx_ResourceGroup_FK1(PASSWDRULEID) references AaaPasswordRule (PASSWDRULE_ID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceGroup_FK2(USERID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_ResourceGroupMembers(GROUPID,RESOURCEID,USERID)
Foreign key Ptrx_ResourceGroupMembers_FK1(GROUPID) references Ptrx_ResourceGroup (GROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceGroupMembers_FK2(RESOURCEID) references Ptrx_Resource (RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceGroupMembers_FK3(USERID) references AaaUser (USER_ID) ON-DELETE-CASCADE

Ptrx_Owner

Top

Column name	Description	Data type
USERID (PK)	Unique User Identifier	BIGINT
RESOURCEID (PK)	The Unique Resource identifier	BIGINT

Constraints

Primary key Ptrx_Owner(USERID,RESOURCEID)
Foreign key Ptrx_Owner_FK1(USERID) references AaaUser (USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_Owner_FK2(RESOURCEID) references Ptrx_Resource (RESOURCEID) ON-DELETE-CASCADE

Ptrx_SuperAdmin

Top

Column name	Description	Data type
USERID (PK)	Unique User Identifier	BIGINT
ISSUPERADMIN	true means password sync is supported	BOOLEAN

Constraints

Primary key Ptrx_SuperAdmin(USERID)
Foreign key Ptrx_SuperAdmin_FK(USERID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_AccessedTime(ACCESSID)
Foreign key Ptrx_AccessedTime_FK1(USERID) references AaaUser (USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccessedTime_FK2(ACCOUNTID) references Ptrx_Account (ACCOUNTID) ON-DELETE-CASCADE

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

Primary key Ptrx_AccessControlAdmin(RESOURCEID,USER_ID)
Foreign key Ptrx_AccessControlAdmin_FK1(RESOURCEID) references Ptrx_Resource (RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_AccessControlAdmin_FK2(USER_ID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_AccessControlUsers(RESOURCEID,USER_ID)
Foreign key Ptrx_AccessControlUsers_FK1(RESOURCEID) references Ptrx_Resource (RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_AccessControlUsers_FK2(USER_ID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_AccessControl(RESOURCEID)
Foreign key Ptrx_AccessControl_FK1(RESOURCEID) references Ptrx_Resource (RESOURCEID) ON-DELETE-CASCADE

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

Primary key Ptrx_RequestRelease(PASSWDID,USER_ID)
Foreign key Ptrx_RequestRelease_FK1(PASSWDID) references Ptrx_Password (PASSWDID) ON-DELETE-CASCADE
Foreign key Ptrx_RequestRelease_FK2(USER_ID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_UserGroup(USERGROUPID)

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

Primary key Ptrx_UserGroupMembers(USERGROUPID,USERID)
Foreign key Ptrx_UserGroupMembers_FK1(USERGROUPID) references Ptrx_UserGroup (USERGROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_UserGroupMembers_FK2(USERID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_UserResGroup(GROUPID,USERID)
Foreign key Ptrx_UserResGroup_FK1(GROUPID) references Ptrx_ResourceGroup (GROUPID)ON-DELETE-CASCADE
Foreign key Ptrx_UserResGroup_FK2(USERID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_UsersTwoFactorAuth(USERTWOFACTORID)
Foreign key Ptrx_UsersTwoFactorAuth_FK1(USER_ID) references AaaUser (USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_UsersTwoFactorAuth_FK2(TWOFACTORID) references Ptrx_TwoFactorAuth(TWOFACTORID) ON-DELETE-CASCADE

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

Primary key Ptrx_UsersMobileAccessDetails(USER_ID)
Foreign key UsersMobileAccessDetails_FK1(USER_ID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_TwoFactorAuth(TWOFACTORID)

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

Primary key Ptrx_ServiceAccountMapping(ACCOUNTID,RESOURCEID,SERVICENAME)
Foreign key Ptrx_ServiceAccountMapping_FK1(RESOURCEID) references Ptrx_Resource (RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_ServiceAccountMapping_FK2(ACCOUNTID) references Ptrx_Account (ACCOUNTID) ON-DELETE-CASCADE

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

Primary key Ptrx_SchTasksDetails(SCHTASKID)
Foreign key Ptrx_SchTasksDetails_FK1(RESOURCEID) references Ptrx_Resource (RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_SchTasksDetails_FK2(ACCOUNTID) references Ptrx_Account (ACCOUNTID) ON-DELETE-CASCADE

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

Primary key Ptrx_ResGrpUser(GROUPID,USERID,SHAREDUSERID,ACCESSTYPE)
Foreign key Ptrx_ResGrpUser_FK1(GROUPID) references Ptrx_ResourceGroup (GROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_ResGrpUser_FK2(USERID) references AaaUser (USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_ResGrpUser_FK3(SHAREDUSERID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_AccountUserGroup(ACCOUNTID,USERGROUPID,USERID)
Foreign key Ptrx_AccountUserGroup_FK1(ACCOUNTID) references Ptrx_Account\(ACCOUNTID) ON-DELETE-CASCADE
Foreign key Ptrx_AccountUserGroup_FK2(USERGROUPID) references Ptrx_UserGroup (USERGROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_AccountUserGroup_FK3(USERID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_AccountUser(ACCOUNTID,USERID,SHAREDUSERID)
Foreign key Ptrx_AccountUser_FK1(ACCOUNTID) references Ptrx_Account (ACCOUNTID) ON-DELETE-CASCADE
Foreign key Ptrx_AccountUser_FK2(USERID) references AaaUser (USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccountUser_FK3(SHAREDUSERID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_ResUserGroup(RESOURCEID,USERGROUPID,USERID,ACCESSTYPE)
Foreign key Ptrx_ResUserGroup_FK1(RESOURCEID) references Ptrx_Resource (RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_ResUserGroup_FK2(USERGROUPID) references Ptrx_UserGroup(USERGROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_ResUserGroup_FK3(USERID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_ResGrpUserGroup(GROUPID,USERGROUPID,USERID,ACCESSTYPE)
Foreign key Ptrx_ResGrpUserGroup_FK1(GROUPID) references Ptrx_ResourceGroup (GROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_ResGrpUserGroup_FK2(USERGROUPID) references Ptrx_UserGroup (USERGROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_ResGrpUserGroup_FK3(USERID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_ResourceUser(RESOURCEID,USERID,SHAREDUSERID,ACCESSTYPE)
Foreign key Ptrx_ResourceUser_FK1(RESOURCEID) references Ptrx_Resource (RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceUser_FK2(USERID) references AaaUser (USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceUser_FK3(SHAREDUSERID) references AaaUser (USER_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_ResourceSystem(OSID)

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

Primary key Ptrx_ResourceSystemMembers(OSID,RESOURCEID)
Foreign key Ptrx_ResourceSystemMembers_FK1(OSID) references Ptrx_ResourceSystem (OSID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceSystemMembers_FK2(RESOURCEID) references Ptrx_Resource (RESOURCEID) ON-DELETE-CASCADE

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

Primary key Ptrx_AuditConfiguration(CONF_ID)

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 pam360	INTEGER
HELPDESKREQUESTID	HelpDesk Request ID	CHAR

Constraints

Primary key Ptrx_UserAudit(AUDITID)
Foreign key Ptrx_UserAudit_FK(OPERATIONTYPE) references Ptrx_AuditConfiguration (CONF_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_TaskAudit(TASKAUDITID)

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

Primary key Ptrx_CriteriaGroup(CRITERIAID)
Foreign key Ptrx_CriteriaGroup_FK(GROUPID) references Ptrx_ResourceGroup (GROUPID) ON-DELETE-CASCADE

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

Primary key Ptrx_ResourceSync(RESOURCEID,ACCOUNTID,ACCOUNTTYPE)
Foreign key Ptrx_ResourceSync_FK(RESOURCEID) references Ptrx_Resource (RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceSync_FK1(ACCOUNTID) references Ptrx_Account (ACCOUNTID) ON-DELETE-CASCADE

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

Primary key Ptrx_CriteriaGroupLogic(LOGICID)
Foreign key Ptrx_CriteriaGroupLogic_FK1(GROUPID) references Ptrx_ResourceGroup (GROUPID) ON-DELETE-CASCADE

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

Primary key Ptrx_AppPoolAccountMapping(ACCOUNTID)
Foreign key Ptrx_AppPoolAccountMapping_FK1(RESOURCEID) references Ptrx_Resource (RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_AppPoolAccountMapping_FK1(ACCOUNTID) references Ptrx_Account (ACCOUNTID) ON-DELETE-CASCADE

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

Primary key AaaUser(USER_ID)

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

Primary key AaaLogin(LOGIN_ID)
Foreign key AAALOGIN_FK(PASSWDRULEID) references AaaUser(USER_ID) ON-DELETE-CASCADE

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

Primary key AaaAccount(ACCOUNT_ID)
Foreign key AaaAccount_FK(LOGIN_ID) references AaaLogin(LOGIN_ID) ON-DELETE-CASCADE

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

Primary key AaaPasswordRule(PASSWDRULE_ID)

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

Primary key AaaContactInfo(CONTACTINFO_ID)

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

Primary key AaaAuthorizedRole(ACCOUNT_ID)
Foreign key AaaAuthorizedRole_FK1(ACCOUNT_ID) references AaaAccount (ACCOUNT_ID) ON-DELETE-CASCADE
Foreign key AaaAuthorizedRole_FK2(ROLE_ID) references AaaRole(ROLE_ID) ON-DELETE-CASCADE

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

Primary key Ptrx_Password(PASSWDID)

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

Primary key Ptrx_PasswordRule(PASSWDRULEID)