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

TABLE: FV.FV_FACTS_TEMP

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


FV_FACTS_TEMP is the temporary table that stores the FACTS bulk file transactions.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TREASURY_SYMBOL_ID NUMBER (15)
Treasury symbol identifier
SGL_ACCT_NUMBER VARCHAR2 (50)
US SGL account number
COHORT VARCHAR2 (2)
Cohort year
BEGIN_END VARCHAR2 (1)
Balance type
INDEF_DEF_FLAG VARCHAR2 (1)
Indefinite or Definite flag
APPOR_CAT_B_DTL VARCHAR2 (3)
Apportionment category B detail
APPOR_CAT_B_TXT VARCHAR2 (25)
Apportionment category B text
PUBLIC_LAW VARCHAR2 (7)
Public law code
APPOR_CAT_CODE VARCHAR2 (1)
Apportionment category code
AUTHORITY_TYPE VARCHAR2 (1)
Authority type
TRANSACTION_PARTNER VARCHAR2 (1)
Transaction partner
REIMBURSEABLE_FLAG VARCHAR2 (1)
Reimbursable flag
BEA_CATEGORY VARCHAR2 (5)
Budget Enforcement Act category
BORROWING_SOURCE VARCHAR2 (6)
Borrowing source
DEF_LIQUID_FLAG VARCHAR2 (1)
For future use
DEFICIENCY_FLAG VARCHAR2 (1)
Not currently used
AVAILABILITY_FLAG VARCHAR2 (1)
Availability flag
LEGISLATION_FLAG VARCHAR2 (1)
Legislation flag
AMOUNT NUMBER

Balance amount
DEBIT_CREDIT VARCHAR2 (1)
Debit or Credit indicator
FCT_INT_RECORD_CATEGORY VARCHAR2 (25)
FACTS record category
FCT_INT_RECORD_TYPE VARCHAR2 (20)
FACTS record type
FACTS_REPORT_INFO VARCHAR2 (416)
Concatenated record for FACTS bulk file
TBAL_FUND_VALUE VARCHAR2 (25)
Fund value for Trial Balance Report
TBAL_ACCT_NUM VARCHAR2 (25)
Account number for Trial Balance Report
DOCUMENT_NUMBER VARCHAR2 (240)
Document number
DOCUMENT_DATE DATE

Document date
TBAL_INDICATOR VARCHAR2 (1)
Indicates which process was run, either the Trial Balance or FACTS II
ADVANCE_FLAG VARCHAR2 (1)
Advance flag
TRANSFER_DEPT_ID VARCHAR2 (3)
Transfer department identifier
TRANSFER_MAIN_ACCT VARCHAR2 (4)
Transfer main account
YEAR_BUDGET_AUTH VARCHAR2 (3)
Year Budget Authority
BUDGET_FUNCTION VARCHAR2 (3)
Budget function
EDIT_CHECK_NUMBER NUMBER

Edit check number
AMOUNT1 NUMBER

Amount1
AMOUNT2 NUMBER

Amount2
PERIOD_ACTIVITY NUMBER

Oracle Internal use only - reserved for future use
CODE_COMBINATION_ID NUMBER (15)
Not currently used
PARENT_SGL_ACCT_NUMBER VARCHAR2 (25)
Not currently used
DOCUMENT_SOURCE VARCHAR2 (25)
Not currently used
DOCUMENT_CREATED_BY NUMBER (15)
Not currently used
DOCUMENT_CREATION_DATE DATE

Not currently used
PAGEBREAK VARCHAR2 (30)
Not currently used
SEGMENT1 VARCHAR2 (30)
Key flexfield segment
SEGMENT2 VARCHAR2 (30)
Key flexfield segment
SEGMENT3 VARCHAR2 (30)
Key flexfield segment
SEGMENT4 VARCHAR2 (30)
Key flexfield segment
SEGMENT5 VARCHAR2 (30)
Key flexfield segment
SEGMENT6 VARCHAR2 (30)
Key flexfield segment
SEGMENT7 VARCHAR2 (30)
Key flexfield segment
SEGMENT8 VARCHAR2 (30)
Key flexfield segment
SEGMENT9 VARCHAR2 (30)
Key flexfield segment
SEGMENT10 VARCHAR2 (30)
Key flexfield segment
SEGMENT11 VARCHAR2 (30)
Key flexfield segment
SEGMENT12 VARCHAR2 (30)
Key flexfield segment
SEGMENT13 VARCHAR2 (30)
Key flexfield segment
SEGMENT14 VARCHAR2 (30)
Key flexfield segment
SEGMENT15 VARCHAR2 (30)
Key flexfield segment
SEGMENT16 VARCHAR2 (30)
Key flexfield segment
SEGMENT17 VARCHAR2 (30)
Key flexfield segment
SEGMENT18 VARCHAR2 (30)
Key flexfield segment
SEGMENT19 VARCHAR2 (30)
Key flexfield segment
SEGMENT20 VARCHAR2 (30)
Key flexfield segment
SEGMENT21 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT22 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT23 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT24 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT25 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT26 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT27 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT28 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT29 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT30 VARCHAR2 (30)
Accounting Flexfield segment
PROGRAM_RPT_CAT_TXT VARCHAR2 (25)
Program Reporting Category Text
PROGRAM_RPT_CAT_NUM VARCHAR2 (3)
Program Reporting Category Number
PYA_FLAG VARCHAR2 (1)
PYA Flag
CLOSING_GRP VARCHAR2 (2)
Closing Grp
SGL_BEG_BAL_ACCT_NUM VARCHAR2 (50)
Sgl Beg Bal Acct Num
NON_FED_EXC_FLAG VARCHAR2 (12)
Non Federal Exception Limitation Allowed Flag
Query Text

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


SELECT TREASURY_SYMBOL_ID
,      SGL_ACCT_NUMBER
,      COHORT
,      BEGIN_END
,      INDEF_DEF_FLAG
,      APPOR_CAT_B_DTL
,      APPOR_CAT_B_TXT
,      PUBLIC_LAW
,      APPOR_CAT_CODE
,      AUTHORITY_TYPE
,      TRANSACTION_PARTNER
,      REIMBURSEABLE_FLAG
,      BEA_CATEGORY
,      BORROWING_SOURCE
,      DEF_LIQUID_FLAG
,      DEFICIENCY_FLAG
,      AVAILABILITY_FLAG
,      LEGISLATION_FLAG
,      AMOUNT
,      DEBIT_CREDIT
,      FCT_INT_RECORD_CATEGORY
,      FCT_INT_RECORD_TYPE
,      FACTS_REPORT_INFO
,      TBAL_FUND_VALUE
,      TBAL_ACCT_NUM
,      DOCUMENT_NUMBER
,      DOCUMENT_DATE
,      TBAL_INDICATOR
,      ADVANCE_FLAG
,      TRANSFER_DEPT_ID
,      TRANSFER_MAIN_ACCT
,      YEAR_BUDGET_AUTH
,      BUDGET_FUNCTION
,      EDIT_CHECK_NUMBER
,      AMOUNT1
,      AMOUNT2
,      PERIOD_ACTIVITY
,      CODE_COMBINATION_ID
,      PARENT_SGL_ACCT_NUMBER
,      DOCUMENT_SOURCE
,      DOCUMENT_CREATED_BY
,      DOCUMENT_CREATION_DATE
,      PAGEBREAK
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      PROGRAM_RPT_CAT_TXT
,      PROGRAM_RPT_CAT_NUM
,      PYA_FLAG
,      CLOSING_GRP
,      SGL_BEG_BAL_ACCT_NUM
,      NON_FED_EXC_FLAG
FROM FV.FV_FACTS_TEMP;

Dependencies

[top of page]

FV.FV_FACTS_TEMP does not reference any database object

FV.FV_FACTS_TEMP is referenced by following:

SchemaFV
ViewFV_FACTS_TEMP#