DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_PROJ_PERIOD_PROFILES

Object Details
Object Name: PA_PROJ_PERIOD_PROFILES
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_PROJ_PERIOD_PROFILES
Subobject Name:
Status: VALID


This table stores the period profile information that is used for reporting purposes. The purpose of this table is to hold 52 period buckets that indicate the periods and their corresponding start and end dates for which values can be displayed in a matrix format. Users can set up period profiles for each project


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_PROJ_PERIOD_PROFILES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIOD_PROFILE_ID
PA_PROJ_PERIOD_PROFILES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnPERIOD_PROFILE_TYPE
ColumnPLAN_PERIOD_TYPE
ColumnGL_PERIOD_TYPE
ColumnPERIOD_SET_NAME
Columns
Name Datatype Length Mandatory Comments
PERIOD_PROFILE_ID NUMBER (15) Yes The system generated number that uniquely identifies the period profile
PERIOD_PROFILE_TYPE VARCHAR2 (30) Yes Stores the type of the Period Profile. Currently, the profile type is used only for Financial Planning purposes
PROJECT_ID NUMBER (15) Yes Identifier of the project for which the period profile has been set up
PERIOD_SET_NAME VARCHAR2 (15) Yes Stores the Period Set Name for the Operating Unit
GL_PERIOD_TYPE VARCHAR2 (15) Yes Stores the GL Period Type
PLAN_PERIOD_TYPE VARCHAR2 (30) Yes Indicates the Period type. Period_name1 to Period_name52 will hold the PA or GL period names based on the value in this column.
NUMBER_OF_PERIODS NUMBER (15)
Indicates the number of periods in the profile.
PERIOD_NAME1 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME2 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME3 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME4 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME5 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME6 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME7 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME8 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME9 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME10 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME11 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME12 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME13 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME14 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME15 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME16 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME17 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME18 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME19 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME20 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME21 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME22 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME23 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME24 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME25 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME26 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME27 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME28 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME29 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME30 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME31 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME32 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME33 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME34 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME35 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME36 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME37 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME38 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME39 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME40 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME41 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME42 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME43 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME44 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME45 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME46 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME47 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME48 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME49 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME50 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME51 VARCHAR2 (30)
Stores the Period Name
PERIOD_NAME52 VARCHAR2 (30)
Stores the Period Name
PERIOD1_START_DATE DATE

Stores the Start Date of the Period
PERIOD2_START_DATE DATE

Stores the Start Date of the Period
PERIOD3_START_DATE DATE

Stores the Start Date of the Period
PERIOD4_START_DATE DATE

Stores the Start Date of the Period
PERIOD5_START_DATE DATE

Stores the Start Date of the Period
PERIOD6_START_DATE DATE

Stores the Start Date of the Period
PERIOD7_START_DATE DATE

Stores the Start Date of the Period
PERIOD8_START_DATE DATE

Stores the Start Date of the Period
PERIOD9_START_DATE DATE

Stores the Start Date of the Period
PERIOD10_START_DATE DATE

Stores the Start Date of the Period
PERIOD11_START_DATE DATE

Stores the Start Date of the Period
PERIOD12_START_DATE DATE

Stores the Start Date of the Period
PERIOD13_START_DATE DATE

Stores the Start Date of the Period
PERIOD14_START_DATE DATE

Stores the Start Date of the Period
PERIOD15_START_DATE DATE

Stores the Start Date of the Period
PERIOD16_START_DATE DATE

Stores the Start Date of the Period
PERIOD17_START_DATE DATE

Stores the Start Date of the Period
PERIOD18_START_DATE DATE

Stores the Start Date of the Period
PERIOD19_START_DATE DATE

Stores the Start Date of the Period
PERIOD20_START_DATE DATE

Stores the Start Date of the Period
PERIOD21_START_DATE DATE

Stores the Start Date of the Period
PERIOD22_START_DATE DATE

Stores the Start Date of the Period
PERIOD23_START_DATE DATE

Stores the Start Date of the Period
PERIOD24_START_DATE DATE

Stores the Start Date of the Period
PERIOD25_START_DATE DATE

Stores the Start Date of the Period
PERIOD26_START_DATE DATE

Stores the Start Date of the Period
PERIOD27_START_DATE DATE

Stores the Start Date of the Period
PERIOD28_START_DATE DATE

Stores the Start Date of the Period
PERIOD29_START_DATE DATE

Stores the Start Date of the Period
PERIOD30_START_DATE DATE

Stores the Start Date of the Period
PERIOD31_START_DATE DATE

Stores the Start Date of the Period
PERIOD32_START_DATE DATE

Stores the Start Date of the Period
PERIOD33_START_DATE DATE

Stores the Start Date of the Period
PERIOD34_START_DATE DATE

Stores the Start Date of the Period
PERIOD35_START_DATE DATE

Stores the Start Date of the Period
PERIOD36_START_DATE DATE

Stores the Start Date of the Period
PERIOD37_START_DATE DATE

Stores the Start Date of the Period
PERIOD38_START_DATE DATE

Stores the Start Date of the Period
PERIOD39_START_DATE DATE

Stores the Start Date of the Period
PERIOD40_START_DATE DATE

Stores the Start Date of the Period
PERIOD41_START_DATE DATE

Stores the Start Date of the Period
PERIOD42_START_DATE DATE

Stores the Start Date of the Period
PERIOD43_START_DATE DATE

Stores the Start Date of the Period
PERIOD44_START_DATE DATE

Stores the Start Date of the Period
PERIOD45_START_DATE DATE

Stores the Start Date of the Period
PERIOD46_START_DATE DATE

Stores the Start Date of the Period
PERIOD47_START_DATE DATE

Stores the Start Date of the Period
PERIOD48_START_DATE DATE

Stores the Start Date of the Period
PERIOD49_START_DATE DATE

Stores the Start Date of the Period
PERIOD50_START_DATE DATE

Stores the Start Date of the Period
PERIOD51_START_DATE DATE

Stores the Start Date of the Period
PERIOD52_START_DATE DATE

Stores the Start Date of the Period
PERIOD1_END_DATE DATE

Stores the End Date of the Period
PERIOD2_END_DATE DATE

Stores the End Date of the Period
PERIOD3_END_DATE DATE

Stores the End Date of the Period
PERIOD4_END_DATE DATE

Stores the End Date of the Period
PERIOD5_END_DATE DATE

Stores the End Date of the Period
PERIOD6_END_DATE DATE

Stores the End Date of the Period
PERIOD7_END_DATE DATE

Stores the End Date of the Period
PERIOD8_END_DATE DATE

Stores the End Date of the Period
PERIOD9_END_DATE DATE

Stores the End Date of the Period
PERIOD10_END_DATE DATE

Stores the End Date of the Period
PERIOD11_END_DATE DATE

Stores the End Date of the Period
PERIOD12_END_DATE DATE

Stores the End Date of the Period
PERIOD13_END_DATE DATE

Stores the End Date of the Period
PERIOD14_END_DATE DATE

Stores the End Date of the Period
PERIOD15_END_DATE DATE

Stores the End Date of the Period
PERIOD16_END_DATE DATE

Stores the End Date of the Period
PERIOD17_END_DATE DATE

Stores the End Date of the Period
PERIOD18_END_DATE DATE

Stores the End Date of the Period
PERIOD19_END_DATE DATE

Stores the End Date of the Period
PERIOD20_END_DATE DATE

Stores the End Date of the Period
PERIOD21_END_DATE DATE

Stores the End Date of the Period
PERIOD22_END_DATE DATE

Stores the End Date of the Period
PERIOD23_END_DATE DATE

Stores the End Date of the Period
PERIOD24_END_DATE DATE

Stores the End Date of the Period
PERIOD25_END_DATE DATE

Stores the End Date of the Period
PERIOD26_END_DATE DATE

Stores the End Date of the Period
PERIOD27_END_DATE DATE

Stores the End Date of the Period
PERIOD28_END_DATE DATE

Stores the End Date of the Period
PERIOD29_END_DATE DATE

Stores the End Date of the Period
PERIOD30_END_DATE DATE

Stores the End Date of the Period
PERIOD31_END_DATE DATE

Stores the End Date of the Period
PERIOD32_END_DATE DATE

Stores the End Date of the Period
PERIOD33_END_DATE DATE

Stores the End Date of the Period
PERIOD34_END_DATE DATE

Stores the End Date of the Period
PERIOD35_END_DATE DATE

Stores the End Date of the Period
PERIOD36_END_DATE DATE

Stores the End Date of the Period
PERIOD37_END_DATE DATE

Stores the End Date of the Period
PERIOD38_END_DATE DATE

Stores the End Date of the Period
PERIOD39_END_DATE DATE

Stores the End Date of the Period
PERIOD40_END_DATE DATE

Stores the End Date of the Period
PERIOD41_END_DATE DATE

Stores the End Date of the Period
PERIOD42_END_DATE DATE

Stores the End Date of the Period
PERIOD43_END_DATE DATE

Stores the End Date of the Period
PERIOD44_END_DATE DATE

Stores the End Date of the Period
PERIOD45_END_DATE DATE

Stores the End Date of the Period
PERIOD46_END_DATE DATE

Stores the End Date of the Period
PERIOD47_END_DATE DATE

Stores the End Date of the Period
PERIOD48_END_DATE DATE

Stores the End Date of the Period
PERIOD49_END_DATE DATE

Stores the End Date of the Period
PERIOD50_END_DATE DATE

Stores the End Date of the Period
PERIOD51_END_DATE DATE

Stores the End Date of the Period
PERIOD52_END_DATE DATE

Stores the End Date of the Period
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column
CURRENT_FLAG VARCHAR2 (1)
Flag that indicates whether this is the current period profile for the period type
PROFILE_END_PERIOD_NAME VARCHAR2 (30)
Stores the end period in the period profile.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PERIOD_PROFILE_ID
,      PERIOD_PROFILE_TYPE
,      PROJECT_ID
,      PERIOD_SET_NAME
,      GL_PERIOD_TYPE
,      PLAN_PERIOD_TYPE
,      NUMBER_OF_PERIODS
,      PERIOD_NAME1
,      PERIOD_NAME2
,      PERIOD_NAME3
,      PERIOD_NAME4
,      PERIOD_NAME5
,      PERIOD_NAME6
,      PERIOD_NAME7
,      PERIOD_NAME8
,      PERIOD_NAME9
,      PERIOD_NAME10
,      PERIOD_NAME11
,      PERIOD_NAME12
,      PERIOD_NAME13
,      PERIOD_NAME14
,      PERIOD_NAME15
,      PERIOD_NAME16
,      PERIOD_NAME17
,      PERIOD_NAME18
,      PERIOD_NAME19
,      PERIOD_NAME20
,      PERIOD_NAME21
,      PERIOD_NAME22
,      PERIOD_NAME23
,      PERIOD_NAME24
,      PERIOD_NAME25
,      PERIOD_NAME26
,      PERIOD_NAME27
,      PERIOD_NAME28
,      PERIOD_NAME29
,      PERIOD_NAME30
,      PERIOD_NAME31
,      PERIOD_NAME32
,      PERIOD_NAME33
,      PERIOD_NAME34
,      PERIOD_NAME35
,      PERIOD_NAME36
,      PERIOD_NAME37
,      PERIOD_NAME38
,      PERIOD_NAME39
,      PERIOD_NAME40
,      PERIOD_NAME41
,      PERIOD_NAME42
,      PERIOD_NAME43
,      PERIOD_NAME44
,      PERIOD_NAME45
,      PERIOD_NAME46
,      PERIOD_NAME47
,      PERIOD_NAME48
,      PERIOD_NAME49
,      PERIOD_NAME50
,      PERIOD_NAME51
,      PERIOD_NAME52
,      PERIOD1_START_DATE
,      PERIOD2_START_DATE
,      PERIOD3_START_DATE
,      PERIOD4_START_DATE
,      PERIOD5_START_DATE
,      PERIOD6_START_DATE
,      PERIOD7_START_DATE
,      PERIOD8_START_DATE
,      PERIOD9_START_DATE
,      PERIOD10_START_DATE
,      PERIOD11_START_DATE
,      PERIOD12_START_DATE
,      PERIOD13_START_DATE
,      PERIOD14_START_DATE
,      PERIOD15_START_DATE
,      PERIOD16_START_DATE
,      PERIOD17_START_DATE
,      PERIOD18_START_DATE
,      PERIOD19_START_DATE
,      PERIOD20_START_DATE
,      PERIOD21_START_DATE
,      PERIOD22_START_DATE
,      PERIOD23_START_DATE
,      PERIOD24_START_DATE
,      PERIOD25_START_DATE
,      PERIOD26_START_DATE
,      PERIOD27_START_DATE
,      PERIOD28_START_DATE
,      PERIOD29_START_DATE
,      PERIOD30_START_DATE
,      PERIOD31_START_DATE
,      PERIOD32_START_DATE
,      PERIOD33_START_DATE
,      PERIOD34_START_DATE
,      PERIOD35_START_DATE
,      PERIOD36_START_DATE
,      PERIOD37_START_DATE
,      PERIOD38_START_DATE
,      PERIOD39_START_DATE
,      PERIOD40_START_DATE
,      PERIOD41_START_DATE
,      PERIOD42_START_DATE
,      PERIOD43_START_DATE
,      PERIOD44_START_DATE
,      PERIOD45_START_DATE
,      PERIOD46_START_DATE
,      PERIOD47_START_DATE
,      PERIOD48_START_DATE
,      PERIOD49_START_DATE
,      PERIOD50_START_DATE
,      PERIOD51_START_DATE
,      PERIOD52_START_DATE
,      PERIOD1_END_DATE
,      PERIOD2_END_DATE
,      PERIOD3_END_DATE
,      PERIOD4_END_DATE
,      PERIOD5_END_DATE
,      PERIOD6_END_DATE
,      PERIOD7_END_DATE
,      PERIOD8_END_DATE
,      PERIOD9_END_DATE
,      PERIOD10_END_DATE
,      PERIOD11_END_DATE
,      PERIOD12_END_DATE
,      PERIOD13_END_DATE
,      PERIOD14_END_DATE
,      PERIOD15_END_DATE
,      PERIOD16_END_DATE
,      PERIOD17_END_DATE
,      PERIOD18_END_DATE
,      PERIOD19_END_DATE
,      PERIOD20_END_DATE
,      PERIOD21_END_DATE
,      PERIOD22_END_DATE
,      PERIOD23_END_DATE
,      PERIOD24_END_DATE
,      PERIOD25_END_DATE
,      PERIOD26_END_DATE
,      PERIOD27_END_DATE
,      PERIOD28_END_DATE
,      PERIOD29_END_DATE
,      PERIOD30_END_DATE
,      PERIOD31_END_DATE
,      PERIOD32_END_DATE
,      PERIOD33_END_DATE
,      PERIOD34_END_DATE
,      PERIOD35_END_DATE
,      PERIOD36_END_DATE
,      PERIOD37_END_DATE
,      PERIOD38_END_DATE
,      PERIOD39_END_DATE
,      PERIOD40_END_DATE
,      PERIOD41_END_DATE
,      PERIOD42_END_DATE
,      PERIOD43_END_DATE
,      PERIOD44_END_DATE
,      PERIOD45_END_DATE
,      PERIOD46_END_DATE
,      PERIOD47_END_DATE
,      PERIOD48_END_DATE
,      PERIOD49_END_DATE
,      PERIOD50_END_DATE
,      PERIOD51_END_DATE
,      PERIOD52_END_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CURRENT_FLAG
,      PROFILE_END_PERIOD_NAME
FROM PA.PA_PROJ_PERIOD_PROFILES;

Dependencies

[top of page]

PA.PA_PROJ_PERIOD_PROFILES does not reference any database object

PA.PA_PROJ_PERIOD_PROFILES is referenced by following:

SchemaAPPS
SynonymPA_PROJ_PERIOD_PROFILES