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
?--ODS code
CREATE TABLE dbo.FBCSDSSBatchesmirror
(
--authoritative sources:
--A06.CDWWork.Raw36
--fields
BatchID bigint IDENTITY(1,1) NOT NULL, --EPRS assigned
FBCSUserID bigint, --EPRS assigned (FK)
DateRelease datetime2(7) NULL, --ReleaseDate
DateFinalization datetime2(7) NULL, --FinalizationDate
DateSupervisorClose datetime2(7) NULL, --SupervisorCloseDate
DateAustinPaid datetime2(7) NULL, --AustinPaidDate
DateBatchOpen datetime2(7) NULL, --BatchOpenDate
DateBatchClose datetime2(7) NULL, --BatchCloseDate
DateMirrorTime datetime2(7) NULL, --MirrorDateTime
Dateassignedprice datetime2(7) NULL, --assignedpricedate
VISNNumber varchar(30) NOT NULL, --station__no
BatchNumber bigint, --BatchNumber
BatchInternalNumber bigint, --BatchInternalNumber
FCP varchar(50) NULL, --FCP
Obligation varchar(50) NULL, --Obligation
OpenedByClerk varchar(50) NULL, --OpenedByClerk
BatchStatus varchar(50) NULL, --BatchStatus
BatchTotal numeric(28) NULL, --BatchTotal
AustinCheckNumber varchar(50) NULL, --AustinCheckNumber
FeeProgram varchar(50) NULL,
/*
[station__no] [varchar](30) NOT NULL,
[StationIFN] [varchar](50) NULL,
[BatchNumber] [bigint] NULL,
[BatchInternalNumber] [bigint] NULL,
[FCP] [varchar](50) NULL,
[Obligation] [varchar](50) NULL,
[OpenedByClerk] [varchar](50) NULL,
[BatchStatus] [varchar](50) NULL,
[BatchTotal] [numeric](28, 6) NULL,
[ReleaseDate] [datetime2](7) NULL,
[FinalizationDate] [datetime2](7) NULL,
[SupervisorCloseDate] [datetime2](7) NULL,
[AustinPaidDate] [datetime2](7) NULL,
[AustinCheckNumber] [varchar](50) NULL,
[FeeProgram] [varchar](50) NULL,
[BatchOpenDate] [datetime2](7) NULL,
[BatchCloseDate] [datetime2](7) NULL,
[MirrorDateTime] [datetime2](7) NULL,
[OpenedByUserID] [bigint] NULL,
[assignedpricedate] [datetime2](7) NULL
*/
--primary key
CONSTRAINT PK_FBCSDSSBatchesmirror PRIMARY KEY CLUSTERED
(
BatchID ASC
)
)
ON CoreData
WITH (DATA_COMPRESSION = PAGE)
GO
--foreign keys
--indexes
--constraints
--Metadata descriptions for each field
/*Commenting these out for now, because we they're incomplete, and they are also duplicates of other tables' metadata
EXECUTE sp_addextendedproperty
N'MS_Description', N'Primary Key',
N'SCHEMA', N'dbo',
N'TABLE', N'CallCenterPrograms',
N'COLUMN', N'CallCenterProgramID'
GO
EXECUTE sp_addextendedproperty
N'MS_Description', N'Name for the call center program',
N'SCHEMA', N'dbo',
N'TABLE', N'CallCenterPrograms',
N'COLUMN', N'CallCenterProgramName'
GO
*/