00900045-01_ID_OIS_SIS_14.0_R16-2_DE_EN - 第33页

ASM OIS/SIS Databases 14.0 ( R16 - 2) / Interface De scription 12/2016 Edition 33 4.5.2.3 DATAMODE L Table D AT AM O DE L SIS name Data t ype Byte I P Name of the entr y strName nvarch ar(32) 64 Value 1 of data type int …

100%1 / 144
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
32
4.5.2.2 TRACK Table
TRACK SIS name Data type Byte I P
Reference number of the setup.
The reference number is equal for all
elements of a station´s setup.
lIdTrack int 4
Feeder type sFeederType smallint 2
Table/location ucTable tinyint 1
Track number sTrack smallint 2
Tower (MTC only, otherwise dummy) ucTower tinyint 1
Level (WPC or MTC only, otherwise dummy) sLevel smallint 2
Division sReceptacle smallint 2
Name of the component strPartNumber nvarchar(128) 256
Name of the component shape strComponentShape nvarchar(128) 256
SIPLACE Pro number for feeder type lFeederType long 4
SIPLACE Pro name for feeder type strFeederTypeName nvarchar(128) 256
SIPLACE Pro number for table type lTableType long 4
SIPLACE Pro name for table type strTableTypeName nvarchar(128) 256
Time when the data is written. Server Time dtCreated datetime 8
SIPLACE Pro used flag ucUsed tinyint 1
This ID uniquely identifies the track entry
within the TRACK table
lIdTrackEntry int 4
Full path of the component (part number)
name
strComponentFullPath nvarchar(1024) 2048
Full path of the component shape name strComponentShapeFullPath nvarchar(1024) 2048
Definition of ucUsed
The ucUsed values indicate whether a track is used by the referred recipe.
Possible values of ucUsed:
0: Undefined
1: True
2: False
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
33
4.5.2.3 DATAMODEL Table
DATAMODEL SIS name Data type Byte I P
Name of the entry strName nvarchar(32) 64
Value 1 of data type int lLong int 4
Value 2 of data type string strString nvarchar(255) 510
Value 3 of data type datetime dtTime datetime 8
Value 4 of data type double dDouble float 8
4.5.2.4 BOARD Table
The BOARD table contains all board related entries. The link between the RECIPE table entry and
the BOARD table entries is the lIdBoard attribute. I.e. if a recipe gets downloaded the board
information is extracted and stored separately in the BOARD table. All new board entries are
getting stored with the same lIdBoard identifier. This identifier is also contained in the RECIPE
table entry to establish the link between the RECIPE table entry and BOARD table entries.
BOARD SIS name Data type Byte CI I P
Board ID lIdBoard int 4
Size of the lot lLotSize int 4
Board name as string strBoardName nvarchar(128) 256
Order ID strOrderId nvarchar(256) 512
Board side ucBoardSide tinyint 1
Subconveyor ID lSubConveyor int 4
Time when the data is written. Server time dtCreated datetime 8
Full path of the board name strBoardFullPath nvarchar(1024) 2048
Count of components lComponentCount int 4
Total count of panels. I.e. the number of
panels of this type that have to be produced.
lPanelLotSize int 4
Definition of ucBoardSide
The ucBoardSide describes whether the top or bottom side of the board has been processed.
Possible values of ucBoardSide:
0: Undefined
1: Top side
2: Bottom side
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
34
4.5.2.5 HEAD Table
The HEAD table is new in the SIS data model version 106 and contains head and gantry related
information. There is a 1:n relation between RECIPE table entry and HEAD table entries. The link
between the RECIPE table entry and HEAD table entries is realized via the lIdHead identifier. The
link mechanism between the RECIPE table entry and HEAD table entries is the same mechanism
as between the RECIPE table entry and BOARD table entries.
HEAD SIS name Data type Byte CI I P
Head ID lIdHead int 4
Gantry number lGantry int 4
Head number ucHead tinyint 1
Head type as string strHeadType nvarchar(128) 256
Bypassed flag bBypassed bit 1
Time when the data is written. Server time t dtCreated datetime 8
4.5.2.6 RECIPEADDON Table
This table contains additional recipe information and has been introduced with SIS 8.0.
RECIPEADDON SIS name Data type Byte CI I P
ID for this recipe related entry lIdRecipe int 4
Processing Area: either 1 or 2 ucProcessingArea tinyint 1
See below ucPlacementMode tinyint 1
Time from first measurement to last
placement activity
lBuildTime int 4
StationTactTime = Build Time + Transport
Time
lStationTactTime int 4
See below lParallelProcessingFactor int 4
Definition of ucPlacementMode
0: Undefined
1: Alternating mode (both gantries place on both lanes)
2: I-Placement mode (right gantry places on the right lane, left gantry places on the left lane)
3: Right (both gantries are placing on the right lane only)
4: Left (both gantries are placing on the left lane only)