| Data element |
Definition |
BASE_SALARY
Indexed - no
Format - number (9,2)
May be null? yes |
Information not available for documentation.
Note: the BUDGET_BASE table was last loaded with fiscal year 1997 data.
Values:
List of values not available.
|
|
BUDGET_BASE_SEQUENCE_NUMBER
Indexed - yes
Format - number (9)
May be null? no
|
Uniquely identifies a record in the BUDGET_BASE 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_BASE 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_BASE 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_BASE 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_BASE 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_Center
codes on July 16, 1999. All records after that date will have null values
for Home_School; Home_School_Center should be used in its place.
Example: 54 (School of Medicine)
Note: the BUDGET_BASE table was last loaded with fiscal year 1997 data.
Values:
Refer to the ORG_OLD_TO_NEW table for values.
|
HOME_SCHOOL_CENTER
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_BASE table was last loaded with fiscal year 1997 data.
Values:
Refer to the CNAC_CODES table, for values where
Home_School_Center||'0' = CNAC_Code.
|
| LAST_EXTRACT_DATE
Indexed - no
Format - date (7)
May be null? yes
|
The date the BUDGET_BASE 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_BASE 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_BASE Table.
Note: the BUDGET_BASE 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_BASE table was last loaded with fiscal year 1997 data.
Values:
List of values not available.
|
