Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | PROGRAM_DATUM |
| Short Name | PGD |
| View Name | CI_PROGRAM_DATA |
| Description | A program data construct (cvariable, constrant or user defined |
| exception) used by a module | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: GENERAL_MODULE versionable object ORACLE_OBJECT_TYPE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
GENERAL_MODULE_REFERENCE PLSQL_MODULE_REFERENCE NAME DATA_CONSTRUCT_TYPE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_PGD |
| Changes: | Summary of changes to PROGRAM_DATUM in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| GENERAL_MODULE_REFERENCE | N | Prompt: Module | Must be owned by one and only one GENERAL_MODULE | 94 |
| PLSQL_MODULE_REFERENCE | N | Prompt: PL/SQL Definition | Must be owned by one and only one PLSQL_MODULE | 94 |
| COLUMN_REFERENCE | Y | Prompt: Column | May be defined by one and only one COLUMN | 11 |
| DATASTRUCTURE_REFERENCE | Y | Prompt: Datastructure | May be defined by one and only one DATASTRUCTURE | 11 |
| DOMAIN_REFERENCE | Y | Prompt: Domain | May be defined by one and only one DOMAIN | 11 |
| ORACLE_TYPE_REFERENCE | Y | Prompt: Oracle Type | May be defined by one and only one ORACLE_TYPE | 11 |
| TABLE_DEFINITION_REFERENCE | Y | Prompt: Table Definition | May be defined by one and only one TABLE_DEFINITION | 11 |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| DATA_CONSTRUCT_TYPE | VARCHAR2(9) | N | The data construct type e.g. variable, constant, exception.
Prompt: Construct Type Uppercase | PROGRAM_DATA | CONSTANT |
| DELIMITER | VARCHAR2(70) | Y | Delimiter to be used to separate the data construct name and value.
Prompt: Delimiter | ||
| DESCRIPTION | VARCHAR2(240) | Y | A description of the data construct.
Not displayed | ||
| MODULE_TYPE_FOR | VARCHAR2(3) | N | Arc 94 discriminator. Indicates whether the program datum is owned by a general module or a PL/SQL module
Not displayed Uppercase System maintained Not updatable by user | GEM_OR_PLM | |
| NAME | VARCHAR2(30) | N | The unique name for the programmatic data construct..
Prompt: Name | ||
| OPTIONAL_FLAG | VARCHAR2(1) | N | Indicates whether or not this parameter is mandatory.
Prompt: Optional ? Uppercase | YESNO | Y |
| ORACLE_ERROR_CODE_NUMBER | NUMBER(10, 0) | Y | Contains the oracle error number to be used when program datum is an EXCEPTION_INIT pragma. Applies only when DATA_CONSTRUCT_TYPE = EXCEPTION
Prompt: Oracle Error Code Number | ||
| PROGRAM_DATUM_FOR | VARCHAR2(8) | Y | Arc 11 discriminator. "Optional logical arc" involves foreign key to ITM, DOM, TBL, COL, ORT and the property VALUE_DATATYPE. If discriminator is null, then these 6 will be null, but DATA_CONSTRUCT_TYPE must be 'EXCEPTION'
Not displayed Uppercase System maintained Not updatable by user | PROGRAM_DATUM_FOR | |
| REMARK | VARCHAR2(240) | Y | A comment for the data construct.
Prompt: Comment | ||
| SCOPE | VARCHAR2(10) | N | Scope for the program data construct. (PUBLIC or PRIVATE).
Prompt: Scope Uppercase | PGD_SCOPE | PRIVATE |
| SEQUENCE | NUMBER(6, 0) | N | The sequence in which the program data is used in the module
Prompt: Usage Sequence System maintained: API provides a value only if left null by the user | ||
| VALUE_DATATYPE | VARCHAR2(70) | Y | The datatype or datastructure name for this data construct.
Prompt: Datatype Uppercase | PLS_DATATYPE Non-enforced | |
| VALUE_DEFAULT | VARCHAR2(60) | Y | The default value for the data construct
Prompt: Default Value | ||
| VALUE_DEFAULT_TYPE | VARCHAR2(15) | N | Indicates the nature of the default value
Prompt: Default Value Type Uppercase | DEFAULT_VALUE_TYPE_2 | LITERAL |
| VALUE_LENGTH | NUMBER(6, 0) | Y | The maximum number of characters used to express the value of the data construct.
Prompt: Length | ||
| VALUE_SCALE | NUMBER(3, 0) | Y | The number of decimal places used to express the value of the data construct.
Prompt: Decimal Places | ||
| 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 |
| EXCEPTION_DEFINTITION | CDIDEF | Data Construct Definition |
| FULL_DESRIPTION | CDIDSC | Description |
| HELP | CDHELP | User/Help Text |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
| PROGRAM_DATUM 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:
|
Other element types that reference PROGRAM_DATUM:
Note: