|
![]() |
Property | Value |
Name | ST_STDNT_CLS_LOG |
Schema | dbo |
Row Count | 60938656 |
Data Size | 20539352 KB |
Index Size | 3769400 KB |
Create Date | 3/2/2017 10:59 AM |
Description |
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
![]() |
![]() |
ACDMC_STAT_CD |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
ACDMC_STAT_CD_HS |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
ACDMC_STAT_CD_VC |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
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 |
|||
![]() |
![]() |
CAMP |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
CAMP_CNTR |
varchar(5) |
True |
False |
False |
|||
![]() |
![]() |
CLS_OPTN |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
CLS_SECT |
varchar(3) |
True |
False |
False |
|||
![]() |
![]() |
CNTRL_NUM |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
CRED_RGSTRTN_APPT_DT |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
CRED_RGSTRTN_APPT_TM |
varchar(7) |
True |
False |
False |
|||
![]() |
![]() |
CRED_TY |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
CRNT_CRS_ID |
varchar(10) |
True |
False |
False |
|||
![]() |
![]() |
CRS_ID |
varchar(10) |
True |
False |
False |
|||
![]() |
![]() |
CVRG_FLG |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
DISPLACED_HOMEMAKER |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
EARNED_HRS |
numeric(6, 2) |
True |
False |
False |
|||
![]() |
![]() |
EFF_TRM |
varchar(6) |
True |
False |
False |
|||
![]() |
![]() |
EFF_TRM_9S_COMP |
varchar(6) |
True |
False |
False |
|||
![]() |
![]() |
EMPLOYMENT_BARRIER |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
EMPLOYMENT_STATUS |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
ENF_TRM |
varchar(6) |
True |
False |
False |
|||
![]() |
![]() |
ENRLMNT_CD |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
EX_OFFENDER |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
FA_GPA |
numeric(3, 2) |
True |
False |
False |
|||
![]() |
![]() |
FA_SOAP_STATUS |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
FA_STANDARD |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
GPA |
numeric(4, 2) |
True |
False |
False |
|||
![]() |
![]() |
GPA_HRS |
numeric(5, 2) |
True |
False |
False |
|||
![]() |
![]() |
GRADE |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
GRD_DT |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
GRD_PTS |
numeric(5, 2) |
True |
False |
False |
|||
![]() |
![]() |
HNRS_FLG |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
HOLD |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
HOMELESS_RUNAWAY |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
HRS_ATT |
numeric(5, 2) |
True |
False |
False |
|||
![]() |
![]() |
HRS_ERN |
numeric(5, 2) |
True |
False |
False |
|||
![]() |
![]() |
IMMIG_STAT |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
ISN_ST_STDNT_CLS_LOG |
int(10, 0) |
False |
False |
False |
|||
![]() |
![]() |
LATE_FEE_EXMPTN |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
LOG_ACTION |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
LOG_DATE |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
LOG_DATE_9SCOMP |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
LOG_TID |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
LOG_TIME |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
LOG_TIME_9SCOMP |
varchar(7) |
True |
False |
False |
|||
![]() |
![]() |
LOG_USER |
varchar(8) |
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 |
|||
![]() |
![]() |
MIGRANT_WORKER |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
MILITARY_STATUS |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
NOT_PAID_FLG |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
NTFY_DISAB_FLG |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
OTHER_RGSTRTN_APPT_DT |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
OTHER_RGSTRTN_APPT_TM |
varchar(7) |
True |
False |
False |
|||
![]() |
![]() |
OVRD_FLG |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
PAID_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PCT_ATT_COMPL |
numeric(5, 2) |
True |
False |
False |
|||
![]() |
![]() |
PGM_CHNG_DT |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PGM_ID |
varchar(5) |
True |
False |
False |
|||
![]() |
![]() |
PRG_HRS |
numeric(6, 2) |
True |
False |
False |
|||
![]() |
![]() |
PYMT_DUE_DT_CRED |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PYMT_DUE_DT_CRED_EXT |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PYMT_DUE_DT_NCRED |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PYMT_DUE_DT_NONCRED_EXT |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
RECALC_FLG |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
REF_NUM |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
REGULAR_HRS_ATT |
numeric(6, 2) |
True |
False |
False |
|||
![]() |
![]() |
REMEDIAL_HRS_ATT |
numeric(6, 2) |
True |
False |
False |
|||
![]() |
![]() |
REPEAT_CRS_FEES_FLG |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
RES_CD |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
RFND_REASON |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
RGSTRTN_CAMP |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
RGSTRTN_MTHD |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
True |
False |
False |
|||
![]() |
![]() |
RSN_DRP |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
RULE_150 |
numeric(5, 2) |
True |
False |
False |
|||
![]() |
![]() |
SCHD_CHG_RSN |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
SCHD_PRN_FLG |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
SDB_REPORTED |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
SEQ_NUM |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
SINGLE_PARENT |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
SRCH_NAME |
varchar(25) |
True |
False |
False |
|||
![]() |
![]() |
STDNT_ID |
varchar(9) |
True |
False |
False |
|||
![]() |
![]() |
TRM_YR |
varchar(6) |
True |
False |
False |
|||
![]() |
![]() |
TRNSCTN_DT |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
TRNSCTN_TM |
varchar(7) |
True |
False |
False |
|||
![]() |
![]() |
TRNSCTN_TY |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
USER_WHO_EXT_CRED |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
USER_WHO_EXT_NONCRED |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
VOC_HRS_ATT |
numeric(6, 2) |
True |
False |
False |
|||
![]() |
![]() |
WITHDRAWAL_REASON |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WRTNG_FLG |
bit(1, 0) |
True |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
EFF_TRM, REF_NUM, LOG_DATE, STDNT_ID, NOT_PAID_FLG, TRNSCTN_TY, LOG_TIME |
|
False |
ISN_ST_STDNT_CLS_LOG |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
StoredProcedure |
|
StoredProcedure |
Name | Type |
STOREDPROCEDURE |
|
STOREDPROCEDURE |
Object | Property | Value |
Object | Property | Value |
/****** Object: Table [dbo].[ST_STDNT_CLS_LOG] Script Date: 03/09/2017 16:46:25 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ST_STDNT_CLS_LOG]( [ISN_ST_STDNT_CLS_LOG] [int] NOT NULL, [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EFF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CRS_ID] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [REF_NUM] [int] NULL, [CAMP_CNTR] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CLS_OPTN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CLS_SECT] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CNTRL_NUM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CRED_TY] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CRNT_CRS_ID] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [GRADE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [GRD_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [HNRS_FLG] [bit] NULL, [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LOG_DATE] [int] NULL, [LOG_TID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LOG_TIME] [int] NULL, [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [NOT_PAID_FLG] [bit] NULL, [OVRD_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RFND_REASON] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RGSTRTN_CAMP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RGSTRTN_MTHD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RSN_DRP] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [REPEAT_CRS_FEES_FLG] [bit] NULL, [SEQ_NUM] [int] NULL, [SRCH_NAME] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TRNSCTN_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TRNSCTN_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TRNSCTN_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WRTNG_FLG] [bit] NULL, [TRM_YR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ACDMC_STAT_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CAMP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CRED_RGSTRTN_APPT_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CRED_RGSTRTN_APPT_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CVRG_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ENRLMNT_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [HOLD] [int] NULL, [IMMIG_STAT] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LATE_FEE_EXMPTN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [NTFY_DISAB_FLG] [bit] NULL, [OTHER_RGSTRTN_APPT_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [OTHER_RGSTRTN_APPT_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PYMT_DUE_DT_CRED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PYMT_DUE_DT_CRED_EXT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PYMT_DUE_DT_NCRED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PYMT_DUE_DT_NONCRED_EXT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RECALC_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RES_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SCHD_CHG_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SCHD_PRN_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [USER_WHO_EXT_CRED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [USER_WHO_EXT_NONCRED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS 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, [LOG_DATE_9SCOMP] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LOG_TIME_9SCOMP] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ENF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EFF_TRM_9S_COMP] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ACDMC_STAT_CD_VC] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ACDMC_STAT_CD_HS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SDB_REPORTED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PGM_ID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PGM_CHNG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAID_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PRG_HRS] [numeric](6, 2) NULL, [REGULAR_HRS_ATT] [numeric](6, 2) NULL, [REMEDIAL_HRS_ATT] [numeric](6, 2) NULL, [VOC_HRS_ATT] [numeric](6, 2) NULL, [EARNED_HRS] [numeric](6, 2) NULL, [FA_GPA] [numeric](3, 2) NULL, [RULE_150] [numeric](5, 2) NULL, [FA_STANDARD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FA_SOAP_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PCT_ATT_COMPL] [numeric](5, 2) NULL, [GPA] [numeric](4, 2) NULL, [GRD_PTS] [numeric](5, 2) NULL, [HRS_ERN] [numeric](5, 2) NULL, [HRS_ATT] [numeric](5, 2) NULL, [GPA_HRS] [numeric](5, 2) NULL, [EMPLOYMENT_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SINGLE_PARENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DISPLACED_HOMEMAKER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EX_OFFENDER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [HOMELESS_RUNAWAY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EMPLOYMENT_BARRIER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MIGRANT_WORKER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WITHDRAWAL_REASON] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MILITARY_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RowUpdatedOn] [datetime2](7) NULL ) ON [PRIMARY] |
Powered by BI Documenter |