DWStaging
 dbo.PENDING_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.PENDING_ASSIGNMENT_A
  Properties
Property Value
Name PENDING_ASSIGNMENT_A
Schema dbo
Row Count 146515
Data Size 32736 KB
Index Size 2600 KB
Create Date 11/5/2012 9:54 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
 
ASSIGNMENT_TYPE
varchar(8)
True
False
False
 
ATTEND_DEPT
varchar(6)
True
False
False
 
BOARD_APPROVAL_DATE
varchar(8)
True
False
False
 
CALENDAR_CODE
varchar(8)
True
False
False
 
CLASS_KEY
varchar(25)
True
False
False
 
END_BASIS
varchar(8)
True
False
False
 
END_DATE
varchar(8)
True
False
False
 
FT_PT_STATUS_CODE
varchar(1)
True
False
False
 
GL_ACCT_NUM
varchar(25)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOURLY_RATE
numeric(17, 2)
True
False
False
 
HOURS
numeric(17, 2)
True
False
False
 
HR_APPROVAL_CODE
varchar(2)
True
False
False
 
HR_APPROVE_DATE
varchar(8)
True
False
False
 
HR_APPROVE_TIME
varchar(7)
True
False
False
 
HR_APPROVE_USER_ID
varchar(8)
True
False
False
 
INSTR_ID
varchar(9)
True
False
False
 
INSTRUCTOR_INDICATOR
varchar(1)
True
False
False
 
INTERNAL_SEQ
int(10, 0)
True
False
False
 
ISN_PENDING_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
 
PAY_BASIS_CODE
varchar(8)
True
False
False
 
PAY_GRADE
varchar(8)
True
False
False
 
PAY_METHOD
varchar(2)
True
False
False
 
PAYROLL_APPROVE_DATE
varchar(8)
True
False
False
 
PAYROLL_APPROVE_TIME
varchar(7)
True
False
False
 
PAYROLL_APPROVE_USER_ID
varchar(8)
True
False
False
 
PENDING_ASSIGNMENT_TYPE
varchar(1)
True
False
False
 
POSITION_CODE
varchar(8)
True
False
False
 
PROCESSED_IND
varchar(1)
True
False
False
 
REASON_CODE
varchar(2)
True
False
False
 
REF_NUM
int(10, 0)
True
False
False
 
REJECT_DATE
varchar(8)
True
False
False
 
REJECT_TIME
varchar(7)
True
False
False
 
REJECT_USER_ID
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SALARY_AMOUNT
numeric(17, 2)
True
False
False
 
SALARY_SCHEDULE
varchar(5)
True
False
False
 
SEARCH_NAME
varchar(25)
True
False
False
 
START_DATE
varchar(8)
True
False
False
 
TITLE
varchar(25)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_PENDING_ASSIGNMENT_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.PENDING_ASSIGNMENT_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.PENDING_ASSIGNMENT_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[PENDING_ASSIGNMENT_A] Script Date: 03/09/2017 16:45:48 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[PENDING_ASSIGNMENT_A](
    [ISN_PENDING_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,
    [PENDING_ASSIGNMENT_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROCESSED_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INSTR_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REASON_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SALARY_AMOUNT] [numeric](17, 2) NULL,
    [HR_APPROVE_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HR_APPROVE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HR_APPROVE_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HR_APPROVAL_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYROLL_APPROVE_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYROLL_APPROVE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYROLL_APPROVE_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REF_NUM] [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,
    [BOARD_APPROVAL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CALENDAR_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ASSIGNMENT_TYPE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_GRADE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_BASIS] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SALARY_SCHEDULE] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOURS] [numeric](17, 2) NULL,
    [HOURLY_RATE] [numeric](17, 2) NULL,
    [FT_PT_STATUS_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_METHOD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEARCH_NAME] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLASS_KEY] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_ACCT_NUM] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_BASIS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INSTRUCTOR_INDICATOR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REJECT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REJECT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REJECT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ATTEND_DEPT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TITLE] [varchar](25) 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 ASSIGNMENT_TYPE ATTEND_DEPT BOARD_APPROVAL_DATE CALENDAR_CODE CLASS_KEY END_BASIS END_DATE FT_PT_STATUS_CODE GL_ACCT_NUM HOURLY_RATE HR_APPROVAL_CODE HR_APPROVE_DATE HR_APPROVE_TIME HR_APPROVE_USER_ID INSTR_ID INSTRUCTOR_INDICATOR INTERNAL_SEQ ISN_PENDING_ASSIGNMENT_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PAY_BASIS_CODE PAY_GRADE PAY_METHOD PAYROLL_APPROVE_DATE PAYROLL_APPROVE_TIME PAYROLL_APPROVE_USER_ID PENDING_ASSIGNMENT_TYPE POSITION_CODE PROCESSED_IND REASON_CODE REF_NUM REJECT_DATE REJECT_TIME REJECT_USER_ID RowUpdatedOn SALARY_AMOUNT SALARY_SCHEDULE SEARCH_NAME START_DATE TITLE
20060118 IRM910N1 0800339 E010035 ADJUNCT CNUR2215L 20062 19 004 P 112301002301051052100 38.49 20060124 1015083 E012720 000020423 6 9158 OC 20060124 1015340 E012720 I NRS1OVLS Y 84166 2017-02-06T11:35:42.841-05:00 806.75 MCGAVIN,VALERIE,B
20050912 IRM910N1 1432181 E005901 PARTTIME CEMS1119L 20061 1 003 P 112301002301101056000 27.59 20050920 1841043 E026518 000026730 1 5748 PL 20050920 1841131 E026518 I EMT1ADJU Y 76554 2017-02-06T11:35:42.404-05:00 27.59 BROWN,JOSE
20121022 IRM910N1 1158331 E027707 PARTTIME NFFO0411 20131 1 001 P 114200004201071056000 30.40 20121022 1509155 E027036 000002994 134 92052 HN 20121022 1509558 E027036 I FRT1ADJU Y 172711 2017-02-06T11:35:53.137-05:00 30.40 SILVERMAN,MICHAEL,W
20150121 IRM910N1 1336319 E000565 PARTTIME NCJK0040 20152 1 008 P 112702002702001056000 31.16 20150130 856492 E077683 000082822 71 122163 HN 20150130 857315 E077683 I CJTCADJU Y 198940 2017-02-06T11:35:56.647-05:00 31.16 SAGET,CHRISTINE,E
20150112 IRM910N1 1134415 E047564 PARTTIME CENC1101L 20152 5 003 P 111315001315015056008 31.29 20150116 1150481 E027036 000020473 2 121696 SB 20150116 1151039 E027036 I CPO5ETOS Y 195480 2017-02-06T11:35:56.585-05:00 1095.15 BARTLETT,RACHEL,M
20090112 IRM910N1 1635365 E000968 ADJUNCT CPGY1401C 20092 2 003 P 111210001210002056000 35.92 20090113 1322511 E000117 000002775 25 42221 SL 20090113 1323040 E000117 I ART2ADJS Y 115120 2017-02-06T11:35:47.084-05:00 2406.64 LUTZ,DENNIS,E
20061016 IRM910N1 1425393 E019193 PARTTIME NPRN0201 20071 1 001 P 112302002302031056000 31.08 20061019 1202414 E000117 000032922 1 16803 HN 20061019 1204336 E000117 I PNRSADJU Y 94608 2017-02-06T11:35:43.824-05:00 31.08 CAHILL,KATHY,A
20070423 IRM910N1 0908011 E000565 PARTTIME NCOO0023 20072 1 002 P 112703002703001056000 31.08 20070423 945413 E000117 000007289 8 21299 HN 20070423 945537 E000117 I PSC1ADJU Y 104431 2017-02-06T11:35:44.386-05:00 31.08 HOWARD,NANCY,L
20140828 IRM910N1 0922522 E077483 SALARY CMAC1105 20151 5 004 F 111617001617005052000 20140902 1713070 E000117 000001302 8 115478 IL 20140902 1713303 E000117 I 3170 Y 189018 2017-02-06T11:35:55.743-05:00 TAYLOR,BARBARA,Y
20121113 IRM910N1 0755525 E025760 PARTTIME CEMS2665 20132 19 001 P 112301002301031056000 29.51 20130108 1057148 E077683 000001188 95 92356 PL 20130108 1057508 E077683 I EMS1ADJU Y 170081 2017-02-06T11:35:53.153-05:00 29.51 GALLON,GLENN,D
Powered by BI Documenter