DWStaging
 dbo.POSITION_LOG_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_LOG_A
  Properties
Property Value
Name POSITION_LOG_A
Schema dbo
Row Count 168707
Data Size 36768 KB
Index Size 2544 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
ACCOUNT_CODE
varchar(25)
True
False
False
 
ACCOUNT_CODE_END_DATE
varchar(8)
True
False
False
 
ACCOUNT_CODE_START_DATE
varchar(8)
True
False
False
 
ACCOUNT_PERC
numeric(7, 4)
True
False
False
 
ACCOUNT_PRIMARY_IND
bit(1, 0)
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
 
BENEFIT_ACTUAL_AMT
numeric(9, 2)
True
False
False
 
CALENDAR_CODE
varchar(8)
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_LOG_A
int(10, 0)
False
False
False
 
JOB_CLASS_CODE
varchar(8)
True
False
False
 
JOB_GROUP_CODE
varchar(8)
True
False
False
 
LOG_ACTION
varchar(1)
True
False
False
 
LOG_DATE
int(10, 0)
True
False
False
 
LOG_TID
varchar(8)
True
False
False
 
LOG_TIME
int(10, 0)
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
 
NUMBER_ENCUMBENTS
int(10, 0)
True
False
False
 
OVERLAP_IND
bit(1, 0)
True
False
False
 
OVERTIME_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_ACCOUNT_HOLD
int(10, 0)
True
False
False
 
POSITION_ACCOUNT_POSITION_CODE
varchar(8)
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
 
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
 
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_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.POSITION_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.POSITION_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[POSITION_LOG_A] Script Date: 03/09/2017 16:45:51 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[POSITION_LOG_A](
    [ISN_POSITION_LOG_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_ACCOUNT_HOLD] [int] NULL,
    [POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSITION_ACCOUNT_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,
    [CALENDAR_CODE] [varchar](8) 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,
    [NUMBER_ENCUMBENTS] [int] NULL,
    [ACCOUNT_CODE] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCOUNT_PERC] [numeric](7, 4) NULL,
    [ACCOUNT_PRIMARY_IND] [bit] NULL,
    [OVERTIME_IND] [bit] NULL,
    [TRACK_IND] [bit] NULL,
    [OVERLAP_IND] [bit] NULL,
    [ACCOUNT_CODE_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCOUNT_CODE_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_TID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_DATE] [int] NULL,
    [LOG_TIME] [int] NULL,
    [GRANT_IND] [bit] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
  Sample Data
ACCOUNT_CODE ACCOUNT_CODE_END_DATE ACCOUNT_CODE_START_DATE ACCOUNT_PRIMARY_IND ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID CALENDAR_CODE EEO_ACTIVITY_CODE_FEDERAL EXEMPT_NON_EXEMPT_CODE FT_PT_STATUS_CODE FULLTIME_EQUIVALENT GRANT_IND HAZARDOUS_MATERIALS HOLD INACTIVITY_CODE ISN_POSITION_LOG_A JOB_CLASS_CODE JOB_GROUP_CODE LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NUMBER_ENCUMBENTS OVERLAP_IND OVERTIME_IND PAY_BASIS_CODE PAY_GRADE_CODE PDB_ACTIVITY_CODE POOLED_POSITION_IND POSITION_ACCOUNT_POSITION_CODE POSITION_CODE POSITION_ESTABLISH_DATE POSITION_INACTIVITY_DATE POSITION_STATUS POSITION_STATUS_CHANGE_DATE POSITION_TITLE REG_TEMP_IND RowUpdatedOn SCHEDULE_CODE STAFFING_FORMULA TRACK_IND WEEKLY_HOURS_AUTHORIZED
false 25-0000 E F 1.00 false false 950017 164547 PROFASSC 168FAC M 20151217 pts/111 950017 E006065 false false SALARY MISC 25 false 3176TMP 20160101 A 20151112 T 2017-02-06T10:39:40.677-05:00 168FAC false 35.00
false E P false false 1245041 141153 ADJFAC ADJUNCT M 20060731 pts/9 1245041 E001501 false false SALARY MISC 02 true CBI5ADJS 20060701 A 20060731 T 2017-02-06T10:39:37.541-05:00 MISC false
false E P 1.00 false false 851272 123215 P/TPROF HOURLY M 20040611 0088 851272 E001122 false false HOURLY MISC 06 false CPI1YE04 20020509 A 20020523 R 2017-02-06T10:39:35.201-05:00 MISC false 30.00
false N F 1.00 false false 1706449 140012 CUSTII 12MO40 M 20060710 <notty> 1706449 OPER2 false false SALARY 54 10 false AA5142 20000701 A 20000701 R 2017-02-06T10:39:37.4-05:00 40HRS-AA false 40.00
false P false false 1432073 72056 ADJFAC ADJUNCT M 20010102 0200 1432073 CZUCCARO 1 false false HOURLY MISC 02 true PSC5ADJU 20000901 A 20001009 T 2017-02-06T10:39:28.462-05:00 MISC false
false P false false 1349068 12217 ADJFAC ADJUNCT M 19981116 NATB0102 1349067 SBURGRD 16 false false HOURLY MISC 02 true MUS1ADJU 19980701 A 19980821 T 2017-02-06T10:39:20.818-05:00 MISC false
false E P false false 1040591 152968 ADJFAC ADJUNCT A 20100909 pts/5 1040591 E001501 false false HOURLY MISC 02 true CFA1ADJU 20100816 A 20100909 T 2017-02-06T10:39:39.07-05:00 MISC false
false E P false false 1322355 DELETED 156293 ADJFAC ADJUNCTR M 20121012 pts/241 1322355 E020563 false false SALARY MISC 02 true VPAAETOS 19990818 20121012 I 20121012 T 2017-02-06T10:39:39.538-05:00 MISC false
false P false false 1632406 109618 ADJFAC ADJUNCTR M 20020109 0104 1632406 SSULLIVA false false SALARY MISC 02 true CPI5ETOS 19990818 A 19990812 T 2017-02-06T10:39:33.469-05:00 MISC false 40.00
false P false false 1412121 44860 ADJFAC ADJUNCT M 20000112 0057 1412120 SSULLIVA false false SALARY MISC 02 true BUS5ADJS 19990818 A 19990811 T 2017-02-06T10:39:24.796-05:00 MISC false
Powered by BI Documenter