DWStaging
 dbo.IT_FA_AUTHORIZATION_LOG_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.IT_FA_AUTHORIZATION_LOG_A
  Properties
Property Value
Name IT_FA_AUTHORIZATION_LOG_A
Schema dbo
Row Count 5111763
Data Size 348536 KB
Index Size 76200 KB
Create Date 11/7/2012 11:53 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
FA_BOOKSTORE_AUTH
varchar(1)
True
False
False
 
FA_CURRENT_TRM_NON_TUITION_AUTH
varchar(1)
True
False
False
 
FA_PRIOR_FUTURE_TRM_AUTH
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_IT_FA_AUTHORIZATION_LOG_A
int(10, 0)
False
False
False
 
LOG_ACTION
varchar(1)
True
False
False
 
LOG_DATE
varchar(8)
True
False
False
 
LOG_PGM
varchar(8)
True
False
False
 
LOG_TIME
varchar(7)
True
False
False
 
LOG_USER
varchar(8)
True
False
False
 
RECORD_TYPE
varchar(2)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STUDENT_BILLING_SELECTION
varchar(1)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_IT_FA_AUTHORIZATION_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.IT_FA_AUTHORIZATION_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.IT_FA_AUTHORIZATION_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[IT_FA_AUTHORIZATION_LOG_A] Script Date: 03/09/2017 16:45:39 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[IT_FA_AUTHORIZATION_LOG_A](
    [ISN_IT_FA_AUTHORIZATION_LOG_A] [int] NOT NULL,
    [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_CURRENT_TRM_NON_TUITION_AUTH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_PRIOR_FUTURE_TRM_AUTH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_BOOKSTORE_AUTH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_BILLING_SELECTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECORD_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
FA_BOOKSTORE_AUTH FA_CURRENT_TRM_NON_TUITION_AUTH FA_PRIOR_FUTURE_TRM_AUTH ISN_IT_FA_AUTHORIZATION_LOG_A LOG_ACTION LOG_DATE LOG_PGM LOG_TIME LOG_USER RECORD_TYPE RowUpdatedOn STUDENT_BILLING_SELECTION STUDENT_ID
4208476 U 20160802 STA008B1 0812592 OPER2 FA 2017-02-06T09:54:26.93-05:00 E B09946849
Y Y Y 3786432 U 20110902 STA008B1 1355093 OPER2 FA 2017-02-06T09:54:07.898-05:00 E S11702222
721295 A 20110603 FI315FX1 1225401 OPER2 FA 2017-02-06T09:51:33.316-05:00 J11738150
1552008 U 20110603 STA008B1 1413397 E002346 FA 2017-02-06T09:52:15.702-05:00 A07546054
513080 A 20110603 FI315FX1 1224038 OPER2 ST 2017-02-06T09:51:23.208-05:00 G10411981
2793814 U 20110603 STA008B2 1425382 E002346 ST 2017-02-06T09:53:20.271-05:00 E M07551674
Y Y Y 3924272 A 20121007 STA010N1 2047066 WEB5 ST 2017-02-06T09:54:14.2-05:00 E S14282974
1163988 A 20110603 FI315FX1 1228479 OPER2 ST 2017-02-06T09:51:54.876-05:00 P10065142
Y Y Y 3425722 U 20110902 STA008B1 1351526 OPER2 FA 2017-02-06T09:53:51.752-05:00 E J09540568
2984160 U 20110603 STA008B2 1427250 E002346 ST 2017-02-06T09:53:30.66-05:00 E S09194663
Powered by BI Documenter