CDS Views for Functions for U.S. Federal Government (PSM-FG)

CDS View NameDescriptionSQL View Name
FMUSFGA_COMPATCompatibility view for FMUSFGA replace with ACDOCAFMUSFGA_COMPAT_V
FMUSFGA_FROM_ACDOCA_CCFWDLedger 95 data from ACDOCA for correction/close postingsFMUSFGA_ACDOCCV
FMUSFGA_ORIGINALAccess to original FMUSFGT table without proxyFMUSFGA_ORI_V
FMUSFGT_COMPATCompatibility view for FMUSFGT replace with ACDOCAFMUSFGT_COMPAT_V
FMUSFGT_GTAS_TOTALSummary of FMUSFGT with all GTAS attributesFMUSFGT_GTAS_T_V
FMUSFGT_GTAS_UNIONLedger 95 totals with all attributesFMUSFGT_GTAS_UV
FMUSFGT_ORIGINALAccess to original FMUSFGT table without proxyFMUSFGT_ORI_V
FMUSFGT_UNIONCompatibility view for FMUSFGT replace with ACDOCAFMUSFGT_UNION_V
I_USFEDALLOCTRANSFTRDGPARTUS Federal Allocation Transfer Agency Trading PartnerIFMFG_TP_ALTRAID
I_USFEDALLOCTRANSFTRDGPARTTEXTUS Federal Allocation Transfer Agency Trading Partner textIFMFG_TP_ALTRADT
I_USFEDAPPLSECDRYSRCEFUNDSUS Federal Application of Secondary Source FundsIFMFG_RFINUSE
I_USFEDAPPLSECDRYSRCEFUNDSTEXTUS Federal Application of Secondary Source Funds textIFMFG_RFINUSET
I_USFEDAPPORTIONMENTCATUS Federal Apportionment CategoryIFMFGAPPRTCAT
I_USFEDAPPORTIONMENTCATTEXTUS Federal Apportionment Category textIFMFGAPPRTCAT_T
I_USFEDAUTHORITYTYPEUS Federal Authority TypeIFMFG_FLG_AUTHOR
I_USFEDAUTHORITYTYPETEXTUS Federal Authority Type textIFMFG_FLG_AUTHRT
I_USFEDAVAILABILITYTYPEUS Federal Availability Type CodeIFMFG_AVTYPE
I_USFEDAVAILYTIMETYPEUS Federal Availability TimeIFMFG_FLG_AVAIL
I_USFEDAVAILYTIMETYPETEXTUS Federal Availability Time textIFMFG_FLG_AVAILT
I_USFEDAVAILYTYPETEXTUS Federal Availability Type Code textIFMFG_AVTYPET
I_USFEDBDGTENFORCEMENTCATUS Federal Budget Enforcement Act CategoryIFMFG_FLG_BEA
I_USFEDBDGTENFORCEMENTCATTEXTUS Federal Budget Enforcement Act Category textIFMFG_FLG_BEAT
I_USFEDBORROWINGSOURCEUS Federal Borrowing SourceIFMFG_FLG_BORROW
I_USFEDBORROWINGSOURCETEXTUS Federal Borrowing Source textIFMFG_FLG_BORRWT
I_USFEDBUDGETIMPACTUS Federal Budget ImpactIFMFG_BDGT_IMPCT
I_USFEDBUDGETIMPACTTEXTUS Federal Budget Impact textIFMFG_BDGT_MPCTT
I_USFEDCUSTODIALINDICATORUS Federal Custodial IndicatorIFMFG_FLG_CUSTDL
I_USFEDCUSTODIALINDICATORTEXTUS Federal Custodial Indicator textIFMFG_FLG_CSTDLT
I_USFEDDISASTEREMERGENCYFUNDUS Federal Disaster Emergency Fund CodeIFMFG_PROGRAM_ND
I_USFEDDISASTEREMERGENCYTEXTUS Federal Disaster Emergency Fund Code textIFMFG_PROGRM_NDT
I_USFEDEXCHANGEINDICATORUS Federal Exchange IndicatorIFMFG_FLG_EXCHNG
I_USFEDEXCHANGEINDTEXTUS Federal Exchange Indicator textIFMFG_FLG_XCHNGT
I_USFEDFEDERALNONFEDERALUS Federal Federal or Nonfederal CodeIFMFG_FLG_FEDERL
I_USFEDFEDERALNONFEDTEXTUS Federal Federal or Nonfederal Code textIFMFG_FLG_FEDRLT
I_USFEDOBJECTCLASSUS Federal Object ClassIFMFG_OBJ_CL
I_USFEDOBJECTCLASSTEXTUS Federal Object Class text for US FederalIFMFG_OBJ_CLT
I_USFEDPRIORYEARADJMTUS Federal Prior Year Adjustment CodeIFMFG_FLG_PYA
I_USFEDPRIORYEARADJMTTEXTUS Federal Prior Year Adjustment Code textIFMFG_FLG_PYAT
I_USFEDREIMBURSABLEUS Federal ReimbursableIFMFG_FLG_REIMBR
I_USFEDREIMBURSABLETEXTUS Federal Reimbursable textIFMFG_FLG_REMBRT
I_USFEDSTANDARDGLACCOUNTUS Federal Standard General Ledger AccountIFMFG_SGL_ACCONT
I_USFEDSTANDARDGLACCOUNTTEXTUS Federal Standard General Ledger Account textIFMFG_SGL_ACCNTT
I_USFEDTRADINGPARTNERAGCYUS Federal Trading Partner AgencyIFMFGTPAGENCY
I_USFEDTRADINGPARTNERAGCYTEXTUS Federal Trading Partner Agency textIFMFGTPAGENCYT
I_USFEDTRDGPARTAVAILYTEXTUS Federal Availability Type Code for Trdg Prtnr textIFMFG_TP_AVTYPET
I_USFEDTRDGPARTAVAILYTYPEUS Federal Availability Type Code for Trading PartnerIFMFG_TP_AVTYPE
I_USFEDTRDGPARTBUSEVTTYPEUS Federal Business Event Type Code for Trading PartnerIFMFG_TP_BETC
I_USFEDTRDGPARTBUSEVTTYPETEXTUS Federal Business Event Type Code for Trading Partner textIFMFG_TP_BETCT
I_USFEDTRDGPARTMAINACCOUNTUS Federal Main Account for Trading PartnerIFMFG_TP_MAN_CCT
I_USFEDTRDGPARTMAINACCOUNTTEXTUS Federal Main Account for Trading Partner textIFMFG_TP_MN_CCTT
I_USFEDTRDGPARTSUBACCOUNTUS Federal Subaccount for Trading PartnerIFMFG_TP_SUB_CCT
I_USFEDTRDGPARTSUBACCOUNTTEXTUS Federal Subaccount for Trading Partner textIFMFG_TP_SB_CCTT
I_USFEDTRDGPARTSUBLVLPREFIXUS Federal Sublevel Prefix for Trading PartnerIFMFG_TP_SUBLEVL
I_USFEDTRDGPARTSUBPREFIXTEXTUS Federal Sublevel Prefix for Trading Partner textIFMFG_TP_SUBLVLT
I_USFEDYEAROFBDGTAUTHORITYUS Federal Year of Budget AuthorityIFMFG_YR_BDGT_TH
I_USFEDYEAROFBDGTAUTHTEXTUS Federal Year of Budget Authority textIFMFG_YR_BDGT_TT