DWStaging
 dbo.JOB_GROUP_AND_CHILDREN_A (Table)
  Properties
Property Value
Name JOB_GROUP_AND_CHILDREN_A
Schema dbo
Row Count 1628
Data Size 104 KB
Index Size 64 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
ACAD_YR_CALENDAR_CODE
varchar(8)
True
False
False
 
ACAD_YR_JOB_GROUP_CODE
varchar(8)
True
False
False
 
ACAD_YR_PAY_BASIS_CODE
varchar(8)
True
False
False
 
ACADEMIC_YEAR
varchar(4)
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_JOB_GROUP_CODE
varchar(8)
True
False
False
 
BENEFIT_PAY_BASIS_CODE
varchar(8)
True
False
False
 
BENEFIT_TYPE_CODE
varchar(8)
True
False
False
 
CALENDAR_CODE
varchar(8)
True
False
False
 
CALENDAR_JOB_GROUP_CODE
varchar(8)
True
False
False
 
CALENDAR_PAY_BASIS_CODE
varchar(8)
True
False
False
 
COMP_ABOVE_TIME_TYPE
varchar(4)
True
False
False
 
COMP_BELOW_TIME_TYPE
varchar(4)
True
False
False
 
DAILY_HOURS_WORKED
numeric(17, 2)
True
False
False
 
DESCRIPTION
varchar(50)
True
False
False
 
EMPLOYEE_OPTION
varchar(1)
True
False
False
 
END_DATE
varchar(8)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_JOB_GROUP_AND_CHILDREN_A
int(10, 0)
False
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
 
MAX_LOAD_ACAD_YEAR
numeric(17, 2)
True
False
False
 
MAX_LOAD_TERM1
numeric(17, 2)
True
False
False
 
MAX_LOAD_TERM2
numeric(17, 2)
True
False
False
 
MAX_LOAD_TERM3
numeric(17, 2)
True
False
False
 
MAX_LOAD_TERM4
numeric(17, 2)
True
False
False
 
MAX_OVERLOAD_ACAD_YEAR
numeric(17, 2)
True
False
False
 
MAX_OVERLOAD_TERM1
numeric(17, 2)
True
False
False
 
MAX_OVERLOAD_TERM2
numeric(17, 2)
True
False
False
 
MAX_OVERLOAD_TERM3
numeric(17, 2)
True
False
False
 
MAX_OVERLOAD_TERM4
numeric(17, 2)
True
False
False
 
PAY_ABOVE_TIME_TYPE
varchar(4)
True
False
False
 
PAY_BASIS_CODE
varchar(8)
True
False
False
 
PAY_BELOW_TIME_TYPE
varchar(4)
True
False
False
 
PAY_OUT_JOB_GROUP
varchar(1)
True
False
False
 
PDB_ANNUAL_HOURS
numeric(17, 2)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SCHEDULE_CODE
varchar(8)
True
False
False
 
SCHEDULE_JOB_GROUP_CODE
varchar(8)
True
False
False
 
SCHEDULE_PAY_BASIS_CODE
varchar(8)
True
False
False
 
STATUS
varchar(1)
True
False
False
 
TIME_JOB_GROUP_CODE
varchar(8)
True
False
False
 
TIME_PAY_BASIS_CODE
varchar(8)
True
False
False
 
TIME_TYPE_CODE
varchar(4)
True
False
False
 
WORK_WEEK_HOURS
numeric(17, 2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_JOB_GROUP_AND_CHILDREN_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.JOB_GROUP_AND_CHILDREN_A depends on)
Name Type
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.JOB_GROUP_AND_CHILDREN_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[JOB_GROUP_AND_CHILDREN_A] Script Date: 03/09/2017 16:45:42 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[JOB_GROUP_AND_CHILDREN_A](
    [ISN_JOB_GROUP_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_GROUP_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BENEFIT_JOB_GROUP_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CALENDAR_JOB_GROUP_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TIME_JOB_GROUP_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHEDULE_JOB_GROUP_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BENEFIT_PAY_BASIS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CALENDAR_PAY_BASIS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TIME_PAY_BASIS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHEDULE_PAY_BASIS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DESCRIPTION] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_BASIS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CALENDAR_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TIME_TYPE_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BENEFIT_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHEDULE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DAILY_HOURS_WORKED] [numeric](17, 2) NULL,
    [PAY_OUT_JOB_GROUP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PDB_ANNUAL_HOURS] [numeric](17, 2) NULL,
    [ACADEMIC_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACAD_YR_JOB_GROUP_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACAD_YR_PAY_BASIS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACAD_YR_CALENDAR_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAX_LOAD_TERM1] [numeric](17, 2) NULL,
    [MAX_LOAD_TERM2] [numeric](17, 2) NULL,
    [MAX_LOAD_TERM3] [numeric](17, 2) NULL,
    [MAX_LOAD_TERM4] [numeric](17, 2) NULL,
    [MAX_LOAD_ACAD_YEAR] [numeric](17, 2) NULL,
    [MAX_OVERLOAD_TERM1] [numeric](17, 2) NULL,
    [MAX_OVERLOAD_TERM2] [numeric](17, 2) NULL,
    [MAX_OVERLOAD_TERM3] [numeric](17, 2) NULL,
    [MAX_OVERLOAD_TERM4] [numeric](17, 2) NULL,
    [MAX_OVERLOAD_ACAD_YEAR] [numeric](17, 2) NULL,
    [WORK_WEEK_HOURS] [numeric](17, 2) NULL,
    [EMPLOYEE_OPTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_BELOW_TIME_TYPE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_ABOVE_TIME_TYPE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMP_ABOVE_TIME_TYPE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMP_BELOW_TIME_TYPE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS] [varchar](1) 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
ACAD_YR_CALENDAR_CODE ACAD_YR_JOB_GROUP_CODE ACAD_YR_PAY_BASIS_CODE ACADEMIC_YEAR ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BENEFIT_JOB_GROUP_CODE BENEFIT_PAY_BASIS_CODE BENEFIT_TYPE_CODE CALENDAR_CODE CALENDAR_JOB_GROUP_CODE CALENDAR_PAY_BASIS_CODE COMP_ABOVE_TIME_TYPE COMP_BELOW_TIME_TYPE DAILY_HOURS_WORKED DESCRIPTION EMPLOYEE_OPTION END_DATE HOLD ISN_JOB_GROUP_AND_CHILDREN_A JOB_GROUP_CODE MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PAY_ABOVE_TIME_TYPE PAY_BASIS_CODE PAY_BELOW_TIME_TYPE PAY_OUT_JOB_GROUP PDB_ANNUAL_HOURS RowUpdatedOn SCHEDULE_CODE SCHEDULE_JOB_GROUP_CODE SCHEDULE_PAY_BASIS_CODE STATUS TIME_JOB_GROUP_CODE TIME_PAY_BASIS_CODE TIME_TYPE_CODE
168FAC SALARY PPO+FAM 881 2017-02-06T11:24:48.526-05:00
168FACLB SALARY EMPASST 1444 2017-02-06T11:24:48.604-05:00
168FACLB SALARY DENTAL 733 2017-02-06T11:24:48.511-05:00
1461 2017-02-06T11:24:48.604-05:00 MISC HOURLYH HOURLY
1261 2017-02-06T11:24:48.589-05:00 210/40HR HOURLY POOL
PRES SALARY LIFEPRES 142 2017-02-06T11:24:48.433-05:00
255 2017-02-06T11:24:48.448-05:00 210/40HR SALARY CTE
20150923 PEJ320N1 1646574 E006065 8.00 TEMPORARY HOURLY WORKERS/HEALTH 1657286 1618 HOUR/OPH 20150923 PEJ320N1 1657286 E006065 SALARY 2080.00 2017-02-06T11:24:48.651-05:00 A
235 2017-02-06T11:24:48.448-05:00 248FAC SALARY CL
228FAC35 SALARY PLANCV 1219 2017-02-06T11:24:48.589-05:00
Powered by BI Documenter