pim database dictionary - panduit · pim™ abbreviated data dictionary . ... the guide defines and...

www.panduit.com [email protected] 866-721-5302 page 1

T E C H N I C A L R E F E R E N C E PIM™ Abbreviated Data Dictionary

Definitions for Database Fields use in PIM™ Reports

Contents

Introduction ............................................................................................................................................................ 1 Conventions ........................................................................................................................................................... 1

PA_ADAPTER ........................................................................................................................................................... 2 PA_ASSETATTRIBUTEGROUP ............................................................................................................................... 3 PA_ASSETATTRIBUTELIST .................................................................................................................................... 3 PA_ASSETLIST ......................................................................................................................................................... 4 PA_CABLETYPE ....................................................................................................................................................... 5 PA_CONTAINER ....................................................................................................................................................... 6 PA_DEVICEPORT ..................................................................................................................................................... 6 PA_DEVICE ............................................................................................................................................................... 8 PA_DEVICETYPE ..................................................................................................................................................... 9 PA_EQUIPMENTTYPE ........................................................................................................................................... 11 PA_EQUIPMENTTYPECATEGORY ....................................................................................................................... 11 PA_GROUPINFO .................................................................................................................................................... 12 PA_LOCATION ........................................................................................................................................................ 12 PA_LOCATIONLEVEL ............................................................................................................................................ 13 PA_LOGIN ............................................................................................................................................................... 13 PA_LOGINSESSION ............................................................................................................................................... 14 PA_MNSDEVICEPORT .......................................................................................................................................... 14 PA_PAM_SENSOR ................................................................................................................................................. 16 PA_PERMISSIONS ................................................................................................................................................. 17 PA_SENSOR ........................................................................................................................................................... 17 PA_SENSOR_READING ........................................................................................................................................ 17 PA_SUBTASKTYPE ................................................................................................................................................ 18 PA_USERDIRECTORY ........................................................................................................................................... 18 PA_VENDOR ........................................................................................................................................................... 19 PA_WORKORDERLIST .......................................................................................................................................... 19 Introduction This Technical Reference is a guide for creating PIM custom reports with external reporting tools, i.e. Crystal Reports, MS Excel. The guide defines and describes a subset of PIM 4.1.0 database relevant for building reports. The tables are defined and described to help the users select relevant data for their reports. Conventions Attribute names in bold typeface indicates primary key.

TR71 Published: 02/23/10 Updated: 03/02/11


T E C H N I C A L R E F E R E N C E Table 1 - PA_ADAPTER

PA_ADAPTER

This table contains the predefined and user defined adapters found in the System Administration module under Device Management > Device Catalog (Types) > Adapters.

No Attribute Definition

1. PA_ADAPTERID Auto generated unique sequence number used to identify each adapter entry

2. PA_DISPLAYNAME The text displayed in the PIM software used to identify the adaptar. This text is either populated by the discovery process or manually entered by the system user.

3. PA_DESCRIPTION This field contains the text entered/displayed in the text box labeled “Description” in the Adapters tab. This text is also displayed in the left hand tree structure contained in the tab Device Management>Device Catalog under the branch/folder labeled “Adapters”.

4. PA_VENDORID This field indentifies the vendor/manufacture of each adapter entry. The PA_VENDORID value originates from the identifying field of the PA_VENDOR table which contains specific details for each vendor.

5. PA_VENDORPARTNUMBER This field contains the text entered/displayed in the text box labeled “Part Number” in the Adapters tab

6. PA_NUMBEROFPORTS This field contains the number of ports entered/displayed in the form field labeled “Number of Ports” in the Adapters tab

7. PA_COMMENTS

This field contains the user provided text contained in the text box labeled “Notes” in the Adapters tab

8. PA_ICONFILEPATH

This field contains the file path to the image/icon used to visually represent the adapter in the various tree structures and forms within the PIM user interface. The default value for this path is …/TreeNodes/device_20x20.gif. The path is relative to the installation location of the PIM client software. The images can be found in <Installation folder>\conf\resources\images\.

9. PA_SLOTNO The field contains the slot number of the adapter obtained through discovery process or manually entered by the system user.

10. PA_PRODUCTFAMILY

This field contains the user provided text contained in the text box labeled “Product Family” in the Adapters tab

11. PA_EQUIPMENTTYPEID

This field contains the unique Id number from the PA_EQUIPMENTTYPE table. This field corresponds with the drop down box labeled “Equipment Type” in the Adapters tab. The dropdown box on this page does not display the numerical value, but rather, the textual description of the available equipment types

12. PA_CLASSTYPE

This field contains the user provided text contained in the drop down box labeled “Class” in the Adapters tab. The drop down box contains the textual description [Copper, Fiber] while the field itself contains the numerical code for each class type [Copper = 1, Fiber = 2].


T E C H N I C A L R E F E R E N C E

13. PA_PERFORMANCE

This field contains the user provided text contained in the text box labeled “Performance” in the Adapters tab

14. PA_ENVIRONMENTAL

This field contains the user provided text contained in the text box labeled “Environmental” in the Adapters tab

15. PA_SERVICE This field contains the service type.

16. PA_CONNECTOR This field contains the connector type. Table 2 – PA_ASSETATTRIBUTEGROUP

PA_ASSETATTRIBUTEGROUP

This table contains the predefined and user defined asset attributes.


1. PA_GROUPID Generated

2. PA_DEFAULTNAME Will be used to store the default value of the group. It will hold the locale key defined in the pa_locale table. This column would be upgradeable.

3. PA_DISPLAYNAME Will be used to display the actual name of the Group on the GUI. For AT 1.1 this column would be upgradeable as there is no way by which the user can rename the group names.

4. PA_ASSETCATEGORY Will be used to store the reference of the asset category. This column will be upgradeable.

5. PA_ASSETSCOPE Will be used to store the reference of the scope (Global / Asset) Table 3 – PA_ASSETATTRIBUTELIST

PA_ASSETATTRIBUTELIST

This table contains the predefined and user defined attributes of an asset within PIM.


1. PA_ASSETATTRIBUTEID Auto-numbered unique id.

2. PA_ASSETATTRIBUTENAME Name of attribute, should store the db / hibernate field name (TBD) to be able to match to legacy table field (method). Never change.

3. PA_ASSETDISPLAYNAME Exact value of the PA_VARIABLENAME from PA_LOCALE table (for internationalization) for GUI to display.

4. PA_ASSETATTRIBUTESCOPE Global or Asset Specific.



5. PA_ASSETATTRIBUTECATEGORY 1 - Device, 2 - Container, 3 – could be something new

6. PA_ASSETATTRIBUTESTATUS Enabled / Disabled/AlwaysEnabled

7. PA_ASSETATTRIBUTELEGACY New (0)/Legacy (1). Legacy means that attribute value actually in the legacy table.

8. PA_ASSETVALUETYPE How to convert String to Value and vice versa

9. PA_ASSETVALUELENGTH Length of the attribute for the string values

10 PA_STANDARDUOMTAG Standard Measure Of Unit TAG

11 PA_METRICUOMTAG Metric Measure Of Unit TAG

12. PA_ASSETATTRIBUTETYPE Will be used for storing the field type, i.e. whether it is a TEXTBOX or DROPDOWNBOX. The value will match the ID from the ACMConstants. AssetInputType ENUM. This column won’t be upgradeable. The value of a previous release would remain intact when upgraded to a new release.

13 PA_ASSETATTRIBUTEGROUPID Will be used for storing the reference of the Group from pa_assetattributegroup table. This column won’t be upgradeable. The value of a previous release would remain intact when upgraded to a new release

Table 4 – PA_ASSETLIST

PA_ASSETLIST

This table contains the predefined and user defined attributes of an asset within PIM.


1. PA_ASSETID PA_ASSETID identifies PA_ASSETLIST (auto-numbered)

2. PA_PARENTID PA_PARENTID for asset. It can be the container id, container type id, device id or device type id

3. PA_ASSETATTRIBUTEID FK references PA_ASSETATTRIBUTELIST.PA_ASSETATTRIBUTEID

4. PA_ASSETVALUE Attribute value stored as String. Measure System METRIC always used to store attributes values (where apply)

5. PA_MEASURESYSTEM STANDARD (0) / METRIC (1). Contains the last choice made by the user (Metric / Standard) or default value.


T E C H N I C A L R E F E R E N C E Table 5 – PA_CABLETYPE

PA_CABLETYPE

This table contains the predefined and user defined cables found in the System Administration module under Device Management>Device Catalog (Types)>Cabling.


1. PA_CABLETYPE Auto generated sequence number used to indentify each cable type entry.

2. PA_DESCRIPTION

This field contains the text entered/displayed in the textbox labeled “Description” in the data entry cabling form. This text is also displayed in the left hand tree structure contained in the tab Device Management>Device Catalog under the branch/folder named “Cabling”.

3. PA_PRODUCTFAMILY This field contains the text entered/displayed in the textbox labeled “Product Family” in the Cabling tab.

4. PA_EQUIPMENTTYPEID

This field contains the unique Id number from the PA_EQUIPMENTTYPE table. This field corresponds with the dropdown box labeled “Equipment Type” in the Cabling tab. The dropdown box on this page does not display the numerical value, but rather, the textual description of the available equipment types.

5. PA_ICONFILEPATH

This field contains the file path to the image/icon used to visually represent the cable in the various tree structures and forms within the PIM user interface. The default value for this path is …/TreeNodes/cable_20x20.gif.

6. PA_CLASS

This field contains the user provided text contained in the drop down box labeled “Class” in the Cable tab. The drop down box contains the textual description [Copper, Fiber] while the field itself contains the numerical code for each class type [Copper = 1, Fiber = 2].

7. PA_SUBCLASS This field contains the subclass information.

8. PA_CABLECOLOR This field contains the color of the cable.

9. PA_ENDPOINTA This field contains the end point device A type.

10. PA_ENDPOINTACOLOR This field contains the color of the end point A device.

11. PA_ENDPOINTB This field contains the end point device B type.

12. PA_ENDPOINTBCOLOR This field contains the color of the end point B device.

13. PA_PARTNUMBER This field contains the adapter part number.

14. PA_PERFORMANCE This contains the performance information of the adaptor.

15. PA_VENDORID This contains the adaptor vendor ID

16. PA_ENVIRONMENTALS This contains the environmental information

17. PA_NOTES This field contains the notes pertaining to the adaptor.



18. PA_ENABLEATCONNECTIVITY This field contains the status of the adaptor when it is connected. Table 6 – PA_CONTAINER

PA_CONTAINER

This table contains all discovered and created infrastructure units that can contain other devices (Racks, Faceplates, etc.)


1. PA_CONTAINERID Auto generated sequence number used to indentify each cable type entry.

2. PA_CONTAINERTYPEID

Foreign Key to PA_CONTAINERTYPE table which is used to identify the specific type of container

3. PA_DISPLAYNAME

The text displayed in the PIM software used to identify the container. This text is either populated by the discovery process or manually entered by the system user.

4. PA_LOCATIONID

Numerical value used to identify the location the container has been allocated to within infrastructure management. The value -1 indicates the container is unallocated (not assigned to a location).

5. PA_ROWCOUNT This field stores a count of the row in the container.

6. PA_COLUMNCOUNT This field stores a count of the column in the container. Table 7 – PA_DEVICEPORT

PA_DEVICEPORT PA_DEVICEPORT contains the list of available ports for each device discovered and listed in table PA_DEVICE. Each enumerated port contains detailed information related to each port such as port type, active status, connector type, position, etc. Port information is dynamic and is updated as SNMP trap messages are received from the PIM software. (Note: MNS devices may have additional information available in the PA_MNSDEVICEPORT table)


1. PA_DEVICEID Auto-generated sequence number.

2. PA_MEDIATYPEID This field contains the unique id from table PA_MEDIATYPE which defines the type of media connected to each port (Fiber, Copper, and Wireless).

3. PA_PORTNUMBER

This field contains the port number of each port of the device defined by the field PA_DEVICEID. This field contains the second half of the multi-key primary key defined for this table.

4. PA_DISPLAYNAME This field contains the text displayed within the PIM software for each device port.



5. PA_ISRESERVED This field stores the status of the port of the device.

6. PA_POESTATUS This field stores the status of the port of the DoE device.

7. PA_ PORTSTATUS This field contains a flag indicating whether or not the port is active on the network. The valid values are “0” (inactive) and “1” (active).

8. PA_ORDERINFO This field contains the order information.

9. PA_SECURELINK This field contains the secure link information.

10. PA_PORTTYPE This field contains the port type.

11. PA_CONNECTORTYPE This field contains the connector type.

12. PA_LOCKMODE This field contains the lock mode information.

13. PA_ISTRUNKPORT This field contains a flag indicating if the defined port is the trunk port.

14. PA_ISMGMTPORT This field contains a flag indicating whether or not the port is a management port.

15. PA_IFINDEX This field contains the interface index of the port.

16. PA_LINKSTATUS This field contains the information about the link status.

17. PA_LINKUPTIME This field contains the time that the port has been up.

18. PA_CHASSISINDEX This filed contains the index of the chassis.

19. PA_SLOTID This field contains the slot location where the device is installed.

20. PA_BLADEINDEX This field contains the index of the blade.

21. PA_BLADEPORTINDEX This field contains the port index of the blade.

22. PA_BLADEPORTNUMBER This field contains the port number of the blade.

23. PA_ISTRUNKDETECTION This field contains a flag indicating that the port is trunk or not.

24. PA_LASTENDDEV This field contains the name of the last device on the port.

25. PA_LASTENDDEVIP This field contains the IP of the last device on the port.

26. PA_PORTVIOLATIONSTATUS This field contains a flag indicating the violation status on the port.

27. PA_TRAPNUMBER This field contains the trap number.

28. PA_EVENTLOGID This field contains the ID of the event log.

29. PA_PARENTID This field contains the ID of the parent device

30. PA_GRANDPARENTID This field contains the ID of the grand-parent device


T E C H N I C A L R E F E R E N C E Table 8 -PA_DEVICE

PA_DEVICE PA_DEVICE contains each device in the network that has been identified through the automatic discovery process in the PIM Infrastructure module or any device that has been manually added by the user. (Note: MNS devices may have additional information available in the PA_MNSDEVICE table)


1. PA_DEVICEID This field contains the device id from PA_DEVICE that the record for each port belongs to. This field forms first half the multi-key primary key for this table.

2. PA_DEVICETYPE

This field contains the numeric reference to PA_DEVICETYPE table used to identify device type.

3. PA_DEVICETYPEMODIFIED This field contains the modified device type.

4. PA_DISPLAYNAME

The field contains the text displayed for the device throughout the PIM application.

5. PA_LOCATIONID This field contains the numeric reference to the PA_LOCATION table.

6. PA_NUMBERPORTS The total number of ports available for devices with ports.

7. PA_NUMBERMGMTPORTS This field contains the total number of management ports on the device.

8. PA_MAC This field contains the string representation of the MAC address for each device.

9. PA_IPADDRESS This field contains the string representation of the IP address for each device.

10. PA_SYSOBJECTID This field contains the SNMP MIB id.

11. PA_SYSLOCATION

The field contains the location of the item in the PIM system hierarchy. This storage scheme may be depreciated after serpentine.

12. PA_IPTYPE This field contains the IP address type.

13. PA_COMMENT

This field stores the text saved in the “comments” text box for devices in the Infrastructure Management module.

14. PA_CONTAINERID

This field contains the numeric id of the container (from PA_CONTAINER) that the device is placed within.

15. PA_CONTAINERPOSITION

This field contains the physical numerical position of the device in the container in which it is located.

16. PA_CONNECTIONTYPE This field contains the connection type.

17. PA_ISALIVE

This field contains a flag indicating the device reporting itself as active on the network. The valid values are “0” and “1”.

18. PA_ISALIVEMODIFIEDAT This field contains the date that the field PA_ISALIVE was last modified.

19. PA_SUBNETMASK This field contains the subnet mask of the device.



20. PA_GATEWAY This field contains the gateway of the device.

21. PA_ISPOWERSUPPLY This field contains a flag indicating whether or not the device is a networked power supply. The valid values are “0” and “1”.

22. PA_HARDWAREVERSION This field contains the hardware version of the device.

23. PA_FIRMWAREVERSION This field contains the current firmware version of the device.

24. PA_CONTACTNAME This field contains the name of the contact person.

25. PA_EMPLOYEEID This field contains the ID of the employee.

26. PA_CONNECTIONSTATUS This field contains the status of the connection.

27. PA_DUPLICATEDEVICENAME This field contains the duplicate name of the device.

28. PA_DUPLICATEDEVICEMAC This field contains the duplicate Media Access Control (MAC) address of the device.

29. PA_DUPLICATEDEVICEIP This field contains the duplicate IP address of the device.

30. PA_DUPLICATEDEVICEID This field contains the duplicate ID address of the device.

31. PA_MANAGEDPORTNUMBER This field contains the total number of managed ports on the device.

32. PA_CALCULATEDIP This field contains the calculated IP address.

33. PA_DRIVERID This field contains the ID of the driver.

34. PA_DEVICESOURCE This field contains the source of the device.

35. PA_OS This field contains the Operating System (OS) of the device.

36. PA_SYSDESCR This field contains the system description of the device.

37. PA_LINKSTATUS This field contains the link status.

38. PA_RACKCOLUMN This field contains the rack column.

39. PA_DEVICEORIENTATION This field contains the orientation of the device. Table 9 – PA_DEVICETYPE

PA_DEVICETYPE

This table contains the available device types for each discovered device in the PIM software (e.g. Device Type field in the PIM Infrastructure Module).


1. PA_DEVICETYPE Auto-generated sequence number. Uniquely indentifies each device type.

2. PA_DESCRIPTION This field contains the textual description of the defined device type.

3. PA_SYSOBJECTID This field contains the SNMP MIB id. This SNMP MIB value indicates the reporting capabilities of the device.



4. PA_NUMBERPORTS This field contains the standard number of port for each defined device type/

5. PA_NUMBERMGMTPORTS This field contains the total number of management ports on the device.

6. PA_MGMTPORTISDUALPORT This field is a flag indicating if the management port is a dual port or not.

7. PA_VENDORID This field contains the ID of the vendor

8. PA_ICONFILEPATH This field contains the relative file path location for the image file used to visually represent the device type in the various PIM modules.

9. PA_ISACTIVE This field contains a flag which indicates if the device is active or not. The valid values are “0” (inactive) and “1” (active).

10. PA_ISDUALPORT This field contains a flag which indicates whether or not the given device type has a dual port setup.

11. PA_NUMRACKSPACES This field gives the number of vertical spaces required in a rack for the device type.

12. PA_ISSWITCHTYPE This field contains a flag indicating if the device type is a switch. The valid values are “0” (not a switch) and “1” (switch).

13. PA_PVMONITORED This is field contains the monitored PV (See the code for info on PV)

14. PA_MACSPECFICATION This field contains the Media Access Control (MAC) specification of the device.

15. PA_DEVICEIMAGEID This field contains the id value from the PA_DEVICEIMAGE table indicating the image to be used for this device type.

16. PA_DEVICEBACKIMAGEID This field contains the ID of the back image to be used.

17. PA_PRODUCTFAMILY This field contains the product family of the device.

18. PA_PERFORMANCE This field contains the performance of the device.

19. PA_BLADE This field contains the name of the blade.

20. PA_CLASSTYPE This field contains the type of the blade.

21. PA_PARTNUMBER This field contains the part number of the device.

22. PA_ENVIRONMENTALS This field contains the environmental information.

23. PA_NOTES This field contains the notes relevant to the device type.

24. PA_RAM This field contains the RAM of the device.

25. PA_CPU This field contains the CPU of the device.

26. PA_FACEPLATETYPE This field contains the face plate type.

27. PA_OUTLETCOLOR This field contains the outlet color.

28. PA_EQUIPMENTTYPEID This field contains the numeric equipment type identifier from the table PA_EQUIPMENTTYPE.

29. PA_PANELTYPE This field contains the panel type.

30. PA_SHIELDTYPE This field contains the shield type.



31. PA_APPLICATIONTYPE This field contains the application type.

32. PA_CUT_THRU_ENABLED This field contains a flag indicating whether or not the device is cut-through-enabled or not.

33. PA_INTERCONNECTVERIFICATION

This field contains the verification of the interconnect configuration.

34. PA_VERTICALRUSIZE This field contains the vertical RU size.

Table 10 – PA_EQUIPMENTTYPE

PA_EQUIPMENTTYPE

This table holds the ids and descriptions of the higher level equipment types in the PIM system.


1. PA_EQUIPMENTTYPEID Auto generated sequence number. Uniquely indentifies table rows.

2. PA_CATEGORYID This field contains the foreign key id that links to the PA_CATEGORY id table.

3. PA_EQUIPMENTTYPE This field contains the textual description of the defined equipment type.

4. PA_INTERCONNECTIBLE This field indicates the ability of the equipment type to be inter connectable. The valid values are “0” and “1”.

5. PA_ISMULTINICALLOWED This field contains the flag indicating if the multi NIC is allowed. Table 11 – PA_EQUIPMENTTYPECATEGORY

PA_EQUIPMENTTYPECATEGORY

This table holds the ids and equipment category in the PIM system.


1. PA_CATEGORYID The autogenerated category ID

2. PA_CATEGORY Equipment category


T E C H N I C A L R E F E R E N C E Table 12 – PA_GROUPINFO

PA_GROUPINFO This table defines the groups available to assign PIM system users.


1. PA_GROUPID Auto generated sequence number. Uniquely indentifies groups.

2. PA_GROUPNAME

This field contains the textual description the defined user group.

3. PA_SYSTEMDEFINED This field contains a flag that indicates if the group is a default system group or a user created group.

4. PA_GROUPDESCRIPTION This field contains the textual description of the defined group. Table 13 – PA_LOCATION

PA_LOCATION The PA_LOCATION table contains the user supplied entries in the Network tree. The Network tree contains the locations where the user can provision devices found during the discovery process and manually added devices.


1. PA_LOCATIONID Auto generated sequence number. Uniquely indentifies table rows.

2. PA_LOCATIONLEVEL The numerical level of the location in the user defined hierarchy. (e.g. The top level of the tree would have the value one (1) as the value of this field, any immediate branches below one (1) would have the value two (2) and so on).

3. PA_DESCRIPTION The (user defined) text that is displayed in the actual tree.

4. PA_CONTAININGLOCATIONID This field is a self-referencing value of the PA_LOCATION table. The value represents the parent side of the parent-child relationship in the Network tree hierarchy. A value of zero (0) indicates a top level branch (with Network being the actual root of the location hierarchy)


T E C H N I C A L R E F E R E N C E Table 14 – PA_LOCATIONLEVEL

PA_LOCATIONLEVEL The PA_LOCATIONLEVEL table contains the user supplied entries in the Network tree.


1. PA_LOCATIONLEVEL Generated

2. PA_LOCATIONLEVELORDER Logical order of location

3. PA_DESCRIPTION Layer description level

4. PA_ICONFILEPATH Image file to depict location

5. PA_SELECTLEVEL

6. PA_DEVICELOCATIONSTRINGINDEX Indicates hierarchical level of location layers Table 15 – PA_LOGIN

PA_LOGIN This table contains the defined users (and passwords) for the system. A default user of “admin” is created upon system installation.


1. PA_LOGINID This field contains the alphanumeric string that uniquely identifies each defined user.

2. PA_PASSWORDSTR This field contains the user password string stored in a hashed format.

3. PA_EMAILADDRESS This field contains the email address entered for the defined use.

4. PA_TPSMAPPING This field contains the mapping of the TPS (What is TPS?)

5. PA_GROUPID This field contains the group id that the user is assigned to.

6. PA_ALIAS This field contains a alternate description for the defined user.

7. PA_EMPLOYEEID This field contains the ID of the employee.

8. PA_LASTLOGIN This field contains the last login date for the defined user.

9. PA_PWDHISTORY This field contains a link to the id field of PA_PASSWORDHISTORY.

10. PA_PWDRETRYLIMIT This column defines the number of times the user is allowed to enter an incorrect password while logging in.

11. PA_PWDCOMPLEXITY This field contains a flag which defines the complexity requirement of the user’s password.

12. PA_NOPWDCHANGE This field contains a flag which indicates if the password can be changed.



13. PA_CHANGEPWDNEXTLOGIN This field contains a flag indicating if the user must change password at the next login attempt.

14. PA_PWDEXPIRY This field contains a flag indicating if the password is allowed to expire.

15. PA_PWDCREATIONDATE This field contains the date of the password creation

16. PA_NOOFDAYSFORPWDEXPIRY The number of days the password is active.

17. PA_ACCOUNTEXPIRENEVER This field contains a flag that indicate if the account is allowed to expire.

18. PA_ACCOUNTEXPIREENDOF This field contains the date at which the account expires.

19. PA_ACCOUNTEXPIRYDATE This field contains the date at which the account expires.

20. PA_USERTYPE This field defines the user type.

21. PA_ATTEMPTEDFAILURES This field contains the number of incorrect login attempts.

22. PA_ACCOUNTLOCKED This field contains a flag indicating if the account has been locked.

23. PA_PWDRETRYLIMITCROSSED This field contains a flag indicating if the login limit has been exceeded.

24. PA_EVENTPAGELIMIT This field contains the event page limit. Table 16 – PA_LOGINSESSION

PA_LOGINSESSION This table contains a running log of all successful login events by login id.


1. PA_IPADDRESS

The field contains the IP address of the network card from which the user logged in to the PIM system.

2. PA_LOGINID

This field contains the login id of the user who has logged in from the computer defined in PA_IPADDRESS

3. PA_LOGINTIME This filed contains the time the user logged in to the system Table 17 – PA_MNSDEVICEPORT

PA_MNSDEVICEPORT This table contains additional port information about Panduit/MNS specific devices. This data is in addition the device port information in the PA_DEVICEPORT table.


1. PA_DEVICEID This field contains an id reference to the PA_DEVICEID field in the PA_DEVICE/PA_MNSEVICEPORT tables.



2. PA_PORTNUMBER This field contains an id reference to the PA_PORTNUMBER field in the PA_DEVICEPORT/PA_MNSDEVICEPORT tables.

3. PA_PORTLOCATIONSTRING This field contains the port location string.

4. PA_POWERCONTROL This field contains the power control information.

5. PA_POWERMODE This field contains the power mode.

6. PA_POWERTYPE This field contains the power type.

7. PA_LEDCOLOR This field contains the textual information about the color of the LED.

8. PA_LEDPERIOD This field contains the period that the LED is ON.

9. PA_LEDISOVERRIDE This field contains the flag indicating if the LED was overridden.

10. PA_LEDISBLINK This field contains the flag indicating that the LED is blinking.

11. PA_CLASSIFICATION This field contains the classification information about the device port.

12. PA_DETECTIONSTATUS This field contains the port detection status.

13. PA_GROUPID This field contains the ID of the group.

14. PA_INVALIDSIGNATURECOUNTER This field contains the invalid signature counter.

15. PA_MPSABSENTCOUNTER This field contains the count of the MPS were absent.

16. PA_OVERLOADCOUNTER This field contains the count of the port over load.

17. PA_POWERDENIEDCOUNTER This field contains the count of the number of times that the power was denied.

18. PA_POWERPAIRS This field contains the power pairs.

19. PA_POWERPRIORITY This field contains the power priority.

20. PA_SHORTCOUNTER This field contains the short counter of the device port.

21. PA_TYPE This field contains the type of the device port.

22. PA_ADMINISENABLE This field contains the flag indicating if the administrative functionality is enabled.

23. PA_POWERPAIRSISCONTROLABILITY This field contains the flag indicating if power pairs are controllable.

24. PA_CORDTYPE This field contains the cord type.

25. PA_FEIP This field contains the IP of the FE. (What is FE)

26. PA_FEMAC This field contains the Media Access Control (MAC) address of the FE.

27. PA_FEPVIQUNIQUEID This field contains the PViQ unique ID (what is FE?)

28. PA_FEOFFSET This field contains the offset of the FE



29. PA_FEPORT This field contains the FE port

30. PA_NEOFFSET This field contains the NE offset.(What is the NE? Network Element?)

31. PA_NEPORT This field contains the NE port

32. PA_PATCHSTATUS This field contains the patch status

33. PA_SWIP This field contains the software IP

34. PA_SWMAC This field contains the software Media Access Control (MAC) address

35. PA_SWOFFSET This field contains software offset.

36. PA_SWPORT This field contains software port.

37. PA_PPFLAG This field contains PP flag. (what is PP)

38. PA_POWERCONSUMPTION This field contains Power Consumption Table 18 - PA_PAM_SENSOR

PA_PAM_SENSOR PA_PAM_SENSOR contains configuration data for sensor. PAM (Panduit Aggregation Manager) displays and reports events to the Event Manager when the sensor values cross the enabled low or high threshold limits defined by the user.


1. PA_SENSORID This field uniquely identifies each sensor.

2. PA_DESCRIPTION This field stores the description of the sensor that is provided by the user.

3. PA_SENSORTYPE This field stores the type of the sensor.

4. PA_HIGH_THRESHOLD This field stores high threshold value of the sensor. If the sensor reading value surpasses the enabled high threshold, an event will be reported to the Event Manager.

5. PA_HIGH_ENABLED This field indicates whether or not the high threshold value is enabled.

6. PA_LOW_THRESHOLD This field stores low threshold value of the sensor. If the sensor reading value fails below the enabled low threshold, an event will be reported to the Event Manager.

7. PA_LOW_ENABLED This field indicates whether or not the low threshold value is enabled.

8. PA_LAST_READ_TIME This field stores the timestamp of the sensor’s last reading.

9. PA_LAST_READING This field stores the value of the sensor’s last reading.


T E C H N I C A L R E F E R E N C E Table 19 - PA_PERMISSIONS

PA_PERMISSIONS The table contains the descriptions and definitions of all system permissions available in the PIM software. These permissions are applied at the Group level in the PA_GROUPPERMISSIONS table.


1. PA_PERMISSIONID This field contains the unique numerical id for each defined system module permission.

2. PA_DESCRIPTION This field contains a brief description describing what the defined permissions apply to.

3. PA_MODULEID This field contains the values for the PIM system module that the defined permission affects.

4. PA_ACTION This field defines the action that is allowed to be performed on the object the permission is applicable to.

Table 20 - PA_SENSOR

PA_SENSOR PA_SENSOR tracks all the sensors that constitute the device. It also maps the relationship between devices and sensors.


1. PA_ SENSORID This field stores a unique ID for each sensor of the device.

2. PA_DEVICEID This field stores a unique ID of the device that contains an array of sensors.

Table 21 - PA_SENSOR_READING

PA_SENSOR_READING PA_SENSOR_READING contains sensor readings. During polling period, PIM reads values from the sensors, and then it stores them in their respective fields of this table.


1. PA_READINGID This field uniquely identifies each reading of the sensors.

2. PA_ SENSORID This field uniquely identifies each sensor.

3. PA_VALUE This field stores value of the sensor’s reading.

4. PA_TIMESTAMP This field stores the timestamp of the sensor’s reading.


T E C H N I C A L R E F E R E N C E Table 22 - PA_SUBTASKTYPE

PA_SUBTASKTYPE This table contains the list of defined attributes populated during task exports to third party systems.


1. PA_TASKTYPEID The generated Task Type ID

2. PA_WOTYPE_DESCRIPTION_TAG This is the tag in locale table This will translate to Sub-Task Short Description.

3. PA_WOTYPE_ENRICHMENT Comma separated list of asset attributes which must be populated during task export to 3rd party system

Table 23 - PA_USERDIRECTORY

PA_USERDIRECTORY This table contains the list of defined users in the PIM System Administration module. The user list is located under the User Administration/User Directory tabs.


1. PA_EMPLOYEEID This field contains the user’s unique system id.

2. PA_FIRSTNAME This field contains the user’s first name, if defined.

3. PA_LASTNAME This field contains the user’s first name, if defined.

4. PA_WORKPHONE This field contains the user’s work phone number, if defined.

5. PA_EMAILADDRESS This field contains the user’s email address, if defined.

6. PA_LOCATION This field contains the user’s location, if defined.

7. PA_BUSINESSGROUP This field contains the user’s location, if defined.

8. PA_WORKADDRESS This field contains the user’s location, if defined.

9. PA_WORKZIP This field contains the user’s zip code, if defined.

10. PA_WORKSTATE This field contains the user’s state, if defined.

11. PA_WORKCITY This field contains the user’s city, if defined.

12. PA_READONLY This field contains a flag indicating if the user’s record can be modified.

13. PA_SOURCE This field contains a string defining the origin of the user record.

14. PA_LASTMODIFIEDBY This field contains the login id of the PIM system user who has last modified the user record.

15. PA_LASTMODIFIEDDATE This field contains the date that the last user record modification has occurred.


T E C H N I C A L R E F E R E N C E Table 24 - PA_VENDOR

PA_VENDOR This table contains a list of various vendor/manufactures of devices within the system.


1. PA_VENDORID This field uniquely identifies each vendor in the system.

2. PA_VENDORNAME This field contains the stored name of the defined vendor.

3. PA_COMMENTS This field contains a brief description of the defined vendor.

4. PA_ICONFILEPATH This field contains the relative file path to the image file used for each vendor.

5. PA_VENDORADDRESSID This field contains the value of the id to the PA_VENDORADDRESS table.

6. PA_URLID This filed contains the URL to the vendor website. Table 25 - PA_WORKORDERLIST

PA_WORKORDERLIST PA_WORKORDERLIST contains the fields needed to create and track work orders within PIM.


1. PA_PIMWOID Generated unique line item (WO/task/sub-task) id which uniquely identifies every record.

2. PA_WOID 3rd party WO ID.

3. PA_TASKID 3rd party Task Id. Shall be equal to Null for the WO record.

4. PA_TPSPIMTASKID External System assigned task id mapped to PIM sub-task

5. PA_SEQUENCENUM 0 – 3rd party WO record 0 – 3rd party Task record 1-N – PIM sub-tasks (Re)Defines sub-tasks ordering.

6. PA_PRECEDENCENUM Defines Sequence number which must be executed before this sequence. Should prevent re-sequencing (re-ordering) if it breaks precedence rules.

7. PA_DESCRIPTION Name of the WO, Task or Sub-task.

8. PA_PIMSTATUS PIM Status

9. PA_EXTSTATUS Exit Status



10. PA_CREATEUSERID User who created WO/Tasks/Sub-task

11. PA_ASSIGNEDUSERID User assigned to execute Task/Sub-task

12. PA_CREATEDATE The created date

13. PA_UPDATEDATE The updated date

14. PA_SCHEDULEDENDDATE The Scheduled date

15. PA_ACTUALENDDATE The actual completion date

16. PA_WOINDICATOR Special indication for this wo, i.e. Lock WO, Lock Task, Cancel, etc.

17. PA_TASKTYPEID Many-to-one association to task types table

18. PA_SUBTASKARG1 Can be any object id (i.e. connection pair id, device id, etc). It will depend on Task Type.

19. PA_SUBTASKARG2 Can be any object id (i.e. connection pair id, device id, etc). It will depend on Task Type.

20. PA_NOTES Free form text describing 3rd party task Or Free form text describing PIM sub-task special instructions

pim database dictionary - panduit · pim™ abbreviated data dictionary . ... the guide defines and...

Documents