BBSDnloadInfo

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

AgencyID

int

4

null

Agency identifier - Reference to the agency

UserName

varchar

50

√

null

BBS username - Username for clearinghouse access

Passwd

varchar

20

√

null

BBS password - Password for clearinghouse authentication

DnloadLocation

varchar

275

√

null

Download location - File path for downloading files from clearinghouse

UploadLocation

varchar

275

√

null

Upload location - File path for uploading files to clearinghouse

MainBBSnum

varchar

15

√

null

Primary BBS number - Main phone number for BBS connection

AltBBSnum

varchar

15

√

null

Alternative BBS number - Backup phone number for BBS connection

Relationships

Close relationships within degrees of separation

One

View Definition

-- select * from BBSDnloadInfo
CREATE                                                     VIEW [dbo].[BBSDnloadInfo]
AS

SELECT          distinct a.AgencyID AS AgencyID, LTRIM(ab.UserName) 
                          AS UserName, RTRIM(ab.Passwd) AS Passwd, 
                          RTRIM(c.DnloadPath) + a.Category AS DnloadLocation, 
                          RTRIM(c.UploadPath) + a.Category AS UploadLocation, 
                          RTRIM(c.Modem) AS MainBBSnum, 
                          RTRIM(c.Modem2) AS AltBBSnum,
			  a.Category,Version = 'Importing RA for V2'
FROM             ics2.dbo.AgencyBBS ab INNER JOIN
                          ics2.dbo.Agency  a ON ab.fkAgencyid = a.AgencyID INNER JOIN
                          ics2.dbo.ClearingHouse c ON 
                          ab.fkClearinghouseID = c.ClearingHouseID
WHERE         ((a.Status = 'A') or (a.tobill in (1,2))) 
and category in ('Fam44',
'Fam64',
'VOA'
)
--and a.agencyid in (49)

-- Union
-- 
-- SELECT          a.AgencyID AS AgencyID, LTRIM(ab.UserName) 
--                           AS UserName, RTRIM(ab.Passwd) AS Passwd, 
--                           RTRIM(c.DnloadPath) + a.Category AS DnloadLocation, 
--                           RTRIM(c.UploadPath) + a.Category AS UploadLocation,                  
--                           RTRIM(c.Modem) AS MainBBSnum, 
--                           RTRIM(c.Modem2) AS AltBBSnum,
-- 			  a.Category as Category,Version = 'Importing RA'
-- FROM             ics.dbo.AgencyBBS ab INNER JOIN
--                           ics.dbo.Agency a ON ab.fkAgencyid = a.AgencyID INNER JOIN
--                           ics.dbo.ClearingHouse c ON 
--                           ab.fkClearinghouseID = c.ClearingHouseID
-- WHERE         ((a.Status = 'A') or (a.tobill = 1))  --and agencyid > 333

Description

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views