MEA.DS_METER_TMP_20200127

SDE Table

Thumbnail Not Available

Tags


Summary

Description

Credits

Use limitations

Extent

Scale Range

ArcGIS Metadata 

Topics and Keywords 

*Content type  Downloadable Data


Citation 

*Title MEA.DS_METER_TMP_20200127


Presentation formats* digital table


Resource Details 

Dataset languages* Thai (THAILAND)


Spatial representation type* text table


*Processing environment  Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9273


ArcGIS item properties
*Name MEA.DS_METER_TMP_20200127
*Location Server=esridbora; Service=sde:oracle$esridbora/meadb; User=mea; Version=SDE.DEFAULT
*Access protocol ArcSDE Connection

Geoprocessing history 

Process
Date 2020-01-27 14:13:21
Tool location c:\program files (x86)\arcgis\desktop10.6\ArcToolbox\Toolboxes\Conversion Tools.tbx\TableToTable
Command issued
TableToTable "Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP" "Database Connections\Connection to esridbora.sde" DS_METER_TMP_20200127 # "MRU "MRU" true true false 8 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,MRU,-1,-1;U_INST "U_INST" true true false 10 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,U_INST,-1,-1;TITLE "TITLE" true true false 70 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,TITLE,-1,-1;NAME "NAME" true true false 40 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,NAME,-1,-1;SURNAME "SURNAME" true true false 40 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,SURNAME,-1,-1;HOUSE_ID "HOUSE_ID" true true false 11 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,HOUSE_ID,-1,-1;HOUSE_NO "HOUSE_NO" true true false 60 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,HOUSE_NO,-1,-1;MOO_VILLAGE "MOO_VILLAGE" true true false 40 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,MOO_VILLAGE,-1,-1;FLOOR "FLOOR" true true false 10 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,FLOOR,-1,-1;SOI "SOI" true true false 40 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,SOI,-1,-1;STREET "STREET" true true false 60 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,STREET,-1,-1;SUBDISTRICT "SUBDISTRICT" true true false 40 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,SUBDISTRICT,-1,-1;DISTRICT "DISTRICT" true true false 40 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,DISTRICT,-1,-1;PROVINCE "PROVINCE" true true false 40 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,PROVINCE,-1,-1;POSTCODE "POSTCODE" true true false 10 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,POSTCODE,-1,-1;TEL "TEL" true true false 30 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,TEL,-1,-1;MEA_NO "MEA_NO" true true false 18 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,MEA_NO,-1,-1;AMP_ALLOW "AMP_ALLOW" true true false 10 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,AMP_ALLOW,-1,-1;VOLT "VOLT" true true false 10 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,VOLT,-1,-1;PHASES "PHASES" true true false 1 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,PHASES,-1,-1;WIRE "WIRE" true true false 1 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,WIRE,-1,-1;MOVE_IN_DATE "MOVE_IN_DATE" true true false 8 Date 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,MOVE_IN_DATE,-1,-1;MOVE_OUT_DATE "MOVE_OUT_DATE" true true false 8 Date 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,MOVE_OUT_DATE,-1,-1;BUSINESS_TYPE "BUSINESS_TYPE" true true false 100 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,BUSINESS_TYPE,-1,-1;TARIFF "TARIFF" true true false 10 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,TARIFF,-1,-1;DISCOUNT "DISCOUNT" true true false 30 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,DISCOUNT,-1,-1;PLACE_TYPE "PLACE_TYPE" true true false 40 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,PLACE_TYPE,-1,-1;STATUS "STATUS" true true false 2 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,STATUS,-1,-1;METER_TYPE "METER_TYPE" true true false 8 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,METER_TYPE,-1,-1;TNO_METER_FL "TNO_METER_FL" true true false 1 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,TNO_METER_FL,-1,-1;KWH_ON_PEAK "KWH_ON_PEAK" true true false 8 Double 0 16 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,KWH_ON_PEAK,-1,-1;KWH_OFF_PEAK "KWH_OFF_PEAK" true true false 8 Double 0 16 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,KWH_OFF_PEAK,-1,-1;KW_ON_PEAK "KW_ON_PEAK" true true false 8 Double 0 16 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,KW_ON_PEAK,-1,-1;KW_OFF_PEAK "KW_OFF_PEAK" true true false 8 Double 0 16 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,KW_OFF_PEAK,-1,-1;KW_PAR_PEAK "KW_PAR_PEAK" true true false 8 Double 0 16 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,KW_PAR_PEAK,-1,-1;KVAR_ON_PEAK "KVAR_ON_PEAK" true true false 8 Double 0 16 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,KVAR_ON_PEAK,-1,-1;KVAR_OFF_PEAK "KVAR_OFF_PEAK" true true false 8 Double 0 16 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,KVAR_OFF_PEAK,-1,-1;KVAR_PAR_PEAK "KVAR_PAR_PEAK" true true false 8 Double 0 16 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,KVAR_PAR_PEAK,-1,-1;MASTER_FLAG "MASTER_FLAG" true true false 1 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,MASTER_FLAG,-1,-1;ROLE_FLAG "ROLE_FLAG" true true false 1 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,ROLE_FLAG,-1,-1;MASTER_NO "MASTER_NO" true true false 10 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,MASTER_NO,-1,-1;STREET_ROUTE "STREET_ROUTE" true true false 6 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,STREET_ROUTE,-1,-1;TEMP_FLAG "TEMP_FLAG" true true false 1 Text 0 0 ,First,#,Database Connections\Connection to esridbora.sde\MEA.DS_METER_TMP,TEMP_FLAG,-1,-1" #
Include in lineage when exporting metadata No


Distribution 

Distribution format
*Name SDE Table


Fields 

Details for object MEA.DS_METER_TMP_20200127 
*Type Table
*Row count 0


Field OBJECTID
 
*Alias OBJECTID
*Data type OID
*Width 4
*Precision 10
*Scale 0
*Field description
Internal feature number.

*Description source
Esri

*Description of values
Sequential unique whole numbers that are automatically generated.





Field MRU
 
*Alias MRU
*Data type String
*Width 8
*Precision 0
*Scale 0




Field U_INST
 
*Alias U_INST
*Data type String
*Width 10
*Precision 0
*Scale 0




Field TITLE
 
*Alias TITLE
*Data type String
*Width 70
*Precision 0
*Scale 0




Field NAME
 
*Alias NAME
*Data type String
*Width 40
*Precision 0
*Scale 0




Field SURNAME
 
*Alias SURNAME
*Data type String
*Width 40
*Precision 0
*Scale 0




Field HOUSE_ID
 
*Alias HOUSE_ID
*Data type String
*Width 11
*Precision 0
*Scale 0




Field HOUSE_NO
 
*Alias HOUSE_NO
*Data type String
*Width 60
*Precision 0
*Scale 0




Field MOO_VILLAGE
 
*Alias MOO_VILLAGE
*Data type String
*Width 40
*Precision 0
*Scale 0




Field FLOOR
 
*Alias FLOOR
*Data type String
*Width 10
*Precision 0
*Scale 0




Field SOI
 
*Alias SOI
*Data type String
*Width 40
*Precision 0
*Scale 0




Field STREET
 
*Alias STREET
*Data type String
*Width 60
*Precision 0
*Scale 0




Field SUBDISTRICT
 
*Alias SUBDISTRICT
*Data type String
*Width 40
*Precision 0
*Scale 0




Field DISTRICT
 
*Alias DISTRICT
*Data type String
*Width 40
*Precision 0
*Scale 0




Field PROVINCE
 
*Alias PROVINCE
*Data type String
*Width 40
*Precision 0
*Scale 0




Field POSTCODE
 
*Alias POSTCODE
*Data type String
*Width 10
*Precision 0
*Scale 0




Field TEL
 
*Alias TEL
*Data type String
*Width 30
*Precision 0
*Scale 0




Field MEA_NO
 
*Alias MEA_NO
*Data type String
*Width 18
*Precision 0
*Scale 0




Field AMP_ALLOW
 
*Alias AMP_ALLOW
*Data type String
*Width 10
*Precision 0
*Scale 0




Field VOLT
 
*Alias VOLT
*Data type String
*Width 10
*Precision 0
*Scale 0




Field PHASES
 
*Alias PHASES
*Data type String
*Width 1
*Precision 0
*Scale 0




Field WIRE
 
*Alias WIRE
*Data type String
*Width 1
*Precision 0
*Scale 0




Field MOVE_IN_DATE
 
*Alias MOVE_IN_DATE
*Data type Date
*Width 8
*Precision 0
*Scale 0




Field MOVE_OUT_DATE
 
*Alias MOVE_OUT_DATE
*Data type Date
*Width 8
*Precision 0
*Scale 0




Field BUSINESS_TYPE
 
*Alias BUSINESS_TYPE
*Data type String
*Width 100
*Precision 0
*Scale 0




Field TARIFF
 
*Alias TARIFF
*Data type String
*Width 10
*Precision 0
*Scale 0




Field DISCOUNT
 
*Alias DISCOUNT
*Data type String
*Width 30
*Precision 0
*Scale 0




Field PLACE_TYPE
 
*Alias PLACE_TYPE
*Data type String
*Width 40
*Precision 0
*Scale 0




Field STATUS
 
*Alias STATUS
*Data type String
*Width 2
*Precision 0
*Scale 0




Field METER_TYPE
 
*Alias METER_TYPE
*Data type String
*Width 8
*Precision 0
*Scale 0




Field TNO_METER_FL
 
*Alias TNO_METER_FL
*Data type String
*Width 1
*Precision 0
*Scale 0




Field KWH_ON_PEAK
 
*Alias KWH_ON_PEAK
*Data type Double
*Width 8
*Precision 16
*Scale 0




Field KWH_OFF_PEAK
 
*Alias KWH_OFF_PEAK
*Data type Double
*Width 8
*Precision 16
*Scale 0




Field KW_ON_PEAK
 
*Alias KW_ON_PEAK
*Data type Double
*Width 8
*Precision 16
*Scale 0




Field KW_OFF_PEAK
 
*Alias KW_OFF_PEAK
*Data type Double
*Width 8
*Precision 16
*Scale 0




Field KW_PAR_PEAK
 
*Alias KW_PAR_PEAK
*Data type Double
*Width 8
*Precision 16
*Scale 0




Field KVAR_ON_PEAK
 
*Alias KVAR_ON_PEAK
*Data type Double
*Width 8
*Precision 16
*Scale 0




Field KVAR_OFF_PEAK
 
*Alias KVAR_OFF_PEAK
*Data type Double
*Width 8
*Precision 16
*Scale 0




Field KVAR_PAR_PEAK
 
*Alias KVAR_PAR_PEAK
*Data type Double
*Width 8
*Precision 16
*Scale 0




Field MASTER_FLAG
 
*Alias MASTER_FLAG
*Data type String
*Width 1
*Precision 0
*Scale 0




Field ROLE_FLAG
 
*Alias ROLE_FLAG
*Data type String
*Width 1
*Precision 0
*Scale 0




Field MASTER_NO
 
*Alias MASTER_NO
*Data type String
*Width 10
*Precision 0
*Scale 0




Field STREET_ROUTE
 
*Alias STREET_ROUTE
*Data type String
*Width 6
*Precision 0
*Scale 0




Field TEMP_FLAG
 
*Alias TEMP_FLAG
*Data type String
*Width 1
*Precision 0
*Scale 0






Metadata Details 

*Metadata language Thai (THAILAND)


Scope of the data described by the metadata* non-geographic dataset
Scope name* dataset


*Last update 2020-01-27


ArcGIS metadata properties
Metadata format ArcGIS 1.0


Created in ArcGIS for the item 2020-01-27 14:02:46
Last modified in ArcGIS for the item 2020-01-27 14:02:46


Automatic updates
Have been performed Yes
Last update 2020-01-27 14:02:46


FGDC Metadata (read-only) 

Entities and Attributes 

Detailed Description
Entity Type
Entity Type LabelMEA.DS_METER_TMP_20200127

Attribute
Attribute LabelOBJECTID
Attribute Definition
Internal feature number.
Attribute Definition SourceEsri
Attribute Domain Values
Unrepresentable Domain
Sequential unique whole numbers that are automatically generated.

Attribute
Attribute LabelMRU

Attribute
Attribute LabelU_INST

Attribute
Attribute LabelTITLE

Attribute
Attribute LabelNAME

Attribute
Attribute LabelSURNAME

Attribute
Attribute LabelHOUSE_ID

Attribute
Attribute LabelHOUSE_NO

Attribute
Attribute LabelMOO_VILLAGE

Attribute
Attribute LabelFLOOR

Attribute
Attribute LabelSOI

Attribute
Attribute LabelSTREET

Attribute
Attribute LabelSUBDISTRICT

Attribute
Attribute LabelDISTRICT

Attribute
Attribute LabelPROVINCE

Attribute
Attribute LabelPOSTCODE

Attribute
Attribute LabelTEL

Attribute
Attribute LabelMEA_NO

Attribute
Attribute LabelAMP_ALLOW

Attribute
Attribute LabelVOLT

Attribute
Attribute LabelPHASES

Attribute
Attribute LabelWIRE

Attribute
Attribute LabelMOVE_IN_DATE

Attribute
Attribute LabelMOVE_OUT_DATE

Attribute
Attribute LabelBUSINESS_TYPE

Attribute
Attribute LabelTARIFF

Attribute
Attribute LabelDISCOUNT

Attribute
Attribute LabelPLACE_TYPE

Attribute
Attribute LabelSTATUS

Attribute
Attribute LabelMETER_TYPE

Attribute
Attribute LabelTNO_METER_FL

Attribute
Attribute LabelKWH_ON_PEAK

Attribute
Attribute LabelKWH_OFF_PEAK

Attribute
Attribute LabelKW_ON_PEAK

Attribute
Attribute LabelKW_OFF_PEAK

Attribute
Attribute LabelKW_PAR_PEAK

Attribute
Attribute LabelKVAR_ON_PEAK

Attribute
Attribute LabelKVAR_OFF_PEAK

Attribute
Attribute LabelKVAR_PAR_PEAK

Attribute
Attribute LabelMASTER_FLAG

Attribute
Attribute LabelROLE_FLAG

Attribute
Attribute LabelMASTER_NO

Attribute
Attribute LabelSTREET_ROUTE

Attribute
Attribute LabelTEMP_FLAG