DWStaging
 dbo.POSITION_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_A
  Properties
Property Value
Name POSITION_A
Schema dbo
Row Count 7636
Data Size 1840 KB
Index Size 160 KB
Create Date 2/2/2017 1:55 PM
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
 
BENEFIT_ACTUAL_AMT
numeric(9, 2)
True
False
False
 
EEO_ACTIVITY_CODE_FEDERAL
varchar(8)
True
False
False
 
EXEMPT_NON_EXEMPT_CODE
varchar(1)
True
False
False
 
FT_PT_STATUS_CODE
varchar(1)
True
False
False
 
FULLTIME_EQUIVALENT
numeric(5, 2)
True
False
False
 
GRANT_IND
bit(1, 0)
True
False
False
 
HAZARDOUS_MATERIALS
bit(1, 0)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INACTIVITY_CODE
varchar(8)
True
False
False
 
ISN_POSITION_A
int(10, 0)
False
False
False
 
JOB_CLASS_CODE
varchar(8)
True
False
False
 
JOB_GROUP_CODE
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
 
OVERLAP_IND
bit(1, 0)
True
False
False
 
PAY_BASIS_CODE
varchar(8)
True
False
False
 
PAY_GRADE_CODE
varchar(8)
True
False
False
 
PDB_ACTIVITY_CODE
varchar(8)
True
False
False
 
POOLED_POSITION_IND
bit(1, 0)
True
False
False
 
POS_START_DATE_9C
int(10, 0)
True
False
False
 
POSITION_CODE
varchar(8)
True
False
False
 
POSITION_ESTABLISH_DATE
varchar(8)
True
False
False
 
POSITION_INACTIVITY_DATE
varchar(8)
True
False
False
 
POSITION_STATUS
varchar(1)
True
False
False
 
POSITION_STATUS_CHANGE_DATE
varchar(8)
True
False
False
 
POSITION_TITLE
varchar(30)
True
False
False
 
PROBATION_SCHEDULE
varchar(10)
True
False
False
 
REG_TEMP_IND
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SALARY_ACTUAL_AMT
numeric(9, 2)
True
False
False
 
SCHEDULE_CODE
varchar(8)
True
False
False
 
STAFFING_FORMULA
varchar(4)
True
False
False
 
SUPERVISOR_POSITION
varchar(8)
True
False
False
 
TRACK_IND
bit(1, 0)
True
False
False
 
WEEKLY_HOURS_AUTHORIZED
numeric(5, 2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_POSITION_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.POSITION_A depends on)
Name Type
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.POSITION_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[POSITION_A] Script Date: 03/09/2017 16:45:50 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[POSITION_A](
    [ISN_POSITION_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,
    [POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSITION_TITLE] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [JOB_CLASS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [JOB_GROUP_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_BASIS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSITION_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSITION_STATUS_CHANGE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXEMPT_NON_EXEMPT_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FT_PT_STATUS_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSITION_ESTABLISH_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HAZARDOUS_MATERIALS] [bit] NULL,
    [PDB_ACTIVITY_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EEO_ACTIVITY_CODE_FEDERAL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSITION_INACTIVITY_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POS_START_DATE_9C] [int] NULL,
    [INACTIVITY_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FULLTIME_EQUIVALENT] [numeric](5, 2) NULL,
    [WEEKLY_HOURS_AUTHORIZED] [numeric](5, 2) NULL,
    [STAFFING_FORMULA] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_GRADE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SALARY_ACTUAL_AMT] [numeric](9, 2) NULL,
    [BENEFIT_ACTUAL_AMT] [numeric](9, 2) NULL,
    [POOLED_POSITION_IND] [bit] NULL,
    [SCHEDULE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REG_TEMP_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRACK_IND] [bit] NULL,
    [OVERLAP_IND] [bit] NULL,
    [SUPERVISOR_POSITION] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROBATION_SCHEDULE] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRANT_IND] [bit] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID EEO_ACTIVITY_CODE_FEDERAL EXEMPT_NON_EXEMPT_CODE FT_PT_STATUS_CODE FULLTIME_EQUIVALENT GRANT_IND HAZARDOUS_MATERIALS HOLD INACTIVITY_CODE ISN_POSITION_A JOB_CLASS_CODE JOB_GROUP_CODE MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID OVERLAP_IND PAY_BASIS_CODE PAY_GRADE_CODE PDB_ACTIVITY_CODE POOLED_POSITION_IND POSITION_CODE POSITION_ESTABLISH_DATE POSITION_INACTIVITY_DATE POSITION_STATUS POSITION_STATUS_CHANGE_DATE POSITION_TITLE PROBATION_SCHEDULE REG_TEMP_IND RowUpdatedOn SCHEDULE_CODE STAFFING_FORMULA SUPERVISOR_POSITION TRACK_IND WEEKLY_HOURS_AUTHORIZED
19980617 PEP210N1 1845286 LKWOKA 25-4031 N F 1.00 false false 1636055 372 LIBTCHI 12MO35 20081216 PEP210N1 1636055 E006065 false SALARY 56 31 false AA6038 20000701 A 20000701 R 2017-02-06T11:19:49.176-05:00 35HRS-AA AA0204 false 35.00
19980902 PEP210N1 1439565 CNOLES N P 40.00 false false 1025522 DELETED 512 OPSCLER HOUR/OPS 20070521 PEP210N1 1025522 E006065 false HOURLY MISC 07 false ACC6OPSC 19980701 20070517 I 20070521 T 2017-02-06T11:19:49.192-05:00 MISC AA2500 false
19980728 PEP210N1 1729590 ECHEEVER 37-2011 N F 1.00 false false 1013256 264 CUSTII 12MO40 20061012 PEP210N1 1013256 OPER2 false SALARY 54 34 false AA5142 20000701 A 20000701 R 2017-02-06T11:19:49.16-05:00 40HRS-AA AA5008 false 40.00
20101217 PEP210N1 0901242 E001501 E F 1.00 false false 1431510 GRENDED 5862 REGCOACH 12MO40 20120405 PEP210N1 1431510 E006065 false SALARY 58 06 false 8281 20110101 20120401 I 20120401 R 2017-02-06T11:19:49.675-05:00 40HRS-AA 8236 false 40.00
20080328 PEP210N1 0939131 E001122 43-9061 N P false false 1719239 DELETED 6300 TMP7FRS FRS/OPS 20121113 PEP210N1 1719239 E077683 false HOURLY MISC 36 true MNT1TR01 20080331 20121113 I 20121113 T 2017-02-06T11:19:49.722-05:00 MISC false
20010321 PEP210N1 1006056 CWHITE E P 1.00 false false 932477 DELETED 1256 P/TPROF HOURLY 20050405 PEP210N1 0932477 E001501 false HOURLY MISC 06 false CPI5YD01 20010302 20050323 I 20050405 T 2017-02-06T11:19:49.254-05:00 MISC false 25.00
19981006 PEP210N1 0712413 CWHITE E F 1.00 false false 1315106 DELETED 41 CNPROFI 248FAC 20110812 PEP210N1 1315106 E020563 false SALARY 03 04 false 4005 19990701 20100801 I 20100801 R 2017-02-06T11:19:49.145-05:00 12MOFAC 1563A false 40.00
20020322 PEP210N1 0845433 CWHITE 43-9061 N P false false 1615151 2447 OPSCLER HOUR/OPS 20140618 PEP210N1 1615151 E077593 false HOURLY MISC 36 true SYC5OPSC 20020314 A 20020322 T 2017-02-06T11:19:49.348-05:00 MISC false
20040923 PEP210N1 1041110 E001501 25-3099 E P false false 1041165 4356 SUB SUBREG 20040923 PEP210N1 1041165 E001501 false HOURLY MISC 32 true MAP2SUB+ 20040916 A 20040923 T 2017-02-06T11:19:49.519-05:00 MISC false
20070830 PEP210N1 1011328 E001501 25-3021 E P false false 1155301 DELETED 5225 ADJFAC ADJUNCT 20121113 PEP210N1 1155301 E006065 false HOURLY MISC 32 true FIT2ADJU 20070701 20121113 I 20121113 T 2017-02-06T11:19:49.613-05:00 MISC false
Powered by BI Documenter