• Home
• org.kuali.ole
• ole-ls-sql
• 1.6.2
• source code
• OLE_CAT_FLD_ENCD_LVL_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_FLD_ENCD_LVL_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE OLE_CAT_FLD_ENCD_LVL_T
/
INSERT INTO OLE_CAT_FLD_ENCD_LVL_T (FLD_ENCD_LVL_CD,FLD_ENCD_LVL_ID,FLD_ENCD_LVL_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES (' ',1,'No information provIDed','1000','Y','MFHD 866-686 1st Indicator: http://www.loc.gov/marc/holdings/hd866868.html',STR_TO_DATE( '20120322000000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_FLD_ENCD_LVL_T (FLD_ENCD_LVL_CD,FLD_ENCD_LVL_ID,FLD_ENCD_LVL_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('3',2,'Holdings level 3 ','1001','Y','MFHD 866-686 1st Indicator: http://www.loc.gov/marc/holdings/hd866868.html',STR_TO_DATE( '20120322000000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_FLD_ENCD_LVL_T (FLD_ENCD_LVL_CD,FLD_ENCD_LVL_ID,FLD_ENCD_LVL_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('4',3,'Holdings level 4 ','1002','Y','MFHD 866-686 1st Indicator: http://www.loc.gov/marc/holdings/hd866868.html',STR_TO_DATE( '20120322000000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_FLD_ENCD_LVL_T (FLD_ENCD_LVL_CD,FLD_ENCD_LVL_ID,FLD_ENCD_LVL_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('5',4,'Holdings level 4 with piece deisgnation ','1003','Y','MFHD 866-686 1st Indicator: http://www.loc.gov/marc/holdings/hd866868.html',STR_TO_DATE( '20120322000000', '%Y%m%d%H%i%s' ),1)
/