| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACCT_CODE
|
ACCOUNT CODE
|
The user-defined value representing an account.
|
VARCHAR2(6 CHAR)
|
|
|
|
|
ACTIVITY_DATE
|
ACTIVITY DATE
|
The date that information for this record in the table was entered or last updated.
|
DATE NOT NULL
|
|
|
|
|
ATYP_CODE
|
ACCOUNT TYPE CODE
|
Classifies an account type i.e., asset, liabilities, control, fund balance, revenue, and labor expenses are used for reporting purposes.
|
VARCHAR2(2 CHAR)
|
|
|
|
|
COAS_CODE
|
CHART OF ACCOUNTS CODE
|
The primary identification code for any chart of accounts that uniquely identifies that chart from any other in a multi-chart environment.
|
VARCHAR2(1 CHAR)
|
|
|
|
|
DOC_TYPE
|
DOCUMENT TYPE
|
Currently Under Review
|
NUMBER(2, 0)
|
|
|
|
|
FTYP_CODE
|
FUND TYPE CODE
|
The user-defined value assigned to level one and two fund types.
|
VARCHAR2(2 CHAR)
|
|
|
|
|
FUND_CODE
|
FUND CODE
|
Identifies the fund code that appears on a transaction.
|
VARCHAR2(6 CHAR)
|
|
|
|
|
LAST_ACTIVITY_DATE
|
LAST ACTIVITY DATE
|
The date that information for this record in the table was last entered or updated.
|
DATE
|
|
|
|
|
ORGN_CODE
|
ORGANIZATION CODE
|
Identifies the organization code that appears on a transaction.
|
VARCHAR2(6 CHAR)
|
|
|
|
|
PROG_CODE
|
PROGRAM CODE
|
The user defined value for a program.
|
VARCHAR2(6 CHAR)
|
|
|
|
|
QUEUE_ID
|
QUEUE ID
|
Currently Under Review
|
VARCHAR2(4 CHAR)
|
|
|
|
|
RULE_GROUP
|
RULE GROUP
|
A four character alphanumeric code representing a group of rules assigned to the particular rule group code in the Rule Group Maintenance Form.
|
VARCHAR2(4 CHAR)
|
|
|
|
|
USER_ID
|
USER ID
|
The unique identification code for the user.
|
VARCHAR2(30 CHAR)
|
|
|
|