Broadsoft CDR Dimension Tables | |||
CallCategoryDimension | |||
|---|---|---|---|
| Column Name | Azure Type | Snowflake Type | Description |
| ccd_id | int | NUMBER(38,0) | Primary key. |
| ccd_callCategory | varchar(16) | VARCHAR(16) | Call category |
| ccd_description | varchar(32) | VARCHAR(32) | Call category description |
| ccd_group | varchar(16) | VARCHAR(16) | Call category group |
| ccd_scope | varchar(32) | VARCHAR(32) | Call category scope |
| ccd_isCharge | bit (1=true/0=false) | BOOLEAN | Is charge flag |
CallTypeDimension | |||
| Column Name | Azure Type | Snowflake Type | Description |
| ct_id | int | NUMBER(38,0) | Primary key |
| ct_eipCallType | varchar(16) | VARCHAR(16) | Billing call type |
| ct_productCode | varchar(16) | VARCHAR(16) | Product code |
| ct_serviceLocation | varchar(16) | VARCHAR(16) | Service location |
| ct_description | varchar(64) | VARCHAR(64) | Call type description |
| ct_handling | varchar(8) | VARCHAR(8) | Indicates if the call is rated (represented as RATE) |
| ct_increment | decimal(10, 1) | NUMBER(10,1) | The billing duration increment in seconds |
| ct_interState | varchar(1) | VARCHAR(1) | Y/N - indicates if rate is applied to interState only |
| ct_minimum | decimal(10, 1) | NUMBER(10,1) | The minimum billing duration in seconds |
| ct_perMinuteOrPerCall | varchar(8) | VARCHAR(8) | Indicates if rate is applied per minute or per call. Current values are 'Minute' or 'Call' |
| ct_rate | decimal(10, 4) | NUMBER(10,4) | Represents the rate value in USD out to 1/100 of a cent |
| ct_st | varchar(3) | VARCHAR(3) | Service tax code |
| ct_tt | varchar(3) | VARCHAR(3) | Transaction tax code |
LergDimension | |||
| Column Name | Azure Type | Snowflake Type | Description |
| ld_npaNxx | int | NUMBER(38,0) | The area code (NPA) and exchange (NXX) |
| ld_city | varchar(48) | VARCHAR(48) | City |
| ld_clli | varchar(32) | VARCHAR(32) | CLLI (Common Language Location Identifier) |
| ld_hcoord | int | NUMBER(38,0) | Horizontal Coordinate |
| ld_lata | varchar(4) | VARCHAR(4) | LATA (Local Access and Transport Area) |
| ld_ocn | varchar(4) | VARCHAR(4) | OCN (Original Call Number) |
| ld_rateCenter | varchar(10) | VARCHAR(10) | Rate Center |
| ld_state | varchar(2) | VARCHAR(2) | State |
| ld_vcoord | int | NUMBER(38,0) | Vertical Coordinate |
Broadsoft CDR Fact Tables | ||||||
BroadsoftCDRFact | ||||||
| # | Column Name | Azure Type | Snowflake Type | Description | References | Indexed |
|---|---|---|---|---|---|---|
| 1 | bf_id | bigint | NUMBER(38,0) | The primary key | ||
| 2 | bf_defaultNpaNxx | varchar(6) | VARCHAR(6) | The area code (NPA) and exchange (NXX) used to tax and rate calls that do not represent a valid endpoint, such as a toll-free number. | ||
| 3 | bf_billedOn | bigint | NUMBER(38,0) | Future use | ||
| 4 | bf_interLata | bit (1=true/0=false) | BOOLEAN | LATA (local access and transport area), did this call traverse LATAs. This is typically use for call rating. | ||
| 5 | bf_calledCountry | int | NUMBER(38,0) | Foreign key to the called country code for this call. | CountryDimension | |
| 6 | bf_recordId | varchar(50) | VARCHAR(50) | The call detail record identifier | ||
| 7 | bf_onNet | bit (1=true/0=false) | BOOLEAN | Did this call originate and terminate within the Evolve IP network. | ||
| 8 | bf_eipCallType | int | NUMBER(38,0) | The call type identifier | CallTypeDimension | |
| 9 | bf_callDuration | bigint | NUMBER(38,0) | The call duration in seconds. The represents the entire length of the call, from off-hook to on-hook. | ||
| 10 | bf_accountId | int | NUMBER(38,0) | Foreign key to the account associated with this call | AccountDimension | |
| 11 | bf_system | int | NUMBER(38,0) | Foreign key to the system identifier | SystemDimension | |
| 12 | bf_billable | bit (1=true/0=false) | BOOLEAN | Future use | ||
| 13 | bf_productCode | int | NUMBER(38,0) | Foreign key to the product code | ProductDimension | |
| 14 | bf_ringDuration | bigint | NUMBER(38,0) | The call ringing time, in seconds, before it was answered or dropped. The represents how long a call rang, from off-hook to answer or hang-up if no answer detected. | ||
| 15 | bf_cdrType | varchar(16) | VARCHAR(16) | The CDR type. Possible values are:
| ||
| 16 | bf_userNumber | varchar(128) | VARCHAR(128) | The E.164 number of the user generating (that is, accountable for) this CDR | ||
| 17 | bf_interState | bit (1=true/0=false) | BOOLEAN | Indicates if the call traverse between two states | ||
| 18 | bf_billDuration | bigint | NUMBER(38,0) | The billable duration of the call, from the answer event to the disconnect event in seconds | ||
| 19 | bf_callRecordingRecordingDestination | varchar(161) | VARCHAR(161) | This field indicates the identity or address of the third-party call recording platform where the media stream is sent. This destination could be in the format of an IP address, host name, or fully qualified domain name | ||
| 20 | bf_meetmeConferenceRecordingDuration | int | NUMBER(38,0) | The total conference recording duration, in seconds. This field is populated only in the CDR of the last party to leave a recorded conference | ||
| 21 | bf_originalCalledPresentationIndicator | varchar(20) | VARCHAR(20) | The presentation indicator of the calling number. Possible values are:
| ||
| 22 | bf_ccDispositionCodeTaggingResult | char(1) | VARCHAR(1) | This field indicates the result (S for Success or F for failure) of the tagging operation. The value S confirms the tagging operation was invoked and processed successfully | ||
| 23 | bf_callCenterOutgoingCallCenterUserId | varchar(161) | VARCHAR(161) | This field captures the Call Center ID that the DNIS name used by the agent to make the outgoing call belongs to | ||
| 24 | bf_redirectingCalledPresentationIndicator | varchar(20) | VARCHAR(20) | The presentation indicator of the calling number. Possible values are:
| ||
| 25 | bf_enterpriseTrunkCapacityExceeded | char(1) | VARCHAR(1) | The enterprise trunk capacity exceeded condition. 1 is the only value. This field is present only when an enterprise trunk capacity exceeded condition blocks the call | ||
| 26 | bf_preAlertingAnnouncementPreAlertingDuration | int | NUMBER(38,0) | The pre alerting announcement duration in seconds | ||
| 27 | bf_callCenterOutgoingCallCenterCallFACResult | char(1) | VARCHAR(1) | This field captures the result (S for Success or F for failure) of dialing the Call Center Make Call Center Call feature access code. The value S means the feature was invoked and processed successfully. | ||
| 28 | bf_broadworksAnywhereRelatedCallId | varchar(40) | VARCHAR(40) | This field provides the local call ID of termination from the portal to the BroadWorks Anywhere user | ||
| 29 | bf_meetmeConferenceInvocationTime | datetime2(7) | TIMESTAMP_NTZ(9) | Time at which the service was invoked during the call. The invocation time is shown using the UTC/GMT time zone. | ||
| 30 | bf_otherPartyNamePresentationIndicator | varchar(20) | VARCHAR(20) | The presentation indicator of the other party name. Possible values are:
| ||
| 31 | bf_callCenterOutgoingPersonalCallFACResult | char(1) | VARCHAR(1) | This field captures the result (S for Success or F for failure) of dialing the Call Center Make Personal Call feature access code. The value S means the feature was invoked and processed successfully | ||
| 32 | bf_callCenterOutgoingCallCenterGroupNumber | varchar(16) | VARCHAR(16) | This field captures the calling line ID group number (E.164 formatted) configured for the group that the Call Center is associated with for the DNIS name used by an agent to make the outgoing call | ||
| 33 | bf_ccDispositionCodeTaggingInvocated | bit (1=true/0=false) | BOOLEAN | This field indicates the result (0 or 1) of the tagging operation. The value 1 confirms the tagging operation was invoked and processed successfully | ||
| 34 | bf_callCenterOutgoingCallCenterPhoneNumber | varchar(16) | VARCHAR(16) | This field captures the Dialed Number Identification Service (DNIS) number (E.164 formatted) or extension associated with the DNIS name used by the agent to make the outgoing call | ||
| 35 | bf_callRecordingStopInvocated | datetime2(7) | TIMESTAMP_NTZ(9) | Time at which the On-Demand-Stop Call Recording service was invoked during the call. The invocation time is shown using the UTC/GMT time zone | ||
| 36 | bf_callRecordingPauseInvocated | datetime2(7) | TIMESTAMP_NTZ(9) | Time at which the Pause Call Recording service was invoked during the call. The invocation time is shown using the UTC/GMT time zone | ||
| 37 | bf_ccEmergencyCaIInvocated | datetime2(7) | TIMESTAMP_NTZ(9) | Time at which the CC Emergency Call service was invoked during the call. The invocation time is shown using the UTC/GMT time zone | ||
| 38 | bf_callRecordingInvocationTime | datetime2(7) | TIMESTAMP_NTZ(9) | Time at which the On-Demand Call Recording service was invoked during the call. The invocation time is shown using the UTC/GMT time zone | ||
| 39 | bf_collaborateBridge | varchar(128) | VARCHAR(128) | The name of the bridge, as entered by bridge administrators when creating the conference bridge | ||
| 40 | bf_callRecordingPausefacResult | char(1) | VARCHAR(1) | This field captures the result (S for Success or F for failure) of dialing a feature access code. The value S means the feature was invoked and processed successfully. | ||
| 41 | bf_collaborateOwner | varchar(161) | VARCHAR(161) | The BroadWorks user identifier of the collaborate room owner | ||
| 42 | bf_collaborateRole | varchar(11) | VARCHAR(11) | The role of the conference participant, which can be "participant" or "leader" | ||
| 43 | bf_collaborateRoomType | varchar(12) | VARCHAR(12) | The type of the collaborate room which is either "My Room", "Instant Room" or "Project Room" | ||
| 44 | bf_collaborateRoomName | varchar(80) | VARCHAR(80) | The name of the collaborate room, as entered by admin/use | ||
| 45 | bf_callRecordingStartInvocated | datetime2(7) | TIMESTAMP_NTZ(9) | Time at which the On-Demand-Start Call Recording service was invoked during the call. The invocation time is shown using the UTC/GMT time zone | ||
| 46 | bf_transferInvocationTime | datetime2(7) | TIMESTAMP_NTZ(9) | Time at which the transfer service was invoked during the call. The invocation time is shown using the UTC/GMT time zone | ||
| 47 | bf_collaborateRoomID | varchar(15) | VARCHAR(15) | The roomID is the same for all calls to the same conference room and is used to correlate all calls in the same conference. | ||
| 48 | bf_callRecordingResumefacResult | char(1) | VARCHAR(1) | This field captures the result (S for Success or F for failure) of dialing a feature access code. The value S means the feature was invoked and processed successfully | ||
| 49 | bf_collaborateInvocated | datetime2(7) | TIMESTAMP_NTZ(9) | Time at which the service was invoked during the call. The invocation time is shown using the UTC/GMT time zone | ||
| 50 | bf_callRecordingResumeInvocated | datetime2(7) | TIMESTAMP_NTZ(9) | Time at which the Resume Call Recording service was invoked during the call. The invocation time is shown using the UTC/GMT time zone | ||
| 51 | bf_collaborateOwnerDN | varchar(16) | VARCHAR(16) | The DN of the collaborate owner. If the owner does not have a DN, then this field contains the group CLID of the owner's group. | ||
| 52 | bf_calledLergInfo | int | NUMBER(38,0) | Foreign key to the called number LERG (local exchange routing guide) info. | LergDimension | |
| 53 | bf_serviceLocation | int | NUMBER(38,0) | Foreign key to the service location identifier | LocationDimension | |
| 54 | bf_taxTransactionType | int | NUMBER(38,0) | Foreign key to tax transaction type identifier | TaxTransactionTypeDimension | |
| 55 | bf_ccEscalatedCallInvocated | bit (1=true/0=false) | BOOLEAN | This field captures the result (1 for success or 0 for failure) of dialing a feature access code. The value 1 means the feature was invoked and processed successfully | ||
| 56 | bf_accountGroupId | int | NUMBER(38,0) | Foreign key to the account group | AccountGroupDimension | |
| 57 | bf_voicePortalCallingInvocated | bit (1=true/0=false) | BOOLEAN | Indicates whether the Voice Portal Calling service was invoked during the call | ||
| 58 | bf_callingLergInfo | int | NUMBER(38,0) | Foreign key to the calling number LERG (local exchange routing guide) info | LergDimension | |
| 59 | bf_directVMTransferInvocated | bit (1=true/0=false) | BOOLEAN | This field captures the result (1 for success or 0 for N/A) of dialing a feature access code. The value 1 means the feature was invoked and processed successfully | ||
| 60 | bf_hotelingInvocated | bit (1=true/0=false) | BOOLEAN | Indicates whether the Hoteling service was invoked during the call | ||
| 61 | bf_ccMonitoringBIInvocated | bit (1=true/0=false) | BOOLEAN | This field captures the result (1 for success or 0 for N/A) of dialing a feature access code. The value 1 means the feature was invoked and processed successfully | ||
| 62 | bf_taxServiceType | int | NUMBER(38,0) | Foreign key to the tax service type | TaxServiceDimension | |
| 63 | bf_billingLocation | int | NUMBER(38,0) | Foreign key to the billing location | LocationDimension | |
| 64 | bf_callingCountry | int | NUMBER(38,0) | The dial country code of the caller | ||
| 65 | bf_callStartDateLocal | int | NUMBER(38,0) | Foreign key for the call start date in local time | DateDimension | Yes |
| 66 | bf_callStartTimeUTC | int | NUMBER(38,0) | Foreign key to the call start time of day in UTC | TimeOfDayDimension | |
| 67 | bf_billingAccount | int | NUMBER(38,0) | Foreign key to the billing account | AccountDimension | |
| 68 | bf_callStartDateUTC | int | NUMBER(38,0) | Foreign key to the call start date in UTC | DateDimension | |
| 69 | bf_callStartTimeLocal | int | NUMBER(38,0) | Foreign key to the call start time of day in local time | TimeOfDayDimension | |
| 70 | bf_callReleaseTimeLocal | int | NUMBER(38,0) | Foreign key to the call release time of day in local time | TimeOfDayDimension | |
| 71 | bf_callReleaseDateLocal | int | NUMBER(38,0) | Foreign key to the call release date in Local time | DateDimension | |
| 72 | bf_callReleaseDateUTC | int | NUMBER(38,0) | Foreign key to the call release date in UTC | DateDimension | |
| 73 | bf_callReleaseTimeUTC | int | NUMBER(38,0) | Foreign key to the call release time of day in UTC | TimeOfDayDimension | |
| 74 | bf_callDescription | varchar(32) | VARCHAR(32) | Call description | ||
| 75 | bf_answerIndicatorAttribute | varchar(18) | VARCHAR(18) | Possible values are:
| ||
| 76 | bf_answerIndicator | char(1) | VARCHAR(1) | Indicates if the call was answered. Possible values are Y for yes and N for No | ||
| 77 | bf_direction | varchar(12) | VARCHAR(12) | Possible values are "Originating" or "Terminating" | ||
| 78 | bf_userTimeZone | varchar(8) | VARCHAR(8) | The time zone of the user (an offset from GMT). The format is 0 (standard time) or 1 (daylight savings), followed by + or -, followed by the 6-digit offset (HHMMSS). The offset is adjusted for daylight savings. | ||
| 79 | bf_callingNumber | varchar(162) | VARCHAR(162) | The Calling party's number | ||
| 80 | bf_calledNumber | varchar(162) | VARCHAR(162) | The called number | Yes | |
| 81 | bf_groupNumber | varchar(16) | VARCHAR(16) | The group number of the user generating the CDR | ||
| 82 | bf_prepaidStatus | varchar(22) | VARCHAR(22) | The prepaid status. It indicates the call's outcome from an online billing perspective. Possible values are:
| ||
| 83 | bf_dialedDigits | varchar(162) | VARCHAR(162) | Digits as dialed by the user, before pre-translations | ||
| 84 | bf_department | varchar(256) | VARCHAR(256) | The user's department name | ||
| 85 | bf_transferType | varchar(40) | VARCHAR(40) | This field indicates the type of the transfer attempt. Possible values are:
| ||
| 86 | bf_locationType | varchar(128) | VARCHAR(128) | This corresponds to the device type of the location. Possible values are:
| ||
| 87 | bf_userAgent | varchar(1024) | VARCHAR(1024) | The local user agent for originating and terminating CDRs | ||
| 88 | bf_extTrackingId | varchar(72) | VARCHAR(72) | This field contains a string that identifies a session uniquely on the BroadWorks Application Server that processed the call | Yes | |
| 89 | bf_hotelingGroup | varchar(30) | VARCHAR(30) | The customer group ID for the hosting user | ||
| 90 | bf_recallType | varchar(40) | VARCHAR(40) | Indicates that the CDR is for a recall and that the content is determined by the service for which the recall is being performed. This field is set only in the terminating CDR for a recall. Call Transfer Recall uses the value "transfer". Call Park recall uses the value "call park". Automatic Hold Retrieve uses the value "automatic hold/retrieve". Executive-Assistant Call Push uses the value "executive-assistant call push" | ||
| 91 | bf_localCallId | varchar(128) | VARCHAR(128) | This field contains a string that uniquely identifies the session that processed the call | ||
| 92 | bf_accountCode | varchar(14) | VARCHAR(14) | The account code, if dialed | ||
| 93 | bf_accessCallId | varchar(162) | VARCHAR(162) | This field is present when the Application Server reaches a BroadWorks user's device, . It records the SIP Call ID that allowed the Application Server to make the connection to the device. | ||
| 94 | bf_route | varchar(86) | VARCHAR(86) | Indicates if the call was handles On-Net or Off-Net: Possible values:
| ||
| 95 | bf_networkCallId | varchar(162) | VARCHAR(162) | The network call identifier | ||
| 96 | bf_remoteCallId | varchar(40) | VARCHAR(40) | This field contains a string that uniquely identifies the session that processed the remote party's call for intra-group calls | ||
| 97 | bf_relatedCallId | varchar(40) | VARCHAR(40) | This field provides the call identifier of a different call that created or was created by this call as a consequence of service activation | ||
| 98 | bf_group | varchar(30) | VARCHAR(30) | The name of the group associated with this call. | Yes | |
| 99 | bf_typeOfNetwork | varchar(8) | VARCHAR(8) | This field presented in originating CDRs Network type can be "private" or "public". | ||
| 100 | bf_sipErrorCode | varchar(3) | VARCHAR(3) | SIP error code | ||
| 101 | bf_asCallType | varchar(11) | VARCHAR(11) | Possible values:
| ||
| 102 | bf_userId | varchar(161) | VARCHAR(161) | The login ID (including the domain) of the user generating (accountable for) this CDR | Yes | |
| 103 | bf_releaseTime | datetime2(7) | TIMESTAMP_NTZ(9) | The time when the call is released. The release time is presented in the UTC/GMT time zone. | Yes | |
| 104 | bf_rate | decimal(12, 5) | NUMBER(12,5) | Future use | ||
| 105 | bf_taxAmount | decimal(12, 4) | NUMBER(12,4) | Future use | ||
| 106 | bf_startTime | datetime2(7) | TIMESTAMP_NTZ(9) | The time when the address is sent to or received from the system. The start time is presented in the UTC/GMT time zone. | Yes | |
| 107 | bf_locationUsage | decimal(12, 3) | NUMBER(12,3) | This field indicates the length of time (in seconds, with three decimal digits), the location(s) described in the location field, were in use. | ||
| 108 | bf_cost | decimal(12, 4) | NUMBER(12,4) | Future use | ||
| 109 | bf_price | decimal(12, 4) | NUMBER(12,4) | Future use | ||
| 110 | bf_answerTime | datetime2(7) | TIMESTAMP_NTZ(9) | The time when the two-way media connection is established between the user and the other party. This happens when the terminating endpoint answers the call. The answer time is presented in the UTC/GMT time zone. | ||
| 111 | bf_btluExceeded | char(1) | VARCHAR(1) | This field indicates a BTLU unavailable condition. "Y" is the only value. This field is present only when a BTLU unavailable condition blocks the call. | ||
| 112 | bf_ccEscalatedCallResult | char(1) | VARCHAR(1) | This field captures the result ("S" for success or "F" for failure) of dialing a feature access code. The value "S" means the feature was invoked and processed successfully | ||
| 113 | bf_transferResult | char(1) | VARCHAR(1) | This field indicates the result of the transfer attempt. Possible values are S for success or F for failure | ||
| 114 | bf_ccMonitoringBIResult | char(1) | VARCHAR(1) | This field captures the result ("S" for success or "F" for failure) of dialing a feature access code. The value "S" means the feature was invoked and processed successfully | ||
| 115 | bf_callCategoryKey | int | NUMBER(38,0) | Foreign key to the call category | CallCategoryDimension | |
| 116 | bf_meetmeConferenceConferenceId | varchar(128) | VARCHAR(128) | The conference identifier is the same for all calls for the same conference | ||
| 117 | bf_originalCalledNumber | varchar(162) | VARCHAR(162) | The original called number | ||
| 118 | bf_networkTranslatedGroup | varchar(32) | VARCHAR(32) | This field reports the optional group ID of the called number, if any, for CDRs of originating | ||
| 119 | bf_relatedCallIdReason | varchar(40) | VARCHAR(40) | Indicates the reason that triggered the presence of the bf_relatedCallId field | ||
| 120 | bf_hotelingUserId | varchar(161) | VARCHAR(161) | The user identifier for the hosting user. | ||
| 121 | bf_networkTranslatedNumber | varchar(162) | VARCHAR(162) | The result of the translations of the called number by the Network Server. This field is only provided in CDRs of originating, non-intra-group calls. | ||
| 122 | bf_transferRelatedCallId | varchar(40) | VARCHAR(40) | This field provides the call identifier of the other call involved in the transfer. The call identifier is the value found in the bf_localCallId field of the related call. | ||
| 123 | bf_redirectingCalledNumber | varchar(162) | VARCHAR(162) | The last redirecting called number | ||
| 124 | bf_trunkGroupInfo | varchar(255) | VARCHAR(255) | This field contains the action taken by the Application Server to allow or deny the origination attempt. Possible values are: • Normal • Bursting • CapacityExceeded • None For a termination, the field indicates the results of the attempts to complete a call to a trunk group user. The field may contain multiple values (separated by spaces). The possible values are: • Normal • Bursting • Unreachable • CapacityExceeded • Unconditional • None | ||
| 125 | bf_meetmeConferenceRole | varchar(12) | VARCHAR(12) | The role of the conference participant, which can be "participant" or "leader". | ||
| 126 | bf_accessDeviceAddress | varchar(80) | VARCHAR(80) | The IP address (numerical or FQDN) where the user (as reported in the Basic module) receives the media of the session. | ||
| 127 | bf_meetmeConferenceBridge | varchar(128) | VARCHAR(128) | The name of the bridge, as entered by bridge administrators when creating the conference bridge. | ||
| 128 | bf_redirectingCalledReason | varchar(40) | VARCHAR(40) | Redirection Reason for the called number | ||
| 129 | bf_terminationCause | varchar(4) | VARCHAR(4) | Code capturing what action caused the call release. | ||
| 130 | bf_authorizationCode | varchar(14) | VARCHAR(14) | The authorization code collected by the Account/Authorization Codes or Enhanced Outgoing Calling Plan services, if dialed | ||
| 131 | bf_chargeIndicator | char(1) | VARCHAR(1) | Indicates whether the call is chargeable or not (according to the VoIP system, not the billing system). | ||
| 132 | bf_hotelingUserNumber | varchar(16) | VARCHAR(16) | The user number for the hosting user | ||
| 133 | bf_hotelingGroupNumber | varchar(16) | VARCHAR(16) | The group number for the hosting user | ||
| 134 | bf_originationMethod | varchar(30) | VARCHAR(30) | This field only appears in originating CDRs, when the call is initiated by the Application Server. It does not | ||
| 135 | bf_trunkGroupName | varchar(255) | VARCHAR(255) | The identity of the user's trunk group, if the user is subject to trunk group call capacity control | ||
| 136 | bf_callingPartyCategory | varchar(20) | VARCHAR(20) | The category of the calling party | ||
| 137 | bf_otherPartyName | varchar(80) | VARCHAR(80) | Name of the calling party for terminating CDRs. Name of the called party for originating CDRs. | ||
| 138 | bf_receivedCallingNumber | varchar(161) | VARCHAR(161) | The receiving calling number | ||
| 139 | bf_configurableCLID | varchar(20) | VARCHAR(20) | The value set in the user's configurable CLID | ||
| 140 | bf_networkCallType | varchar(4) | VARCHAR(4) | The network call type | ||
| 141 | bf_releasingParty | varchar(6) | VARCHAR(6) | Indicates which party released the call first. For example: "local", "remote" or "none". | ||
| 142 | bf_originalCalledReason | varchar(40) | VARCHAR(40) | Redirection Reason for the original called number | ||
| 143 | bf_directVMTransferResult | char(1) | VARCHAR(1) | This field captures the result ("S" for Success or "F" for Failure") of dialing a feature access code. The value "S" means the feature was invoked and processed successfully. | ||
| 144 | bf_callRecordingRecordingResult | char(1) | VARCHAR(1) | This service extension field indicates the status of the recorded media. The values for this field can be "s" for "successful" or "f" for "failed". | ||
| 145 | bf_callRecordingRecordingTrigger | varchar(20) | VARCHAR(20) | The user's recording mode for this call. Possible values are:
| ||
| 146 | bf_callRecordingStartfacResult | char(1) | VARCHAR(1) | This field captures the result ("S" for success or "F" for failure) of dialing a feature access code. The value "S" means the feature was invoked and processed successfully. | ||
| 147 | bf_meetmeConferenceOwner | varchar(161) | VARCHAR(161) | The BroadWorks user ID for the conference owner | ||
| 148 | bf_meetmeConferenceOwnerDN | varchar(32) | VARCHAR(32) | The DN of the conference owner. If the owner does not have a DN, then this field contains the group CLID of the owner's group | ||
| 149 | bf_meetmeConferenceTitle | varchar(80) | VARCHAR(80) | The title of the conference call, as entered by bridge administrators when creating the conference call | ||
| 150 | bf_meetmeConferenceProjectCode | varchar(40) | VARCHAR(40) | The project code as entered by the bridge administrator when creating the conference call | ||
| 151 | bf_callRecordingStopfacResult | char(1) | VARCHAR(1) | This field captures the result ("S" for success or "F" for failure) of dialing a feature access code. The value "S" means the feature was invoked and processed successfully | ||
| 152 | bf_callRecordingResult | char(1) | VARCHAR(1) | This field captures the result ("S" for success or "F" for failure) of dialing a feature access code. The value "S" means the feature was invoked and processed successfully | ||
| 153 | bf_location | varchar(256) | VARCHAR(256) | This field contains the provisioned public identity of the originating/terminating devices. | ||
| 154 | bf_eipId | varchar(16) | VARCHAR(16) | The account identifier for this CDR | Yes | |
| 155 | bf_userFk | int | NUMBER(38,0) | Foreign key to the user generating this CDR | BroadsoftUserDimension | Yes |
| 156 | bf_parentEipId | varchar(16) | VARCHAR(16) | The parent account identifier | ||
| 157 | bf_lastUpdatedTimestamp | datetime2(7) | TIMESTAMP_NTZ(9) | The timestamp indicating the most recent update of the record | ||
| 158 | bf_updated | bit (1=true/0=false) | BOOLEAN | Indicates if the record has been updated | ||