Portal Service
PortalService
63 columns Fetched February 27, 2026
Columns
TicketNbr Numeric
Rec_Type Text
owner_level_recid Numeric
Location Text nullable
billing_unit_recid Numeric nullable
SR_Board_RecID Numeric
Also in 21 reports
Kb Resolution Audit Trail Member Portal Config Service Boards Portal Project Portal Ticket Type Description Project Project Header Service Service Board Service Board Members Service Code Service Item Service KPICount By Hour Service Status Service Sub Type Service Team Service Template Service Type Service Open Service Summary Service Summary Open
Board_Name Text nullable
Site_Name Text nullable
sr_status_recid Numeric
Urgency Text nullable
Urgency_Sort_Order Numeric nullable
service_location Text nullable
Status_SortOrder Numeric nullable
status_description Text nullable
Source Text nullable
Closed_Flag Boolean nullable
ClosedDesc Text
date_closed DateTime nullable
closed_by Text nullable
Type_RecID Numeric nullable
Also in 5 reports
ServiceType Text nullable
SubType_RecID Numeric nullable
Also in 5 reports
ServiceSubType Text nullable
SubTypeItem_RecID Numeric nullable
Also in 5 reports
ServiceSubTypeItem Text nullable
company_name Text nullable
company_recid Numeric nullable
contact_name Text nullable
contact_recid Numeric
Address_Line1 Text
Address_Line2 Text
City Text
State Text
PostalCode Text
Country Text
Summary Text nullable
Detail_Description Text
Internal_Analysis Text
Resolution Text
AGR_Header_RecID Numeric nullable
Also in 20 reports
Territory Text nullable
territory_recid Numeric nullable
Territory_Manager Text nullable
entered_by Text nullable
date_entered DateTime nullable
Universal_Formatted_Date_Entered Text nullable
Date_Entered_UTC DateTime nullable
Updated_By Text nullable
Last_Update DateTime nullable
Universal_Formatted_Last_Update Text nullable
Last_Update_UTC DateTime nullable
Date_Required DateTime nullable
Universal_Formatted_Date_Required Text nullable
Date_Req DateTime nullable
Time_Zone Text nullable
Hours_Budget Numeric nullable
Approved_Flag Boolean
resource_list Text
Sla_Name Text nullable
Hours_Actual Numeric nullable
Publish_Flag Boolean
Site Text nullable
IsMerged Numeric
| Name | Type | Nullable | Also In |
|---|---|---|---|
| TicketNbr | Numeric | No | unique |
| Rec_Type | Text | No | unique |
| owner_level_recid | Numeric | No | unique |
| Location | Text | Yes | unique |
| billing_unit_recid | Numeric | Yes | unique |
| SR_Board_RecID | Numeric | No | 21 reports Kb Resolution Audit Trail Member Portal Config Service Boards Portal Project Portal Ticket Type Description Project Project Header Service Service Board Service Board Members Service Code Service Item Service KPICount By Hour Service Status Service Sub Type Service Team Service Template Service Type Service Open Service Summary Service Summary Open |
| Board_Name | Text | Yes | unique |
| Site_Name | Text | Yes | unique |
| sr_status_recid | Numeric | No | unique |
| Urgency | Text | Yes | unique |
| Urgency_Sort_Order | Numeric | Yes | unique |
| service_location | Text | Yes | unique |
| Status_SortOrder | Numeric | Yes | unique |
| status_description | Text | Yes | unique |
| Source | Text | Yes | unique |
| Closed_Flag | Boolean | Yes | unique |
| ClosedDesc | Text | No | unique |
| date_closed | DateTime | Yes | unique |
| closed_by | Text | Yes | unique |
| Type_RecID | Numeric | Yes | |
| ServiceType | Text | Yes | unique |
| SubType_RecID | Numeric | Yes | |
| ServiceSubType | Text | Yes | unique |
| SubTypeItem_RecID | Numeric | Yes | |
| ServiceSubTypeItem | Text | Yes | unique |
| company_name | Text | Yes | unique |
| company_recid | Numeric | Yes | unique |
| contact_name | Text | Yes | unique |
| contact_recid | Numeric | No | unique |
| Address_Line1 | Text | No | unique |
| Address_Line2 | Text | No | unique |
| City | Text | No | unique |
| State | Text | No | unique |
| PostalCode | Text | No | unique |
| Country | Text | No | unique |
| Summary | Text | Yes | unique |
| Detail_Description | Text | No | unique |
| Internal_Analysis | Text | No | unique |
| Resolution | Text | No | unique |
| AGR_Header_RecID | Numeric | Yes | |
| Territory | Text | Yes | unique |
| territory_recid | Numeric | Yes | unique |
| Territory_Manager | Text | Yes | unique |
| entered_by | Text | Yes | unique |
| date_entered | DateTime | Yes | unique |
| Universal_Formatted_Date_Entered | Text | Yes | unique |
| Date_Entered_UTC | DateTime | Yes | unique |
| Updated_By | Text | Yes | unique |
| Last_Update | DateTime | Yes | unique |
| Universal_Formatted_Last_Update | Text | Yes | unique |
| Last_Update_UTC | DateTime | Yes | unique |
| Date_Required | DateTime | Yes | unique |
| Universal_Formatted_Date_Required | Text | Yes | unique |
| Date_Req | DateTime | Yes | unique |
| Time_Zone | Text | Yes | unique |
| Hours_Budget | Numeric | Yes | unique |
| Approved_Flag | Boolean | No | unique |
| resource_list | Text | No | unique |
| Sla_Name | Text | Yes | unique |
| Hours_Actual | Numeric | Yes | unique |
| Publish_Flag | Boolean | No | unique |
| Site | Text | Yes | unique |
| IsMerged | Numeric | No | unique |