Visualization of datamap

Excel

The datamap applies to the Construction Contracts in the KONEPS Contracts dataset. There are many fields that pertain to the AMOUNT concept. There is no data dictionary available so we had to infer the descriptions of the fields. We may have missed it based on the half Korean, half English displayed when researching the KONEPS portal. We used a combination of Google Translate and a translator to name the fields which is why there is a big discrepancy in some cases between the Field Name, and the Standard Name. When in doubt we put fields into ADDON so this may have overemphasized this category. This analysis should be considered preliminary due to the language barrier.

Standardized FieldnameConceptTypeLanguageTitleDescriptionAllowable Values
contract_description_detailsGOODS / SERVICES한국어 (Korean)공종명e.g., 가스시설시공업제1종; 건축공사업; 금속구조물.창호공사업
U.S. English0 kinds of peoplee.g., the gas in first class contract...
contract_descriptionGOODS / SERVICESText한국어 (Korean)공사명
U.S. English04 people
government_issue_amountAMOUNTCurrency한국어 (Korean)관급금액
U.S. EnglishAmount of government issue
laws_and_regulationsADD ONSingleSelect한국어 (Korean)적용법규국가계약법, 지방계약법
U.S. EnglishApplicable laws and regulationsNational contract law, contract law p...
basic_priceAMOUNTCurrency한국어 (Korean)기초금액
U.S. EnglishBased on the amount
bid_ordersADD ONNumber한국어 (Korean)입찰공고차수00, 01
U.S. EnglishBidding orders00, 01
bond_purchasesADD ONCurrency한국어 (Korean)공채매입액
U.S. EnglishBond Purchases
total_contract_amount_bookkeepingAMOUNTCurrency한국어 (Korean)총부기계약금액
U.S. EnglishBookkeeping total contract amount
branch_office_nameBUYER한국어 (Korean)지청명강원지방조달청, 경남지방조달청, 광주지방조달청, 대구지방조달청, 대...
U.S. EnglishBranch Office NameGangwon province PPS, PPS Gyeongnam P...
category_name_obligationsADD ONSingleSelect한국어 (Korean)임의의무계약구분명의무계약; 임의계약
U.S. EnglishCategory Name any contract obligationsContract obligations;Any contract
construction_management_codeGOODS / SERVICESNumber한국어 (Korean)공사관리번호
U.S. EnglishConstruction Management Code
construction_period_supplierCONTRACT FEATURESText, Number한국어 (Korean)공사기한단서e.g., 금차 180일, 총공사 180일; 금차 270일, 총공사...
U.S. EnglishConstruction period leadse.g., geumcha 180 days, 180 days tota...
contract_locationADD ONText, SingleSelect한국어 (Korean)공사현장e.g., 강원도, 경기도, 경기도
U.S. EnglishConstruction sitee.g., Gangwon-do, Gyeonggi-do, Gyeong...
construction_amountAMOUNTCurrency한국어 (Korean)공사예정금액
U.S. EnglishConstruction will amount
supplier_nameSUPPLIERText한국어 (Korean)담당자명
U.S. EnglishContact Name
contract_amountAMOUNTCurrency한국어 (Korean)계약금액
U.S. EnglishContract Amount
contract_feeAMOUNTCurrency한국어 (Korean)계약수수료
U.S. EnglishContract fee
publication_dateTENDER FEATURESDateTime한국어 (Korean)나라장터공고일자
U.S. EnglishCountry marketplaces Publication Date
announcement_dateTENDER FEATURESDateTime한국어 (Korean)공고일자
U.S. EnglishDate of Announcement
amount_publication_dateTENDER FEATURESDateTime한국어 (Korean)기초금액공개일자
U.S. EnglishDate of publication based on the amount
receipt_dateAWARD FEATURESDateTime한국어 (Korean)접수일자
U.S. EnglishDate of receipt
technical_review_dateAWARD FEATURESDateTime한국어 (Korean)기술검토일자
U.S. EnglishDate of Technical Review
wicket_dateADD ONDateTime한국어 (Korean)개찰일자
U.S. EnglishDate of wicket
delay_daysCONTRACT FEATURESNumber, SingleSelect한국어 (Korean)지연일수negative and positive numbers
U.S. EnglishDays of delay
deposit_rateADD ONSingleSelect한국어 (Korean)보증금율10, 15, 20, 40, 50
U.S. EnglishDeposit rate10, 15, 20, 40, 50
design_costAMOUNTCurrency한국어 (Korean)설계금액
U.S. EnglishDesign cost
estimated_priceAMOUNTCurrency한국어 (Korean)추정가격
U.S. EnglishEstimated price
exemption_feeADD ONCurrency한국어 (Korean)수수료면제사유n/a
U.S. EnglishFee exemptionn / a
contract_fixed_dateCONTRACT FEATURESDateTime한국어 (Korean)계약확정일자
U.S. EnglishFixed date contract
research_amountAMOUNTCurrency한국어 (Korean)금차조사금액
U.S. EnglishGeumcha amount of research
government_issue_amount_contractorsAMOUNTCurrency한국어 (Korean)도급자관급금액
U.S. EnglishGovernment issue amount of contractors
guaranteed_amountADD ONCurrency한국어 (Korean)보증금액
U.S. EnglishGuaranteed amount
bid_evaluation_typeTENDER FEATURES한국어 (Korean)낙찰방법명e.g., 일괄(가중치기준방식); 추정가격 100억원미만 50억원이...
U.S. EnglishHow people bide.g., bulk (weight based on the way);...
tender_evaluation_type_codeTENDER FEATURESNumber한국어 (Korean)낙찰방법코드
U.S. EnglishHow to code a bid
contract_codeADD ONNumber한국어 (Korean)시설계약방법코드
U.S. EnglishHow to code in a contract
bid_typeTENDER FEATURESText한국어 (Korean)시설계약방법명e.g., 실적+PQ; 3등급+PQ; 실적제한
U.S. EnglishIn how people deale.g., Performance + PQ; 3 star + PQ; ...
jurisdiction_category_nameBUYERText한국어 (Korean)소관구분명공기업, 교육기관, 국가기관, 기타공공기관, 기타기관, 준정부기관,...
U.S. EnglishJurisdiction Category NamePublic, educational institutions, sta...
successful_bid_rateAWARD FEATURESNumber한국어 (Korean)낙찰율e.g., range: 66.52-99.96
U.S. EnglishNakchalyule.g., range: 66.52-99.96
supplier_nameSUPPLIERText한국어 (Korean)조달업체명e.g., (유)광토건설, (유)광토건설, 남명건설주식회사
U.S. EnglishName one trillion monthseg, (u) gwangto construction, (with) ...
national_housing_bondsADD ONCurrency한국어 (Korean)국민주택채권
U.S. EnglishNational Housing Bonds
category_name_durationADD ONSingleSelect한국어 (Korean)신규장기구분명계속비(신규); 신규; 장기
U.S. EnglishNew long-term Category NameGyesokbi (new); New; Long-term
request_target_noticeADD ONSingleSelect한국어 (Korean)고지의뢰대상여부Y
U.S. EnglishNotice whether the request targetY
government_issue_amount_currentAMOUNTCurrency한국어 (Korean)관급자관급금액
U.S. EnglishNow government issue government issue amount
ownershipADD ONNumber한국어 (Korean)지분율e.g., range: 0.83-100
U.S. EnglishOwnershipe.g., range: 0.83-100
construction_periodCONTRACT FEATURESNumber, SingleSelect한국어 (Korean)공사기간
U.S. EnglishPeriod
planned_priceAMOUNTCurrency한국어 (Korean)예정가격
U.S. EnglishPlanned price
public_organizationBUYERText한국어 (Korean)공공기관명e.g., 감사원, 강릉원주대학교, 경상남도 하동군
U.S. EnglishPublic Organizationeg, auditors, Gangneung Wonju Nationa...
number_exceeded_daysCONTRACT FEATURESNumber, SingleSelect한국어 (Korean)초과사유일수1-12, 15, 18, 19, 20, 21, 25, 26, 27,...
U.S. EnglishReason for exceeding the number of days1-12, 15, 18, 19, 20, 21, 25, 26, 27,...
regional_co_contractor_obligationsADD ONSingleSelect한국어 (Korean)공동도급의무지역경기도; 경상북도; 인천광역시; 전라남도; 충청남도
U.S. EnglishRegional co-contractor obligationsGyeonggi-do; Gyeongsangbuk-do; Incheo...
regional_co_contractor_obligations_ratioADD ONSingleSelect, Number한국어 (Korean)지역의무공동도급비율40, 49
U.S. EnglishRegional co-contractor obligations ratio40, 49
standard_delivery_daysCONTRACT FEATURESNumber, SingleSelect한국어 (Korean)표준소요일수10, 40, 42, 48, 53, 67, 73, 76, 77, 7...
U.S. EnglishStandard delivery days can10, 40, 42, 48, 53, 67, 73, 76, 77, 7...
technology_review_contact_nameADD ON한국어 (Korean)기술검토담당자명김혜영
U.S. EnglishTechnology Review Contact NameKim, Hye - Young
tender_notice_numberTENDER TRACKINGNumber한국어 (Korean)입찰공고번호
U.S. EnglishTender notice number
tender_release_dateTENDER FEATURESDateTime한국어 (Korean)입찰서개시일자
U.S. EnglishTender Release Date
joint_guaranteed_company_1ADD ONNumber, Text한국어 (Korean)연대보증업체11048126728-삼성물산(주)
U.S. EnglishThe bond company 11048126728 - Samsung C & T
joint_guaranteed_company_2ADD ONNumber, Text한국어 (Korean)연대보증업체2n/a
U.S. EnglishThe bond company 2n / a
joint_guaranteed_company_3ADD ONNumber, Text한국어 (Korean)연대보증업체3n/a
U.S. EnglishThe bond company 3n / a
highest_bidAMOUNTCurrency한국어 (Korean)낙찰금액
U.S. EnglishThe highest bid
tender_typeTENDER FEATURESSingleSelect한국어 (Korean)표준계약방법명수의계약; 일반경쟁; 제한경쟁
U.S. EnglishThe standard way people contractPrivate contract; Generic competition...
total_amount_bookkeepingAMOUNTCurrency한국어 (Korean)총부기조사금액
U.S. EnglishThe total amount of bookkeeping research
total_required_daysCONTRACT FEATURESNumber, SingleSelect한국어 (Korean)총소요일수
U.S. EnglishThe total number of days required
budget_amountAMOUNTCurrency한국어 (Korean)총공사예산금액
U.S. EnglishTotal construction budget amount
number_bid_participantsAWARD FEATURESNumber한국어 (Korean)투찰자수
U.S. EnglishTuchal embroidery
bid_placeTENDER FEATURESSingleSelect한국어 (Korean)국제입찰여부국내; 국제
U.S. EnglishWhether international biddingDomestic; International
contract_type__AWARD FEATURESSingleSelect한국어 (Korean)공동도급여부공동+분담, 공동이행, 단독도급, 분담이행
U.S. EnglishWhether or not a joint contract+ Co-sharing, joint implementation, a...
joint_obligation_contract_areaADD ONSingleSelect한국어 (Korean)지역의무공동도급여부Y, N
U.S. EnglishWhether or not a joint obligation contract areaY, N
durationADD ONSingleSelect한국어 (Korean)장기여부명당해년도; 장기차년도; 장기초년도
U.S. EnglishWhether people long-termThe year; Long-term fiscal year; Year...
referred_noticeADD ONSingleSelect한국어 (Korean)고지의뢰여부Y
U.S. EnglishWhether the notice referredY
PQ_targetADD ONSingleSelect한국어 (Korean)PQ대상여부명PQ심사대상; PQ심사제외
U.S. EnglishWhether the person targeted PQPQ audited; Except for PQ assessment