DWStaging
 dbo.COA_ORG_UNIT_FILE (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.COA_ORG_UNIT_FILE
  Properties
Property Value
Name COA_ORG_UNIT_FILE
Schema dbo
Row Count 2000833
Data Size 299976 KB
Index Size 29864 KB
Create Date 10/24/2012 1:57 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACCT_SIGN
varchar(1)
True
False
False
 
ACCT_TYPE
varchar(2)
True
False
False
 
ACTIVE_IND
varchar(1)
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
 
BANK_CODE
varchar(4)
True
False
False
 
BATCH_FISCAL_YR
varchar(4)
True
False
False
 
BDMG_NOTES_IND
varchar(1)
True
False
False
 
BUDGET_MANAGER
varchar(9)
True
False
False
 
CFDA_NO
varchar(15)
True
False
False
 
COA_BUDGET_POOL_NO
varchar(9)
True
False
False
 
COA_BUDGETED_ACCT_IND
varchar(1)
True
False
False
 
COA_IND
varchar(1)
True
False
False
 
CONTROL_ACCT_NO
varchar(25)
True
False
False
 
DESCRIPTION
varchar(50)
True
False
False
 
DISTRIBUTION
varchar(4)
True
False
False
 
END_DATE
varchar(8)
True
False
False
 
EXCHANGE_IND
varchar(1)
True
False
False
 
EXCLUDE_WITHHOLD_IND
varchar(1)
True
False
False
 
EXTENDED_PAYMENT
varchar(1)
True
False
False
 
FISCAL_MANAGER
varchar(9)
True
False
False
 
FISCAL_YEAR
varchar(4)
True
False
False
 
FR_CLASS
varchar(2)
True
False
False
 
FUND_AVAILABILITY
varchar(1)
True
False
False
 
FUND_BAL_OFFSET_GLC
varchar(9)
True
False
False
 
GL_ACCT_NO
varchar(25)
True
False
False
 
GL_CODE
varchar(9)
True
False
False
 
GL_CODE_SHORT_DESC
varchar(12)
True
False
False
 
GL_IND
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_COA_ORG_UNIT_FILE
int(10, 0)
False
False
False
 
LAST_ENC_COMMIT_DATE
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
 
MATCHING_FUND_IND
varchar(1)
True
False
False
 
MULTI_YEAR_ACCT_END_DATE
varchar(8)
True
False
False
 
MULTI_YEAR_ACCT_ST_DATE
varchar(8)
True
False
False
 
NAME
varchar(30)
True
False
False
 
NOTES_IND
varchar(1)
True
False
False
 
OEF_442
varchar(1)
True
False
False
 
OLD_GL_CODE
int(10, 0)
True
False
False
 
ORG_IND
varchar(1)
True
False
False
 
ORG_UNIT
varchar(16)
True
False
False
 
ORIG_ACCT_NO
varchar(38)
True
False
False
 
PRINCIPAL_ADMIN
varchar(9)
True
False
False
 
PROJECT_CONTRACT_NO
varchar(10)
True
False
False
 
PROJECT_NO
int(10, 0)
True
False
False
 
REPORT_POS_1
varchar(7)
True
False
False
 
REPORT_POS_2
varchar(7)
True
False
False
 
REPORT_POS_3
varchar(7)
True
False
False
 
REPORT_POS_4
varchar(7)
True
False
False
 
REPORT_POS_5
varchar(7)
True
False
False
 
REPORT_POS_6
varchar(7)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SPD_IND
varchar(1)
True
False
False
 
START_DATE
varchar(8)
True
False
False
 
STATUS
varchar(1)
True
False
False
 
SUBS_ID_CODE
varchar(1)
True
False
False
 
USER_GROUP_ID
varchar(16)
True
False
False
 
YEAR_END_ROLLOVER
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_COA_ORG_UNIT_FILE
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.COA_ORG_UNIT_FILE depends on)
Name Type
View
View
  Child Dependencies (objects that depend on dbo.COA_ORG_UNIT_FILE)
Name Type
VIEW
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[COA_ORG_UNIT_FILE] Script Date: 03/09/2017 16:45:09 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[COA_ORG_UNIT_FILE](
    [ISN_COA_ORG_UNIT_FILE] [int] NOT NULL,
    [ORG_UNIT] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTROL_ACCT_NO] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DESCRIPTION] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORIG_ACCT_NO] [varchar](38) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRINCIPAL_ADMIN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROJECT_NO] [int] NULL,
    [PROJECT_CONTRACT_NO] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUDGET_MANAGER] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CFDA_NO] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FISCAL_MANAGER] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BANK_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [YEAR_END_ROLLOVER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MULTI_YEAR_ACCT_ST_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MULTI_YEAR_ACCT_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OEF_442] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MATCHING_FUND_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COA_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_CODE] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCT_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCT_SIGN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUBS_ID_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OLD_GL_CODE] [int] NULL,
    [REPORT_POS_1] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REPORT_POS_2] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REPORT_POS_3] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REPORT_POS_4] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REPORT_POS_5] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REPORT_POS_6] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_ACCT_NO] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COA_BUDGET_POOL_NO] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COA_BUDGETED_ACCT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FUND_AVAILABILITY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BATCH_FISCAL_YR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISTRIBUTION] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_CODE_SHORT_DESC] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LAST_ENC_COMMIT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FUND_BAL_OFFSET_GLC] [varchar](9) 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,
    [HOLD] [int] NULL,
    [USER_GROUP_ID] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FR_CLASS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXCHANGE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOTES_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BDMG_NOTES_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXTENDED_PAYMENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPD_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXCLUDE_WITHHOLD_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACCT_SIGN ACCT_TYPE ACTIVE_IND ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BANK_CODE BATCH_FISCAL_YR BDMG_NOTES_IND BUDGET_MANAGER CFDA_NO COA_BUDGET_POOL_NO COA_BUDGETED_ACCT_IND COA_IND CONTROL_ACCT_NO DESCRIPTION DISTRIBUTION END_DATE EXCHANGE_IND EXCLUDE_WITHHOLD_IND EXTENDED_PAYMENT FISCAL_MANAGER FISCAL_YEAR FR_CLASS FUND_AVAILABILITY FUND_BAL_OFFSET_GLC GL_ACCT_NO GL_CODE GL_CODE_SHORT_DESC GL_IND HOLD ISN_COA_ORG_UNIT_FILE LAST_ENC_COMMIT_DATE MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MATCHING_FUND_IND MULTI_YEAR_ACCT_END_DATE MULTI_YEAR_ACCT_ST_DATE NAME NOTES_IND OEF_442 ORG_IND ORG_UNIT ORIG_ACCT_NO PRINCIPAL_ADMIN PROJECT_CONTRACT_NO REPORT_POS_1 REPORT_POS_2 REPORT_POS_3 REPORT_POS_4 REPORT_POS_5 REPORT_POS_6 RowUpdatedOn SPD_IND START_DATE STATUS SUBS_ID_CODE USER_GROUP_ID YEAR_END_ROLLOVER
+ 6 A 20170203 FIG120N2 1015009 ZCTBK 60000 Y Y 20170831 2018 151020005102152062002 1015009 1454820 2017-02-06T09:45:54.498-05:00 20170701
+ 6 A 20160329 FIG120N2 1655122 E005840 Y Y 20170630 2017 58000001 0062504 1801383 598430 20160630 FIG120N2 1801383 E014684 2017-02-06T09:44:03.332-05:00 20160701
+ 6 A 20170203 FIG120N2 1008073 ZCTBK 60000 Y Y 20180630 2018 112301002301014062501 1008073 1309699 2017-02-06T09:45:35.903-05:00 20170701
+ 6 A 20170203 FIG120N2 1017506 ZCTBK Y Y 20180630 2018 163103006313009666507 1017506 1509864 2017-02-06T09:46:01.549-05:00 20170701
- 4 A 20160329 FIG120N2 1732536 E005840 Y Y 20170630 2017 720100477090109040160SUMM 1830270 849510 20160630 FIG120N2 1830270 E014684 2017-02-06T09:44:36.279-05:00 20160701
+ 1 A 20170203 FIG120N2 1027357 ZCTBK N Y 20180630 2018 582150002152099010200 1027357 1743689 2017-02-06T09:46:32.687-05:00 20170701
- 4 A 20160329 FIG120N2 1730035 E005840 Y Y 20170630 2017 71210002 9040400ONLN 1730035 828010 2017-02-06T09:44:33.611-05:00 20160701
+ 1 A 20070910 FIG120N2 1638113 E005840 N Y 20060630 2006 682260008220039010108 1638113 762531 2017-02-06T09:44:25.062-05:00 20050701
+ 5 A 20160329 FIG120N2 1612544 E005840 N Y 20170630 2017 141010004101004059505 987347 20160906 FIG125N1 1131578 E001353 2017-02-06T09:44:54.188-05:00 20160701
- 2 A 20160329 FIG120N2 1637151 E005840 N Y 20170630 2017 251000002000159421216 1028732 20160811 FIG125N1 0901236 E030656 2017-02-06T09:44:59.383-05:00 20160701
Powered by BI Documenter