March 4, 2016 at 9:04 am
Hello,
I am working at college. We using one ERP software called Jenzabar. Somehow advising tab is not populating properly in Jenzabar so I am trying to populate advising tab through backend side means SQL server side.
I want to transfer advisors from student_div_master to advisor_stud_table but because of null values I get an error.
advisor_stud_table has primary key. Is there any other way to copy some columns from one table to another including null values
update advisor_stud_table set advisor_stud_table.advisor_id=student_div_mast.advisor_id_num from advisor_stud_table,student_div_mast where advisor_stud_table.id_num=student_div_mast.ID_NUM;
Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'ADVISOR_ID', table 'TmsEPly.dbo.ADVISOR_STUD_TABLE'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
March 4, 2016 at 9:22 am
ripas (3/4/2016)
Hello,I want to transfer advisors from student_div_master to advisor_stud_table but because of null values I get an error.
advisor_stud_table has primary key. Is there any other way to copy some columns from one table to another including null values
update advisor_stud_table set advisor_stud_table.advisor_id=student_div_mast.advisor_id_num from advisor_stud_table,student_div_mast where advisor_stud_table.id_num=student_div_mast.ID_NUM;
Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'ADVISOR_ID', table 'TmsEPly.dbo.ADVISOR_STUD_TABLE'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
The error really says it all. If the requirements allow for NULL in TmsEPly.dbo.ADVISOR_STUD_TABLE.ADVISOR_ID then the only way to put NULL in that column is to change the column to allow NULL.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 4, 2016 at 9:30 am
ripas (3/4/2016)
Hello,I want to transfer advisors from student_div_master to advisor_stud_table but because of null values I get an error.
advisor_stud_table has primary key. Is there any other way to copy some columns from one table to another including null values
update advisor_stud_table set advisor_stud_table.advisor_id=student_div_mast.advisor_id_num from advisor_stud_table,student_div_mast where advisor_stud_table.id_num=student_div_mast.ID_NUM;
Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'ADVISOR_ID', table 'TmsEPly.dbo.ADVISOR_STUD_TABLE'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
You need to determine what (non-NULL) value column Advisor_Id should contain if there is no advisor.
Or, as Jack suggested, modify the definition of the column in the database to allow NULLs.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
March 4, 2016 at 9:33 am
I couldn't set that allow null property. It has primary key...
Is there any other way to do this?
March 4, 2016 at 9:39 am
There isn't enough information to provide what is going to be the right answer but are here are a couple of options:
/* This eliminates rows where advisor_id is null in the source table */
UPDATE
advisor_stud_table
SET
advisor_stud_table.advisor_id = student_div_mast.advisor_id_num
FROM
student_div_mast
WHERE
advisor_stud_table.id_num = student_div_mast.ID_NUM AND
student_div_mast.advisor_id_num IS NOT NULL;
/* This provides a default advisor_id when it is null in the source table */
UPDATE
advisor_stud_table
SET
advisor_stud_table.advisor_id = ISNULL(student_div_mast.advisor_id_num, 1)
FROM
student_div_mast
WHERE
advisor_stud_table.id_num = student_div_mast.ID_NUM;
The first query is the one I think is most likely correct.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 4, 2016 at 9:57 am
Hello,
I also tried this before but sorry to say that I forgot to mention.
I just executed first query and we have some duplicate student ids so I get following error:
UPDATE
advisor_stud_table
SET
advisor_stud_table.advisor_id = student_div_mast.advisor_id_num
FROM
student_div_mast
WHERE
advisor_stud_table.id_num = student_div_mast.ID_NUM AND
student_div_mast.advisor_id_num IS NOT NULL;
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_ADVISOR_STUD_TABLE'. Cannot insert duplicate key in object 'dbo.ADVISOR_STUD_TABLE'. The duplicate key value is (4302884, 4357170, 3).
The statement has been terminated.
March 4, 2016 at 11:06 am
Without more information all we'd be doing is throwing stuff at the problem and seeing what sticks. Please read the first 2 articles linked in my signature and post the relevant information like schema, test data, and requirements.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 4, 2016 at 11:19 am
OK, I am sending you whole table information:
This one is for ADVISOR_STUD_TABLE
USE [TmsEPly]
GO
/****** Object: Table [dbo].[ADVISOR_STUD_TABLE] Script Date: 3/4/2016 11:16:35 AM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[ADVISOR_STUD_TABLE](
[APPID] [int] NOT NULL,
[ADVISOR_ID] [int] NOT NULL,
[ID_NUM] [int] NOT NULL,
[DIV_CDE] [char](2) NULL,
[SEQ_NUM] [int] NOT NULL,
[ADVISOR_NUM] [int] NOT NULL,
[ADVISOR_TYPE] [char](5) NULL,
[ADVISOR_TABLE_STS] [char](1) NOT NULL,
[SESS_CDE] [char](8) NULL,
[YR_CDE] [char](4) NULL,
[TRM_CDE] [char](2) NULL,
[SECURITY_CLASS_1] [char](8) NULL,
[SECURITY_CLASS_2] [char](8) NULL,
[SECURITY_CLASS_3] [char](8) NULL,
[COMMENT_TXT] [char](30) NULL,
[BEGIN_DTE] [datetime] NULL,
[END_DTE] [datetime] NULL,
[ADV_GRP_CDE] [varchar](15) NULL,
[APPROWVERSION] [timestamp] NOT NULL,
[USER_NAME] [varchar](513) NULL,
[JOB_NAME] [varchar](30) NULL,
[JOB_TIME] [datetime] NULL,
CONSTRAINT [PK_ADVISOR_STUD_TABLE] PRIMARY KEY CLUSTERED
(
[ADVISOR_ID] ASC,
[ID_NUM] ASC,
[SEQ_NUM] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] ADD DEFAULT (NEXT VALUE FOR [ADVISOR_STUD_TABLE_SEQ]) FOR [APPID]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] ADD DEFAULT ((0)) FOR [ADVISOR_NUM]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] ADD DEFAULT ('A') FOR [ADVISOR_TABLE_STS]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_101] FOREIGN KEY([ADV_GRP_CDE])
REFERENCES [dbo].[ADVISING_GROUP_DEF] ([ADV_GRP_CDE])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_101]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_2455] FOREIGN KEY([ADVISOR_ID])
REFERENCES [dbo].[ADVISOR_MASTER] ([ADVISOR_ID])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_2455]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_2458] FOREIGN KEY([ID_NUM])
REFERENCES [dbo].[ADV_MASTER] ([ID_NUM])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_2458]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_2495] FOREIGN KEY([ADVISOR_TYPE])
REFERENCES [dbo].[ADVISOR_TYPE_DEF] ([ADVISOR_TYPE])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_2495]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_3480] FOREIGN KEY([TRM_CDE])
REFERENCES [dbo].[TERM_DEF] ([TRM_CDE])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_3480]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_3483] FOREIGN KEY([YR_CDE])
REFERENCES [dbo].[YEAR_DEF] ([YR_CDE])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_3483]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_7788] FOREIGN KEY([DIV_CDE])
REFERENCES [dbo].[DIVISION_DEF] ([DIV_CDE])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_7788]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [CKC_USER_NAME_ADVISOR_STUD_TABLE] CHECK ((len([USER_NAME])<(16)))
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [CKC_USER_NAME_ADVISOR_STUD_TABLE]
GO
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STudent_DIV_Mast
USE [TmsEPly]
GO
/****** Object: Table [dbo].[STUDENT_DIV_MAST] Script Date: 3/4/2016 11:18:40 AM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[STUDENT_DIV_MAST](
[APPID] [int] NOT NULL,
[ID_NUM] [int] NOT NULL,
[DIV_CDE] [char](2) NOT NULL,
[CLASS_CDE] [char](2) NULL,
[ADVISOR_ID_NUM] [int] NULL,
[NUM_TRANSCR_COPIES] [int] NOT NULL,
[CLASS_RANK] [char](5) NULL,
[CLASS_RANK_HI_RANG] [char](5) NULL,
[CLASS_SIZE] [char](5) NULL,
[CERTIFICATION] [char](5) NULL,
[GRAD_HONORS_1] [char](5) NULL,
[GRAD_HONORS_2] [char](5) NULL,
[GRAD_HONORS_3] [char](5) NULL,
[GRAD_HONORS_4] [char](5) NULL,
[EXPECTED_GRAD_YR] [char](4) NULL,
[EXPECTED_GRAD_TRM] [char](2) NULL,
[ENTRY_DTE] [datetime] NULL,
[EXIT_DTE] [datetime] NULL,
[EXIT_REASON] [char](2) NULL,
[RE_ENTRY_DTE] [datetime] NULL,
[NUM_LEAVE_OF_ABS] [int] NOT NULL,
[LAST_LEAVE_OF_ABS] [datetime] NULL,
[LAST_YR_ACAD_UPD] [char](4) NULL,
[LAST_TRM_ACAD_UPD] [char](2) NULL,
[LAST_ACADEMIC_UPD] [datetime] NULL,
[LAST_GRADE_RPT] [datetime] NULL,
[LAST_YR_REG] [char](4) NULL,
[LAST_TRM_REG] [char](2) NULL,
[XFER_HRS_ATTEMPTED] [numeric](5, 2) NOT NULL,
[XFER_RS_EARNED] [numeric](5, 2) NOT NULL,
[XFER_HRS_GPA] [numeric](5, 2) NOT NULL,
[XFER_QUAL_PTS] [numeric](7, 2) NOT NULL,
[XFER_GPA] [numeric](7, 4) NOT NULL,
[LOCAL_HRS_ATTEMPT] [numeric](5, 2) NOT NULL,
[LOCAL_HRS_EARNED] [numeric](5, 2) NOT NULL,
[LOCAL_HRS_GPA] [numeric](5, 2) NOT NULL,
[LOCAL_QUAL_PTS] [numeric](7, 2) NOT NULL,
[LOCAL_GPA] [numeric](7, 4) NOT NULL,
[CAREER_HRS_ATTEMPT] [numeric](5, 2) NOT NULL,
[CAREER_HRS_EARNED] [numeric](5, 2) NOT NULL,
[CAREER_HRS_GPA] [numeric](5, 2) NOT NULL,
[CAREER_QUAL_PTS] [numeric](7, 2) NOT NULL,
[CAREER_GPA] [numeric](7, 4) NOT NULL,
[TRM_HRS_ATTEMPT] [numeric](5, 2) NOT NULL,
[TRM_HRS_EARNED] [numeric](5, 2) NOT NULL,
[TRM_HRS_GPA] [numeric](5, 2) NOT NULL,
[TRM_QUAL_PTS] [numeric](7, 2) NOT NULL,
[TRM_GPA] [numeric](7, 4) NOT NULL,
[WRK_HRS_ATTEMPT_1] [numeric](5, 2) NOT NULL,
[WRK_HRS_EARNED_1] [numeric](5, 2) NOT NULL,
[WRK_HRS_GPA_1] [numeric](5, 2) NOT NULL,
[WRK_QUAL_PTS_1] [numeric](7, 2) NOT NULL,
[WRK_GPA_1] [numeric](7, 4) NOT NULL,
[WRK_HRS_ATTEMPT_2] [numeric](5, 2) NOT NULL,
[WRK_HRS_EARNED_2] [numeric](5, 2) NOT NULL,
[WRK_HRS_GPA_2] [numeric](5, 2) NOT NULL,
[WRK_QUAL_PTS_2] [numeric](7, 2) NOT NULL,
[WRK_GPA_2] [numeric](7, 4) NOT NULL,
[CAREER_CRTYPE1_HRS] [numeric](5, 2) NOT NULL,
[CAREER_CRTYPE2_HRS] [numeric](5, 2) NOT NULL,
[CAREER_CRTYPE3_HRS] [numeric](5, 2) NOT NULL,
[TRM_CRTYPE1_HRS] [numeric](5, 2) NOT NULL,
[TRM_CRTYPE2_HRS] [numeric](5, 2) NOT NULL,
[TRM_CRTYPE3_HRS] [numeric](5, 2) NOT NULL,
[CAREER_GRADE_1_HRS] [numeric](5, 2) NOT NULL,
[CAREER_GRADE_2_HRS] [numeric](5, 2) NOT NULL,
[CAREER_GRADE_3_HRS] [numeric](5, 2) NOT NULL,
[CAREER_GRADE_4_HRS] [numeric](5, 2) NOT NULL,
[CAREER_GRADE_5_HRS] [numeric](5, 2) NOT NULL,
[CAREER_GRADE_6_HRS] [numeric](5, 2) NOT NULL,
[TRM_GRADE_1_HRS] [numeric](5, 2) NOT NULL,
[TRM_GRADE_2_HRS] [numeric](5, 2) NOT NULL,
[TRM_GRADE_3_HRS] [numeric](5, 2) NOT NULL,
[TRM_GRADE_4_HRS] [numeric](5, 2) NOT NULL,
[TRM_GRADE_5_HRS] [numeric](5, 2) NOT NULL,
[TRM_GRADE_6_HRS] [numeric](5, 2) NOT NULL,
[ADVISOR_ID_NUM_2] [int] NULL,
[ADVISOR_ID_NUM_3] [int] NULL,
[TRANSFER_IN] [char](1) NOT NULL,
[FIRST_TIME_POST_SECONDARY] [char](1) NOT NULL,
[ADV_GRP_CDE] [varchar](15) NULL,
[FT_TR_YEAR_DEF_APPID] [int] NULL,
[FT_TR_TERM_DEF_APPID] [int] NULL,
[COHORT_DEFINITION_APPID] [int] NULL,
[TRANSFERRED_TO_ID_NUM] [int] NULL,
[VERIFIED] [char](1) NOT NULL,
[VERIFIED_BY] [char](15) NULL,
[DATE_VERIFIED] [datetime] NULL,
[NOTES] [varchar](150) NULL,
[UDEF_1A_1] [char](1) NULL,
[UDEF_1A_2] [char](1) NULL,
[UDEF_1A_3] [char](1) NULL,
[UDEF_1A_4] [char](1) NULL,
[UDEF_1A_5] [char](1) NULL,
[UDEF_2A_1] [char](2) NULL,
[UDEF_2A_2] [char](2) NULL,
[UDEF_2A_3] [char](2) NULL,
[UDEF_3A_1] [char](3) NULL,
[UDEF_3A_2] [char](3) NULL,
[UDEF_3A_3] [char](3) NULL,
[UDEF_5A_1] [char](5) NULL,
[UDEF_5A_2] [char](5) NULL,
[UDEF_HRS_GPA] [numeric](5, 2) NOT NULL,
[UDEF_QUAL_PTS] [numeric](7, 2) NOT NULL,
[UDEF_GPA] [numeric](7, 4) NOT NULL,
[UDEF_DTE_1] [datetime] NULL,
[UDEF_DTE_2] [datetime] NULL,
[UDEF_DTE_3] [datetime] NULL,
[DEF_DTE_4] [datetime] NULL,
[UDEF_3_2_1] [numeric](3, 2) NOT NULL,
[UDEF_3_2_2] [numeric](3, 2) NOT NULL,
[UDEF_5_2_1] [numeric](5, 2) NOT NULL,
[UDEF_5_2_2] [numeric](5, 2) NOT NULL,
[UDEF_5_2_3] [numeric](5, 2) NOT NULL,
[UDEF_5_2_4] [numeric](5, 2) NOT NULL,
[UDEF_ID_NUM] [int] NULL,
[APPROWVERSION] [timestamp] NOT NULL,
[USER_NAME] [varchar](513) NULL,
[JOB_NAME] [varchar](30) NULL,
[JOB_TIME] [datetime] NULL,
CONSTRAINT [PK_STUDENT_DIV_MAST] PRIMARY KEY CLUSTERED
(
[APPID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT (NEXT VALUE FOR [STUDENT_DIV_MAST_SEQ]) FOR [APPID]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [NUM_TRANSCR_COPIES]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [NUM_LEAVE_OF_ABS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [XFER_HRS_ATTEMPTED]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [XFER_RS_EARNED]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [XFER_HRS_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [XFER_QUAL_PTS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [XFER_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [LOCAL_HRS_ATTEMPT]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [LOCAL_HRS_EARNED]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [LOCAL_HRS_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [LOCAL_QUAL_PTS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [LOCAL_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_HRS_ATTEMPT]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_HRS_EARNED]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_HRS_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_QUAL_PTS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_HRS_ATTEMPT]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_HRS_EARNED]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_HRS_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_QUAL_PTS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_HRS_ATTEMPT_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_HRS_EARNED_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_HRS_GPA_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_QUAL_PTS_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_GPA_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_HRS_ATTEMPT_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_HRS_EARNED_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_HRS_GPA_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_QUAL_PTS_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_GPA_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_CRTYPE1_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_CRTYPE2_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_CRTYPE3_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_CRTYPE1_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_CRTYPE2_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_CRTYPE3_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GRADE_1_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GRADE_2_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GRADE_3_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GRADE_4_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GRADE_5_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GRADE_6_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GRADE_1_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GRADE_2_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GRADE_3_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GRADE_4_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GRADE_5_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GRADE_6_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ('N') FOR [TRANSFER_IN]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ('N') FOR [FIRST_TIME_POST_SECONDARY]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ('N') FOR [VERIFIED]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_HRS_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_QUAL_PTS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_3_2_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_3_2_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_5_2_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_5_2_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_5_2_3]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_5_2_4]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_111905] FOREIGN KEY([CERTIFICATION])
REFERENCES [dbo].[CERTIFICATION_DEF] ([CERT_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_111905]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_111929] FOREIGN KEY([GRAD_HONORS_1])
REFERENCES [dbo].[HONOR_DEFINITION] ([HONOR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_111929]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_111933] FOREIGN KEY([GRAD_HONORS_3])
REFERENCES [dbo].[HONOR_DEFINITION] ([HONOR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_111933]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_111936] FOREIGN KEY([GRAD_HONORS_4])
REFERENCES [dbo].[HONOR_DEFINITION] ([HONOR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_111936]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_111939] FOREIGN KEY([GRAD_HONORS_2])
REFERENCES [dbo].[HONOR_DEFINITION] ([HONOR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_111939]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_20150605002] FOREIGN KEY([FT_TR_YEAR_DEF_APPID])
REFERENCES [dbo].[YEAR_DEF] ([APPID])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_20150605002]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_20150605003] FOREIGN KEY([FT_TR_TERM_DEF_APPID])
REFERENCES [dbo].[TERM_DEF] ([APPID])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_20150605003]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_20150605004] FOREIGN KEY([COHORT_DEFINITION_APPID])
REFERENCES [dbo].[COHORT_DEFINITION] ([APPID])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_20150605004]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_20151116001] FOREIGN KEY([VERIFIED_BY])
REFERENCES [dbo].[APP_USER] ([USER_ID])
ON UPDATE CASCADE
ON DELETE SET NULL
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_20151116001]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3320] FOREIGN KEY([CLASS_CDE])
REFERENCES [dbo].[CLASS_DEFINITION] ([CLASS_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3320]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3329] FOREIGN KEY([EXPECTED_GRAD_TRM])
REFERENCES [dbo].[TERM_DEF] ([TRM_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3329]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3332] FOREIGN KEY([LAST_TRM_ACAD_UPD])
REFERENCES [dbo].[TERM_DEF] ([TRM_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3332]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3335] FOREIGN KEY([LAST_TRM_REG])
REFERENCES [dbo].[TERM_DEF] ([TRM_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3335]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3338] FOREIGN KEY([EXPECTED_GRAD_YR])
REFERENCES [dbo].[YEAR_DEF] ([YR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3338]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3341] FOREIGN KEY([LAST_YR_ACAD_UPD])
REFERENCES [dbo].[YEAR_DEF] ([YR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3341]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3344] FOREIGN KEY([LAST_YR_REG])
REFERENCES [dbo].[YEAR_DEF] ([YR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3344]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3507] FOREIGN KEY([ADV_GRP_CDE])
REFERENCES [dbo].[ADVISING_GROUP_DEF] ([ADV_GRP_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3507]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_98545] FOREIGN KEY([ID_NUM])
REFERENCES [dbo].[STUDENT_MASTER] ([ID_NUM])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_98545]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_98548] FOREIGN KEY([DIV_CDE])
REFERENCES [dbo].[DIVISION_DEF] ([DIV_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_98548]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_98602] FOREIGN KEY([UDEF_ID_NUM])
REFERENCES [dbo].[NAME_MASTER] ([ID_NUM])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_98602]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_99246] FOREIGN KEY([ADVISOR_ID_NUM])
REFERENCES [dbo].[NAME_MASTER] ([ID_NUM])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_99246]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_99251] FOREIGN KEY([ADVISOR_ID_NUM_3])
REFERENCES [dbo].[NAME_MASTER] ([ID_NUM])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_99251]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_99254] FOREIGN KEY([ADVISOR_ID_NUM_2])
REFERENCES [dbo].[NAME_MASTER] ([ID_NUM])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_99254]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [CKC_USER_NAME_STUDENT_DIV_MAST] CHECK ((len([USER_NAME])<(16)))
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [CKC_USER_NAME_STUDENT_DIV_MAST]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [CKC_VERIFIED_STUDENT_DIV_MAST] CHECK (([VERIFIED]='N' OR [VERIFIED]='Y'))
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [CKC_VERIFIED_STUDENT_DIV_MAST]
GO
Thanks
March 4, 2016 at 11:29 am
ripas (3/4/2016)
I couldn't set that allow null property. It has primary key...Is there any other way to do this?
No, you cannot force NULLs into a column that has been defined as NOT NULL.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
March 4, 2016 at 11:36 am
Ok. Advisor_stud_table information
USE [TmsEPly]
GO
/****** Object: Table [dbo].[ADVISOR_STUD_TABLE] Script Date: 3/4/2016 11:16:35 AM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[ADVISOR_STUD_TABLE](
[APPID] [int] NOT NULL,
[ADVISOR_ID] [int] NOT NULL,
[ID_NUM] [int] NOT NULL,
[DIV_CDE] [char](2) NULL,
[SEQ_NUM] [int] NOT NULL,
[ADVISOR_NUM] [int] NOT NULL,
[ADVISOR_TYPE] [char](5) NULL,
[ADVISOR_TABLE_STS] [char](1) NOT NULL,
[SESS_CDE] [char](8) NULL,
[YR_CDE] [char](4) NULL,
[TRM_CDE] [char](2) NULL,
[SECURITY_CLASS_1] [char](8) NULL,
[SECURITY_CLASS_2] [char](8) NULL,
[SECURITY_CLASS_3] [char](8) NULL,
[COMMENT_TXT] [char](30) NULL,
[BEGIN_DTE] [datetime] NULL,
[END_DTE] [datetime] NULL,
[ADV_GRP_CDE] [varchar](15) NULL,
[APPROWVERSION] [timestamp] NOT NULL,
[USER_NAME] [varchar](513) NULL,
[JOB_NAME] [varchar](30) NULL,
[JOB_TIME] [datetime] NULL,
CONSTRAINT [PK_ADVISOR_STUD_TABLE] PRIMARY KEY CLUSTERED
(
[ADVISOR_ID] ASC,
[ID_NUM] ASC,
[SEQ_NUM] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] ADD DEFAULT (NEXT VALUE FOR [ADVISOR_STUD_TABLE_SEQ]) FOR [APPID]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] ADD DEFAULT ((0)) FOR [ADVISOR_NUM]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] ADD DEFAULT ('A') FOR [ADVISOR_TABLE_STS]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_101] FOREIGN KEY([ADV_GRP_CDE])
REFERENCES [dbo].[ADVISING_GROUP_DEF] ([ADV_GRP_CDE])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_101]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_2455] FOREIGN KEY([ADVISOR_ID])
REFERENCES [dbo].[ADVISOR_MASTER] ([ADVISOR_ID])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_2455]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_2458] FOREIGN KEY([ID_NUM])
REFERENCES [dbo].[ADV_MASTER] ([ID_NUM])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_2458]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_2495] FOREIGN KEY([ADVISOR_TYPE])
REFERENCES [dbo].[ADVISOR_TYPE_DEF] ([ADVISOR_TYPE])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_2495]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_3480] FOREIGN KEY([TRM_CDE])
REFERENCES [dbo].[TERM_DEF] ([TRM_CDE])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_3480]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_3483] FOREIGN KEY([YR_CDE])
REFERENCES [dbo].[YEAR_DEF] ([YR_CDE])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_3483]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [AV_REF_7788] FOREIGN KEY([DIV_CDE])
REFERENCES [dbo].[DIVISION_DEF] ([DIV_CDE])
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [AV_REF_7788]
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] WITH CHECK ADD CONSTRAINT [CKC_USER_NAME_ADVISOR_STUD_TABLE] CHECK ((len([USER_NAME])<(16)))
GO
ALTER TABLE [dbo].[ADVISOR_STUD_TABLE] CHECK CONSTRAINT [CKC_USER_NAME_ADVISOR_STUD_TABLE]
GO
student_div_mast table information:
USE [TmsEPly]
GO
/****** Object: Table [dbo].[STUDENT_DIV_MAST] Script Date: 3/4/2016 11:18:40 AM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[STUDENT_DIV_MAST](
[APPID] [int] NOT NULL,
[ID_NUM] [int] NOT NULL,
[DIV_CDE] [char](2) NOT NULL,
[CLASS_CDE] [char](2) NULL,
[ADVISOR_ID_NUM] [int] NULL,
[NUM_TRANSCR_COPIES] [int] NOT NULL,
[CLASS_RANK] [char](5) NULL,
[CLASS_RANK_HI_RANG] [char](5) NULL,
[CLASS_SIZE] [char](5) NULL,
[CERTIFICATION] [char](5) NULL,
[GRAD_HONORS_1] [char](5) NULL,
[GRAD_HONORS_2] [char](5) NULL,
[GRAD_HONORS_3] [char](5) NULL,
[GRAD_HONORS_4] [char](5) NULL,
[EXPECTED_GRAD_YR] [char](4) NULL,
[EXPECTED_GRAD_TRM] [char](2) NULL,
[ENTRY_DTE] [datetime] NULL,
[EXIT_DTE] [datetime] NULL,
[EXIT_REASON] [char](2) NULL,
[RE_ENTRY_DTE] [datetime] NULL,
[NUM_LEAVE_OF_ABS] [int] NOT NULL,
[LAST_LEAVE_OF_ABS] [datetime] NULL,
[LAST_YR_ACAD_UPD] [char](4) NULL,
[LAST_TRM_ACAD_UPD] [char](2) NULL,
[LAST_ACADEMIC_UPD] [datetime] NULL,
[LAST_GRADE_RPT] [datetime] NULL,
[LAST_YR_REG] [char](4) NULL,
[LAST_TRM_REG] [char](2) NULL,
[XFER_HRS_ATTEMPTED] [numeric](5, 2) NOT NULL,
[XFER_RS_EARNED] [numeric](5, 2) NOT NULL,
[XFER_HRS_GPA] [numeric](5, 2) NOT NULL,
[XFER_QUAL_PTS] [numeric](7, 2) NOT NULL,
[XFER_GPA] [numeric](7, 4) NOT NULL,
[LOCAL_HRS_ATTEMPT] [numeric](5, 2) NOT NULL,
[LOCAL_HRS_EARNED] [numeric](5, 2) NOT NULL,
[LOCAL_HRS_GPA] [numeric](5, 2) NOT NULL,
[LOCAL_QUAL_PTS] [numeric](7, 2) NOT NULL,
[LOCAL_GPA] [numeric](7, 4) NOT NULL,
[CAREER_HRS_ATTEMPT] [numeric](5, 2) NOT NULL,
[CAREER_HRS_EARNED] [numeric](5, 2) NOT NULL,
[CAREER_HRS_GPA] [numeric](5, 2) NOT NULL,
[CAREER_QUAL_PTS] [numeric](7, 2) NOT NULL,
[CAREER_GPA] [numeric](7, 4) NOT NULL,
[TRM_HRS_ATTEMPT] [numeric](5, 2) NOT NULL,
[TRM_HRS_EARNED] [numeric](5, 2) NOT NULL,
[TRM_HRS_GPA] [numeric](5, 2) NOT NULL,
[TRM_QUAL_PTS] [numeric](7, 2) NOT NULL,
[TRM_GPA] [numeric](7, 4) NOT NULL,
[WRK_HRS_ATTEMPT_1] [numeric](5, 2) NOT NULL,
[WRK_HRS_EARNED_1] [numeric](5, 2) NOT NULL,
[WRK_HRS_GPA_1] [numeric](5, 2) NOT NULL,
[WRK_QUAL_PTS_1] [numeric](7, 2) NOT NULL,
[WRK_GPA_1] [numeric](7, 4) NOT NULL,
[WRK_HRS_ATTEMPT_2] [numeric](5, 2) NOT NULL,
[WRK_HRS_EARNED_2] [numeric](5, 2) NOT NULL,
[WRK_HRS_GPA_2] [numeric](5, 2) NOT NULL,
[WRK_QUAL_PTS_2] [numeric](7, 2) NOT NULL,
[WRK_GPA_2] [numeric](7, 4) NOT NULL,
[CAREER_CRTYPE1_HRS] [numeric](5, 2) NOT NULL,
[CAREER_CRTYPE2_HRS] [numeric](5, 2) NOT NULL,
[CAREER_CRTYPE3_HRS] [numeric](5, 2) NOT NULL,
[TRM_CRTYPE1_HRS] [numeric](5, 2) NOT NULL,
[TRM_CRTYPE2_HRS] [numeric](5, 2) NOT NULL,
[TRM_CRTYPE3_HRS] [numeric](5, 2) NOT NULL,
[CAREER_GRADE_1_HRS] [numeric](5, 2) NOT NULL,
[CAREER_GRADE_2_HRS] [numeric](5, 2) NOT NULL,
[CAREER_GRADE_3_HRS] [numeric](5, 2) NOT NULL,
[CAREER_GRADE_4_HRS] [numeric](5, 2) NOT NULL,
[CAREER_GRADE_5_HRS] [numeric](5, 2) NOT NULL,
[CAREER_GRADE_6_HRS] [numeric](5, 2) NOT NULL,
[TRM_GRADE_1_HRS] [numeric](5, 2) NOT NULL,
[TRM_GRADE_2_HRS] [numeric](5, 2) NOT NULL,
[TRM_GRADE_3_HRS] [numeric](5, 2) NOT NULL,
[TRM_GRADE_4_HRS] [numeric](5, 2) NOT NULL,
[TRM_GRADE_5_HRS] [numeric](5, 2) NOT NULL,
[TRM_GRADE_6_HRS] [numeric](5, 2) NOT NULL,
[ADVISOR_ID_NUM_2] [int] NULL,
[ADVISOR_ID_NUM_3] [int] NULL,
[TRANSFER_IN] [char](1) NOT NULL,
[FIRST_TIME_POST_SECONDARY] [char](1) NOT NULL,
[ADV_GRP_CDE] [varchar](15) NULL,
[FT_TR_YEAR_DEF_APPID] [int] NULL,
[FT_TR_TERM_DEF_APPID] [int] NULL,
[COHORT_DEFINITION_APPID] [int] NULL,
[TRANSFERRED_TO_ID_NUM] [int] NULL,
[VERIFIED] [char](1) NOT NULL,
[VERIFIED_BY] [char](15) NULL,
[DATE_VERIFIED] [datetime] NULL,
[NOTES] [varchar](150) NULL,
[UDEF_1A_1] [char](1) NULL,
[UDEF_1A_2] [char](1) NULL,
[UDEF_1A_3] [char](1) NULL,
[UDEF_1A_4] [char](1) NULL,
[UDEF_1A_5] [char](1) NULL,
[UDEF_2A_1] [char](2) NULL,
[UDEF_2A_2] [char](2) NULL,
[UDEF_2A_3] [char](2) NULL,
[UDEF_3A_1] [char](3) NULL,
[UDEF_3A_2] [char](3) NULL,
[UDEF_3A_3] [char](3) NULL,
[UDEF_5A_1] [char](5) NULL,
[UDEF_5A_2] [char](5) NULL,
[UDEF_HRS_GPA] [numeric](5, 2) NOT NULL,
[UDEF_QUAL_PTS] [numeric](7, 2) NOT NULL,
[UDEF_GPA] [numeric](7, 4) NOT NULL,
[UDEF_DTE_1] [datetime] NULL,
[UDEF_DTE_2] [datetime] NULL,
[UDEF_DTE_3] [datetime] NULL,
[DEF_DTE_4] [datetime] NULL,
[UDEF_3_2_1] [numeric](3, 2) NOT NULL,
[UDEF_3_2_2] [numeric](3, 2) NOT NULL,
[UDEF_5_2_1] [numeric](5, 2) NOT NULL,
[UDEF_5_2_2] [numeric](5, 2) NOT NULL,
[UDEF_5_2_3] [numeric](5, 2) NOT NULL,
[UDEF_5_2_4] [numeric](5, 2) NOT NULL,
[UDEF_ID_NUM] [int] NULL,
[APPROWVERSION] [timestamp] NOT NULL,
[USER_NAME] [varchar](513) NULL,
[JOB_NAME] [varchar](30) NULL,
[JOB_TIME] [datetime] NULL,
CONSTRAINT [PK_STUDENT_DIV_MAST] PRIMARY KEY CLUSTERED
(
[APPID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT (NEXT VALUE FOR [STUDENT_DIV_MAST_SEQ]) FOR [APPID]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [NUM_TRANSCR_COPIES]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [NUM_LEAVE_OF_ABS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [XFER_HRS_ATTEMPTED]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [XFER_RS_EARNED]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [XFER_HRS_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [XFER_QUAL_PTS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [XFER_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [LOCAL_HRS_ATTEMPT]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [LOCAL_HRS_EARNED]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [LOCAL_HRS_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [LOCAL_QUAL_PTS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [LOCAL_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_HRS_ATTEMPT]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_HRS_EARNED]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_HRS_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_QUAL_PTS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_HRS_ATTEMPT]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_HRS_EARNED]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_HRS_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_QUAL_PTS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_HRS_ATTEMPT_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_HRS_EARNED_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_HRS_GPA_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_QUAL_PTS_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_GPA_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_HRS_ATTEMPT_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_HRS_EARNED_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_HRS_GPA_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_QUAL_PTS_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [WRK_GPA_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_CRTYPE1_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_CRTYPE2_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_CRTYPE3_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_CRTYPE1_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_CRTYPE2_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_CRTYPE3_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GRADE_1_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GRADE_2_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GRADE_3_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GRADE_4_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GRADE_5_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [CAREER_GRADE_6_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GRADE_1_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GRADE_2_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GRADE_3_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GRADE_4_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GRADE_5_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [TRM_GRADE_6_HRS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ('N') FOR [TRANSFER_IN]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ('N') FOR [FIRST_TIME_POST_SECONDARY]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ('N') FOR [VERIFIED]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_HRS_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_QUAL_PTS]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_GPA]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_3_2_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_3_2_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_5_2_1]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_5_2_2]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_5_2_3]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] ADD DEFAULT ((0)) FOR [UDEF_5_2_4]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_111905] FOREIGN KEY([CERTIFICATION])
REFERENCES [dbo].[CERTIFICATION_DEF] ([CERT_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_111905]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_111929] FOREIGN KEY([GRAD_HONORS_1])
REFERENCES [dbo].[HONOR_DEFINITION] ([HONOR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_111929]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_111933] FOREIGN KEY([GRAD_HONORS_3])
REFERENCES [dbo].[HONOR_DEFINITION] ([HONOR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_111933]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_111936] FOREIGN KEY([GRAD_HONORS_4])
REFERENCES [dbo].[HONOR_DEFINITION] ([HONOR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_111936]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_111939] FOREIGN KEY([GRAD_HONORS_2])
REFERENCES [dbo].[HONOR_DEFINITION] ([HONOR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_111939]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_20150605002] FOREIGN KEY([FT_TR_YEAR_DEF_APPID])
REFERENCES [dbo].[YEAR_DEF] ([APPID])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_20150605002]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_20150605003] FOREIGN KEY([FT_TR_TERM_DEF_APPID])
REFERENCES [dbo].[TERM_DEF] ([APPID])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_20150605003]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_20150605004] FOREIGN KEY([COHORT_DEFINITION_APPID])
REFERENCES [dbo].[COHORT_DEFINITION] ([APPID])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_20150605004]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_20151116001] FOREIGN KEY([VERIFIED_BY])
REFERENCES [dbo].[APP_USER] ([USER_ID])
ON UPDATE CASCADE
ON DELETE SET NULL
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_20151116001]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3320] FOREIGN KEY([CLASS_CDE])
REFERENCES [dbo].[CLASS_DEFINITION] ([CLASS_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3320]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3329] FOREIGN KEY([EXPECTED_GRAD_TRM])
REFERENCES [dbo].[TERM_DEF] ([TRM_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3329]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3332] FOREIGN KEY([LAST_TRM_ACAD_UPD])
REFERENCES [dbo].[TERM_DEF] ([TRM_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3332]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3335] FOREIGN KEY([LAST_TRM_REG])
REFERENCES [dbo].[TERM_DEF] ([TRM_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3335]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3338] FOREIGN KEY([EXPECTED_GRAD_YR])
REFERENCES [dbo].[YEAR_DEF] ([YR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3338]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3341] FOREIGN KEY([LAST_YR_ACAD_UPD])
REFERENCES [dbo].[YEAR_DEF] ([YR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3341]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3344] FOREIGN KEY([LAST_YR_REG])
REFERENCES [dbo].[YEAR_DEF] ([YR_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3344]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_3507] FOREIGN KEY([ADV_GRP_CDE])
REFERENCES [dbo].[ADVISING_GROUP_DEF] ([ADV_GRP_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_3507]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_98545] FOREIGN KEY([ID_NUM])
REFERENCES [dbo].[STUDENT_MASTER] ([ID_NUM])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_98545]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_98548] FOREIGN KEY([DIV_CDE])
REFERENCES [dbo].[DIVISION_DEF] ([DIV_CDE])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_98548]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_98602] FOREIGN KEY([UDEF_ID_NUM])
REFERENCES [dbo].[NAME_MASTER] ([ID_NUM])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_98602]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_99246] FOREIGN KEY([ADVISOR_ID_NUM])
REFERENCES [dbo].[NAME_MASTER] ([ID_NUM])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_99246]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_99251] FOREIGN KEY([ADVISOR_ID_NUM_3])
REFERENCES [dbo].[NAME_MASTER] ([ID_NUM])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_99251]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [RE_REF_99254] FOREIGN KEY([ADVISOR_ID_NUM_2])
REFERENCES [dbo].[NAME_MASTER] ([ID_NUM])
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [RE_REF_99254]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [CKC_USER_NAME_STUDENT_DIV_MAST] CHECK ((len([USER_NAME])<(16)))
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [CKC_USER_NAME_STUDENT_DIV_MAST]
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] WITH CHECK ADD CONSTRAINT [CKC_VERIFIED_STUDENT_DIV_MAST] CHECK (([VERIFIED]='N' OR [VERIFIED]='Y'))
GO
ALTER TABLE [dbo].[STUDENT_DIV_MAST] CHECK CONSTRAINT [CKC_VERIFIED_STUDENT_DIV_MAST]
GO
March 4, 2016 at 3:25 pm
Hello I just make some changes in query and it seems like its working
update ADVISOR_STUD_TABLE set advisor_stud_table.ADVISOR_ID=STUDENT_DIV_MAST.ADVISOR_ID_NUM from STUDENT_DIV_MAST
where STUDENT_DIV_MAST.ADVISOR_ID_NUM=ADVISOR_STUD_TABLE.ADVISOR_ID and
STUDENT_DIV_MAST.ADVISOR_ID_NUM is not null;
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply