• Home
• org.kuali.ole
• ole-ls-sql
• 1.6.2
• source code
• OLE_CAT_RCPT_STAT_T.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.mysql.OLE_CAT_RCPT_STAT_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE OLE_CAT_RCPT_STAT_T
/
INSERT INTO OLE_CAT_RCPT_STAT_T (OBJ_ID,RCPT_STAT_CD,RCPT_STAT_ID,RCPT_STAT_NM,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('c060dfc4-7afd-4494-94e2-efebc0f09ad6','0','2','Unknown','Y','MFHD 008-06 http://www.loc.gov/marc/holdings/hd008.html',STR_TO_DATE( '20120322120000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_RCPT_STAT_T (OBJ_ID,RCPT_STAT_CD,RCPT_STAT_ID,RCPT_STAT_NM,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('01ea3439-4a85-4acf-8745-4bbcb0757da4','1','3','Other receipt or acquisition status','Y','MFHD 008-06 http://www.loc.gov/marc/holdings/hd008.html',STR_TO_DATE( '20120322120000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_RCPT_STAT_T (OBJ_ID,RCPT_STAT_CD,RCPT_STAT_ID,RCPT_STAT_NM,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('135704f7-822b-4d93-afbc-371d1ab4d7d2','2','4','Received and complete or ceased','Y','MFHD 008-06 http://www.loc.gov/marc/holdings/hd008.html',STR_TO_DATE( '20120322120000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_RCPT_STAT_T (OBJ_ID,RCPT_STAT_CD,RCPT_STAT_ID,RCPT_STAT_NM,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('e91ac912-a4be-435c-b294-514a5383559d','3','5','On order','Y','MFHD 008-06 http://www.loc.gov/marc/holdings/hd008.html',STR_TO_DATE( '20120322120000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_RCPT_STAT_T (OBJ_ID,RCPT_STAT_CD,RCPT_STAT_ID,RCPT_STAT_NM,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('1a188ac9-df55-45af-b956-90e4ac8b8b9c','4','6','Currently received','Y','MFHD 008-06 http://www.loc.gov/marc/holdings/hd008.html',STR_TO_DATE( '20120322120000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_RCPT_STAT_T (OBJ_ID,RCPT_STAT_CD,RCPT_STAT_ID,RCPT_STAT_NM,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('1be8e6f4-84fa-4a77-ae9a-bd212fbb3ca3','5','7','Not currently received','Y','MFHD 008-06 http://www.loc.gov/marc/holdings/hd008.html',STR_TO_DATE( '20120322120000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_RCPT_STAT_T (OBJ_ID,RCPT_STAT_CD,RCPT_STAT_ID,RCPT_STAT_NM,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('1be8e6f4-84fa-4a77-ae9a-bd212fbb3ca4','6','8','Not Received','Y','MFHD 008-06 http://www.loc.gov/marc/holdings/hd008.html',STR_TO_DATE( '20120322120000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_RCPT_STAT_T (OBJ_ID,RCPT_STAT_CD,RCPT_STAT_ID,RCPT_STAT_NM,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('1be8e6f4-84fa-4a77-ae9a-bd212fbb3ca5','7','9','Received','Y','MFHD 008-06 http://www.loc.gov/marc/holdings/hd008.html',STR_TO_DATE( '20120322120000', '%Y%m%d%H%i%s' ),1)
/