dbo.BRG3

Description

Properties

Name	Value
File Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	0
Created	3/6/2025 6:55:52 PM
Last Modified	3/6/2025 6:55:52 PM

Columns

Name	Data Type	Length	Not Null	Computed	Persisted
BUSINESS_GROUP	varchar	50	False	False	False
LATEST_START_DATE	varchar	50	False	False	False
ORIGINAL_START_DATE	varchar	50	False	False	False
PERSON_ID	varchar	50	False	False	False
EMAIL_ADDRESS	varchar	50	False	False	False
EMPLOYEE_NUMBER	varchar	50	False	False	False
ASSIGNMENT_NUMBER	varchar	50	False	False	False
FULL_NAME	varchar	50	False	False	False
FIRST_NAME	varchar	50	False	False	False
LAST_NAME	varchar	50	False	False	False
MIDDLE_NAMES	varchar	50	False	False	False
GENDER	varchar	50	False	False	False
PATERNAL_LAST_NAME	varchar	50	False	False	False
MATERNAL_LAST_NAME	varchar	50	False	False	False
USER_PERSON_TYPE	varchar	50	False	False	False
DATE_OF_BIRTH	varchar	50	False	False	False
NATIONAL_IDENTIFIER	varchar	50	False	False	False
ACTUAL_TERMINATION_DATE	varchar	50	False	False	False
COMPANY	varchar	50	False	False	False
JOB_TITLE	varchar	50	False	False	False
ADDRESS_LINE1	varchar	50	False	False	False
ADDRESS_LINE2	varchar	50	False	False	False
ADDRESS_LINE3	varchar	50	False	False	False
ADDRESS_TYPE	varchar	50	False	False	False
POSTAL_CODE	varchar	50	False	False	False
REGION_1	varchar	50	False	False	False
REGION_2	varchar	50	False	False	False

SQL Script

Copy

CREATE TABLE dbo.BRG3 (
  BUSINESS_GROUP varchar(50) NULL,
  LATEST_START_DATE varchar(50) NULL,
  ORIGINAL_START_DATE varchar(50) NULL,
  PERSON_ID varchar(50) NULL,
  EMAIL_ADDRESS varchar(50) NULL,
  EMPLOYEE_NUMBER varchar(50) NULL,
  ASSIGNMENT_NUMBER varchar(50) NULL,
  FULL_NAME varchar(50) NULL,
  FIRST_NAME varchar(50) NULL,
  LAST_NAME varchar(50) NULL,
  MIDDLE_NAMES varchar(50) NULL,
  GENDER varchar(50) NULL,
  PATERNAL_LAST_NAME varchar(50) NULL,
  MATERNAL_LAST_NAME varchar(50) NULL,
  USER_PERSON_TYPE varchar(50) NULL,
  DATE_OF_BIRTH varchar(50) NULL,
  NATIONAL_IDENTIFIER varchar(50) NULL,
  ACTUAL_TERMINATION_DATE varchar(50) NULL,
  COMPANY varchar(50) NULL,
  JOB_TITLE varchar(50) NULL,
  ADDRESS_LINE1 varchar(50) NULL,
  ADDRESS_LINE2 varchar(50) NULL,
  ADDRESS_LINE3 varchar(50) NULL,
  ADDRESS_TYPE varchar(50) NULL,
  POSTAL_CODE varchar(50) NULL,
  REGION_1 varchar(50) NULL,
  REGION_2 varchar(50) NULL
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found