Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

List of all attributes/database field names for the users table

Thriller
New Contributor II
New Contributor II

How can we get a list of all of the attributes/database field names for the users table?  Inclusive of the ones not seen in the interface.

4 REPLIES 4

PremMahadikar
Valued Contributor
Valued Contributor

Hi @Thriller ,

Please check this article: Database Schema Reference (saviyntcloud.com)

Here in the documentation, you can see all the user's attribute/column names.

PremMahadikar_0-1715703171431.png

 

If this helps your question, please consider selecting Accept As Solution and hit Kudos

Raghu
Valued Contributor III
Valued Contributor III

@Thriller  Please find below

 

  • users database object table:

    ACCOUNTEXPIRED, ACCOUNTLOCKED,CITY, COMMENTS, COMPANYNAME, COSTCENTER, COUNTRY, CREATEDATE, CREATEDBY, CUSTOMER, CUSTOMPROPERTY1, CUSTOMPROPERTY10, CUSTOMPROPERTY11, CUSTOMPROPERTY12, CUSTOMPROPERTY13, CUSTOMPROPERTY14, CUSTOMPROPERTY15, CUSTOMPROPERTY16, CUSTOMPROPERTY17, CUSTOMPROPERTY18, CUSTOMPROPERTY19, CUSTOMPROPERTY2, CUSTOMPROPERTY20, CUSTOMPROPERTY21, CUSTOMPROPERTY22, CUSTOMPROPERTY23, CUSTOMPROPERTY24, CUSTOMPROPERTY25, CUSTOMPROPERTY26, CUSTOMPROPERTY27, CUSTOMPROPERTY28, CUSTOMPROPERTY29, CUSTOMPROPERTY3, CUSTOMPROPERTY30, CUSTOMPROPERTY31, CUSTOMPROPERTY32, CUSTOMPROPERTY33, CUSTOMPROPERTY34, CUSTOMPROPERTY35, CUSTOMPROPERTY36, CUSTOMPROPERTY37, CUSTOMPROPERTY38, CUSTOMPROPERTY39, CUSTOMPROPERTY4, CUSTOMPROPERTY40, CUSTOMPROPERTY41, CUSTOMPROPERTY42, CUSTOMPROPERTY43, CUSTOMPROPERTY44, CUSTOMPROPERTY45, CUSTOMPROPERTY46, CUSTOMPROPERTY47, CUSTOMPROPERTY48, CUSTOMPROPERTY49, CUSTOMPROPERTY5, CUSTOMPROPERTY50, CUSTOMPROPERTY51, CUSTOMPROPERTY52, CUSTOMPROPERTY53, CUSTOMPROPERTY54, CUSTOMPROPERTY55, CUSTOMPROPERTY56, CUSTOMPROPERTY57, CUSTOMPROPERTY58, CUSTOMPROPERTY59, CUSTOMPROPERTY6, CUSTOMPROPERTY60, CUSTOMPROPERTY61, CUSTOMPROPERTY62, CUSTOMPROPERTY63, CUSTOMPROPERTY64, CUSTOMPROPERTY65, CUSTOMPROPERTY7, CUSTOMPROPERTY8, CUSTOMPROPERTY9, DEPARTMENTNAME, DEPARTMENTNUMBER, DISPLAYNAME, DONOTDISTURBDELEGATE, EMAIL, EMPLOYEECLASS, EMPLOYEEID, EMPLOYEETYPE, ENABLED, ENDDATE, ENTITY, FAILEDTRIES, FIRSTNAME, HANARULEKEY, JOBCODE, JOBCODEDESC, JOBDESCRIPTION, JOB_FUNCTION,JOB_ID, LASTCERTIFIEDCAMPAIGNNAME, LASTCERTIFIEDDATE, LASTCERTIFIEDUSER,LASTNAME, LASTPASSWORDUPDATEDATE, LASTSYNCDATE, LEAVESTATUS, LOCALE,LOCATION, LOCATIONDESC, LOCATIONNUMBER, MANAGER, MIDDLENAME, ORGUNITID, OWNER, OWNERONTERMINATE, PASSWORDEXPIRED, PHONENUMBER, PREFEREDFIRSTNAME, REGION, REGIONCODE, RISKSCORE, RULEACTION, SAVUPDATEDATE, SECONDARYEMAIL, SECONDARYMANAGER, SECONDARYPHONE, SITEID, STARTDATE, STATE,STATUSKEY, STREET, SYSTEMUSERNAME, TASKCREATEDFORTERMINATE, TERMDATE, TITLE, UPDATEDATE, UPDATEUSER, USERKEY, USERNAME, USERSOURCE, USERSOURCEKEY, and VENDORMANAGER.

https://forums.saviynt.com/t5/saviynt-knowledge-base/list-of-table-attributes-accessible-via-data-an...

https://docs.saviyntcloud.com/bundle/SSM-DB-Schema-Reference-v55x/page/Content/Identity-Repository-S...

 

 


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

Saathvik
All-Star
All-Star

@Thriller : Most of the columns are covered in schema document shared by Prem except very few columns. But below is the list of columns we exported in older version.

 

USERKEY
ACCOUNTEXPIRED
ACCOUNTLOCKED
CITY
COMMENTS
COMPANYNAME
COSTCENTER
COUNTRY
CREATEDBY
CREATEDATE
CUSTOMER
CUSTOMPROPERTY1
CUSTOMPROPERTY10
CUSTOMPROPERTY11
CUSTOMPROPERTY12
CUSTOMPROPERTY13
CUSTOMPROPERTY14
CUSTOMPROPERTY15
CUSTOMPROPERTY16
CUSTOMPROPERTY17
CUSTOMPROPERTY18
CUSTOMPROPERTY19
CUSTOMPROPERTY2
CUSTOMPROPERTY20
CUSTOMPROPERTY21
CUSTOMPROPERTY22
CUSTOMPROPERTY23
CUSTOMPROPERTY24
CUSTOMPROPERTY25
CUSTOMPROPERTY26
CUSTOMPROPERTY27
CUSTOMPROPERTY28
CUSTOMPROPERTY29
CUSTOMPROPERTY3
CUSTOMPROPERTY30
CUSTOMPROPERTY31
CUSTOMPROPERTY32
CUSTOMPROPERTY33
CUSTOMPROPERTY34
CUSTOMPROPERTY35
CUSTOMPROPERTY36
CUSTOMPROPERTY37
CUSTOMPROPERTY38
CUSTOMPROPERTY39
CUSTOMPROPERTY4
CUSTOMPROPERTY40
CUSTOMPROPERTY41
CUSTOMPROPERTY42
CUSTOMPROPERTY43
CUSTOMPROPERTY44
CUSTOMPROPERTY45
CUSTOMPROPERTY46
CUSTOMPROPERTY47
CUSTOMPROPERTY48
CUSTOMPROPERTY49
CUSTOMPROPERTY5
CUSTOMPROPERTY50
CUSTOMPROPERTY51
CUSTOMPROPERTY52
CUSTOMPROPERTY53
CUSTOMPROPERTY54
CUSTOMPROPERTY55
CUSTOMPROPERTY56
CUSTOMPROPERTY57
CUSTOMPROPERTY58
CUSTOMPROPERTY59
CUSTOMPROPERTY6
CUSTOMPROPERTY60
CUSTOMPROPERTY61
CUSTOMPROPERTY62
CUSTOMPROPERTY63
CUSTOMPROPERTY64
CUSTOMPROPERTY65
CUSTOMPROPERTY7
CUSTOMPROPERTY8
CUSTOMPROPERTY9
DEPARTMENTNUMBER
DEPARTMENTNAME
DISPLAYNAME
DONOTDISTURBDELEGATE
EMAIL
EMPLOYEETYPE
EMPLOYEECLASS
EMPLOYEEID
ENABLED
ECP1
ECP2
ECP3
ECP4
ECP5
SECURITYANSWERS
ENDDATE
ENTITY
FAILEDTRIES
FIRSTNAME
HANARULEKEY
HCP1
HCP2
HCP3
HCP4
HCP5
JOBCODE
JOBDESCRIPTION
JOB_ID
JOB_FUNCTION
JOBCODEDESC
LASTCERTIFIEDCAMPAIGNNAME
LASTCERTIFIEDDATE
LASTCERTIFIEDUSER
LASTPASSWORDUPDATEDATE
LASTNAME
LASTSYNCDATE
LEAVESTATUS
LOCALE
LOCATION
LOCATIONDESC
LOCATIONNUMBER
MANAGER
MIDDLENAME
ORGUNITID
OWNER
OWNERONTERMINATE
PASSWORD
PASSWORDEXPIRED
PHONENUMBER
PREFEREDFIRSTNAME
REGION
REGIONCODE
RISKSCORE
RULEACTION
SAVUPDATEDATE
SECONDARYEMAIL
SECONDARYMANAGER
SECONDARYPHONE
SITEID
STARTDATE
STATE
STATUSKEY
STREET
SYSTEMUSERNAME
TASKCREATEDFORTERMINATE
TERMDATE
TITLE
UPDATEDATE
UPDATEUSER
USERSOURCE
USERSOURCEKEY
USERNAME
VENDORMANAGER
LOCALAUTHENABLED

Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

rushikeshvartak
All-Star
All-Star

from v24.5

TABLE_NAMECOLUMN_NAMECOLUMN_TYPECOLUMN_KEY
usersUSERchar(32) 
usersUSERKEYbigint(20)PRI
usersCURRENT_CONNECTIONSbigint(20) 
usersACCOUNTEXPIREDbit(1) 
usersTOTAL_CONNECTIONSbigint(20) 
usersACCOUNTLOCKEDbit(1) 
usersCITYvarchar(255) 
usersCOMMENTSvarchar(255) 
usersCOMPANYNAMEvarchar(255) 
usersCOSTCENTERvarchar(255) 
usersCOUNTRYvarchar(255) 
usersCREATEDBYvarchar(255) 
usersCREATEDATEdatetime 
usersCUSTOMERbigint(20)MUL
usersCUSTOMPROPERTY1varchar(255) 
usersCUSTOMPROPERTY10varchar(255) 
usersCUSTOMPROPERTY11varchar(255) 
usersCUSTOMPROPERTY12varchar(255) 
usersCUSTOMPROPERTY13varchar(255) 
usersCUSTOMPROPERTY14varchar(255) 
usersCUSTOMPROPERTY15varchar(255) 
usersCUSTOMPROPERTY16varchar(255) 
usersCUSTOMPROPERTY17varchar(255) 
usersCUSTOMPROPERTY18varchar(255) 
usersCUSTOMPROPERTY19varchar(255) 
usersCUSTOMPROPERTY2varchar(255) 
usersCUSTOMPROPERTY20varchar(255) 
usersCUSTOMPROPERTY21varchar(255) 
usersCUSTOMPROPERTY22varchar(255) 
usersCUSTOMPROPERTY23varchar(255) 
usersCUSTOMPROPERTY24varchar(255) 
usersCUSTOMPROPERTY25varchar(255) 
usersCUSTOMPROPERTY26varchar(255) 
usersCUSTOMPROPERTY27varchar(255) 
usersCUSTOMPROPERTY28varchar(255) 
usersCUSTOMPROPERTY29varchar(255) 
usersCUSTOMPROPERTY3varchar(255) 
usersCUSTOMPROPERTY30varchar(255) 
usersCUSTOMPROPERTY31varchar(255) 
usersCUSTOMPROPERTY32varchar(255) 
usersCUSTOMPROPERTY33varchar(255) 
usersCUSTOMPROPERTY34varchar(255) 
usersCUSTOMPROPERTY35varchar(255) 
usersCUSTOMPROPERTY36varchar(255) 
usersCUSTOMPROPERTY37varchar(255) 
usersCUSTOMPROPERTY38varchar(255) 
usersCUSTOMPROPERTY39varchar(255) 
usersCUSTOMPROPERTY4varchar(255) 
usersCUSTOMPROPERTY40varchar(255) 
usersCUSTOMPROPERTY5varchar(255) 
usersCUSTOMPROPERTY6varchar(255) 
usersCUSTOMPROPERTY7varchar(255) 
usersCUSTOMPROPERTY8varchar(255) 
usersCUSTOMPROPERTY9varchar(255) 
usersDEPARTMENTNUMBERvarchar(255) 
usersDEPARTMENTNAMEvarchar(255) 
usersDISPLAYNAMEvarchar(255) 
usersDONOTDISTURBDELEGATEvarchar(255) 
usersDUPLICATEDETECTIONSTATUSbigint(20) 
usersEMAILvarchar(255)MUL
usersEMPLOYEETYPEvarchar(255) 
usersEMPLOYEECLASSvarchar(255) 
usersEMPLOYEEIDvarchar(255) 
usersENABLEDbit(1) 
usersECP1longtext 
usersECP2longtext 
usersECP3longtext 
usersECP4longtext 
usersECP5longtext 
usersSECURITYANSWERStext 
usersENDDATEdatetime 
usersENTITYvarchar(255) 
usersFAILEDTRIESbigint(20) 
usersFIRSTNAMEvarchar(255)MUL
usersHANARULEKEYlongtext 
usersJOBCODEvarchar(255) 
usersJOBDESCRIPTIONvarchar(255) 
usersJOB_IDbigint(20) 
usersJOB_FUNCTIONvarchar(255) 
usersJOBCODEDESCvarchar(255) 
usersLASTNAMEvarchar(255)MUL
usersLASTSYNCDATEdatetime 
usersLEAVESTATUSvarchar(255) 
usersLOCATIONvarchar(255) 
usersLOCATIONDESCvarchar(255) 
usersLOCATIONNUMBERvarchar(255) 
usersMANAGERbigint(20) 
usersMIDDLENAMEvarchar(255) 
usersORGUNITIDvarchar(255) 
usersOWNERvarchar(255) 
usersOWNERONTERMINATEbigint(20) 
usersPASSWORDvarchar(255) 
usersPASSWORDEXPIREDbit(1) 
usersPHONENUMBERvarchar(255) 
usersPREFEREDFIRSTNAMEvarchar(255) 
usersREGIONvarchar(255) 
usersREGIONCODEvarchar(255) 
usersRISKSCOREbigint(20) 
usersRULEACTIONvarchar(255) 
usersSAVUPDATEDATEdatetime 
usersSECONDARYEMAILvarchar(255) 
usersSECONDARYMANAGERbigint(20)MUL
usersSECONDARYPHONEvarchar(255) 
usersSITEIDvarchar(255) 
usersSTARTDATEdatetime 
usersSTATEvarchar(255) 
usersSTATUSKEYbigint(20)MUL
usersSTREETvarchar(255) 
usersSYSTEMUSERNAMEvarchar(255)MUL
usersTASKCREATEDFORTERMINATEbigint(20) 
usersTERMDATEdatetime 
usersTITLEvarchar(255) 
usersUPDATEDATEdatetime 
usersUPDATEUSERbigint(20)MUL
usersUSERSOURCEvarchar(255) 
usersUSERSOURCEKEYbigint(20) 
usersUSERNAMEvarchar(255)UNI
usersVENDORMANAGERbigint(20)MUL
usersCUSTOMPROPERTY41tinytext 
usersCUSTOMPROPERTY42tinytext 
usersCUSTOMPROPERTY43tinytext 
usersCUSTOMPROPERTY44tinytext 
usersCUSTOMPROPERTY45tinytext 
usersCUSTOMPROPERTY46tinytext 
usersCUSTOMPROPERTY47tinytext 
usersCUSTOMPROPERTY48tinytext 
usersCUSTOMPROPERTY49tinytext 
usersCUSTOMPROPERTY50tinytext 
usersHCP1tinytext 
usersHCP2tinytext 
usersHCP3tinytext 
usersHCP4tinytext 
usersHCP5tinytext 
usersCUSTOMPROPERTY51tinytext 
usersCUSTOMPROPERTY52tinytext 
usersCUSTOMPROPERTY53tinytext 
usersCUSTOMPROPERTY54tinytext 
usersCUSTOMPROPERTY55tinytext 
usersCUSTOMPROPERTY56tinytext 
usersCUSTOMPROPERTY57tinytext 
usersCUSTOMPROPERTY58tinytext 
usersCUSTOMPROPERTY59tinytext 
usersCUSTOMPROPERTY60tinytext 
usersCUSTOMPROPERTY61tinytext 
usersCUSTOMPROPERTY62tinytext 
usersCUSTOMPROPERTY63tinytext 
usersCUSTOMPROPERTY64tinytext 
usersCUSTOMPROPERTY65tinytext 
usersLASTCERTIFIEDCAMPAIGNNAMElongtext 
usersLASTCERTIFIEDDATEdatetime 
usersLASTCERTIFIEDUSERbigint(20) 
usersLOCALEtinytext 
usersLOCALAUTHENABLEDbit(1) 
usersLASTPASSWORDUPDATEDATEdatetime 
usersPIIERASURESTATUSbigint(20) 
usersSOURCELASTLOGINDATEdatetime 

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.