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

ASM OIS/SIS Databases 14.0 ( R16 - 2) / Interface De scription 12/2016 Edition 32 4.5.2.2 TRACK Table TR AC K SIS name Data type B yte I P Reference nu mber of the setup. The reference num ber is equal for all elements o…

100%1 / 144
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
31
Definition of ucRecipeStatus
0: Undefined
1: Recipe is active: triggered by recipe download (SIS Server)
2: Recipe is active: triggered by detection of alternative components
3: Recipe is closed: triggered by subsequent recipe download
4: Recipe is closed: triggered by detection of alternative components
5: Recipe is closed: triggered by the reception of a board produced based on a subsequent recipe
Definition of ucConveyorMode
1: Single lane conveyor
2: Asynchronous dual lane conveyor
3: Synchronous dual lane conveyor
4: Quad Lane in single lane conveyor
5: Quad Lane in asynchronous conveyor mode
6: Quad Lane in synchronous conveyor mode
Obsolete Columns in RECIPE Table
To meet the requirements of new features like Quad Lane support, a recipe may contain assembly
information for more than one board. Until now there was a 1:1 relation between recipe and board.
The board attributes were contained in the RECIPE table. With a 1: n relation between recipe and
boards this is no longer possible.
Starting with SIS data model version 106, the board related information is stored in the SIS BOARD
table. For compatibility reasons, the attributes of the first board entries are stored in the RECIPE
table (using the obsolete marked columns) as well.
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