DWStaging
 dbo.PERSONNEL_REPORT_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.PERSONNEL_REPORT_A
  Properties
Property Value
Name PERSONNEL_REPORT_A
Schema dbo
Row Count 4899
Data Size 1112 KB
Index Size 128 KB
Create Date 2/26/2016 9:04 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_TERMINAL_ID
varchar(8)
True
False
False
 
ADD_TIME
varchar(7)
True
False
False
 
ADD_USER_ID
varchar(8)
True
False
False
 
APR_ANNUAL_SALARY
int(10, 0)
True
False
False
 
APR_BIRTH_DATE
varchar(8)
True
False
False
 
APR_CITIZENSHIP
varchar(1)
True
False
False
 
APR_CONTRACT_STATUS_NON_TENURED
varchar(1)
True
False
False
 
APR_CREDIT_PRIMARY_INSTR
varchar(1)
True
False
False
 
APR_DATE_HIRED
varchar(8)
True
False
False
 
APR_DEGREE
varchar(1)
True
False
False
 
APR_EEO_6_INDICATOR
varchar(1)
True
False
False
 
APR_ETHNIC_ORIGIN
varchar(1)
True
False
False
 
APR_FACULTY_STATUS
varchar(1)
True
False
False
 
APR_FIRST_NAME
varchar(15)
True
False
False
 
APR_FLEID
varchar(14)
True
False
False
 
APR_FULL_PART_TIME_IND
varchar(1)
True
False
False
 
APR_GENDER
varchar(1)
True
False
False
 
APR_LAST_NAME
varchar(20)
True
False
False
 
APR_LEAVE_TYPE
varchar(1)
True
False
False
 
APR_MIDDLE
varchar(20)
True
False
False
 
APR_MONTHS_EMPLOYED
int(10, 0)
True
False
False
 
APR_NAME_SUFFIX
varchar(10)
True
False
False
 
APR_OCCUPATIONAL_ACT_CODE
varchar(2)
True
False
False
 
APR_PERSON_ID
varchar(9)
True
False
False
 
APR_POSITION_TITLE
varchar(25)
True
False
False
 
APR_RANK
varchar(1)
True
False
False
 
APR_REPORT_INST
varchar(6)
True
False
False
 
APR_SENSITIVE_IND
bit(1, 0)
True
False
False
 
APR_TEMP_EMPLOYED
varchar(1)
True
False
False
 
APR_TENURE
varchar(1)
True
False
False
 
APR_TENURE_DATE
varchar(8)
True
False
False
 
APR_TERMS_EMPLOYED
varchar(2)
True
False
False
 
ETHNICITY
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_PERSONNEL_REPORT_A
int(10, 0)
False
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_PGM
varchar(8)
True
False
False
 
MAINT_TERMINAL_ID
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
True
False
False
 
PRIMARY_INTERNAL_SEQ
int(10, 0)
True
False
False
 
PRIMARY_POSITION_CODE
varchar(8)
True
False
False
 
RACE_AFAMER
varchar(1)
True
False
False
 
RACE_AMERIND_ALASKAN
varchar(1)
True
False
False
 
RACE_ASIAN
varchar(1)
True
False
False
 
RACE_HAWAIIAN_PACISLANDER
varchar(1)
True
False
False
 
RACE_WHITE
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_PERSONNEL_REPORT_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.PERSONNEL_REPORT_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.PERSONNEL_REPORT_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[PERSONNEL_REPORT_A] Script Date: 03/09/2017 16:45:50 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[PERSONNEL_REPORT_A](
    [ISN_PERSONNEL_REPORT_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_TERMINAL_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_TERMINAL_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,
    [APR_REPORT_INST] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_PERSON_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_LAST_NAME] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_FIRST_NAME] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_MIDDLE] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_GENDER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_ETHNIC_ORIGIN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_CITIZENSHIP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_DATE_HIRED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_TERMS_EMPLOYED] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_TEMP_EMPLOYED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_FULL_PART_TIME_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_ANNUAL_SALARY] [int] NULL,
    [APR_BIRTH_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_POSITION_TITLE] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_OCCUPATIONAL_ACT_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_RANK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_DEGREE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_LEAVE_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_TENURE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_TENURE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_EEO_6_INDICATOR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_SENSITIVE_IND] [bit] NULL,
    [APR_FACULTY_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RACE_WHITE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RACE_AFAMER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RACE_ASIAN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RACE_AMERIND_ALASKAN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RACE_HAWAIIAN_PACISLANDER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ETHNICITY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_MONTHS_EMPLOYED] [int] NULL,
    [APR_CONTRACT_STATUS_NON_TENURED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_CREDIT_PRIMARY_INSTR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRIMARY_POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRIMARY_INTERNAL_SEQ] [int] NULL,
    [APR_FLEID] [varchar](14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APR_NAME_SUFFIX] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
  Sample Data
ADD_DATE ADD_PGM ADD_TERMINAL_ID ADD_TIME ADD_USER_ID APR_ANNUAL_SALARY APR_BIRTH_DATE APR_CITIZENSHIP APR_CONTRACT_STATUS_NON_TENURED APR_CREDIT_PRIMARY_INSTR APR_DATE_HIRED APR_DEGREE APR_EEO_6_INDICATOR APR_ETHNIC_ORIGIN APR_FACULTY_STATUS APR_FIRST_NAME APR_FLEID APR_FULL_PART_TIME_IND APR_GENDER APR_LAST_NAME APR_LEAVE_TYPE APR_MIDDLE APR_MONTHS_EMPLOYED APR_NAME_SUFFIX APR_OCCUPATIONAL_ACT_CODE APR_PERSON_ID APR_POSITION_TITLE APR_RANK APR_REPORT_INST APR_SENSITIVE_IND APR_TEMP_EMPLOYED APR_TENURE APR_TENURE_DATE APR_TERMS_EMPLOYED ETHNICITY ISN_PERSONNEL_REPORT_A MAINT_DATE MAINT_PGM MAINT_TERMINAL_ID MAINT_TIME MAINT_USER_ID PRIMARY_INTERNAL_SEQ PRIMARY_POSITION_CODE RACE_AFAMER RACE_AMERIND_ALASKAN RACE_ASIAN RACE_HAWAIIAN_PACISLANDER RACE_WHITE RowUpdatedOn
55587 19690514 C D X 20020903 3 N W N MONIQUE F F WILKINSON 0 M 12 32 593324647 INSTRUCTIONAL DESIGNER 9 001512 false N 3 00000000 N 2219 7 8290 N N N N Y 2017-02-06T11:34:29.38-05:00
38415 19760427 P D X 20090316 6 N B N STEVE F M BARRETT 0 L 12 34 594414377 GROUNDSKEEPER LEAD 9 001512 false N 3 00000000 X 2320 6 5423 Y N N N N 2017-02-06T11:34:29.38-05:00
19661118 C C A 20130822 3 N W Y LISA P F ESTRADA 0 Z 25 820014761 175773 9 001512 false Y 3 00000000 N 4806 1 CPE1ADJS N N N N Y 2017-02-20T16:52:30.679-05:00
41126 19621230 C D X 20150116 3 N H N ROBERTO F M CARBALLOSO 0 M 12 24 267874078 POST SECONDARY ADVISOR 9 001512 false N 3 00000000 Y 1359 1 8031 N N N N Y 2017-02-06T11:34:29.224-05:00
19300524 C C A 19771206 1 N W Y ARLENE P F RAMEY 0 25 820000709 177088 9 001512 false Y 3 00000000 N 2576 68 HLT5ADJS N N N N Y 2017-02-20T16:52:09.416-05:00
41126 19600712 C D X 20150601 6 N W N CLIFTON F M WELLS 0 W 12 37 262676581 VEHICLE EQUIP MECHANIC 9 001512 false N 3 00000000 N 1089 3 AA5016 N N N N Y 2017-02-06T11:34:29.209-05:00
52967 19751201 P X A 20090819 3 N B Y ROSE F F WILSON 0 A 9 25 591969530 ASSOCIATE PROFESSOR 4 001512 false N 1 20120821 N 2093 6 3038 Y N N N N 2017-02-06T11:34:29.365-05:00
19700718 C A 20160823 1 N X Y PHILIP P M VENTURA 0 R 25 104620190 217875 7 001512 false Y 3 00000000 N 510 1 CSE5ADJS X X X X X 2017-02-06T11:34:29.146-05:00
77259 19560909 C D X 20080602 4 N W N JOHN F M SMITH 0 E 12 34 221420829 SECURITY & RISK MGMT DIRE 9 001512 true N 3 00000000 N 920 11 5919 N N N N Y 2017-02-06T11:34:29.162-05:00
19940427 P D X 20130104 6 N B N BRITNEY P F SHASHA 0 K 39 820014271 TUTOR 9 001512 false Y 3 00000000 N 4565 3 SLC2TUTR Y N N N N 2017-02-20T16:52:29.057-05:00
Powered by BI Documenter