Element Type Definition: BATCH

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	BATCH_RUN
Short Name	BRU
View Name	CI_BATCH_RUNS
Description	A specific run of a batch

Sub-type of	SECONDARY_ACCESS_ELEMENT
Versioning:	Belongs to: BATCH versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	BATCH_REFERENCE BATCH_LABEL
Used by:	Oracle Designer
Underlying table:	SDD_BRU

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
BATCH_REFERENCE	N	Prompt: Batch Transferable only if null	Must be a specific run of one and only one BATCH

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
BATCH_LABEL	VARCHAR2(100)	N	Label by which this run of the batch can be identified Prompt: Label
DATE_TIME_COMPLETED	DATE	Y	Date and time this run of the batch was completed Prompt: Date/Time Completed
DATE_TIME_STARTED	DATE	Y	Date and time this run of the batch started Prompt: Date/Time Started
STATUS	VARCHAR2(11)	N	Status of this run of the batch Prompt: Status Uppercase	BATCH_RUN_STATUS	NOT_STARTED
PARENT_IVID	NUMBER(38, 0)	Y	Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs Not displayed System maintained Updatable only if null Defined on SAC supertype
PAC_REFERENCE	NUMBER(38, 0)	Y	Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs Not displayed System maintained Not updatable by user Defined on SAC supertype

Multi-line Text
Name	Text Type	Prompt

Other Properties
BATCH_RUN has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility
The following 'standard' properties are also inherited by all element types: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference BATCH_RUN:

Each BATCHLINE_RUN must be part of one and only one BATCH_RUN
Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype