DWStaging
 dbo.POSITION_REQUISITION_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.POSITION_REQUISITION_A
  Properties
Property Value
Name POSITION_REQUISITION_A
Schema dbo
Row Count 1432
Data Size 152 KB
Index Size 56 KB
Create Date 11/5/2012 9:54 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
 
ANTICIPATED_HIRE_DATE
varchar(8)
True
False
False
 
CLOSING_DATE
varchar(8)
True
False
False
 
FIRSTNAME
varchar(15)
True
False
False
 
FISCAL_YEAR
varchar(6)
True
False
False
 
HIRE_DATE
varchar(8)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INTERVIEWED_NUMBER
int(10, 0)
True
False
False
 
ISN_POSITION_REQUISITION_A
int(10, 0)
False
False
False
 
LASTNAME
varchar(50)
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
 
OPERATING_TITLE
varchar(50)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
PERSON_ID_METHOD_CODE
varchar(2)
True
False
False
 
POSITION_CODE
varchar(8)
True
False
False
 
REQUISITION_HOURLY_RATE
numeric(17, 4)
True
False
False
 
REQUISITION_INTERNAL
varchar(1)
True
False
False
 
REQUISITION_MAX_PAY_RANGE
numeric(17, 2)
True
False
False
 
REQUISITION_MID_PAY_RANGE
numeric(17, 2)
True
False
False
 
REQUISITION_MIN_PAY_RANGE
numeric(17, 2)
True
False
False
 
REQUISITION_SALARY
numeric(17, 2)
True
False
False
 
REQUISITION_SEQNO
int(10, 0)
True
False
False
 
REVIEW_DATE
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SSN
varchar(9)
True
False
False
 
START_DATE
varchar(8)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_POSITION_REQUISITION_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.POSITION_REQUISITION_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.POSITION_REQUISITION_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[POSITION_REQUISITION_A] Script Date: 03/09/2017 16:45:51 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[POSITION_REQUISITION_A](
    [ISN_POSITION_REQUISITION_A] [int] NOT 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,
    [FISCAL_YEAR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUISITION_SEQNO] [int] NULL,
    [POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INTERVIEWED_NUMBER] [int] NULL,
    [REVIEW_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLOSING_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ANTICIPATED_HIRE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PERSON_ID] [int] NULL,
    [PERSON_ID_METHOD_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LASTNAME] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIRSTNAME] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HIRE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUISITION_INTERNAL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUISITION_MIN_PAY_RANGE] [numeric](17, 2) NULL,
    [REQUISITION_MAX_PAY_RANGE] [numeric](17, 2) NULL,
    [REQUISITION_MID_PAY_RANGE] [numeric](17, 2) NULL,
    [REQUISITION_HOURLY_RATE] [numeric](17, 4) NULL,
    [REQUISITION_SALARY] [numeric](17, 2) NULL,
    [OPERATING_TITLE] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ANTICIPATED_HIRE_DATE CLOSING_DATE FIRSTNAME FISCAL_YEAR HIRE_DATE HOLD ISN_POSITION_REQUISITION_A LASTNAME MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID OPERATING_TITLE PERSON_ID_METHOD_CODE POSITION_CODE REQUISITION_HOURLY_RATE REQUISITION_INTERNAL REQUISITION_MAX_PAY_RANGE REQUISITION_MID_PAY_RANGE REQUISITION_MIN_PAY_RANGE REQUISITION_SALARY REQUISITION_SEQNO REVIEW_DATE RowUpdatedOn SSN START_DATE
20020225 PEA001N1 1005589 MCONSIDI 2002 1006531 351 20020225 PEA001N1 1006531 MCONSIDI 4211 N 71526.00 57594.50 43663.00 43663.00 114 2017-02-06T11:22:03.462-05:00 20020130
20050301 PEA001N1 1143006 E026540 2005 1143008 1097 CPI5OPRF 11.6100 N 859 2017-02-06T11:22:03.54-05:00 20050208
20030609 PEA001N1 1618476 E005940 20030627 2003 1618477 684 1609 N 31300.00 31300.00 421 2017-02-06T11:22:03.493-05:00 20030606
20010904 PEA001N1 1012016 MCONSIDI 20011105 2002 00000000 1152276 293 20020322 PEA001N1 1152276 CHAMBERT AA1006 N 53669.00 44034.50 34400.00 34400.00 55 2017-02-06T11:22:03.446-05:00 20010824
20030214 PEA001N1 0917569 GRINDLEC 2003 917570 598 5406 N 21300.00 21300.00 339 2017-02-06T11:22:03.493-05:00 20030206
20030923 PEA001N1 1720093 E005940 20031003 2004 1720093 767 CPI1ZE03 9.4100 N 9.41 500 2017-02-06T11:22:03.493-05:00 20030919
20040714 PEA001N1 1426175 E011236 20040723 2005 00000000 1426176 926 REG2ZE02 9.4100 N 668 2017-02-06T11:22:03.508-05:00 20040709
20020215 PEA001N1 1557239 MCONSIDI 2002 1557532 349 20020215 PEA001N1 1557532 MCONSIDI 1609 N 31300.00 31300.00 112 2017-02-06T11:22:03.462-05:00 20020214
20020401 PEA001N1 1300254 MCONSIDI 2002 1301080 371 20020401 PEA001N1 1301080 MCONSIDI CUS2OPSM 19200.0000 N 150000.00 84600.00 19200.00 132 2017-02-06T11:22:03.462-05:00 20020328
20010702 PEA001N1 1036209 MCONSIDI 2001 1040042 233 20010702 PEA001N1 1040041 MCONSIDI AA6017 N 53669.00 44034.50 34400.00 34400.00 173 2017-02-06T11:22:03.446-05:00 20010627
Powered by BI Documenter