Microsoft word - 141.doc

FIELD NAME
DESCRIPTION
GRUP-ACCESS1
GROUP DATA RELATED TO ORGANIZATIONAL ACCESS. GRUP-ACCESS2
GROUP DATA RELATED TO FINANCIAL AREA ACCESS. GRUP-ACCESS3
GROUP DATA RELATED TO HUMAN RESOURCES ACCESS. GRUP-ACCESS4
GROUP DATA RELATED TO CROSS-ADMINISTRATION ACCESS. CODE-UNIV-REC-TYPE
CODE IDENTIFYING A SPECIFIC RECORD TYPE WITHIN THE UNIVERSITY CODE-RECD-LAST-UPDATE-TRANS
THE ID OF THE LAST FUNCTION TO UPDATE THE RECORD. AMNT-ICOA-AWARD-TOTAL
The award amount for a particular account (budget/fund). The fund file contains the total award amount for that fund. The account file contains the total portion of that award allocated to the account. The contract award amount contains the total award for the contract, which may be divided across more than 1 fund number. REVERSION RULES: In RDACM, AM-AWARD-AMOUNT. Straight move of Account-Award-Amount to Input Rcd1 Col. 60-70 CODE-CBUD
A number assigned to admin area, comprised of: 2-byte function 3-byte division 3-byte department 1-byte special project and a 2 byte location code. CODE-EMPL-USERID-ICOA-ADMN
The University-assigned userid for the person responsible for monitoring the account, or the 3-byte admin officer initials. The current central acctg file does not carry both the Account Administrator and the Fund Administrator as IBIS does. It does not separate Account-Administrator(Admoff/ Research Dean) from the Fund-Administrator (PI). REVERSION RULES: Call U-CBUDG using budget-number to CODE-FACO
On federal agreements, the name of the person we must contact, the Federal Administrative Contract Officer. DCAA- Defense contract audit agency ONRR - Office of Naval Research Rep REVERSION RULES: None INITIALIZE to spaces. IBIS VALIDATION: CODE-ICOA-FRINGE-ACTUAL
CODE-ICOA-INDIRECT-CALC-ACTUAL
The actual code for the default CODE-ICOA-INDIRECT-CALC-ACTUAL CODE-ICOA-MSTR-CHNG-TYPE
A code designating the type of change being performed on the Chart of Accounts file: N = New master C = Change to existing master R = Reopen previously closed master REVERSION RULES: If "R" move a hyphen to INPUT RECORD 1: Col 77-77. DATE-ICOA-ACCOUNT-BEGIN
The date an account begins. REVERSION RULES: Change IBIS format date (YYYYMMDD) to old central acctg system format (MMDDYY). Enter as INPUT RCD3 Col. 20-25 (WS-FUND-START-DATE-3). NOTE: Fund dates were not kept in RDACM, Acct dates were. INITIALIZE to current system date. IBIS VALIDATION: Date validation. DATE-ICOA-ACCOUNT-CLOSED
The date an account closes. This will be set by Research Acctg, not by the system, and will occur sometime after the Hold-Close-Date. REVERSION RULES: In RDACM, AM-CLOSED-BYTE. When account is intially set up, move '0' to WS-CLOSE-BYTE-1. When Account-Closed-Date > zeroes, move '1' to INPUT RCD1 Col 76 (WS-CLOSE-BYTE-1). DATE-ICOA-ACCOUNT-END
The date an account ends. REVERSION RULES: In RDACM, AM-FUND-END-DATE. Change IBIS date format (YYYYMMDD) to old central acctg system format (MMDDYY). Enter as INPUT RCD3 Col. 26-31 (WS-FUND-END-DATE-3). INITIALIZE to zeroes. IBIS VALIDATION: Date validation. DATE-ICOA-ACCOUNT-HOLD-CLOSE
This date will be set by the system, 60 calendar days after the FUND-END-DATE. Research Acctg can adjust this date, but no posting will occur AFTER this date unless Res Acctg sets an override for that particular detail. This date can be changed by Res Acctg, for example, if unanticipated direct billing (postage, telephone charges, etc) come in after the hold close date. At some point after this, the Account-Close Date will be set by the account steward, which DATE-ICOA-ACCOUNT-MAINT
The date of the last change to this account. This was not used in the old central acctg INDC-ICOA-EXPEND-ALLOW
"Y" INDICATES EXPENSES CAN BE POSTED TO THIS ACCT. BUDGET MONEY ONLY ACCOUNTS, LIKE 3999 FUNDS, AND REVENUE ACCOUNTS WOULD BE "N" SINCE THEY DONT HAVE EXPENDITURES POSTED TO THEM. INDC-ICOA-CARRYOVER
This indicator set to "Y(es)" means an account record is to is to carried forward or copied into the new fiscal year. REVERSION RULES: None. In the old central acctg system, this indicator is with the details file, not the acctmast RDACM. INITIALIZE to "N" for "No." IBIS VALIDATION: Y or N NAME-ICOA
A descriptive name for the account. In the old central acctg system this was a variation of the fund name. REVERSION RULES: In RDACM, AM-GENERAL-LEDGER-FUND. For restricted funds, Account-Name will be made up: a) 10-bytes of Sponsor-Code b) 30-bytes of Account-Name text Straight move to Input Rcd2 Col. 20-39 (WS-FUND-NAME-2). SPECIAL NOTE: Since the IBIS field is 10-bytes longer than the central FIELD NAME
DESCRIPTION
CODE-FUND
THE FUND NUMBER THE TRANSACTION WILL BE POSTED TO. THE FUND NUMBERS ARE ASSIGNED BY THE CONTROLLER'S OFFICE. DATA STEWARD: CONTOLLER'S OFFICE PCNT-ICOA-COST-SHARE-ACTUAL
The actual percent for the default field PCNT-FUND-COST-SHARE-DEFAULT PCNT-ICOA-FRINGE-GRAD-ACTUAL
PCNT-ICOA-FRINGE-SAL-ACAD-ACT
PCNT-ICOA-FRINGE-WAGE-ACTUAL
PCNT-ICOA-INDIRECT-CALC-ACTUAL
The actual percent for the default PCNT-FUND-INDIRECT-CALC-DEFAUL PCNT-ICOA-INDIRECT-CALC-CAP-ACT
The actual percent for the default PCNT-FUND-INDIRECT-CALC-CAP-DE CODE-ICOA-ROUTING-SUPPL-ADMOFF
A combination of admin officer initials to further breakdown an admin area for routing of reports to desks within the admin area. REVERSION RULES: Use budget number to call CBUDG to get the admin area. Use admin area to call CADAREXE to get the admin officer initials. Move admin officer initials to INPUT RCD1 Col. 50-52 (WS-ADM-OFF-INITIALS-1). Move Code-Admin-Area-Routing to INPUT RCD1 Col. 53-55 (WS-SUPP-INITIALS-1). CODE-ICOA-ROUTING-ENDOWMENT
A code used to route the non-restricted endowment fund reports. REVERSION RULES: In RDACM as AM-FISCAL-DUE-MONTH for funds beginning with 19xx (endowment funds). Straight move to INPUT RCD3 Col. 58-59 (WS-FISCAL-DUE-MONTH-3). INITIALIZE to spaces. IBIS VALIDATION: Alpha if fund begins with 19xx See codeset "xxxxxxxx" CODE-ICOA-ROUTING-SPEC-PROJ
A code assigned by the Corporate Controller's Office to group non-restricted funds by source of funds. These codes can be deleted and reassigned. Their meaning is confidential so no listing exists to cross-reference the code to the meaning. REVERSION RULES: In RDACM, AM-SPECIAL-PROJECT-CODE. In the old central acctg system, this 2-byte code is always used in conjunction with a special project number within the budget number. In CODE-FUND-MAINT-IND
THIS CODE IS USED TO CONTROL BATCH UPDATING. BYTE 1 ID'S THE FILE TO UPDATE AND BYTES 2-8 ID THE FIELD TO UPDATE. INDC-ICOA-CLRNG-ACCT
PCNT-ICOA-FRINGE-SAL-NONACAD-ACT
NUMB-ICOA-CFDA-ACTUAL
PCNT-ICOA-MGMT-FEE-ACTUAL
CODE-ICOA-REPORT-TYPE
A CODE INDICATING THE TYPE OF REPORT THAT SHOULD BE CREATED. TEXT-ICOA-DEPT
A FREE FORMAT TEXT AREA TO BE USED BY THE DEPARTMENT. CODE-CBUD-ICOA-MATCHING
CODE-FUND-ICOA-MATCHING
CODE-ICOA-COST-TYPE
A CODE INDICATING THE RESEARCH OR COST TYPE. TEXT-ICOA-CENT-DESK
A FREE FORMAT TEXT AREA TO BE USED BY THE ACCOUNTING OFFICE. DATE-ICOA-REVERT
A DATE THAT TELLS THE REVERSION PROGRAM THAT THERE HAS BEEN A CHANGE TO THE REVERSION FIELDS FOR THIS RECORD. IF THIS DATE IS GREATER THAN OR EQUAL TO THE INCOMING OPTION DATE, A REVERSION RECORD WILL BE CREATED TO PASS THIS CHANGED DATA BACK TO THE OLD CENTRAL ACCOUNTING SYSTEM. GRUP-EMPL-COA-DIR
NAME-EMPL-LAST-ICOA-PROJ-DIR
NAME-EMPL-FIRST-ICOA-PROJ-DIR
NAME-EMPL-MID-ICOA-PROJ-DIR
NUMB-EMPL-USERID
NUMB-EMPL-SSN
INDC-ICOA-CREATE-ACCESS-PROFILE
To determine if a user profileneeds to be created. TIME-ICOA-MAINT
DATE-ICOA-REVERT-REOPEN
INDC-FNST-PROCESS-ASSN-BATCH
GRUP-FNST-GLOBAL-ASSN
FIELD NAME
DESCRIPTION
CODE-BUDG-ADMN-AREA
THE ADMINISTRATIVE AREA CODE OF THE DEPARTMENT ASSIGNED TO THE ROOM. DERIVED BASED ON CODE-BUDG. SHORT LABEL=ADMN LONG LABEL=ADMIN AREA CODE-BUDG
NUMB-FNST-ID-GLOBAL
GRUP-FUND-RANGE
CODE-FUND-START
The first fund number in an associated range of fund numbers. CODE-FUND-END
The last fund number in an associated range of fund numbers. CODE-AGCY-RES
CODE-CBUD-ACCESS-MNEMONIC
CODE-EMPL-USERID-ADMN
The userid of the Structure Administrator. GRUP-FNST-PURE-ID
CODE-EMPL-USERID-PURE-CREATOR
The userid of the person who created the structure. CODE-FNST-PURE-ID
GRUP-FNST-ASSN
NUMB-FNST-ASSN-ACCT
CODE-CBUD-ACCESS-MNEMONIC-ASSN
CODE-CCTR-ASSN
CODE-CCAC-ASSN
CODE-EMPL-USERID-ASSN-ADMN
NUMB-FNST-ID-ASSN
GRUP-FNST-PURE-ID-ASSN
CODE-EMPL-USERID-PURE-CREAT-ASSN
CODE-FNST-PURE-ID-ASSN
NAME-FNST-SHORT-TITLE
The shortened version of the structure title. NAME-FNST-LONG-TITLE
DATE-FNST-BEGIN
DATE-FNST-END
DATE-RECD-LAST-UPDATE-TRANS
NUMB-ICOA-BEN-FRANKLIN
THIS ELEMENT WILL BE USED TO IDENTIFY AND LABEL BEN FRANKLIN NUMB-ICOA-ACCOUNT-ENCM
DATE-ICOA-CREATE
THE DATE A NEW ACCOUNT NUMBER IS ADDED TO THE U-COA FILE. INDC-ICOA-REC-ASSOC
INDICATES WHETHER A COA RECORD HAS PASSED THROUGH THE ASSOCIATION CODE-ICOA-INDIRECT-CALC-TYPE
INDICATES THE TYPE OF INDIRECT COSTS CALCULATION TO BE DONE. PCNT-ICOA-GOVT-USE
THE RATE FOR CONTRACTS WHICH INCLUDE A USER FEE NEGOTIATED PCNT-ICOA-PRIME-RATE
FOR ACCOUNTS WITH THE PRIME INDIRECT COST RATE, THIS WOULD INDICATE WHAT PERCENTAGE OF THE INDIRECT COST RATE IS TO BE CREDITED TO THE MGR ACCOUNT. FIELD NAME
DESCRIPTION
NUMB-ICOA-PRIME-CREDIT
FOR ACCOUNTS WITH THE PRIME INDIRECT COST RATE, THE MISCELLANEOUS GENERAL RESEARCH ACCOUNT TO WHICH THE PRIME PORTION OF THE OVERHEAD WOULD BE CREDITED. PCNT-ICOA-ARL-INTERNAL
FOR CONTRACTS WHICH INCLUDE AN INCENTIVE RATE TO KICKBACK INDIRECT COSTS TO THE BUDGET OF THE DEPARTMENT PERFORMING THE RESEARCH. CODE-FUND-TYPE
CODE-ICOA-FASB
THIS CODE WILL INDICATE WHETHER THIS ACCOUNT BELONGS IN REPORTS DESIGNATED FOR THE FINANCIAL ACCOUNTING STANDARD BOARD. TEXT-ICOA-CONT-AGREEMENT-PRD
THREE CHARACTERS TO CORRESPOND TO THREE CHARACTER ADDITION TO CONTRACT AGREEMENT SPECIFIC TO TIME PERIOD SET BY AGENCY. DATE-ICOA-FISCAL-YR-ASSOC
DATE-ICOA-PRECOST-BEGIN
The date that details may begin posting to an account even before its contract has not AMNT-ICOA-PRECOST-AWARD-TOT
Total dollars posted to an account during the precost award period. AMNT-ICOA-PRECOST-AWARD-USED
Total dollars posted to an account during the precost award period. CODE-ICOA-FO-CHGS
INDICATES WHETHER CODE-FNST-DTL-FO CHANGES ARE NEEDED. NUMB-FNST-ALL-ID
THIS NUMBER WILL BE USED TO IDENTIFY TOTAL DOLLARS FOR A PARTICULAR ACCOUNT'S POSTINGS OVER ONE OR MANY FISCAL YEARS. PCNT-ICOA-ARL-ADMIN-FEE
THE RATE AT WHICH THE ARL MANAGEMENT FEE WILL BE CHARGED. INDC-TRAN-DATE
This field will indicate if this account is using accrual account. long label=indc transaction date short label=indc trans date CODE-ICOA-FUND-TYPE
This field will tell what type of account the account is. INDC-ICOA-ACCT-EXCLUDE
Indicates that all details for an account are to be totally excluded from the indirect cost PCNT-ICOA-FRINGE-STUDENT
Percent to be used in fringe calculation for a student. CODE-ICOA-PRIORITY-RATING
Priority rating for the account as defined by the federal government. PCNT-ICOA-FED-PASS-THRU
Percentage of award which is federal pass thru. long label=Percentage of award which is federal pass thru CODE-ICOA-AGCY-RES-FED-PASS-THRU
The agency code for the federal pass through. NUMB-ICOA-RES-FED-PASS-THRU
The number for the federal pass through. CODE-ICOA-LEDG-ADM
The admin area for fund type "ledg" accounts. CODE-ICOA-UPDATE-USER-ID
Used to keep the user id of the research accountant who closed the account DATE-ICOA-ACCOUNT-EXPENSE-CLOSE
Last date that expenses (actuals) can post to an account CODE-ICOA-ARL-ADMIN-FEE
THIS CODE INDICATES THE TYPE OF FRINGE AND OVERHEAD CALCULATION TO BE DONE FOR ARL ADMIN FEES. USING THIS KEY INTO CODESET CRECOVRY, GIVES THE CREDIT/RECOVERY ACCOUNT NUMBER AND PERCENTS. LONG LABEL=ARL ADMIN FEE SHORT LABEL=ARLFEE CODESET: CARLFEE CODE-ICOA-MGMT-FEE
THIS CODE INDICATES THE TYPE OF FRINGE AND OVERHEAD CALCULATION TO BE DONE FOR MGMT FEES. USING THIS KEY INTO CODESET CRECOVRY, GIVES THE CREDIT/RECOVERY ACCOUNT NUMBER AND PERCENTS. LONG LABEL=MGMT FEE TYPE SHORT LABEL=MGMT FEE CODESET: CMGMTFEE GRUP-ICOA-COMMENT
TEXT-ICOA-COMMENT
COMMENT AREA TO HOLD FREE TEXTAREA FOR COMMENTS ABOUT A SINGLE DATE-ICOA-COMMENT-STORED
DATE THE COMMENT WAS CREATED FOR THE ACCOUNT. CODE-ICOA-COMMENT-USERID
USERID OF THE PERSON WHO ENTERED THE CORRESPONDING COMMENT. CODE-ICOA-ADMIN-AREA
THIS FIELD IS THE ADMIN AREA OF THE BUDGET/FUND COMBINATION. LONG LABEL=ADMINISTRATIVE AREA SHORT LABEL=ADMIN AREA FIELD NAME
DESCRIPTION
INDC-ICOA-BUDAUTO-RESOLUTION
Indicates whether auto resolution is to be done for Budget Startup. Long label=Budauto Auto Resolution Short label=Budauto Res INDC-ICOA-COST-SHARING
"Y" indicates cost sharing is required by sponsoring agency. CODE-ICOA-COST-SHARING-TYPE
This code indicates a type of cost sharing required by sponsoring agency. It should be completed only when the indicator cost sharing is set to "Y". Long label=code of cost sharing type CODESET: COSTSHTP INDC-ICOA-XCODE-APPLICABLE
Used to indicate x-coding does not apply to an account. KEY-ACCOUNT
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-MATCHING
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-FUND-ENDDATE
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-NAME
KEY-ACCT-CLOSED
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-ACCT-MATCHING
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-ASSN
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-ACCOUNT-TYPE
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-MATCHING-TYPE
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-FUND-ENDDATE-TYPE
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-NAME-TYPE
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-ACCT-CLOSED-TYPE
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-ACCT-MATCHING-TYPE
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-UNIV-CREAT
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-UNIV-START
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: FIELD NAME
DESCRIPTION
KEY-UNIV-DCREAT
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-FUND-TYPE-CLOSED
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS: KEY-REC-AA-FUND-CLOSED
A SUPERDESCRIPTOR CONSISTING OF THE FOLLOWING ELEMENTS:

Source: http://controller.psu.edu/sites/default/files/users/finInfoSys/datamart/COAFunds.pdf