FILENAME=FDW_LEDGER_AGG_MV_2017, SUFFIX=SQLORA , $ SEGMENT=FDW_LEDGER_AGG_MV_2017, SEGTYPE=S0, $ FIELDNAME=FISCAL_MONTH_KEY, ALIAS=FISCAL_MONTH_KEY, USAGE=P4, ACTUAL=P8, MISSING=ON, $ FIELDNAME=FUND_KEY, ALIAS=FUND_KEY, USAGE=P4, ACTUAL=P8, MISSING=ON, $ FIELDNAME=ORG_KEY, ALIAS=ORG_KEY, USAGE=P7, ACTUAL=P8, MISSING=ON, $ FIELDNAME=PROGRAM_KEY, ALIAS=PROGRAM_KEY, USAGE=P6, ACTUAL=P8, MISSING=ON, $ FIELDNAME=PROJECT_KEY, ALIAS=PROJECT_KEY, USAGE=P7, ACTUAL=P8, MISSING=ON, $ FIELDNAME=ACCOUNT_KEY, ALIAS=ACCOUNT_KEY, USAGE=P7, ACTUAL=P8, MISSING=ON, $ FIELDNAME=BU_KEY, ALIAS=BU_KEY, USAGE=P3, ACTUAL=P8, MISSING=ON, $ FIELDNAME=OP_UNIT, ALIAS=OP_UNIT, USAGE=A5, ACTUAL=A5, $ FIELDNAME=DEPTID, ALIAS=DEPTID, USAGE=A10, ACTUAL=A10, $ FIELDNAME=ACTUAL, ALIAS=ACTUAL, USAGE=D20.2, ACTUAL=D8, MISSING=ON, $ FIELDNAME=BUDGET, ALIAS=BUDGET, USAGE=D20.2, ACTUAL=D8, MISSING=ON, $ FIELDNAME=VARIANCE, ALIAS=VARIANCE, USAGE=D20.2, ACTUAL=D8, MISSING=ON, $ FIELDNAME=BALANCE_BEG, ALIAS=BALANCE_BEG, USAGE=D20.2, ACTUAL=D8, MISSING=ON, $ FIELDNAME=ANNUAL_BUDGET, ALIAS=ANNUAL_BUDGET, USAGE=D20.2, ACTUAL=D8, MISSING=ON, $ FIELDNAME=ENCUMBRANCE, ALIAS=ENCUMBRANCE, USAGE=D20.2, ACTUAL=D8, MISSING=ON, $ FIELDNAME=YTD_ACTUAL, ALIAS=YTD_ACTUAL, USAGE=D20.2, ACTUAL=D8, MISSING=ON, $ FIELDNAME=YTD_BUDGET, ALIAS=YTD_BUDGET, USAGE=D20.2, ACTUAL=D8, MISSING=ON, $ FIELDNAME=YTD_VARIANCE, ALIAS=YTD_VARIANCE, USAGE=D20.2, ACTUAL=D8, MISSING=ON, $ FIELDNAME=YTD_BALANCE_BEG, ALIAS=YTD_BALANCE_BEG, USAGE=D20.2, ACTUAL=D8, MISSING=ON, $ FIELDNAME=YTD_BALANCE_END, ALIAS=YTD_BALANCE_END, USAGE=D20.2, ACTUAL=D8, MISSING=ON, $ FIELDNAME=YTD_ENCUMBRANCE, ALIAS=YTD_ENCUMBRANCE, USAGE=D20.2, ACTUAL=D8, MISSING=ON, $ FIELDNAME=REFRESH_DATE_TIME, ALIAS=REFRESH_DATE_TIME, USAGE=HYYMDS, ACTUAL=HYYMDS, MISSING=ON, $ $$ FILENAME=FDW_BUSINESS_UNIT, SUFFIX=SQLORA , $ SEGMENT=FDW_BUSINESS_UNIT, SEGTYPE=KLU,PARENT=FDW_LEDGER_AGG_MV_2017,CRFILE=FDW_BUSINESS_UNIT, $ FIELDNAME=BU_KEY, ALIAS=BU_KEY, USAGE=P3, ACTUAL=P2, $ FIELDNAME=BUSINESS_UNIT, ALIAS=BUSINESS_UNIT, USAGE=A10, ACTUAL=A10, MISSING=ON, $ FIELDNAME=BUSINESS_UNIT_DESC, ALIAS=BUSINESS_UNIT_DESC, USAGE=A50, ACTUAL=A50, MISSING=ON, $ FIELDNAME=MEDICAL_CENTER, ALIAS=MEDICAL_CENTER, USAGE=A10, ACTUAL=A10, MISSING=ON, $ FIELDNAME=MEDICAL_CENTER_DESC, ALIAS=MEDICAL_CENTER_DESC, USAGE=A50, ACTUAL=A50, MISSING=ON, $ FIELDNAME=CREATE_DATE_TIME, ALIAS=CREATE_DATE_TIME, USAGE=HYYMDS, ACTUAL=HYYMDS, $ FIELDNAME=UPDATE_DATE_TIME, ALIAS=UPDATE_DATE_TIME, USAGE=HYYMDS, ACTUAL=HYYMDS, $ FIELDNAME=UPDATE_USER, ALIAS=UPDATE_USER, USAGE=A20, ACTUAL=A20, MISSING=ON, $
FILENAME=FDW_LEDGER_2017_BV, VIEW_OF=FDW_LEDGER_JOINED_2017,$ SEGMENT=measures, $ $$ FIELDNAME=FISCAL_MONTH_KEY, ALIAS=FISCAL_MONTH_KEY, USAGE=P4, ACTUAL=P8,MISSING=ON, $ $$ FIELDNAME=FUND_KEY, ALIAS=FUND_KEY, USAGE=P4, ACTUAL=P8,MISSING=ON, $ $$ FIELDNAME=ORG_KEY, ALIAS=ORG_KEY, USAGE=P7, ACTUAL=P8, MISSING=ON, $ $$ FIELDNAME=PROGRAM_KEY, ALIAS=PROGRAM_KEY, USAGE=P6, ACTUAL=P8,MISSING=ON, $ $$ FIELDNAME=PROJECT_KEY, ALIAS=PROJECT_KEY, USAGE=P7, ACTUAL=P8,MISSING=ON, $ $$ FIELDNAME=ACCOUNT_KEY, ALIAS=ACCOUNT_KEY, USAGE=P7, ACTUAL=P8,MISSING=ON, $ $$ FIELDNAME=BU_KEY, ALIAS=BU_KEY, USAGE=P3, ACTUAL=P8, MISSING=ON, $ $$ FIELDNAME=OP_UNIT, ALIAS=OP_UNIT, USAGE=A5, ACTUAL=A5, $ FIELDNAME=ACTUAL, ALIAS=ACTUAL, BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $ FIELDNAME=ENCUMBRANCE, ALIAS=ENCUMBRANCE, BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $ FIELDNAME=BUDGET, ALIAS=BUDGET, BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $ FIELDNAME=VARIANCE, ALIAS=VARIANCE, BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $ FIELDNAME=YTD_ACTUAL, ALIAS=YTD_ACTUAL, BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $ FIELDNAME=YTD_ENCUMBRANCE, ALIAS=YTD_ENCUMBRANCE, BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $ FIELDNAME=YTD_BUDGET, ALIAS=YTD_BUDGET, BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $ FIELDNAME=YTD_VARIANCE, ALIAS=YTD_VARIANCE, BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $ FIELDNAME=YTD_BALANCE_BEG, ALIAS=YTD_BALANCE_BEG, BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $ FIELDNAME=YTD_BALANCE_END, ALIAS=YTD_BALANCE_END, BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $ FIELDNAME=BALANCE_BEG, ALIAS=BALANCE_BEG, BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017,$ FIELDNAME=ANNUAL_BUDGET, ALIAS=ANNUAL_BUDGET, BELONGS_TO_SEGMENT=FDW_LEDGER_AGG_MV_2017, $ $$ FIELDNAME=REFRESH_DATE_TIME, ALIAS=REFRESH_DATE_TIME, USAGE=HYYMDS, ACTUAL=HYYMDS, MISSING=ON, $ $$ FILENAME=FDW_BUSINESS_UNIT, SUFFIX=SQLORA , $ SEGMENT=businessunit, $ $$ FIELDNAME=BU_KEY, ALIAS=BU_KEY, USAGE=P3, ACTUAL=P2, $ FIELDNAME=BUSINESS_UNIT, ALIAS=BUSINESS_UNIT, BELONGS_TO_SEGMENT=FDW_BUSINESS_UNIT, $ FIELDNAME=BUSINESS_UNIT_DESC, ALIAS=BUSINESS_UNIT_DESC,BELONGS_TO_SEGMENT=FDW_BUSINESS_UNIT,$ $$ FIELDNAME=MEDICAL_CENTER, ALIAS=MEDICAL_CENTER, USAGE=A10, ACTUAL=A10, MISSING=ON, $ $$ FIELDNAME=MEDICAL_CENTER_DESC, ALIAS=MEDICAL_CENTER_DESC, USAGE=A50, ACTUAL=A50, MISSING=ON, $ $$ FIELDNAME=CREATE_DATE_TIME, ALIAS=CREATE_DATE_TIME, USAGE=HYYMDS, ACTUAL=HYYMDS, $ $$ FIELDNAME=UPDATE_DATE_TIME, ALIAS=UPDATE_DATE_TIME, USAGE=HYYMDS, ACTUAL=HYYMDS, $ $$ FIELDNAME=UPDATE_USER, ALIAS=UPDATE_USER, USAGE=A20, ACTUAL=A20, MISSING=ON, $
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |