DWStaging
 dbo.ST_FACTS_COMBINED_A (Table)
Home  Diagrams  Documents  Images  DWStaging  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  DWStaging   Tables   dbo.ST_FACTS_COMBINED_A
  Properties
Property Value
Name ST_FACTS_COMBINED_A
Schema dbo
Row Count 1845
Data Size 344 KB
Index Size 64 KB
Create Date 8/15/2012 1:36 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ADD_DATE
varchar(8)
True
False
False
 
ADD_PGM
varchar(8)
True
False
False
 
ADD_TIME
varchar(7)
True
False
False
 
ADD_USER_ID
varchar(8)
True
False
False
 
ADMISSIONS_FLAG
varchar(1)
True
False
False
 
ADVISING_AUDIT_SUPPORT_FLAG
varchar(1)
True
False
False
 
CAMPUS_CODE
varchar(4)
True
False
False
 
CIP_CODE
varchar(6)
True
False
False
 
CIP_CODE_2010
varchar(6)
True
False
False
 
CIP_CODE_2010_TRACK
varchar(2)
True
False
False
 
COLLEGE_TITLE
varchar(60)
True
False
False
 
DEGREE_CONTACT_EMAIL
varchar(45)
True
False
False
 
DEGREE_PGM_LEVEL
varchar(5)
True
False
False
 
DEGREE_PROGRAM_URL
varchar(100)
True
False
False
 
DISTANCE_LEARNING_FLAG
varchar(1)
True
False
False
 
EFFECTIVE_DATE
varchar(6)
True
False
False
 
EXPIRATION_DATE
varchar(6)
True
False
False
 
FICE_CODE
varchar(7)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_ST_FACTS_COMBINED_A
int(10, 0)
False
False
False
 
LIMITED_ACCESS_PGM_FLAG
varchar(1)
True
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_PGM
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
True
False
False
 
MORE_INFO_FLAG
varchar(1)
True
False
False
 
PGM_CODE_LOCAL_AUDIT
varchar(10)
True
False
False
 
PROGRAM_TITLE
varchar(65)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SEQ_NO
int(10, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_FACTS_COMBINED_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_FACTS_COMBINED_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_FACTS_COMBINED_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_FACTS_COMBINED_A] Script Date: 03/09/2017 16:46:08 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_FACTS_COMBINED_A](
    [ISN_ST_FACTS_COMBINED_A] [int] NOT NULL,
    [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [FICE_CODE] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAMPUS_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEQ_NO] [int] NULL,
    [PGM_CODE_LOCAL_AUDIT] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROGRAM_TITLE] [varchar](65) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COLLEGE_TITLE] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CIP_CODE] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFFECTIVE_DATE] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXPIRATION_DATE] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEGREE_PGM_LEVEL] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LIMITED_ACCESS_PGM_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADVISING_AUDIT_SUPPORT_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MORE_INFO_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CIP_CODE_2010] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CIP_CODE_2010_TRACK] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEGREE_CONTACT_EMAIL] [varchar](45) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISTANCE_LEARNING_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADMISSIONS_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEGREE_PROGRAM_URL] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ADMISSIONS_FLAG ADVISING_AUDIT_SUPPORT_FLAG CAMPUS_CODE CIP_CODE CIP_CODE_2010 CIP_CODE_2010_TRACK COLLEGE_TITLE DEGREE_CONTACT_EMAIL DEGREE_PGM_LEVEL DEGREE_PROGRAM_URL DISTANCE_LEARNING_FLAG EFFECTIVE_DATE EXPIRATION_DATE FICE_CODE HOLD ISN_ST_FACTS_COMBINED_A LIMITED_ACCESS_PGM_FLAG MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MORE_INFO_FLAG PGM_CODE_LOCAL_AUDIT PROGRAM_TITLE RowUpdatedOn SEQ_NO
20090720 STD060N0 1116243 E002756 Y Y 0000 430107 430107 01 PALM BEACH COMMUNITY COLLEGE VC N 200908 201008 0001512 1324508 414 Y 20110811 STD060N0 1324508 E011387 5609 VC- Corrections Probation Crossover To Cms Law Enforcement 2017-02-06T11:25:31.973-05:00 1
20150728 STD060N0 2219282 E000318 Y Y 0000 070199 520399 01 PALM BEACH STATE COLLEGE CCC N 200708 200808 0001512 2219282 1348 N 6110 TC- Accounting Technology 2017-02-06T11:25:32.066-05:00 10
20150611 STD060N0 1100225 E000318 Y N 0000 510904 510904 01 PALM BEACH STATE COLLEGE AS N 201505 999999 0001512 1100225 1160 N 2449 AS- Emergency Medical Services 2017-02-06T11:25:32.066-05:00 8
20151022 STD060N0 1239221 E000318 Y Y 0000 170506 510707 01 PALM BEACH STATE COLLEGE VC N 200108 200208 0001512 1239221 1609 N 5085 VC- Medical Transcription 2017-02-06T11:25:32.113-05:00 3
20090615 STD060N0 0841452 E011387 N N 0000 240101 142701 1 PALM BEACH COMMUNITY COLLEGE AA N 200008 999999 0001512 841452 304 N X 1000 2017-02-06T11:25:31.957-05:00 55
20150729 STD060N0 1616071 E003976 Y Y 0000 430107 430107 01 PALM BEACH STATE COLLEGE VC N 200805 200808 0001512 1616071 1504 N 5600 VC- Law Enforcement Officer 2017-02-06T11:25:32.113-05:00 25
20100820 STD060N0 1537007 E003976 Y Y 0000 170406 511502 01 PALM BEACH STATE COLLEGE AAS N 201008 201205 0001512 1509484 89 N 20140806 STD060N0 1509484 E011387 A378 AAS- Human Services 2017-02-06T11:25:31.941-05:00 2
20151022 STD060N0 1451055 E000318 Y Y 0000 170506 510707 01 PALM BEACH STATE COLLEGE ATD N 200608 200708 0001512 1451055 1737 N B526 ATD- Medical Coder/Biller 2017-02-06T11:25:32.113-05:00 9
20090615 STD060N0 0840184 E011387 2 Y 0000 170506 510707 01 PALM BEACH COMMUNITY COLLEGE AS N 200908 201008 0001512 934355 196 Y 20100630 STD060N0 0934355 E011387 U 2529 AS- Health Information Management 2017-02-06T11:25:31.957-05:00 1
20150727 STD060N0 1625246 E000318 Y N 0000 513501 513501 01 PALM BEACH STATE COLLEGE VC N 201308 201408 0001512 1625246 1320 Y 5232 VC- Massage Therapy 2017-02-06T11:25:32.066-05:00 9
Powered by BI Documenter