This table contains student financial data from Campus Solutions. 


KeyRecord.FieldnameFormatXLATHeading Text
 ACCOUNT - AccountChar10 Account
 ACCOUNT_DESCR - Account DescriptionChar30 Account
 ACCOUNTING_DT - Accounting DateDate Acctg Date
 ACCOUNTING_PERIOD - Accounting PeriodNum3.0 Period
 AFFILIATE - AffiliateChar5 Affiliate
 AFFILIATE_INTRA1 - Fund AffiliateChar10 Fund Affil
 AFFILIATE_INTRA2 - Operating Unit AffiliateChar10 Oper Unit Affil
 ALTACCT - Alternate AccountChar10 Alt Acct
 APPL_JRNL_ID - Journal TemplateChar10 Template
 BUDGET_PERIOD - Budget PeriodChar8 Budget Period
 BUDGET_REF - Budget ReferenceChar8 Bud Ref
 BUSINESS_UNIT - Business UnitChar5 Unit
 BUSINESS_UNIT_GL - GL Business UnitChar5 GL Unit
 CHARTFIELD1 - ChartField 1Char10 ChartField 1
 CHARTFIELD2 - ChartField 2Char10 ChartField 2
 CHARTFIELD3 - ChartField 3Char10 ChartField 3
 CLASS_FLD - Class FieldChar5 Class
 CURRENCY_CD - Currency CodeChar3 Currency
 DEPTID - DepartmentChar10 Dept
 DEPTID_DESCR - Department DescriptionChar30 Department
EMPLID - Empl IDChar11 ID
 EXT_GL_CHARTFLD - External GL Chart FieldChar50 Ext Chart
 FISCAL_YEAR - Fiscal YearNum4.0 Year
 FOREIGN_AMOUNT - Foreign AmountSNm25.3 Amount
 FOREIGN_CURRENCY - Foreign Currency CodeChar3 Currency
 FUND_CODE - Fund CodeChar5 Fund
 GL_DISTRIB_STATUS - Distribution StatusChar1NStatus
 IN_PROCESS_FLG - In ProcessChar1 In Process
 ITEM_NBR - Item NbrChar15 Item Nbr
 JOURNAL_DATE - Journal DateDate Date
 JOURNAL_ID - Journal IDChar10 Journal ID
 JOURNAL_LINE - GL Journal Line NumberNum9.0 Line #
 JOURNAL_LINE_DATE - Journal Line DateDate Line Date
 JRNL_LINE_STATUS - Journal Line StatusChar1NStatus
 JRNL_LN_REF - Journal Line ReferenceChar10 Ref
 LEDGER - LedgerChar10 Ledger
 LEDGER_GROUP - Ledger GroupChar10 Ledger Grp
 LINE_DESCR - Journal Line DescriptionChar30 Line Descr
 MONETARY_AMOUNT - Monetary AmountSNm25.3 Amount
 NAME - NameChar50 Name
 OPEN_ITEM_STATUS - Open Item StatusChar1NStatus
 OPER_UNIT_DESCR - Operating Unit DescriptionChar30 Operating Unit
 OPERATING_UNIT - Operating UnitChar8 Oper Unit
 PROCESS_INSTANCE - Process InstanceNum10.0 Instance
 PRODUCT - ProductChar6 Product
 PROGRAM_CODE - Program CodeChar5 Program
 PROJECT_ID - ProjectChar15 Project
 PROJECTDESCR - Project DescriptionChar30 Proj Descr
 RATE_DIV - Rate DivisorNum8.8 Divisor
 RATE_MULT - Rate MultiplierSNm9.8 Multiplier
 RT_TYPE - Rate TypeChar5 Rate Type
RUN_DT - Run DateDate Run Date
SEQNUM - Sequence numberNum3.0 SeqNum
 SF_DEPOSIT_ID - Deposit IDChar10 Deposit
 SF_EXT_ORG_ID - External Org IDChar11 Org ID
 SF_GL_RUN_INSTANCE - Process InstanceNum10.0 Instance
SF_LINE_NBR - Line NumberNum9.0 Line
 STATISTIC_AMOUNT - Statistic AmountSNm15.2 Stat Amt
 STATISTICS_CODE - Statistics CodeChar3 Stat
 UM_CLASS_D - Class DescChar30 Class Desc
 UM_FUND_DESCR - Fund DescriptionChar30 Fund Descr
 UM_HR_DEPT_DESCR - HR Dept DescriptionChar30 HR Dept Descr
 UM_HR_DEPTID - HR Dept IDChar10 HR Deptid
 UM_PROG_DESCR - Program DescriptionChar30 Prog Descr




SQL code for UM_SF_ACCTG_VW
SELECT A.RUN_DT,
       A.SEQNUM,
       A.SF_LINE_NBR,
       A.IN_PROCESS_FLG,
       A.BUSINESS_UNIT_GL,
       A.JOURNAL_ID,
       A.JOURNAL_DATE,
       A.JOURNAL_LINE,
       A.ACCOUNT,
       A.ALTACCT,
       A.DEPTID,
       A.OPERATING_UNIT,
       A.PRODUCT,
       A.FUND_CODE,
       A.CLASS_FLD,
       A.PROGRAM_CODE,
       A.BUDGET_REF,
       A.AFFILIATE,
       A.AFFILIATE_INTRA1,
       A.AFFILIATE_INTRA2,
       A.CHARTFIELD1,
       A.CHARTFIELD2,
       A.CHARTFIELD3,
       A.PROJECT_ID,
       A.STATISTICS_CODE,
       A.STATISTIC_AMOUNT,
       A.MONETARY_AMOUNT,
       A.JRNL_LN_REF,
       A.OPEN_ITEM_STATUS,
       A.LINE_DESCR,
       A.JRNL_LINE_STATUS,
       A.JOURNAL_LINE_DATE,
       A.BUSINESS_UNIT,
       A.APPL_JRNL_ID,
       A.ACCOUNTING_DT,
       A.GL_DISTRIB_STATUS,
       A.PROCESS_INSTANCE,
       A.CURRENCY_CD,
       A.ACCOUNTING_PERIOD,
       A.FISCAL_YEAR,
       A.FOREIGN_AMOUNT,
       A.FOREIGN_CURRENCY,
       A.LEDGER,
       A.LEDGER_GROUP,
       A.EXT_GL_CHARTFLD,
       A.EMPLID,
       EMPL.NAME,
       A.ITEM_NBR,
       A.BUDGET_PERIOD,
       A.RT_TYPE,
       A.RATE_DIV,
       A.RATE_MULT,
       A.SF_EXT_ORG_ID,
       A.SF_DEPOSIT_ID,
       A.SF_GL_RUN_INSTANCE,
       B.DESCR,
       C.DESCR,
       D.DESCR,
       E.DESCR,
       F.DESCR,
       H.DESCR,
       I.DESCR,
       G.UM_HR_DEPTID,
       G.UM_HR_DEPT_DESCR
  FROM PS_SF_ACCTG_LN     A,
       PS_DEPT_TBL        B,
       PS_GL_ACCOUNT_TBL  C,
       PS_PROGRAM_TBL     D,
       PS_PROJECT         E,
       PS_OPER_UNIT_TBL   F,
       PS_UM_HR_XREF      G,
       PS_FUND_TBL        H,
       PS_CLASS_CF_TBL    I,
       PS_UM_FGLEMPLOY_VW EMPL
 WHERE B.SETID = 'UMSYS'
   AND A.DEPTID = B.DEPTID
   AND B.EFFDT = (SELECT MAX(B_ED.EFFDT)
                    FROM PS_DEPT_TBL B_ED
                   WHERE B.SETID = B_ED.SETID
                     AND B.DEPTID = B_ED.DEPTID
                     AND B_ED.EFFDT <= A.ACCOUNTING_DT)
   AND C.SETID(+) = 'UMSYS'
   AND C.ACCOUNT = A.ACCOUNT
   AND C.EFFDT = (SELECT MAX(C_ED.EFFDT)
                    FROM PS_GL_ACCOUNT_TBL C_ED
                   WHERE C.SETID = C_ED.SETID
                     AND C.ACCOUNT = C_ED.ACCOUNT
                     AND C_ED.EFFDT <= A.ACCOUNTING_DT)
   AND D.SETID(+) = 'UMSYS'
   AND D.PROGRAM_CODE(+) = A.PROGRAM_CODE
   AND (D.EFFDT = (SELECT MAX(D_ED.EFFDT)
                     FROM PS_PROGRAM_TBL D_ED
                    WHERE D.SETID = D_ED.SETID
                      AND D.PROGRAM_CODE = D_ED.PROGRAM_CODE
                      AND D_ED.EFFDT <= A.ACCOUNTING_DT) OR
       D.EFFDT IS NULL)
   AND E.BUSINESS_UNIT(+) = 'UMSYS'
   AND E.PROJECT_ID(+) = A.PROJECT_ID
   AND F.SETID(+) = 'UMSYS'
   AND F.OPERATING_UNIT(+) = A.OPERATING_UNIT
   AND (F.EFFDT = (SELECT MAX(F_ED.EFFDT)
                     FROM PS_OPER_UNIT_TBL F_ED
                    WHERE F.SETID = F_ED.SETID
                      AND F.OPERATING_UNIT = F_ED.OPERATING_UNIT
                      AND F_ED.EFFDT <= A.ACCOUNTING_DT) OR
       F.EFFDT IS NULL)
   AND A.DEPTID = G.DEPTID(+)
   AND H.SETID(+) = 'UMSYS'
   AND H.FUND_CODE(+) = A.FUND_CODE
   AND (H.EFFDT = (SELECT MAX(H_ED.EFFDT)
                     FROM PS_FUND_TBL H_ED
                    WHERE H.SETID = H_ED.SETID
                      AND H.FUND_CODE = H_ED.FUND_CODE
                      AND H_ED.EFFDT <= A.ACCOUNTING_DT) OR
       H.EFFDT IS NULL)
   AND I.SETID(+) = 'UMSYS'
   AND I.CLASS_FLD(+) = A.CLASS_FLD
   AND (I.EFFDT = (SELECT MAX(I_ED.EFFDT)
                     FROM PS_CLASS_CF_TBL I_ED
                    WHERE I.SETID = I_ED.SETID
                      AND I.CLASS_FLD = I_ED.CLASS_FLD
                      AND I_ED.EFFDT <= A.ACCOUNTING_DT) OR
       I.EFFDT IS NULL)
   AND EMPL.EMPLID(+) = A.EMPLID
   AND EMPL.BUSINESS_UNIT(+) = A.BUSINESS_UNIT_GL;      


Data Dictionary Links

Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.