| Data Element |
Definition |
ACCOUNTING_PERIOD
Indexed - yes
Format - char (6)
May be null? yes |
The Accounting Period stated in MON-YY format. MON is the calendar month
(stored in upper case), and YY is the calendar year. Note that the beginning
and ending dates of an ACCOUNTING_PERIOD are not the same as the first
and last day of the calendar month.
Example: JUL-96 (July 1996, which occurs in fiscal year 1997).
Values:
List of values not available.
|
| CALENDAR_MONTH
Indexed - yes
Format - char (2)
May be null? yes
|
The calendar month for the ACCOUNTING_PERIOD.
Example: 08 (the CALENDAR_MONTH for ACCOUNTING_PERIOD AUG-96).
Values:
List of values not available.
|
| CALENDAR_YEAR
Indexed - yes
Format - char (4)
May be null? yes
|
The calendar year for the ACCOUNTING_PERIOD. The calendar year begins
January 1 and ends December 31.
Example: 1996 (the CALENDAR_YEAR for ACCOUNTING_PERIOD JUL-96).
Values:
List of values not available.
|
CREATE_DATE
Indexed - no
Format - date
May be null? yes |
The date when the FUND_STATUS record was created. This information is
stored in the Warehouse in date format. In Business Objects, it is displayed
as specified in the desktop operating system settings. It is recommended
that users specify a format including 4 digits for the year. (To specify
the date format in Windows, use the Control Panel's Regional Settings,
selecting the Date tab and specifying the Short date style. On the Macintosh,
use the Date & Time Control Panel.)
Example: 8/1/1999
Values:
List of values not available.
|
FISCAL_MONTH
Indexed - yes
Format - char (2)
May be null? yes |
The month of the fiscal year for the ACCOUNTING_PERIOD.
Example: 02 (the FISCAL_MONTH for ACCOUNTING_PERIOD AUG-96)
Values:
List of values not available.
|
FISCAL_YEAR
Indexed - yes
Format - char (4)
May be null? yes |
The financial year. Penn's fiscal year begins July 1 of one calendar
year and ends June 30 of the next calendar year.
Example: 1997 (fiscal year that began July 1, 1996, and ended June 30,
1997)
Values:
List of values not available.
|
|
FUND_CODE
Indexed - yes
Format - char (6)
May be null? yes
|
The 6-character fund code. A fund is the unique identifier for a specific
set of financial resources that needs tracking or management.
FUND_CODE is the fourth segment of the Accounting Flexfield.
Example: 520139 (DERMATOLOGY FDN)
Values:
Refer to the FUND_CODES table for values.
|
|
FUND_STATUS_PK
Indexed - yes
Format - number
May be null? no
|
A sequence number used to uniquely identify a row in the FUND_STATUS
table.
Examples: 237044
Values:
List of values not available.
|
MODIFY_DATE
Indexed - no
Format - date
May be null? yes |
The date when the FUND_STATUS record was last changed. This information
is stored in the Warehouse in date format. In Business Objects, it is
displayed as specified in the desktop operating system settings. It is
recommended that users specify a format including 4 digits for the year.
(To specify the date format in Windows, use the Control Panel's Regional
Settings, selecting the Date tab and specifying the Short date style.
On the Macintosh, use the Date & Time Control Panel.)
Example: 8/1/1999
Values:
List of values not available.
|
|
ORGANIZATON_CODE
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-character code that represents the organization for which the fund
may or may not be active.
An organization is a subdivision of the University created for management
purposes. An organization belongs to only one Responsibility Center, and
its ORGANIZATION_CODE is unique. That is, no two organizations will have
the same value for ORGANIZATION_CODE.
ORGANIZATION_CODE is the second segment of the Accounting_Flexfield.
Example: 4212 (Dermatology Administration)
Values:
Refer to the ORG_CODES table for values.
|
| STATUS
Indexed - no
Format - char (1)
May be null? yes
|
The one-character code that indicates whether a sponsored project fund
is active according to BEN Financials report logic. All of the following
criteria must be satisfied for the fund to be considered inactive (indicated
by a STATUS of 'I'). If any of the following criteria are not satisfied,
the fund is considered active (indicated by a STATUS of 'A'):
1. The fund code itself is disabled or expired. (Only Research Accounting
can expire or disable a grant fund value; this is usally done 90 to 120
days after award termination.) The fund code is disabled or expired if
its ENABLED flag in the FUND_CODES table has a value of 'N'.)
2. There has been no budget, actual or encumbrance activity during the
fiscal year being reported (that is, the fiscal year associated with the
accouting period parameter for the report query). Determining this involves
an an extensive test of the BALANCES table, summing (separately) the values
of ACTUAL_PJTD, OPER_BUDGET_PJTD, and TOTAL_ENCUMBERED for each ACCOUNTING_PERIOD/COA_ORG/COA_FUND/COA_OBJECT,
where each object selected is a child of parent object K108. (This calculation,
and the comparison that follows, must proceed on an object-by-object basis.)
The previous ADJ period is determined, and then the values of ACTUAL_PJTD,
OPER_BUDGET_PJTD, and TOTAL_ENCUMBERED are summed for each corresponding
COA_ORG/COA_FUND/COA_OBJECT in the ADJ period. The two sets of sums are
compared. If any of the three buckets is not equal to its corresponding
ADJ bucket (again, for any object taken separately), there is FYTD activity,
and the fund is active.
3. The net project-to-date revenue plus expense is zero. Determining this
involves another extensive test of the BALANCES table, summing (in aggregate)
the value of ACTUAL_PJTD for the ACCOUNTING_PERIOD/COA_ORG/COA_FUND/PARENT_OBJECT,
where the parent object selected is K108. If the sum is not equal to zero,
there is PJTD activity, and the fund is active.
Examples: A (Active); I (Inactive)
Values:
A Active
I Inactive
|
