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

TABLE: BIM.BIM_R_FDSP_WEEKLY_FACTS

Object Details
Object Name: BIM_R_FDSP_WEEKLY_FACTS
Object Type: TABLE
Owner: BIM
Subobject Name:
Status: VALID


This table keeps weekly fund spending facts


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_R_FDSP_WEEKLY_FACTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSPEND_TRANSACTION_ID
BIM_R_FDSP_WEEKLY_FACTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_CREATE_DATE
Columns
Name Datatype Length Mandatory Comments
SPEND_TRANSACTION_ID NUMBER
Yes unique identifer
CREATION_DATE DATE

standard who column
CREATED_BY NUMBER

standard who column
LAST_UPDATE_DATE DATE

standard who column
LAST_UPDATED_BY NUMBER

standard who column
LAST_UPDATE_LOGIN NUMBER

standard who column
FUND_ID NUMBER

fund id for fund spending
BUSINESS_UNIT_ID NUMBER

business unit id
OBJECT_ID NUMBER

object id for fund spending
OBJECT_TYPE VARCHAR2 (30)
object type for fund spending
STANDARD_DISCOUNT NUMBER

standard discount for fund spending
ACCRUAL NUMBER

accrual for fund spending
MARKET_EXPENSE NUMBER

amount of market expense for fund spending
COMMITED_AMT NUMBER

amount commited for fund spending
PLANNED_AMT NUMBER

amount planned for fund spending
PAID_AMT NUMBER

amount paid for fund spending
DELETE_FLAG VARCHAR2 (1)
delete flag are used when records need to be deleted
TRANSACTION_CREATE_DATE DATE

Creation date of the transaction.
LOAD_DATE DATE

This column provides the week end date of the transaction create date.
UTIL_ORG_ID NUMBER

utility organization id
SECURITY_GROUP_ID NUMBER

This column is used in hosted environments
METRICS1 NUMBER

additional metrics column
METRICS2 NUMBER

additional metrics column
METRICS3 NUMBER

additional metrics column
METRICS4 NUMBER

additional metrics column
METRICS5 NUMBER

additional metrics column
METRICS6 NUMBER

additional metrics column
METRICS7 NUMBER

additional metrics column
METRICS8 NUMBER

additional metrics column
METRICS9 NUMBER

additional metrics column
METRICS10 NUMBER

additional metrics column
METRICS11 NUMBER

additional metrics column
METRICS12 NUMBER

additional metrics column
METRICS13 NUMBER

additional metrics column
METRICS14 NUMBER

additional metrics column
METRICS15 NUMBER

additional metrics column
FIS_MONTH VARCHAR2 (30)
Fiscal period month
FIS_QTR VARCHAR2 (30)
Fiscal period quarter
FIS_YEAR VARCHAR2 (30)
Fiscal period year
Query Text

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


SELECT SPEND_TRANSACTION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FUND_ID
,      BUSINESS_UNIT_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      STANDARD_DISCOUNT
,      ACCRUAL
,      MARKET_EXPENSE
,      COMMITED_AMT
,      PLANNED_AMT
,      PAID_AMT
,      DELETE_FLAG
,      TRANSACTION_CREATE_DATE
,      LOAD_DATE
,      UTIL_ORG_ID
,      SECURITY_GROUP_ID
,      METRICS1
,      METRICS2
,      METRICS3
,      METRICS4
,      METRICS5
,      METRICS6
,      METRICS7
,      METRICS8
,      METRICS9
,      METRICS10
,      METRICS11
,      METRICS12
,      METRICS13
,      METRICS14
,      METRICS15
,      FIS_MONTH
,      FIS_QTR
,      FIS_YEAR
FROM BIM.BIM_R_FDSP_WEEKLY_FACTS;

Dependencies

[top of page]

BIM.BIM_R_FDSP_WEEKLY_FACTS does not reference any database object

BIM.BIM_R_FDSP_WEEKLY_FACTS is referenced by following:

SchemaBIM
ViewBIM_R_FDSP_WEEKLY_FACTS#