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.
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.
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 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply