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

VIEW: FV.FV_FACTS1_PERIOD_ATTRIBUTES#

Object Details
Object Name: FV_FACTS1_PERIOD_ATTRIBUTES#
Object Type: VIEW
Owner: FV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CCID NUMBER (15) Yes
PERIOD_NUM NUMBER (15) Yes
PERIOD_NAME VARCHAR2 (15) Yes
PERIOD_YEAR NUMBER (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
FUND_GROUP NUMBER (4) Yes
ACCOUNT_NUMBER VARCHAR2 (30) Yes
FUND_VALUE VARCHAR2 (30)
DEPT_ID VARCHAR2 (3)
BUREAU_ID VARCHAR2 (2)
ELIMINATIONS_DEPT VARCHAR2 (6)
G_NG_INDICATOR VARCHAR2 (1)
END_BAL_IND VARCHAR2 (1)
REPORTED_GROUP VARCHAR2 (1)
USSGL_ACCOUNT VARCHAR2 (4)
EXCH_NON_EXCH VARCHAR2 (1)
CUST_NON_CUST VARCHAR2 (1)
BUDGET_SUBFUNCTION VARCHAR2 (3)
ACCOUNT_TYPE VARCHAR2 (1)
NEW_REC_FLAG VARCHAR2 (1)
BALANCE_AMOUNT NUMBER

BEGIN_BALANCE NUMBER

PERIOD_CY_DR_BAL NUMBER

PERIOD_CY_CR_BAL NUMBER

PERIOD_BEGIN_BAL NUMBER

Query Text

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


SELECT CCID
,      PERIOD_NUM
,      PERIOD_NAME
,      PERIOD_YEAR
,      SET_OF_BOOKS_ID
,      FUND_GROUP
,      ACCOUNT_NUMBER
,      FUND_VALUE
,      DEPT_ID
,      BUREAU_ID
,      ELIMINATIONS_DEPT
,      G_NG_INDICATOR
,      END_BAL_IND
,      REPORTED_GROUP
,      USSGL_ACCOUNT
,      EXCH_NON_EXCH
,      CUST_NON_CUST
,      BUDGET_SUBFUNCTION
,      ACCOUNT_TYPE
,      NEW_REC_FLAG
,      BALANCE_AMOUNT
,      BEGIN_BALANCE
,      PERIOD_CY_DR_BAL
,      PERIOD_CY_CR_BAL
,      PERIOD_BEGIN_BAL
FROM FV.FV_FACTS1_PERIOD_ATTRIBUTES#;

Dependencies

[top of page]

FV.FV_FACTS1_PERIOD_ATTRIBUTES# references the following:

SchemaFV
TableFV_FACTS1_PERIOD_ATTRIBUTES
FV.FV_FACTS1_PERIOD_ATTRIBUTES# is referenced by following:

SchemaAPPS
SynonymFV_FACTS1_PERIOD_ATTRIBUTES