relationships between location table, bulding table, floor and room table

nattapholu
Kilo Contributor

Hi guys,

I'm working on reference tables starting off with location, it will be in hierarchy so we make use of the 'parent' field. top level that we define is building, then next level down is host modules (data center, data room, PoP site, Closet, etc) and the lowest level is space name. does this mean I should crate records in location table and maintain hierarchy in there only?

I'm asking this because I saw tables called building, room and floor in the facility management. Are they just for facility purpose? What I tried was I created a City in Location table, then a building in the location table, use the city as parent location for the buliding I created. Then I look into an hw asset record, tried to update the locaiont but it only showed me the city I created, not to the bulding I put in bulding table. So I guess ServiceNow can't show hierarchy across the tables?

Thanks in advance.

5 REPLIES 5

nattapholu
Kilo Contributor

another question, I know Sys ID is a unique ID for each record in there. Is it displayable? I see there is auto number feature in there, whatif I use different prefixes for each location type, let's say country is C, building is B, data center is C, can I create a business rule for this?