1. Tables and Views for Project Management
  2. PJF_PERIODS_ALL

PJF_PERIODS_ALL

PJF_PERIODS_ALL stores all the projects accounting period for all the project implemented business unit.

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

PJF_PERIODS_ALL_PK

PERIOD_NAME, ORG_ID

Columns

Name Datatype Length Precision Not-null Comments Status
PERIOD_NAME VARCHAR2 20 Yes The implementation-defined name that uniquely identifies the period Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
START_DATE DATE Yes The start date of the PA period Active
END_DATE DATE Yes The end date of the PA period Active
STATUS VARCHAR2 1 Yes The status of the PA period used to determine if the period can be used for processing Active
GL_PERIOD_NAME VARCHAR2 15 Yes The GL period that matches the PA period Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
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. Active
PERIOD_NUM NUMBER 18 Period Number *****

Foreign Keys

Table Foreign Table Foreign Key Column
PJF_PERIODS_ALL pjf_bu_impl_all ORG_ID
pjc_cost_dist_lines_all pjf_periods_all PRVDR_PA_PERIOD_NAME, ORG_ID
pjc_cost_dist_lines_all pjf_periods_all RECVR_PA_PERIOD_NAME, ORG_ID

Indexes

Index Uniqueness Tablespace Columns Status
PJF_PERIODS_ALL_N1 Non Unique FUSION_TS_TX_DATA STATUS, ORG_ID Active
PJF_PERIODS_ALL_N2 Non Unique FUSION_TS_TX_DATA GL_PERIOD_NAME, ORG_ID Active
PJF_PERIODS_ALL_N3 Non Unique FUSION_TS_TX_DATA END_DATE, START_DATE, PERIOD_NAME Active
PJF_PERIODS_ALL_U1 Unique FUSION_TS_TX_DATA PERIOD_NAME, ORG_ID Active
PJF_PERIODS_ALL_U2 Unique FUSION_TS_TX_DATA ORG_ID, START_DATE, END_DATE Active