DWStaging
 dbo.ASSIGNMENT_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.ASSIGNMENT_A
  Properties
Property Value
Name ASSIGNMENT_A
Schema dbo
Row Count 239593
Data Size 63432 KB
Index Size 3984 KB
Create Date 10/25/2012 3:55 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACTUAL_SALARY
numeric(17, 2)
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
 
ASSIGNMENT_PAID_OUT
varchar(1)
True
False
False
 
ASSIGNMENT_TITLE
varchar(30)
True
False
False
 
ASSIGNMENT_TYPE
varchar(8)
True
False
False
 
BASE_SALARY
numeric(17, 2)
True
False
False
 
BOARD_APPROVAL_DATE
varchar(8)
True
False
False
 
CALENDAR_CODE
varchar(8)
True
False
False
 
CONTRACT_YTD_ADJ
varchar(1)
True
False
False
 
DAILY_RATE
numeric(17, 2)
True
False
False
 
EFFECTIVE_END_DATE
varchar(8)
True
False
False
 
EFFECTIVE_START_DATE
varchar(8)
True
False
False
 
END_DATE
varchar(8)
True
False
False
 
END_DATE_9C
int(10, 0)
True
False
False
 
EXEMPT_NON_EXEMPT
varchar(1)
True
False
False
 
FT_PT_STATUS_CODE
varchar(1)
True
False
False
 
GRANT_IND
bit(1, 0)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOURLY_RATE
numeric(17, 4)
True
False
False
 
HOURS_2080_IND
bit(1, 0)
True
False
False
 
INTERNAL_SEQ
int(10, 0)
True
False
False
 
INTERNAL_SEQ_9C
int(10, 0)
True
False
False
 
ISN_ASSIGNMENT_A
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
 
ORIG_END_DATE_LOCKED_IND
bit(1, 0)
True
False
False
 
ORIGINAL_END_DATE
varchar(8)
True
False
False
 
OVERTIME_RATE
numeric(17, 2)
True
False
False
 
PAY_GRADE_CODE
varchar(8)
True
False
False
 
PAY_OUT_ASSIGNMENT
varchar(1)
True
False
False
 
PAY_PERIOD_GROSS
numeric(17, 2)
True
False
False
 
PAY_STEP_CODE
varchar(8)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
POSITION_CODE
varchar(8)
True
False
False
 
PRIMARY_ASSIGNMENT_IND
bit(1, 0)
True
False
False
 
REG_TEMP_IND
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
START_DATE
varchar(8)
True
False
False
 
START_DATE_9C
int(10, 0)
True
False
False
 
STOP_PAY
varchar(1)
True
False
False
 
STOP_PAY_END_DATE
varchar(8)
True
False
False
 
STOP_PAY_START_DATE
varchar(8)
True
False
False
 
TERMINATION_BASIS_CODE
varchar(8)
True
False
False
 
TIME_ATTENDANCE_COMPOUND_KEY
varchar(85)
True
False
False
 
TOTAL_SALARY
decimal(9, 2)
True
False
False
 
YEARS_ON_TRACK
int(10, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ASSIGNMENT_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ASSIGNMENT_A depends on)
Name Type
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.ASSIGNMENT_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ASSIGNMENT_A] Script Date: 03/09/2017 16:45:02 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ASSIGNMENT_A](
    [ISN_ASSIGNMENT_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,
    [PERSON_ID] [int] NULL,
    [POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INTERNAL_SEQ] [int] 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,
    [START_DATE_9C] [int] NULL,
    [HOURLY_RATE] [numeric](17, 4) NULL,
    [OVERTIME_RATE] [numeric](17, 2) NULL,
    [BASE_SALARY] [numeric](17, 2) NULL,
    [ACTUAL_SALARY] [numeric](17, 2) NULL,
    [PAY_PERIOD_GROSS] [numeric](17, 2) NULL,
    [CALENDAR_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FT_PT_STATUS_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ASSIGNMENT_TYPE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ASSIGNMENT_TITLE] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRIMARY_ASSIGNMENT_IND] [bit] NULL,
    [BOARD_APPROVAL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERMINATION_BASIS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRANT_IND] [bit] NULL,
    [REG_TEMP_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DAILY_RATE] [numeric](17, 2) NULL,
    [TIME_ATTENDANCE_COMPOUND_KEY] [varchar](85) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOURS_2080_IND] [bit] NULL,
    [PAY_STEP_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [YEARS_ON_TRACK] [int] NULL,
    [EXEMPT_NON_EXEMPT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_GRADE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOTAL_SALARY] [decimal](9, 2) NULL,
    [PAY_OUT_ASSIGNMENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ASSIGNMENT_PAID_OUT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STOP_PAY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STOP_PAY_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STOP_PAY_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INTERNAL_SEQ_9C] [int] NULL,
    [ORIGINAL_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORIG_END_DATE_LOCKED_IND] [bit] NULL,
    [EFFECTIVE_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFFECTIVE_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_YTD_ADJ] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_DATE_9C] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACTUAL_SALARY ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ASSIGNMENT_PAID_OUT ASSIGNMENT_TITLE ASSIGNMENT_TYPE BASE_SALARY BOARD_APPROVAL_DATE CALENDAR_CODE CONTRACT_YTD_ADJ DAILY_RATE EFFECTIVE_END_DATE EFFECTIVE_START_DATE END_DATE END_DATE_9C EXEMPT_NON_EXEMPT FT_PT_STATUS_CODE GRANT_IND HOLD HOURLY_RATE HOURS_2080_IND INTERNAL_SEQ INTERNAL_SEQ_9C ISN_ASSIGNMENT_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID ORIG_END_DATE_LOCKED_IND ORIGINAL_END_DATE OVERTIME_RATE PAY_GRADE_CODE PAY_OUT_ASSIGNMENT PAY_PERIOD_GROSS PAY_STEP_CODE PERSON_ID POSITION_CODE PRIMARY_ASSIGNMENT_IND REG_TEMP_IND RowUpdatedOn START_DATE START_DATE_9C STOP_PAY STOP_PAY_END_DATE STOP_PAY_START_DATE TERMINATION_BASIS_CODE TIME_ATTENDANCE_COMPOUND_KEY TOTAL_SALARY
2673.30 20160825 PEJ340N2 1434005 E027036 N 218211 ADJUNCT 2673.30 ADJUNCT 20161219 79838780 E P false 1458185 39.9000 false 41 958 235480 20160825 PEJ340N2 1458185 E027036 false MISC N 334.16 42587 ART5ADJS false T 2017-02-06T10:47:15.529-05:00 20160823 79839176 CONENDED ART5 SALARY LABAR000042587ART5ADJS041 2673.30
1905.87 20120829 PEJ340N2 1823040 E000117 N 161896 NEWSEM 1905.87 ADJUNCT 20121218 79878781 E P false 1634463 37.3700 false 44 955 164781 20120830 PEJ340N2 1634463 E027036 false MISC N 238.23 3786 PSY1ADJS false T 2017-02-06T10:47:05.701-05:00 20120823 79879176 CONENDED SOC1 SALARY THOMM000003786PSY1ADJS044 1905.87
2428.26 20100831 PEJ340N2 1046144 E000117 N 144243 9 PTS OVERLOAD 2428.26 ADJUNCT 20101217 79898782 E P false 1100149 45.7300 false 44 955 134861 20100831 PEJ340N2 1100149 E000117 false MISC N 346.89 29580 SOC5OVLS false T 2017-02-06T10:47:01.395-05:00 20100920 79899079 CONENDED SOC5 SALARY RAZAA000029580SOC5OVLS044 2428.26
20110902 PEJ340N2 1709226 E077683 N 158997 NEWSEM PARTTIME 20110914 79889085 E P false 1709376 33.5100 false 43 956 150790 20110902 PEJ340N2 1709376 E077683 false 33.51 MISC N 145 PNRSADJU false T 2017-02-06T10:47:03.782-05:00 20110822 79889177 CONENDED HLT1 HOURLY GROTN000000145PNRSADJU043
329.60 20151214 PEJ340N2 1101312 E000117 N MODEL LEGISLATURE FALL 2015 STIPEND 329.60 260 DAY 20151218 20150821 20160115 79839884 E P false 1102115 329.6000 false 1 998 223132 20151214 PEJ340N2 1102115 E000117 false MISC N 329.60 77785 DCA_0007 false T 2017-02-06T10:47:13.781-05:00 20160101 79839898 TEMPJOB SAD6 SALARY VAN R000077785DCA_0007001 329.60
20010123 PEJ340N2 1322194 SSULLIVA N LEARNING SPECIALIST PARTTIME PARTTIME 20010123 79989876 E P true 906177 15.0300 true 1 998 20615 20010130 PEJ340N2 0906176 SSULLIVA false 15.03 MISC N 3632 CPI5OPRF false T 2017-02-06T10:46:44.516-05:00 20010109 79989890 TEMPJOB CPI5 HOURLY PELLS000003632CPI5OPRF001
817.68 20140228 PEJ340N2 1319550 E000117 N 184215 ADJUNCT 817.68 ADJUNCT 20140329 79859670 E P false 1321170 34.0700 false 28 971 194716 20140228 PEJ340N2 1321170 E000117 false MISC N 408.84 30897 CDA1ETOS false T 2017-02-06T10:47:09.647-05:00 20140301 79859698 CONENDED TED5 SALARY GOMEE000030897CDA1ETOS028 817.68
1955.85 20140905 PEJ340N2 1437273 E027036 N 188986 ADJUNCT 1955.85 ADJUNCT 20141218 79858781 E P false 1437521 38.3500 false 103 896 204760 20140905 PEJ340N2 1437521 E027036 false MISC N 244.48 455 HLT5ADJS false T 2017-02-06T10:47:11.036-05:00 20140822 79859177 CONENDED HLT5 SALARY SIEGR000000455HLT5ADJS103 1955.85
51264.96 20050701 PEJ340N2 1351491 E001122 N FULLTIME 51265.01 260 DAY 197.17 20060630 79939369 E F true 1039389 24.6463 false 5 994 62424 20060629 XPJ340N2 1039389 E001122 false 24.64 59 N 2136.04 1984 AA8106 true R 2017-02-06T10:46:50.974-05:00 20050701 79949298 SAL INC CROS SALARY MARSR000001984AA8106 005 51265.01
2021.64 20090902 PEJ340N2 1406597 E000117 N 122729 NEWSEM 2021.64 ADJUNCT 20091217 79908782 E P false 1408047 39.6400 false 39 960 119470 20090902 PEJ340N2 1408047 E000117 false MISC N 252.71 473 ECO2ADJS false T 2017-02-06T10:46:59.086-05:00 20090821 79909178 CONENDED SOC2 SALARY ASSAA000000473ECO2ADJS039 2021.64
Powered by BI Documenter