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

TABLE: FII.EDW_TIME_CAL_DAY_LSTG

Object Details
Object Name: EDW_TIME_CAL_DAY_LSTG
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.EDW_TIME_CAL_DAY_LSTG
Subobject Name:
Status: VALID


This is the interface table for calendar day level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_TIME_CAL_DAY_LSTG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCAL_DAY_PK
Columns
Name Datatype Length Mandatory Comments
CAL_PERIOD_FK_KEY NUMBER

System generated foreign key to the calendar period level
DAY_FK_KEY NUMBER

System generated foreign key to the day level
FA_PERIOD_FK_KEY NUMBER

System generated foreign key to the FA period level
PA_PERIOD_FK_KEY NUMBER

System generated foreign key to PA period level
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
SEQ_NUMBER NUMBER

Sequence number assigned to the calendar day
TIMESPAN NUMBER

The duration of this time period
EP_CAL_PERIOD_FK_KEY NUMBER

System generated foreign key to the enterprise calendar level
CAL_DAY VARCHAR2 (80)
Calender date formatted for display
CAL_DAY_PK VARCHAR2 (120)
The unique identifier for the calendar day
CAL_PERIOD_FK VARCHAR2 (120)
Foreign key to the calendar period level
COLLECTION_STATUS VARCHAR2 (30)
Collection status code for the record
DAY_FK VARCHAR2 (20)
Foreign key to the day level
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
FA_PERIOD_FK VARCHAR2 (120)
Foreign key to the FA period level
HOLIDAY_FLAG VARCHAR2 (40)
Indicates if this date is a holiday
INSTANCE VARCHAR2 (40)
Instance identifier
NAME VARCHAR2 (2000)
Calender date formatted for display
OPERATION_CODE VARCHAR2 (30)
Code used by the collection program to determine whether to insert/update/delete this record
PA_PERIOD_FK VARCHAR2 (120)
Foreign key to PA period level
ROW_ID ROWID (10)
Row identifier
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
WORK_DAY_FLAG VARCHAR2 (40)
Indicates if the date is a workday in this calendar
EP_CAL_PERIOD_FK VARCHAR2 (120)
Foreign key to the enterprise calendar level
CALENDAR_DATE DATE

Calendar date
DELETION_DATE DATE

Deletion date of the record
END_DATE DATE

End day of this time period
EFFECTIVE_PERIOD_NUM NUMBER (15)
General Ledger effective period number
PERIOD_SET_NAME VARCHAR2 (15)
General Ledger calendar name
PERIOD_TYPE VARCHAR2 (15)
General Ledger period type
Query Text

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


SELECT CAL_PERIOD_FK_KEY
,      DAY_FK_KEY
,      FA_PERIOD_FK_KEY
,      PA_PERIOD_FK_KEY
,      REQUEST_ID
,      SEQ_NUMBER
,      TIMESPAN
,      EP_CAL_PERIOD_FK_KEY
,      CAL_DAY
,      CAL_DAY_PK
,      CAL_PERIOD_FK
,      COLLECTION_STATUS
,      DAY_FK
,      ERROR_CODE
,      FA_PERIOD_FK
,      HOLIDAY_FLAG
,      INSTANCE
,      NAME
,      OPERATION_CODE
,      PA_PERIOD_FK
,      ROW_ID
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      WORK_DAY_FLAG
,      EP_CAL_PERIOD_FK
,      CALENDAR_DATE
,      DELETION_DATE
,      END_DATE
,      EFFECTIVE_PERIOD_NUM
,      PERIOD_SET_NAME
,      PERIOD_TYPE
FROM FII.EDW_TIME_CAL_DAY_LSTG;

Dependencies

[top of page]

FII.EDW_TIME_CAL_DAY_LSTG does not reference any database object

FII.EDW_TIME_CAL_DAY_LSTG is referenced by following:

SchemaAPPS
SynonymEDW_TIME_CAL_DAY_LSTG