The Resp Org List table contains information on the:
- Resp Org code
- Resp Org name
- Trouble Referral number
- Status and Effective Date
Table 118 RHDB_RESPORG
|
RHDB_RESPORG |
||
|
Field |
Characters |
Description |
|
Resporg |
varchar2(5) |
The Resp Org codes. The first two alpha characters of the code identify the CCS Network. The next two characters identify the company within that CCS Network. The final numeric digit identifies the organization. For ITCs and OCs, the first four alpha characters are company codes assigned by SMTs software vendor. |
|
DaOrg |
varchar2(4) |
The code for work center to be contacted by the directory assistance provider for listing corrections to the Dial# controlled by the associated Resp Org. An entry of ‘NO’ signifies that directory assistance information for this Resp Org’s Dial# is not to be sent to the national directory assistance provider. |
|
DaBill |
varchar2(3) |
Three digit code for the Entity to be billed for this Resp Org’s Dial# Information in the national directory assistance SMS/800 TFN Registry. |
|
TroubleReferralNbr |
varchar2(12) |
This column lists the contact number to help resolve problems reported against a Dial#. This field is only populated if the Resp Org listed in an owner of a Customer Record and requires a contact number. |
|
ResporgName |
varchar2(30) |
Entered by the Help Desk, the name of the Resp Org company that is associated with the controlling Resp Org for the Dial#(s) being queried. A blank is returned if the company information has not been furnished to the Help Desk. |
|
EffectiveDate |
Date |
The Effective Date for the Action of the Resp Org. The date is either a PENDING DELETION or PENDING ADDITION. |
|
StatusIndicator |
varchar2(1) |
Possible status values are:
|
|
ExtractDate |
Date |
The date when the record was sent to the RHDB database. |
|
Create_LoginID |
Varchar2 (8) |
The mandatory data field that identifies the Login ID of the SMS/800 TFN Registry user that created the record. |
|
Create_Time |
Timestamp (6) |
The date and time the record was last updated in the SMS/800 TFN Registry. |
|
Update_LoginID |
Varchar2 (8) |
The mandatory data field that identifies the Login ID of the SMS/800 TFN Registry user who last updated the record. |
|
Update_Time |
Timestamp (6) |
The date and time the record was last updated in the SMS/800 TFN Registry. |
Index for RHDB_RESPORG Table
The index and fields used for the RHDB_RESPORG table are:
|
RHDB_RESPORG |
|
|
Index Name |
Fields Used |
|
rhdb_ RespOrg _idx1 |
|
|
rhdb_ RespOrg _idx2 |
|
|
rhdb_ RespOrg _idx3 |
|