eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FV.FV_GTAS1_PERIOD_ATTRIBUTES

Object Details

Object Name:	FV_GTAS1_PERIOD_ATTRIBUTES
Object Type:	TABLE
Owner:	FV
Subobject Name:
Status:	VALID

Table used by GTAS Processes

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FV_GTAS1_PERIOD_ATTRIBUTES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CCID PERIOD_YEAR SET_OF_BOOKS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNT_NUMBER	VARCHAR2	(30)	Yes	Account Number
ACCOUNT_TYPE	VARCHAR2	(1)		Account Type
APPOR_CAT_B_CODE	VARCHAR2	(4)		Appor Cat B Code
APPOR_CAT_CODE	VARCHAR2	(1)		Appor Cat Code
BALANCE_AMOUNT	NUMBER		Yes	Balance Amount
BEA_CAT_CODE	VARCHAR2	(1)		BEA Cat Code
BEGIN_BALANCE	NUMBER	(22)		Begin Balance
BORR_SRC_CODE	VARCHAR2	(1)		Borr src Code
CCID	NUMBER	(15)	Yes	Ccid
CREDIT_COHORT_YR	VARCHAR2	(150)		Credit Cohort Yr
CUR_SUBSEQUENT_CODE	VARCHAR2	(1)		Cur Subsequent Code
CUST_NON_CUST	VARCHAR2	(1)		Cust Non Cust
DIRECT_OR_REIMB_CODE	VARCHAR2	(1)		Direct or Reimb Code
END_BAL_IND	VARCHAR2	(1)		End Bal Ind
EXCH_NON_EXCH	VARCHAR2	(1)		Exch Non Exch
FUND_VALUE	VARCHAR2	(30)		Fund Value
NEW_BAL_CODE	VARCHAR2	(3)		New Bal Code
NEW_REC_FLAG	VARCHAR2	(1)		New Rec Flag
PERIOD_BEGIN_BAL	NUMBER	(22)		Period Begin Bal
PERIOD_CY_CR_BAL	NUMBER	(22)		Period cy Cr Bal
PERIOD_CY_DR_BAL	NUMBER			Period cy Dr Bal
PERIOD_NAME	VARCHAR2	(15)	Yes	Period Name
PERIOD_YEAR	NUMBER	(15)	Yes	Period Year
PROGRAM_COST_IND	VARCHAR2	(4)		Program Cost Ind
PROGRAM_REPT_CODE	VARCHAR2	(4)		Program Rept Code
PYA_CODE	VARCHAR2	(1)		PYA Code
REPORTED_GROUP	VARCHAR2	(1)		Reported Group
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books Id
TREASURY_SYMBOL_ID	NUMBER	(15)		Treasury Symbol Id
USSGL_ACCOUNT	VARCHAR2	(6)		Ussgl Account
PERIOD_NUM	NUMBER	(15)	Yes	Period Num

Query Text

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


SELECT ACCOUNT_NUMBER
,      ACCOUNT_TYPE
,      APPOR_CAT_B_CODE
,      APPOR_CAT_CODE
,      BALANCE_AMOUNT
,      BEA_CAT_CODE
,      BEGIN_BALANCE
,      BORR_SRC_CODE
,      CCID
,      CREDIT_COHORT_YR
,      CUR_SUBSEQUENT_CODE
,      CUST_NON_CUST
,      DIRECT_OR_REIMB_CODE
,      END_BAL_IND
,      EXCH_NON_EXCH
,      FUND_VALUE
,      NEW_BAL_CODE
,      NEW_REC_FLAG
,      PERIOD_BEGIN_BAL
,      PERIOD_CY_CR_BAL
,      PERIOD_CY_DR_BAL
,      PERIOD_NAME
,      PERIOD_YEAR
,      PROGRAM_COST_IND
,      PROGRAM_REPT_CODE
,      PYA_CODE
,      REPORTED_GROUP
,      SET_OF_BOOKS_ID
,      TREASURY_SYMBOL_ID
,      USSGL_ACCOUNT
,      PERIOD_NUM
FROM FV.FV_GTAS1_PERIOD_ATTRIBUTES;

Dependencies

[top of page]

FV.FV_GTAS1_PERIOD_ATTRIBUTES does not reference any database object

FV.FV_GTAS1_PERIOD_ATTRIBUTES is referenced by following:

FV: FV_GTAS1_PERIOD_ATTRIBUTES#