PJS_PROGRAM_DEFN_B
This table contains program related data.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJS_PROGRAM_DEFN_B_PK |
PROGRAM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROGRAM_ID | NUMBER | 18 | Yes | System-generated number that uniquely identifies the program. | |
| PROGRAM_BUDGET | NUMBER | Budget of the program. | |||
| PARENT_PROGRAM_ID | NUMBER | 18 | Unique identifier of the parent program. The value is null for root program. | ||
| PROGRAM_NUMBER | VARCHAR2 | 25 | Yes | Unique number used to identify the program. | |
| PROGRAM_STATUS_CODE | VARCHAR2 | 30 | Yes | Code from table PJF_PROJECT_STATUSES_B that represents the user-defined status of the program. | |
| PROGRAM_SYSTEM_STATUS_CODE | VARCHAR2 | 30 | Code from table PJF_PROJECT_STATUSES_B that represents the system status of the program. | ||
| OWNING_ORGANIZATION_ID | NUMBER | 18 | Unique identifier of the owning organization. | ||
| LOB_CODE | VARCHAR2 | 30 | Code from lookup type ORA_PROJECT_PROGRAM_BUSINESS that represents the line of business name for the set of products and services managed by the program. | ||
| STRATEGY_CODE | VARCHAR2 | 30 | Code from lookup type ORA_PROJECT_PROGRAM_STRATEGY that represents the strategic plan of actions and policies targeted by the project program. An example strategy is innovation. | ||
| START_DATE | DATE | Date on which work or information tracking starts on the program. | |||
| END_DATE | DATE | Date when the program is finished. | |||
| ASSESSMENT_CODE | VARCHAR2 | 30 | Code from lookup type ORA_PROJECT_PROGRAM_ASSESSMENT that represents the program owner's ongoing assessment for the likelihood that the program will meet the program objectives. | ||
| PRIORITY_CODE | VARCHAR2 | 30 | Code from lookup type ORA_PROJECT_PROGRAM_PRIORITY that represents the priority for the program. Example priorities are HIGH, MEDIUM, and LOW. | ||
| PUBLIC_FLAG | VARCHAR2 | 1 | Yes | Defined at the root node, the value Indicates whether the program hierarchy can be viewed by all. If yes, then the hierarchy can be viewed by all. If no, then only the persons that are assigned to the programs can view their programs. | |
| PROGRAM_LEVEL | NUMBER | 2 | Yes | Level of the program in the program hierarchy. The root node is level zero. | |
| REGION_CODE | VARCHAR2 | 30 | Region of the program from lookup code | ||
| TREE_STRUCTURE_ID | NUMBER | 18 | Yes | Unique identifier of the program hierarchy tree structure. | |
| 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. | |
| 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_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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE31 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE32 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE33 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE34 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE35 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE36 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE37 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE38 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE39 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE40 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE41 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE42 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE43 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE44 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE45 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE46 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE47 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE48 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE49 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE50 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER11 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER12 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER13 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER14 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER15 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE11 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE12 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE13 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE14 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE15 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ADDL_ATTR_CHAR1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTR_CHAR2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTR_CHAR3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTR_CHAR4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTR_CHAR5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTR_CHAR6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTR_CHAR7 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTR_CHAR8 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTR_CHAR9 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTR_CHAR10 | VARCHAR2 | 150 | Oracle internal use only. | ||
| PROGRAM_BUDGET_CURRENCY | VARCHAR2 | 15 | Currency used for the program budget. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJS_PROGRAM_DEFN_B_N1 | Non Unique | Default | PARENT_PROGRAM_ID, TREE_STRUCTURE_ID, PROGRAM_LEVEL |
| PJS_PROGRAM_DEFN_B_N2 | Non Unique | Default | PROGRAM_STATUS_CODE, START_DATE, END_DATE |
| PJS_PROGRAM_DEFN_B_N3 | Non Unique | Default | OWNING_ORGANIZATION_ID |
| PJS_PROGRAM_DEFN_B_N4 | Non Unique | Default | LAST_UPDATE_DATE |
| PJS_PROGRAM_DEFN_B_N5 | Non Unique | Default | LOB_CODE, STRATEGY_CODE, ASSESSMENT_CODE, REGION_CODE |
| PJS_PROGRAM_DEFN_B_N6 | Non Unique | Default | TREE_STRUCTURE_ID |
| PJS_PROGRAM_DEFN_B_U1 | Unique | Default | PROGRAM_ID |
| PJS_PROGRAM_DEFN_B_U2 | Unique | Default | PROGRAM_NUMBER |
| PJS_PROGRAM_DEFN_B_U3 | Unique | Default | UPPER("PROGRAM_NUMBER") |