PJC_CAPITAL_EVENTS
Stores information about events used to group costs and assets for capitalization and events used to generate retirement cost adjustments. Based on the Event Processing Method defined at the project level, capital events are system generated or entered manually.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
PJC_CAPITAL_EVENTS_PK |
CAPITAL_EVENT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
CAPITAL_EVENT_ID | NUMBER | 18 | Yes | Capital event identifier. | |
PROJECT_ID | NUMBER | 18 | Yes | The system generated number that uniquely identifies the project. | |
CAPITAL_EVENT_NUMBER | NUMBER | 18 | Yes | Number that identifies the event within the Project. | |
EVENT_TYPE | VARCHAR2 | 30 | Yes | Event Classification. Available values are "C" = "Capital" and "R" = "Retirement". | |
EVENT_NAME | VARCHAR2 | 240 | Yes | User defined event name. | |
ASSET_ALLOCATION_METHOD | VARCHAR2 | 30 | Yes | Identifies the method used to allocate indirect and common costs across the assets assigned to a grouping level. | |
EVENT_PERIOD | VARCHAR2 | 15 | General Ledger Period associated with the event. | ||
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. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
PJC_CAPITAL_EVENTS | pjf_projects_all_b | PROJECT_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PJC_CAPITAL_EVENTS_N1 | Non Unique | Default | REQUEST_ID |
PJC_CAPITAL_EVENTS_U1 | Unique | Default | CAPITAL_EVENT_ID |
PJC_CAPITAL_EVENTS_U2 | Unique | Default | PROJECT_ID, CAPITAL_EVENT_NUMBER |