DWStaging
 dbo.JOB_CLASS_AND_CHILDREN_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.JOB_CLASS_AND_CHILDREN_A
  Properties
Property Value
Name JOB_CLASS_AND_CHILDREN_A
Schema dbo
Row Count 1123
Data Size 160 KB
Index Size 56 KB
Create Date 11/5/2012 9:36 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
 
BARGAINING_UNIT
varchar(1)
True
False
False
 
BARGAINING_UNIT_CODE
varchar(4)
True
False
False
 
EEO_ACTIVITY_CODE_FEDERAL
varchar(8)
True
False
False
 
END_DATE
varchar(8)
True
False
False
 
EXEMPT_NON_EXEMPT
varchar(1)
True
False
False
 
HAZARDOUS_MATERIALS
bit(1, 0)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_JOB_CLASS_AND_CHILDREN_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
 
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
 
OCCUPATIONAL_ACTIVITY
varchar(8)
True
False
False
 
PAY_GRADE_CODE
varchar(8)
True
False
False
 
PAY_SCHEDULE_CODE
varchar(8)
True
False
False
 
PDB_ACTIVITY_CODE
varchar(8)
True
False
False
 
PROBATION_DAYS
int(10, 0)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
START_DATE
varchar(8)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_JOB_CLASS_AND_CHILDREN_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.JOB_CLASS_AND_CHILDREN_A depends on)
Name Type
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.JOB_CLASS_AND_CHILDREN_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[JOB_CLASS_AND_CHILDREN_A] Script Date: 03/09/2017 16:45:41 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[JOB_CLASS_AND_CHILDREN_A](
    [ISN_JOB_CLASS_AND_CHILDREN_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,
    [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,
    [PROBATION_DAYS] [int] NULL,
    [OCCUPATIONAL_ACTIVITY] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
    [BARGAINING_UNIT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HAZARDOUS_MATERIALS] [bit] 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,
    [PAY_SCHEDULE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BARGAINING_UNIT_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BARGAINING_UNIT BARGAINING_UNIT_CODE EEO_ACTIVITY_CODE_FEDERAL END_DATE EXEMPT_NON_EXEMPT HAZARDOUS_MATERIALS HOLD ISN_JOB_CLASS_AND_CHILDREN_A JOB_CLASS_CODE JOB_GROUP_CODE JOB_TITLE MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID OCCUPATIONAL_ACTIVITY PAY_GRADE_CODE PAY_SCHEDULE_CODE PDB_ACTIVITY_CODE RowUpdatedOn START_DATE
20050718 PEJ330N1 1125538 E001122 N 26 20070630 E false 1310191 504 STDEVGII STUDENT DEV GENERALIST II 20080811 PEJ330N1 1310191 E020563 06 2017-02-06T11:25:42.565-05:00 19940101
19980330 PEJ330N1 0935405 SHILL Y 22 20100902 E false 944540 77 INSTRUCT ASSISTANT PROFESSOR 20100830 PEJ330N1 0944540 E020563 02 2017-02-06T11:25:42.534-05:00 19940101
19980401 PEJ330N1 1213391 SHILL N 25-3099 E false 1013439 172 SUB SUBSTITUTE 20130221 PEJ330N1 1013439 E006065 32 2017-02-06T11:25:42.534-05:00 19940101
19980330 PEJ330N1 1042131 SHILL N 29 20061231 N false 937163 174 MECHAUTO AUTO MECHANIC 20070502 PEJ330N1 0937163 E032243 09 2017-02-06T11:25:42.534-05:00 19940101
20000114 PEJ330N1 1315504 SHILL N 26 20061231 E false 1559127 245 DECD&EDS DIR.EARLY CHDHD & ED.SERV. 20070423 PEJ330N1 1559127 E020563 06 2017-02-06T11:25:42.534-05:00 19940101
19980626 PEJ330N1 1030493 SHILL N 21 20061231 E false 1639439 191 CEO CHIEF EXECUTIVE OFFICER 20070420 PEJ330N1 1639439 E020563 06 2017-02-06T11:25:42.534-05:00 19940101
19980327 PEJ330N1 1008200 SHILL N 13-1023 20140601 E false 1644285 219 DIRPURC PURCHASING DIRECTOR 20140603 PEJ330N1 1644285 E006065 22 2017-02-06T11:25:42.534-05:00 19940101
20050629 PEJ330N1 1227397 E001122 N 25-9031 E false 1309394 921 PSAVCORD PSAV COORDINATOR 20130225 PEJ330N1 1309394 E020563 32 2017-02-06T11:25:42.581-05:00 19940101
20120611 PEJ330N1 0859266 E020563 N 13-1071 20140402 E false 835162 886 ADIRHRSR ASST DIRECTOR HR SAFETY & RISK 20140407 PEJ330N1 0835162 E020563 22 2017-02-06T11:25:42.581-05:00 20120601
20030714 PEJ330N1 1006296 E001122 N 25-2011 N false 1344061 395 ELTEAIII EARLY LEARNING TEACHER III 20130227 PEJ330N1 1344061 E077683 32 2017-02-06T11:25:42.549-05:00 19940101
Powered by BI Documenter