[Home] [Help] [Dependency Information]
Object Name: | FEM_CAL_PERIODS_ATTR_T |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
FEM_CAL_PERIODS_ATTR_T is an interface table for loading and updating Calendar Period attribute assignments using the Dimension Member Loader. These attribute assignments are properties that further describe each Calendar Period. When loading Calendar Periods using the Dimension Member Loader, identify each new member in the FEM_CAL_PERIODS_B_T table while providing an assignment row for each required attribute in the FEM_CAL_PERIODS_ATTR_T table. Only members with valid assignments for all Calendar Period dimension required attributes will be successfully loaded by the Dimension Member Loader.
Each distinct Calendar Period member is always identified by the following in the Calendar Period interface tables:
Calendar (in the CALENDAR_DISPLAY_CODE column)
Level (in the DIMENSION_GROUP_DISPLAY_CODE column)
End Date (in the CAL_PERIOD_END_DATE column)
Period Number (in the CAL_PERIOD_NUMBER column)
The other columns in the FEM_CAL_PERIODS_ATTR_T table are:
ATTRIBUTE_VARCHAR_LABEL - This column identifies the attribute
VERSION_DISPLAY_CODE - This column identifies the attribute version to which the assignment applies
ATTR_ASSIGN_VS_DISPLAY_CODE - Normally this column should be null. It is only populated if the attribute being assigned uses a Value Set dimension as the list of values for assignments. In which case, you populate this column with the Display Code that identifies the Value Set of that list of values dimension.
STATUS - This column designates the loading status for the record. You will initially populate it as 'LOAD', thereby indicating that the Dimension Member loader should try to load the record into the Enterprise Performance Foundation database. If there is a problem with the record or the member being loaded, the loader will update this column with an error code that specifies the problem encountered.
CREATED_BY_DIM_MIGRATION_FLAG - Always leave this column as null for your loads. Enterprise Performance Foundation uses this column for Dimension Migration loads.
The 4 CALPATTR columns (CALPATTR_CAL_DISPLAY_CODE, CALPATTR_DIMGRP_DISPLAY_CODE, CALPATTR_END_DATE and CALPATTR_PERIOD_NUM) are columns that should normally remain null. Only populate these columns if the attribute being assigned uses the Calendar Period dimension as the list of values for assignments. In which case, you populate these columns with the 4 (external) identifying components of a Calendar Period member. The columns are as follows:
CALPATTR_CAL_DISPLAY_CODE - This is the Display Code identifying the Calendar for the Calendar Period member.
CALPATTR_DIMGRP_DISPLAY_CODE - This is the Display Code identifying the Level for the Calendar Period member.
CALPATTR_END_DATE - This is the End Date of the Calendar Period member.
CALPATTR_PERIOD_NUM - This is the Period Number of the Calendar Period member.
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic Calendar Period Attribute Assignment
Category: BUSINESS_ENTITY FEM_XDIM_CAL_PERIOD
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_CAL_PERIODS_ATTR_T_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE |
CAL_PERIOD_END_DATE
CAL_PERIOD_NUMBER CALENDAR_DISPLAY_CODE DIMENSION_GROUP_DISPLAY_CODE ATTRIBUTE_VARCHAR_LABEL VERSION_DISPLAY_CODE ATTRIBUTE_ASSIGN_VALUE ATTR_ASSIGN_VS_DISPLAY_CODE CALPATTR_CAL_DISPLAY_CODE CALPATTR_DIMGRP_DISPLAY_CODE CALPATTR_END_DATE CALPATTR_PERIOD_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAL_PERIOD_END_DATE | DATE | Yes | The end date of the Calendar Period | |
CAL_PERIOD_NUMBER | NUMBER | (15) | Yes | The relative number of the period within a given year |
ATTRIBUTE_VARCHAR_LABEL | VARCHAR2 | (30) | Yes | Non translatable alphanumeric code that identifies the attribute |
ATTRIBUTE_ASSIGN_VALUE | VARCHAR2 | (1000) | Value of the attribute assignment | |
ATTR_ASSIGN_VS_DISPLAY_CODE | VARCHAR2 | (150) | Value Set display code of the attribute assignment dimension member | |
STATUS | VARCHAR2 | (30) | Yes | Load status of the record |
CALENDAR_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Non translatable alphanumeric code identifying the Calendar |
DIMENSION_GROUP_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Non translatable alphanumeric identifier of the level |
VERSION_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Non translatable alphanumeric identifier for the attribute version |
CALPATTR_CAL_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alpahnumeric identifier of the Calendar that is a component of the attribute assignment when the attribute references the Calendar Period dimension as a list of values | |
CALPATTR_DIMGRP_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alpahnumeric identifier of the Dimension Group that is a component of the attribute assignment when the attribute references the Calendar Period dimension as a list of values | |
CALPATTR_END_DATE | DATE | End Date of the Calendar Period that is a component of the attribute assignment when the attribute references the Calendar Period dimension as a list of values | ||
CALPATTR_PERIOD_NUM | NUMBER | Period Number of the Calendar Period that is a component of the attribute assignment when the attribute references the Calendar Period dimension as a list of values | ||
CREATED_BY_DIM_MIGRATION_FLAG | VARCHAR2 | (1) | Oracle applications uses this column to identify data created by internal processes. Do not populate this column for user created rows - leave as null. |
Cut, paste (and edit) the following text to query this object:
SELECT CAL_PERIOD_END_DATE
, CAL_PERIOD_NUMBER
, ATTRIBUTE_VARCHAR_LABEL
, ATTRIBUTE_ASSIGN_VALUE
, ATTR_ASSIGN_VS_DISPLAY_CODE
, STATUS
, CALENDAR_DISPLAY_CODE
, DIMENSION_GROUP_DISPLAY_CODE
, VERSION_DISPLAY_CODE
, CALPATTR_CAL_DISPLAY_CODE
, CALPATTR_DIMGRP_DISPLAY_CODE
, CALPATTR_END_DATE
, CALPATTR_PERIOD_NUM
, CREATED_BY_DIM_MIGRATION_FLAG
FROM FEM.FEM_CAL_PERIODS_ATTR_T;
FEM.FEM_CAL_PERIODS_ATTR_T does not reference any database object
FEM.FEM_CAL_PERIODS_ATTR_T is referenced by following:
|
|
|