FPSBASE.RTG_BANKS

Data Dictionary

>

FPSBASE Tables

> FPSBASE.RTG_BANKS

Table FPSBASE.RTG_BANKS"

Information about each bank. Lots must be either on a route with a step or at a bank. If a lot goes to a bank in the middle of the route we do not count that time towards the route cycle time.

Schema: FPSBASE
Tablespace: FPSDATA
Primary key: FACILITY, BANK
Foreign keys: RTG_BANKS_FK_FAC: FACILITY REFERENCES FPSINPUT.GEN_FACILITIES (FACILITY)

Column	Type	Nullable	Comment
FACILITY	VARCHAR2(6)	N	Facility is included in almost every join in the DWH so this represents a definitive split. A route must have all steps on tools in the same facility. A tool must process all lots in the same facility. If your site has multiple buildings where lots run on routes using tools in multiple buildings then everything should be one facility. For example, multiple Fab buildings. But if your site has independent facilities like Fab and Test and Assembly where lot may progress from one to the next but on different routes then these should be different facilities. Since this column is in virtually every table it is critical that the value here is exactly matches what is in the MES if the MES has facility. Use facility_display for the display friendly name displayed in applications. See site_name comment for client/site/facility example. (* from FPSINPUT.GEN_FACILITIES)
BANK	VARCHAR2(36)	N	Lots which are not on a route are considered in a bank and the bank name indicates why the lot is off route. Bank must be NA for lots which are on a route. Our standard filter for active lots is bank = NA.
COMMIT_CT_DAYS	NUMBER(5,1)		Number of days of cycle time committed to the customer for the prd or bank. This commit is published externally. This should be greater than or equal to the target.
DESCRIPTION	VARCHAR2(256)		Tool desciption. This value is only used to display in the Dashboard. (* from FPSINPUT.EQP_TOOLS)
IS_DIE_BANK_FOR_CTM	CHAR(1)		We treat the die bank as a special bank regardless of the facility in our finished lot cycle time logic. Often there are die banks within each facility and we sum them together and count these die separately from other banks.
KEEP_MAIN_ROUTE_ACTIVE	CHAR(1)		One way to reduce the number of active routes is to not activate the main_route of lots that have been sitting in a bank for awhile. To do this, set this column to N.
OVR_FACILITY_OF_BANK	VARCHAR2(6)		Occasionally a lot is of a prd owned by one facility but at a bank owned by another facility. Here we can indicate the facility which owns the bank. When reporting lots in bank, we will show the total by the facility of the prd as well as the total by facility of the bank.
OVR_LINE_SECTION_OF_BANK	VARCHAR2(32)		This column sets the line section for lots in a bank for both WIP_LOTS and WIP_STEP_HIST. If this value is not populated for the bank then we get line section from the main route and step if populated. If not, we have a default for the prd otherwise we just set the default for the facility.
TARGET_CT_DAYS	NUMBER(5,1)		Number of days of cycle time targeted for the prd or bank. This target is only published internally which often means it is not even published to corporate planning. This should be less than or equal to the commit.