Oracle Designer
Report : ENTITIES AND THEIR ATTRIBUTE
Run by : Andrei S. Lopatenko
Report Date : 06 July 2001
Total Pages : 29
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 3 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
ACADEMIC TITLE ACADEMIC_TITLE 10 N CHAR 4
Retrofitted from column
ACADEMIC_TITLE of table
ACADEMIC_TITLE
ACADEMIC_TITLE_FULL 20 Y VARCHAR2 32
Retrofitted from column
ACADEMIC_TITLE_FULL of
table ACADEMIC_TITLE
ACADEMIC TITLE PER
CLASSIFICATION CLASS 10 N VARCHAR2 16
Retrofitted from column
CLASS of table
CLASSIFICATION
CLASS_CODE 20 N VARCHAR2 16
Retrofitted from column
CLASS_CODE of table
CLASSIFICATION
CLASS_URL 50 Y VARCHAR2 512
Retrofitted from column
CLASS_URL of table
CLASSIFICATION
CLASSIFICATION CLASS_DESC_LANG 10 N CHAR 2
Retrofitted from column
DESCRIPTION
CLASS_DESC_LANG of table
CLASSIFICATION_DESCRIPTIO
N
CLASS_DESC_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
CLASS_DESC_TRANS_TYPE of
table
CLASSIFICATION_DESCRIPTIO
N
CLASS_DESCRIPTION 50 Y VARCHAR2 64
Retrofitted from column
CLASS_DESCRIPTION of
table
CLASSIFICATION_DESCRIPTIO
N
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 4 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
CONTACT CON_ID 10 N CHAR 32
Retrofitted from column
CON_ID of table CONTACT
CON_ADDRLINE1 40 Y VARCHAR2 80
Retrofitted from column
CON_ADDRLINE1 of table
CONTACT
CON_ADDRLINE2 50 Y VARCHAR2 80
Retrofitted from column
CON_ADDRLINE2 of table
CONTACT
CON_ADDRLINE3 60 Y VARCHAR2 80
Retrofitted from column
CON_ADDRLINE3 of table
CONTACT
CON_ADDRLINE4 70 Y VARCHAR2 80
Retrofitted from column
CON_ADDRLINE4 of table
CONTACT
CON_ADDRLINE5 80 Y VARCHAR2 80
Retrofitted from column
CON_ADDRLINE5 of table
CONTACT
CON_CITY_TOWN 90 N VARCHAR2 32
Retrofitted from column
CON_CITY_TOWN of table
CONTACT
CON_PROVINCE_STATE 100 Y VARCHAR2 32
Retrofitted from column
CON_PROVINCE_STATE of
table CONTACT
CON_POSTAL_CODE 110 N VARCHAR2 16
Retrofitted from column
CON_POSTAL_CODE of table
CONTACT
CON_TELEPHONE 120 Y VARCHAR2 24
Retrofitted from column
CON_TELEPHONE of table
CONTACT
CON_FAX 130 Y VARCHAR2 24
Retrofitted from column
CON_FAX of table CONTACT
CON_EMAIL 140 Y VARCHAR2 32
Retrofitted from column
CON_EMAIL of table
CONTACT
CON_URI 150 Y VARCHAR2 512
Retrofitted from column
CON_URI of table CONTACT
COUNTRY COUNTRY_CODE 10 N CHAR 2
Retrofitted from column
COUNTRY_CODE of table
COUNTRY
COUNTRY_NAME 20 N VARCHAR2 24
Retrofitted from column
COUNTRY_NAME of table
COUNTRY
COUNTRY_NAME_ENGLISH 30 N VARCHAR2 24
Retrofitted from column
COUNTRY_NAME_ENGLISH of
table COUNTRY
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 5 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
CV CV_ID 10 N VARCHAR2 32
Retrofitted from column
CV_ID of table CV
CV_URI 20 Y VARCHAR2 512
Retrofitted from column
CV_URI of table CV
CV MULTIMEDIA TYPE
EQUIP CLASS
EQUIPMENT EQUIP_DESC_LANGUAGE 10 N CHAR 2
Retrofitted from column
DESCRIPTION
EQUIP_DESC_LANGUAGE of
table
EQUIPMENT_DESCRIPTION
EQUIP_DESC_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
EQUIP_DESC_TRANS_TYPE of
table
EQUIPMENT_DESCRIPTION
EQUIP_DESCRIPTION 40 Y VARCHAR2 1024
Retrofitted from column
EQUIP_DESCRIPTION of
table
EQUIPMENT_DESCRIPTION
EQUIPMENT NAME EQUIP_NAME_LANGUAGE 10 N CHAR 2
Retrofitted from column
EQUIP_NAME_LANGUAGE of
table EQUIPMENT_NAME
EQUIP_NAME_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
EQUIP_NAME_TRANS_TYPE of
table EQUIPMENT_NAME
EQUIP_NAME 40 Y VARCHAR2 512
Retrofitted from column
EQUIP_NAME of table
EQUIPMENT_NAME
EQUIPMENT TYPE EQUIP_TYPE 10 N VARCHAR2 16
Retrofitted from column
EQUIP_TYPE of table
EQUIPMENT_TYPE
EQUIP_TYPE_FULL 20 N VARCHAR2 64
Retrofitted from column
EQUIP_TYPE_FULL of table
EQUIPMENT_TYPE
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 6 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
EVENT EVENT_ID 10 N CHAR 32
Retrofitted from column
EVENT_ID of table EVENT
EVENT_LOCATION 20 Y VARCHAR2 80
Retrofitted from column
EVENT_LOCATION of table
EVENT
EVENT_START_DATE 30 Y DATE
Retrofitted from column
EVENT_START_DATE of table
EVENT
EVENT_END_DATE 40 Y DATE
Retrofitted from column
EVENT_END_DATE of table
EVENT
EVENT_FEE_OR_FREE 50 Y CHAR 1
Retrofitted from column
EVENT_FEE_OR_FREE of
table EVENT
EVENT_URL 60 N VARCHAR2 512
Retrofitted from column
EVENT_URL of table EVENT
EVENT DESCRIPTION EVENT_DESC_LANGUAGE 10 N CHAR 2
Retrofitted from column
EVENT_DESC_LANGUAGE of
table EVENT_DESCRIPTION
EVENT_DESC_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
EVENT_DESC_TRANS_TYPE of
table EVENT_DESCRIPTION
EVENT_DESCRIPTION 40 Y VARCHAR2 1024
Retrofitted from column
EVENT_DESCRIPTION of
table EVENT_DESCRIPTION
EVENT NAME EVENT_LANGUAGE 10 N CHAR 2
Retrofitted from column
EVENT_LANGUAGE of table
EVENT_NAME
EVENT_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
EVENT_TRANS_TYPE of table
EVENT_NAME
EVENT_NAME 40 Y VARCHAR2 512
Retrofitted from column
EVENT_NAME of table
EVENT_NAME
EVENT TYPE EVENT_TYPE 10 N VARCHAR2 16
Retrofitted from column
EVENT_TYPE of table
EVENT_TYPE
EVENT_TYPE_FULL 20 Y VARCHAR2 64
Retrofitted from column
EVENT_TYPE_FULL of table
EVENT_TYPE
EXPERTISE SKILLS EXP_SKILL_ID 10 N CHAR 32
Retrofitted from column
EXP_SKILL_ID of table
EXPERTISE_SKILLS
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 7 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
EXPERTISE SKILLS EXP_SKILL_DESC_LANGUA 10 N CHAR 2
Retrofitted from column
DESCRIPTION GE
EXP_SKILL_DESC_LANGUAGE
of table
EXPERTISE_SKILLS_DESCRIPT
ION
EXP_SKILL_DESC_TRANS_ 20 N CHAR 1
Retrofitted from column
TYPE
EXP_SKILL_DESC_TRANS_TYPE
of table
EXPERTISE_SKILLS_DESCRIPT
ION
EXP_SKILL_DESCRIPTION 40 N VARCHAR2 1024
Retrofitted from column
EXP_SKILL_DESCRIPTION of
table
EXPERTISE_SKILLS_DESCRIPT
ION
EXPERTISE SKILLS EXP_SKILL_NAME_LANGUA 10 N CHAR 2
Retrofitted from column
NAME GE
EXP_SKILL_NAME_LANGUAGE
of table
EXPERTISE_SKILLS_NAME
EXP_SKILL_NAME_TRANS_ 20 N CHAR 1
Retrofitted from column
TYPE
EXP_SKILL_NAME_TRANS_TYPE
of table
EXPERTISE_SKILLS_NAME
EXP_SKILL_NAME 40 N VARCHAR2 512
Retrofitted from column
EXP_SKILL_NAME of table
EXPERTISE_SKILLS_NAME
FACILITY DESCRIPTIONFACILITY_DESC_LANGUAG 10 N CHAR 2
Retrofitted from column
E
FACILITY_DESC_LANGUAGE of
table
FACILITY_DESCRIPTION
FACILITY_DESC_TRANS_T 20 N CHAR 1
Retrofitted from column
YPE
FACILITY_DESC_TRANS_TYPE
of table
FACILITY_DESCRIPTION
FACILITY_DESCRIPTION 40 Y VARCHAR2 1024
Retrofitted from column
FACILITY_DESCRIPTION of
table
FACILITY_DESCRIPTION
FACILITY NAME FACILITY_LANGUAGE 10 N CHAR 2
Retrofitted from column
FACILITY_LANGUAGE of
table FACILITY_NAME
FACILITY_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
FACILITY_TRANS_TYPE of
table FACILITY_NAME
FACILITY_NAME 40 Y VARCHAR2 512
Retrofitted from column
FACILITY_NAME of table
FACILITY_NAME
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 8 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
FACILITY TYPE FACILITY_TYPE 10 N VARCHAR2 16
Retrofitted from column
FACILITY_TYPE of table
FACILITY_TYPE
FACILITY_TYPE_FULL 20 N VARCHAR2 64
Retrofitted from column
FACILITY_TYPE_FULL of
table FACILITY_TYPE
FUNDING ORG ORG_FUND_ROLE 30 Y VARCHAR2 16
Retrofitted from column
ORG_FUND_ROLE of table
FUNDING_ORG
ORG_FUND_START 40 Y DATE
Retrofitted from column
ORG_FUND_START of table
FUNDING_ORG
ORG_FUND_END 50 Y DATE
Retrofitted from column
ORG_FUND_END of table
FUNDING_ORG
FUNDING PROGRAM FUNDING_ID 10 N CHAR 32
Retrofitted from column
FUNDING_ID of table
FUNDING_PROGRAM
FUNDING_START_DATE 20 Y DATE
Retrofitted from column
FUNDING_START_DATE of
table FUNDING_PROGRAM
FUNDING_END_DATE 30 Y DATE
Retrofitted from column
FUNDING_END_DATE of table
FUNDING_PROGRAM
FUNDING_BUDGET 40 Y NUMBER
Retrofitted from column
FUNDING_BUDGET of table
FUNDING_PROGRAM
FUNDING_CURRENCY 50 Y CHAR 3
Retrofitted from column
FUNDING_CURRENCY of table
FUNDING_PROGRAM
FUNDING_URL 60 Y VARCHAR2 512
Retrofitted from column
FUNDING_URL of table
FUNDING_PROGRAM
FUNDING PROGRAMME FUNDING_DESC_LANGUAGE 10 N CHAR 2
Retrofitted from column
DESCRIPTION
FUNDING_DESC_LANGUAGE of
table
FUNDING_PROGRAMME_DESCRIP
TION
FUNDING_DESC_TRANS_TY 20 N CHAR 1
Retrofitted from column
PE
FUNDING_DESC_TRANS_TYPE
of table
FUNDING_PROGRAMME_DESCRIP
TION
FUNDING_DESCRIPTION 40 Y VARCHAR2 1024
Retrofitted from column
FUNDING_DESCRIPTION of
table
FUNDING_PROGRAMME_DESCRIP
TION
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 9 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
FUNDING PROGRAMME FUNDING_LANGUAGE 10 N CHAR 2
Retrofitted from column
NAME
FUNDING_LANGUAGE of table
FUNDING_PROGRAMME_NAME
FUNDING_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
FUNDING_TRANS_TYPE of
table
FUNDING_PROGRAMME_NAME
FUNDING_NAME 40 Y VARCHAR2 512
Retrofitted from column
FUNDING_NAME of table
FUNDING_PROGRAMME_NAME
FUNDING RECURSIVE FUN_FUN_ROLE 30 Y VARCHAR2 16
Retrofitted from column
FUN_FUN_ROLE of table
FUNDING_RECURSIVE
GENERAL FACILITY FACILITY_ID 10 N CHAR 32
Retrofitted from column
FACILITY_ID of table
GENERAL_FACILITY
FACILITY_URL 30 Y VARCHAR2 512
Retrofitted from column
FACILITY_URL of table
GENERAL_FACILITY
HONORIFIC TITLE PER
HONOROFIC TITLE HONORIFIC_TITLE 10 N CHAR 4
Retrofitted from column
HONORIFIC_TITLE of table
HONOROFIC_TITLE
HONORIFIC_TITLE_FULL 20 N VARCHAR2 32
Retrofitted from column
HONORIFIC_TITLE_FULL of
table HONOROFIC_TITLE
LANGUAGE LANG_CODE 10 N CHAR 2
Retrofitted from column
LANG_CODE of table
LANGUAGE
LANG_FULL_NAME 20 N VARCHAR2 32
Retrofitted from column
LANG_FULL_NAME of table
LANGUAGE
LANG_ENGLISH_NAME 30 Y VARCHAR2 32
Retrofitted from column
LANG_ENGLISH_NAME of
table LANGUAGE
MULTIMEDIA TYPE MULTIMEDIA_TYPE 10 N VARCHAR2 16
Retrofitted from column
MULTIMEDIA_TYPE of table
MULTIMEDIA_TYPE
MULTIMEDIA_TYPE_FULL 20 N VARCHAR2 64
Retrofitted from column
MULTIMEDIA_TYPE_FULL of
table MULTIMEDIA_TYPE
MULTIMEDIA_FORMAT 30 N VARCHAR2 32
Retrofitted from column
MULTIMEDIA_FORMAT of
table MULTIMEDIA_TYPE
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 10 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
NUTS REGION REGION_CODE 10 N CHAR 10
Retrofitted from column
REGION_CODE of table
NUTS_REGION
REGION_NAME 20 N VARCHAR2 32
Retrofitted from column
REGION_NAME of table
NUTS_REGION
REGION_NAME_ENGLISH 30 Y VARCHAR2 32
Retrofitted from column
REGION_NAME_ENGLISH of
table NUTS_REGION
ORG CONTACT ORG_CON_ROLE 30 Y VARCHAR2 16
Retrofitted from column
ORG_CON_ROLE of table
ORG_CONTACT
ORG_CON_START 40 Y DATE
Retrofitted from column
ORG_CON_START of table
ORG_CONTACT
ORG_CON_END 50 Y DATE
Retrofitted from column
ORG_CON_END of table
ORG_CONTACT
ORG EQUIPMENT ORG_EQUIP_ROLE 30 Y VARCHAR2 16
Retrofitted from column
ORG_EQUIP_ROLE of table
ORG_EQUIPMENT
ORG_EQUIP_CONDITIONS 40 Y VARCHAR2 1024
Retrofitted from column
ORG_EQUIP_CONDITIONS of
table ORG_EQUIPMENT
ORG_EQUIP_PRICE 50 Y NUMBER 12 2
Retrofitted from column
ORG_EQUIP_PRICE of table
ORG_EQUIPMENT
ORG_EQUIP_CURRENCY 60 Y CHAR 3
Retrofitted from column
ORG_EQUIP_CURRENCY of
table ORG_EQUIPMENT
ORG_EQUIP_AVAILABILIT 70 Y VARCHAR2 64
Retrofitted from column
Y
ORG_EQUIP_AVAILABILITY of
table ORG_EQUIPMENT
ORG_EQUIP_START 80 Y DATE
Retrofitted from column
ORG_EQUIP_START of table
ORG_EQUIPMENT
ORG_EQUIP_END 90 Y DATE
Retrofitted from column
ORG_EQUIP_END of table
ORG_EQUIPMENT
ORG EVENT ORG_EVENT_ROLE 30 Y VARCHAR2 16
Retrofitted from column
ORG_EVENT_ROLE of table
ORG_EVENT
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 11 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
ORG EXPERT SKILL ORG_EXP_ROLE 30 Y VARCHAR2 16
Retrofitted from column
ORG_EXP_ROLE of table
ORG_EXPERT_SKILL
ORG_EXP_CONDITIONS 40 Y VARCHAR2 1024
Retrofitted from column
ORG_EXP_CONDITIONS of
table ORG_EXPERT_SKILL
ORG_EXP_PRICE 50 Y NUMBER 12 2
Retrofitted from column
ORG_EXP_PRICE of table
ORG_EXPERT_SKILL
ORG_EXP_CURRENCY 60 Y CHAR 3
Retrofitted from column
ORG_EXP_CURRENCY of table
ORG_EXPERT_SKILL
ORG_EX_AVAILABILITY 70 Y VARCHAR2 64
Retrofitted from column
ORG_EX_AVAILABILITY of
table ORG_EXPERT_SKILL
ORG_EXP_START 80 Y DATE
Retrofitted from column
ORG_EXP_START of table
ORG_EXPERT_SKILL
ORG_EXP_END 90 Y DATE
Retrofitted from column
ORG_EXP_END of table
ORG_EXPERT_SKILL
ORG FACILITY ORG_FACIL_ROLE 30 Y VARCHAR2 16
Retrofitted from column
ORG_FACIL_ROLE of table
ORG_FACILITY
ORG_FACIL_CONDITIONS 40 Y VARCHAR2 1024
Retrofitted from column
ORG_FACIL_CONDITIONS of
table ORG_FACILITY
ORG_FACIL_PRICE 50 Y NUMBER 12 2
Retrofitted from column
ORG_FACIL_PRICE of table
ORG_FACILITY
ORG_FACIL_CURRENCY 60 Y CHAR 3
Retrofitted from column
ORG_FACIL_CURRENCY of
table ORG_FACILITY
ORG_FACIL_AVAILABILIT 70 Y VARCHAR2 64
Retrofitted from column
Y
ORG_FACIL_AVAILABILITY of
table ORG_FACILITY
ORG_FACIL_START 80 Y DATE
Retrofitted from column
ORG_FACIL_START of table
ORG_FACILITY
ORG_FACIL_END 90 Y DATE
Retrofitted from column
ORG_FACIL_END of table
ORG_FACILITY
ORG ORG ORG_ORG_ROLE 30 Y VARCHAR2 16
Retrofitted from column
ORG_ORG_ROLE of table
ORG_ORG
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 12 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
ORG PROD ROLE ORG_PROD_ROLE 10 N VARCHAR2 16
Retrofitted from column
ORG_PROD_ROLE of table
ORG_PROD_ROLE
ORG_PROD_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
ORG_PROD_ROLE_FULL of
table ORG_PROD_ROLE
ORG PUB ORG_PUB_ROLE 30 Y VARCHAR2 16
Retrofitted from column
ORG_PUB_ROLE of table
ORG_PUB
ORG_PUB_COPYRIGHT 40 N VARCHAR2 32
Retrofitted from column
ORG_PUB_COPYRIGHT of
table ORG_PUB
ORG RESERACH ORG_RESEARCH_LANG 20 N CHAR 2
Retrofitted from column
INTEREST
ORG_RESEARCH_LANG of
table
ORG_RESERACH_INTEREST
ORG_RESEARCH_TRANS 30 N CHAR 1
Retrofitted from column
ORG_RESEARCH_TRANS of
table
ORG_RESERACH_INTEREST
KEYWORDS 40 Y VARCHAR2 1024
Retrofitted from column
KEYWORDS of table
ORG_RESERACH_INTEREST
ORG SERVICE ORG_SERVICE_ROLE 30 Y VARCHAR2 16
Retrofitted from column
ORG_SERVICE_ROLE of table
ORG_SERVICE
ORG_SERVICE_CONDITION 40 Y VARCHAR2 1024
Retrofitted from column
S
ORG_SERVICE_CONDITIONS of
table ORG_SERVICE
ORG_SERVICE_PRICE 50 Y NUMBER 12 2
Retrofitted from column
ORG_SERVICE_PRICE of
table ORG_SERVICE
ORG_SERVICE_CURRENCY 60 Y CHAR 3
Retrofitted from column
ORG_SERVICE_CURRENCY of
table ORG_SERVICE
ORG_SERVICE_AVAILABIL 70 Y VARCHAR2 64
Retrofitted from column
ITY
ORG_SERVICE_AVAILABILITY
of table ORG_SERVICE
ORG_SERVICE_START 80 Y DATE
Retrofitted from column
ORG_SERVICE_START of
table ORG_SERVICE
ORG_SERVICE_END 90 Y DATE
Retrofitted from column
ORG_SERVICE_END of table
ORG_SERVICE
ORG TYPE ORG
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 13 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
ORGUNIT ORGUNITID 10 N CHAR 32
Retrofitted from column
ORGUNITID of table
ORGUNIT
ORG_ACRONYM 20 Y VARCHAR2 16
Retrofitted from column
ORG_ACRONYM of table
ORGUNIT
ORG_HEADCOUNT 30 Y CHAR 2
Retrofitted from column
ORG_HEADCOUNT of table
ORGUNIT
ORG_TURNOVER 40 Y NUMBER
Retrofitted from column
ORG_TURNOVER of table
ORGUNIT
ORG_TURNOVER_CURR 50 Y CHAR 3
Retrofitted from column
ORG_TURNOVER_CURR of
table ORGUNIT
ORG_PRIZE_AWARD 60 Y VARCHAR2 64
Retrofitted from column
ORG_PRIZE_AWARD of table
ORGUNIT
ORG_URL 70 Y VARCHAR2 512
Retrofitted from column
ORG_URL of table ORGUNIT
ORGUNIT PRODUCT ORG_PROD_IPR 40 Y VARCHAR2 32
Retrofitted from column
ORG_PROD_IPR of table
ORGUNIT_PRODUCT
ORG_PROD_CONDITIONS 50 Y VARCHAR2 1024
Retrofitted from column
ORG_PROD_CONDITIONS of
table ORGUNIT_PRODUCT
ORG_PROD_PRICE 60 Y NUMBER 12 2
Retrofitted from column
ORG_PROD_PRICE of table
ORGUNIT_PRODUCT
ORG_PROD_CURRENCY 70 Y CHAR 3
Retrofitted from column
ORG_PROD_CURRENCY of
table ORGUNIT_PRODUCT
ORG_PROD_AVAILABILITY 80 Y VARCHAR2 64
Retrofitted from column
ORG_PROD_AVAILABILITY of
table ORGUNIT_PRODUCT
ORG_PROD_START 90 Y DATE
Retrofitted from column
ORG_PROD_START of table
ORGUNIT_PRODUCT
ORG_PROD_END 100 Y DATE
Retrofitted from column
ORG_PROD_END of table
ORGUNIT_PRODUCT
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 14 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
ORGUNIT TRANSLATION ORG_LANGUAGE 10 N CHAR 2
Retrofitted from column
ORG_LANGUAGE of table
ORGUNIT_TRANSLATION
ORGUNIT_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
ORGUNIT_TRANS_TYPE of
table ORGUNIT_TRANSLATION
ORGUNIT_NAME 40 Y VARCHAR2 512
Retrofitted from column
ORGUNIT_NAME of table
ORGUNIT_TRANSLATION
ORGUNIT TYPE ORG_TYPE 10 N VARCHAR2 16
Retrofitted from column
ORG_TYPE of table
ORGUNIT_TYPE
ORG_TYPE_FULL 20 N VARCHAR2 45
Retrofitted from column
ORG_TYPE_FULL of table
ORGUNIT_TYPE
PARTICULAR EQUIPMENTEQUIP_ID 10 N CHAR 32
Retrofitted from column
EQUIP_ID of table
PARTICULAR_EQUIPMENT
EQUIP_OW_INV_ID 30 Y VARCHAR2 32
Retrofitted from column
EQUIP_OW_INV_ID of table
PARTICULAR_EQUIPMENT
EQUIP_OEM_ID 40 Y VARCHAR2 32
Retrofitted from column
EQUIP_OEM_ID of table
PARTICULAR_EQUIPMENT
PATENT ABSTRACT PATENT_ABS_LANGUAGE 10 N CHAR 2
Retrofitted from column
PATENT_ABS_LANGUAGE of
table PATENT_ABSTRACT
PATENT_ABS_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
PATENT_ABS_TRANS_TYPE of
table PATENT_ABSTRACT
PATENT_ABSTRACT 40 Y VARCHAR2 1024
Retrofitted from column
PATENT_ABSTRACT of table
PATENT_ABSTRACT
PATENT CLASS
PATENT ORG ORG_PATENT_ROLE 30 Y VARCHAR2 16
Retrofitted from column
ORG_PATENT_ROLE of table
PATENT_ORG
ORG_PATENT_START 40 Y DATE
Retrofitted from column
ORG_PATENT_START of table
PATENT_ORG
ORG_PATENT_END 50 Y DATE
Retrofitted from column
ORG_PATENT_END of table
PATENT_ORG
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 15 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
PATENT STATUS PATENT_STATUS 10 N VARCHAR2 8
Retrofitted from column
PATENT_STATUS of table
PATENT_STATUS
PATENT_STATUS_FULL 20 N VARCHAR2 32
Retrofitted from column
PATENT_STATUS_FULL of
table PATENT_STATUS
PATENT TITLE PATENT_TITLE_LANGUAGE 10 N CHAR 2
Retrofitted from column
PATENT_TITLE_LANGUAGE of
table PATENT_TITLE
PATENT_TITLE_TRANS_TY 20 N CHAR 1
Retrofitted from column
PE
PATENT_TITLE_TRANS_TYPE
of table PATENT_TITLE
PATENT_TITLE 40 Y VARCHAR2 1024
Retrofitted from column
PATENT_TITLE of table
PATENT_TITLE
PATENT TYPE PATENT_TYPE 10 N VARCHAR2 16
Retrofitted from column
PATENT_TYPE of table
PATENT_TYPE
PATENT_TYPE_FULL 20 N VARCHAR2 32
Retrofitted from column
PATENT_TYPE_FULL of table
PATENT_TYPE
PER CON ROLE PER_CON_ROLE 10 N VARCHAR2 16
Retrofitted from column
PER_CON_ROLE of table
PER_CON_ROLE
PER_CON_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PER_CON_ROLE_FULL of
table PER_CON_ROLE
PER EQUIP ROLE PER_EQUIP_ROLE 10 N VARCHAR2 16
Retrofitted from column
PER_EQUIP_ROLE of table
PER_EQUIP_ROLE
PER_EQUIP_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PER_EQUIP_ROLE_FULL of
table PER_EQUIP_ROLE
PER EVENT ROLE PER_EVENT_ROLE 10 N VARCHAR2 16
Retrofitted from column
PER_EVENT_ROLE of table
PER_EVENT_ROLE
PER_EVENT_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PER_EVENT_ROLE_FULL of
table PER_EVENT_ROLE
PER EXP ROLE PER_EXP_ROLE 10 N VARCHAR2 16
Retrofitted from column
PER_EXP_ROLE of table
PER_EXP_ROLE
PER_EXP_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PER_EXP_ROLE_FULL of
table PER_EXP_ROLE
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 16 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
PER FACIL ROLE PER_FACIL_ROLE 10 N VARCHAR2 16
Retrofitted from column
PER_FACIL_ROLE of table
PER_FACIL_ROLE
PER_FACIL_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PER_FACIL_ROLE_FULL of
table PER_FACIL_ROLE
PER PATENT ROLE PER_PATENT_ROLE 10 N VARCHAR2 16
Retrofitted from column
PER_PATENT_ROLE of table
PER_PATENT_ROLE
PER_PATENT_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PER_PATENT_ROLE_FULL of
table PER_PATENT_ROLE
PER PROD ROLE PER_PROD_ROLE 10 N VARCHAR2 16
Retrofitted from column
PER_PROD_ROLE of table
PER_PROD_ROLE
PER_PROD_ROLE_FULL_ 20 Y VARCHAR2 64
Retrofitted from column
PER_PROD_ROLE_FULL_ of
table PER_PROD_ROLE
PER PUB ROLE PERS_PUB_ROLE 10 N VARCHAR2 16
Retrofitted from column
PERS_PUB_ROLE of table
PER_PUB_ROLE
PERS_PUB_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PERS_PUB_ROLE_FULL of
table PER_PUB_ROLE
PER SERVICE ROLE PER_SERVICE_ROLE 10 N VARCHAR2 16
Retrofitted from column
PER_SERVICE_ROLE of table
PER_SERVICE_ROLE
PER_SERVICE_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PER_SERVICE_ROLE_FULL of
table PER_SERVICE_ROLE
PERS CONTACT PER_CON_START 40 Y DATE
Retrofitted from column
PER_CON_START of table
PERS_CONTACT
PER_CON_END 50 Y DATE
Retrofitted from column
PER_CON_END of table
PERS_CONTACT
PERS CV
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 17 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
PERS EQUIP PER_EQUIP_CONDITIONS 40 Y VARCHAR2 1024
Retrofitted from column
PER_EQUIP_CONDITIONS of
table PERS_EQUIP
PER_EQUIP_PRICE 50 Y NUMBER 12 2
Retrofitted from column
PER_EQUIP_PRICE of table
PERS_EQUIP
PER_EQUIP_CURRENCY 60 Y CHAR 3
Retrofitted from column
PER_EQUIP_CURRENCY of
table PERS_EQUIP
PER_EQUIP_AVAILABILIT 70 Y VARCHAR2 64
Retrofitted from column
Y
PER_EQUIP_AVAILABILITY of
table PERS_EQUIP
PER_EQUIP_START 80 Y DATE
Retrofitted from column
PER_EQUIP_START of table
PERS_EQUIP
PER_EQUIP_END 90 Y DATE
Retrofitted from column
PER_EQUIP_END of table
PERS_EQUIP
PERS EVENT
PERS EXPERT SKILL PER_EXP_CONDITIONS 40 Y VARCHAR2 1024
Retrofitted from column
PER_EXP_CONDITIONS of
table PERS_EXPERT_SKILL
PER_EXP_PRICE 50 Y NUMBER 12 2
Retrofitted from column
PER_EXP_PRICE of table
PERS_EXPERT_SKILL
PER_EXP_CURRENCY 60 Y CHAR 3
Retrofitted from column
PER_EXP_CURRENCY of table
PERS_EXPERT_SKILL
PER_EXP_AVAILABILITY 70 Y CHAR 64
Retrofitted from column
PER_EXP_AVAILABILITY of
table PERS_EXPERT_SKILL
PER_EXP_START 80 Y DATE
Retrofitted from column
PER_EXP_START of table
PERS_EXPERT_SKILL
PER_EXP_END 90 Y DATE
Retrofitted from column
PER_EXP_END of table
PERS_EXPERT_SKILL
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 18 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
PERS FACILITY PER_FACIL_CONDITIONS 40 Y VARCHAR2 1024
Retrofitted from column
PER_FACIL_CONDITIONS of
table PERS_FACILITY
PER_FACIL_PRICE 50 Y NUMBER 12 2
Retrofitted from column
PER_FACIL_PRICE of table
PERS_FACILITY
PER_FACIL_CURRENCY 60 Y CHAR 3
Retrofitted from column
PER_FACIL_CURRENCY of
table PERS_FACILITY
PER_FACIL_AVAIL 70 Y VARCHAR2 64
Retrofitted from column
PER_FACIL_AVAIL of table
PERS_FACILITY
PER_FACIL_START 80 Y DATE
Retrofitted from column
PER_FACIL_START of table
PERS_FACILITY
PER_FACIL_END 90 Y DATE
Retrofitted from column
PER_FACIL_END of table
PERS_FACILITY
PERS LANG SKILL_READING 30 Y CHAR 1
Retrofitted from column
SKILL_READING of table
PERS_LANG
SKILL_WRITING 40 Y CHAR 1
Retrofitted from column
SKILL_WRITING of table
PERS_LANG
SKILL_SPEAKING 50 Y CHAR 1
Retrofitted from column
SKILL_SPEAKING of table
PERS_LANG
PERS ORG PER_ORG_ROLE 40 Y VARCHAR2 16
Retrofitted from column
PER_ORG_ROLE of table
PERS_ORG
PER_ORG_START 50 Y DATE
Retrofitted from column
PER_ORG_START of table
PERS_ORG
PER_ORG_END 60 Y DATE
Retrofitted from column
PER_ORG_END of table
PERS_ORG
PERS ORG ROLE PERS_ORG_ROLE 10 N VARCHAR2 16
Retrofitted from column
PERS_ORG_ROLE of table
PERS_ORG_ROLE
PERS_ORG_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PERS_ORG_ROLE_FULL of
table PERS_ORG_ROLE
PERS PATENT PER_PATENT_START 40 Y DATE
Retrofitted from column
PER_PATENT_START of table
PERS_PATENT
PER_PATENT_END 50 Y DATE
Retrofitted from column
PER_PATENT_END of table
PERS_PATENT
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 19 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
PERS PERS PER_PER_ROLE 40 Y CHAR 16
Retrofitted from column
PER_PER_ROLE of table
PERS_PERS
PER_PER_START 50 Y DATE
Retrofitted from column
PER_PER_START of table
PERS_PERS
PER_PER_END 60 Y DATE
Retrofitted from column
PER_PER_END of table
PERS_PERS
PERS PERS ROLE PERS_PERS_ROLE 10 N VARCHAR2 16
Retrofitted from column
PERS_PERS_ROLE of table
PERS_PERS_ROLE
PERS_PERS_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PERS_PERS_ROLE_FULL of
table PERS_PERS_ROLE
PERS PRODUCT PER_PROD_IPR 40 Y VARCHAR2 32
Retrofitted from column
PER_PROD_IPR of table
PERS_PRODUCT
PER_PROD_CONDITIONS 50 Y VARCHAR2 1024
Retrofitted from column
PER_PROD_CONDITIONS of
table PERS_PRODUCT
PER_PROD_PRICE 60 Y NUMBER 12 2
Retrofitted from column
PER_PROD_PRICE of table
PERS_PRODUCT
PER_PROD_CURRENCY 70 Y CHAR 3
Retrofitted from column
PER_PROD_CURRENCY of
table PERS_PRODUCT
PER_PROD_AVAILABILITY 80 Y VARCHAR2 64
Retrofitted from column
PER_PROD_AVAILABILITY of
table PERS_PRODUCT
PERS PUB PER_PUB_COPYRIGHT 40 N VARCHAR2 32
Retrofitted from column
PER_PUB_COPYRIGHT of
table PERS_PUB
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 20 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
PERS SERVICE PER_SERVICE_CONDITION 40 Y VARCHAR2 1024
Retrofitted from column
S
PER_SERVICE_CONDITIONS of
table PERS_SERVICE
PER_SERVICE_PRICE 50 Y NUMBER 12 2
Retrofitted from column
PER_SERVICE_PRICE of
table PERS_SERVICE
PER_SERVICE_CURRENCY 60 Y CHAR 3
Retrofitted from column
PER_SERVICE_CURRENCY of
table PERS_SERVICE
PER_SER_VICE_AVAILABI 70 Y VARCHAR2 64
Retrofitted from column
LITY
PER_SER_VICE_AVAILABILITY
of table PERS_SERVICE
PER_SERVICE_START 80 Y DATE
Retrofitted from column
PER_SERVICE_START of
table PERS_SERVICE
PER_SERVICE_END 90 Y DATE
Retrofitted from column
PER_SERVICE_END of table
PERS_SERVICE
PERSON PER_ID 10 N CHAR 32
Retrofitted from column
PER_ID of table PERSON
PER_FAMILY_NAMES 20 N VARCHAR2 32
Retrofitted from column
PER_FAMILY_NAMES of table
PERSON
PER_FIRST_NAMES 30 Y VARCHAR2 16
Retrofitted from column
PER_FIRST_NAMES of table
PERSON
PER_OTHER_NAMES 40 Y VARCHAR2 32
Retrofitted from column
PER_OTHER_NAMES of table
PERSON
PER_SEX 50 Y CHAR 1
Retrofitted from column
PER_SEX of table PERSON
PER_HONORIFIC_TITLE 60 Y VARCHAR2 10
Retrofitted from column
PER_HONORIFIC_TITLE of
table PERSON
PER_ACADEMIC_TITLE 70 Y VARCHAR2 10
Retrofitted from column
PER_ACADEMIC_TITLE of
table PERSON
PER_QUALIFICATIONS 80 Y VARCHAR2 24
Retrofitted from column
PER_QUALIFICATIONS of
table PERSON
PER_NATIONALITIES 90 Y VARCHAR2 16
Retrofitted from column
PER_NATIONALITIES of
table PERSON
PER_PRIZE_AWARD 100 Y VARCHAR2 64
Retrofitted from column
PER_PRIZE_AWARD of table
PERSON
PER_URI 110 Y VARCHAR2 512
Retrofitted from column
PER_URI of table PERSON
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 21 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
PERSON RESEARCH PERS_RES_INT_LANGUAGE 10 N CHAR 2
Retrofitted from column
INTEREST
PERS_RES_INT_LANGUAGE of
table
PERSON_RESEARCH_INTEREST
PERS_RES_INT_TRANS_TY 20 N CHAR 1
Retrofitted from column
PE
PERS_RES_INT_TRANS_TYPE
of table
PERSON_RESEARCH_INTEREST
PERS_RES_INT_KEYWORDS 40 Y VARCHAR2 1024
Retrofitted from column
PERS_RES_INT_KEYWORDS of
table
PERSON_RESEARCH_INTEREST
PROD CLASS
PRODUCT DESCRIPTION PROD_DESC_LANGUAGE 10 N CHAR 2
Retrofitted from column
PROD_DESC_LANGUAGE of
table PRODUCT_DESCRIPTION
PROD_DESC_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
PROD_DESC_TRANS_TYPE of
table PRODUCT_DESCRIPTION
PROD_DESCRIPTION 40 Y VARCHAR2 1024
Retrofitted from column
PROD_DESCRIPTION of table
PRODUCT_DESCRIPTION
PRODUCT NAME PROD_NAME_LANGUAGE 10 N CHAR 2
Retrofitted from column
PROD_NAME_LANGUAGE of
table PRODUCT_NAME
PROD_NAME_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
PROD_NAME_TRANS_TYPE of
table PRODUCT_NAME
PROD_NAME 40 Y VARCHAR2 512
Retrofitted from column
PROD_NAME of table
PRODUCT_NAME
PRODUCT TYPE PROD_TYPE 10 N VARCHAR2 16
Retrofitted from column
PROD_TYPE of table
PRODUCT_TYPE
PROD_TYPE_FULL 20 N VARCHAR2 64
Retrofitted from column
PROD_TYPE_FULL of table
PRODUCT_TYPE
PROJ CLASSIFICATION
PROJ EQUIP ROLE PROJ_EQUIP_ROLE 10 N VARCHAR2 16
Retrofitted from column
PROJ_EQUIP_ROLE of table
PROJ_EQUIP_ROLE
PROJ_EQUIP_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PROJ_EQUIP_ROLE_FULL of
table PROJ_EQUIP_ROLE
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 22 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
PROJ EQUIPMENT PROJ_EQUIP_CONDITIONS 40 Y VARCHAR2 1032
Retrofitted from column
PROJ_EQUIP_CONDITIONS of
table PROJ_EQUIPMENT
PROJ_EQUP_PRICE 50 Y NUMBER 12 2
Retrofitted from column
PROJ_EQUP_PRICE of table
PROJ_EQUIPMENT
PROJ_EQUIP_CURRENCY 60 Y CHAR 3
Retrofitted from column
PROJ_EQUIP_CURRENCY of
table PROJ_EQUIPMENT
PROJ_EQUIP__AVAILABIL 70 Y VARCHAR2 64
Retrofitted from column
ITY
PROJ_EQUIP__AVAILABILITY
of table PROJ_EQUIPMENT
PROJ_EQUIP_START 80 Y DATE
Retrofitted from column
PROJ_EQUIP_START of table
PROJ_EQUIPMENT
PROJ_EQUIP_END 90 Y DATE
Retrofitted from column
PROJ_EQUIP_END of table
PROJ_EQUIPMENT
PROJ EVENT PROJ_EVENT_ROLE 30 Y CHAR 16
Retrofitted from column
PROJ_EVENT_ROLE of table
PROJ_EVENT
PROJ FACILITY PROJ_FACIL_CONDITIONS 40 Y VARCHAR2 1032
Retrofitted from column
PROJ_FACIL_CONDITIONS of
table PROJ_FACILITY
PROJ_FACIL_PRICE 50 Y NUMBER 12 2
Retrofitted from column
PROJ_FACIL_PRICE of table
PROJ_FACILITY
PROJ_FACIL_CURRENCY 60 Y CHAR 3
Retrofitted from column
PROJ_FACIL_CURRENCY of
table PROJ_FACILITY
PROJ_FACIL_AVAILABILI 70 Y VARCHAR2 64
Retrofitted from column
TY
PROJ_FACIL_AVAILABILITY
of table PROJ_FACILITY
PROJ_FACIL_START 80 Y DATE
Retrofitted from column
PROJ_FACIL_START of table
PROJ_FACILITY
PROJ_FACIL_END 90 N DATE
Retrofitted from column
PROJ_FACIL_END of table
PROJ_FACILITY
PROJ FACILITY ROLE PROJ_FACIL_ROLE 10 N VARCHAR2 16
Retrofitted from column
PROJ_FACIL_ROLE of table
PROJ_FACILITY_ROLE
PROJ_FACIL_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PROJ_FACIL_ROLE_FULL of
table PROJ_FACILITY_ROLE
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 23 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
PROJ FUND ROLE PROJ_FUND_ROLE 10 N VARCHAR2 16
Retrofitted from column
PROJ_FUND_ROLE of table
PROJ_FUND_ROLE
PROJ_FUND_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PROJ_FUND_ROLE_FULL of
table PROJ_FUND_ROLE
PROJ FUNDING PROJ_FUND_START 40 Y DATE
Retrofitted from column
PROJ_FUND_START of table
PROJ_FUNDING
PROJ_FUND_END 50 Y DATE
Retrofitted from column
PROJ_FUND_END of table
PROJ_FUNDING
PROJ_BUDGET 60 Y NUMBER 12 2
Retrofitted from column
PROJ_BUDGET of table
PROJ_FUNDING
PROJ_CURRENCY 70 Y CHAR 3
Retrofitted from column
PROJ_CURRENCY of table
PROJ_FUNDING
PROJ ORGUNIT PROG_ORG_START 40 Y DATE
Retrofitted from column
PROG_ORG_START of table
PROJ_ORGUNIT
PROJ_ORG_END 50 Y DATE
Retrofitted from column
PROJ_ORG_END of table
PROJ_ORGUNIT
PROJ ORGUNIT ROLE PROJ_ORG_ROLE 10 N VARCHAR2 16
Retrofitted from column
PROJ_ORG_ROLE of table
PROJ_ORGUNIT_ROLE
PROJ_ORG_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PROJ_ORG_ROLE_FULL of
table PROJ_ORGUNIT_ROLE
PROJ PATENT
PROJ PATENT ROLE PROJ_PATENT_ROLE 10 N VARCHAR2 16
Retrofitted from column
PROJ_PATENT_ROLE of table
PROJ_PATENT_ROLE
PROJ_PATENT_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PROJ_PATENT_ROLE_FULL of
table PROJ_PATENT_ROLE
PROJ PERS ROLE PROJ_PER_ROLE 10 N VARCHAR2 16
Retrofitted from column
PROJ_PER_ROLE of table
PROJ_PERS_ROLE
PROJ_PERS_TYPE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PROJ_PERS_TYPE_FULL of
table PROJ_PERS_ROLE
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 24 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
PROJ PERSON PROJ_PER_START 40 Y DATE
Retrofitted from column
PROJ_PER_START of table
PROJ_PERSON
PROJ_PER_END 50 Y DATE
Retrofitted from column
PROJ_PER_END of table
PROJ_PERSON
PROJ PROD ROLE PROJ_PROD_ROLE 10 N VARCHAR2 16
Retrofitted from column
PROJ_PROD_ROLE of table
PROJ_PROD_ROLE
PROJ_PROD_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PROJ_PROD_ROLE_FULL of
table PROJ_PROD_ROLE
PROJ PRODUCT PROJ_PROD_IPR 40 Y VARCHAR2 32
Retrofitted from column
PROJ_PROD_IPR of table
PROJ_PRODUCT
PROJ_PROD_CONDITIONS 50 Y VARCHAR2 1024
Retrofitted from column
PROJ_PROD_CONDITIONS of
table PROJ_PRODUCT
PROJ_PROD_PRICE 60 Y NUMBER 12 2
Retrofitted from column
PROJ_PROD_PRICE of table
PROJ_PRODUCT
PROJ_PROD_CURRENCY 70 Y CHAR 3
Retrofitted from column
PROJ_PROD_CURRENCY of
table PROJ_PRODUCT
PROJ_PROD_AVAILABILIT 80 Y VARCHAR2 64
Retrofitted from column
Y
PROJ_PROD_AVAILABILITY of
table PROJ_PRODUCT
PROJ_PROD_START 90 Y DATE
Retrofitted from column
PROJ_PROD_START of table
PROJ_PRODUCT
PROJ_PROD_END 100 Y DATE
Retrofitted from column
PROJ_PROD_END of table
PROJ_PRODUCT
PROJ PROJ ROLE PROJ_PROJ_ROLE 10 N VARCHAR2 16
Retrofitted from column
PROJ_PROJ_ROLE of table
PROJ_PROJ_ROLE
PROJ_PROJ_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PROJ_PROJ_ROLE_FULL of
table PROJ_PROJ_ROLE
PROJ PUB PROJ_PUB_COPYRIGHT 40 N VARCHAR2 32
Retrofitted from column
PROJ_PUB_COPYRIGHT of
table PROJ_PUB
PROJ PUB ROLE PROJ_PUB_ROLE 10 N VARCHAR2 16
Retrofitted from column
PROJ_PUB_ROLE of table
PROJ_PUB_ROLE
PROJ_PUB_ROLE_FULL 20 Y VARCHAR2 64
Retrofitted from column
PROJ_PUB_ROLE_FULL of
table PROJ_PUB_ROLE
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 25 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
PROJ RECURSIVE PROJ_PROJ_START 40 Y DATE
Retrofitted from column
PROJ_PROJ_START of table
PROJ_RECURSIVE
PROJ_PORJ_END 50 Y DATE
Retrofitted from column
PROJ_PORJ_END of table
PROJ_RECURSIVE
PROJECT PROJ_ID 10 N CHAR 32
Retrofitted from column
PROJ_ID of table PROJECT
PROJ_START_DATE 30 Y DATE
Retrofitted from column
PROJ_START_DATE of table
PROJECT
PROJ_END_DATE 40 Y DATE
Retrofitted from column
PROJ_END_DATE of table
PROJECT
PROJ_PRIZE_AWARD 50 Y CHAR 64
Retrofitted from column
PROJ_PRIZE_AWARD of table
PROJECT
PROJ_URL 60 Y VARCHAR2 512
Retrofitted from column
PROJ_URL of table PROJECT
PROJECT ABSTRACT PROJ_ABS_LANGUAGE 10 N CHAR 2
Retrofitted from column
PROJ_ABS_LANGUAGE of
table PROJECT_ABSTRACT
PROJ_ABS_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
PROJ_ABS_TRANS_TYPE of
table PROJECT_ABSTRACT
PROJ_ABSTRACT 40 Y VARCHAR2 1024
Retrofitted from column
PROJ_ABSTRACT of table
PROJECT_ABSTRACT
PROJECT KEYWORDS PROJ_KEYW_LANGUAGE 10 N CHAR 2
Retrofitted from column
PROJ_KEYW_LANGUAGE of
table PROJECT_KEYWORDS
PROJ_KEYW_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
PROJ_KEYW_TRANS_TYPE of
table PROJECT_KEYWORDS
PROJ_KEYWORDS 40 Y VARCHAR2 1024
Retrofitted from column
PROJ_KEYWORDS of table
PROJECT_KEYWORDS
PROJECT STATUS PROJ_STATUS 10 N VARCHAR2 8
Retrofitted from column
PROJ_STATUS of table
PROJECT_STATUS
PROJ_STATUS_NAME 20 N VARCHAR2 32
Retrofitted from column
PROJ_STATUS_NAME of table
PROJECT_STATUS
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 26 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
PROJECT TITLE PROJ_TITLE_LANGUAGE 10 N CHAR 2
Retrofitted from column
PROJ_TITLE_LANGUAGE of
table PROJECT_TITLE
PROJ_TITLE_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
PROJ_TITLE_TRANS_TYPE of
table PROJECT_TITLE
PROJ_TITLE 40 Y VARCHAR2 1024
Retrofitted from column
PROJ_TITLE of table
PROJECT_TITLE
PUB CLASS
PUBLICATION PUB_LANGUAGE 10 N CHAR 2
Retrofitted from column
TRANSLATION
PUB_LANGUAGE of table
PUBLICATION_TRANSLATION
PUB_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
PUB_TRANS_TYPE of table
PUBLICATION_TRANSLATION
PUB_TITLE 40 Y VARCHAR2 1024
Retrofitted from column
PUB_TITLE of table
PUBLICATION_TRANSLATION
PUBLICATION TYPE PUB_TYPE 10 N VARCHAR2 16
Retrofitted from column
PUB_TYPE of table
PUBLICATION_TYPE
PUB_TYPE_FULL 20 N VARCHAR2 32
Retrofitted from column
PUB_TYPE_FULL of table
PUBLICATION_TYPE
QUAL PERSON
QUALIFICATION QUALIFICATION 10 N CHAR 4
Retrofitted from column
QUALIFICATION of table
QUALIFICATION
QUALIFICATION_FULL 20 Y VARCHAR2 32
Retrofitted from column
QUALIFICATION_FULL of
table QUALIFICATION
RESEARCH ACTIVITY RES_ACT_LANGUAGE 10 N CHAR 2
Retrofitted from column
RES_ACT_LANGUAGE of table
RESEARCH_ACTIVITY
RES_ACT_TRANSLATION 20 N CHAR 1
Retrofitted from column
RES_ACT_TRANSLATION of
table RESEARCH_ACTIVITY
RES_ACT_KEYWORDS 40 Y VARCHAR2 1024
Retrofitted from column
RES_ACT_KEYWORDS of table
RESEARCH_ACTIVITY
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 27 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
RESULT PATENT PATENT_ID 10 N CHAR 32
Retrofitted from column
PATENT_ID of table
RESULT_PATENT
PATENT_NUMBER 40 N VARCHAR2 64
Retrofitted from column
PATENT_NUMBER of table
RESULT_PATENT
PATENT_COUNTRIES 50 Y VARCHAR2 32
Retrofitted from column
PATENT_COUNTRIES of table
RESULT_PATENT
PATENT_REG_DATE 60 Y DATE
Retrofitted from column
PATENT_REG_DATE of table
RESULT_PATENT
PATENT_APPROVAL_DATE 70 Y DATE
Retrofitted from column
PATENT_APPROVAL_DATE of
table RESULT_PATENT
PATENT_URI 80 Y VARCHAR2 512
Retrofitted from column
PATENT_URI of table
RESULT_PATENT
RESULT PRODUCT PROD_ID 10 N CHAR 32
Retrofitted from column
PROD_ID of table
RESULT_PRODUCT
PROD_INT_ID 30 N VARCHAR2 32
Retrofitted from column
PROD_INT_ID of table
RESULT_PRODUCT
PROD_URI 40 Y VARCHAR2 512
Retrofitted from column
PROD_URI of table
RESULT_PRODUCT
RESULT PUBLICATION PUB_ID 10 N CHAR 32
Retrofitted from column
PUB_ID of table
RESULT_PUBLICATION
PUB__DATE 30 Y DATE
Retrofitted from column
PUB__DATE of table
RESULT_PUBLICATION
PUB_REFERENCE 40 N VARCHAR2 512
Retrofitted from column
PUB_REFERENCE of table
RESULT_PUBLICATION
PUB_URI 50 Y VARCHAR2 512
Retrofitted from column
PUB_URI of table
RESULT_PUBLICATION
PUB_URI_TYPE 60 Y VARCHAR2 16
Retrofitted from column
PUB_URI_TYPE of table
RESULT_PUBLICATION
SERVICE SERVICE_ID 10 N CHAR 32
Retrofitted from column
SERVICE_ID of table
SERVICE
SERVICE_URI 20 Y VARCHAR2 512
Retrofitted from column
SERVICE_URI of table
SERVICE
Oracle Designer Report : ckatt
b14
06 July 2001 Entities and their Attribu
tes Page 28 of 29
Container : AURIS Version :
Entity Name Attribute Name Seq. Opt.Format Length Dec Pl
Attribute Description Attribute Notes
SERVICE CLASS
SERVICE DESCRIPTION SERVICE_DERSC_LANGUAG 10 N CHAR 2
Retrofitted from column
E
SERVICE_DERSC_LANGUAGE of
table SERVICE_DESCRIPTION
SERVICE_TRANS_TYPE2 20 N CHAR 1
Retrofitted from column
SERVICE_TRANS_TYPE2 of
table SERVICE_DESCRIPTION
SERVICE_DESCRIPTION 40 Y VARCHAR2 1024
Retrofitted from column
SERVICE_DESCRIPTION of
table SERVICE_DESCRIPTION
SERVICE NAME SERVICE_NAME_LANGUAGE 10 N CHAR 2
Retrofitted from column
SERVICE_NAME_LANGUAGE of
table SERVICE_NAME
SERVICE_TRANS_TYPE 20 N CHAR 1
Retrofitted from column
SERVICE_TRANS_TYPE of
table SERVICE_NAME
SERVICE_NAME 40 Y VARCHAR2 512
Retrofitted from column
SERVICE_NAME of table
SERVICE_NAME
Oracle Designer Report : ckatt
b14
Oracle Designer
ENTITIES AND THEIR ATTRIBUTE
S
End of Report