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

TABLE: FV.FV_TREASURY_SYMBOLS_HISTORY

Object Details
Object Name: FV_TREASURY_SYMBOLS_HISTORY
Object Type: TABLE
Owner: FV
FND Design Data: TableFV.FV_TREASURY_SYMBOLS_HISTORY
Subobject Name:
Status: VALID


FV_TREASURY_SYMBOLS_HISTORY is the base table for the Purge Treasury Symbols process window.This table is exact replica of FV_TREASURY_SYMBOLS.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FV_TREASURY_SYM_HIST_TSSOB_UNQ NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTREASURY_SYMBOL
ColumnSET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
TREASURY_SYMBOL_ID NUMBER (15) Yes Treasury symbol identifier
TREASURY_SYMBOL VARCHAR2 (35) Yes Treasury symbol of fund value
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books identifier
SF224_TYPE_CODE VARCHAR2 (25)
FMS Form 224 report fund type
FUND_GROUP_CODE VARCHAR2 (30) Yes Fund group
TIME_FRAME VARCHAR2 (25) Yes Fund time frames
ESTABLISHED_FISCAL_YR NUMBER (15) Yes Closing fiscal year for year-end closing process
DEPARTMENT_ID VARCHAR2 (2) Yes Department identifier
BUREAU_ID VARCHAR2 (2)
Bureau identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
EXPIRATION_DATE DATE

Fund expiration date used for year-end processing
CANCELLATION_DATE DATE

Fund cancel date used for year- end processing
RESOURCE_TYPE VARCHAR2 (80)
Resource type used for year-end processing
PRECLOSING_UNEXPENDED_AMT NUMBER

Preclosing unexpended amount designated by Treasury Department used for year-end closing process
CLOSE_REQUISITIONS VARCHAR2 (1)
Y or N value used to determine if requisitions should be closed
YEARS_AVAILABLE NUMBER (3)
Number of years appropriation is available
BUSINESS_LINE VARCHAR2 (2)
Business line for this Treasury symbol
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ORG_ID NUMBER (15)
Organization identifier
FEDERAL_ACCT_SYMBOL_ID NUMBER (15) Yes Foreign key to FV_FACTS_FEDERAL_ACCOUNTS
DEPT_TRANSFER VARCHAR2 (2)
Department transfer
TAFS_SUB_ACCT VARCHAR2 (3)
TAFS subaccount
TAFS_SPLIT_CODE VARCHAR2 (3)
TAFS split code
TAFS_SPLIT_NAME VARCHAR2 (125)
TAFS split name
PUBLIC_LAW_CODE VARCHAR2 (7)
Public law code. No longer used.
TS_FLAG VARCHAR2 (1)
Treasury symbol flag
DEF_INDEF_FLAG VARCHAR2 (1)
Definite or Indefinite flag
SF224_QTR1_OUTLAY NUMBER

Net outlay amount for first quarter
SF224_QTR2_OUTLAY NUMBER

Net outlay amount for second quarter
SF224_QTR3_OUTLAY NUMBER

Net outlay amount for third quarter
SF224_QTR4_OUTLAY NUMBER

Net outlay amount for fourth quarter
CUST_NON_CUST VARCHAR2 (3)
Custodial or noncustodial
DO_NOT_PURGE_FLAG VARCHAR2 (1)
Denotes whether to purge or not
DATE_PURGED DATE

Date purged
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
OPEN_FLAG VARCHAR2 (1)
Open flag
Query Text

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


SELECT TREASURY_SYMBOL_ID
,      TREASURY_SYMBOL
,      SET_OF_BOOKS_ID
,      SF224_TYPE_CODE
,      FUND_GROUP_CODE
,      TIME_FRAME
,      ESTABLISHED_FISCAL_YR
,      DEPARTMENT_ID
,      BUREAU_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      EXPIRATION_DATE
,      CANCELLATION_DATE
,      RESOURCE_TYPE
,      PRECLOSING_UNEXPENDED_AMT
,      CLOSE_REQUISITIONS
,      YEARS_AVAILABLE
,      BUSINESS_LINE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      ORG_ID
,      FEDERAL_ACCT_SYMBOL_ID
,      DEPT_TRANSFER
,      TAFS_SUB_ACCT
,      TAFS_SPLIT_CODE
,      TAFS_SPLIT_NAME
,      PUBLIC_LAW_CODE
,      TS_FLAG
,      DEF_INDEF_FLAG
,      SF224_QTR1_OUTLAY
,      SF224_QTR2_OUTLAY
,      SF224_QTR3_OUTLAY
,      SF224_QTR4_OUTLAY
,      CUST_NON_CUST
,      DO_NOT_PURGE_FLAG
,      DATE_PURGED
,      REQUEST_ID
,      OPEN_FLAG
FROM FV.FV_TREASURY_SYMBOLS_HISTORY;

Dependencies

[top of page]

FV.FV_TREASURY_SYMBOLS_HISTORY does not reference any database object

FV.FV_TREASURY_SYMBOLS_HISTORY is referenced by following:

SchemaAPPS
SynonymFV_TREASURY_SYMBOLS_HISTORY