[Home] [Help] [Dependency Information]
Object Name: | FV_GTAS1_PERIOD_ATTRIBUTES# |
---|---|
Object Type: | VIEW |
Owner: | FV |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | |
ACCOUNT_TYPE | VARCHAR2 | (1) | ||
APPOR_CAT_B_CODE | VARCHAR2 | (4) | ||
APPOR_CAT_CODE | VARCHAR2 | (1) | ||
BALANCE_AMOUNT | NUMBER | Yes | ||
BEA_CAT_CODE | VARCHAR2 | (1) | ||
BEGIN_BALANCE | NUMBER | (22) | ||
BORR_SRC_CODE | VARCHAR2 | (1) | ||
CCID | NUMBER | (15) | Yes | |
CREDIT_COHORT_YR | VARCHAR2 | (150) | ||
CUR_SUBSEQUENT_CODE | VARCHAR2 | (1) | ||
CUST_NON_CUST | VARCHAR2 | (1) | ||
DIRECT_OR_REIMB_CODE | VARCHAR2 | (1) | ||
END_BAL_IND | VARCHAR2 | (1) | ||
EXCH_NON_EXCH | VARCHAR2 | (1) | ||
FUND_VALUE | VARCHAR2 | (30) | ||
NEW_BAL_CODE | VARCHAR2 | (3) | ||
NEW_REC_FLAG | VARCHAR2 | (1) | ||
PERIOD_BEGIN_BAL | NUMBER | (22) | ||
PERIOD_CY_CR_BAL | NUMBER | (22) | ||
PERIOD_CY_DR_BAL | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | Yes | |
PERIOD_YEAR | NUMBER | (15) | Yes | |
PROGRAM_COST_IND | VARCHAR2 | (4) | ||
PROGRAM_REPT_CODE | VARCHAR2 | (4) | ||
PYA_CODE | VARCHAR2 | (1) | ||
REPORTED_GROUP | VARCHAR2 | (1) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
TREASURY_SYMBOL_ID | NUMBER | (15) | ||
USSGL_ACCOUNT | VARCHAR2 | (6) | ||
PERIOD_NUM | NUMBER | (15) | Yes |
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#;
|
|
|