1. Tables and Views for Project Management
  2. PJF_PROJECT_BUILDER

PJF_PROJECT_BUILDER

This table contains a list of all classes that implement the IProjectBuilder interface and participate in the copy template and project opertation. It contains parameters for how the operation is to proceed.

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

PJF_PROJECT_BUILDER_PK

BUILDER

Columns

Name Datatype Length Precision Not-null Comments
PASS NUMBER 18 Yes The pass this builder run. There are four passes as of the writing of this comment.
SEQUENCE NUMBER 18 Yes The sequence this builder is called in the pass.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
PRODUCT_LBA VARCHAR2 3 Optional LBA.
PRODUCT_SUBLBA VARCHAR2 20 Optional SubLBA.
BUILDER VARCHAR2 127 Yes Fully qualified builder class name.
PROJECT_OPTS_MASK NUMBER 18 The project options mask used to determine if this builder is called based on the project options selected by the user.
REQUIRED VARCHAR2 1 If required = Y then if the builder fails to load the create process fails. If required = N then if the builder fails to load, it is ignored.
ENABLED VARCHAR2 1 If this builder is enabled to run this column should be 'Y'.
MSP_PASS NUMBER 18 The pass this builder run for MSP create. There are four passes as of the writing of this comment.
MSP_SEQUENCE NUMBER 18 The sequence this builder is called in the pass for MSP create.
MSP_ENABLED VARCHAR2 1 If this builder is enabled to run when creating from MSP, this column should be 'Y'.
ERR_PROJ_MSG VARCHAR2 30 ERR_PROJ_MSG
ERR_TEMP_MSG VARCHAR2 30 ERR_TEMP_MSG
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
FIN_PASS NUMBER 18 The pass this builder run while creating unified project. The builder in the same pass can be run in parallel.
FIN_SEQUENCE NUMBER 18 The sequence this builder is called in the pass while creating a unified project.
FIN_ENABLED VARCHAR2 1 If this builder is enabled to run when creating unified project, this column should be 'Y'.
EXE_PASS NUMBER 18 The pass this builder run while creating execution only project. The builder in the same pass can be run in parallel.
EXE_SEQUENCE NUMBER 10 The sequence this builder is called in the pass while creating a execution project.
EXE_ENABLED VARCHAR2 1 If this builder is enabled to run when creating execution project, this column should be 'Y'.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Indexes

Index Uniqueness Tablespace Columns
PJF_PROJECT_BUILDER_U0 Unique Default PASS, SEQUENCE, ORA_SEED_SET1
PJF_PROJECT_BUILDER_U01 Unique Default PASS, SEQUENCE, ORA_SEED_SET2
PJF_PROJECT_BUILDER_U1 Unique Default MSP_PASS, MSP_SEQUENCE, ORA_SEED_SET1
PJF_PROJECT_BUILDER_U11 Unique Default MSP_PASS, MSP_SEQUENCE, ORA_SEED_SET2
PJF_PROJECT_BUILDER_U2 Unique Default BUILDER, ORA_SEED_SET1
PJF_PROJECT_BUILDER_U21 Unique Default BUILDER, ORA_SEED_SET2