|
![]() |
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 |
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 |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_JOB_GROUP_AND_CHILDREN_A |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
Name | Type |
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
Object | Property | Value |
Object | Property | Value |
/****** 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 ) |
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 |