| Element Name | Alias Name | Table | Field/Logic | End User Logic | Field ID | Sub |
|---|---|---|---|---|---|---|
|
StateOrganizationId |
District ID |
TEXAS_DISTRICT_INFORMATION |
DISTRICT_ID |
Texas_District_Information.district_id where district_id is used in District Information |
1 |
|
|
TX-FiscalYear |
Fiscal Year |
GL_BUDGET |
YEAR |
If the length of GL_Element.code = 4 (where GL_Element.ID = GL_Accounting_Strip.category_fund) then use the value in the 4th position of GL_Element.code (where GL_Element.ID = GL_Accounting_Strip.category_fund), otherwise use the 4th position of GL_Budget.year + 1 |
1 | |
|
TX‐Amount |
Budget Amount |
GL_JOURNALS |
SUM(BUDGETED) AS SUM_BUDGETED |
Sum of GL_Journals.budgeted where GL_Journals.journal_fiscal_year = this year and GL_Journals.journal_date <= effective date |
1 | |
|
TX‐FundCode |
Fund Code |
GL_ELEMENT |
FUND_CODE |
GL_Element.code where GL_Element.ID = GL_Accounting_Strip.category_fund |
1 | |
|
TX‐FunctionCode |
Function Code |
GL_ELEMENT |
FUNC_CODE |
GL_Element.code where GL_Element.ID = GL_Accounting_Strip.category_func |
1 | |
|
TX‐ObjectCode |
Object Code |
GL_ELEMENT |
OBJ_CODE |
GL_Element.code where GL_Element.ID = GL_Accounting_Strip.category_obj |
1 | |
|
TX-OrganizationCode |
Organization Code |
GL_ELEMENT |
ORG_CODE |
GL_Element.code where GL_Element.ID = GL_Accounting_Strip.category_org |
1 | |
|
TX-ProgramIntentCode |
Program Intent Code |
GL_ELEMENT |
PIC_CODE |
GL_Element.code where GL_Element.ID = GL_Accounting_Strip.category_pic |
1 |
| Element Name | Alias Name | Table | Field/Logic | End User Logic | Field ID | Sub |
|---|---|---|---|---|---|---|
|
StateOrganizationId |
District ID |
TEXAS_DISTRICT_INFORMATION |
DISTRICT_ID |
Texas_District_Information.district_id where district_id is used in District Information |
2 | |
|
TX-FiscalYear |
Fiscal Year |
GL_BUDGET |
YEAR |
If the length of GL_Element.code = 4 (where GL_Element.ID = GL_Accounting_Strip.category_fund) then use the value in the 4th position of GL_Element.code (where GL_Element.ID = GL_Accounting_Strip.category_fund), otherwise use the 4th position of GL_Budget.year + 1 |
2 | |
|
TX‐Amount |
Actual Amount |
GL_JOURNALS |
SUM(COLLECTED) + SUM(EXPENDED + COMPLETED) AS SUM_ACTUAL |
Sum of GL_Journals.collected, GL_Jounrals.expended & GL_Jounrals.completed where GL_Journals.journal_fiscal_year = previous year |
2 | |
|
TX‐FundCode |
Fund Code |
GL_TX_STRIP_CROSSWALK, GL_ELEMENT_CATEGORY, GL_ELEMENT |
FUND_CODE |
If GL_TX_Strip_Crosswalk.id (Fund) is not NULL then use GL_TX_Strip_Crosswalk.crosswalk_to Else If GL_TX_Element_Crosswalk.id (Fund) is not NULL then use GL_TX_Element_Crosswalk.crosswalk_to Else use GL_Element.code where GL_Element.ID = GL_Accounting_Strip.category_fund |
2 | |
|
TX‐FunctionCode |
Function Code |
GL_TX_STRIP_CROSSWALK, GL_ELEMENT_CATEGORY, GL_ELEMENT |
FUNC_CODE |
If GL_TX_Strip_Crosswalk.id (Func) is not NULL then use GL_TX_Strip_Crosswalk.crosswalk_to Else If GL_TX_Element_Crosswalk.id (Func) is not NULL then use GL_TX_Element_Crosswalk.crosswalk_to Else use GL_Element.code where GL_Element.ID = GL_Accounting_Strip.category_func |
2 | |
|
TX‐ObjectCode |
Object Code |
GL_TX_STRIP_CROSSWALK, GL_ELEMENT_CATEGORY, GL_ELEMENT |
OBJ_CODE |
If GL_TX_Strip_Crosswalk.id (Obj) is not NULL then use GL_TX_Strip_Crosswalk.crosswalk_to Else If GL_TX_Element_Crosswalk.id (Obj) is not NULL then use GL_TX_Element_Crosswalk.crosswalk_to Else use GL_Element.code where GL_Element.ID = GL_Accounting_Strip.category_obj |
2 | |
|
TX-OrganizationCode |
Organization Code |
GL_TX_STRIP_CROSSWALK, GL_ELEMENT_CATEGORY, GL_ELEMENT |
ORG_CODE |
If GL_TX_Strip_Crosswalk.id (Org) is not NULL then use GL_TX_Strip_Crosswalk.crosswalk_to Else If GL_TX_Element_Crosswalk.id (Org) is not NULL then use GL_TX_Element_Crosswalk.crosswalk_to Else use GL_Element.code where GL_Element.ID = GL_Accounting_Strip.category_org |
2 | |
|
TX-ProgramIntentCode |
Program Intent Code |
GL_TX_STRIP_CROSSWALK, GL_ELEMENT_CATEGORY, GL_ELEMENT |
PIC_CODE |
If GL_TX_Strip_Crosswalk.id (Pic) is not NULL then use GL_TX_Strip_Crosswalk.crosswalk_to Else If GL_TX_Element_Crosswalk.id (Pic) is not NULL then use GL_TX_Element_Crosswalk.crosswalk_to Else use GL_Element.code where GL_Element.ID = GL_Accounting_Strip.category_pic |
2 |