GENERAL_LEDGER - Report
Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
FISCAL_YEAR |
A UNIQUE NUMERIC IDENTIFIER CODE FOR THE FISCAL YEAR BEING DEFINED. FUNCTION RETURNS A FOUR-DIGIT YEAR WHEN SUPPLIED A TWO-DIGIT YEAR. |
|
FGBGENL |
FOFYNCV(FGBGENL_FSYR_CODE) |
UNKNOWN |
FISCAL_PERIOD |
FISCAL PERIOD CODE. |
|
FGBGENL |
FGBGENL_PERIOD |
UNKNOWN |
FISCAL_PERIOD_STATUS |
REFERS TO THE ACCOUNTING PERIODS ABILITY TO ACCEPT POSTING ACTIVITY. |
|
FTVFSPD |
FTVFSPD_PRD_STATUS_IND |
UNKNOWN |
CHART_OF_ACCOUNTS |
INSTITUTIONAL DEFINED VALUE FOR THE CHART OF ACCOUNTS. |
|
FGBGENL |
FGBGENL_COAS_CODE |
UNKNOWN |
CHART_OF_ACCOUNTS_DESC |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVCOAS |
FTVCOAS_TITLE |
UNKNOWN |
CHART_OF_ACCOUNTS_STATUS |
FIELD REPRESENTING THE CURRENT STATUS OF A SYSTEM CODE. A FOR ACTIVE OR I FOR INACTIVE. |
|
FTVCOAS |
FTVCOAS_STATUS_IND |
UNKNOWN |
FUND |
"FUND CODE ASSOCIATED WITH THE LOAN APPLICATION. ONCE THE LOAN APPLICATION IS ESTABLISHED |
|
FGBGENL |
FGBGENL_FUND_CODE |
UNKNOWN |
FUND_DESC |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFUND |
FTVFUND_TITLE |
UNKNOWN |
FUND_STATUS |
CURRENT STATUS OF THE ASSOCIATED FUND . |
|
FTVFUND |
FTVFUND_STATUS_IND |
UNKNOWN |
ACCOUNT |
"DEFINED VALUE REPRESENTING AN ACCOUNT. ACCOUNTS ARE EITHER ASSETS, LIABILITY, CONTROL, FUND BALANCE, REVENUE, LABOR, EXPENDITURE OR TRANSFER." |
|
FGBGENL |
FGBGENL_ACCT_CODE |
UNKNOWN |
ACCOUNT_DESC |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVACCT |
FTVACCT_TITLE |
UNKNOWN |
ACCOUNT_STATUS |
"INDICATES STATUS OF THE ASSOCIATED ACCOUNT FOR THIS LEVEL OF THE HIERARCHY." |
|
FTVACCT |
FTVACCT_STATUS_IND |
UNKNOWN |
ACCOUNTING_ID |
"SPECIFIES THE ACCOUNTING ID." |
|
NA |
NOT AVAILABLE |
UNKNOWN |
FUND_TYPE_LEVEL_1 |
PRIMARY FUND TYPE WITHIN THIS FUND HIERARCHY. |
|
FTVFTYP |
FTVFTYP_FTYP_CODE |
UNKNOWN |
FUND_TYPE_DESC_1 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFTYP |
FTVFTYP_TITLE |
UNKNOWN |
FUND_TYPE_STATUS_1 |
STATUS OF THE PRIMARY FUND TYPE WITHIN THIS FUND HIERARCHY. |
|
FTVFTYP |
FTVFTYP_STATUS_IND |
UNKNOWN |
FUND_TYPE_LEVEL_2 |
LEVEL 2FUND TYPE WITHIN THIS FUND HIERARCHY. |
|
FTVFTYP |
FTVFTYP_FTYP_CODE |
UNKNOWN |
FUND_TYPE_DESC_2 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFTYP |
FTVFTYP_TITLE |
UNKNOWN |
FUND_TYPE_STATUS_2 |
STATUS OF THE LEVEL 2FUND TYPE WITHIN THIS FUND HIERARCHY. |
|
FTVFTYP |
FTVFTYP_STATUS_IND |
UNKNOWN |
FUND_LEVEL_1 |
PRIMARY FUND WITHIN THE FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_FUND_CODE |
UNKNOWN |
FUND_DESC_1 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFUND |
FTVFUND_TITLE |
UNKNOWN |
FUND_STATUS_1 |
STATUS OF THE PRIMARY FUND WITHIN THE FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_STATUS_IND |
UNKNOWN |
FUND_LEVEL_2 |
LEVEL 2FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_FUND_CODE |
UNKNOWN |
FUND_DESC_2 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFUND |
FTVFUND_TITLE |
UNKNOWN |
FUND_STATUS_2 |
STATUS OF THE LEVEL 2FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_STATUS_IND |
UNKNOWN |
FUND_LEVEL_3 |
LEVEL 3FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_FUND_CODE |
UNKNOWN |
FUND_DESC_3 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFUND |
FTVFUND_TITLE |
UNKNOWN |
FUND_STATUS_3 |
STATUS OF THE LEVEL 3FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_STATUS_IND |
UNKNOWN |
FUND_LEVEL_4 |
LEVEL 4FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_FUND_CODE |
UNKNOWN |
FUND_DESC_4 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFUND |
FTVFUND_TITLE |
UNKNOWN |
FUND_STATUS_4 |
STATUS OF THE LEVEL 4FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_STATUS_IND |
UNKNOWN |
FUND_LEVEL_5 |
LEVEL 5FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_FUND_CODE |
UNKNOWN |
FUND_DESC_5 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVFUND |
FTVFUND_TITLE |
UNKNOWN |
FUND_STATUS_5 |
STATUS OF THE LEVEL 5FUND WITHIN THIS FUND HIERARCHY. |
|
FTVFUND |
FTVFUND_STATUS_IND |
UNKNOWN |
ACCOUNT_TYPE_LEVEL_1 |
"CLASSIFIES AN ACCOUNT TYPE I.E., ASSET, REVENUE, ETC. FOR REPORTING PURPOSES." |
|
FTVATYP |
FTVATYP_ATYP_CODE |
UNKNOWN |
ACCOUNT_TYPE_DESC_1 |
"HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL." |
|
FTVATYP |
FTVATYP_TITLE |
UNKNOWN |
ACCOUNT_TYPE_STATUS_1 |
"STATUS OF THE PRIMARY ACCOUNT TYPE WITHIN THIS ACCOUNT HIERARCHY." |
|
FTVATYP |
FTVATYP_STATUS_IND |
UNKNOWN |
ACCOUNT_TYPE_LEVEL_2 |
"CLASSIFIES AN ACCOUNT TYPE I.E., ASSET, REVENUE, ETC. FOR REPORTING PURPOSES." |
|
FTVATYP |
FTVATYP_ATYP_CODE |
UNKNOWN |
ACCOUNT_TYPE_DESC_2 |
"HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL." |
|
FTVATYP |
FTVATYP_TITLE |
UNKNOWN |
ACCOUNT_TYPE_STATUS_2 |
"STATUS OF THE SECONDARY ACCOUNT TYPE WITHIN THIS ACCOUNT HIERARCHY." |
|
FTVATYP |
FTVATYP_STATUS_IND |
UNKNOWN |
ACCOUNT_LEVEL_1 |
"DEFINED VALUE REPRESENTING AN ACCOUNT. ACCOUNTS ARE EITHER ASSETS, LIABILITY, CONTROL, FUND BALANCE, REVENUE, LABOR, EXPENDITURE OR TRANSFER." |
|
FTVACCT |
FTVACCT_ACCT_CODE |
UNKNOWN |
ACCOUNT_DESC_1 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVACCT |
FTVACCT_TITLE |
UNKNOWN |
ACCOUNT_STATUS_1 |
"INDICATES STATUS OF THE ASSOCIATED ACCOUNT FOR THIS LEVEL OF THE HIERARCHY." |
|
FTVACCT |
FTVACCT_STATUS_IND |
UNKNOWN |
ACCOUNT_LEVEL_2 |
"DEFINED VALUE REPRESENTING AN ACCOUNT. ACCOUNTS ARE EITHER ASSETS, LIABILITY, CONTROL, FUND BALANCE, REVENUE, LABOR, EXPENDITURE OR TRANSFER." |
|
FTVACCT |
FTVACCT_ACCT_CODE |
UNKNOWN |
ACCOUNT_DESC_2 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVACCT |
FTVACCT_TITLE |
UNKNOWN |
ACCOUNT_STATUS_2 |
"INDICATES STATUS OF THE ASSOCIATED ACCOUNT FOR THIS LEVEL OF THE HIERARCHY." |
|
FTVACCT |
FTVACCT_STATUS_IND |
UNKNOWN |
ACCOUNT_LEVEL_3 |
"DEFINED VALUE REPRESENTING AN ACCOUNT. ACCOUNTS ARE EITHER ASSETS, LIABILITY, CONTROL, FUND BALANCE, REVENUE, LABOR, EXPENDITURE OR TRANSFER." |
|
FTVACCT |
FTVACCT_ACCT_CODE |
UNKNOWN |
ACCOUNT_DESC_3 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVACCT |
FTVACCT_TITLE |
UNKNOWN |
ACCOUNT_STATUS_3 |
"INDICATES STATUS OF THE ASSOCIATED ACCOUNT FOR THIS LEVEL OF THE HIERARCHY." |
|
FTVACCT |
FTVACCT_STATUS_IND |
UNKNOWN |
ACCOUNT_LEVEL_4 |
"DEFINED VALUE REPRESENTING AN ACCOUNT. ACCOUNTS ARE EITHER ASSETS, LIABILITY, CONTROL, FUND BALANCE, REVENUE, LABOR, EXPENDITURE OR TRANSFER." |
|
FTVACCT |
FTVACCT_ACCT_CODE |
UNKNOWN |
ACCOUNT_DESC_4 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVACCT |
FTVACCT_TITLE |
UNKNOWN |
ACCOUNT_STATUS_4 |
"INDICATES STATUS OF THE ASSOCIATED ACCOUNT FOR THIS LEVEL OF THE HIERARCHY." |
|
FTVACCT |
FTVACCT_STATUS_IND |
UNKNOWN |
GRANT_ID |
GRANT CODE. |
|
FTVFUND |
FTVFUND_GRNT_CODE |
UNKNOWN |
GRANT_DESC |
NAME GIVEN TO IDENTIFY THIS GRANT. |
|
FRBGRNT |
FRBGRNT_TITLE |
UNKNOWN |
GRANT_STATUS |
|
|
FTVGRNT |
FTVGRNT_STATUS_IND |
UNKNOWN |
SUM_PERIODIC_DEBITS |
SUM OF ALL DEBIT TRANSACTIONS FOR A GIVEN PERIOD OF TIME. |
|
FGBGENL |
FGBGENL_SUM_PERIODIC_DR |
UNKNOWN |
SUM_PERIODIC_CREDITS |
SUM OF ALL CREDIT TRANSACTIONS FOR A GIVEN PERIOD OF TIME. |
|
FGBGENL |
FGBGENL_SUM_PERIODIC_CR |
UNKNOWN |
CURRENT_ACTUAL |
CURRENT ACTUAL AMOUNT. |
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
BEGINNING_BALANCE |
BEGINNING BALANCE AMOUNT. |
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
ENDING_BALANCE |
ENDING BALANCE AMOUNT. |
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
NORMAL_BALANCE |
USUAL BALANCE IN THE ACCOUNT AS ESTABLISHED BY GAAP. ACCOUNT EXAMPLES INCLUDE ASSET-DEBIT, LIABILITY-CREDIT, CONTROL-ZERO FUND BALANCE CREDIT, REVENUES-CREDIT, EXPENDITURE-DEBIT. |
|
FTVACCT |
FTVACCT_NORMAL_BAL |
UNKNOWN |