COAACR is actually a view of the table for translating the funding chart/account
number. Only the current period chart/accounts are included in this view whereas the
FIS_ORGANIZATION_ACCOUNT table contains the list of chart/accounts for all the fiscal
periods since the DaFIS system went into production July 1997. The data for the table and
view originates from the DaFIS Decision Support system. Updates happen on a monthly basis,
near the beginning of each month when DaFIS "freezes" the fiscal period's
chart/account numbers.
The COAACR view mimics the extract file that is sent by DaFIS to Office of the President
on a nightly basis. It is used by the online Payroll/Personnel System (PPS) to validate
valid chart/account numbers.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| ALL_ACCT_NBR | All ACCOUNT NUMBER | VARCHAR2(7) | The A-11 Account that was the old system precursor to this Account. |
| ACCOUNT_NBR | ACCOUNT NUMBER | VARCHAR2(7) | The organization-selected identifier used to classify financial resources for accounting and reporting purposes. |
| ACCOUNT_NM | ACCOUNT NAME | VARCHAR2(40) | The descriptive name of the account. |
| ACCT_EFFECT_DT | ACCOUNT EFFECTIVE DATE | DATE | The date which this account became effective and can begin accepting transactions. |
| ACCT_EXPIRATION_DT | ACCOUNT EXPIRATION DATE | DATE | This is the date on which the account expires and will no longer accept transactions. |
| ACCT_GRP_CD | ACCOUNT GROUP CODE | VARCHAR2(6) | The code developed and maintained by UCOP on each account used to identify the type of account and its placement with the chart of accounts number. |
| ACCT_SAU_CD | SYSTEM ADMINISTRATIVE UNIT CODE | VARCHAR2(1) | Not used - blank. |
| ACCT_TYPE_CD | ACCOUNT TYPE CODE | VARCHAR2(2) | The code used to identify the account as income, expenditure,etc. |
| AWRD_BEGIN_DT | AWARD BEGIN DATE | DATE | The effective date of a contract or grant. |
| AWRD_END_DT | AWARD END DATE | DATE | The termination date of a contract or grant. |
| CG_ON_OFF_CMPS_CD | ON/OFF CAMPUS CODE | VARCHAR2(1) | The code which indicates whether a project is considered on or off campus. |
| CONT_ACCOUNT_NBR | CONTINUATION ACCOUNT NUMBER | VARCHAR2(2) | Not used - blank. |
| CONT_FIN_COA_CD | CONTINUATION CHART OF ACCOUNTS NUMBER | VARCHAR2(2) | Not used - blank. |
| CONTR_CNTRL_ACCT_NBR | CONTROL ACCOUNT NUMBER | VARCHAR2(7) | The primary spending authority account for a contract/grant that has been assigned multiple accounts. This is the account used for most reporting. |
| CONTR_CTRL_FIN_COA_CD | CONTROL CHART OF ACCOUNTS NUMBER | VARCHAR2(2) | The Chart of Accounts that the Control Account belongs to. |
| COST_SHARING_IND | COST SHARING INDICATOR | VARCHAR2(1) | The code indicating the cost sharing requirements of an account. |
| FFT_CODE | FEDERAL FLOW THROUGH CODE | VARCHAR2(1) | The code indicating that this account is designed as a Federal Flow Through account. |
| FIN_COA_CD | CHART OF ACCOUNTS NUMBER | VARCHAR2(2) | The identifier of a Chart of Accounts. |
| FIN_HGH_ED_FUNC_CD | HIGHER EDUCATION FUNCTION CODE | VARCHAR2(4) | The function code which is assigned to each account which matches expenditure to the functionality of the account. High Education examples are instruction, academic support, art and museums, etc. These names are the most detailed level of functional classification and are utilized in determining AICPA function codes, and federal function codes for indirect cost pruposes. |
| FUND_GRP_CD | FUND GROUP CODE | VARCHAR2(2) | The code that identifies a major fund group. The fund groups are current funds, plant funds, agency funds, endowment funds, loan funds and UCRS funds. |
| HOME_DEPT_CD | HOME DEPARTMENT NUMBER | VARCHAR2(6) | The code currently used to identify campus department for Payroll and report distribution. (translation in CTLHME table) |
| OP_FUND_GRP_CD | OP FUND GROUP CODE | VARCHAR2(6) | The Office of the President code indicating the category to which a fund belongs in the university's accounting structure. |
| OP_FUND_NBR | UCD/OP FUND NUBER | VARCHAR2(6) | The UCD pre-DAFIS fund number for reporting to Office of the President. |
| OP_ORG_CATEGORY_CD | OP ORGANIZATION CODE | VARCHAR2(1) | Not used - blank. |
| OP_PROGRAM_CD | OP PROGRAM CODE | VARCHAR2(6) | Reserved for Accounting/OP Use. |
| ORG_CD | ORGANIZATION CODE | VARCHAR2(4) | The identifier of an organization. |
| SPONSOR_CD | SPONSOR CODE | VARCHAR2(4) | Reserved for Extramural Accounting. |
| SUB_FUND_GRP_CD | SUB FUND GROUP NUMBER | VARCHAR2(6) | The code used to identify the fund source of an account. Similar to the A11 system fund number, but will be an alpha abbreviation instead of a number. |
| SUB_FUND_GROUP_DESC | SUB FUND GROUP RESDTRICTION CODE | VARCHAR2(40) | The descriptive name for the Sub Fund Group. Example of sub fund group are general funds, endowments, contracts and grants. |
| SUB_FUND_GRP_TYPE_CD | SUB FUND GROUP TYPE CODE | VARCHAR2(1) | The code used to group like sub funds. For example, Federal Contracts would be a sub fund group type with a number of associated sub fund groups. |
| SUB_FUND_GROUP_TYPE_NAME | SUB FUND GORUP TYPE NAME | VARCHAR2(40) | The descriptive name for the Sub Fund Group Type. |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data
Warehouse Support
Last Updated: August 11, 1999