| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACCI_CODE
|
Account Index
|
Business Definition
Account Index is used as a short cut method to the data entry of an accounting distribution.The index links a fund, org and program code together.
Valid Values
Sample
012015
060541
200524
368417
910003
|
VARCHAR2(63)
|
|
|
|
|
ACCT_CODE
|
Account
|
Business Definition
Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer. The account defines/classifies activity within a fund.
Valid Values
Sample
12009
14004
21135
22050
22058
|
VARCHAR2(63)
|
|
|
|
|
ACCT_OVERRIDE
|
Account Override
|
Business Definition
Specifies whether the user may choose the defaulted index or override it at data entry.
Valid Values
Y
N
|
VARCHAR2(63)
|
|
|
|
|
ACCT_OVERRIDE
|
|
|
VARCHAR2(1 CHAR)
|
|
|
|
|
ACTIVITY_DATE
|
ACTIVITY DATE
|
Business DefinitionThe date that information for this record in the table was entered or last updated.
Valid values
Sample
07/01/08 12:00 AM
12/09/10 12:00 AM
08/09/13 12:00 AM
03/14/16 12:00 AM
|
DATE
|
|
|
|
|
ACTV_CODE
|
Activity
|
Business DefinitionAccounting identification code used to identify accounting data by activity. Northeastern does not currently use the activity code field.
Valid values
(null)
|
VARCHAR2(63)
|
|
|
|
|
ACTV_OVERRIDE
|
Activity Override
|
Business Definition
Specifies whether the user may choose the defaulted index or override it at data entry.
Valid Values
Y
N
|
VARCHAR2(63)
|
|
|
|
|
COAS_CODE
|
Chart Of Accounts
|
Business Definition
Identifies the chart of accounts from other charts in a multi-chart environment. The only chart of accounts currently used is N.
Valid Values
N
|
VARCHAR2(63)
|
|
|
|
|
EFF_DATE
|
EFFECTIVE DATE
|
Business Definition
The date the record is effective.
Valid Values
Sample
07/01/08 12:00 AM
12/09/10 03:35 PM
08/08/13 08:49 AM
03/11/16 03:07 PM
|
DATE
|
|
|
|
|
FUND_CODE
|
Fund
|
Business Definition
A Fund "holds" the balance or equity of a budget. Funds can be classified as Unrestricted, Designated, Endowment, Plant Funds, etc.
Valid Values
Sample
200000
420599
500408
612007
920007
|
VARCHAR2(63)
|
|
|
|
|
FUND_OVERRIDE
|
Fund Override
|
Business Definition
Specifies whether the user may choose the defaulted index or override it at data entry.
Valid Values
Y
N
|
VARCHAR2(63)
|
|
|
|
|
LOCN_CODE
|
Location
|
Business Definition
Accounting identification code of the physical location to which the item has been assigned. Northeastern does not currently use the location code field.
Valid Values
(null)
|
VARCHAR2(63)
|
|
|
|
|
LOCN_OVERRIDE
|
Location Override
|
Business Definition
Specifies whether the user may choose the defaulted index or override it at data entry. Northeastern does not currently use the location code field.
Valid Values
Y
N
|
VARCHAR2(63)
|
|
|
|
|
NCHG_DATE
|
Next Change Date
|
Business Definition
The date this record was changed, reflecting the effective date of the next record.
Valid Values
Sample
07/07/08 08:58 AM
12/10/10 01:16 PM
06/11/13 10:53 AM
03/11/16 03:07 PM
|
DATE
|
|
|
|
|
ORGN_CODE
|
Organization Code
|
Business Definition
Accounting identification code which defines a department within a division. Each university department has a unique organization code.
Valid Values
Sample
100070
1333740
149100
186570
199353
|
VARCHAR2(63)
|
|
|
|
|
ORGN_OVERRIDE
|
Organization Override
|
Business Definition
Specifies whether the user may choose the defaulted index or override it at data entry.
Valid Values
Y
N
|
VARCHAR2(63)
|
|
|
|
|
PROG_CODE
|
Program
|
Business Definition
Accounting identification code, which defines the placement of expenses and revenues into functional categories for the purpose of generating university financial statements.
Valid Values
Sample
1010
4060
5040
6010
9520
|
VARCHAR2(63)
|
|
|
|
|
PROG_OVERRIDE
|
Program Override
|
Business Definition
Specifies whether the user may choose the defaulted index or override it at data entry.
Valid Values
Y
N
|
VARCHAR2(63)
|
|
|
|
|
STATUS_IND
|
Account INDEX Status
|
Business Definition
Current status of the associated account index.
Can be A = Active or I = Inactive
Valid Values
A
I
|
VARCHAR2(63)
|
|
|
|
|
TERM_DATE
|
Termination Date
|
Business Definition
The date this record was terminated.
Valid Values
Sample
11/21/08 11:59 PM
09/30/13 11:59 PM
03/01/16 11:59 PM
12/31/20 11:59 PM
|
DATE
|
|
|
|
|
TITLE
|
Account Index description
|
Business Definition
Account index description
Valid Values
10 Coventry Street
CNSIS Management
IS Customer Services
NUGN Business
Development
|
VARCHAR2(255)
|
|
|
|
|
USER_ID
|
USER ID
|
Business Definition
The unique identification code for the user
Valid values
Sample
N000144801
N000357038
N000141566
N001798308
|
VARCHAR2(30 CHAR)
|
|
|
|