PJS_PROG_IMPL_OPTIONS
This table contains the Program Implementation Options.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJS_PROG_IMPL_OPTIONS_PK |
ENTERPRISE_CALENDAR_ID, ENTERPRISE_PERIOD_SET_NAME, ENTERPRISE_PERIOD_TYPE, PERIOD_MAPPING_METHOD, EXCHANGE_RATE_TYPE, PHYSICAL_PERC_COMP_SOURCE, PERCENT_COMPLETE_DERIV_METHOD, EARNED_VALUE_SOURCE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_CALENDAR_ID | NUMBER | 18 | Yes | Unique identifier for the accounting calendar. The calendar is used to define the periods for project and program performance reporting. | |
| ENTERPRISE_PERIOD_SET_NAME | VARCHAR2 | 15 | Yes | Name of the accounting calendar. | |
| ENTERPRISE_PERIOD_TYPE | VARCHAR2 | 15 | Yes | Accounting period type. Examples are weekly, monthly, and quarterly. | |
| PERIOD_MAPPING_METHOD | VARCHAR2 | 30 | Yes | Method used to map periods when the project accounting calendar period dates aren't the same as the program calendar periods. | |
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Yes | Currency conversion type used to determine the conversion rate between two currencies. | |
| PHYSICAL_PERC_COMP_SOURCE | VARCHAR2 | 30 | Yes | Represents the source for deriving physical percentage complete. | |
| PERCENT_COMPLETE_DERIV_METHOD | VARCHAR2 | 30 | Yes | Method of deriving percentage completion. | |
| EARNED_VALUE_SOURCE | VARCHAR2 | 30 | Yes | Column to store source of earned values. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ADDL_ATTRIBUTE1 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| ADDL_ATTRIBUTE2 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| ADDL_ATTRIBUTE3 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| ADDL_ATTRIBUTE4 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| ADDL_ATTRIBUTE5 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| ADDL_ATTRIBUTE_NUM1 | NUMBER | Column supporting numeric characters reserved for internal use. | |||
| ADDL_ATTRIBUTE_NUM2 | NUMBER | Column supporting numeric characters reserved for internal use. | |||
| ADDL_ATTRIBUTE_NUM3 | NUMBER | Column supporting numeric characters reserved for internal use. | |||
| ADDL_ATTRIBUTE_NUM4 | NUMBER | Column supporting numeric characters reserved for internal use. | |||
| ADDL_ATTRIBUTE_NUM5 | NUMBER | Column supporting numeric characters reserved for internal use. | |||
| EXCHANGE_RATE_DATE_TYPE | VARCHAR2 | 30 | Date used for converting currency transactions between two currencies. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJS_PROG_IMPL_OPTIONS_U1 | Unique | Default | ENTERPRISE_CALENDAR_ID, ENTERPRISE_PERIOD_SET_NAME, ENTERPRISE_PERIOD_TYPE, PERIOD_MAPPING_METHOD, EXCHANGE_RATE_TYPE, PHYSICAL_PERC_COMP_SOURCE, PERCENT_COMPLETE_DERIV_METHOD, EARNED_VALUE_SOURCE |