Summary Table
Categories |
Total Count |
PII |
0 |
URL |
0 |
DNS |
0 |
EKL |
0 |
IP |
0 |
PORT |
0 |
VsID |
0 |
CF |
0 |
AI |
0 |
VPD |
0 |
PL |
0 |
Other |
0 |
File Content
?--This is a raw table that already exists in raw; commenting out for now to fix compile errors
CREATE TABLE dbo.FBCSUBScores
(
--authoritative source: A06.CDWWork.FBCS.UB92Scores
--fields
FBCSUBScoreID bigint IDENTITY(1,1) NOT NULL,
FBCSUBClaimID bigint, --EPRS assigned (FK), relates to FBCSUBClaims
StationID smallint, --EPRS assigned (FK), relates to stationid, NOT station__no
CDWUBScoreNumber bigint, --id
CDWRowNumber bigint, --rownumber
CDWLineNumber smallint, --lineid
DatabaseNumber varchar(10), --databaseid
DateScoreReceived datetime2(7), --scorercvddtstamp
DateFeed datetime2(7), --feeddate
--TODO: need to find out if this IsPay or CanPaid or WasPaid, but should be only a bi-state bit (1 or 0)
Pay bit NOT NULL, --pay (turn all empty string to 0, Y = 1, N = 0)
--primary key
CONSTRAINT PK_FBCSUBScores PRIMARY KEY CLUSTERED
(
FBCSUBScoreID ASC
)
)
ON CoreData
--when using clustered columnstore index, can't set data compression to PAGE
WITH (DATA_COMPRESSION = PAGE)
GO
/*
--zraw._fbcsub92score
[station__no] VARCHAR(30) NOT NULL, --trade this in along with the ub92id to the FBCSUBClaims table to get the FBCSClaimID
ub92id BIGINT, --FBCSUBClaimID
id BIGINT, --CDWUBScoreNumber
scorercvddtstamp DATETIME2(7), --DateScoreReceived
rownumber BIGINT, --CDWRowNumber
feeddate DATETIME2(7), --DateFeed
databaseid VARCHAR(10), --DatabaseNumber
stationid VARCHAR(10), --StationID
lineid BIGINT, --CDWLineNumber
pay VARCHAR(5), --TODO: call Pay for now
score BIGINT,
scoredate DATETIME2(7),
reasoncode VARCHAR(50),
reasondescription VARCHAR(8000),
ub92lines_id BIGINT,
[thread__id] NUMERIC(18, 0) NOT NULL,
--BatchLogID should always be the last of the authoritative source fields listed
--in the data gathered by extractors, it should be the first of the EPRS-specific fields
BatchLogID BIGINT,
--EPRS table specific: Any fields beyond this point are EPRS specific fields/FKs
*/
--foreign keys
--indexes
--constraints
--Metadata descriptions for each field