DWStaging
 dbo.ASSIGNMENT_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.ASSIGNMENT_LOG_A
  Properties
Property Value
Name ASSIGNMENT_LOG_A
Schema dbo
Row Count 676474
Data Size 186464 KB
Index Size 10128 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
 
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_TYPE
varchar(8)
True
False
False
 
CONTRACT_YTD_ADJ
varchar(1)
True
False
False
 
COURSE_REFERENCE_NBR
int(10, 0)
True
False
False
 
DAILY_RATE
numeric(17, 2)
True
False
False
 
EFFECTIVE_DATE
varchar(8)
True
False
False
 
EFFECTIVE_DATE_9C
int(10, 0)
True
False
False
 
EFFECTIVE_TERM
varchar(6)
True
False
False
 
END_DATE
varchar(8)
True
False
False
 
END_DATE_9C
int(10, 0)
True
False
False
 
EQUAL_PAYMENTS_IND
bit(1, 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_LOG_A
int(10, 0)
False
False
False
 
JOB_CLASS_CODE
varchar(8)
True
False
False
 
JOB_GROUP_CODE
varchar(8)
True
False
False
 
JOB_TITLE
varchar(30)
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
 
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
 
REASSIGN_CODE
varchar(8)
True
False
False
 
REG_TEMP_IND
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SSN
varchar(9)
True
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_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ASSIGNMENT_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ASSIGNMENT_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ASSIGNMENT_LOG_A] Script Date: 03/09/2017 16:45:03 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ASSIGNMENT_LOG_A](
    [ISN_ASSIGNMENT_LOG_A] [int] NOT 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,
    [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,
    [CONTRACT_TYPE] [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,
    [EQUAL_PAYMENTS_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,
    [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,
    [JOB_TITLE] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFFECTIVE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFFECTIVE_DATE_9C] [int] NULL,
    [SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFFECTIVE_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COURSE_REFERENCE_NBR] [int] NULL,
    [REASSIGN_CODE] [varchar](8) 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,
    [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 ASSIGNMENT_PAID_OUT ASSIGNMENT_TITLE ASSIGNMENT_TYPE BASE_SALARY BOARD_APPROVAL_DATE CALENDAR_CODE CONTRACT_TYPE CONTRACT_YTD_ADJ DAILY_RATE EFFECTIVE_DATE EFFECTIVE_DATE_9C EFFECTIVE_TERM END_DATE END_DATE_9C EQUAL_PAYMENTS_IND EXEMPT_NON_EXEMPT FT_PT_STATUS_CODE GRANT_IND HOLD HOURLY_RATE HOURS_2080_IND INTERNAL_SEQ INTERNAL_SEQ_9C ISN_ASSIGNMENT_LOG_A JOB_CLASS_CODE JOB_GROUP_CODE JOB_TITLE LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER 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 REASSIGN_CODE REG_TEMP_IND RowUpdatedOn SSN START_DATE START_DATE_9C STOP_PAY STOP_PAY_END_DATE STOP_PAY_START_DATE TERMINATION_BASIS_CODE TIME_ATTENDANCE_COMPOUND_KEY TOTAL_SALARY
N 110276 NEWSEM PARTTIME 20080513 79919486 false E P false 1634264 31.9500 false 4 995 299074 M 20080502 pts/309 1634261 E037566 20080502 PEJ340N2 1634264 E037566 false 31.95 MISC N 47560 CJTCADJU false T 2017-02-06T10:33:41.328-05:00 820010155 20080502 79919497 CONENDED CJTC HOURLY ACKEG000047560CJTCADJU004
1916.91 N 141986 9 PTS OVERLOAD 1916.91 ADJUNCT 20110803 79889196 false E P false 1646464 36.1000 false 20 979 420035 M 20110516 pts/186 1646463 E000117 20110516 PEJ340N2 1646464 E000117 false MISC N 319.49 47784 RAD2OVLS false T 2017-02-06T10:34:01.827-05:00 820010260 20110510 79889489 CONENDED RAD2 SALARY LATIM000047784RAD2OVLS020 1916.91
1905.87 N 169133 NEWSEM 1905.87 ADJUNCT 20130107 79869892 20130508 79869491 false E P false 1628191 37.3700 false 35 964 508714 ADJFAC ADJUNCT ADJUNCT INSTRUCTOR A 20130118 pts/125 1628190 E027036 false MISC N 238.23 29394 CPO5ADJS false T 2017-02-06T10:34:17.24-05:00 820008553 20130107 79869892 CONENDED COM5 SALARY DOMIJ000029394CPO5ADJS035 1905.87
N 065392 3 HRS PARTTIME PARTTIME 20040925 79959074 false E P false 1354531 15.6200 false 1 998 180721 M 20041005 0184 1354531 E000117 20041005 PEJ340N2 1354531 E000117 false 15.62 MISC N 4289 ART2OSUB false T 2017-02-06T10:33:21.407-05:00 820003867 20040925 79959074 TEMPJOB ART2 HOURLY ERICR000004289ART2OSUB001
N 117293 NEWSEM PARTTIME 20090729 79909270 false E P false 1722586 25.5100 false 6 993 344055 M 20090604 pts/100 1722585 E012720 20090604 PEJ340N2 1722586 E012720 false 25.51 MISC N 57633 HCO1ADJU true T 2017-02-06T10:33:49.081-05:00 820010713 20090512 79909487 CONENDED COR1 HOURLY GRIFJ000057633HCO1ADJU006
231.30 N 123979 .90 PTS OVERLOAD 231.30 ADJUNCT 20091217 79908782 false E P false 1211314 45.7300 false 14 985 356092 M 20090825 pts/34 1211314 E000117 20090825 PEJ340N2 1211314 E000117 false MISC N 33.04 710 PLG2OVLS false T 2017-02-06T10:33:51.094-05:00 820000706 20090921 79909078 CONENDED PLG2 SALARY SCHEB000000710PLG2OVLS014 231.30
N 094805,094806,094807,094809 NEWSEM PARTTIME 20060508 79939491 false E P false 1607121 27.5900 false 9 990 224208 M 20060320 0498 1607119 E026518 20060320 PEJ340N2 1607121 E026518 false 27.59 MISC N 31151 EMF1ADJU false T 2017-02-06T10:33:28.599-05:00 820009018 20060206 79939793 CONENDED CEP1 HOURLY AZZAV000031151EMF1ADJU009
CLERK PARTTIME PARTTIME 20000530 79999469 false N P false 1011290 8.4700 true 1 48413 M 20000525 0065 1011288 SSULLIVA 20000525 PEJ340N2 1011290 SSULLIVA false 8.47 5924 CPI2OPSC true T 2017-02-06T10:32:58.49-05:00 820004188 20000510 79999489 TEMPJOB CPI2 HOURLY WHYTD000005924CPI2OPSC001
43871.31 N FULLTIME 50138.61 260 DAY 192.84 20100105 79899894 0 false E F false 823114 24.1050 false 11 988 367475 CRMSPEC 12MO40 COLLEGE REL & MARKETING SPEC M 20100105 <notty> 823114 E020563 20100105 PEJ340N2 0823114 E020563 false 24.10 58 N 2089.11 5954 AA1558 true R 2017-02-06T10:33:52.857-05:00 820004218 20090816 79909183 CRM6 SALARY MCDOT000005954AA1558 011 50138.61
N 119476 NEWSEM PARTTIME 20090727 79909272 false E P false 1442102 31.9500 false 4 995 342198 M 20090519 pts/25 1442102 E000117 20090519 PEJ340N2 1442102 E000117 false 31.95 MISC N 37587 MEDAADJU false T 2017-02-06T10:33:48.754-05:00 820009677 20090512 79909487 CONENDED HLT1 HOURLY POMEH000037587MEDAADJU004
Powered by BI Documenter