Table - dbo.ST_ACDMC_HIST_ARCH_A_POST_SECONDARY

Properties

Property	Value
Name	ST_ACDMC_HIST_ARCH_A_POST_SECONDARY_AWARD
Schema	dbo
Row Count	0
Data Size	0 KB
Index Size	0 KB
Create Date	8/15/2012 12:45 PM
Description

Columns

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
cnxarraycolumn	smallint(5, 0)	False	False	False
ISN_ST_ACDMC_HIST_ARCH_A	int(10, 0)	False	False	False
POST_SECONDARY_AWARD_COUNT	smallint(5, 0)	False	False	False
PS_AWD_CRED_HRS	numeric(17, 2)	True	False	False
PS_AWD_DT	varchar(8)	True	False	False
PS_AWD_GPA	numeric(17, 2)	True	False	False
PS_AWD_LVL	varchar(3)	True	False	False
PS_AWD_TTL	varchar(30)	True	False	False
PS_AWD_TY	varchar(4)	True	False	False
PS_HNRS_CD	varchar(1)	True	False	False
RowUpdatedOn	datetime2(27, 7)	False	False	False

Triggers

Name

Insert

Update

Delete

Instead

Indexes

Name	Clustered	Columns
U2V0SJ9A1KED5N	False	ISN_ST_ACDMC_HIST_ARCH_A, cnxarraycolumn

Foreign Key Constraints

Name

Columns

Referenced Table

Referenced Columns

Checked

Check Constraints

Name

Text

Checked

Parent Dependencies (objects that dbo.ST_ACDMC_HIST_ARCH_A_POST_SECONDARY_AWARD depends on)

Name

Type

Child Dependencies (objects that depend on dbo.ST_ACDMC_HIST_ARCH_A_POST_SECONDARY_AWARD)

Name

Type

Extended Properties

Object

Property

Value

Annotations

Object

Property

Value

DDL

/****** Object: Table [dbo].[ST_ACDMC_HIST_ARCH_A_POST_SECONDARY_AWARD] Script Date: 03/09/2017 16:45:56 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_ACDMC_HIST_ARCH_A_POST_SECONDARY_AWARD](
    [ISN_ST_ACDMC_HIST_ARCH_A] [int] NOT NULL,
    [POST_SECONDARY_AWARD_COUNT] [smallint] NOT NULL,
    [PS_AWD_TY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PS_AWD_TTL] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PS_AWD_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PS_AWD_LVL] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PS_AWD_CRED_HRS] [numeric](17, 2) NULL,
    [PS_AWD_GPA] [numeric](17, 2) NULL,
    [PS_HNRS_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [cnxarraycolumn] [smallint] NOT NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)