Created by Miki Yanagi, last modified on Nov 04, 2019
This table contains student financial data from Campus Solutions.
Key | Record.Fieldname | Format | XLAT | Heading Text |
---|---|---|---|---|
ACCOUNT - Account | Char10 | Account | ||
ACCOUNT_DESCR - Account Description | Char30 | Account | ||
ACCOUNTING_DT - Accounting Date | Date | Acctg Date | ||
ACCOUNTING_PERIOD - Accounting Period | Num3.0 | Period | ||
AFFILIATE - Affiliate | Char5 | Affiliate | ||
AFFILIATE_INTRA1 - Fund Affiliate | Char10 | Fund Affil | ||
AFFILIATE_INTRA2 - Operating Unit Affiliate | Char10 | Oper Unit Affil | ||
ALTACCT - Alternate Account | Char10 | Alt Acct | ||
APPL_JRNL_ID - Journal Template | Char10 | Template | ||
BUDGET_PERIOD - Budget Period | Char8 | Budget Period | ||
BUDGET_REF - Budget Reference | Char8 | Bud Ref | ||
BUSINESS_UNIT - Business Unit | Char5 | Unit | ||
BUSINESS_UNIT_GL - GL Business Unit | Char5 | GL Unit | ||
CHARTFIELD1 - ChartField 1 | Char10 | ChartField 1 | ||
CHARTFIELD2 - ChartField 2 | Char10 | ChartField 2 | ||
CHARTFIELD3 - ChartField 3 | Char10 | ChartField 3 | ||
CLASS_FLD - Class Field | Char5 | Class | ||
CURRENCY_CD - Currency Code | Char3 | Currency | ||
DEPTID - Department | Char10 | Dept | ||
DEPTID_DESCR - Department Description | Char30 | Department | ||
→ | EMPLID - Empl ID | Char11 | ID | |
EXT_GL_CHARTFLD - External GL Chart Field | Char50 | Ext Chart | ||
FISCAL_YEAR - Fiscal Year | Num4.0 | Year | ||
FOREIGN_AMOUNT - Foreign Amount | SNm25.3 | Amount | ||
FOREIGN_CURRENCY - Foreign Currency Code | Char3 | Currency | ||
FUND_CODE - Fund Code | Char5 | Fund | ||
GL_DISTRIB_STATUS - Distribution Status | Char1 | N | Status | |
IN_PROCESS_FLG - In Process | Char1 | In Process | ||
ITEM_NBR - Item Nbr | Char15 | Item Nbr | ||
JOURNAL_DATE - Journal Date | Date | Date | ||
JOURNAL_ID - Journal ID | Char10 | Journal ID | ||
JOURNAL_LINE - GL Journal Line Number | Num9.0 | Line # | ||
JOURNAL_LINE_DATE - Journal Line Date | Date | Line Date | ||
JRNL_LINE_STATUS - Journal Line Status | Char1 | N | Status | |
JRNL_LN_REF - Journal Line Reference | Char10 | Ref | ||
LEDGER - Ledger | Char10 | Ledger | ||
LEDGER_GROUP - Ledger Group | Char10 | Ledger Grp | ||
LINE_DESCR - Journal Line Description | Char30 | Line Descr | ||
MONETARY_AMOUNT - Monetary Amount | SNm25.3 | Amount | ||
NAME - Name | Char50 | Name | ||
OPEN_ITEM_STATUS - Open Item Status | Char1 | N | Status | |
OPER_UNIT_DESCR - Operating Unit Description | Char30 | Operating Unit | ||
OPERATING_UNIT - Operating Unit | Char8 | Oper Unit | ||
PROCESS_INSTANCE - Process Instance | Num10.0 | Instance | ||
PRODUCT - Product | Char6 | Product | ||
PROGRAM_CODE - Program Code | Char5 | Program | ||
PROJECT_ID - Project | Char15 | Project | ||
PROJECTDESCR - Project Description | Char30 | Proj Descr | ||
RATE_DIV - Rate Divisor | Num8.8 | Divisor | ||
RATE_MULT - Rate Multiplier | SNm9.8 | Multiplier | ||
RT_TYPE - Rate Type | Char5 | Rate Type | ||
→ | RUN_DT - Run Date | Date | Run Date | |
→ | SEQNUM - Sequence number | Num3.0 | SeqNum | |
SF_DEPOSIT_ID - Deposit ID | Char10 | Deposit | ||
SF_EXT_ORG_ID - External Org ID | Char11 | Org ID | ||
SF_GL_RUN_INSTANCE - Process Instance | Num10.0 | Instance | ||
→ | SF_LINE_NBR - Line Number | Num9.0 | Line | |
STATISTIC_AMOUNT - Statistic Amount | SNm15.2 | Stat Amt | ||
STATISTICS_CODE - Statistics Code | Char3 | Stat | ||
UM_CLASS_D - Class Desc | Char30 | Class Desc | ||
UM_FUND_DESCR - Fund Description | Char30 | Fund Descr | ||
UM_HR_DEPT_DESCR - HR Dept Description | Char30 | HR Dept Descr | ||
UM_HR_DEPTID - HR Dept ID | Char10 | HR Deptid | ||
UM_PROG_DESCR - Program Description | Char30 | Prog Descr |
SQL code for UM_SF_ACCTG_VW Expand source
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.