User Defined Reporting - Data Sources
This article provides the list of reporting fields available for each data source that can be used to create a User Defined Report (UDR). For instructions on creating a UDR, see this article: User Defined Reporting Tool
117_1 ASU (Excludes pledges)
AdminFees
BegBal
- Contributions
- Distributions
- EndBal
- Endowment Name
- FASBType
- GLID
- Income
- Investment Fees
- Net Asset Classification
- PermRestr
- RealizedGainLoss
- TempRestr
- Transfers
- UnrealizedGainLoss
- Unrestr
Activity Summary and Transactions
Administrative Fees
Auxiliary ID
- Beginning Book Value
- Beginning Historical Gift
- Beginning MV
- Beginning MV Less HG
- Beginning Nonpooled
- Beginning Pledge Balance
- Beginning Total MV
- Beginning Unit Price
- Beginning Units
- Book Value Transfer In
- Book Value Transfer Out
- Business Office Notes
- Cash Historical Gift Transfer
- Change in Historical Gift
- Change in Units
- Distribution
- Distribution Destination ID
- Distributions All
- Distributions Plus Admin Fees
- Due To/From Transfer
- Ending Book Value
- Ending Historical Gift
- Ending MV
- Ending MV Less HG
- Ending Nonpooled
- Ending Pledge Balance
- Ending Total MV
- Ending Unit Price
- Ending Units
- Expendable Fund
- Expense
- Expenses All
- External Transfer In
- External Transfer Out
- FASB Restriction
- Funding Source
- Gift
- Gifts All
- Gifts Plus Transfers
- GLID
- GLID Fund Name
- Inception Date
- Income
- Income Account
- Income BU
- Income Department
- Income Fund
- Income Net of Fees
- Income RGL Investment Fees
- Income to Principal
- Internal Book Value X-Fer
- Internal Transfer
- Investment Fees
- Investment Pool
- Liability
- Manual Income Transactions
- Manual Investment Fee Transactions
- Manual Realized Gains Transactions
- Manual Unrealized Gains Transactions
- Match Funds
- Misc. Trans.
- Net Asset Classification
- Net Investment Activity
- Non-Cash Historical Gift Transfer
- Non-Unitized Asset Transfer
- Peoplesoft Department
- Peoplesoft Department-addl
- Pledge
- Pledge Payment
- Pledge Write-Off
- Realized Gains
- Reporting Division
- Restriction Code
- Revenue
- Spending Bucket Trans
- Spending Rule
- Status
- Total Fees
- Transfers All
- Unrealized Gains
Distribution Rules
Activity Type
Amount
- Authorized Date
- Dept Code
- Distribution Destination ID
- Distribution Rule Calc Type
- Distribution Rule Dept Code
- Distribution Rule Destination ID
- Distribution Rule Fund
- Distribution Rule Last Modified Date
- Distribution Rule Program
- Distribution Rule Project
- Expendable Fund GLID
- Expendable Fund Name
- Fund
- Gain Acct
- GLID
- GLID Fund Name
- Income Acct
- Internal Destination
- Invest Acct
- Notes
- Program
- Project
- Reinvest Threshold
- Reinvest Type
Estimated Spending Report
Annual Estimated Gross Distribution
Annual Estimated Net Distribution
- Annual Estimated Reinvestment
- Aux ID
- Average MV
- Business Office Notes
- Dept Code
- Dest Dept
- Dest Program
- Distribution Destination ID
- Endowment Description
- Endowment Name
- FASB Type
- Fee Schedule Names
- Flag Funds
- Fund Notes
- Fund Status
- Funding Source
- GLID
- Historical Gift
- Inception Date
- Income BU
- Income Fund
- Investment Pool
- Match Funds
- Net Asset Classification
- Peoplesoft Department
- Peoplesoft Department-addl
- Pooled Market Value as of Post Date
- Prior Year Spending
- Purpose Code
- Purpose Descript
- Reinvest Threshold
- Reinvest Type
- Reporting Division
- Secondary Description
- Secondary Spending Rule
- Spending Allocation Date
- Spending Bucket Balance
- Spending Date
- Spending Rule
- Spending Rule Tier
- Spending Rule Tier with Spending Rule
- Total Market Value as of Post Date
- Underwater Amount
- Units
- Withdrawal Estimated Gross Distribution
- Withdrawal Estimated Net Distribution
- Withdrawal Estimated Reinvestment
Estimated Spending Report
Annual Cash flow (Net)
Annual Transaction Amt
- Automated Dist Source Note
- Aux ID
- Business Office Notes
- Dept Code
- Dest Dept
- Dest Program
- Dist Rule Activity Type
- Dist Rule Amount/Percentage
- Dist Rule Area
- Dist Rule Calc Type
- Dist Rule Destination ID
- Dist Rule DestinationField3
- Dist Rule DestinationField4
- Dist Rule Org
- Distribution Destination ID
- Endowment Description
- Endowment Name
- FASB Type
- Funding Source
- GLID
- Inception Date
- Income BU
- Income Fund
- Investment Pool
- Match Funds
- Net Asset Classification
- Peoplesoft Department
- Peoplesoft Department-addl
- Purpose Code
- Purpose Descript
- Reinvest Threshold
- Reporting Division
- Secondary Description
- Secondary Spending Rule
- Spending Allocation Date
- Spending Date
- Spending Rule
- Spending Rule Tier
- Spending Rule Tier with Spending Rule
- Transaction Note
- Transaction Type
- Withdrawal Transaction Amt
- Withdrawl amount (Net)
Profile Data
Aux ID
Business Office Notes
- DeptCode
- DestDept
- DestProgram
- Distribution Destination ID
- Endowment Description
- Endowment Name
- Fee Schedule Names
- FoundationFund
- Fund Notes
- Fund Status
- Funding Source
- FundKey
- GLID
- Inception Date
- Income BU
- Income Fund
- Investment Pool
- Match Funds
- Net Asset Classification
- Peoplesoft Department
- Peoplesoft Department-addl
- Purpose Descript
- PurposeCode
- Reinvest
- Reporting Division
- Secondary Description
- Spending Date
- Spending Rule
- Status
- TypeCode
Transaction Details in Date Range
Aux ID
Business Office Notes
- Cash Flow Amount
- DeptCode
- DestDept
- DestProgram
- Distribution Dept
- Distribution Destination ID
- Distribution Destination ID
- Distribution Fund
- Distribution Program
- Distribution Project
- Effective Date
- Endowment Description
- Endowment Name
- Entered Amount
- External Transfer Org
- FASBType
- FoundationFund
- Funding Source
- GLID
- Inception Date
- Income BU
- Income Fund
- Investment Pool
- Journal Date
- Last Modified
- Match Funds
- Merge To From Fund
- Modified By
- Net Asset Classification
- NonEndowedFund
- Note
- Object Code
- Override Unit Price
- Peoplesoft Department
- Peoplesoft Department-addl
- Post Date
- ProfileData_FeeScheduleNames
- ProfileData_FundNotes
- ProfileData_FundStatus
- Program Code
- Purpose Descript
- PurposeCode
- Reinvest
- Reporting Division
- Secondary Description
- SecondarySpendingRule
- Source
- Spending Date
- Spending Rule
- Status
- System Generated
- TransactionType
- Transfer To Fund
- TransID
- TypeCode
- Unit Price
- Units
Transactions
- Amount
- Aux ID
- Business Office Notes
- DeptCode
- DestDept
- Destination
- DestProgram
- Distribution Destination ID
- DonorID
- EffectiveDate
- Endowment Description
- Endowment Name
- External Transfer Org
- Fee Schedule Names
- FoundationFund
- Fund Notes
- Fund Status
- Funding Source
- FundKey
- GainAmt
- GiftImportKey
- GLID
- GLID Fund Name
- ImportFileID
- Inception Date
- Income Account
- Income BU
- Income Department
- Income Fund
- IncomeAmount
- IncomeBal
- Investment Pool
- JournalDate
- LastModified
- LoginID
- Match Funds
- Net Asset Classification
- NetCashFlowAmount
- Note
- ObjectCode
- OverideUnitPR
- Peoplesoft Department
- Peoplesoft Department-addl
- Post Date
- Posted
- PrinBal
- ProgramCode
- Purpose Descript
- PurposeCode
- Reinvest
- Reporting Division
- Secondary Description
- ShareBal
- Spending Date
- Spending Rule
- Status
- TransactionType
- TransferLink
- TransferToEndowmentKey
- TransID
- TransType
- TypeCode
- Unit Price
- Units
- UnrPrin
- UnrUnits
Underwater Report ASU (Excludes pledges)
- Business Office Notes
- DeptCode
- DestDept
- DestProgram
- Distribution Destination ID
- Distributions
- EndHistoricalGift
- Endowment Description
- Endowment Name
- FASBType
- Fee Schedule Names
- FoundationFund
- Fund Count
- Fund Notes
- Fund Status
- Funding Source
- FundKey
- GLID
- GLID Fund Name
- Inception Date
- Income BU
- Income Fund
- Investment Pool
- Match Funds
- Net Asset Classification
- NonEndowedFund
- Peoplesoft Department
- Peoplesoft Department-addl
- Post Date
- Purpose Descript
- PurposeCode
- Reinvest
- Reporting Division
- Secondary Description
- SecondarySpendingRule
- Spending Date
- Spending Rule
- Status
- TotalMarketValue
- TypeCode
- UnderwaterAmount
Was this article helpful?
Reply
Content aside
- 6 mths agoLast active
- 32Views
-
1
Following