|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | APPROVAL_APPROVER |
| Schema | dbo |
| Row Count | 882533 |
| Data Size | 72080 KB |
| Index Size | 13184 KB |
| Create Date | 10/24/2012 9:40 AM |
| 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 |
|||
|
|
APPROVAL_ACTION_REQUIRED |
varchar(1) |
True |
False |
False |
|||
|
|
APPROVAL_DATE_FINAL |
varchar(8) |
True |
False |
False |
|||
|
|
APPROVAL_DATE_FORWARD |
varchar(8) |
True |
False |
False |
|||
|
|
APPROVAL_DATE_SUBMITTED |
varchar(8) |
True |
False |
False |
|||
|
|
APPROVAL_PERSON_ID |
varchar(8) |
True |
False |
False |
|||
|
|
APPROVAL_POSITION |
varchar(8) |
True |
False |
False |
|||
|
|
APPROVAL_SEQ |
int(10, 0) |
True |
False |
False |
|||
|
|
APPROVAL_STATUS |
varchar(2) |
True |
False |
False |
|||
|
|
APPROVAL_STATUS_DATE |
varchar(8) |
True |
False |
False |
|||
|
|
APPROVAL_TYPE |
varchar(1) |
True |
False |
False |
|||
|
|
DOCUMENT_KEY |
varchar(25) |
True |
False |
False |
|||
|
|
HOLD |
int(10, 0) |
True |
False |
False |
|||
|
|
ISN_APPROVAL_APPROVER |
int(10, 0) |
False |
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 |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_APPROVAL_APPROVER |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.APPROVAL_APPROVER depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.APPROVAL_APPROVER)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[APPROVAL_APPROVER] Script Date: 03/09/2017 16:44:54 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[APPROVAL_APPROVER]( [ISN_APPROVAL_APPROVER] [int] NOT NULL, [DOCUMENT_KEY] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [APPROVAL_SEQ] [int] NULL, [APPROVAL_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [APPROVAL_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [APPROVAL_STATUS_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [APPROVAL_PERSON_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [APPROVAL_POSITION] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [APPROVAL_DATE_SUBMITTED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [APPROVAL_DATE_FINAL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [APPROVAL_DATE_FORWARD] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [APPROVAL_ACTION_REQUIRED] [varchar](1) 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, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| ADD_DATE | ADD_PGM | ADD_TIME | ADD_USER_ID | APPROVAL_ACTION_REQUIRED | APPROVAL_DATE_FINAL | APPROVAL_DATE_FORWARD | APPROVAL_DATE_SUBMITTED | APPROVAL_PERSON_ID | APPROVAL_POSITION | APPROVAL_SEQ | APPROVAL_STATUS | APPROVAL_STATUS_DATE | APPROVAL_TYPE | DOCUMENT_KEY | ISN_APPROVAL_APPROVER | MAINT_DATE | MAINT_PGM | MAINT_TIME | MAINT_USER_ID | RowUpdatedOn |
| 20130830 | 20130829 | E000770 | 2 | AP | 20130830 | A | FIAPC2014A001474 | 675127 | 2017-02-06T10:25:31.111-05:00 | |||||||||||
| 20160303 | 20160303 | E088602 | 1 | AP | 20160303 | A | FIPDN201600004020 | 827558 | 2017-02-06T10:25:42.14-05:00 | |||||||||||
| 20080807 | 20080807 | BTRESTR | 1 | AP | 20080807 | A | FINDS2009000721 | 359284 | 2017-02-06T10:25:08.74-05:00 | |||||||||||
| 20110713 | 20110713 | TRAVEL1 | 1 | AP | 20110713 | A | FINDS2012000296 | 535150 | 2017-02-06T10:25:21.298-05:00 | |||||||||||
| 20020214 | 20020214 | E001305 | 1 | AP | 20020214 | A | FIPDN200200040725 | 116378 | 2017-02-06T10:24:51.502-05:00 | |||||||||||
| 20090318 | 20090318 | E052808 | 1 | AP | 20090318 | A | FIPDN200900004899 | 393456 | 2017-02-06T10:25:11.158-05:00 | |||||||||||
| 20031215 | 20031215 | E001859 | 3 | AP | 20031215 | A | FIPDN200400004180 | 189884 | 2017-02-06T10:24:56.556-05:00 | |||||||||||
| 20090706 | 20090706 | E001353 | 3 | AP | 20090706 | A | FIPDN201000000097 | 410759 | 2017-02-06T10:25:12.328-05:00 | |||||||||||
| 20160627 | 20160601 | E091415 | 1 | AP | 20160627 | A | FIAPC2016A008565 | 848326 | 2017-02-06T10:25:43.513-05:00 | |||||||||||
| 20000725 | 20000724 | E001353 | 2 | AP | 20000725 | A | FIPDN200100026386 | 53899 | 2017-02-06T10:24:46.978-05:00 |
| Powered by BI Documenter |
