| Data element |
Definition |
APRIL_DISTRIBUTION_AMOUNT
Indexed - no
Format - number (9,2)
May be null? yes |
Total salary payments and adjustments for the month of April.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
|
AUGUST_DISTRIBUTION_AMOUNT
Indexed - no
Format - number (9,2)
May be null? no
|
Total salary payments and adjustments for the month of August.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
BUDGET_DIST_SEQUENCE_NUMBER
Indexed - yes
Format - number (9,0)
May be null? no
|
Uniquely identifies a record in the BUDGET_DISTRIBUTION table. Rather
than Social Security Number or other key data, a sequence number is used
because there are "open positions" in the Pillar data that have been assigned
to dummy Social Security Numbers. It is not possible to guarantee uniqueness
without using a sequence number. The sequence number is generated by SQL*Loader.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
| DECEMBER_DISTRIBUTION_AMOUNT
Indexed - no
Format - number (9,2)
May be null? yes
|
Total salary payments and adjustments for the month of December.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
|
DISTRIBUTION_ACCOUNT
Indexed - yes
Format - char (9)
May be null? yes
|
For fiscal year 1998 and earlier, the 9-digit account number
(from the financial system used before July 1, 1996) indicating the source
of this Budget_Distribution for the employee. The first digit indicates
the ledger. Digits 1-6 are the account number. Digits 7-9 are the subcode.
Use of 9-digit account numbers was phased out at the end of June 1998, when
the Payroll system became fully compliant with the present General Legder
account numbers. This column should be null for all records from fiscal
year 1999 onward; in these records refer to Distribution_COA_Account to
determine the source of the budget distribution for the employee.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
DISTRIBUTION_COA_ACCOUNT
Indexed - yes
Format - char (26)
May be null? yes |
The 26-digit account number from the present General Ledger accounting
structure (in use at Penn since July 1, 1996) indicating the source of
this payroll distribution for the employee. The Payroll system was rewritten
to accept that 26-digit account code combination in place of legacy 9-digit
account numbers for fiscal year 1999. Effective June 28, 1998, all Payroll
transansactions that require an account are completed using the 26-digit
account code combination. For records prior to fiscal year 1999, this
data element contains the account number that was returned by the GL mapper
utility, given the Distribution Account. In cases where the subcode portion
of the Distribution_Account could not be translated to an Object code,
OBJT was used as the Object code.
Example: 01111011000000OBJT00000000, where OBJT indicates that there
was not an object code mapping for the requested subcode portion of the
9-digit Distribution_Account.
The Distribution_COA_Account consists of seven segments: Distribution_COA_CNAC,
Distribution_COA_Org, Distribution_COA_BC, Distribution_COA_Fund, Distribution_COA_Object,
Distribution_COA_Program, Distribution_COA_Center_Ref.
See also the definitions Distribution_COA_CNAC, Distribution_COA_Org,
Distribution_COA_BC, Distribution_COA_Fund, Distribution_COA_Object, Distribution_COA_Program,
and Distribution_COA_Center_Ref.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
DISTRIBUTION_COA_BC
Indexed - no
Format - char (1)
May be null? yes |
The budgetary control character that represents the level at which funds
availability checking occurs. Distribution_COA_BC is the third segment
of the Distribution_COA_Account.
Example: 1 (CNAC/ORG/FUND Year-To-Date)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
0 Project-To-Date for capital projects
1 CNAC/ORG/FUND Year-To-Date
2 CNAC/ORG/FUND/CREF Year-To-Date
4 CNAC/ORG/FUND/CREF Project-to-Date
|
| DISTRIBUTION_COA_CENTER_REF
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-character Center Reference Code. This is an identifier uniquely
defined by each School or Center. Distribution_Center_Ref is used to record
information that is important to a school or center but is inappropriate
for any other segment of the Budget_Distribution_Account. The value of
the Distribution_Center_Ref is unique within a school or center. Distribution_Center_Ref
is the seventh and last segment of the Budget_Distribution_Account.
Examples (for center 02): 4045 (Graduate Programs); 4091 (SAS Newsletter)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
Refer to the CENTER_REF_CODES table for values.
|
|
DISTRIBUTION_COA_CNAC
Indexed - yes
Format - char (3)
May be null? yes
|
The 3-character Center Net Asset Class code. The first two positions
of the Distribution_COA_CNAC identify the school or center. The last position
identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted);
2 (Permanently Restricted). Distribution_COA_CNAC is the first segment
of the Distribution_COA_Account.
Examples: 880 (Medical School, Unrestricted); 921 (Human Relations, Temporarily
Restricted)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
Refer to the CNAC_CODES Table for values.
|
DISTRIBUTION_COA_FUND
Indexed - yes
Format - char (6)
May be null? yes
|
The 6-character fund code. A fund segment is the unique identifier for
a specific set of financial resources that needs tracking or management.
Distribution_COA_Fund is the fourth segment of the Distribution_COA_Account.
Examples: 000000 (General Unrestricted Fund); 010201 (SAS: GEN FUND 1)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
Refer to the FUND_CODES table for values.
|
| DISTRIBUTION_COA_OBJECT
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-character Object Code that identifies the function of the money:
asset, liability, revenue, or expense. If the subcode section of the Distribution
Account cannot be translated to an Object code, OBJT will be the value
for Distribution_COA_Object. Distribution_COA_Object is the fifth segment
of the Distribution_COA_Account.
Examples: 5220 (EXTERNAL OFFICE SUPPLIES); 1149 (CASH SUSPENSE).
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
Refer to the OBJECT_CODES Table for values.
|
| DISTRIBUTION_COA_ORG
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-character Organization code. This 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 values for Distribution_COA_Org. Distribution_COA_Org
is the second segment of the Distribution_COA_Account.
Examples: 0702 (Wharton Finance); 0705 (Wharton Legal Studies)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
Refer to the ORG_CODES table for values.
|
| DISTRIBUTION_COA_PROGRAM
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-character code identifying an activity or work process commonly
defined across the University, used for tracking a program's activity
across Schools and Centers (or across organizations within a school or
center). Distribution_COA_Program is the sixth segment of the Distribution_COA_Account.
Examples: 7311 (Alumni Relations); 0001 (Discretionary)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
Refer to the PROGRAM_CODES Table for values.
|
| FEBRUARY_DISTRIBUTION_AMOUNT
Indexed - no
Format - number (9,2)
May be null? yes
|
Total salary payments and adjustments for the month of February.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
| FISCAL_YEAR
Indexed - yes
Format - char (4)
May be null? no
|
The financial year. Penn's fiscal year begins July 1 of one calendar
year and ends June 30 of the next calendar year.
Example: 1995 (fiscal year that began July 1, 1994, and ended June 30,
1995)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
| HOME_DEPT
Indexed - yes
Format - char (5)
May be null? yes
|
The 5-digit Payroll code identifying the department that owns the employee's
record and is responsible for its maintenance. Department numbers in the
Personnel/Payroll and related systems were converted to four-digit organization
codes on July 16, 1999. All records after that date will have null values
for Home_Dept; Home_Dept_Org should be used in its place.
Example: 17101 (Data Administration)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
Refer to the ORG_OLD_TO_NEW table for values.
|
| HOME_DEPT_ORG
Indexed - yes
Format - char (4)
May be null? no
|
The 4-digit number that represents the Organization that owns the employee's
record and is responsible for its maintenance. An organization is a subdivision
of the University created for management purposes. An Organization belongs
to only one School or Responsibility Center, and its organization code
is unique. (The code set is from the University's General Ledger, and
has been in use since July 1, 1996.)
Examples: 0104 (CHEMISTRY); 0001 (GEN UNIVERSITY)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
Refer to the ORG_CODES table for values.
|
| HOME_SCHOOL
Indexed - yes
Format - char (2)
May be null? yes
|
The 2-digit Payroll code used to identify the school or center that owns
the employee's record and is responsible for its maintenance. Home_School
codes in the Personnel/Payroll and related systems were converted to Home_School_Ctr
codes on July 16, 1999. All records after that date will have null values
for Home_School; Home_School_Ctr should be used in its place.
Example: 54 (School of Medicine)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
Refer to the ORG_OLD_TO_NEW table for values.
|
| HOME_SCHOOL_CTR
Indexed - yes
Format - char (2)
May be null? no
|
A 2-digit number used to identify the school or center that owns the
employee's record and is responsible for its maintenance. The code set
is from the University's General Ledger, and has been in use since July
1, 1996.
Example: 40 (School of Medicine)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
Refer to the CNAC_CODES table, for values where
Home_School_Ctr||'0' = CNAC_Code.
|
| JANUARY_DISTRIBUTION_AMOUNT
Indexed - no
Format - number (9,2)
May be null? yes
|
Total salary payments and adjustments for the month of January.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
| JOB_CLASS
Indexed - yes
Format - char (6)
May be null? no
|
The 6-digit code indicating the job to which the distribution applies.
Key to the job classification table where the job attributes are listed.
To find the Job_Title associated with the Job_Class, join to the JOB_CLASS
or JOB_CLASS_GENERAL tables using the Job_Class column. (The results of
this join may be questionable for employee records when the Termination_Date
falls before April 8, 1998.) As a result of the University's Classification
Redesign Project, a new job classification system for staff positions
was developed in 1998. Job classes in the online Payroll system and the
Data Warehouse were converted to this new system over April 8 - 9, 1998.
For jobs that were reclassified, records before this date will contain
the old class, and records after this date will reflect the new scheme.
Some classes were reused, however, and JOB_CLASS_GENERAL contains only
job titles now associated with those classes. Faculty classes were unaffected
by this conversion. (In general, faculty job classes begin with '2'.)
Example: 226010 (Associate Professor C-E)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
Refer to the JOB_CLASS table for values.
|
| JOB_DEPT
Indexed - yes
Format - char (5)
May be null? no
|
The 5-digit Payroll code identifying the department having primary responsibility
for this job appointment. Department numbers in the Personnel/Payroll
and related systems were converted to four-digit organization codes on
July 16, 1999. All records after that date will have null values for Job_Dept;
Job_Dept_Org should be used in its place.
Example: 17101 (Data Administration)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
Refer to the ORG_OLD_TO_NEW table for values.
|
| JOB_DEPT_ORG
Indexed - yes
Format - char (4)
May be null? yes
|
The 4-digit number identifying the Organization having primary responsibility
for this job appointment. An organization is a subdivision of the University
created for management purposes. An Organization belongs to only one School
or Responsibility Center, and its organization code is unique. (The code
set is from the University's General Ledger, and has been in use since
July 1, 1996.)
Examples: 0104 (CHEMISTRY); 0001 (GEN UNIVERSITY)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
Refer to the ORG_CODES table for values.
|
| JULY_DISTRIBUTION_AMOUNT
Indexed - no
Format - number (9,2)
May be null? yes
|
Total salary payments and adjustments for the month of July.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
| JUNE_DISTRIBUTION_AMOUNT
Indexed - no
Format - number (9,2)
May be null? yes
|
Total salary payments and adjustments for the month of June.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
| LAST_EXTRACT_DATE
Indexed - no
Format - date (7)
May be null? yes
|
The date the BUDGET_DISTRIBUTION record was extracted from the Pillar
system and loaded into the Warehouse. 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.)
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
| MARCH_DISTRIBUTION_AMOUNT
Indexed - no
Format - number (9,2)
May be null? yes
|
Total salary payments and adjustments for the month of March.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
| MAY_DISTRIBUTION_AMOUNT
Indexed - no
Format - number (9,2)
May be null? yes
|
Total salary payments and adjustments for the month of May.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
| NOVEMBER_DISTRIBUTION_AMOUNT
Indexed - no
Format - number (9,2)
May be null? yes
|
Total salary payments and adjustments for the month of November.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
| OCTOBER_DISTRIBUTION_AMOUNT
Indexed - no
Format - number (9,2)
May be null? yes
|
Total salary payments and adjustments for the month of October.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
| PENN_ID
Indexed - no
Format - char (8)
May be null? yes
|
The 8-digit identification number assigned to the employee by the PENNcard
system. For example: 77777777. No two persons have the same Penn_ID. Only
persons affiliated with the University will be assigned a Penn_ID. Note:
As of this writing (August, 1999), Penn_ID is not yet populated in the
BUDGET_DISTRIBUTION Table.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
| SEPTEMBER_DISTRIBUTION_AMOUNT
Indexed - no
Format - number (9,2)
May be null? yes
|
Total salary payments and adjustments for the month of September.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
| SSN
Indexed - yes
Format - char (9)
May be null? no
|
The 9-digit Social Security number of the employee. A Social Security
number is a unique number assigned to an individual by the federal Social
Security Administration.
Note: the BUDGET_DISTRIBUTION table was last loaded with fiscal year
1997 data.
Values:
List of values not available.
|
